dbo.user_role_types - Users - CRM

Box Inc - Enterprise Data Catalog

Documentation	CRM
Schema	dbo
Name	user_role_types
Module	Users

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		user_role	nvarchar(50)
	2		name	nvarchar(200)
	3		creation_date	datetime		Default: getdate()		Row creation date time
Row creation date time Default: getdate()
	4		created_by	nvarchar(100)		Default: suser_sname()		Login of user who created row
Login of user who created row Default: suser_sname()
	5		modification_date	datetime		Default: getdate()		Date and time of row last modification
Date and time of row last modification Default: getdate()
	6		modified_by	nvarchar(100)		Default: suser_sname()		Login of user who last modified row
Login of user who last modified row Default: suser_sname()

Relations

Foreign table		Primary table	Join	Title / Name / Description
dbo.user_roles		dbo.user_role_types	dbo.user_roles.user_role = dbo.user_role_types.user_role	FK_user_roles_tab_user_role_types_tab
dbo.user_roles.user_role = dbo.user_role_types.user_role Name: FK_user_roles_tab_user_role_types_tab

Unique keys

	Key name	Columns	Description
	PK_user_role_types_tab	user_role

Used by

Name
dbo.user_role_types
dbo.user_roles

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