Appraisal Review Data Table Schema (appraisal_review_data)


Description

Course, objectives, etc reviews in appraisal

appraisal_review_data table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
appraisalquestfieldid BIGINT 19 null
appraisal_quest_field.id apprrevidata_app3_fk R
appraisalscalevalueid BIGINT 19 null
appraisal.id Implied Constraint R
appraisalroleassignmentid BIGINT 19 null
appraisal_role_assignment.id apprrevidata_app4_fk R
itemid BIGINT 19 null
scope BIT 1 √ null
content LONGTEXT 2147483647 √ null

Table contained -1 rows

appraisal_review_data table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
apprrevidata_app2_ix Performance Asc appraisalroleassignmentid
apprrevidata_app_ix Performance Asc appraisalquestfieldid
apprrevidata_ite_ix Performance Asc itemid

appraisal_review_data table relationships

Close relationships within degrees of separation