List of tables

Tables

Name Owner Data Size KB Index Size KB Creation Date Cols Rows Description
  Address  Person  2440  2224  04/26/2006  8  19614  Street address information for customers, employees, and vendors. 
  AddressType  Person  40  8  04/26/2006  4  6  Types of addresses stored in the Address table.  
  AWBuildVersion  dbo  8  8  04/26/2006  6  1  Current version number of the AdventureWorks sample database.  
  BillOfMaterials  Production  200  160  04/26/2006  9  2679  Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components. 
  Contact  Person  1896  4536  04/26/2006  15  19972  Names of each employee, customer contact, and vendor contact. 
  ContactCreditCard  Sales  16  480  04/26/2006  3  19118  Cross-reference table mapping customers in the Contact table to their credit card information in the CreditCard table.  
  ContactType  Person  24  8  04/26/2006  3  20  Lookup table containing the types of contacts stored in Contact. 
  CountryRegion  Person  32  16  04/26/2006  3  238  Lookup table containing the ISO standard codes for countries and regions. 
  CountryRegionCurrency  Sales  24  8  04/26/2006  3  109  Cross-reference table mapping ISO currency codes to a country or region. 
  CreditCard  Sales  776  1496  04/26/2006  6  19118  Customer credit card information. 
  Culture  Production  24  8  04/26/2006  3  8  Lookup table containing the languages in which some AdventureWorks data is stored. 
  Currency  Sales  24  8  04/26/2006  3  105  Lookup table containing standard ISO currencies. 
  CurrencyRate  Sales  400  768  04/26/2006  7  13532  Currency exchange rates. 
  Customer  Sales  1176  824  04/26/2006  6  19185  Current customer information. Also see the Individual and Store tables. 
  CustomerAddress  Sales  552  864  04/26/2006  5  19220  Cross-reference table mapping customers to their address(es). 
  DatabaseLog  dbo  24  1408  04/26/2006  8  389  Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog. 
  Department  HumanResources  24  8  04/26/2006  4  16  Lookup table containing the departments within the Adventure Works Cycles company. 
  Document  Production  24  344  04/26/2006  10  9  Product maintenance documents. 
  Employee  HumanResources  120  56  04/26/2006  16  290  Employee information such as salary, department, and title. 
  EmployeeAddress  HumanResources  32  16  04/26/2006  4  290  Cross-reference table mapping employees to their address(es). 
  EmployeeDepartmentHistory  HumanResources  48  16  04/26/2006  6  296  Employee department transfers. 
  EmployeePayHistory  HumanResources  16  16  04/26/2006  5  316  Employee pay history. 
  ErrorLog  dbo  0  0  04/26/2006  9  0  Audit table tracking errors in the the AdventureWorks database that are caught by the CATCH block of a TRY...CATCH construct. Data is inserted by stored procedure dbo.uspLogError when it is executed from inside the CATCH block of a TRY...CATCH construct. 
  Illustration  Production  8  184  04/26/2006  3  5  Bicycle assembly diagrams. 
  Individual  Sales  56  24648  04/26/2006  4  18484  Demographic data about customers that purchase Adventure Works products online. 
  JobCandidate  HumanResources  32  128  04/26/2006  4  13  Résumés submitted to Human Resources by job applicants. 
  Location  Production  24  8  04/26/2006  5  14  Product inventory and manufacturing locations. 
  Product  Production  120  104  04/26/2006  25  504  Products sold or used in the manfacturing of sold products. 
  ProductCategory  Production  40  8  04/26/2006  4  4  High-level product categorization. 
  ProductCostHistory  Production  16  24  04/26/2006  5  395  Changes in the cost of a product over time. 
  ProductDescription  Production  56  144  04/26/2006  4  762  Product descriptions in several languages. 
  ProductDocument  Production  8  8  04/26/2006  3  32  Cross-reference table mapping products to related product documents. 
  ProductInventory  Production  16  56  04/26/2006  7  1069  Product inventory information. 
  ProductListPriceHistory  Production  16  24  04/26/2006  5  395  Changes in the list price of a product over time. 
  ProductModel  Production  48  144  04/26/2006  6  128  Product model classification. 
  ProductModelIllustration  Production  8  8  04/26/2006  3  7  Cross-reference table mapping product models and illustrations. 
  ProductModelProductDescriptionCulture  Production  16  32  04/26/2006  4  762  Cross-reference table mapping product descriptions and the language the description is written in. 
  ProductPhoto  Production  16  2240  04/26/2006  6  101  Product images. 
  ProductProductPhoto  Production  40  16  04/26/2006  4  504  Cross-reference table mapping products and product photos. 
  ProductReview  Production  56  16  04/26/2006  8  4  Customer reviews of products they have purchased. 
  ProductSubcategory  Production  40  8  04/26/2006  5  37  Product subcategories. See ProductCategory table. 
  ProductVendor  Purchasing  48  40  04/26/2006  11  460  Cross-reference table mapping vendors with the products they supply. 
  PurchaseOrderDetail  Purchasing  168  512  04/26/2006  11  8845  Individual products associated with a specific purchase order. See PurchaseOrderHeader. 
  PurchaseOrderHeader  Purchasing  144  336  04/26/2006  13  4012  General purchase order information. See PurchaseOrderDetail. 
  SalesOrderDetail  Sales  5144  9864  04/26/2006  11  121317  Individual products associated with a specific sales order. See SalesOrderHeader. 
  SalesOrderHeader  Sales  2384  5592  04/26/2006  27  31465  General sales order information. 
  SalesOrderHeaderSalesReason  Sales  16  688  04/26/2006  3  27647  Cross-reference table mapping sales orders to sales reason codes. 
  SalesPerson  Sales  24  8  04/26/2006  9  17  Sales representative current information. 
  SalesPersonQuotaHistory  Sales  32  16  04/26/2006  5  163  Sales performance tracking. 
  SalesReason  Sales  8  8  04/26/2006  4  10  Lookup table of customer purchase reasons. 
  SalesTaxRate  Sales  40  8  04/26/2006  7  29  Tax rate lookup table. 
  SalesTerritory  Sales  40  8  04/26/2006  10  10  Sales territory lookup table. 
  SalesTerritoryHistory  Sales  24  8  04/26/2006  6  17  Sales representative transfers to other sales territories. 
  ScrapReason  Production  24  8  04/26/2006  3  16  Manufacturing failure reasons lookup table. 
  Shift  HumanResources  40  8  04/26/2006  5  3  Work shift lookup table. 
  ShipMethod  Purchasing  40  8  04/26/2006  6  5  Shipping company lookup table. 
  ShoppingCartItem  Sales  24  8  04/26/2006  6  3  Contains online customer orders until the order is submitted or cancelled. 
  SpecialOffer  Sales  24  8  04/26/2006  11  16  Sale discounts lookup table. 
  SpecialOfferProduct  Sales  64  24  04/26/2006  4  538  Cross-reference table mapping products to special offer discounts. 
  StateProvince  Person  64  16  04/26/2006  8  181  State and province lookup table. 
  Store  Sales  80  808  04/26/2006  6  701  Customers (resellers) of Adventure Works products. 
  StoreContact  Sales  120  40  04/26/2006  5  753  Cross-reference table mapping stores and their employees. 
  TransactionHistory  Production  2992  6304  04/26/2006  9  113443  Record of each purchase order, sales order, or work order transaction year to date. 
  TransactionHistoryArchive  Production  2352  4960  04/26/2006  9  89253  Transactions for previous years. 
  UnitMeasure  Production  24  8  04/26/2006  3  38  Unit of measure lookup table. 
  Vendor  Purchasing  32  16  04/26/2006  8  104  Companies from whom Adventure Works Cycles purchases parts or other goods. 
  VendorAddress  Purchasing  24  8  04/26/2006  4  104  Cross-reference mapping vendors and addresses. 
  VendorContact  Purchasing  40  8  04/26/2006  4  156  Cross-reference table mapping vendors and their employees. 
  WorkOrder  Production  1704  4184  04/26/2006  10  72591  Manufacturing work orders. 
  WorkOrderRouting  Production  912  5544  04/26/2006  12  67131  Work order details. 
Total: 70 table(s)

See Also

Database overview