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
