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

-- -----------------------------------------------------
-- Schema Agenda
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `Agenda` ;
USE `Agenda` ;

-- -----------------------------------------------------
-- Table `Agenda`.`personas`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Agenda`.`personas` (
  `idpersonas` INT NOT NULL AUTO_INCREMENT,
  `nombre` VARCHAR(45) NOT NULL,
  `telefono` VARCHAR(45) NOT NULL,
  `email` VARCHAR(45) NULL,
  `calle` VARCHAR(45) NULL,
  `altura` INT NULL,
  `piso` INT NULL,
  `depto` VARCHAR(45) NULL,
  `linkedin` VARCHAR(45) NULL,
  `birthday` DATE NULL,
  `idTipo` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`idpersonas`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `Agenda`.`tipo`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Agenda`.`tipo` (
  `idtipo` INT NOT NULL AUTO_INCREMENT,
  `nombre` VARCHAR(45) NOT NULL,
  `idpersonas` INT NOT NULL,
  PRIMARY KEY (`idtipo`),
  INDEX `idPersona_idx` (`idpersonas` ASC) VISIBLE,
  CONSTRAINT `idPersona`
    FOREIGN KEY (`idpersonas`)
    REFERENCES `Agenda`.`personas` (`idpersonas`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `Agenda`.`localidad`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Agenda`.`localidad` (
  `idlocalidad` INT NOT NULL AUTO_INCREMENT,
  `CP` INT NOT NULL,
  `nombre` VARCHAR(45) NOT NULL,
  `idpersonas` INT NOT NULL,
  PRIMARY KEY (`idlocalidad`),
  INDEX `idPersonas_idx` (`idpersonas` ASC) VISIBLE,
  CONSTRAINT `idPersonas`
    FOREIGN KEY (`idpersonas`)
    REFERENCES `Agenda`.`personas` (`idpersonas`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `Agenda`.`provincia`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Agenda`.`provincia` (
  `idprovincia` INT NOT NULL AUTO_INCREMENT,
  `nombre` VARCHAR(45) NOT NULL,
  `idlocalidad` INT NOT NULL,
  PRIMARY KEY (`idprovincia`),
  INDEX `idlocalidad_idx` (`idlocalidad` ASC) VISIBLE,
  CONSTRAINT `idlocalidad`
    FOREIGN KEY (`idlocalidad`)
    REFERENCES `Agenda`.`localidad` (`idlocalidad`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `Agenda`.`pais`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Agenda`.`pais` (
  `idpais` INT NOT NULL AUTO_INCREMENT,
  `nombre` VARCHAR(45) NOT NULL,
  `idprovincia` INT NOT NULL,
  PRIMARY KEY (`idpais`),
  INDEX `idprovincia_idx` (`idprovincia` ASC) VISIBLE,
  CONSTRAINT `idprovincia`
    FOREIGN KEY (`idprovincia`)
    REFERENCES `Agenda`.`provincia` (`idprovincia`)
    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;