dbo.activities - Activities

Box Inc - Enterprise Data Catalog

Documentation	CRM
Schema	dbo
Name	activities
Module	Activities

List of activities for salesforce.

Columns

		Name	Data type	Attributes	References	Description	Sensitive	Information type
	1	activity_id	int	Identity		Row ID
Row ID Identity
	2	activity_no	nvarchar(15)			Unique activity reference number (visible in the UI).
Unique activity reference number (visible in the UI).
	3	title	nvarchar(150)			Title of the activity
Title of the activity
	4	class	varchar(50)		dbo.activity_classes	Activty class
Activty class References: dbo.activity_classes
	5	type_id	int		dbo.activity_types
References: dbo.activity_types
	6	email_message_code	nvarchar(100)				Confidential - GDPR	Contact Info
	7	email_thread_id	int
	8	person_id	int
	9	owner_id	int		dbo.contacts
References: dbo.contacts
	10	assigned_to_id	int		dbo.contacts
References: dbo.contacts
	11	event_date	datetime
	12	raised_date	datetime	Default: getdate()
Default: getdate()
	13	resolved_date	datetime
	14	due_date	datetime
	15	closed_date	datetime
	16	start_date	datetime
	17	end_date	datetime
	18	details	ntext
	19	location	nvarchar(500)
	20	source	varchar(50)
	21	created_by	nvarchar(100)			Login of user who created row
Login of user who created row
	22	creation_date	datetime	Default: getdate()		Row creation date time
Row creation date time Default: getdate()
	23	modified_by	nvarchar(100)			Login of user who last modified row
Login of user who last modified row
	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.activities	dbo.activity_classes	dbo.activities.class = dbo.activity_classes.activity_class_code	FK_activities_class Descp
dbo.activities.class = dbo.activity_classes.activity_class_code Name: FK_activities_class Descp
dbo.activities	dbo.activity_types	dbo.activities.type_id = dbo.activity_types.activity_type_id	FK_activities_type
dbo.activities.type_id = dbo.activity_types.activity_type_id Name: FK_activities_type
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.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.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_participants	dbo.activities	dbo.activity_participants.activity_id = dbo.activities.activity_id	FK_activity_participants_activity
dbo.activity_participants.activity_id = dbo.activities.activity_id Name: FK_activity_participants_activity
dbo.complaints_history	dbo.activities	dbo.complaints_history.activity_id = dbo.activities.activity_id	FK_complaints_history_activity
dbo.complaints_history.activity_id = dbo.activities.activity_id Name: FK_complaints_history_activity
dbo.sale_opportunities_history	dbo.activities	dbo.sale_opportunities_history.activity_id = dbo.activities.activity_id	FK_sale_opportunity_history_activity
dbo.sale_opportunities_history.activity_id = dbo.activities.activity_id Name: FK_sale_opportunity_history_activity

Unique keys

	Key name	Columns	Description
	PK_activities_tab	activity_id

	User-defined unique key	activity_no	Activity no must be unique
Activity no must be unique

Uses

Name
dbo.activities
dbo.activity_classes
dbo.activity_types
dbo.contacts
dbo.contacts

Used by

Name
dbo.activities
dbo.activity_history
dbo.activity_participants
dbo.complaints_history
dbo.sale_opportunities_history

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