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 |
|||
branchcode | VARCHAR | 10 | √ | null |
|
|
foreign key from the branches table defining which branch the patron wishes to 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 |
|||
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) |
|||
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 hpld placed at item level |
Table contained 0 rows
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_itemnumber | Performance | Asc | itemnumber |
old_reserves_itemtype | Performance | Asc | itemtype |