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_2 R
course_reserves.course_id course_reserves_ibfk_1 R

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 Constraint R

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') 3 '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

Close relationships within degrees of separation