| ci_id |
INT |
10 |
|
√ |
null |
|
|
course item id |
| itemnumber |
INT |
10 |
√ |
|
null |
|
| items.itemnumber |
course_items_ibfk_1 |
C |
|
items.itemnumber for the item on reserve |
| biblionumber |
INT |
10 |
|
|
null |
|
| biblio.biblionumber |
fk_course_items_biblionumber |
C |
|
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 |
BIT |
0 |
|
|
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 |
BIT |
0 |
|
|
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 |
|
| branches.branchcode |
fk_course_items_homebranch |
C |
|
new home branch for the item to have while on reserve (optional) |
