dbo.sale_opportunities_statuses - CRM

Box Inc - Enterprise Data Catalog

Documentation	CRM
Schema	dbo
Name	sale_opportunities_statuses
Module	Sale opportunities

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		status	nvarchar(50)
	2		name	nvarchar(100)
	3		sort	int
	4		is_open	bit		Default: 1
Default: 1
	5		default_probability	int
	6		created_by	nvarchar(100)				Login of user who created row
Login of user who created row
	7		creation_date	datetime		Default: getdate()		Row creation date time
Row creation date time Default: getdate()
	8		modified_by	nvarchar(100)				Login of user who last modified row
Login of user who last modified row
	9		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.sale_opportunities		dbo.sale_opportunities_statuses	dbo.sale_opportunities.status = dbo.sale_opportunities_statuses.status	FK_sale_opportunities_status
dbo.sale_opportunities.status = dbo.sale_opportunities_statuses.status Name: FK_sale_opportunities_status

Unique keys

	Key name	Columns	Description
	PK_sale_opportunities_statuses_tab	status

Used by

Name
dbo.sale_opportunities_statuses
dbo.sale_opportunities

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