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