| 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 |
old_issues_ibfk_borrowers_borrowernumber |
N |
|
foreign key, linking this to the borrowers table for the user who checked out this item |
| itemnumber |
INT |
10 |
√ |
|
null |
|
| items.itemnumber |
old_issues_ibfk_2 |
N |
|
foreign key, linking this to the items table for the item that was checked out |
| date_due |
DATETIME |
19 |
√ |
|
null |
|
|
date the item is due (yyyy-mm-dd) |
| 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 |
| lastreneweddate |
DATETIME |
19 |
√ |
|
null |
|
|
date the item was last renewed |
| renewals_count |
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 |
