dbo.activity_history - CRM

Box Inc - Enterprise Data Catalog

Documentation	CRM
Schema	dbo
Name	activity_history
Module	Activities

History of status changes of each activity.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		activity_history_id	int		Identity
Identity
	2		activity_id	int			dbo.activities
References: dbo.activities
	3		event_type	varchar(50)
	4		event_time	datetime
	5		person_id	int			dbo.contacts
References: dbo.contacts
	6		person_name	nvarchar(100)
	7		details	ntext
	8		source	varchar(50)
	9		created_by	nvarchar(100)				Login of user who created row
Login of user who created row
	10		created_date	datetime		Default: getdate()
Default: getdate()
	11		modified_by	nvarchar(100)				Login of user who last modified row
Login of user who last modified row
	12		modifiaction_date	datetime		Default: getdate()
Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
dbo.activity_history		dbo.activities	dbo.activity_history.activity_id = dbo.activities.activity_id	FK_activity_history_activity
dbo.activity_history.activity_id = dbo.activities.activity_id Name: FK_activity_history_activity
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

Unique keys

	Key name	Columns	Description
	PK_activity_history_tab	activity_history_id

Uses

Name
dbo.activity_history
dbo.activities
dbo.contacts

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