dbo.contacts - Contacts

Box Inc - Enterprise Data Catalog

Documentation	CRM
Schema	dbo
Name	contacts
Module	Contacts

List of people/contacts - customers, prospects, partners, employees.

Columns

		Name	Data type	Attributes	References	Description	Sensitive	Information type
	1	contact_id	int	Identity
Identity
	2	reference_no	nvarchar(50)
	3	employee_number	nvarchar(50)		HR.HR.EMP (Employees)
References: HR.HR.EMP (Employees)
	4	title	nvarchar(50)
	5	salutation_form	nvarchar(50)	Default: N'salutation_informal'
Default: N'salutation_informal'
	6	first_name	nvarchar(50)				Confidential - GDPR	Name
	7	last_name	nvarchar(50)				Confidential - GDPR	Name
	8	email	varchar(50)				Confidential - GDPR	Contact Info
	9	gender	varchar(15)				Y
	10	date_of_birth	date				Confidential - GDPR	Date Of Birth
	11	marital_status	varchar(50)		dbo.dictionary		Y
References: dbo.dictionary Sensitive: Y
	12	citizenship	varchar(50)		dbo.dictionary		Y
References: dbo.dictionary Sensitive: Y
	13	occupation	nvarchar(50)				Y
	14	facebook_url	nvarchar(500)				Y
	15	twitter_url	nvarchar(500)				Y
	16	linkedin_url	nvarchar(500)				Y
	17	google_url	nvarchar(500)				Y
	18	photo	varbinary(MAX)				Y
	19	row_source	nvarchar(3)	Default: N'CRM'
Default: N'CRM'
	20	deleted	bit	Default: 0
Default: 0
	21	created_by	nvarchar(100)	Default: suser_sname()		Login of user who created row
Login of user who created row Default: suser_sname()
	22	creation_date	datetime	Default: getdate()		Row creation date time
Row creation date time Default: getdate()
	23	modified_by	nvarchar(100)	Default: suser_sname()		Login of user who last modified row
Login of user who last modified row Default: suser_sname()
	24	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.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.contacts	HR.HR.EMP (Employees)	dbo.contacts.employee_number = HR.HR.EMP.EMP_NO	User-defined relation
dbo.contacts.employee_number = HR.HR.EMP.EMP_NO Name: User-defined relation
dbo.activities	dbo.contacts	dbo.activities.assigned_to_id = dbo.contacts.contact_id	FK_activities_assigned
dbo.activities.assigned_to_id = dbo.contacts.contact_id Name: FK_activities_assigned
dbo.activities	dbo.contacts	dbo.activities.owner_id = dbo.contacts.contact_id	FK_activities_owner
dbo.activities.owner_id = dbo.contacts.contact_id Name: FK_activities_owner
dbo.activity_history	dbo.contacts	dbo.activity_history.person_id = dbo.contacts.contact_id	FK_activity_history_person
dbo.activity_history.person_id = dbo.contacts.contact_id Name: FK_activity_history_person
dbo.activity_participants	dbo.contacts	dbo.activity_participants.contact_id = dbo.contacts.contact_id	FK_activity_participants_contact
dbo.activity_participants.contact_id = dbo.contacts.contact_id Name: FK_activity_participants_contact
dbo.company_roles	dbo.contacts	dbo.company_roles.contact_id = dbo.contacts.contact_id	FK_company_roles_tab_contacts_tab
dbo.company_roles.contact_id = dbo.contacts.contact_id Name: FK_company_roles_tab_contacts_tab
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	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.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_relationships	dbo.contacts	dbo.contact_relationships.contact_from_id = dbo.contacts.contact_id	FK_contact_relationships_from
dbo.contact_relationships.contact_from_id = dbo.contacts.contact_id Name: FK_contact_relationships_from
dbo.contact_relationships	dbo.contacts	dbo.contact_relationships.contact_to_id = dbo.contacts.contact_id	FK_contact_relationships_to
dbo.contact_relationships.contact_to_id = dbo.contacts.contact_id Name: FK_contact_relationships_to
dbo.sale_opportunities	dbo.contacts	dbo.sale_opportunities.contact_id = dbo.contacts.contact_id	FK_sale_opportunities_contact
dbo.sale_opportunities.contact_id = dbo.contacts.contact_id Name: FK_sale_opportunities_contact
dbo.sale_opportunities	dbo.contacts	dbo.sale_opportunities.representative_id = dbo.contacts.contact_id	FK_sale_opportunities_rep
dbo.sale_opportunities.representative_id = dbo.contacts.contact_id Name: FK_sale_opportunities_rep
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_timeline	dbo.contacts	dbo.sale_opportunities_timeline.person_id = dbo.contacts.contact_id	FK_sale_opportunities_timeline_person
dbo.sale_opportunities_timeline.person_id = dbo.contacts.contact_id Name: FK_sale_opportunities_timeline_person
dbo.users	dbo.contacts	dbo.users.contact_id = dbo.contacts.contact_id	FK_users_contact
dbo.users.contact_id = dbo.contacts.contact_id Name: FK_users_contact

Unique keys

	Key name	Columns	Description
	PK_contacts_tab	contact_id

	IX_contacts	reference_no

Uses

Name
dbo.contacts
dbo.dictionary
dbo.dictionary
HR.HR.EMP (Employees)

Used by

Name
dbo.contacts
dbo.activities
dbo.activities
dbo.activity_history
dbo.activity_participants
dbo.company_roles
dbo.complaints
dbo.complaints
dbo.contact_emails
dbo.contact_relationships
dbo.contact_relationships
dbo.sale_opportunities
dbo.sale_opportunities
dbo.sale_opportunities_history
dbo.sale_opportunities_timeline
dbo.users

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