Table testsql_comments.old_reserves
this table holds all holds/reserves that have been completed (either filled or cancelled)

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
reserve_id int 10
reserves.reserve_id Implied Constraint R
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
branches.branchcode Implied Constraint R
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 mediumtext 16777215  √  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 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 at Tue Dec 27 15:49 NZDT 2016

Indexes:
Column(s) Type Sort Constraint Name
reserve_id Primary key Asc PRIMARY
biblionumber Performance Asc old_reserves_biblionumber
borrowernumber Performance Asc old_reserves_borrowernumber
branchcode Performance Asc old_reserves_branchcode
itemnumber Performance Asc old_reserves_itemnumber
itemtype Performance Asc old_reserves_itemtype

Close relationships  within of separation: