Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| companyId | uuid | 2147483647 | null |
|
|
The ID of the learning site |
||||||||||||||
| id | uuid | 2147483647 | null |
|
|
Unique Identifier of the Topic |
||||||||||||||
| sectionId | uuid | 2147483647 | √ | null |
|
|
The ID of the Section associated with the Topic |
|||||||||||||
| lessonId | uuid | 2147483647 | √ | null |
|
|
The ID of the Lesson associated with the Topic |
|||||||||||||
| courseId | uuid | 2147483647 | √ | null |
|
|
The ID of the Course associated with the Topic |
|||||||||||||
| title | varchar | 255 | √ | null |
|
|
The title of the Topic |
|||||||||||||
| type | varchar | 32 | √ | null |
|
|
The type of the Topic |
|||||||||||||
| slug | varchar | 32 | √ | null |
|
|
The slug (URL-formatted version of the Name) of the Topic |
|||||||||||||
| continueAfterTimerExpires | bool | 1 | false |
|
|
The continue after timer expires of the Topic |
||||||||||||||
| hideQuestionResults | bool | 1 | false |
|
|
The hide question results of the Topic |
||||||||||||||
| minPassingPercent | int4 | 10 | √ | null |
|
|
The min passing percent of the Topic |
|||||||||||||
| timePerQuestionInSeconds | int4 | 10 | √ | null |
|
|
The time per question in seconds of the Topic |
|||||||||||||
| completionTimeSeconds | int4 | 10 | √ | null |
|
|
The completion time in seconds of the Topic |
|||||||||||||
| maxAttempts | int4 | 10 | √ | null |
|
|
The max attempts of the Topic |
|||||||||||||
| timeLimitInSeconds | int4 | 10 | √ | null |
|
|
The time limit in seconds of the Topic |
|||||||||||||
| randomizeChoices | bool | 1 | false |
|
|
The randomize choices of the Topic |
||||||||||||||
| preventProgression | bool | 1 | false |
|
|
The prevent progression of the Topic |
||||||||||||||
| timerEnabled | bool | 1 | false |
|
|
The timer enabled of the Topic |
||||||||||||||
| hintControlEnabled | bool | 1 | false |
|
|
The hint control enabled of the Topic |
||||||||||||||
| questionSkipEnabled | bool | 1 | false |
|
|
The question skip enabled of the Topic |
||||||||||||||
| displayAllHints | bool | 1 | false |
|
|
The display all hints of the Topic |
||||||||||||||
| bool | 1 | false |
|
|
The navigation disabled of the Topic |
|||||||||||||||
| isGraded | bool | 1 | false |
|
|
The is graded of the Topic |
||||||||||||||
| bool | 1 | false |
|
|
The sidebar is hidden of the Topic |
Table contained 0 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| topics_pkey | Primary key | Asc | id |
| topics_courseId_idx | Performance | Asc | courseId |
| topics_lessonId_idx | Performance | Asc | lessonId |
| topics_sectionId_idx | Performance | Asc | sectionId |
Relationships
Close relationships within degrees of separation
