Tables

Name	Description
dbo.AWBuildVersion	Current version number of the AdventureWorks 2012 sample database.
dbo.DatabaseLog	Audit table tracking all DDL changes made to the AdventureWorks database. Data is captured by the database trigger ddlDatabaseTriggerLog.
dbo.ErrorLog	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.
HumanResources.Department	Lookup table containing the departments within the Adventure Works Cycles company.
HumanResources.Employee	Employee information such as salary, department, and title.
HumanResources.EmployeeDepartmentHistory	Employee department transfers.
HumanResources.EmployeePayHistory	Employee pay history.
HumanResources.JobCandidate	Résumés submitted to Human Resources by job applicants.
HumanResources.Shift	Work shift lookup table.
Person.Address	Street address information for customers, employees, and vendors.
Person.AddressType	Types of addresses stored in the Address table.
Person.BusinessEntity	Source of the ID that connects vendors, customers, and employees with address and contact information.
Person.BusinessEntityAddress	Cross-reference table mapping customers, vendors, and employees to their addresses.
Person.BusinessEntityContact	Cross-reference table mapping stores, vendors, and employees to people
Person.ContactType	Lookup table containing the types of business entity contacts.
Person.CountryRegion	Lookup table containing the ISO standard codes for countries and regions.
Person.EmailAddress	Where to send a person email.
Person.Password	One way hashed authentication information
Person.Person	Human beings involved with AdventureWorks: employees, customer contacts, and vendor contacts.
Person.PersonPhone	Telephone number and type of a person.
Person.PhoneNumberType	Type of phone number of a person.
Person.StateProvince	State and province lookup table.
Production.BillOfMaterials	Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components.
Production.Culture	Lookup table containing the languages in which some AdventureWorks data is stored.
Production.Document	Product maintenance documents.
Production.Illustration	Bicycle assembly diagrams.
Production.Location	Product inventory and manufacturing locations.
Production.Product	Products sold or used in the manfacturing of sold products.
Production.ProductCategory	High-level product categorization.
Production.ProductCostHistory	Changes in the cost of a product over time.
Production.ProductDescription	Product descriptions in several languages.
Production.ProductDocument	Cross-reference table mapping products to related product documents.
Production.ProductInventory	Product inventory information.
Production.ProductListPriceHistory	Changes in the list price of a product over time.
Production.ProductModel	Product model classification.
Production.ProductModelIllustration	Cross-reference table mapping product models and illustrations.
Production.ProductModelProductDescriptionCulture	Cross-reference table mapping product descriptions and the language the description is written in.
Production.ProductPhoto	Product images.
Production.ProductProductPhoto	Cross-reference table mapping products and product photos.
Production.ProductReview	Customer reviews of products they have purchased.
Production.ProductSubcategory	Product subcategories. See ProductCategory table.
Production.ScrapReason	Manufacturing failure reasons lookup table.
Production.TransactionHistory	Record of each purchase order, sales order, or work order transaction year to date.
Production.TransactionHistoryArchive	Transactions for previous years.
Production.UnitMeasure	Unit of measure lookup table.
Production.WorkOrder	Manufacturing work orders.
Production.WorkOrderRouting	Work order details.
Purchasing.ProductVendor	Cross-reference table mapping vendors with the products they supply.
Purchasing.PurchaseOrderDetail	Individual products associated with a specific purchase order. See PurchaseOrderHeader.
Purchasing.PurchaseOrderHeader	General purchase order information. See PurchaseOrderDetail.
Purchasing.ShipMethod	Shipping company lookup table.
Purchasing.Vendor	Companies from whom Adventure Works Cycles purchases parts or other goods.
Sales.CountryRegionCurrency	Cross-reference table mapping ISO currency codes to a country or region.
Sales.CreditCard	Customer credit card information.
Sales.Currency	Lookup table containing standard ISO currencies.
Sales.CurrencyRate	Currency exchange rates.
Sales.Customer	Current customer information. Also see the Person and Store tables.
Sales.PersonCreditCard	Cross-reference table mapping people to their credit card information in the CreditCard table.
Sales.SalesOrderDetail	Individual products associated with a specific sales order. See SalesOrderHeader.
Sales.SalesOrderHeader	General sales order information.
Sales.SalesOrderHeaderSalesReason	Cross-reference table mapping sales orders to sales reason codes.
Sales.SalesPerson	Sales representative current information.
Sales.SalesPersonQuotaHistory	Sales performance tracking.
Sales.SalesReason	Lookup table of customer purchase reasons.
Sales.SalesTaxRate	Tax rate lookup table.
Sales.SalesTerritory	Sales territory lookup table.
Sales.SalesTerritoryHistory	Sales representative transfers to other sales territories.
Sales.ShoppingCartItem	Contains online customer orders until the order is submitted or cancelled.
Sales.SpecialOffer	Sale discounts lookup table.
Sales.SpecialOfferProduct	Cross-reference table mapping products to special offer discounts.
Sales.Store	Customers (resellers) of Adventure Works products.