topics


Description

Topics created by the learning site

Columns

Column Type Size Nulls Auto Default Children Parents Comments
companyId uuid 2147483647 null
companies.id topics_companyId_fkeyC

The ID of the learning site

id uuid 2147483647 null
assignmentSubmissions.assignmentId quizAttemptResponses_assignmentId_fkeyC
ltiAttempts.topicId ltiAttempts_topicId_fkeyC
quizAttemptResponses.topicId quizAttemptResponses_topicId_fkeyC
quizAttempts.topicId quizAttempts_topicId_fkeyC
scormAttemptResponses.topicId scormAttemptResponses_topicId_fkeyC
scormAttempts.topicId scormAttempts_topicId_fkeyC

Unique Identifier of the Topic

sectionId uuid 2147483647 null
sections.id topics_sectionId_fkeyC

The ID of the Section associated with the Topic

lessonId uuid 2147483647 null
lessons.id topics_lessonId_fkeyC

The ID of the Lesson associated with the Topic

courseId uuid 2147483647 null
courses.id topics_courseId_fkeyC

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

navigationDisabled bool 1 false

The navigation disabled of the Topic

isGraded bool 1 false

The is graded of the Topic

sidebarIsHidden 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