usrs

148 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
usrs_id int identity 4 √ null
acquis_usr_relns.usrs_id FK_acquis_usr_relns_usrs_idR
act_usrs.usrs_id FK_act_usrs_usrs_idR
crts.usrs_id FK_crts_usrs_idR
tasks.usrs_id FK_tasks_usrs_idR
tkn_usr_relns.usrs_id FK_tkn_usr_relns_usrs_idR
usr_grp_relns.usrs_id FK_usr_grp_relns_usrs_idR
usr_ofcs_relns.usrs_id FK_usr_ofcs_relns_usrs_idR
usr_disp_name nvarchar 400 √ null
usr_uniq_name nvarchar 1000 √ null
usr_gn nvarchar 400 √ null
usr_sn nvarchar 400 √ null
usr_cm_soc_sec_nrs_id int 4 √ null
cm_soc_sec_nrs.cm_soc_sec_nrs_id FK_usrs_cm_soc_sec_nrs_idR
usr_snr nvarchar 200 √ null
orgs_id int 4 √ null
orgs.orgs_id FK_usrs_orgs_idR
usr_img_id nvarchar 200 √ null
usr_fn nvarchar 400 √ null
usr_mn nvarchar 400 √ null
usr_dir_id nvarchar 200 ('')
usr_dir_type int 4 ((1))
usr_empl_type int 4 ((0))
usr_empl_enddate datetime 16,3 √ null
usr_mail_addr nvarchar 400 ('')
usr_mobile_nr nvarchar 200 ('')
usr_flags nvarchar 100 ('0x0000')
usr_sign_img_id nvarchar 200 √ null
ref_id int 4 √ null
usr_adnl_info nvarchar 2147483647 √ null
ofcs_id int 4 √ null
ofcs.ofcs_id FK_usrs_ofcs_idR
usr_empl_startdate datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_usrs_id Primary key Asc usrs_id

Relationships

Close relationships within degrees of separation