| 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 |
|
| biblio.biblionumber |
recalls_ibfk_2 |
C |
|
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 |
