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