Re: Help designing a relationship.

[Peter Brawley]

create table employees(id int primary key,...) engine=innodb;
create table parttimers(
  id int primary key,
  employeeID int, 
  key(employeeID),
  foreign key(employeeID) references employees(ID),...
) engine=innodb;
create table fulltimers(
  id int primary key,
  employeeID int, 
  key(employeeID),
  foreign key(employeeID) references employees(ID),...
) engine=innodb;

PB
http://www.artfulsoftware.com