Table testsql_comments.reserves Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
reserve_id int 10  √ 
primary key
borrowernumber int 10 0
borrowers
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
foreign key from the biblio table defining which bib record this hold is on
constrainttype varchar 1  √  null
branchcode varchar 10  √  null
branches
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
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
reserve_id Primary key Asc
biblionumber Performance Asc
borrowernumber Performance Asc
branchcode Performance Asc
itemnumber Performance Asc
priority + found Performance Asc/Asc

Close relationships  within of separation: