|
Lines 1996-2002
CREATE TABLE `statistics` ( -- information related to transactions (circulation
Link Here
|
| 1996 |
`branch` varchar(10) default NULL, -- foreign key, branch where the transaction occurred |
1996 |
`branch` varchar(10) default NULL, -- foreign key, branch where the transaction occurred |
| 1997 |
`proccode` varchar(4) default NULL, -- type of procedure used when making payments (does not appear in the code) |
1997 |
`proccode` varchar(4) default NULL, -- type of procedure used when making payments (does not appear in the code) |
| 1998 |
`value` double(16,4) default NULL, -- monetary value associated with the transaction |
1998 |
`value` double(16,4) default NULL, -- monetary value associated with the transaction |
| 1999 |
`type` varchar(16) default NULL, -- transaction type (locause, issue, return, renew, writeoff, payment, Credit*) |
1999 |
`type` varchar(16) default NULL, -- transaction type (localuse, issue, return, renew, writeoff, payment) |
| 2000 |
`other` LONGTEXT, -- used by SIP |
2000 |
`other` LONGTEXT, -- used by SIP |
| 2001 |
`usercode` varchar(10) default NULL, -- unused in Koha |
2001 |
`usercode` varchar(10) default NULL, -- unused in Koha |
| 2002 |
`itemnumber` int(11) default NULL, -- foreign key from the items table, links transaction to a specific item |
2002 |
`itemnumber` int(11) default NULL, -- foreign key from the items table, links transaction to a specific item |
| 2003 |
- |
|
|