old_reserves

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
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

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
items.itemnumber old_reserves_ibfk_3N

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
itemtypes.itemtype old_reserves_ibfk_4N

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

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_itemnumber Performance Asc itemnumber
old_reserves_itemtype Performance Asc itemtype

Relationships