Lines 5360-5365
CREATE TABLE `statistics` (
Link Here
|
5360 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key from the borrowers table, links transaction to a specific borrower', |
5360 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key from the borrowers table, links transaction to a specific borrower', |
5361 |
`ccode` varchar(80) DEFAULT NULL COMMENT 'foreign key from the items table, links transaction to a specific collection code', |
5361 |
`ccode` varchar(80) DEFAULT NULL COMMENT 'foreign key from the items table, links transaction to a specific collection code', |
5362 |
`categorycode` varchar(10) DEFAULT NULL COMMENT 'foreign key from the borrowers table, links transaction to a specific borrower category', |
5362 |
`categorycode` varchar(10) DEFAULT NULL COMMENT 'foreign key from the borrowers table, links transaction to a specific borrower category', |
|
|
5363 |
`interface` varchar(30) DEFAULT NULL COMMENT 'the context this action was taken in', |
5363 |
KEY `timeidx` (`datetime`), |
5364 |
KEY `timeidx` (`datetime`), |
5364 |
KEY `branch_idx` (`branch`), |
5365 |
KEY `branch_idx` (`branch`), |
5365 |
KEY `type_idx` (`type`), |
5366 |
KEY `type_idx` (`type`), |
5366 |
- |
|
|