Lines 1850-1856
CREATE TABLE `statistics` ( -- information related to transactions (circulation
Link Here
|
1850 |
`itemtype` varchar(10) default NULL, -- foreign key from the itemtypes table, links transaction to a specific item type |
1850 |
`itemtype` varchar(10) default NULL, -- foreign key from the itemtypes table, links transaction to a specific item type |
1851 |
`borrowernumber` int(11) default NULL, -- foreign key from the borrowers table, links transaction to a specific borrower |
1851 |
`borrowernumber` int(11) default NULL, -- foreign key from the borrowers table, links transaction to a specific borrower |
1852 |
`associatedborrower` int(11) default NULL, |
1852 |
`associatedborrower` int(11) default NULL, |
1853 |
`ccode` int(11) default NULL, -- foreign key from the items table, links transaction to a specific collection code |
1853 |
`ccode` varchar(10) default NULL, -- foreign key from the items table, links transaction to a specific collection code |
1854 |
KEY `timeidx` (`datetime`) |
1854 |
KEY `timeidx` (`datetime`) |
1855 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
1855 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
1856 |
|
1856 |
|