| AdventureWorks Database : Production Schema |
| Table | Description |
|---|---|
| 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. |
| View | Description |
|---|---|
| Production.vProductAndDescription | Product names and descriptions. Product descriptions are provided in multiple languages. |
| Production.vProductModelCatalogDescription | Displays the content from each element in the xml column CatalogDescription for each product in the Production.ProductModel table that has catalog data. |
| Production.vProductModelInstructions | Displays the content from each element in the xml column Instructions for each product in the Production.ProductModel table that has manufacturing instructions. |