Table testsql_comments.statistics
information related to transactions (circulation and fines) in Koha

 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.itemnumber Implied Constraint R
foreign key from the items table, links transaction to a specific item
itemtype varchar 10  √  null
itemtypes.itemtype Implied Constraint R
foreign key from the itemtypes table, links transaction to a specific item type
borrowernumber int 10  √  null
patronimage.borrowernumber Implied Constraint R
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 17:18 NZDT 2016

Indexes:
Column(s) Type Sort Constraint Name
associatedborrower Performance Asc associatedborrower_idx
borrowernumber Performance Asc borrowernumber_idx
branch Performance Asc branch_idx
ccode Performance Asc ccode_idx
itemnumber Performance Asc itemnumber_idx
itemtype Performance Asc itemtype_idx
proccode Performance Asc proccode_idx
datetime Performance Asc timeidx
type Performance Asc type_idx
usercode Performance Asc usercode_idx

Close relationships: