Table testsql_comments.statistics Generated by
SchemaSpy
Legend: SourceForge.net
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
datetime datetime 19  √  null date and time of the transaction
branch varchar 10  √  null foreign key, branch where the transaction occurred
proccode varchar 4  √  null type of procedure used when making payments (does not appear in the code)
value double 16,4  √  null monetary value associated with the transaction
type varchar 16  √  null transaction type (locause, issue, return, renew, writeoff, payment, Credit*)
other mediumtext 16777215  √  null used by SIP
usercode varchar 10  √  null unused in Koha
itemnumber int 10  √  null
hold_fill_targets
foreign key from the items table, links transaction to a specific item
itemtype varchar 10  √  null
itemtypes
foreign key from the itemtypes table, links transaction to a specific item type
borrowernumber int 10  √  null
patronimage
foreign key from the borrowers table, links transaction to a specific borrower
associatedborrower int 10  √  null unused in Koha
ccode varchar 10  √  null foreign key from the items table, links transaction to a specific collection code

Table contained 0 rows at Tue Dec 27 18:01 NZDT 2016

Indexes:
Column(s) Type Sort
associatedborrower Performance Asc
borrowernumber Performance Asc
branch Performance Asc
ccode Performance Asc
itemnumber Performance Asc
itemtype Performance Asc
proccode Performance Asc
datetime Performance Asc
type Performance Asc
usercode Performance Asc

Close relationships: