app_appraisal_user_assignment

0 rows


Description

Actual user who is subject of appraisal

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_appraisal_user_assignment_id_seq'::regclass)
app_appraisal_role_assignment.appraisaluserassignmentid Defined in XMLR
userid int8 19 null
app_user.id Defined in XMLR
appraisalid int8 19 null
app_appraisal.id Defined in XMLR
activestageid int8 19 √ null
app_appraisal_stage.id Defined in XMLR
timecompleted int8 19 √ null
status int8 19 0
jobassignmentid int8 19 √ null
app_job_assignment.id Defined in XMLR
jobassignmentlastmodified int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
app_appruserassi_id_pk Primary key Asc id
app_appruserassi_act_ix Performance Asc activestageid
app_appruserassi_app_ix Performance Asc appraisalid
app_appruserassi_appuse_uix Must be unique Asc/Asc appraisalid + userid
app_appruserassi_job_ix Performance Asc jobassignmentid
app_appruserassi_use_ix Performance Asc userid

Relationships

Close relationships within degrees of separation