Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ci_id | INT | 10 | √ | null |
|
|
course item id |
||||
| itemnumber | INT | 10 | √ | NULL |
|
|
items.itemnumber for the item on reserve |
||||
| biblionumber | INT | 10 | null |
|
|
biblio.biblionumber for the bibliographic record on reserve |
|||||
| itype | VARCHAR | 10 | √ | NULL |
|
|
new itemtype for the item to have while on reserve (optional) |
||||
| itype_enabled | BOOLEAN | 3 | 0 |
|
|
indicates if itype should be changed while on course reserve |
|||||
| itype_storage | VARCHAR | 10 | √ | NULL |
|
|
a place to store the itype when item is on course reserve |
||||
| ccode | VARCHAR | 80 | √ | NULL |
|
|
new category code for the item to have while on reserve (optional) |
||||
| ccode_enabled | BOOLEAN | 3 | 0 |
|
|
indicates if ccode should be changed while on course reserve |
|||||
| ccode_storage | VARCHAR | 80 | √ | NULL |
|
|
a place to store the ccode when item is on course reserve |
||||
| homebranch | VARCHAR | 10 | √ | NULL |
|
|
new home branch for the item to have while on reserve (optional) |
||||
| homebranch_enabled | BOOLEAN | 3 | 0 |
|
|
indicates if homebranch should be changed while on course reserve |
|||||
| homebranch_storage | VARCHAR | 10 | √ | NULL |
|
|
a place to store the homebranch when item is on course reserve |
||||
| holdingbranch | VARCHAR | 10 | √ | NULL |
|
|
new holding branch for the item to have while on reserve (optional) |
||||
| holdingbranch_enabled | BOOLEAN | 3 | 0 |
|
|
indicates if itype should be changed while on course reserve |
|||||
| holdingbranch_storage | VARCHAR | 10 | √ | NULL |
|
|
a place to store the holdingbranch when item is on course reserve |
||||
| location | VARCHAR | 80 | √ | NULL |
|
|
new shelving location for the item to have while on reseve (optional) |
||||
| location_enabled | BOOLEAN | 3 | 0 |
|
|
indicates if itype should be changed while on course reserve |
|||||
| location_storage | VARCHAR | 80 | √ | NULL |
|
|
a place to store the location when the item is on course reserve |
||||
| enabled | enum('yes', 'no') | 3 | 'no' |
|
|
if at least one enabled course has this item on reseve, this field will be ‘yes’, otherwise it will be ‘no’ |
|||||
| timestamp | TIMESTAMP | 19 | current_timestamp() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | ci_id |
| fk_course_items_biblionumber | Performance | Asc | biblionumber |
| fk_course_items_homebranch | Performance | Asc | homebranch |
| fk_course_items_homebranch_storage | Performance | Asc | homebranch_storage |
| holdingbranch | Performance | Asc | holdingbranch |
| itemnumber | Must be unique | Asc | itemnumber |
Relationships
Close relationships within degrees of separation
