Appraisal Scale Data Table Schema (appraisal_scale_data)


Description

Multiple user answers

appraisal_scale_data table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
appraisalscalevalueid BIGINT 19 null
appraisal_scale_value.id apprscaldata_app4_fk R
appraisalroleassignmentid BIGINT 19 null
appraisal_role_assignment.id apprscaldata_app5_fk R
appraisalquestfieldid BIGINT 19 null
appraisal_quest_field.id apprscaldata_app6_fk R

Table contained -1 rows

appraisal_scale_data table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
apprscaldata_app2_ix Performance Asc appraisalroleassignmentid
apprscaldata_app3_ix Performance Asc appraisalquestfieldid
apprscaldata_app_ix Performance Asc appraisalscalevalueid

appraisal_scale_data table relationships

Close relationships within degrees of separation