dbo.bill_of_materials - Engineering

Box Inc - Enterprise Data Catalog

Documentation	Engineering
Schema	dbo
Name	bill_of_materials
Module	Engineering

Bill of materials (BOM) table holds information about all item parts and their quantity.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		bom_id	int				BOM system identifier
BOM system identifier
	2		parent_item_id	int			dbo.items	Item that this BOM specifies
Item that this BOM specifies References: dbo.items
	3		part_item_id	int			dbo.items	Part item
Part item References: dbo.items
	4		item_no	int				Part item order within BOM
Part item order within BOM
	5		quantity	numeric(18, 0)				Part item quantity
Part item quantity

Relations

Foreign table		Primary table	Join	Title / Name / Description
dbo.bill_of_materials		dbo.items	dbo.bill_of_materials.parent_item_id = dbo.items.item_id	Parent FK_bill_of_materials_parent
dbo.bill_of_materials.parent_item_id = dbo.items.item_id Title: Parent Name: FK_bill_of_materials_parent
dbo.bill_of_materials		dbo.items	dbo.bill_of_materials.part_item_id = dbo.items.item_id	Part FK_bill_of_materials_part
dbo.bill_of_materials.part_item_id = dbo.items.item_id Title: Part Name: FK_bill_of_materials_part
dbo.assembly_task_boms		dbo.bill_of_materials	dbo.assembly_task_boms.bom_id = dbo.bill_of_materials.bom_id	FK_assembly_task_boms_bill_of_materials
dbo.assembly_task_boms.bom_id = dbo.bill_of_materials.bom_id Name: FK_assembly_task_boms_bill_of_materials

Unique keys

	Key name	Columns	Description
	PK_bill_of_materials	bom_id

	UK_bill_of_materials_no	bom_id, item_no

Uses

Name
dbo.bill_of_materials
dbo.items (Parent)
dbo.items (Part)

Used by

Name
dbo.bill_of_materials
dbo.assembly_task_boms

Exported: 2019-02-04 23:17, Last imported: 2018-03-22 17:01