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
account_offset_types
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
location varchar 80  √  null authorized value for the shelving location for this item (MARC21 952$c)
borrowernumber int 10  √  null
borrowers
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 Mon Jul 16 09:22 NZST 2018

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: