Lines 6056-6061
CREATE TABLE `statistics` (
Link Here
|
6056 |
`value` double(16,4) DEFAULT NULL COMMENT 'monetary value associated with the transaction', |
6056 |
`value` double(16,4) DEFAULT NULL COMMENT 'monetary value associated with the transaction', |
6057 |
`type` varchar(16) DEFAULT NULL COMMENT 'transaction type (localuse, issue, return, renew, writeoff, payment)', |
6057 |
`type` varchar(16) DEFAULT NULL COMMENT 'transaction type (localuse, issue, return, renew, writeoff, payment)', |
6058 |
`other` longtext DEFAULT NULL COMMENT 'used by SIP', |
6058 |
`other` longtext DEFAULT NULL COMMENT 'used by SIP', |
|
|
6059 |
`illrequest_id` int(11) DEFAULT NULL COMMENT 'foreign key from the illrequests table, links transaction to a specific illrequest', |
6059 |
`itemnumber` int(11) DEFAULT NULL COMMENT 'foreign key from the items table, links transaction to a specific item', |
6060 |
`itemnumber` int(11) DEFAULT NULL COMMENT 'foreign key from the items table, links transaction to a specific item', |
6060 |
`itemtype` varchar(10) DEFAULT NULL COMMENT 'foreign key from the itemtypes table, links transaction to a specific item type', |
6061 |
`itemtype` varchar(10) DEFAULT NULL COMMENT 'foreign key from the itemtypes table, links transaction to a specific item type', |
6061 |
`location` varchar(80) DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)', |
6062 |
`location` varchar(80) DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)', |
Lines 6066-6071
CREATE TABLE `statistics` (
Link Here
|
6066 |
KEY `timeidx` (`datetime`), |
6067 |
KEY `timeidx` (`datetime`), |
6067 |
KEY `branch_idx` (`branch`), |
6068 |
KEY `branch_idx` (`branch`), |
6068 |
KEY `type_idx` (`type`), |
6069 |
KEY `type_idx` (`type`), |
|
|
6070 |
KEY `illrequest_idx` (`illrequest_id`), |
6069 |
KEY `itemnumber_idx` (`itemnumber`), |
6071 |
KEY `itemnumber_idx` (`itemnumber`), |
6070 |
KEY `itemtype_idx` (`itemtype`), |
6072 |
KEY `itemtype_idx` (`itemtype`), |
6071 |
KEY `borrowernumber_idx` (`borrowernumber`), |
6073 |
KEY `borrowernumber_idx` (`borrowernumber`), |
6072 |
- |
|
|