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

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

-- -----------------------------------------------------
-- Table `mlb_juiced_balls`.`season_2019`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mlb_juiced_balls`.`season_2019` (
  `Team_ID` VARCHAR(3) NOT NULL,
  `runs_per_game19` DECIMAL(10,2) NULL,
  `at_bats19` DECIMAL(10,2) NULL,
  `runs19` DECIMAL(10,2) NULL,
  `hits19` DECIMAL(10,2) NULL,
  `d0uble19` DECIMAL(10,2) NULL,
  `triple19` DECIMAL(10,2) NULL,
  `home_runs19` DECIMAL(10,2) NULL,
  `runs_batted_in19` DECIMAL(10,2) NULL,
  `bases_on_balls19` DECIMAL(10,2) NULL,
  `batting_avg19` DECIMAL(10,3) NULL,
  `on_base_percentage19` DECIMAL(10,3) NULL,
  `slugging_percentage19` DECIMAL(10,3) NULL,
  `total_bases19` DECIMAL(10,2) NULL,
  `season_2019col` INT NULL,
  PRIMARY KEY (`Team_ID`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mlb_juiced_balls`.`season_2018`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mlb_juiced_balls`.`season_2018` (
  `Team_ID` VARCHAR(3) NOT NULL,
  `runs_per_game18` DECIMAL(10,2) NULL,
  `at_bats18` DECIMAL(10,2) NULL,
  `runs18` DECIMAL(10,2) NULL,
  `hits18` DECIMAL(10,2) NULL,
  `d0uble18` DECIMAL(10,2) NULL,
  `triple18` DECIMAL(10,2) NULL,
  `home_runs18` DECIMAL(10,2) NULL,
  `runs_batted_in18` DECIMAL(10,2) NULL,
  `bases_on_balls18` DECIMAL(10,2) NULL,
  `batting_avg18` DECIMAL(10,3) NULL,
  `on_base_percentage18` DECIMAL(10,3) NULL,
  `slugging_percentage18` DECIMAL(10,3) NULL,
  `total_bases18` DECIMAL(10,2) NULL,
  PRIMARY KEY (`Team_ID`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mlb_juiced_balls`.`season_2017`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mlb_juiced_balls`.`season_2017` (
  `Team_ID` VARCHAR(3) NOT NULL,
  `runs_per_game17` DECIMAL(10,2) NULL,
  `at_bats17` DECIMAL(10,2) NULL,
  `runs17` DECIMAL(10,2) NULL,
  `hits17` DECIMAL(10,2) NULL,
  `d0uble17` DECIMAL(10,2) NULL,
  `triple17` DECIMAL(10,2) NULL,
  `home_runs17` DECIMAL(10,2) NULL,
  `runs_batted_in17` DECIMAL(10,2) NULL,
  `bases_on_balls17` DECIMAL(10,2) NULL,
  `batting_avg17` DECIMAL(10,3) NULL,
  `on_base_percentage17` DECIMAL(10,3) NULL,
  `slugging_percentage17` DECIMAL(10,3) NULL,
  `total_bases17` DECIMAL(10,2) NULL,
  PRIMARY KEY (`Team_ID`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mlb_juiced_balls`.`season_2016`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mlb_juiced_balls`.`season_2016` (
  `Team_ID` VARCHAR(3) NOT NULL,
  `runs_per_game16` DECIMAL(10,2) NULL,
  `at_bats16` DECIMAL(10,2) NULL,
  `runs16` DECIMAL(10,2) NULL,
  `hits16` DECIMAL(10,2) NULL,
  `d0uble16` DECIMAL(10,2) NULL,
  `triple16` DECIMAL(10,2) NULL,
  `home_runs16` DECIMAL(10,2) NULL,
  `runs_batted_in16` DECIMAL(10,2) NULL,
  `bases_on_balls16` DECIMAL(10,2) NULL,
  `batting_avg16` DECIMAL(10,3) NULL,
  `on_base_percentage16` DECIMAL(10,3) NULL,
  `slugging_percentage16` DECIMAL(10,3) NULL,
  `total_bases16` DECIMAL(10,2) NULL,
  PRIMARY KEY (`Team_ID`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mlb_juiced_balls`.`season_2015`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mlb_juiced_balls`.`season_2015` (
  `Team_ID` VARCHAR(3) NOT NULL,
  `runs_per_game15` DECIMAL(10,2) NULL,
  `at_bats15` DECIMAL(10,2) NULL,
  `runs15` DECIMAL(10,2) NULL,
  `hits15` DECIMAL(10,2) NULL,
  `d0uble15` DECIMAL(10,2) NULL,
  `triple15` DECIMAL(10,2) NULL,
  `home_runs15` DECIMAL(10,2) NULL,
  `runs_batted_in15` DECIMAL(10,2) NULL,
  `bases_on_balls15` DECIMAL(10,2) NULL,
  `batting_avg15` DECIMAL(10,3) NULL,
  `on_base_percentage15` DECIMAL(10,3) NULL,
  `slugging_percentage15` DECIMAL(10,3) NULL,
  `total_bases15` DECIMAL(10,2) NULL,
  PRIMARY KEY (`Team_ID`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mlb_juiced_balls`.`MLB_Teams`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mlb_juiced_balls`.`MLB_Teams` (
  `Team_ID` VARCHAR(3) NOT NULL,
  `Team_Name` VARCHAR(100) NULL,
  `season_2019_Team_ID` VARCHAR(3) NULL,
  `season_2018_Team_ID` VARCHAR(3) NULL,
  `season_2017_Team_ID` VARCHAR(3) NULL,
  `season_2016_Team_ID` VARCHAR(3) NULL,
  `season_2015_Team_ID` VARCHAR(3) NULL,
  PRIMARY KEY (`Team_ID`),
  INDEX `fk_MLB_Teams_season_2019_idx` (`season_2019_Team_ID` ASC) INVISIBLE,
  INDEX `fk_MLB_Teams_season_20181_idx` (`season_2018_Team_ID` ASC) INVISIBLE,
  INDEX `fk_MLB_Teams_season_20171_idx` (`season_2017_Team_ID` ASC) INVISIBLE,
  INDEX `fk_MLB_Teams_season_20161_idx` (`season_2016_Team_ID` ASC) INVISIBLE,
  INDEX `fk_MLB_Teams_season_20151_idx` (`season_2015_Team_ID` ASC) INVISIBLE,
  CONSTRAINT `fk_MLB_Teams_season_2019`
    FOREIGN KEY (`season_2019_Team_ID`)
    REFERENCES `mlb_juiced_balls`.`season_2019` (`Team_ID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_MLB_Teams_season_20181`
    FOREIGN KEY (`season_2018_Team_ID`)
    REFERENCES `mlb_juiced_balls`.`season_2018` (`Team_ID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_MLB_Teams_season_20171`
    FOREIGN KEY (`season_2017_Team_ID`)
    REFERENCES `mlb_juiced_balls`.`season_2017` (`Team_ID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_MLB_Teams_season_20161`
    FOREIGN KEY (`season_2016_Team_ID`)
    REFERENCES `mlb_juiced_balls`.`season_2016` (`Team_ID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_MLB_Teams_season_20151`
    FOREIGN KEY (`season_2015_Team_ID`)
    REFERENCES `mlb_juiced_balls`.`season_2015` (`Team_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;