Appraisal Stage Role Setting Table Schema (appraisal_stage_role_setting)


Description

Role access settings for each stage. appraisalrole - APPRAISAL_ROLE_* constant.

appraisal_stage_role_setting table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
appraisalstageid BIGINT 19 null
appraisal_stage.id apprstagrolesett_app2_fk R
appraisalrole SMALLINT 5 null
locked BIT 1 0

Table contained -1 rows

appraisal_stage_role_setting table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
apprstagrolesett_app_ix Performance Asc appraisalstageid
apprstagrolesett_appapp_uix Must be unique Asc/Asc appraisalstageid + appraisalrole

appraisal_stage_role_setting table relationships

Close relationships within degrees of separation