Certif Completion History Table Schema (certif_completion_history)


Description

Previous completed certifications

certif_completion_history table columns

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

Certification ID

userid BIGINT 19 null
user.id certcomphist_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

timecompleted BIGINT 19 null
timemodified BIGINT 19 null
unassigned BIT 0 0

Unassigned from certification

Table contained -1 rows

certif_completion_history table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
certcomphist_cer_ix Performance Asc certifid
certcomphist_cerusetimtim_uix Must be unique Asc/Asc/Asc/Asc certifid + userid + timecompleted + timeexpires
certcomphist_use_ix Performance Asc userid

certif_completion_history table relationships