Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| reserve_id | INT | 10 | √ | null |
|
|
primary key |
|||
| borrowernumber | INT | 10 | 0 |
|
|
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 |
|
|
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 |
|||
| desk_id | INT | 10 | √ | null |
|
|
foreign key from the desks table defining which desk the patron should 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 |
|||
| cancellation_reason | VARCHAR | 80 | √ | null |
|
|
optional authorised value CANCELLATION_REASON |
|||
| reservenotes | LONGTEXT | 2147483647 | √ | null |
|
|
notes related to this hold |
|||
| priority | SMALLINT | 5 | 1 |
|
|
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 |
|
|
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 |
|
|
If record level hold, the optional itemtype of the item the patron is requesting |
|||
| item_level_hold | BIT | 0 | 0 |
|
|
Is the hpld placed at item level |
||||
| non_priority | BIT | 0 | 0 |
|
|
Is this a non priority hold |
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 |
| desk_id | Performance | Asc | desk_id |
| itemnumber | Performance | Asc | itemnumber |
| itemtype | Performance | Asc | itemtype |
| priorityfoundidx | Performance | Asc/Asc | priority + found |
Relationships
Close relationships within degrees of separation
