Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
id | BIGINT | 19 | √ | null |
|
|
||||
huburl | VARCHAR | 255 | √ | null |
|
|
the url of the "registered on" hub |
|||
courseid | BIGINT | 19 | null |
|
|
the id of the published course |
||||
timepublished | BIGINT | 19 | null |
|
|
The time when the publication occurred |
||||
enrollable | BIT | 1 | 1 |
|
|
1 = enrollable, 0 = downloadable |
||||
hubcourseid | BIGINT | 19 | null |
|
|
the course id on the hub server |
||||
status | BIT | 1 | √ | 0 |
|
|
is the publication published or not |
|||
timechecked | BIGINT | 19 | √ | null |
|
|
the last time the status has been checked |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | id |
courpubl_cou_ix | Performance | Asc | courseid |
courpubl_hub_ix | Performance | Asc | hubcourseid |