database design help ??
Posted: Sat Sep 13, 2008 11:08 pm
Hello forums !!
I would like to know the idea regarding db design for the following case:
CASE:
There are three types of users(say Customer, Business User and Personnel)
They have some parts common like first name, last name, email etc. Users like business user and personnel
have login access and permission types.
I would like to know:
1> whether to design three tables for the three types of users with all the required fields.
2> or one table with extra field user_type (for common fields). and other table for login infos and permission types.
Which one is better and why ? I would like to know the opinions of the forumians.
I would like to know the idea regarding db design for the following case:
CASE:
There are three types of users(say Customer, Business User and Personnel)
They have some parts common like first name, last name, email etc. Users like business user and personnel
have login access and permission types.
I would like to know:
1> whether to design three tables for the three types of users with all the required fields.
2> or one table with extra field user_type (for common fields). and other table for login infos and permission types.
Which one is better and why ? I would like to know the opinions of the forumians.