Columns
| 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 |
||||
| booking_id | INT | 10 | √ | NULL |
|
|
foreign key linking this checkout to the booking it fulfills |
||||
| 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 |
||||
| checkin_library | VARCHAR | 10 | √ | NULL |
|
|
library the item was checked in at |
||||
| 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 |
|||||
| auto_renew | TINYINT | 3 | √ | 0 |
|
|
automatic renewal |
||||
| auto_renew_error | VARCHAR | 32 | √ | NULL |
|
|
automatic renewal error |
||||
| timestamp | TIMESTAMP | 19 | current_timestamp() |
|
|
the date and time this record was last touched |
|||||
| issuedate | DATETIME | 19 | √ | NULL |
|
|
date the item was checked out or issued |
||||
| onsite_checkout | TINYINT | 3 | 0 |
|
|
in house use flag |
|||||
| note | LONGTEXT | 2147483647 | √ | NULL |
|
|
issue note text |
||||
| notedate | DATETIME | 19 | √ | NULL |
|
|
datetime of issue note (yyyy-mm-dd hh:mm::ss) |
||||
| noteseen | TINYINT | 3 | √ | NULL |
|
|
describes whether checkout note has been seen 1, not been seen 0 or doesn’t exist null |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| old_issues_s_pk | Primary key | Asc | issue_id |
| branchcode_idx | Performance | Asc | branchcode |
| old_bordate | Performance | Asc/Asc | borrowernumber + timestamp |
| old_issues_booking_id_fk | Performance | Asc | booking_id |
| old_issues_ibfk_borrowers_borrowernumber | Performance | Asc | issuer_id |
| old_issuesborridx | Performance | Asc | borrowernumber |
| old_issuesitemidx | Performance | Asc | itemnumber |
| PRIMARY | Must be unique | Asc | issue_id |
Relationships
Close relationships within degrees of separation
