Table testsql_comments.issues Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
issue_id int 10  √ 
accountlines.issue_id Implied Constraint R
old_issues.issue_id Implied Constraint R
primary key for issues table
borrowernumber int 10  √  null
borrowers.borrowernumber issues_ibfk_1 R
foreign key, linking this to the borrowers table for the patron this item was checked out to
itemnumber int 10  √  null
items.itemnumber issues_ibfk_2 R
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
refund_lost_item_fee_rules.branchcode Implied Constraint R
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  √  null lists the number of times the item was renewed
auto_renew bit 0  √  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 int 10 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)

Table contained 0 rows at Mon Jul 16 08:37 NZST 2018

Column(s) Type Sort Constraint Name Anomalies
issue_id Primary key Asc PRIMARY  
borrowernumber + timestamp Performance Asc/Asc bordate  
branchcode Performance Asc branchcode_idx  
borrowernumber Performance Asc issuesborridx  
itemnumber Must be unique Asc itemnumber This unique column is also nullable
itemnumber Performance Asc itemnumber_idx  

Close relationships  within of separation: