Individual customers (names and addresses) that purchase Adventure Works Cycles products online.ĭisplays the content from each education related element in the xml column Resume in the HumanResources.JobCandidate table. Vendor (company) names and the names of vendor employees to contact. Returns employee name and current and previous departments. HumanResources.vEmployeeDepartmentHistory Returns employee name, title, and current department. Sales representative transfers to other sales territories.Ĭross-reference table mapping products to related product documents.Ĭontains online customer orders until the order is submitted or cancelled.Ĭhanges in the list price of a product over time.Ĭross-reference table mapping products to special offer discounts.Ĭustomers (resellers) of Adventure Works products.Ĭross-reference table mapping product models and illustrations.ĭisplays the content from each element in the xml column Instructions for each product in the Production.ProductModel table that has manufacturing instructions. Product descriptions in several languages. Lookup table of customer purchase reasons.Ĭhanges in the cost of a product over time. Products sold or used in the manfacturing of sold products. Product inventory and manufacturing locations. Sales representative current information. Lookup table containing the languages in which some AdventureWorks data is stored.Ĭross-reference table mapping sales orders to sales reason codes. Individual products associated with a specific sales order. It identifies the heirarchical relationship between a parent product and its components. Items required to make bicycles and bicycle subassemblies. Also see the Person and Store tables.Ĭross-reference table mapping people to their credit card information in the CreditCard table. Lookup table containing standard ISO currencies.Ĭurrent customer information.

Human beings involved with AdventureWorks: employees, customer contacts, and vendor contacts. One way hashed authentication information Lookup table containing the ISO standard codes for countries and regions.Ĭompanies from whom Adventure Works Cycles purchases parts or other goods.Ĭross-reference table mapping ISO currency codes to a country or region. Lookup table containing the types of business entity contacts. See PurchaseOrderHeader.Ĭross-reference table mapping stores, vendors, and employees to people Individual products associated with a specific purchase order. Source of the ID that connects vendors, customers, and employees with address and contact information.Ĭross-reference table mapping vendors with the products they supply.Ĭross-reference table mapping customers, vendors, and employees to their addresses. Types of addresses stored in the Address table. Street address information for customers, employees, and vendors. Résumés submitted to Human Resources by job applicants. Record of each purchase order, sales order, or work order transaction year to date. Manufacturing failure reasons lookup table. Lookup table containing the departments within the Adventure Works Cycles company.Ĭustomer reviews of products they have purchased.Įmployee information such as salary, department, and title. Data is inserted by stored procedure dbo.uspLogError when it is executed from inside the CATCH block of a TRY.CATCH construct.Ĭross-reference table mapping products and product photos. Data is captured by the database trigger ddlDatabaseTriggerLog.Īudit table tracking errors in the the AdventureWorks database that are caught by the CATCH block of a TRY.CATCH construct. Production.ProductModelProductDescriptionCultureĬross-reference table mapping product descriptions and the language the description is written in.Īudit table tracking all DDL changes made to the AdventureWorks database. (Last updated on Thu, Nov 26th, 2015 at 12:25 PM)Ĭurrent version number of the AdventureWorks 2012 sample database. Generated using SQL Data Dictionary demo version.

Adventureworks sample database 2012