Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | course_id |