Table Structure

From: john <nospam_at_nospam.com>
Date: Thu, 8 May 2003 19:07:41 +0100
Message-ID: <k0xua.15001$xd5.860923_at_stones.force9.net>

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 -----------
Received on Thu May 08 2003 - 20:07:41 CEST