CREATE TABLE IF NOT EXISTS `Departements`
(
  `code` int PRIMARY KEY,
  `nom` char(20) UNIQUE,
  `directeur` char(5) NOT NULL
);

CREATE TABLE IF NOT EXISTS `Profs` (
  `idul` char(5) PRIMARY KEY,
  `nom` char(20),
  `age` int
);

CREATE TABLE IF NOT EXISTS `Affiliations` (
  `idul` char(5),
  `code` int,
  `depuis` date,
  CONSTRAINT
  	FOREIGN KEY (`idul`)
  	REFERENCES `Profs`(`idul`)
    ON DELETE CASCADE,
  CONSTRAINT
  	FOREIGN KEY (`code`)
  	REFERENCES `Departements`(`code`)
);