course_reserves

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 6 of 6 entries

Table contained 0 rows

Indexes

Search:

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

Showing 1 to 4 of 4 entries

Columns

Indexes

Relationships

Close relationships within degrees of separation