Re: Please help, table design!
Many companies have multiple addresses, so ...
members(memberid,companyid,name,contactphone,email)
member_addresses(addressid, memberid, ...address columns..., postcode)
postcodes(postcode)
Different offices (addresses) of a company usually cover their own areas, so you need ...
addresses_postcodes(addressid,postcode)
with one row for each address-posttcode coverage.
If the mainly relevant coverage is in relation to companies(members) as a whole, from the above you could generate ...
members_postcodes(memberid,postcode)
with one row for each company-postcode coverage instance.
Subject
Written By
Posted
Re: Please help, table design!
March 27, 2014 11:42AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.