certificate_issues_history table columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||
| userid | BIGINT | 19 | 0 |
|
|
|||||
| certificateid | BIGINT | 19 | 0 |
|
|
|||||
| 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
Close relationships within degrees of separation
