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

[bugzilla-daemon]

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

Katrin Fischer  changed:

   What|Removed |Added

 CC||katrin.fisc...@bsz-bw.de

--- Comment #4 from Katrin Fischer  ---
Bug 18218 suggested to remodel the aqcontacts table for this.

-- 
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
https://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/

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

[bugzilla-daemon]

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

--- Comment #3 from Katrin Fischer  ---
*** Bug 18218 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
https://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/

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

[bugzilla-daemon]

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

--- Comment #2 from Barton Chittenden  ---
(In reply to Barton Chittenden from comment #0)
> 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.

alt* is actually altcontact*.

Other borrower contact fields:

mobile
fax
emailpro
phonepro
smsalertnumber
sms_provider_id

Contact fields from other tables:

aqbooksellers:

address1
address2
address3
address4
phone
booksellerfax
bookselleremail
booksellerurl
postal
url
fax

branches:

branchaddress1
branchaddress2
branchaddress3
branchzip
branchcity
branchstate
branchcountry
branchphone
branchfax
branchemail
branchreplyto
branchreturnpath
branchurl 
geolocation (?)

This will require us to use a contact_id and some linking tables
(borrower_contact_link, branch_contact_link, aqbooksellers_contact_link)

-- 
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
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/

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

[bugzilla-daemon]

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

Fridolin SOMERS  changed:

   What|Removed |Added

 CC||fridolin.som...@biblibre.co
   ||m

--- Comment #1 from Fridolin SOMERS  ---
Nice idea, more relational database indeed

-- 
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
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/