course_published

0 rows


Description

Information about how and when an local courses were publish

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 course_published_erd_course_idR

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

Relationships