dbo.assembly_task_boms - Engineering

Box Inc - Enterprise Data Catalog

Documentation	Engineering
Schema	dbo
Name	assembly_task_boms
Module	Engineering

Columns

		Key	Name	Data type	Null	Attributes	References	Description	Data Owner
	1		task_bom_id	int				BOM system identifier	Engeeniring team
BOM system identifier Data Owner: Engeeniring team
	2		task_id	int			dbo.assembly_tasks
References: dbo.assembly_tasks
	3		bom_id	int			dbo.bill_of_materials
References: dbo.bill_of_materials

Relations

Foreign table		Primary table	Join	Title / Name / Description
dbo.assembly_task_boms		dbo.assembly_tasks	dbo.assembly_task_boms.task_id = dbo.assembly_tasks.task_id	FK_assembly_task_boms_assembly_tasks
dbo.assembly_task_boms.task_id = dbo.assembly_tasks.task_id Name: FK_assembly_task_boms_assembly_tasks
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_assembly_task_boms	task_bom_id

Uses

Name
dbo.assembly_task_boms
dbo.assembly_tasks
dbo.bill_of_materials

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