[Koha-bugs] [Bug 17230] New: borrowers table should be better normalized

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17230

            Bug ID: 17230
           Summary: borrowers table should be better normalized
 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: barton at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org

I've always been bothered by the fact that we have 3 separate sets of contact
information in the borrowers table:

streetnumber    
streettype                
address    
address2    
city    
state    
zipcode    
country    
email    
phone    

B_streetnumber
B_streettype
B_address
B_address2
B_city
B_state
B_zipcode
B_country
B_email
B_phone

altstreetnumber
altstreettype
altaddress
altaddress2
altcity
altstate
altzipcode
altcountry
altemail
altphone

These should be moved to a contacts table, which contains a 'contact_type'
field corresponding to 'primary', 'B_' or 'alt' (although these also
desperately need to be renamed), as well as a link to the borrower and a
timestamp.

-- 
You are receiving this mail because:
You are watching all bug changes.