dbo.complaints

Columns

		Name	Data type	Attributes	References	Description
	1	complaint_id	int	Identity
Identity
	2	reference_no	nvarchar(50)
	3	contact_id	int		dbo.contacts
References: dbo.contacts
	4	company_id	int		dbo.companies
References: dbo.companies
	5	raised_date	datetime	Default: getdate()
Default: getdate()
	6	source	nvarchar(50)
	7	assigned_to_id	int		dbo.contacts
References: dbo.contacts
	8	status	nvarchar(50)	Default: 'OPEN'	dbo.complaints_statuses
Default: 'OPEN' References: dbo.complaints_statuses
	9	details	text
	10	resolved_date	date
	11	closed_date	date
	12	rating	int
	13	created_by	nvarchar(100)			Login of user who created row
Login of user who created row
	14	creation_date	datetime	Default: getdate()		Row creation date time
Row creation date time Default: getdate()
	15	modified_by	nvarchar(100)			Login of user who last modified row
Login of user who last modified row
	16	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.complaints	dbo.companies	dbo.complaints.company_id = dbo.companies.company_id	FK_complaints_company
dbo.complaints.company_id = dbo.companies.company_id Name: FK_complaints_company
dbo.complaints	dbo.complaints_statuses	dbo.complaints.status = dbo.complaints_statuses.status	FK_complaints_status
dbo.complaints.status = dbo.complaints_statuses.status Name: FK_complaints_status
dbo.complaints	dbo.contacts	dbo.complaints.contact_id = dbo.contacts.contact_id	FK_complaints_contact
dbo.complaints.contact_id = dbo.contacts.contact_id Name: FK_complaints_contact
dbo.complaints	dbo.contacts	dbo.complaints.assigned_to_id = dbo.contacts.contact_id	FK_complaints_assigned
dbo.complaints.assigned_to_id = dbo.contacts.contact_id Name: FK_complaints_assigned
dbo.complaints_history	dbo.complaints	dbo.complaints_history.complaint_id = dbo.complaints.complaint_id	FK_complaints_history_request
dbo.complaints_history.complaint_id = dbo.complaints.complaint_id Name: FK_complaints_history_request
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

Unique keys

	Key name	Columns	Description
	PK_complaints	complaint_id

Uses

Used by

Name
dbo.complaints
dbo.complaints_history
dbo.sale_opportunities_history

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