dbo.contact_relationships - Contacts - CRM

Box Inc - Enterprise Data Catalog

Documentation	CRM
Schema	dbo
Name	contact_relationships
Module	Contacts

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		contact_relationship_id	int		Identity
Identity
	2		contact_from_id	int			dbo.contacts
References: dbo.contacts
	3		contact_to_id	int			dbo.contacts
References: dbo.contacts
	4		relationship_type_code	nvarchar(50)			dbo.contact_relationships_types
References: dbo.contact_relationships_types
	5		deleted	bit		Default: 0
Default: 0
	6		created_by	nvarchar(100)				Login of user who created row
Login of user who created row
	7		creation_date	datetime		Default: getdate()		Row creation date time
Row creation date time Default: getdate()
	8		modified_by	nvarchar(100)				Login of user who last modified row
Login of user who last modified row
	9		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_relationships		dbo.contact_relationships_types	dbo.contact_relationships.relationship_type_code = dbo.contact_relationships_types.relationship_type_code	FK_contact_relationships_type
dbo.contact_relationships.relationship_type_code = dbo.contact_relationships_types.relationship_type_code Name: FK_contact_relationships_type
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

Unique keys

	Key name	Columns	Description
	PK_contact_relationships_tab	contact_relationship_id

Uses

Name
dbo.contact_relationships
dbo.contact_relationships_types
dbo.contacts
dbo.contacts

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