Lines 4937-4943
CREATE TABLE `statistics` (
Link Here
|
4937 |
`location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)', |
4937 |
`location` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'authorized value for the shelving location for this item (MARC21 952$c)', |
4938 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key from the borrowers table, links transaction to a specific borrower', |
4938 |
`borrowernumber` int(11) DEFAULT NULL COMMENT 'foreign key from the borrowers table, links transaction to a specific borrower', |
4939 |
`ccode` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key from the items table, links transaction to a specific collection code', |
4939 |
`ccode` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key from the items table, links transaction to a specific collection code', |
4940 |
`categorycode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, |
4940 |
`categorycode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'foreign key from the borrowers table, links transaction to a specific borrower category',, |
4941 |
KEY `timeidx` (`datetime`), |
4941 |
KEY `timeidx` (`datetime`), |
4942 |
KEY `branch_idx` (`branch`), |
4942 |
KEY `branch_idx` (`branch`), |
4943 |
KEY `type_idx` (`type`), |
4943 |
KEY `type_idx` (`type`), |
4944 |
- |
|
|