[Koha-bugs] [Bug 10778] New: Store more information in statistics table

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

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

            Bug ID: 10778
           Summary: Store more information in statistics table
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Architecture, internals, and plumbing
          Assignee: gmcharlt at gmail.com
          Reporter: mathieu.saby at univ-rennes2.fr
        QA Contact: testopia at bugs.koha-community.org

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 watching all bug changes.