dbo.activity_types - CRM

Box Inc - Enterprise Data Catalog

Documentation	CRM
Schema	dbo
Name	activity_types
Module	Activities

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		activity_type_id	int		Identity
Identity
	2		code	nvarchar(50)
	3		class	varchar(50)			dbo.activity_classes
References: dbo.activity_classes
	4		name	nvarchar(50)
	5		sort	int
	6		created_by	nvarchar(50)				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(50)				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.activity_types		dbo.activity_classes	dbo.activity_types.class = dbo.activity_classes.activity_class_code	FK_activity_types_class Descp
dbo.activity_types.class = dbo.activity_classes.activity_class_code Name: FK_activity_types_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

Unique keys

	Key name	Columns	Description
	PK_activity_types_tab_1	activity_type_id

Uses

Name
dbo.activity_types
dbo.activity_classes

Used by

Name
dbo.activity_types
dbo.activities

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