Generated using SQL Data Dictionary demo version.


Table Production.BillOfMaterials (2,679 rows)


Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components.


  Column Data Type Identity Nullable Default
PK BillOfMaterialsID int X
Primary key for BillOfMaterials records.
UK, FK ProductAssemblyID int X
Parent product identification number. Foreign key to Product.ProductID.
UK, FK ComponentID int
Component identification number. Foreign key to Product.ProductID.
UK StartDate datetime getdate()
Date the component started being used in the assembly item.
EndDate datetime X
Date the component stopped being used in the assembly item.
FK UnitMeasureCode nchar(3)
Standard code identifying the unit of measure for the quantity.
BOMLevel smallint
Indicates the depth the component is from its parent (AssemblyID).
PerAssemblyQty decimal(8,2) 1.00
Quantity of the component needed to create the assembly.
ModifiedDate datetime getdate()
Date and time the record was last updated.

Indexes:


References:


Used by: