SQL Server - Adventure Works Sample Schema
Table of Contents
Installation
Datawarehouse
OLTP
Schema
Schema | Contains objects related to | Examples |
---|---|---|
HumanResources | Employees of Adventure Works Cycles. | Employee Table, Department Table |
Person | Names and addresses of individual customers, vendors, and employees. | Contact Table, Address Table, StateProvince Table |
Production | Products manufactured and sold by Adventure Works Cycles. | BillOfMaterials Table, Product Table, WorkOrder Table |
Purchasing | Vendors from who parts and products are purchased. | PurchaseOrderDetail Table, PurchaseOrderHeader Table, Vendor Table |
Sales | Customers and sales-related data. | Customer Table, SalesOrderDetail Table, SalesOrderHeader Table |