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.
0 kommentar(er)
