https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18218 Bug ID: 18218 Summary: Contact information (borrower, branch, acquisitions), should be centralized into a single 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@gmail.com Reporter: barton@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org The borrowers table contains three sets of contact information -- primary (streetnumber, streettype, address, etc... no prefix), secondary (B_streetnumber, B_streettype, etc) and alternate (altcontactaddress1, altcontactaddress2, etc.)... there are also the emailpro and phonepro fields. These should be moved into a 'contacts' table. I think that it would be reasonable to re-factor the aqcontacts table so that generic contact information was in the contacts table, as well as pulling branch contact information into contacts as well. -- You are receiving this mail because: You are watching all bug changes.