app_certif_completion_history

0 rows


Description

Previous completed certifications

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_certif_completion_history_id_seq'::regclass)
certifid int8 19 null
app_certif.id Defined in XMLR
userid int8 19 null
app_user.id Defined in XMLR
certifpath int2 5 null
status int2 5 null
renewalstatus int2 5 0
timewindowopens int8 19 null
timeexpires int8 19 null
baselinetimeexpires int8 19 null
timecompleted int8 19 null
timemodified int8 19 null
unassigned int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_certcomphist_id_pk Primary key Asc id
app_certcomphist_cer_ix Performance Asc certifid
app_certcomphist_cerusetim_uix Must be unique Asc/Asc/Asc/Asc certifid + userid + timecompleted + timeexpires
app_certcomphist_use_ix Performance Asc userid

Relationships