Mysql pil

-- MySQL Workbench Forward Engineering

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

-- -----------------------------------------------------
-- Schema pil_db
-- -----------------------------------------------------

-- -----------------------------------------------------
-- Schema pil_db
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `pil_db` DEFAULT CHARACTER SET utf8 ;
USE `pil_db` ;

-- -----------------------------------------------------
-- Table `pil_db`.`Persoon`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `pil_db`.`Persoon` (
  `Persoon_ID` INT NOT NULL,
  `Persoon_Naam` VARCHAR(45) NULL,
  `Persoon_Leeftijd` INT NULL,
  PRIMARY KEY (`Persoon_ID`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `pil_db`.`Tijdstip`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `pil_db`.`Tijdstip` (
  `Tijdstip_ID` INT NOT NULL,
  `Tijdstip1` TIME NULL,
  `Tijdstip2` TIME NULL,
  `Tijdstip3` TIME NULL,
  PRIMARY KEY (`Tijdstip_ID`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `pil_db`.`Pil`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `pil_db`.`Pil` (
  `Pil_ID` INT NOT NULL,
  `Pil_Naam` VARCHAR(50) NULL,
  `Pil_Beschrijving` VARCHAR(255) NULL,
  `Vakje_Locatie` INT NULL,
  `Tijdstip_ID` INT NOT NULL,
  `Persoon_ID` INT NOT NULL,
  PRIMARY KEY (`Pil_ID`, `Tijdstip_ID`, `Persoon_ID`),
  INDEX `fk_Pil_Persoon1_idx` (`Persoon_ID` ASC),
  INDEX `fk_Pil_Tijdstip1_idx` (`Tijdstip_ID` ASC),
  CONSTRAINT `fk_Pil_Persoon1`
    FOREIGN KEY (`Persoon_ID`)
    REFERENCES `pil_db`.`Persoon` (`Persoon_ID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Pil_Tijdstip1`
    FOREIGN KEY (`Tijdstip_ID`)
    REFERENCES `pil_db`.`Tijdstip` (`Tijdstip_ID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;