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
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
itemnumber INT 10 √ null

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
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
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)
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
timeidx Performance Asc datetime
type_idx Performance Asc type

Relationships

Close relationships within degrees of separation