Appraisal User Assignment Table Schema (appraisal_user_assignment)


Description

Actual user who is subject of appraisal

appraisal_user_assignment table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
appraisal_role_assignment.appraisaluserassignmentid apprroleassi_app2_fk R
userid BIGINT 19 null
user.id appruserassi_use2_fk R
appraisalid BIGINT 19 null
appraisal.id appruserassi_app2_fk R
activestageid BIGINT 19 √ null
appraisal_stage.id appruserassi_act2_fk R
timecompleted BIGINT 19 √ null
status BIGINT 19 0
jobassignmentid BIGINT 19 √ null
job_assignment.id appruserassi_job2_fk R
jobassignmentlastmodified BIGINT 19 √ null

Table contained -1 rows

appraisal_user_assignment table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
appruserassi_act_ix Performance Asc activestageid
appruserassi_app_ix Performance Asc appraisalid
appruserassi_appuse_uix Must be unique Asc/Asc appraisalid + userid
appruserassi_job_ix Performance Asc jobassignmentid
appruserassi_use_ix Performance Asc userid

appraisal_user_assignment table relationships

Close relationships within degrees of separation