| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| reserve_id | INT | 10 | √ | null |
|
|
primary key |
|||
| borrowernumber | INT | 10 | 0 |
|
|
foreign key from the borrowers table defining which patron this hold is for |
||||
| reservedate | DATE | 10 | √ | null |
|
|
the date the hold was placed |
|||
| biblionumber | INT | 10 | 0 |
|
|
foreign key from the biblio table defining which bib record this hold is on |
||||
| item_group_id | INT | 10 | √ | null |
|
|
foreign key from the item_groups table defining if this is an item group level hold |
|||
| 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 |
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | reserve_id |
| biblionumber | Performance | Asc | biblionumber |
| borrowernumber | Performance | Asc | borrowernumber |
| branchcode | Performance | Asc | branchcode |
| desk_id | Performance | Asc | desk_id |
| itemnumber | Performance | Asc | itemnumber |
| itemtype | Performance | Asc | itemtype |
| priorityfoundidx | Performance | Asc/Asc | priority + found |
| reserves_ibfk_ig | Performance | Asc | item_group_id |
