BillOfMaterials Table (AdventureWorks)
Contains a list of all the components used to manufacture bicycles and bicycle subassemblies. ProductAssemblyID represents the parent (or primary) product and ComponentID represents child (or individual) parts that are used to build the parent assembly. For example, a wheel assembly contains components such as reflectors, rims, spokes, tires, and tire tubes.
The BillOfMaterials table is contained in the Production schema.
Primary key for BillOfMaterials rows.
Parent product identification number. Foreign key to Product.ProductID.
Component identification number. Foreign key to Product.ProductID.
Date the component started being used in the assembly item.
Date the component stopped being used in the assembly item.
Standard code identifying the unit of measure for the quantity.
Indicates the depth the component is from its parent (ProductAssemblyID).
Quantity of the component needed to create the assembly.
Date and time the row was last updated.