courses


Description

Courses created by the learning site

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
assignmentSubmissions.courseId assignmentSubmissions_courseId_fkeyC
courseActions.courseId courseActions_courseId_fkeyC
lessons.courseId lessons_courseId_fkeyC
ltiAttempts.courseId ltiAttempts_courseId_fkeyC
milestoneCourses.courseId milestoneCourses_courseId_fkeyC
quizAttemptResponses.courseId quizAttemptResponses_courseId_fkeyC
quizAttempts.courseId quizAttempts_courseId_fkeyC
scormAttemptResponses.courseId scormAttemptResponses_courseId_fkeyC
scormAttempts.courseId scormAttempts_courseId_fkeyC
sections.courseId sections_courseId_fkeyC
topics.courseId topics_courseId_fkeyC
userCourseProgresses.courseId userCourseProgresses_courseId_fkeyC
userCourses.courseId userCourses_courseId_fkeyC
waitlists.courseId waitlists_courseId_fkeyC

Unique Identifier of the Course
companyId uuid 2147483647 null
companies.id courses_companyId_fkeyC

The ID of the learning site
sku varchar 65535 √ null

The sku of the Course
status varchar 16 √ null

The status of the Course
totalTime int4 10 √ null

The total time of the Course
totalViews int4 10 √ null

The total views of the Course
title varchar 1024 √ null

The title of the Course
slug varchar 1024 √ null

The slug (URL-formatted version of the Name) of the Course
courseGroupId uuid 2147483647 √ null
courseGroups.id courses_courseGroupId_fkeyC

The ID of the Course Group associated with the Course
parentCourseId uuid 2147483647 √ null

The ID of the Parent Course associated with the Course
kind varchar 32 √ null

The kind of the Course
priceInCents int4 10 √ null

The price (in cents) of the Course
createdAt timestamp 29,6 √ null

The date and time the Course was created
startDate timestamp 29,6 √ null

The date and time the Course was created
enrollmentStartDate timestamp 29,6 √ null

The date and time the Course was created
endDate timestamp 29,6 √ null

The date and time the Course was created
enrollmentEndDate timestamp 29,6 √ null

The date and time the Course was created
gracePeriodEndDate timestamp 29,6 √ null

The date and time the Course was created
updatedAt timestamp 29,6 √ null
seatsLimit int4 10 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
courses_pkey Primary key Asc id
courses_courseGroupId_idx Performance Asc courseGroupId

Relationships

Close relationships within degrees of separation