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: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
