dbo.contact_emails - Contacts

Columns

		Name	Data type	Attributes	References	Description	Sensitive	Information type
	1	contact_email_id	int	Identity
Identity
	2	contact_id	int		dbo.contacts
References: dbo.contacts
	3	email_no	int	Default: 1
Default: 1
	4	email	nvarchar(50)				Confidential - GDPR	Contact Info
	5	alias	nvarchar(50)
	6	email_type_code	varchar(50)		dbo.dictionary		Confidential - GDPR	Contact Info
References: dbo.dictionary Sensitive: Confidential - GDPR Information type: Contact Info
	7	deleted	bit	Default: 0
Default: 0
	8	created_by	nvarchar(100)			Login of user who created row
Login of user who created row
	9	creation_date	datetime	Default: getdate()		Row creation date time
Row creation date time 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.contact_emails	dbo.contacts	dbo.contact_emails.contact_id = dbo.contacts.contact_id	FK_contact_emails_contact
dbo.contact_emails.contact_id = dbo.contacts.contact_id Name: FK_contact_emails_contact
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

Unique keys

	Key name	Columns	Description
	PK_contact_emails_tab	contact_email_id

Uses

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