dbo.products - CRM

Box Inc - Enterprise Data Catalog

Documentation	CRM
Schema	dbo
Name	products

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		product_id	int		Identity
Identity
	2		reference_no	nvarchar(50)			Products.dbo.products
References: Products.dbo.products
	3		short	nvarchar(50)
	4		name	nvarchar(50)
	5		created_by	nvarchar(100)				Login of user who created row
Login of user who created row
	6		creation_date	datetime		Default: getdate()		Row creation date time
Row creation date time Default: getdate()
	7		modified_by	nvarchar(100)				Login of user who last modified row
Login of user who last modified row
	8		modification_date	datetime		Default: getdate()		Date and time of row last modification
Date and time of row last modification Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
dbo.products		Products.dbo.products	dbo.products.reference_no = Products.dbo.products.product_code	User-defined relation
dbo.products.reference_no = Products.dbo.products.product_code Name: User-defined relation
dbo.sale_opportunities_products		dbo.products	dbo.sale_opportunities_products.product_id = dbo.products.product_id	FK_sale_opportunities_products_products
dbo.sale_opportunities_products.product_id = dbo.products.product_id Name: FK_sale_opportunities_products_products

Unique keys

	Key name	Columns	Description
	PK_products_tab	product_id

	IX_products	reference_no

Uses

Name
dbo.products
Products.dbo.products

Used by

Name
dbo.products
dbo.sale_opportunities_products

Exported: 2019-02-04 23:17, Last imported: 2018-02-28 01:29