| 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 |
|
|
|
| pages |
MEDIUMTEXT |
16777215 |
√ |
|
null |
|
|
|
| chapters |
MEDIUMTEXT |
16777215 |
√ |
|
null |
|
|
|
| patron_notes |
MEDIUMTEXT |
16777215 |
√ |
|
null |
|
|
|
| status |
enum('PENDING', 'PROCESSING', 'COMPLETED', 'CANCELED') |
10 |
|
|
PENDING |
|
|
|
| notes |
MEDIUMTEXT |
16777215 |
√ |
|
null |
|
|
|
| created_on |
TIMESTAMP |
19 |
√ |
|
null |
|
|
Be careful with two timestamps in one table not allowing NULL |
| updated_on |
TIMESTAMP |
19 |
|
|
current_timestamp() |
|
|
|
