This data is based on Microsoft's AdventureWorks database
-
Customer(CustomerID, FirstName, MiddleName, LastName, CompanyName, EmailAddress)
-
CustomerAddress(CustomerID, AddressID, AddressType)
-
Address(AddressID, AddressLine1, AddressLine2, City, StateProvince, CountyRegion, PostalCode)
-
SalesOrderHeader(SalesOrderID, RevisionNumber, OrderDate, CustomerID, BillToAddressID, ShipToAddressID, ShipMethod, SubTotal, TaxAmt, Freight)
-
SalesOrderDetail(SalesOrderID, SalesOrderDetailID, OrderQty, ProductID, UnitPrice, UnitPriceDiscount)
-
Product(ProductID, Name, Color, ListPrice, Size, Weight, ProductModelID, ProductCategoryID)
-
ProductModel(ProductModelID, Name)
-
ProductCategory(ProductCategoryID, ParentProductCategoryID, Name)
-
ProductModelProductDescription(ProductModelID, ProductDescriptionID, Culture)
-
ProductDescription(ProductDescriptionID, Description)
