topics

14116345 rows


Description

Topic created by the learning site

Columns

Column Type Size Nulls Auto Default Children Parents Comments
companyid varchar 36 √ null
companies.id topics_companyid_fkey R

The ID of the learning site
id varchar 36 null
quizattempts.topicid quizattempts_topicid_fkey R
quizattempts.topicid quizattempts_topicid_fkey R
usertopicprogresses.topicid usertopicprogresses_topicid_fkey R
views.topicid views_topicid_fkey R
viewtimes.topicid viewtimes_topicid_fkey R

Unique Identifier of the Topic
sectionid varchar 36 √ null
sections.id topics_section_fkey R

The section of the Topic
lessonid varchar 36 √ null
lessons.id topics_lesson_fkey R

The lesson of the Topic
courseid varchar 36 √ null
courses.id topics_courseid_fkey R

The courseid of 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 of the Topic
updatedat timestamp 29,6 √ ('now'::text)::timestamp with time zone

The date and time the Topic was created
minpassingpercent float8 17,17 √ null
continueaftertimerexpires bool 1 √ null
hidequestionresults bool 1 √ null
timeperquestioninseconds int4 10 √ null
completiontimeseconds int4 10 √ null
maxattempts int4 10 √ null
timelimitinseconds int4 10 √ null
randomizechoices bool 1 √ null
preventprogression bool 1 √ null
timerenabled bool 1 √ null
hintcontrolenabled bool 1 √ null
questionskipenabled bool 1 √ null
displayallhints bool 1 √ null
navigationdisabled bool 1 √ null
isgraded bool 1 √ null
sidebarishidden bool 1 √ null
statusgroup varchar 256 √ null
statusgroupupdatedat timestamp 29,6 √ null

Relationships

Close relationships within degrees of separation