Appraisal Role Assignment Table Schema (appraisal_role_assignment)


Description

Individual user assignments by their roles

appraisal_role_assignment table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
appraisal_review_data.appraisalroleassignmentid apprrevidata_app4_fk R
appraisal_scale_data.appraisalroleassignmentid apprscaldata_app5_fk R
appraisal_stage_data.appraisalroleassignmentid apprstagdata_app3_fk R
appraisaluserassignmentid BIGINT 19 null
appraisal_user_assignment.id apprroleassi_app2_fk R
userid BIGINT 19 null
user.id apprroleassi_use2_fk R
appraisalrole SMALLINT 5 null
activepageid BIGINT 19 √ null
timecreated BIGINT 19 √ 0

Table contained -1 rows

appraisal_role_assignment table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
apprroleassi_app_ix Performance Asc appraisaluserassignmentid
apprroleassi_appuseapp_uix Must be unique Asc/Asc/Asc appraisaluserassignmentid + userid + appraisalrole
apprroleassi_use_ix Performance Asc userid

appraisal_role_assignment table relationships

Close relationships within degrees of separation