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 19 null
courseid BIGINT 19 0
course.id backcour_cou2_fk R
laststarttime BIGINT 19 0
lastendtime BIGINT 19 0
laststatus VARCHAR 1 5
nextstarttime BIGINT 19 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