dbo.activity_participant_roles - CRM

Box Inc - Enterprise Data Catalog

Documentation	CRM
Schema	dbo
Name	activity_participant_roles
Module	Activities

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		role_code	varchar(50)
	2		name	nvarchar(50)
	3		sort	int		Default: 99
Default: 99
	4		created_by	nvarchar(100)				Login of user who created row
Login of user who created row
	5		created_date	datetime		Default: getdate()
Default: getdate()
	6		modified_by	nvarchar(100)				Login of user who last modified row
Login of user who last modified row
	7		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.activity_participants		dbo.activity_participant_roles	dbo.activity_participants.role_code = dbo.activity_participant_roles.role_code	FK_activity_participants_role
dbo.activity_participants.role_code = dbo.activity_participant_roles.role_code Name: FK_activity_participants_role

Unique keys

	Key name	Columns	Description
	PK_activity_participant_roles_tab	role_code

Used by

Name
dbo.activity_participant_roles
dbo.activity_participants

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