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 |
|
|
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 |
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | issue_id |
bordate | Performance | Asc/Asc | borrowernumber + timestamp |
branchcode_idx | Performance | Asc | branchcode |
issues_ibfk_borrowers_borrowernumber | Performance | Asc | issuer_id |
issuesborridx | Performance | Asc | borrowernumber |
itemnumber | Must be unique | Asc | itemnumber |
itemnumber_idx | Performance | Asc | itemnumber |