AdventureWorks Data Base ER diagram

This ER diagram shows the main entities and foreign key relationships for the AdventureWorks database.

AdventureWorks Database ERD Entity relationship diagram for the simplified AdventureWorks schema used in SQLTest, with ten tables and explicit foreign keys. Address PKAddressID AddressLine1, AddressLine2 City, StateProvince CountryRegion, PostalCode rowguid, ModifiedDate Customer PKCustomerID NameStyle, Title FirstName, MiddleName, LastName CompanyName, SalesPerson EmailAddress, Phone PasswordHash, PasswordSalt rowguid, ModifiedDate ProductCategory PKProductCategoryID FKParentProductCategoryID Name rowguid ModifiedDate ProductModel PKProductModelID Name CatalogDescription rowguid, ModifiedDate ProductDescription PKProductDescriptionID Description rowguid, ModifiedDate Product PKProductID FKProductCategoryID -> ProductCategory FKProductModelID -> ProductModel Name, ProductNumber, Color StandardCost, ListPrice Size, Weight SellStartDate, SellEndDate DiscontinuedDate, ModifiedDate CustomerAddress PKFKCustomerID -> Customer PKFKAddressID -> Address AddressType rowguid, ModifiedDate ProductModelProductDescription PKFKProductModelID PKFKProductDescriptionID Culture rowguid, ModifiedDate SalesOrderHeader PKSalesOrderID FKCustomerID -> Customer FKShipToAddressID -> Address FKBillToAddressID -> Address OrderDate, DueDate, ShipDate Status, SalesOrderNumber SubTotal, TaxAmt, Freight TotalDue, rowguid, ModifiedDate SalesOrderDetail PKFKSalesOrderID -> SalesOrderHeader PKSalesOrderDetailID PKFKProductID -> Product OrderQty, UnitPrice UnitPriceDiscount, LineTotal rowguid, ModifiedDate Legend PKPrimary key FKForeign key Child table points to parent table Diagram reflects simplified schema used in this SQLTest AdventureWorks page including explicit FK list sections N:1 N:1 N:1 N:1 N:1 N:1 N:1 N:1 N:1 N:1 N:1 N:1