dbo.companies - Companies

List of all comapnies tracked in CRM - customers, prospects, partners.

Columns

		Name	Data type	Attributes	References	Description	Sensitive	Information type
	1	company_id	int	Identity
Identity
	2	short	nvarchar(50)
	3	name	nvarchar(50)
	4	address	nvarchar(150)				Confidential - GDPR	Contact Info
	5	city	nvarchar(50)				Confidential - GDPR	Contact Info
	6	postcode	nvarchar(15)
	7	country	varchar(50)		dbo.dictionary
References: dbo.dictionary
	8	phone	nvarchar(50)				Confidential - GDPR	Contact Info
	9	fax	nvarchar(50)
	10	email	nvarchar(50)				Confidential - GDPR	Contact Info
	11	website	nvarchar(50)
	12	industry	varchar(50)		dbo.dictionary
References: dbo.dictionary
	13	employees	int
	14	basic_information_notes	ntext
	15	created_by	nvarchar(100)			Login of user who created row
Login of user who created row
	16	creation_date	datetime	Default: getdate()		Row creation date time
Row creation date time Default: getdate()
	17	modified_by	nvarchar(100)			Login of user who last modified row
Login of user who last modified row
	18	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.companies	dbo.dictionary	dbo.companies.country = dbo.dictionary.value	FK_companies_country
dbo.companies.country = dbo.dictionary.value Name: FK_companies_country
dbo.companies	dbo.dictionary	dbo.companies.industry = dbo.dictionary.value	FK_companies_industry
dbo.companies.industry = dbo.dictionary.value Name: FK_companies_industry
dbo.activity_participants	dbo.companies	dbo.activity_participants.company_id = dbo.companies.company_id	FK_activity_participants_company
dbo.activity_participants.company_id = dbo.companies.company_id Name: FK_activity_participants_company
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.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

Unique keys

	Key name	Columns	Description
	PK_companies_tab	company_id

Uses

Used by

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