dbo.drawings - Engineering

Box Inc - Enterprise Data Catalog

Documentation	Engineering
Schema	dbo
Name	drawings
Module	Engineering

Table holds engineering and manufacturing drawings (stored a as file attachments) assigned to specific item. Those include the following:

Component drawings
Assembly drawings
Schematics

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		drawing_id	int				Drawing system identifier
Drawing system identifier
	2		item_id	int			dbo.items	Item
Item References: dbo.items
	3		drawing	image				Drawing stored as image
Drawing stored as image
	4		description	nvarchar(4000)				Comments, description of the image
Comments, description of the image
	5		date_created	datetime				Date image was uploaded
Date image was uploaded
	6		date_modified	datetime				Last modification date
Last modification date
	7		status	nvarchar(50)				Drawings can be in following statuses - W - working draft, A - active, D - deleted
Drawings can be in following statuses - W - working draft, A - active, D - deleted

Relations

Foreign table		Primary table	Join	Title / Name / Description
dbo.drawings		dbo.items	dbo.drawings.item_id = dbo.items.item_id	FK_drawings_items
dbo.drawings.item_id = dbo.items.item_id Name: FK_drawings_items

Unique keys

	Key name	Columns	Description
	PK_drawings	drawing_id

Uses

Name
dbo.drawings
dbo.items

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