Vmf3N4FY

1-- MySQL Script generated by MySQL Workbench
2-- Thu Sep 26 12:08:58 2019
3-- Model: New Model    Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @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';
9
10-- -----------------------------------------------------
11-- Schema tpdaii
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema tpdaii
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `tpdaii` DEFAULT CHARACTER SET utf8 ;
18USE `tpdaii` ;
19
20-- -----------------------------------------------------
21-- Table `tpdaii`.`Electrovalvulas`
22-- -----------------------------------------------------
23DROP TABLE IF EXISTS `tpdaii`.`Electrovalvulas` ;
24
25CREATE TABLE IF NOT EXISTS `tpdaii`.`Electrovalvulas` (
26  `electrovalvulaId` INT NOT NULL AUTO_INCREMENT,
27  `nombre` VARCHAR(45) NULL,
28  PRIMARY KEY (`electrovalvulaId`))
29ENGINE = InnoDB;
30
31
32-- -----------------------------------------------------
33-- Table `tpdaii`.`Dispositivos`
34-- -----------------------------------------------------
35DROP TABLE IF EXISTS `tpdaii`.`Dispositivos` ;
36
37CREATE TABLE IF NOT EXISTS `tpdaii`.`Dispositivos` (
38  `dispositivoId` INT NOT NULL AUTO_INCREMENT,
39  `nombre` VARCHAR(200) NULL,
40  `ubicacion` VARCHAR(200) NULL,
41  `electrovalvulaId` INT NOT NULL,
42  PRIMARY KEY (`dispositivoId`, `electrovalvulaId`),
43  INDEX `fk_Dispositivos_Electrovalvulas1_idx` (`electrovalvulaId` ASC) ,
44  CONSTRAINT `fk_Dispositivos_Electrovalvulas1`
45    FOREIGN KEY (`electrovalvulaId`)
46    REFERENCES `tpdaii`.`Electrovalvulas` (`electrovalvulaId`)
47    ON DELETE NO ACTION
48    ON UPDATE NO ACTION)
49ENGINE = InnoDB;
50
51
52-- -----------------------------------------------------
53-- Table `tpdaii`.`Mediciones`
54-- -----------------------------------------------------
55DROP TABLE IF EXISTS `tpdaii`.`Mediciones` ;
56
57CREATE TABLE IF NOT EXISTS `tpdaii`.`Mediciones` (
58  `medicionId` INT NOT NULL AUTO_INCREMENT,
59  `fecha` DATETIME NULL,
60  `valor` VARCHAR(100) NULL,
61  `dispositivoId` INT NOT NULL,
62  PRIMARY KEY (`medicionId`, `dispositivoId`),
63  INDEX `fk_Mediciones_Dispositivos_idx` (`dispositivoId` ASC) ,
64  CONSTRAINT `fk_Mediciones_Dispositivos`
65    FOREIGN KEY (`dispositivoId`)
66    REFERENCES `tpdaii`.`Dispositivos` (`dispositivoId`)
67    ON DELETE NO ACTION
68    ON UPDATE NO ACTION)
69ENGINE = InnoDB;
70
71
72-- -----------------------------------------------------
73-- Table `tpdaii`.`Log_Riegos`
74-- -----------------------------------------------------
75DROP TABLE IF EXISTS `tpdaii`.`Log_Riegos` ;
76
77CREATE TABLE IF NOT EXISTS `tpdaii`.`Log_Riegos` (
78  `logRiegoId` INT NOT NULL AUTO_INCREMENT,
79  `apertura` TINYINT NULL,
80  `fecha` DATETIME NULL,
81  `electrovalvulaId` INT NOT NULL,
82  PRIMARY KEY (`logRiegoId`, `electrovalvulaId`),
83  INDEX `fk_Log_Riegos_Electrovalvulas1_idx` (`electrovalvulaId` ASC) ,
84  CONSTRAINT `fk_Log_Riegos_Electrovalvulas1`
85    FOREIGN KEY (`electrovalvulaId`)
86    REFERENCES `tpdaii`.`Electrovalvulas` (`electrovalvulaId`)
87    ON DELETE NO ACTION
88    ON UPDATE NO ACTION)
89ENGINE = InnoDB;
90
91
92SET SQL_MODE=@OLD_SQL_MODE;
93SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
94SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;