course_reserves

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cr_id INT 10 null
course_id INT 10 null
courses.course_id course_reserves_ibfk_1R

foreign key to link to courses.course_id

ci_id INT 10 null
course_items.ci_id course_reserves_ibfk_2C

foreign key to link to courses_items.ci_id

staff_note LONGTEXT 2147483647 null

staff only note

public_note LONGTEXT 2147483647 null

public, OPAC visible note

timestamp TIMESTAMP 19 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc cr_id
course_id Performance Asc course_id
course_reserves_ibfk_2 Performance Asc ci_id
pseudo_key Must be unique Asc/Asc course_id + ci_id

Relationships