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_1 C

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
branches.branchcode recalls_ibfk_4 C

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_3 C

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