-- 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='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------
-- -----------------------------------------------------
-- Schema practicum_week_1
-- -----------------------------------------------------

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

-- -----------------------------------------------------
-- Table `practicum_week_1`.`gebouw`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `practicum_week_1`.`gebouw` (
  `gebouwcode` VARCHAR(25) NOT NULL,
  `locatie` VARCHAR(45) NULL DEFAULT NULL,
  PRIMARY KEY (`gebouwcode`),
  UNIQUE INDEX `gebouwcode_UNIQUE` (`gebouwcode` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `practicum_week_1`.`afdeling`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `practicum_week_1`.`afdeling` (
  `afdelingcode` VARCHAR(25) NOT NULL,
  `naam` VARCHAR(45) NULL DEFAULT NULL,
  `gebouwcode` VARCHAR(45) NULL DEFAULT NULL,
  PRIMARY KEY (`afdelingcode`),
  UNIQUE INDEX `afdelingcode_UNIQUE` (`afdelingcode` ASC) VISIBLE,
  INDEX `gebouwcode_idx` (`gebouwcode` ASC) VISIBLE,
  CONSTRAINT `gebouwcode`
    FOREIGN KEY (`gebouwcode`)
    REFERENCES `practicum_week_1`.`gebouw` (`gebouwcode`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `practicum_week_1`.`chef`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `practicum_week_1`.`chef` (
  `chef_id` INT(11) NOT NULL AUTO_INCREMENT,
  `vanaf` DATE NULL DEFAULT NULL,
  `tot` DATE NULL DEFAULT NULL,
  `naam` VARCHAR(45) NULL DEFAULT NULL,
  PRIMARY KEY (`chef_id`),
  UNIQUE INDEX `naam_UNIQUE` (`chef_id` ASC) VISIBLE)
ENGINE = InnoDB
AUTO_INCREMENT = 10
DEFAULT CHARACTER SET = utf8;


-- -----------------------------------------------------
-- Table `practicum_week_1`.`werknemers`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `practicum_week_1`.`werknemers` (
  `personeelsnr` INT(11) NOT NULL,
  `naam` VARCHAR(45) NULL DEFAULT NULL,
  `afdelingcode` VARCHAR(25) NULL DEFAULT NULL,
  `chef_id` INT(11) NULL DEFAULT NULL,
  PRIMARY KEY (`personeelsnr`),
  UNIQUE INDEX `personeelsnr_UNIQUE` (`personeelsnr` ASC) VISIBLE,
  INDEX `afdelingcode_idx` (`afdelingcode` ASC) VISIBLE,
  INDEX `id_idx` (`naam` ASC) VISIBLE,
  INDEX `chef_id_idx` (`chef_id` ASC) VISIBLE,
  CONSTRAINT `afdelingcode`
    FOREIGN KEY (`afdelingcode`)
    REFERENCES `practicum_week_1`.`afdeling` (`afdelingcode`),
  CONSTRAINT `chef_id`
    FOREIGN KEY (`chef_id`)
    REFERENCES `practicum_week_1`.`chef` (`chef_id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;


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