course_reserves


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

foreign key to link to courses.course_id
ci_id INT 10 null
course_items.ci_id course_reserves_ibfk_2 C

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()

Table contained 0 rows

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

Close relationships within degrees of separation