-- MySQL Script generated by MySQL Workbench
-- Fri Feb 25 16:01:58 2022
-- Model: New Model    Version: 1.0
-- 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 mse
-- -----------------------------------------------------

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

-- -----------------------------------------------------
-- Table `mse`.`mse`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`mse` (
  `mse_id` INT NOT NULL,
  `mse_description` VARCHAR(2000) NULL,
  `mse_number` INT NULL,
  PRIMARY KEY (`mse_id`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mse`.`status`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`status` (
  `status_id` INT NOT NULL,
  `status_description` VARCHAR(2000) NULL,
  `status_code` VARCHAR(45) NULL,
  PRIMARY KEY (`status_id`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mse`.`mission_analysis`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`mission_analysis` (
  `mission_analysis_id` INT NOT NULL,
  `mission_analysis_description` VARCHAR(2000) NULL,
  `mse_id` INT NULL,
  PRIMARY KEY (`mission_analysis_id`),
  INDEX `mse_id_idx` (`mse_id` ASC),
  CONSTRAINT `mse_id`
    FOREIGN KEY (`mse_id`)
    REFERENCES `mse`.`mse` (`mse_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mse`.`task`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`task` (
  `task_id` INT NOT NULL,
  `task_description` VARCHAR(2000) NULL,
  `mse_id` INT NULL,
  PRIMARY KEY (`task_id`),
  INDEX `mse_id_idx` (`mse_id` ASC),
  CONSTRAINT `mse_id`
    FOREIGN KEY (`mse_id`)
    REFERENCES `mse`.`mse` (`mse_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mse`.`implied_task`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`implied_task` (
  `implied_task_id` INT NOT NULL,
  `implied_task_description` VARCHAR(2000) NULL,
  `status_id` INT NULL,
  `mse_id` INT NULL,
  PRIMARY KEY (`implied_task_id`),
  INDEX `mse_id_idx` (`mse_id` ASC),
  INDEX `status_id_idx` (`status_id` ASC),
  CONSTRAINT `status_id`
    FOREIGN KEY (`status_id`)
    REFERENCES `mse`.`status` (`status_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `mse_id`
    FOREIGN KEY (`mse_id`)
    REFERENCES `mse`.`mse` (`mse_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mse`.`specific_task`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`specific_task` (
  `specific_task_id` INT NOT NULL,
  `specific_task_description` VARCHAR(2000) NULL,
  `status_id` INT NULL,
  `mse_id` INT NULL,
  PRIMARY KEY (`specific_task_id`),
  INDEX `status_id_idx` (`status_id` ASC),
  INDEX `mse_id_idx` (`mse_id` ASC),
  CONSTRAINT `status_id`
    FOREIGN KEY (`status_id`)
    REFERENCES `mse`.`status` (`status_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `mse_id`
    FOREIGN KEY (`mse_id`)
    REFERENCES `mse`.`mse` (`mse_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mse`.`essential_task`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`essential_task` (
  `essential_task_id` INT NOT NULL,
  `essential_task_description` VARCHAR(45) NULL,
  `status_id` INT NULL,
  `mse_id` INT NULL,
  PRIMARY KEY (`essential_task_id`),
  INDEX `status_id_idx` (`status_id` ASC),
  INDEX `mse_id_idx` (`mse_id` ASC),
  CONSTRAINT `status_id`
    FOREIGN KEY (`status_id`)
    REFERENCES `mse`.`status` (`status_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `mse_id`
    FOREIGN KEY (`mse_id`)
    REFERENCES `mse`.`mse` (`mse_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mse`.`mission_objective`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`mission_objective` (
  `mission_objective_id` INT NOT NULL,
  `mission_objective_description` VARCHAR(2000) NULL,
  `mse_id` INT NULL,
  PRIMARY KEY (`mission_objective_id`),
  INDEX `mse_id_idx` (`mse_id` ASC),
  CONSTRAINT `mse_id`
    FOREIGN KEY (`mse_id`)
    REFERENCES `mse`.`mse` (`mse_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mse`.`who`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`who` (
  `who_id` INT NOT NULL,
  `who_description` VARCHAR(250) NULL,
  `mse_id` INT NULL,
  PRIMARY KEY (`who_id`),
  INDEX `mse_id_idx` (`mse_id` ASC),
  CONSTRAINT `mse_id`
    FOREIGN KEY (`mse_id`)
    REFERENCES `mse`.`mse` (`mse_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mse`.`what`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`what` (
  `what_id` INT NOT NULL,
  `what_description` VARCHAR(250) NULL,
  `mse_id` INT NULL,
  PRIMARY KEY (`what_id`),
  INDEX `mse_id_idx` (`mse_id` ASC),
  CONSTRAINT `mse_id`
    FOREIGN KEY (`mse_id`)
    REFERENCES `mse`.`mse` (`mse_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mse`.`when`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`when` (
  `when_id` INT NOT NULL,
  `when_description` VARCHAR(250) NULL,
  `when_date` DATETIME NULL,
  `mse_id` INT NULL,
  PRIMARY KEY (`when_id`),
  INDEX `mse_id_idx` (`mse_id` ASC),
  CONSTRAINT `mse_id`
    FOREIGN KEY (`mse_id`)
    REFERENCES `mse`.`mse` (`mse_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mse`.`where`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`where` (
  `where_id` INT NOT NULL,
  `where_description` VARCHAR(250) NULL,
  `where_loglat` VARCHAR(250) NULL,
  `mse_id` INT NULL,
  PRIMARY KEY (`where_id`),
  INDEX `mse_id_idx` (`mse_id` ASC),
  CONSTRAINT `mse_id`
    FOREIGN KEY (`mse_id`)
    REFERENCES `mse`.`mse` (`mse_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mse`.`why`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`why` (
  `why_id` INT NOT NULL,
  `why_description` VARCHAR(250) NULL,
  `mse_id` INT NULL,
  PRIMARY KEY (`why_id`),
  INDEX `mse_id_idx` (`mse_id` ASC),
  CONSTRAINT `mse_id`
    FOREIGN KEY (`mse_id`)
    REFERENCES `mse`.`mse` (`mse_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mse`.`mission_summary`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`mission_summary` (
  `idmission_summary` INT NOT NULL,
  `mission_summary_description` VARCHAR(250) NULL,
  `mse_id` INT NULL,
  PRIMARY KEY (`idmission_summary`),
  INDEX `mse_id_idx` (`mse_id` ASC),
  CONSTRAINT `mse_id`
    FOREIGN KEY (`mse_id`)
    REFERENCES `mse`.`mse` (`mse_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mse`.`situation_analysis`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`situation_analysis` (
  `situation_analysis_id` INT NOT NULL,
  `situation_analysis_description` VARCHAR(2000) NULL,
  `mse_id` INT NULL,
  PRIMARY KEY (`situation_analysis_id`),
  INDEX `mse_id_idx` (`mse_id` ASC),
  CONSTRAINT `mse_id`
    FOREIGN KEY (`mse_id`)
    REFERENCES `mse`.`mse` (`mse_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mse`.`coa_dev`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`coa_dev` (
  `coa_dev_id` INT NOT NULL,
  `coa_dev_description` VARCHAR(2000) NULL,
  `mse_id` INT NULL,
  PRIMARY KEY (`coa_dev_id`),
  INDEX `mse_id_idx` (`mse_id` ASC),
  CONSTRAINT `mse_id`
    FOREIGN KEY (`mse_id`)
    REFERENCES `mse`.`mse` (`mse_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mse`.`add_doc`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`add_doc` (
  `add_doc_id` INT NOT NULL,
  `add_doc_filename` VARCHAR(250) NULL,
  `add_doc_description` VARCHAR(250) NULL,
  `mse_id` INT NULL,
  `add_doc_location` VARCHAR(250) NULL,
  PRIMARY KEY (`add_doc_id`),
  INDEX `mse_id_idx` (`mse_id` ASC),
  CONSTRAINT `mse_id`
    FOREIGN KEY (`mse_id`)
    REFERENCES `mse`.`mse` (`mse_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mse`.`analysis_adversary`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`analysis_adversary` (
  `analysis_adversary_id` INT NOT NULL,
  `analysis_adversary_description` VARCHAR(2000) NULL,
  `mse_id` INT NULL,
  PRIMARY KEY (`analysis_adversary_id`),
  INDEX `mse_id_idx` (`mse_id` ASC),
  CONSTRAINT `mse_id`
    FOREIGN KEY (`mse_id`)
    REFERENCES `mse`.`mse` (`mse_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mse`.`coa_advantage`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`coa_advantage` (
  `coa_advantage_id` INT NOT NULL,
  `coa_advantage_description` VARCHAR(2000) NULL,
  `mse_id` INT NULL,
  PRIMARY KEY (`coa_advantage_id`),
  INDEX `mse_id_idx` (`mse_id` ASC),
  CONSTRAINT `mse_id`
    FOREIGN KEY (`mse_id`)
    REFERENCES `mse`.`mse` (`mse_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mse`.`coa_disadvantage`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`coa_disadvantage` (
  `coa_disadvantage_id` INT NOT NULL,
  `coa_disadvantage_description` VARCHAR(2000) NULL,
  `mse_id` INT NULL,
  PRIMARY KEY (`coa_disadvantage_id`),
  INDEX `mse_id_idx` (`mse_id` ASC),
  CONSTRAINT `mse_id`
    FOREIGN KEY (`mse_id`)
    REFERENCES `mse`.`mse` (`mse_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mse`.`coa_govfactor`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`coa_govfactor` (
  `coa_govfactor_id` INT NOT NULL,
  `coa_govfactor_description` VARCHAR(2000) NULL,
  `mse_id` INT NULL,
  PRIMARY KEY (`coa_govfactor_id`),
  INDEX `mse_id_idx` (`mse_id` ASC),
  CONSTRAINT `mse_id`
    FOREIGN KEY (`mse_id`)
    REFERENCES `mse`.`mse` (`mse_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mse`.`recommendation`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`recommendation` (
  `recommendation_id` INT NOT NULL,
  `recommendation_description` VARCHAR(2000) NULL,
  `mse_id` INT NULL,
  PRIMARY KEY (`recommendation_id`),
  INDEX `mse_id_idx` (`mse_id` ASC),
  CONSTRAINT `mse_id`
    FOREIGN KEY (`mse_id`)
    REFERENCES `mse`.`mse` (`mse_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mse`.`add_information`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`add_information` (
  `add_information_id` INT NOT NULL,
  `add_information_description` VARCHAR(2000) NULL,
  `add_information_title` VARCHAR(2000) NULL,
  `mse_id` INT NULL,
  PRIMARY KEY (`add_information_id`),
  INDEX `mse_id_idx` (`mse_id` ASC),
  CONSTRAINT `mse_id`
    FOREIGN KEY (`mse_id`)
    REFERENCES `mse`.`mse` (`mse_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;

USE `mse` ;

-- -----------------------------------------------------
-- Placeholder table for view `mse`.`view1`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mse`.`view1` (`id` INT);

-- -----------------------------------------------------
-- View `mse`.`view1`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mse`.`view1`;
USE `mse`;


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