Certificate Issues History Table Schema (certificate_issues_history)


Archived user certificates for Totara

certificate_issues_history table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
userid BIGINT 19 0
user.id certissuhist_use2_fk R
certificateid BIGINT 19 0
certificate.id certissuhist_cer2_fk R
code VARCHAR 40 null

Copy of the 10-digit code that can be printed on the certificate

timecreated BIGINT 19 0
timecompleted BIGINT 19 null

Date/Time completed at the time the certificate was archived.

grade VARCHAR 300 null

Grade at time of archive - note that this is text not a percentage

outcome VARCHAR 300 null

Outcome at time of archive

timearchived BIGINT 19 null
idarchived BIGINT 19 null

Table contained -1 rows

certificate_issues_history table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
certissuhist_cer_ix Performance Asc certificateid
certissuhist_use_ix Performance Asc userid

certificate_issues_history table relationships