Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| reserve_id | INT | 10 | null |
|
|
primary key |
||||
| borrowernumber | INT | 10 | √ | null |
|
|
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 |
|
|
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 |
|||
| cancellation_reason | VARCHAR | 80 | √ | null |
|
|
optional authorised value CANCELLATION_REASON |
|||
| reservenotes | LONGTEXT | 2147483647 | √ | null |
|
|
notes related to this hold |
|||
| priority | SMALLINT | 5 | 1 |
|
|
where in the queue the patron sits |
||||
| found | VARCHAR | 1 | √ | null |
|
|
a one letter code defining what the status is of the hold is after it has been confirmed |
|||
| timestamp | TIMESTAMP | 19 | current_timestamp() |
|
|
the date and time this hold was last updated |
||||
| itemnumber | INT | 10 | √ | null |
|
|
foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with |
|||
| waitingdate | DATE | 10 | √ | null |
|
|
the date the item was marked as waiting for the patron at the library |
|||
| expirationdate | DATE | 10 | √ | null |
|
|
the date the hold expires (usually the date entered by the patron to say they don’t need the hold after a certain date) |
|||
| patron_expiration_date | DATE | 10 | √ | null |
|
|
the date the hold expires - usually the date entered by the patron to say they don’t need the hold after a certain date |
|||
| lowestPriority | BIT | 0 | 0 |
|
|
has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no) |
||||
| suspend | BIT | 0 | 0 |
|
|
in this hold suspended (1 for yes, 0 for no) |
||||
| suspend_until | DATETIME | 19 | √ | null |
|
|
the date this hold is suspended until (NULL for infinitely) |
|||
| itemtype | VARCHAR | 10 | √ | null |
|
|
If record level hold, the optional itemtype of the item the patron is requesting |
|||
| item_level_hold | BIT | 0 | 0 |
|
|
Is the hold placed at item level |
||||
| non_priority | BIT | 0 | 0 |
|
|
Is this a non priority hold |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | reserve_id |
| old_reserves_biblionumber | Performance | Asc | biblionumber |
| old_reserves_borrowernumber | Performance | Asc | borrowernumber |
| old_reserves_branchcode | Performance | Asc | branchcode |
| old_reserves_ibfk_ig | Performance | Asc | item_group_id |
| old_reserves_itemnumber | Performance | Asc | itemnumber |
| old_reserves_itemtype | Performance | Asc | itemtype |
Relationships
Close relationships within degrees of separation
