# List of Tables

| Name | Schema | Description | Modify Date | Create Date
--- | --- | --- | --- | --- | ---
| a0 | dbo |  | 1/6/2012 6:13:42 AM | 1/6/2012 6:13:42 AM
| a1 | dbo |  | 1/6/2012 7:46:05 AM | 1/6/2012 7:46:05 AM
| a1000 | dbo |  | 12/16/2011 9:21:34 PM | 12/16/2011 9:21:34 PM
| a1001 | dbo |  | 12/16/2011 9:26:08 PM | 12/16/2011 9:26:08 PM
| AAA1 | dbo |  | 7/18/2011 11:59:06 PM | 7/18/2011 11:59:06 PM
| 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
| 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
| 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
| Globally_Unique_Data | dbo |  | 2/6/2011 2:50:05 PM | 2/6/2011 2:50:05 PM
| mobiTableRule | dbo |  | 10/23/2011 8:10:54 PM | 10/23/2011 8:10:30 PM
| PartitionTable | dbo |  | 10/26/2011 11:44:09 PM | 10/26/2011 11:44:09 PM
| Phones | dbo |  | 8/8/2010 5:58:10 PM | 8/8/2010 5:57:50 PM
| Records | dbo | mobi test comment | 2/6/2011 5:22:48 PM | 2/6/2011 5:22:45 PM
| s | dbo | mobi update s | 9/20/2010 10:22:06 AM | 9/20/2010 10:22:06 AM
| sysdiagrams | dbo |  | 6/20/2011 3:16:00 PM | 6/20/2011 3:15:59 PM
| t | dbo |  | 9/20/2010 10:22:06 AM | 9/20/2010 10:22:06 AM
| t1 | dbo |  | 4/24/2011 4:07:42 PM | 4/24/2011 4:02:32 PM
| t10 | dbo |  | 5/7/2011 1:22:51 AM | 5/7/2011 1:20:38 AM
| t100 | dbo |  | 1/18/2011 3:23:22 PM | 1/18/2011 3:23:22 PM
| t200 | dbo |  | 5/20/2011 7:49:17 PM | 5/20/2011 7:43:48 PM
| t3 | dbo |  | 11/14/2011 8:18:22 PM | 11/14/2011 8:12:32 PM
| t300 | dbo |  | 5/20/2011 7:35:57 PM | 5/20/2011 7:35:57 PM
| t5000 | dbo |  | 7/22/2011 7:34:57 PM | 7/22/2011 7:34:57 PM
| t99 | dbo |  | 12/18/2011 2:04:58 PM | 12/18/2011 2:04:58 PM
| tcolumnset | dbo |  | 2/6/2011 2:20:50 PM | 2/6/2011 2:20:50 PM
| tcomputed | dbo |  | 2/6/2011 3:42:47 PM | 2/6/2011 3:42:47 PM
| test_table | dbo |  | 11/28/2010 1:18:47 AM | 11/28/2010 1:18:47 AM
| TestProduct | dbo |  | 2/8/2011 6:19:14 PM | 2/8/2011 6:19:14 PM
| tid | dbo |  | 2/6/2011 2:37:21 PM | 2/6/2011 2:37:21 PM
| towner | dbo |  | 1/1/2011 12:37:14 PM | 1/1/2011 12:36:49 PM
| trowguid2 | dbo |  | 2/6/2011 3:02:50 PM | 2/6/2011 3:02:50 PM
| tt | dbo |  | 12/22/2010 11:07:13 PM | 12/22/2010 11:07:13 PM
| 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
| Employee | HumanResources | Employee information such as salary, department, and title. | 11/26/2011 3:07:40 PM | 8/8/2010 5:21:51 PM
| EmployeeDepartmentHistory | HumanResources | Employee department transfers. | 8/8/2010 5:23:39 PM | 8/8/2010 5:21:51 PM
| EmployeePayHistory | HumanResources | Employee pay history. | 8/8/2010 5:23:39 PM | 8/8/2010 5:21:51 PM
| 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
| Shift | HumanResources | Work shift lookup table. | 8/8/2010 5:23:39 PM | 8/8/2010 5:21:53 PM
| Address | Person | Street address information for customers, employees, and vendors. | 8/8/2010 5:23:41 PM | 8/8/2010 5:21:47 PM
| AddressType | Person | Types of addresses stored in the Address table. | 8/8/2010 5:23:38 PM | 8/8/2010 5:21:47 PM
| 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
| 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
| 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
| 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
| 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
| EmailAddress | Person | Where to send a person email. | 8/8/2010 5:23:39 PM | 8/8/2010 5:21:51 PM
| Password | Person | One way hashed authentication information | 8/8/2010 5:23:39 PM | 8/8/2010 5:21:51 PM
| 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
| PersonPhone | Person | Telephone number and type of a person. | 8/8/2010 5:23:39 PM | 8/8/2010 5:21:51 PM
| PhoneNumberType | Person | Type of phone number of a person. | 8/8/2010 5:23:39 PM | 8/8/2010 5:21:51 PM
| StateProvince | Person | State and province lookup table. | 8/8/2010 5:23:46 PM | 8/8/2010 5:21:53 PM
| 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
| 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
| Document | Production | Product maintenance documents. | 8/8/2010 5:23:39 PM | 8/8/2010 5:21:51 PM
| Illustration | Production | Bicycle assembly diagrams. | 8/8/2010 5:23:40 PM | 8/8/2010 5:21:51 PM
| Location | Production | Product inventory and manufacturing locations. | 8/8/2010 5:23:43 PM | 8/8/2010 5:21:51 PM
| 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
| ProductCategory | Production | High-level product categorization. | 8/8/2010 5:23:40 PM | 8/8/2010 5:21:51 PM
| 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
| ProductDescription | Production | Product descriptions in several languages. | 8/8/2010 5:23:45 PM | 8/8/2010 5:21:51 PM
| 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
| ProductInventory | Production | Product inventory information. | 8/8/2010 5:23:39 PM | 8/8/2010 5:21:51 PM
| 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
| ProductModel | Production | Product model classification. | 8/8/2010 5:23:45 PM | 8/8/2010 5:21:51 PM
| ProductModelIllustration | Production | Cross-reference table mapping product models and illustrations. | 8/8/2010 5:23:40 PM | 8/8/2010 5:21:51 PM
| 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
| ProductPhoto | Production | Product images. | 8/8/2010 5:23:40 PM | 8/8/2010 5:21:51 PM
| ProductProductPhoto | Production | Cross-reference table mapping products and product photos. | 8/8/2010 5:23:40 PM | 8/8/2010 5:21:51 PM
| ProductReview | Production | Customer reviews of products they have purchased. | 8/8/2010 5:23:40 PM | 8/8/2010 5:21:51 PM
| ProductSubcategory | Production | Product subcategories. See ProductCategory table. | 8/8/2010 5:23:40 PM | 8/8/2010 5:21:52 PM
| ScrapReason | Production | Manufacturing failure reasons lookup table. | 8/8/2010 5:23:43 PM | 8/8/2010 5:21:53 PM
| 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
| TransactionHistoryArchive | Production | Transactions for previous years. | 8/8/2010 5:23:15 PM | 8/8/2010 5:21:54 PM
| UnitMeasure | Production | Unit of measure lookup table. | 8/8/2010 5:23:40 PM | 8/8/2010 5:21:54 PM
| WorkOrder | Production | Manufacturing work orders. | 8/8/2010 5:23:44 PM | 8/8/2010 5:21:54 PM
| WorkOrderRouting | Production | Work order details. | 8/8/2010 5:23:43 PM | 8/8/2010 5:21:54 PM
| 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
| 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
| PurchaseOrderHeader | Purchasing | General purchase order information. See PurchaseOrderDetail. | 8/8/2010 5:23:44 PM | 8/8/2010 5:21:52 PM
| ShipMethod | Purchasing | Shipping company lookup table. | 8/8/2010 5:23:41 PM | 8/8/2010 5:21:53 PM
| 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
| 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
| CreditCard | Sales | Customer credit card information. | 8/8/2010 5:23:41 PM | 8/8/2010 5:21:47 PM
| Currency | Sales | Lookup table containing standard ISO currencies. | 8/8/2010 5:23:39 PM | 8/8/2010 5:21:47 PM
| CurrencyRate | Sales | Currency exchange rates. | 8/8/2010 5:23:41 PM | 8/8/2010 5:21:47 PM
| 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
| mobiFT | Sales |  | 12/28/2011 5:28:30 PM | 12/28/2011 5:26:20 PM
| 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
| 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
| SalesOrderHeader | Sales | General sales order information. | 8/8/2010 5:23:44 PM | 8/8/2010 5:21:52 PM
| 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
| SalesPerson | Sales | Sales representative current information. | 8/8/2010 5:23:43 PM | 8/8/2010 5:21:52 PM
| SalesPersonQuotaHistory | Sales | Sales performance tracking. | 8/8/2010 5:23:43 PM | 8/8/2010 5:21:52 PM
| SalesReason | Sales | Lookup table of customer purchase reasons. | 8/8/2010 5:23:42 PM | 8/8/2010 5:21:52 PM
| SalesTaxRate | Sales | Tax rate lookup table. | 8/8/2010 5:23:43 PM | 8/8/2010 5:21:52 PM
| SalesTerritory | Sales | Sales territory lookup table. | 8/8/2010 5:23:43 PM | 8/8/2010 5:21:53 PM
| SalesTerritoryHistory | Sales | Sales representative transfers to other sales territories. | 8/8/2010 5:23:43 PM | 8/8/2010 5:21:53 PM
| 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
| SpecialOffer | Sales | Sale discounts lookup table. | 8/8/2010 5:23:43 PM | 8/8/2010 5:21:53 PM
| 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
| Store | Sales | Customers (resellers) of Adventure Works products. | 8/8/2010 5:23:43 PM | 8/8/2010 5:21:53 PM