app_appraisal_event

0 rows


Description

Appraisal event notifications

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_appraisal_event_id_seq'::regclass)
app_appraisal_event_message.appraisaleventid Defined in XMLR
app_appraisal_user_event.eventid Defined in XMLR
appraisalid int8 19 null
app_appraisal.id Defined in XMLR
appraisalstageid int8 19 null
app_appraisal_stage.id Defined in XMLR
event varchar 32 ''::character varying
delta int8 19 0
deltaperiod int2 5 0
triggered int2 5 0
stageiscompleted int2 5 0
timescheduled int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
app_appreven_id_pk Primary key Asc id
app_appreven_app2_ix Performance Asc appraisalstageid
app_appreven_app_ix Performance Asc appraisalid
app_appreven_eve_ix Performance Asc event
app_appreven_tim_ix Performance Asc timescheduled

Relationships

Close relationships within degrees of separation