tmp_holdsqueue

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
biblionumber INT 10 null
biblio.biblionumber tmp_holdsqueue_ibfk_2C
itemnumber INT 10 null
items.itemnumber tmp_holdsqueue_ibfk_1C
barcode VARCHAR 20 null
surname LONGTEXT 2147483647 null
firstname MEDIUMTEXT 16777215 null
phone MEDIUMTEXT 16777215 null
borrowernumber INT 10 null
borrowers.borrowernumber tmp_holdsqueue_ibfk_3C
cardnumber VARCHAR 32 null
reservedate DATE 10 null
title LONGTEXT 2147483647 null
itemcallnumber VARCHAR 255 null
holdingbranch VARCHAR 10 null
pickbranch VARCHAR 10 null
notes MEDIUMTEXT 16777215 null
item_level_request TINYINT 3 0
timestamp TIMESTAMP 19 current_timestamp()

date and time this entry as added/last updated

Indexes

Constraint Name Type Sort Column(s)
tmp_holdsqueue_ibfk_1 Performance Asc itemnumber
tmp_holdsqueue_ibfk_2 Performance Asc biblionumber
tmp_holdsqueue_ibfk_3 Performance Asc borrowernumber

Relationships