dbo.dictionary - CRM

Box Inc - Enterprise Data Catalog

Documentation	CRM
Schema	dbo
Name	dictionary

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		value	varchar(50)
	2		dictionary_code	nvarchar(50)
	3		label	nvarchar(150)
	4		status	char(1)		Default: 'A'
Default: 'A'
	5		sort	int
	6		parent_value	nvarchar(50)
	7		creation_date	datetime		Default: getdate()		Row creation date time
Row creation date time Default: getdate()
	8		created_by	varchar(50)		Default: suser_sname()		Login of user who created row
Login of user who created row Default: suser_sname()
	9		modification_date	datetime		Default: getdate()		Date and time of row last modification
Date and time of row last modification Default: getdate()
	10		modified_by	varchar(50)		Default: suser_sname()		Login of user who last modified row
Login of user who last modified row Default: suser_sname()

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.contact_emails		dbo.dictionary	dbo.contact_emails.email_type_code = dbo.dictionary.value	FK_contact_emails_type
dbo.contact_emails.email_type_code = dbo.dictionary.value Name: FK_contact_emails_type
dbo.contacts		dbo.dictionary	dbo.contacts.citizenship = dbo.dictionary.value	FK_contacts_citizenship
dbo.contacts.citizenship = dbo.dictionary.value Name: FK_contacts_citizenship
dbo.contacts		dbo.dictionary	dbo.contacts.marital_status = dbo.dictionary.value	FK_contacts_marital
dbo.contacts.marital_status = dbo.dictionary.value Name: FK_contacts_marital
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.dictionary	dbo.sale_opportunities.type = dbo.dictionary.value	FK_sale_opportunities_type
dbo.sale_opportunities.type = dbo.dictionary.value Name: FK_sale_opportunities_type

Unique keys

	Key name	Columns	Description
	PK_dictionary_tab	value

Used by

Name
dbo.dictionary
dbo.companies
dbo.companies
dbo.contact_emails
dbo.contacts
dbo.contacts
dbo.sale_opportunities
dbo.sale_opportunities

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