Appraisal Quest Field Table Schema (appraisal_quest_field)


Description

Individual question list for appraisal page

appraisal_quest_field table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
appraisal_quest_field_role.appraisalquestfieldid apprquesfielrole_app2_fk R
appraisal_review_data.appraisalquestfieldid apprrevidata_app3_fk R
appraisal_scale_data.appraisalquestfieldid apprscaldata_app6_fk R
appraisalstagepageid BIGINT 19 null
appraisal_stage_page.id apprquesfiel_app3_fk R
name VARCHAR 255 √ null
datatype VARCHAR 255
description LONGTEXT 2147483647 √ null
descriptionformat BIT 1 √ null
sortorder BIGINT 19 null
defaultdata LONGTEXT 2147483647 √ null
defaultdataformat BIT 1 √ null
appraisalscaleid BIGINT 19 √ null
appraisal_scale.id apprquesfiel_app4_fk R
param1 LONGTEXT 2147483647 √ null
param2 LONGTEXT 2147483647 √ null
param3 LONGTEXT 2147483647 √ null
param4 LONGTEXT 2147483647 √ null
param5 LONGTEXT 2147483647 √ null

Table contained -1 rows

appraisal_quest_field table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
apprquesfiel_app2_ix Performance Asc appraisalscaleid
apprquesfiel_app_ix Performance Asc appraisalstagepageid

appraisal_quest_field table relationships

Close relationships within degrees of separation