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_1C

biblionumber

INT

10

null

biblio.biblionumber

article_requests_ibfk_2C

itemnumber

INT

10

√

null

items.itemnumber

article_requests_ibfk_3N

branchcode

VARCHAR

10

√

null

branches.branchcode

article_requests_ibfk_4N

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 21 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
itemnumber	Performance	Asc	itemnumber

Showing 1 to 5 of 5 entries

Columns

Indexes

Relationships

Close relationships within degrees of separation