-- 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 mydb
-- -----------------------------------------------------

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

-- -----------------------------------------------------
-- Table `mydb`.`Job`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Job` (
  `idJob` INT NOT NULL AUTO_INCREMENT,
  `dateofjoining` INT NOT NULL COMMENT 'дате поступления на работу',
  `dateofdismissal` INT NOT NULL,
  `Job` VARCHAR(100) NOT NULL COMMENT 'месте работы',
  `reasondismissal` VARCHAR(100) NOT NULL COMMENT 'причина увольнения',
  PRIMARY KEY (`idJob`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`Anketa`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Anketa` (
  `idAnketa` INT NOT NULL AUTO_INCREMENT COMMENT 'Анкета',
  `data` INT NOT NULL COMMENT 'дата  рождения',
  `Pasportdannie` INT NOT NULL COMMENT 'паспортные данные',
  `FIO` VARCHAR(100) NOT NULL COMMENT 'ФИО',
  `personalqualities` VARCHAR(100) NOT NULL COMMENT 'личные качества и характеристики',
  `dateofentry` INT NOT NULL COMMENT 'дату занесения',
  `placeofbirth` VARCHAR(45) NOT NULL COMMENT 'место рождения\n',
  `Job_idJob` INT NOT NULL,
  PRIMARY KEY (`idAnketa`, `Job_idJob`),
  INDEX `fk_Anketa_Job_idx` (`Job_idJob` ASC),
  CONSTRAINT `fk_Anketa_Job`
    FOREIGN KEY (`Job_idJob`)
    REFERENCES `mydb`.`Job` (`idJob`)
    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;