The content has been localized into French, Simplified Chinese and Thai. Individual customers (names and addresses) that purchase Adventure Works Cycles products online.ĭisplays the content from each element in the xml column Demographics for each customer in the Sales.Individual table.ĭisplays the content from each education related element in the xml column Resume in the HumanResources.JobCandidate table. Returns employee name and current and previous departments. Returns employee name, title, and current department. Record of each purchase order, sales order, or work order transaction year to date.Ĭompanies from whom Adventure Works Cycles purchases parts or other goods.Ĭross-reference mapping vendors and addresses.Ĭross-reference table mapping vendors and their employees.ĭisplays the contact name and content from each element in the xml column AdditionalContactInfo for that person. Manufacturing failure reasons lookup table.Ĭontains online customer orders until the order is submitted or cancelled.Ĭross-reference table mapping products to special offer discounts.Ĭustomers (resellers) of Adventure Works products.Ĭross-reference table mapping stores and their employees. Sales representative transfers to other sales territories. Lookup table of customer purchase reasons. Sales representative current information. See SalesOrderHeader.Ĭross-reference table mapping sales orders to sales reason codes. Individual products associated with a specific sales order. Individual products associated with a specific purchase order. See ProductCategory table.Ĭross-reference table mapping vendors with the products they supply. Product descriptions in several languages.Ĭross-reference table mapping products to related product documents.Ĭhanges in the list price of a product over time.Ĭross-reference table mapping product models and illustrations.Ĭross-reference table mapping product descriptions and the language the description is written in.Ĭross-reference table mapping products and product photos.Ĭustomer reviews of products they have purchased. Products sold or used in the manfacturing of sold products.Ĭhanges in the cost of a product over time. Product inventory and manufacturing locations. Résumés submitted to Human Resources by job applicants.
Data is inserted by stored procedure dbo.uspLogError when it is executed from inside the CATCH block of a TRY.CATCH construct.ĭemographic data about customers that purchase Adventure Works products online. Lookup table containing the departments within the Adventure Works Cycles company.Įmployee information such as salary, department, and title.Ĭross-reference table mapping employees to their address(es).Īudit table tracking errors in the the AdventureWorks database that are caught by the CATCH block of a TRY.CATCH construct.
Data is captured by the database trigger ddlDatabaseTriggerLog. Also see the Individual and Store tables.Ĭross-reference table mapping customers to their address(es).Īudit table tracking all DDL changes made to the AdventureWorks database.
#Adventureworks2012 oltp database iso
Lookup table containing standard ISO currencies.Ĭurrent customer information. Lookup table containing the languages in which some AdventureWorks data is stored. Lookup table containing the ISO standard codes for countries and regions.Ĭross-reference table mapping ISO currency codes to a country or region. Lookup table containing the types of contacts stored in Contact. Names of each employee, customer contact, and vendor contact.Ĭross-reference table mapping customers in the Contact table to their credit card information in the CreditCard table. It identifies the heirarchical relationship between a parent product and its components. Items required to make bicycles and bicycle subassemblies. Types of addresses stored in the Address table.Ĭurrent version number of the AdventureWorks sample database. Street address information for customers, employees, and vendors. C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdfĭata Space in Use and Reserved for Use, KB:Ĭ:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\AdventureWorks_Data.mdfĬ:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\AdventureWorks_Log.ldf
0 kommentar(er)
