| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| id |
int |
10 |
|
√ |
|
|
|
| borrowernumber |
int |
10 |
|
|
|
|
| borrowers.borrowernumber
|
article_requests_ibfk_1 C |
|
| biblionumber |
int |
10 |
|
|
|
|
| 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 |
|
|
| pages |
mediumtext |
16777215 |
√ |
|
null |
|
|
| chapters |
mediumtext |
16777215 |
√ |
|
null |
|
|
| patron_notes |
mediumtext |
16777215 |
√ |
|
null |
|
|
| status |
enum |
10 |
|
|
PENDING |
|
|
| notes |
mediumtext |
16777215 |
√ |
|
null |
|
|
| created_on |
timestamp |
19 |
|
|
CURRENT_TIMESTAMP |
|
|
| updated_on |
timestamp |
19 |
√ |
|
null |
|
|
Table contained 0 rows at Mon Jul 16 08:37 NZST 2018
|
