Backup Courses Table Schema (backup_courses)


Description

To store every course backup status

backup_courses table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
courseid bigint 10 0
course.id Implied Constraint R
laststarttime bigint 10 0
lastendtime bigint 10 0
laststatus varchar 1 5
nextstarttime bigint 10 0

Table contained -1 rows

backup_courses table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
backcour_cou_uix Must be unique Asc courseid

backup_courses table relationships