[Koha-bugs] [Bug 7021] patron category in the statistics table

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7021

--- Comment #5 from mathieu saby <mathieu.saby at univ-rennes2.fr> ---
I copy the content of the bug Bug 10778 and close it, as it is a duplicate
Mathieu

Curently, statistic table contains some information about the item and the
borrower (http://schema.koha-community.org/tables/statistics.html):
For the item : 
- itemnumber
- itemtype
- ccode
For the borrower
- borrowernumber
- associatedborrower
- 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 :
- categorycode
- branchcode
- sex
- sort1
- sort2
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 ?

M. Saby

-- 
You are receiving this mail because:
You are the QA Contact for the bug.
You are watching all bug changes.