Appraisal Table Schema (appraisal)


Description

Main appraisal table

appraisal table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
appraisal_event.appraisalid appreven_app3_fk R
appraisal_grp_cohort.appraisalid apprgrpcoho_app2_fk R
appraisal_grp_org.appraisalid apprgrporg_app2_fk R
appraisal_grp_pos.appraisalid apprgrppos_app2_fk R
appraisal_history.appraisalid apprhist_app2_fk R
appraisal_review_data.appraisalscalevalueid Implied Constraint R
appraisal_stage.appraisalid apprstag_app2_fk R
appraisal_user_assignment.appraisalid appruserassi_app2_fk R
name VARCHAR 255
description LONGTEXT 2147483647 √ null
status BIT 1 0
timefinished BIGINT 19 √ null

timestamp
timestarted BIGINT 19 √ null

timestamp

Table contained -1 rows

appraisal table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
appr_nam_ix Performance Asc name
appr_sta_ix Performance Asc status
appr_tim2_ix Performance Asc timestarted
appr_tim_ix Performance Asc timefinished

appraisal table relationships

Close relationships within degrees of separation