Iím planning on building a site somewhat similar to a web hosting directory and was hoping to get some input/advice on the database design from all you coding gurus
Iíd like to have two different types of users: 1) hosts 2) normal users
Because of the this, Iíll need two seperate registration forms (with different fields). Will I require two tables in the db or can I combine them into one? I would also like to allow the host admin to be able to add/edit/delete users associated to that host.
What would be the best way to go about creating the database?
I'm guessing they have some similar fields like name, email etc? If they have I would add the fields that are similar between the two in the same table and the variable fields (eg. fields that are either specific to hosts or normal users) in each of their own table. Then I would just add a foreign key reference from the first table to each of the other two.