dbo.sale_opportunities_history

Columns

		Name	Data type	Attributes	References	Description
	1	sale_opportunity_history_id	int	Identity
Identity
	2	sale_opportunity_id	int		dbo.complaints dbo.sale_opportunities
References: dbo.complaints ,dbo.sale_opportunities
	3	event_type	varchar(50)
	4	event_time	datetime
	5	activity_id	int		dbo.activities
References: dbo.activities
	6	person_id	int		dbo.contacts
References: dbo.contacts
	7	person_name	nvarchar(100)
	8	details	ntext
	9	is_visible_to_client	bit	Default: 0
Default: 0
	10	source	varchar(50)
	11	created_by	nvarchar(100)			Login of user who created row
Login of user who created row
	12	created_date	datetime	Default: getdate()
Default: getdate()
	13	modified_by	nvarchar(100)			Login of user who last modified row
Login of user who last modified row
	14	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_history	dbo.activities	dbo.sale_opportunities_history.activity_id = dbo.activities.activity_id	FK_sale_opportunity_history_activity
dbo.sale_opportunities_history.activity_id = dbo.activities.activity_id Name: FK_sale_opportunity_history_activity
dbo.sale_opportunities_history	dbo.complaints	dbo.sale_opportunities_history.sale_opportunity_id = dbo.complaints.complaint_id	FK_sale_opportunity_history_request
dbo.sale_opportunities_history.sale_opportunity_id = dbo.complaints.complaint_id Name: FK_sale_opportunity_history_request
dbo.sale_opportunities_history	dbo.contacts	dbo.sale_opportunities_history.person_id = dbo.contacts.contact_id	FK_sale_opportunity_history_person
dbo.sale_opportunities_history.person_id = dbo.contacts.contact_id Name: FK_sale_opportunity_history_person
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

Unique keys

	Key name	Columns	Description
	PK_sale_opportunities_history_tab	sale_opportunity_history_id

Uses

Name
dbo.sale_opportunities_history
dbo.activities
dbo.complaints
dbo.contacts
dbo.sale_opportunities

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