| reserve_id |
INT |
10 |
|
|
null |
|
|
primary key |
| borrowernumber |
INT |
10 |
√ |
|
null |
|
| borrowers.borrowernumber |
old_reserves_ibfk_1N |
|
foreign key from the borrowers table defining which patron this hold is for |
| reservedate |
DATE |
10 |
√ |
|
null |
|
|
the date the hold was places |
| biblionumber |
INT |
10 |
√ |
|
null |
|
| biblio.biblionumber |
old_reserves_ibfk_2N |
|
foreign key from the biblio table defining which bib record this hold is on |
| branchcode |
VARCHAR |
10 |
√ |
|
null |
|
|
foreign key from the branches table defining which branch the patron wishes to pick this hold up at |
| desk_id |
INT |
10 |
√ |
|
null |
|
|
foreign key from the desks table defining which desk the patron should pick this hold up at |
| notificationdate |
DATE |
10 |
√ |
|
null |
|
|
currently unused |
| reminderdate |
DATE |
10 |
√ |
|
null |
|
|
currently unused |
| cancellationdate |
DATE |
10 |
√ |
|
null |
|
|
the date this hold was cancelled |
| cancellation_reason |
VARCHAR |
80 |
√ |
|
null |
|
|
optional authorised value CANCELLATION_REASON |
