courses

1309413 rows


Description

Course created by the learning site

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id varchar 36 null
assignmentsubmissions.courseid assignmentsubmissions_courseid_fkey R
certificates.courseid certificates_courseid_fkey1 R
clientcourses.courseid clientcourses_courseid_fkey1 R
courseactions.courseid n_courseactions_courseid_fkey R
coursecustomfields.courseid coursecustomfields_courseid_fkey R
coursetags.courseid n_coursetags_courseid_fkey R
forums.courseid forums_courseid_fkey1 R
lessons.courseid lessons_courseid_fkey1 R
licensecourses.courseid licensecourses_courseid_fkey1 R
ltiattempts.courseid ltiattempts_courseid_fkey1 R
meetings.courseid meetings_courseid_fkey R
purchases.courseid purchases_courseid_fkey1 R
quizattemptresponses.courseid quizattemptresponses_courseid_fkey1 R
quizattempts.courseid quizattempts_courseid_fkey R
scormattemptresponses.courseid scormattemptresponses_courseid_fkey1 R
scormattempts.courseid scormattempts_courseid_fkey1 R
sectioncompletions.courseid sectioncompletions_courseid_fkey R
sections.courseid sections_courseid_fkey1 R
topics.courseid topics_courseid_fkey R
userattendedmeetings.courseid userattendedmeetings_courseid_fkey R
usercourseprogresses.courseid usercourseprogresses_courseid_fkey1 R
usercourses.courseid usercourses_courseid_fkey1 R
userlearningpaths.companyid userlearningpaths_companyid_fkey R
waitlists.courseid waitlists_courseid_fkey R
assignmentsubmissions.courseid assignmentsubmissions_courseid_fkey R
certificates.courseid certificates_courseid_fkey1 R
clientcourses.courseid clientcourses_courseid_fkey1 R
courseactions.courseid n_courseactions_courseid_fkey R
coursecustomfields.courseid coursecustomfields_courseid_fkey R
coursetags.courseid n_coursetags_courseid_fkey R
forums.courseid forums_courseid_fkey1 R
lessons.courseid lessons_courseid_fkey1 R
licensecourses.courseid licensecourses_courseid_fkey1 R
ltiattempts.courseid ltiattempts_courseid_fkey1 R
meetings.courseid meetings_courseid_fkey R
purchases.courseid purchases_courseid_fkey1 R
quizattemptresponses.courseid quizattemptresponses_courseid_fkey1 R
quizattempts.courseid quizattempts_courseid_fkey R
scormattemptresponses.courseid scormattemptresponses_courseid_fkey1 R
scormattempts.courseid scormattempts_courseid_fkey1 R
sectioncompletions.courseid sectioncompletions_courseid_fkey R
sections.courseid sections_courseid_fkey1 R
topics.courseid topics_courseid_fkey R
userattendedmeetings.courseid userattendedmeetings_courseid_fkey R
usercourseprogresses.courseid usercourseprogresses_courseid_fkey1 R
usercourses.courseid usercourses_courseid_fkey1 R
userlearningpaths.companyid userlearningpaths_companyid_fkey R
views.courseid views_new_id_courseid_fkey R
viewtimes.courseid viewtimes_courseid_fkey R
waitlists.courseid waitlists_courseid_fkey R

Unique Identifier of the Course
companyid varchar 36 √ null
companies.id n_courses_companyid_fkey R

The ID of the learning site
clientid varchar 36 √ null
clients.id n_courses_clientid_fkey R

The clientid of the Course
status varchar 16 √ null

The status of the Course
totalviews int4 10 √ null

The totalview of the Course
title varchar 1024 √ null

The title of the Course
slug varchar 1024 √ null

The slug of the Course
coursegroupid varchar 36 √ null

The coursegroupid of the Course
parentcourseid varchar 36 √ null

The parentcourseid of the Course
kind varchar 32 √ null

The kind of the Course
contenttype varchar 32 √ null

The contenttype of the Course
createdat timestamp 29,6 √ ('now'::text)::timestamp with time zone

The date and time the Course was created
author varchar 512 √ null

The author of the Course
source varchar 512 √ null

The source of the Course
updatedat timestamp 29,6 √ ('now'::text)::timestamp with time zone

The date and time the Course was created
seatslimit int4 10 √ null
seatsused int4 10 √ null
priceincents float8 17,17 √ null
balancerequirement float8 17,17 √ null
graceperiodenddate timestamp 29,6 √ null
enrollmentenddate timestamp 29,6 √ null
enrollmentstartdate timestamp 29,6 √ null
startdate timestamp 29,6 √ null
enddate timestamp 29,6 √ null
sku varchar 65535 √ null
totaltime int8 19 √ null
statusgroup varchar 256 √ null
statusgroupupdatedat timestamp 29,6 √ null

Relationships

Close relationships within degrees of separation