app_appraisal_role_assignment

0 rows


Description

Individual user assignments by their roles

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_appraisal_role_assignment_id_seq'::regclass)
app_appraisal_review_data.appraisalroleassignmentid Defined in XMLR
app_appraisal_scale_data.appraisalroleassignmentid Defined in XMLR
app_appraisal_stage_data.appraisalroleassignmentid Defined in XMLR
appraisaluserassignmentid int8 19 null
app_appraisal_user_assignment.id Defined in XMLR
userid int8 19 null
app_user.id Defined in XMLR
appraisalrole int2 5 null
activepageid int8 19 √ null
timecreated int8 19 √ 0

Indexes

Constraint Name Type Sort Column(s)
app_apprroleassi_id_pk Primary key Asc id
app_apprroleassi_app_ix Performance Asc appraisaluserassignmentid
app_apprroleassi_appuseapp_uix Must be unique Asc/Asc/Asc appraisaluserassignmentid + userid + appraisalrole
app_apprroleassi_use_ix Performance Asc userid

Relationships

Close relationships within degrees of separation