Why not combine them:
userid
username
password
name
type
email
location
usertype enum("admin","staff","rep")
primary key (userid)
No sense in wasting tables when you are repeating data. And this way it's
easier to do authentication.
Since you didn't say that a rep can also be a staff or admin, I'm assuming
they can't. If they can, I suggest a unix file permission type solution:
1 = staff
2 = admin
4 = rep
usertype tinyint
usertype 1 staff
usertype 2 admin
usertype 3 staff, admin
usertype 4 rep
usertype 5 staff, rep
usertype 6 admin, rep
usertype 7 staff, admin, rep
Peter
On Thu, 8 May 2003, shaun wrote:
> Hi,
>
> I have the following tables in my database. A user could be of type Staff,
> Client or Administrators. A client could have many reps. Only staff,
> administrators and reps can log in to the system. I would appreciate your
> comments on this model. Have i modelled this correctly, or should i have a
> seperate table for each user?
>
> Thanks for your help
>
>
> # ---------- MySQL dump ----------
> #
> # Table structure for table 'WMS_Rep'
> #
> CREATE TABLE WMS_Rep (
> Rep_ID int(11) DEFAULT '' NOT NULL auto_increment,
> User_ID int(11) DEFAULT '0' NOT NULL ,
> Rep_Name varchar(40) DEFAULT '' NOT NULL ,
> Rep_Username varchar(20) DEFAULT '' NOT NULL ,
> Rep_Password varchar(20) DEFAULT '' NOT NULL ,
> Rep_Location varchar(40) DEFAULT '' NOT NULL ,
> PRIMARY KEY (Rep_ID,User_ID)
> );
>
> #
> # Table structure for table 'WMS_User'
> #
> CREATE TABLE WMS_User (
> User_ID int(11) DEFAULT '' NOT NULL auto_increment,
> User_Username varchar(20) DEFAULT '' NOT NULL ,
> User_Password varchar(20) DEFAULT '' NOT NULL ,
> User_Name varchar(100) DEFAULT '' NOT NULL ,
> User_Type int(11) DEFAULT '1' NOT NULL ,
> User_Email varchar(70) ,
> User_Location varchar(40) ,
> PRIMARY KEY (User_ID)
> );
>
> # ----------- Dump ends -----------
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
---------------------------------------------------------------------------
Peter Beckman Internet Guy
beckman@purplecow.com http://www.purplecow.com/
---------------------------------------------------------------------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
