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 TINYINT 3 0

Flag if recall is old and no longer active, i.e. expired, cancelled or completed
item_level TINYINT 3 0

Flag if recall is for a specific item

Indexes

Constraint Name Type Sort Column(s)
recalls_s_pk Primary key Asc recall_id
PRIMARY Must be unique 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