Course Published Table Schema (course_published)


Description

Information about how and when an local courses were published to hubs

course_published table 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
course.id Implied Constraint R

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

Table contained -1 rows

course_published table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

course_published table relationships