List of Tables

Name Schema Description Modify Date Create Date
table icon a0 dbo 1/6/2012 6:13:42 AM 1/6/2012 6:13:42 AM
table icon a1 dbo 1/6/2012 7:46:05 AM 1/6/2012 7:46:05 AM
table icon a1000 dbo 12/16/2011 9:21:34 PM 12/16/2011 9:21:34 PM
table icon a1001 dbo 12/16/2011 9:26:08 PM 12/16/2011 9:26:08 PM
table icon AAA1 dbo 7/18/2011 11:59:06 PM 7/18/2011 11:59:06 PM
table icon AWBuildVersion dbo Current version number of the AdventureWorks2008 sample database. update 8/8/2010 5:22:49 PM 8/8/2010 5:21:47 PM
table icon DatabaseLog dbo Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog. update 8/8/2010 5:22:50 PM 8/8/2010 5:21:42 PM
table icon ErrorLog dbo 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. 8/8/2010 5:21:43 PM 8/8/2010 5:21:43 PM
table icon Globally_Unique_Data dbo 2/6/2011 2:50:05 PM 2/6/2011 2:50:05 PM
table icon mobiTableRule dbo 10/23/2011 8:10:54 PM 10/23/2011 8:10:30 PM
table icon PartitionTable dbo 10/26/2011 11:44:09 PM 10/26/2011 11:44:09 PM
table icon Phones dbo 8/8/2010 5:58:10 PM 8/8/2010 5:57:50 PM
table icon Records dbo mobi test comment 2/6/2011 5:22:48 PM 2/6/2011 5:22:45 PM
table icon s dbo mobi update s 9/20/2010 10:22:06 AM 9/20/2010 10:22:06 AM
table icon sysdiagrams dbo 6/20/2011 3:16:00 PM 6/20/2011 3:15:59 PM
table icon t dbo 9/20/2010 10:22:06 AM 9/20/2010 10:22:06 AM
table icon t1 dbo 4/24/2011 4:07:42 PM 4/24/2011 4:02:32 PM
table icon t10 dbo 5/7/2011 1:22:51 AM 5/7/2011 1:20:38 AM
table icon t100 dbo 1/18/2011 3:23:22 PM 1/18/2011 3:23:22 PM
table icon t200 dbo 5/20/2011 7:49:17 PM 5/20/2011 7:43:48 PM
table icon t3 dbo 11/14/2011 8:18:22 PM 11/14/2011 8:12:32 PM
table icon t300 dbo 5/20/2011 7:35:57 PM 5/20/2011 7:35:57 PM
table icon t5000 dbo 7/22/2011 7:34:57 PM 7/22/2011 7:34:57 PM
table icon t99 dbo 12/18/2011 2:04:58 PM 12/18/2011 2:04:58 PM
table icon tcolumnset dbo 2/6/2011 2:20:50 PM 2/6/2011 2:20:50 PM
table icon tcomputed dbo 2/6/2011 3:42:47 PM 2/6/2011 3:42:47 PM
table icon test_table dbo 11/28/2010 1:18:47 AM 11/28/2010 1:18:47 AM
table icon TestProduct dbo 2/8/2011 6:19:14 PM 2/8/2011 6:19:14 PM
table icon tid dbo 2/6/2011 2:37:21 PM 2/6/2011 2:37:21 PM
table icon towner dbo 1/1/2011 12:37:14 PM 1/1/2011 12:36:49 PM
table icon trowguid2 dbo 2/6/2011 3:02:50 PM 2/6/2011 3:02:50 PM
table icon tt dbo 12/22/2010 11:07:13 PM 12/22/2010 11:07:13 PM
table icon Department HumanResources Lookup table containing the departments within the Adventure Works Cycles company. 8/8/2010 5:23:39 PM 8/8/2010 5:21:47 PM
table icon Employee HumanResources Employee information such as salary, department, and title. 11/26/2011 3:07:40 PM 8/8/2010 5:21:51 PM
table icon EmployeeDepartmentHistory HumanResources Employee department transfers. 8/8/2010 5:23:39 PM 8/8/2010 5:21:51 PM
table icon EmployeePayHistory HumanResources Employee pay history. 8/8/2010 5:23:39 PM 8/8/2010 5:21:51 PM
table icon JobCandidate HumanResources Résumés submitted to Human Resources by job applicants. 8/8/2010 5:23:39 PM 8/8/2010 5:21:51 PM
table icon Shift HumanResources Work shift lookup table. 8/8/2010 5:23:39 PM 8/8/2010 5:21:53 PM
table icon Address Person Street address information for customers, employees, and vendors. 8/8/2010 5:23:41 PM 8/8/2010 5:21:47 PM
table icon AddressType Person Types of addresses stored in the Address table. 8/8/2010 5:23:38 PM 8/8/2010 5:21:47 PM
table icon BusinessEntity Person Source of the ID that connects vendors, customers, and employees with address and contact information. 8/8/2010 5:23:43 PM 8/8/2010 5:21:47 PM
table icon BusinessEntityAddress Person Cross-reference table mapping customers, vendors, and employees to their addresses. 8/8/2010 5:23:38 PM 8/8/2010 5:21:47 PM
table icon BusinessEntityContact Person Cross-reference table mapping stores, vendors, and employees to people 8/8/2010 5:23:38 PM 8/8/2010 5:21:47 PM
table icon ContactType Person Lookup table containing the types of business entity contacts. 8/8/2010 5:23:38 PM 8/8/2010 5:21:47 PM
table icon CountryRegion Person Lookup table containing the ISO standard codes for countries and regions. 8/8/2010 5:23:46 PM 8/8/2010 5:21:47 PM
table icon EmailAddress Person Where to send a person email. 8/8/2010 5:23:39 PM 8/8/2010 5:21:51 PM
table icon Password Person One way hashed authentication information 8/8/2010 5:23:39 PM 8/8/2010 5:21:51 PM
table icon Person Person Human beings involved with AdventureWorks: employees, customer contacts, and vendor contacts. - mobi czwartek 8/8/2010 5:23:44 PM 8/8/2010 5:21:51 PM
table icon PersonPhone Person Telephone number and type of a person. 8/8/2010 5:23:39 PM 8/8/2010 5:21:51 PM
table icon PhoneNumberType Person Type of phone number of a person. 8/8/2010 5:23:39 PM 8/8/2010 5:21:51 PM
table icon StateProvince Person State and province lookup table. 8/8/2010 5:23:46 PM 8/8/2010 5:21:53 PM
table icon BillOfMaterials Production Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components. 8/8/2010 5:23:38 PM 8/8/2010 5:21:47 PM
table icon Culture Production Lookup table containing the languages in which some AdventureWorks data is stored. 8/8/2010 5:23:40 PM 8/8/2010 5:21:47 PM
table icon Document Production Product maintenance documents. 8/8/2010 5:23:39 PM 8/8/2010 5:21:51 PM
table icon Illustration Production Bicycle assembly diagrams. 8/8/2010 5:23:40 PM 8/8/2010 5:21:51 PM
table icon Location Production Product inventory and manufacturing locations. 8/8/2010 5:23:43 PM 8/8/2010 5:21:51 PM
table icon Product Production Products sold or used in the manfacturing of sold products. 8/8/2010 5:23:45 PM 8/8/2010 5:21:51 PM
table icon ProductCategory Production High-level product categorization. 8/8/2010 5:23:40 PM 8/8/2010 5:21:51 PM
table icon ProductCostHistory Production Changes in the cost of a product over time. mobi update 8/8/2010 5:23:39 PM 8/8/2010 5:21:51 PM
table icon ProductDescription Production Product descriptions in several languages. 8/8/2010 5:23:45 PM 8/8/2010 5:21:51 PM
table icon ProductDocument Production Cross-reference table mapping products to related product documents. mobi 8/8/2010 5:23:39 PM 8/8/2010 5:21:51 PM
table icon ProductInventory Production Product inventory information. 8/8/2010 5:23:39 PM 8/8/2010 5:21:51 PM
table icon ProductListPriceHistory Production Changes in the list price of a product over time. 8/8/2010 5:23:40 PM 8/8/2010 5:21:51 PM
table icon ProductModel Production Product model classification. 8/8/2010 5:23:45 PM 8/8/2010 5:21:51 PM
table icon ProductModelIllustration Production Cross-reference table mapping product models and illustrations. 8/8/2010 5:23:40 PM 8/8/2010 5:21:51 PM
table icon ProductModelProductDescriptionCulture Production Cross-reference table mapping product descriptions and the language the description is written in. 8/8/2010 5:23:45 PM 8/8/2010 5:21:51 PM
table icon ProductPhoto Production Product images. 8/8/2010 5:23:40 PM 8/8/2010 5:21:51 PM
table icon ProductProductPhoto Production Cross-reference table mapping products and product photos. 8/8/2010 5:23:40 PM 8/8/2010 5:21:51 PM
table icon ProductReview Production Customer reviews of products they have purchased. 8/8/2010 5:23:40 PM 8/8/2010 5:21:51 PM
table icon ProductSubcategory Production Product subcategories. See ProductCategory table. 8/8/2010 5:23:40 PM 8/8/2010 5:21:52 PM
table icon ScrapReason Production Manufacturing failure reasons lookup table. 8/8/2010 5:23:43 PM 8/8/2010 5:21:53 PM
table icon TransactionHistory Production Record of each purchase order, sales order, or work order transaction year to date. 10/26/2011 11:51:14 PM 8/8/2010 5:21:53 PM
table icon TransactionHistoryArchive Production Transactions for previous years. 8/8/2010 5:23:15 PM 8/8/2010 5:21:54 PM
table icon UnitMeasure Production Unit of measure lookup table. 8/8/2010 5:23:40 PM 8/8/2010 5:21:54 PM
table icon WorkOrder Production Manufacturing work orders. 8/8/2010 5:23:44 PM 8/8/2010 5:21:54 PM
table icon WorkOrderRouting Production Work order details. 8/8/2010 5:23:43 PM 8/8/2010 5:21:54 PM
table icon ProductVendor Purchasing Cross-reference table mapping vendors with the products they supply. 8/8/2010 5:23:40 PM 8/8/2010 5:21:52 PM
table icon PurchaseOrderDetail Purchasing Individual products associated with a specific purchase order. See PurchaseOrderHeader. 8/8/2010 5:23:44 PM 8/8/2010 5:21:52 PM
table icon PurchaseOrderHeader Purchasing General purchase order information. See PurchaseOrderDetail. 8/8/2010 5:23:44 PM 8/8/2010 5:21:52 PM
table icon ShipMethod Purchasing Shipping company lookup table. 8/8/2010 5:23:41 PM 8/8/2010 5:21:53 PM
table icon Vendor Purchasing Companies from whom Adventure Works Cycles purchases parts or other goods. 8/8/2010 5:23:44 PM 8/8/2010 5:21:54 PM
table icon CountryRegionCurrency Sales Cross-reference table mapping ISO currency codes to a country or region. 8/8/2010 5:23:39 PM 8/8/2010 5:21:47 PM
table icon CreditCard Sales Customer credit card information. 8/8/2010 5:23:41 PM 8/8/2010 5:21:47 PM
table icon Currency Sales Lookup table containing standard ISO currencies. 8/8/2010 5:23:39 PM 8/8/2010 5:21:47 PM
table icon CurrencyRate Sales Currency exchange rates. 8/8/2010 5:23:41 PM 8/8/2010 5:21:47 PM
table icon Customer Sales Current customer information. Also see the Person and Store tables. 8/8/2010 5:23:41 PM 8/8/2010 5:21:47 PM
table icon mobiFT Sales 12/28/2011 5:28:30 PM 12/28/2011 5:26:20 PM
table icon PersonCreditCard Sales Cross-reference table mapping people to their credit card information in the CreditCard table. 8/8/2010 5:23:39 PM 8/8/2010 5:21:51 PM
table icon SalesOrderDetail Sales Individual products associated with a specific sales order. See SalesOrderHeader. 8/8/2010 5:23:44 PM 8/8/2010 5:21:52 PM
table icon SalesOrderHeader Sales General sales order information. 8/8/2010 5:23:44 PM 8/8/2010 5:21:52 PM
table icon SalesOrderHeaderSalesReason Sales Cross-reference table mapping sales orders to sales reason codes. 8/8/2010 5:23:42 PM 8/8/2010 5:21:52 PM
table icon SalesPerson Sales Sales representative current information. 8/8/2010 5:23:43 PM 8/8/2010 5:21:52 PM
table icon SalesPersonQuotaHistory Sales Sales performance tracking. 8/8/2010 5:23:43 PM 8/8/2010 5:21:52 PM
table icon SalesReason Sales Lookup table of customer purchase reasons. 8/8/2010 5:23:42 PM 8/8/2010 5:21:52 PM
table icon SalesTaxRate Sales Tax rate lookup table. 8/8/2010 5:23:43 PM 8/8/2010 5:21:52 PM
table icon SalesTerritory Sales Sales territory lookup table. 8/8/2010 5:23:43 PM 8/8/2010 5:21:53 PM
table icon SalesTerritoryHistory Sales Sales representative transfers to other sales territories. 8/8/2010 5:23:43 PM 8/8/2010 5:21:53 PM
table icon ShoppingCartItem Sales Contains online customer orders until the order is submitted or cancelled. 8/8/2010 5:23:43 PM 8/8/2010 5:21:53 PM
table icon SpecialOffer Sales Sale discounts lookup table. 8/8/2010 5:23:43 PM 8/8/2010 5:21:53 PM
table icon SpecialOfferProduct Sales Cross-reference table mapping products to special offer discounts. 8/8/2010 5:23:43 PM 8/8/2010 5:21:53 PM
table icon Store Sales Customers (resellers) of Adventure Works products. 8/8/2010 5:23:43 PM 8/8/2010 5:21:53 PM