course_id |
INT |
10 |
|
√ |
null |
|
|
unique id for the course |
department |
VARCHAR |
80 |
√ |
|
null |
|
|
the authorised value for the DEPARTMENT |
course_number |
VARCHAR |
255 |
√ |
|
null |
|
|
the "course number" assigned to a course |
section |
VARCHAR |
255 |
√ |
|
null |
|
|
the 'section' of a course |
course_name |
VARCHAR |
255 |
√ |
|
null |
|
|
the name of the course |
term |
VARCHAR |
80 |
√ |
|
null |
|
|
the authorised value for the TERM |
staff_note |
LONGTEXT |
2147483647 |
√ |
|
null |
|
|
the text of the staff only note |
public_note |
LONGTEXT |
2147483647 |
√ |
|
null |
|
|
the text of the public / opac note |
students_count |
VARCHAR |
20 |
√ |
|
null |
|
|
how many students will be taking this course/section |
enabled |
enum('yes', 'no') |
4 |
|
|
yes |
|
|
determines whether the course is active |
timestamp |
TIMESTAMP |
19 |
|
|
current_timestamp() |
|
|
|