Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
cr_id | INT | 10 | √ | null |
|
|
||||
course_id | INT | 10 | null |
|
|
foreign key to link to courses.course_id |
||||
ci_id | INT | 10 | null |
|
|
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 |
|
|