Hello all,
I've got a few questions about setting up a data model for a database I'm
creating. I want to set it up to be most efficient and would like input
from anyone that has the time.
I'm setting up your basic customer database, except I'd like to allow for a
customer within a customer option. Not everyone will have this, but for
those that choose to, it will be available.
Here is basically what I have:
1) I'm a web hosting company and would like for each customer to have the
ability to have multiple domains under their account. (this is the easy
part, just a basic customer database)
2) Each domain however will need the ability to have up to 3 addresses
associated with it. For example, Administrative, Technical and Billing
Contacts.
Now, the question is how do I set this up to be the most efficient storage
of the data?
My thought is
Main Customer Table
|
|
----------------Domain Table
|
|
TechAddress Table---------- ----------AdminAddress Table
|
|
BillingAddress Table
Am I way off here?
I will be checking for things like if each of the addresses being entered
are the same as the main address in the main customer table.
I know this is very confusing. Can someone please help?
Thanks,
Kevin
[EMAIL PROTECTED]
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
