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_1 N

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_2 N

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 null

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_3 N

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
itemtypes.itemtype old_reserves_ibfk_4 N

If record level hold, the optional itemtype of the item the patron is requesting

Table contained 0 rows


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