Appraisal Event Table Schema (appraisal_event)


Description

Appraisal event notifications

appraisal_event table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
appraisal_event_message.appraisaleventid apprevenmess_app2_fk R
appraisal_user_event.eventid apprusereven_eve2_fk R
appraisalid BIGINT 19 null
appraisal.id appreven_app3_fk R
appraisalstageid BIGINT 19 null
appraisal_stage.id appreven_app4_fk R
event VARCHAR 32

Event name: activation, stage_complete or stage_due
delta BIGINT 19 0

Event time delta: + - after event, 0 - immediately, - before event
deltaperiod BIT 1 0

Period: 0 - hours (not used), 1 - days, 2 - weeks, 3 - months
triggered BIT 1 0
stageiscompleted BIT 1 0
timescheduled BIGINT 19 √ null

Table contained -1 rows

appraisal_event table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
appreven_app2_ix Performance Asc appraisalstageid
appreven_app_ix Performance Asc appraisalid
appreven_eve_ix Performance Asc event
appreven_tim_ix Performance Asc timescheduled

appraisal_event table relationships

Close relationships within degrees of separation