app_appraisal_stage_role_setting

6 rows


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_appraisal_stage_role_setting_id_seq'::regclass)
appraisalstageid int8 19 null
app_appraisal_stage.id Defined in XMLR
appraisalrole int2 5 null
locked int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_apprstagrolesett_id_pk Primary key Asc id
app_apprstagrolesett_app_ix Performance Asc appraisalstageid
app_apprstagrolesett_appap_uix Must be unique Asc/Asc appraisalstageid + appraisalrole

Relationships