reserves


Columns

Column Type Size Nulls Auto Default Children Parents Comments
reserve_id INT 10 √ null

primary key
borrowernumber INT 10 0
borrowers.borrowernumber reserves_ibfk_1 C

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
biblio.biblionumber reserves_ibfk_2 C

foreign key from the biblio table defining which bib record this hold is on
branchcode VARCHAR 10 √ null
branches.branchcode reserves_ibfk_4 C

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 reserves_ibfk_3 C

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
suspend BIT 0 0
suspend_until DATETIME 19 √ null
itemtype VARCHAR 10 √ null
itemtypes.itemtype reserves_ibfk_5 C

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

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc reserve_id
biblionumber Performance Asc biblionumber
borrowernumber Performance Asc borrowernumber
branchcode Performance Asc branchcode
itemnumber Performance Asc itemnumber
itemtype Performance Asc itemtype
priorityfoundidx Performance Asc/Asc priority + found

Relationships

Close relationships within degrees of separation