Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
id | uuid | 2147483647 | null |
|
|
Unique Identifier of the Course |
||||||||||||||||||||||||||||||
companyId | uuid | 2147483647 | null |
|
|
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 |
|
|
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 |