courses

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
course_id INT 10 null
course_instructors.course_id course_instructors_ibfk_2R
course_reserves.course_id course_reserves_ibfk_1R

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
items_search_fields.name Implied ConstraintR

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

Relationships