dbo.sale_opportunities_timeline - CRM

Box Inc - Enterprise Data Catalog

Documentation	CRM
Schema	dbo
Name	sale_opportunities_timeline
Module	Sale opportunities

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		opportunity_timeline_id	int		Identity
Identity
	2		opportunity_id	int			dbo.sale_opportunities
References: dbo.sale_opportunities
	3		event_type	varchar(50)
	4		event_time	datetime		Default: getdate()
Default: getdate()
	5		person_id	int			dbo.contacts
References: dbo.contacts
	6		person_name	nvarchar(100)
	7		comment	ntext
	8		created_by	nvarchar(100)				Login of user who created row
Login of user who created row
	9		created_date	datetime		Default: getdate()
Default: getdate()
	10		modified_by	nvarchar(100)				Login of user who last modified row
Login of user who last modified row
	11		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_timeline		dbo.contacts	dbo.sale_opportunities_timeline.person_id = dbo.contacts.contact_id	FK_sale_opportunities_timeline_person
dbo.sale_opportunities_timeline.person_id = dbo.contacts.contact_id Name: FK_sale_opportunities_timeline_person
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_timeline_tab	opportunity_timeline_id

Uses

Name
dbo.sale_opportunities_timeline
dbo.contacts
dbo.sale_opportunities

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