CREATE TABLE PROJECT (
  ID_INTERNAL int(11) NOT NULL auto_increment,
  START_DATE varchar(10),
  END_DATE varchar(10),
  STATUS varchar(50),
  PRIMARY KEY (ID_INTERNAL)
) Type=InnoDB;

CREATE TABLE PROJECT_RESEARCHER (
  ID_INTERNAL int(11) NOT NULL auto_increment,
  KEY_RESEARCHER int(11) NOT NULL,
  KEY_PROJECT int(11) NOT NULL,
  PRIMARY KEY (ID_INTERNAL),
  UNIQUE KEY (KEY_RESEARCHER, KEY_PROJECT)
) Type=InnoDB;

CREATE TABLE PROJECT_UNIT (
  ID_INTERNAL int(11) NOT NULL auto_increment,
  KEY_UNIT int(11) NOT NULL,
  KEY_PROJECT int(11) NOT NULL,
  PRIMARY KEY (ID_INTERNAL),
  UNIQUE KEY (KEY_UNIT, KEY_PROJECT)
) Type=InnoDB;