Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
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 |
|
|
foreign key, linking this to the borrowers table for the user who checked out this item |
|||
itemnumber | INT | 10 | √ | null |
|
|
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 | 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 |
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | issue_id |
branchcode_idx | Performance | Asc | branchcode |
old_bordate | Performance | Asc/Asc | borrowernumber + timestamp |
old_issues_ibfk_borrowers_borrowernumber | Performance | Asc | issuer_id |
old_issuesborridx | Performance | Asc | borrowernumber |
old_issuesitemidx | Performance | Asc | itemnumber |