Appraisal Stage Table Schema (appraisal_stage)


Description

Stages within appraisal

appraisal_stage table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
appraisal_event.appraisalstageid appreven_app4_fk R
appraisal_stage_data.appraisalstageid apprstagdata_app4_fk R
appraisal_stage_page.appraisalstageid apprstagpage_app2_fk R
appraisal_stage_role_setting.appraisalstageid apprstagrolesett_app2_fk R
appraisal_user_assignment.activestageid appruserassi_act2_fk R
appraisalid BIGINT 19 null
appraisal.id apprstag_app2_fk R
name VARCHAR 255
description LONGTEXT 2147483647 √ null
timedue BIGINT 19 √ null

Table contained -1 rows

appraisal_stage table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
apprstag_app_ix Performance Asc appraisalid
apprstag_nam_ix Performance Asc name

appraisal_stage table relationships

Close relationships within degrees of separation