| issue_id |
INT |
10 |
|
√ |
null |
|
|
primary key for issues table |
| borrowernumber |
INT |
10 |
√ |
|
null |
|
|
foreign key, linking this to the borrowers table for the patron this item was checked out to |
| issuer_id |
INT |
10 |
√ |
|
null |
|
| borrowers.borrowernumber |
issues_ibfk_borrowers_borrowernumberN |
|
foreign key, linking this to the borrowers table for the user who checked out this item |
| itemnumber |
INT |
10 |
√ |
|
null |
|
| items.itemnumber |
issues_ibfk_2R |
|
foreign key, linking this to the items table for the item that was checked out |
| date_due |
DATETIME |
19 |
√ |
|
null |
|
|
datetime the item is due (yyyy-mm-dd hh:mm::ss) |
| branchcode |
VARCHAR |
10 |
√ |
|
null |
|
|
foreign key, linking to the branches table for the location the item was checked out |
| returndate |
DATETIME |
19 |
√ |
|
null |
|
|
date the item was returned, will be NULL until moved to old_issues |
| lastreneweddate |
DATETIME |
19 |
√ |
|
null |
|
|
date the item was last renewed |
| renewals |
TINYINT |
3 |
|
|
0 |
|
|
lists the number of times the item was renewed |
| unseen_renewals |
TINYINT |
3 |
|
|
0 |
|
|
lists the number of consecutive times the item was renewed without being seen |
