Certif Completion Table Schema (certif_completion)


Certifications completed

certif_completion table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
certifid BIGINT 19 null
certif.id certcomp_cer2_fk R

Certification ID

userid BIGINT 19 null
user.id certcomp_use2_fk R

Users id

certifpath TINYINT 3 null


status TINYINT 3 null

Certification status

renewalstatus TINYINT 3 0
timewindowopens BIGINT 19 null

Date the window opens

timeexpires BIGINT 19 null

Date the certificate expires

baselinetimeexpires BIGINT 19 null
timecompleted BIGINT 19 null
timemodified BIGINT 19 null

Table contained -1 rows

certif_completion table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
certcomp_cer_ix Performance Asc certifid
certcomp_ceruse_uix Must be unique Asc/Asc certifid + userid
certcomp_use_ix Performance Asc userid

certif_completion table relationships