[eluser]Unknown[/eluser]
Okay guys, I have a project I'm helping a friend out with and we're wanting to allow users to logon and based on their location and current provider, display a list of service plan options and rates (lets just say long distance service for topical purposes).
I'm struggling to design the database to accomodate these features. So far I have the following tables:
- states (id, name, abbreviation) :
- providers (id, name, logo, etc) :
- provider_plans (id, state_id, provider_id, name, details, etc) :
Now, since not only will the criteria be based on state, but also their current local provider, will I need a table of local providers and then another table to associate the state and local provider to the available plans to display? Or how would you guys best solve this issue?
I hope I haven't ran around in circles here and made this somewhat understandable. I will be checking this thread often so if I need to clear anything up just ask.
Thanks so much,
-phear