Certif Completion Table Schema (certif_completion)


Description

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

CERT/RECET
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

Close relationships within degrees of separation