article_requests

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

INT

10

√

null

borrowernumber

INT

10

null

borrowers.borrowernumber

article_requests_ibfk_1

C

biblionumber

INT

10

null

biblio.biblionumber

article_requests_ibfk_2

C

itemnumber

INT

10

√

null

items.itemnumber

article_requests_ibfk_3

N

branchcode

VARCHAR

10

√

null

branches.branchcode

article_requests_ibfk_4

N

title

MEDIUMTEXT

16777215

√

null

author

MEDIUMTEXT

16777215

√

null

volume

MEDIUMTEXT

16777215

√

null

issue

MEDIUMTEXT

16777215

√

null

date

MEDIUMTEXT

16777215

√

null

Showing 1 to 10 of 22 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
biblionumber	Performance	Asc	biblionumber
borrowernumber	Performance	Asc	borrowernumber
branchcode	Performance	Asc	branchcode
debit_id	Performance	Asc	debit_id
itemnumber	Performance	Asc	itemnumber

Showing 1 to 6 of 6 entries

Columns

Indexes

Relationships

Close relationships within degrees of separation