recalls

0 rows


Description

Information related to recalls in Koha

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
borrowers.borrowernumber recalls_ibfk_1C

Identifier for patron who requested recall
created_date DATETIME 19 √ null

Date the recall was requested
biblio_id INT 10 0
biblio.biblionumber recalls_ibfk_2C

Identifier for bibliographic record that has been recalled
pickup_library_id VARCHAR 10 √ null
branches.branchcode recalls_ibfk_4C

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
items.itemnumber recalls_ibfk_3C

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