Appraisal Stage Data Table Schema (appraisal_stage_data)


Description

Appraisal stage completion for each asiignment

appraisal_stage_data table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
appraisalroleassignmentid BIGINT 19 null
appraisal_role_assignment.id apprstagdata_app3_fk R
appraisalstageid BIGINT 19 null
appraisal_stage.id apprstagdata_app4_fk R
timecompleted BIGINT 19 null
usercompleted BIGINT 19 √ null
realusercompleted BIGINT 19 √ null

Table contained -1 rows

appraisal_stage_data table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
apprstagdata_app2_ix Performance Asc appraisalstageid
apprstagdata_app_ix Performance Asc appraisalroleassignmentid

appraisal_stage_data table relationships

Close relationships within degrees of separation