Production.BillOfMaterials

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Production
Name	BillOfMaterials
Module	Manufacturing

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

Columns

		Name	Data type	Attributes	References	Description
	1	BillOfMaterialsID	int	Identity		Primary key for BillOfMaterials records.
Primary key for BillOfMaterials records. Identity
	2	ProductAssemblyID	int		Production.Product	Parent product identification number. Foreign key to Product.ProductID.
Parent product identification number. Foreign key to Product.ProductID. References: Production.Product
	3	ComponentID	int		Production.Product	Component identification number. Foreign key to Product.ProductID.
Component identification number. Foreign key to Product.ProductID. References: Production.Product
	4	StartDate	datetime	Default: getdate()		Date the component started being used in the assembly item.
Date the component started being used in the assembly item. Default: getdate()
	5	EndDate	datetime			Date the component stopped being used in the assembly item.
Date the component stopped being used in the assembly item.
	6	UnitMeasureCode	nchar(3)		Production.UnitMeasure	Standard code identifying the unit of measure for the quantity.
Standard code identifying the unit of measure for the quantity. References: Production.UnitMeasure
	7	BOMLevel	smallint			Indicates the depth the component is from its parent (AssemblyID).
Indicates the depth the component is from its parent (AssemblyID).
	8	PerAssemblyQty	decimal(8, 2)	Default: 1.00		Quantity of the component needed to create the assembly.
Quantity of the component needed to create the assembly. Default: 1.00
	9	ModifiedDate	datetime	Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table	Primary table	Join	Title / Name / Description
Production.BillOfMaterials	Production.Product	Production.BillOfMaterials.ComponentID = Production.Product.ProductID	FK_BillOfMaterials_Product_ComponentID Foreign key constraint referencing Product.ProductAssemblyID.
Production.BillOfMaterials.ComponentID = Production.Product.ProductID Name: FK_BillOfMaterials_Product_ComponentID Foreign key constraint referencing Product.ProductAssemblyID.
Production.BillOfMaterials	Production.Product	Production.BillOfMaterials.ProductAssemblyID = Production.Product.ProductID	FK_BillOfMaterials_Product_ProductAssemblyID Foreign key constraint referencing Product.ProductAssemblyID.
Production.BillOfMaterials.ProductAssemblyID = Production.Product.ProductID Name: FK_BillOfMaterials_Product_ProductAssemblyID Foreign key constraint referencing Product.ProductAssemblyID.
Production.BillOfMaterials	Production.UnitMeasure	Production.BillOfMaterials.UnitMeasureCode = Production.UnitMeasure.UnitMeasureCode	FK_BillOfMaterials_UnitMeasure_UnitMeasureCode Foreign key constraint referencing UnitMeasure.UnitMeasureCode.
Production.BillOfMaterials.UnitMeasureCode = Production.UnitMeasure.UnitMeasureCode Name: FK_BillOfMaterials_UnitMeasure_UnitMeasureCode Foreign key constraint referencing UnitMeasure.UnitMeasureCode.

Unique keys

	Key name	Columns	Description
	PK_BillOfMaterials_BillOfMaterialsID	BillOfMaterialsID	Primary key (clustered) constraint
Primary key (clustered) constraint
	AK_BillOfMaterials_ProductAssemblyID_ComponentID_StartDate	ProductAssemblyID, ComponentID, StartDate	Clustered index.
Clustered index.

Uses

Name
Production.BillOfMaterials
Production.Product
Production.Product
Production.UnitMeasure

Used by

Name
Production.BillOfMaterials
dbo.uspGetBillOfMaterials
dbo.uspGetWhereUsedProductID

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56