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 |