dbo.products - Products

Box Inc - Enterprise Data Catalog

Documentation	Products
Schema	dbo
Name	products
Module	Products

This table keeps all the products and materials boutght and sold by the company:

Company products
Parts / components
Raw materials

Component hierarchy is represented by components table.

Columns

		Name	Data type	Attributes	References	Description
	1	product_id	int	Identity		Product unique internal database ID
Product unique internal database ID Identity
	2	product_code	nvarchar(15)			Product manufacturing ID
Product manufacturing ID
	3	sku	nvarchar(50)			Stock keeping unit, public product invemtory ID
Stock keeping unit, public product invemtory ID
	4	product_name	nvarchar(150)			Product name
Product name
	5	product_category_id	int		dbo.product_categories	Product category
Product category References: dbo.product_categories
	6	manager_no	int		HR.HR.EMP (Employees)	Manager employee no
Manager employee no References: HR.HR.EMP (Employees)
	7	color	nvarchar(50)		dbo.dictionary	Color (dictionary)
Color (dictionary) References: dbo.dictionary
	8	mfg_cost	float			Manufactuiring cost in USD
Manufactuiring cost in USD
	9	market_id	int		dbo.markets	Key market
Key market References: dbo.markets
	10	segment_id	int		dbo.segments	Product segment
Product segment References: dbo.segments
	11	release_date	date			Product market releas date (actual or planned)
Product market releas date (actual or planned)
	12	end_of_support	date			Planned end of product support
Planned end of product support

Relations

Foreign table	Primary table	Join	Title / Name / Description
dbo.products	dbo.dictionary	dbo.products.color = dbo.dictionary.val	Color User-defined relation Where dictionary = 'COLOR'
dbo.products.color = dbo.dictionary.val Title: Color Name: User-defined relation Where dictionary = 'COLOR'
dbo.products	HR.HR.EMP (Employees)	dbo.products.manager_no = HR.HR.EMP.EMP_NO	Manager User-defined relation
dbo.products.manager_no = HR.HR.EMP.EMP_NO Title: Manager Name: User-defined relation
dbo.products	dbo.markets	dbo.products.market_id = dbo.markets.market_id	FK_products_markets
dbo.products.market_id = dbo.markets.market_id Name: FK_products_markets
dbo.products	dbo.product_categories	dbo.products.product_category_id = dbo.product_categories.product_category_id	FK_products_product_categories
dbo.products.product_category_id = dbo.product_categories.product_category_id Name: FK_products_product_categories
dbo.products	dbo.segments	dbo.products.segment_id = dbo.segments.segment_id	FK_products_segments
dbo.products.segment_id = dbo.segments.segment_id Name: FK_products_segments
Engineering.dbo.items	dbo.products	Engineering.dbo.items.product_code = dbo.products.code	User-defined relation
Engineering.dbo.items.product_code = dbo.products.code Name: User-defined relation
Inventory.inv.items	dbo.products	Inventory.inv.items.sku = dbo.products.sku	User-defined relation
Inventory.inv.items.sku = dbo.products.sku Name: User-defined relation
dbo.prices	dbo.products	dbo.prices.product_id = dbo.products.product_id	User-defined relation
dbo.prices.product_id = dbo.products.product_id Name: User-defined relation
CRM.dbo.products	dbo.products	CRM.dbo.products.product_code = dbo.products.reference_no	User-defined relation
CRM.dbo.products.product_code = dbo.products.reference_no Name: User-defined relation

Unique keys

	Key name	Columns	Description
	PK_products	product_id

	User-defined unique key	sku

	User-defined unique key	product_code

Uses

Name
dbo.products
dbo.dictionary (Color)
dbo.markets
dbo.product_categories
dbo.segments
HR.HR.EMP (Employees) (Manager)

Used by

Name
dbo.products
CRM.dbo.products
dbo.prices
Engineering.dbo.items
Inventory.inv.items

Exported: 2019-02-04 23:17, Last imported: 2018-04-10 17:07