app_certif_completion

0 rows


Description

Certifications completed

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_certif_completion_id_seq'::regclass)
certifid int8 19 null
app_certif.id Defined in XML R
userid int8 19 null
app_user.id Defined in XML R
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

Indexes

Constraint Name Type Sort Column(s)
app_certcomp_id_pk Primary key Asc id
app_certcomp_cer_ix Performance Asc certifid
app_certcomp_ceruse_uix Must be unique Asc/Asc certifid + userid
app_certcomp_use_ix Performance Asc userid

Relationships