Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| companyid | varchar | 36 | √ | null |
|
|
The ID of the learning site |
||||
| id | varchar | 36 | null |
|
|
Unique Identifier of the Quiz Attempt |
|||||
| courseid | varchar | 36 | √ | null |
|
|
The courseid of the Quiz Attempt |
||||
| userid | varchar | 36 | √ | null |
|
|
The userid of the Quiz Attempt |
||||
| topicid | varchar | 36 | √ | null |
|
|
The topicid of the Quiz Attempt |
||||
| topictype | varchar | 16 | √ | null |
|
|
The topictype of the Quiz Attempt |
||||
| status | varchar | 16 | √ | null |
|
|
The status of the Quiz Attempt |
||||
| grade | int4 | 10 | √ | null |
|
|
The grade of the Quiz Attempt |
||||
| passed | bool | 1 | √ | true |
|
|
The passed of the Quiz Attempt |
||||
| timeelapsed | int4 | 10 | √ | null |
|
|
The timeelapsed of the Quiz Attempt |
||||
| createdat | timestamp | 29,6 | √ | ('now'::text)::timestamp with time zone |
|
|
The date and time the Quiz Attempt was created |
||||
| migrated | int4 | 10 | √ | null |
|
|
The migrated of the Quiz Attempt |
||||
| updatedat | timestamp | 29,6 | √ | ('now'::text)::timestamp with time zone |
|
|
The date and time the Quiz Attempt was created |
||||
| licenseid | varchar | 36 | √ | null |
|
|
|||||
| forgiven | bool | 1 | √ | null |
|
|
|||||
| statusgroup | varchar | 256 | √ | null |
|
|
|||||
| statusgroupupdatedat | timestamp | 29,6 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
