Appraisal Quest Field Role Table Schema (appraisal_quest_field_role)


Description

Access restrictions for each question. access - APPRAISAL_ACCESS_* constant

appraisal_quest_field_role table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
appraisalquestfieldid BIGINT 19 null
appraisal_quest_field.id apprquesfielrole_app2_fk R
appraisalrole SMALLINT 5 null
rights SMALLINT 5 null

Table contained -1 rows

appraisal_quest_field_role table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
apprquesfielrole_app_ix Performance Asc appraisalquestfieldid
apprquesfielrole_appapp_uix Must be unique Asc/Asc appraisalquestfieldid + appraisalrole

appraisal_quest_field_role table relationships

Close relationships within degrees of separation