Bug 18218 - Contact information (borrower, branch, acquisitions), should be centralized into a single table
Summary: Contact information (borrower, branch, acquisitions), should be centralized i...
Status: RESOLVED DUPLICATE of bug 17230
Alias: None
Product: Koha
Classification: Unclassified
Component: Architecture, internals, and plumbing (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Galen Charlton
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-03-06 16:38 UTC by Barton Chittenden
Modified: 2020-01-11 23:20 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Barton Chittenden 2017-03-06 16:38:12 UTC
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.
Comment 1 Katrin Fischer 2020-01-11 23:20:02 UTC

*** This bug has been marked as a duplicate of bug 17230 ***