tmp_holdsqueue

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

biblionumber

INT

10

√

null

biblio.biblionumber

tmp_holdsqueue_ibfk_2

C

itemnumber

INT

10

null

items.itemnumber

tmp_holdsqueue_ibfk_1

C

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_3

C

cardnumber

VARCHAR

32

√

null

reservedate

DATE

10

√

null

title

LONGTEXT

2147483647

√

null

Showing 1 to 10 of 16 entries

Indexes

Search:

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

Showing 1 to 4 of 4 entries

Columns

Indexes

Relationships

Close relationships within degrees of separation