Certif Table Schema (certif)



certif table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
certif_completion.certifid certcomp_cer2_fk R
certif_completion_history.certifid certcomphist_cer2_fk R
prog.certifid prog_cer2_fk R
totara_compl_import_cert.certificationid Implied Constraint R
learningcomptype TINYINT 3 null

Type of component - program, course, competency

activeperiod VARCHAR 20 null

How long is the certificate active for - stored as seconds

minimumactiveperiod VARCHAR 20 null

When using fixed expiry date, calculated expiry dates must be at least this far in the future

windowperiod VARCHAR 20 null

How long before a learners certification is due for renewal and that the recertification window should open - stored as seconds

recertifydatetype BIT 0 null

Indicator for which date is used for the recertification, either the completion date or the certificate expiry date

timemodified BIGINT 19 0

Table contained -1 rows

certif table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

certif table relationships