dbo.sale_opportunities

Box Inc - Enterprise Data Catalog

Documentation	CRM
Schema	dbo
Name	sale_opportunities
Module	Sale opportunities

Columns

		Name	Data type	Attributes	References	Description	Sensitive	Information type
	1	opportunity_id	int	Identity
Identity
	2	reference_no	nvarchar(50)
	3	title	nvarchar(500)
	4	contact_id	int		dbo.contacts
References: dbo.contacts
	5	company_id	int		dbo.companies
References: dbo.companies
	6	account_id	int				Confidential	Credentials
	7	details	ntext
	8	representative_id	int		dbo.contacts
References: dbo.contacts
	9	branch	varchar(50)		dbo.dictionary
References: dbo.dictionary
	10	type	varchar(50)		dbo.dictionary
References: dbo.dictionary
	11	opened_date	datetime	Default: getdate()
Default: getdate()
	12	expected_close_date	date				Confidential	Credit Card
	13	closed_date	datetime
	14	status	nvarchar(50)		dbo.sale_opportunities_statuses
References: dbo.sale_opportunities_statuses
	15	value	int
	16	probability	int
	17	notes	ntext
	18	created_by	nvarchar(100)			Login of user who created row
Login of user who created row
	19	creation_date	datetime	Default: getdate()		Row creation date time
Row creation date time Default: getdate()
	20	modified_by	nvarchar(100)			Login of user who last modified row
Login of user who last modified row
	21	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.companies	dbo.sale_opportunities.company_id = dbo.companies.company_id	FK_sale_opportunities_company
dbo.sale_opportunities.company_id = dbo.companies.company_id Name: FK_sale_opportunities_company
dbo.sale_opportunities	dbo.contacts	dbo.sale_opportunities.contact_id = dbo.contacts.contact_id	FK_sale_opportunities_contact
dbo.sale_opportunities.contact_id = dbo.contacts.contact_id Name: FK_sale_opportunities_contact
dbo.sale_opportunities	dbo.contacts	dbo.sale_opportunities.representative_id = dbo.contacts.contact_id	FK_sale_opportunities_rep
dbo.sale_opportunities.representative_id = dbo.contacts.contact_id Name: FK_sale_opportunities_rep
dbo.sale_opportunities	dbo.dictionary	dbo.sale_opportunities.type = dbo.dictionary.value	FK_sale_opportunities_type
dbo.sale_opportunities.type = dbo.dictionary.value Name: FK_sale_opportunities_type
dbo.sale_opportunities	dbo.dictionary	dbo.sale_opportunities.branch = dbo.dictionary.value	FK_sale_opportunities_branch
dbo.sale_opportunities.branch = dbo.dictionary.value Name: FK_sale_opportunities_branch
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
dbo.sale_opportunities_history	dbo.sale_opportunities	dbo.sale_opportunities_history.sale_opportunity_id = dbo.sale_opportunities.opportunity_id	FK_sale_opportunities_history_sale_opportunities
dbo.sale_opportunities_history.sale_opportunity_id = dbo.sale_opportunities.opportunity_id Name: FK_sale_opportunities_history_sale_opportunities
dbo.sale_opportunities_products	dbo.sale_opportunities	dbo.sale_opportunities_products.opportunity_id = dbo.sale_opportunities.opportunity_id	FK_sale_opportunities_products_sale_opportunities
dbo.sale_opportunities_products.opportunity_id = dbo.sale_opportunities.opportunity_id Name: FK_sale_opportunities_products_sale_opportunities
dbo.sale_opportunities_timeline	dbo.sale_opportunities	dbo.sale_opportunities_timeline.opportunity_id = dbo.sale_opportunities.opportunity_id	FK_sale_opportunities_timeline_sale_opportunities
dbo.sale_opportunities_timeline.opportunity_id = dbo.sale_opportunities.opportunity_id Name: FK_sale_opportunities_timeline_sale_opportunities

Unique keys

	Key name	Columns	Description
	PK_sale_opportunities_tab	opportunity_id

	IX_sale_opportunities	reference_no

Uses

Name
dbo.sale_opportunities
dbo.companies
dbo.contacts
dbo.contacts
dbo.dictionary
dbo.dictionary
dbo.sale_opportunities_statuses

Used by

Name
dbo.sale_opportunities
dbo.sale_opportunities_history
dbo.sale_opportunities_products
dbo.sale_opportunities_timeline

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