Table testsql_comments.reserves 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  √ 
old_reserves.reserve_id Implied Constraint R
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 places
biblionumber int 10 0
biblio.biblionumber reserves_ibfk_2 C
foreign key from the biblio table defining which bib record this hold is on
constrainttype varchar 1  √  null
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 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 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
suspend bit 0 0
suspend_until datetime 19  √  null

Table contained 0 rows at Tue Dec 27 18:01 NZDT 2016

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

Close relationships  within of separation: