dbo.users - Users

Box Inc - Enterprise Data Catalog

Documentation	CRM
Schema	dbo
Name	users
Module	Users

System users.

Columns

		Name	Data type	Attributes	References	Description	Sensitive	Information type
	1	login	nvarchar(100)			User login
User login
	2	name	nvarchar(100)			Full name	Y
Full name Sensitive: Y
	3	contact_id	int		dbo.contacts	Related person/contact. Every user needs a contact.
Related person/contact. Every user needs a contact. References: dbo.contacts
	4	password	nvarchar(100)			User encrypted password	Confidential	Credentials
User encrypted password Sensitive: Confidential Information type: Credentials
	5	email	nvarchar(100)			User email address	Confidential - GDPR	Contact Info
User email address Sensitive: Confidential - GDPR Information type: Contact Info
	6	login_failures_count	int	Default: 0		Number of login failures. Reset after 15 minutes (tracked in last_login_failure field).
Number of login failures. Reset after 15 minutes (tracked in last_login_failure field). Default: 0
	7	last_login_failure	datetime			Date and time of last login failure
Date and time of last login failure
	8	active_flag	char(1)	Default: 1		Is user active
Is user active Default: 1
	9	created_by	nvarchar(100)	Default: suser_sname()		Login of user who created row
Login of user who created row Default: suser_sname()
	10	creation_date	datetime	Default: getdate()		Row creation date time
Row creation date time Default: getdate()
	11	modified_by	nvarchar(100)	Default: suser_sname()		Login of user who last modified row
Login of user who last modified row Default: suser_sname()
	12	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.users		dbo.contacts	dbo.users.contact_id = dbo.contacts.contact_id	FK_users_contact
dbo.users.contact_id = dbo.contacts.contact_id Name: FK_users_contact

Unique keys

	Key name	Columns	Description
	PK_users_tab	login

Uses

Name
dbo.users
dbo.contacts

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