You all seem very knowledgable on this forum, so I thought you may be able to help me out.
My problem is this....
I have designed the following tables
userid - pk
contactid - fk
typeid - fk
addressid - pk
contactid - pk
typeid - pk
businessid - pk
addressid - fk
contaactid - fk
my problem is that i,m not sure how to complete the last relationship,which is between the users, adresses and usertype. You see, not every user will need an address, this in itself is dependant on the usertype.
There are 3 options at present..
public user (this is a person that will only ever enter data once,but needs an address)
business user (this is a person that will enter data in future tables not supplied, the address will be taken from the root business users address)
root business user (this is the person that will setup the account and have the rights to create new users that can post details on a website)
Now should I just add an addressid field to the users table and axcept null entries or is there a better way?
BTW this will be setup with the mySQL database.
Hope all that makes sense, and I hope someone out there can help.
Thx in advance