Table Structure
| From: | shaun | Date: | Thu, 08 May 2003 18:07:11 +0000 |
| Subject: | Table Structure | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-27590@lists.php.net to get a copy of this message | ||
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 -----------