Curently, statistic table contains some information about the item and the borrower (http://schema.koha-community.org/tables/statistics.html):
For the item :
For the borrower
- and maybe "usercode" (not documented in schemaspy, so I don't know what it means).
I think we should store more information for the borrower : if the borrower record is deleted, we will not be able to get the useful informations (categorycode...) with a JOIN.
I am not sure of Koha's behavior if the item or biblio is deleted : if the itemnumber and biblionumber is deleted from statistic table, we could also store more information (as homebranch, location, biblio.serial, biblioitems.itemtype)
For the borrowers, I think we need :
and optionally the ability to record 3 or 4 custom fields with a syspref (for example, to store the extended attributes).
Do you agree with that ?
*** This bug has been marked as a duplicate of bug 7021 ***