This patch documents the statistics table. A few fields were left undocumented.
'other' - unclear what this is used for 'proccode' - unclear what the number entered in this field stands for 'usercode' - always NULL on my system 'associatedborrower' - always NULL on my system Signed-off-by: Nicole C. Engard <[email protected]> --- installer/data/mysql/kohastructure.sql | 18 +++++++++--------- 1 files changed, 9 insertions(+), 9 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index e9edf25..2e29eb5 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1695,17 +1695,17 @@ CREATE TABLE `special_holidays` ( -- DROP TABLE IF EXISTS `statistics`; -CREATE TABLE `statistics` ( - `datetime` datetime default NULL, - `branch` varchar(10) default NULL, - `proccode` varchar(4) default NULL, - `value` double(16,4) default NULL, - `type` varchar(16) default NULL, +CREATE TABLE `statistics` ( -- information related to transactions (circulation and fines) in Koha + `datetime` datetime default NULL, -- date and time of the transaction + `branch` varchar(10) default NULL, -- foreign key, branch where the transaction occurred + `proccode` varchar(4) default NULL, -- proceedure code + `value` double(16,4) default NULL, -- monetary value associated with the transaction + `type` varchar(16) default NULL, -- transaction type (locause, issue, return, renew, writeoff, payment, Credit*) `other` mediumtext, `usercode` varchar(10) default NULL, - `itemnumber` int(11) default NULL, - `itemtype` varchar(10) default NULL, - `borrowernumber` int(11) default NULL, + `itemnumber` int(11) default NULL, -- foreign key from the items table, links transaction to a specific item + `itemtype` varchar(10) default NULL, -- foreign key from the itemtypes table, links transaction to a specific item type + `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table, links transaction to a specific borrower `associatedborrower` int(11) default NULL, KEY `timeidx` (`datetime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 1.7.2.3 _______________________________________________ Koha-patches mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-patches website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
