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 |