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 Response |
|||||
| courseid | varchar | 36 | √ | null |
|
|
The courseid of the Quiz Attempt Response |
||||
| userid | varchar | 36 | √ | null |
|
|
The userid of the Quiz Attempt Response |
||||
| topicid | varchar | 36 | √ | null |
|
|
The topicid of the Quiz Attempt Response |
||||
| quizattemptid | varchar | 36 | √ | null |
|
|
The quizattemptid of the Quiz Attempt Response |
||||
| question | varchar | 65535 | √ | null |
|
|
The question of the Quiz Attempt Response |
||||
| answer | varchar | 65535 | √ | null |
|
|
The answer of the Quiz Attempt Response |
||||
| correct | bool | 1 | √ | true |
|
|
The correct of the Quiz Attempt Response |
||||
| createdat | timestamp | 29,6 | √ | ('now'::text)::timestamp with time zone |
|
|
The date and time the Quiz Attempt Response was created |
||||
| updatedat | timestamp | 29,6 | √ | ('now'::text)::timestamp with time zone |
|
|
The date and time the Quiz Attempt Response was created |
||||
| questionid | varchar | 36 | √ | null |
|
|
|||||
| quizquestiontype | varchar | 36 | √ | null |
|
|
|||||
| mustselectallcorrectchoices | bool | 1 | √ | null |
|
|
|||||
| licenseid | varchar | 36 | √ | null |
|
|
|||||
| order | int4 | 10 | √ | null |
|
|
|||||
| topictype | varchar | 65535 | √ | null |
|
|
|||||
| statusgroup | varchar | 256 | √ | null |
|
|
|||||
| statusgroupupdatedat | timestamp | 29,6 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
