• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Help with database design?

#2
[eluser]brianw1975[/eluser]
I would have multiple tables, but not the way you are probably thinking.

I would have:
host_accounts table with id, username, host_name, url, etc,etc
user_accounts table with id, username, password, accounts_type_id
account_types table with id, description, access_level
host_accounts table with id, host_accounts_id, user_accounts_id

you could take this a step or two further (give me some slack, it's a bit late) with

user_account_types table with id, user_accounts_id, accounts_type_id

doing that would require removing account_type_id from the above user_accounts table

anyways, hope that helps and if you need more info I'll be happy to assist; you'll probably get a few more suggestions on how to do it.


Messages In This Thread
Help with database design? - by El Forum - 02-12-2009, 11:19 PM
Help with database design? - by El Forum - 02-13-2009, 12:07 AM
Help with database design? - by El Forum - 02-13-2009, 06:43 AM
Help with database design? - by El Forum - 02-13-2009, 01:14 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.