Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| recall_id | INT | 10 | √ | null |
|
|
Unique identifier for this recall |
|||
| patron_id | INT | 10 | 0 |
|
|
Identifier for patron who requested recall |
||||
| created_date | DATETIME | 19 | √ | null |
|
|
Date the recall was requested |
|||
| biblio_id | INT | 10 | null |
|
|
Identifier for bibliographic record that has been recalled |
||||
| pickup_library_id | VARCHAR | 10 | √ | null |
|
|
Identifier for recall pickup library |
|||
| completed_date | DATETIME | 19 | √ | null |
|
|
Date the recall is completed (fulfilled, cancelled or expired) |
|||
| notes | MEDIUMTEXT | 16777215 | √ | null |
|
|
Notes related to the recall |
|||
| priority | SMALLINT | 5 | √ | null |
|
|
Where in the queue the patron sits |
|||
| status | enum('requested', 'overdue', 'waiting', 'in_transit', 'cancelled', 'expired', 'fulfilled') | 10 | √ | requested |
|
|
Status of recall |
|||
| timestamp | TIMESTAMP | 19 | current_timestamp() |
|
|
Date and time the recall was last updated |
||||
| item_id | INT | 10 | √ | null |
|
|
Identifier for item record that was recalled, if an item-level recall |
|||
| waiting_date | DATETIME | 19 | √ | null |
|
|
Date an item was marked as waiting for the patron at the library |
|||
| expiration_date | DATETIME | 19 | √ | null |
|
|
Date recall is no longer required, or date recall will expire after waiting on shelf for pickup |
|||
| completed | BIT | 0 | 0 |
|
|
Flag if recall is old and no longer active, i.e. expired, cancelled or completed |
||||
| item_level | BIT | 0 | 0 |
|
|
Flag if recall is for a specific item |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | recall_id |
| recalls_ibfk_1 | Performance | Asc | patron_id |
| recalls_ibfk_2 | Performance | Asc | biblio_id |
| recalls_ibfk_3 | Performance | Asc | item_id |
| recalls_ibfk_4 | Performance | Asc | pickup_library_id |
Relationships
Close relationships within degrees of separation
