DEPRECATED_21_02_tblUSER_PROFILE


Columns

Column Type Size Nulls Auto Default Children Parents Comments
USER_PROFILE_ID int identity 4 √ null
USER_ID uniqueidentifier 16 null
ORG_CODE varchar 5 √ null
DEPARTMENT_ID int 4 √ null
ltblUSER_DEPARTMENT.DEPARTMENT_ID FK_tblUSER_PROFILE_ltblUSER_DEPARTMENTR
FULL_NAME varchar 50 √ null
ADMIN_USER_ID int 4 √ null
ltblADMIN_USER.ADMIN_USER_ID FK_tblUSER_PROFILE_ltblADMIN_USERR
PASSWORD_RESET bit 1 √ ((0))
LAST_LOGIN_DATE datetime 16,3 √ null
ASSOCIATED_CNS int 4 √ null
ltblCNS_NAME.ID FK_tblUSER_PROFILE_ltblCNS_NAMER
eMailAddress varchar 512 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tblUSER_PROFILE Primary key Asc USER_PROFILE_ID

Relationships

Close relationships within degrees of separation