Difference between revisions of "Template:AdventureWorks tables"

From SQLZOO
Jump to: navigation, search
Line 2: Line 2:
 
CustomerAW('''CustomerID''', FirstName, MiddleName, LastName, CompanyName, EmailAddress)
 
CustomerAW('''CustomerID''', FirstName, MiddleName, LastName, CompanyName, EmailAddress)
 
   
 
   
CustomerAddress('''CustomerID''', AddressID, '''AddressType''')
+
CustomerAddress('''<i>CustomerID</i>''', <i>AddressID</i>, '''AddressType''')
 
   
 
   
 
Address('''AddressID''', AddressLine1, AddressLine2, City, StateProvince, CountyRegion, PostalCode)
 
Address('''AddressID''', AddressLine1, AddressLine2, City, StateProvince, CountyRegion, PostalCode)

Revision as of 16:26, 2 February 2017

CustomerAW(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)

ProductAW(ProductID, Name, Color, ListPrice, Size, Weight, ProductModelID, ProductCategoryID)

ProductModel(ProductModelID, Name)

ProductCategory(ProductCategoryID, ParentProductCategoryID, Name)

ProductModelProductDescription(ProductModelID, ProductDescriptionID, Culture)

ProductDescription(ProductDescriptionID, Description)