statistics


Columns

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.type Implied Constraint R

transaction type (localuse, issue, return, renew, writeoff, payment)
other LONGTEXT 2147483647 √ null

used by SIP
usercode VARCHAR 10 √ null

unused in Koha
itemnumber INT 10 √ null

foreign key from the items table, links transaction to a specific item
itemtype VARCHAR 10 √ null

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

foreign key from the borrowers table, links transaction to a specific borrower
associatedborrower INT 10 √ null

unused in Koha
ccode VARCHAR 80 √ null

foreign key from the items table, links transaction to a specific collection code

Table contained 0 rows

Indexes

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

Relationships

Close relationships within degrees of separation