2D4m5tmZ

1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema smra
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema smra
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `smra` DEFAULT CHARACTER SET utf8 ;
15USE `smra` ;
16
17-- -----------------------------------------------------
18-- Table `smra`.`Regiao`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `smra`.`Regiao` (
21  `idRegiao` INT NOT NULL,
22  `regiao` VARCHAR(125) NOT NULL,
23  PRIMARY KEY (`idRegiao`))
24ENGINE = InnoDB;
25
26
27-- -----------------------------------------------------
28-- Table `smra`.`Utilizadores`
29-- -----------------------------------------------------
30CREATE TABLE IF NOT EXISTS `smra`.`Utilizadores` (
31  `idUtilizadores` INT NOT NULL,
32  `nome` VARCHAR(45) NULL,
33  `email` VARCHAR(45) NULL,
34  `palavra_passe` VARCHAR(45) NULL,
35  `Regiao_idRegiao` INT NOT NULL,
36  PRIMARY KEY (`idUtilizadores`),
37  INDEX `fk_Utilizadores_Regiao1_idx` (`Regiao_idRegiao` ASC),
38  CONSTRAINT `fk_Utilizadores_Regiao1`
39    FOREIGN KEY (`Regiao_idRegiao`)
40    REFERENCES `smra`.`Regiao` (`idRegiao`)
41    ON DELETE NO ACTION
42    ON UPDATE NO ACTION)
43ENGINE = InnoDB;
44
45
46-- -----------------------------------------------------
47-- Table `smra`.`Reservatorio`
48-- -----------------------------------------------------
49CREATE TABLE IF NOT EXISTS `smra`.`Reservatorio` (
50  `idReservatorio` INT NOT NULL,
51  `nome` VARCHAR(45) NULL,
52  `ultima_manutencao` DATETIME NULL,
53  `revestimento` VARCHAR(45) NULL,
54  `Regiao_idRegiao` INT NOT NULL,
55  PRIMARY KEY (`idReservatorio`),
56  INDEX `fk_Reservatorio_Regiao1_idx` (`Regiao_idRegiao` ASC),
57  CONSTRAINT `fk_Reservatorio_Regiao1`
58    FOREIGN KEY (`Regiao_idRegiao`)
59    REFERENCES `smra`.`Regiao` (`idRegiao`)
60    ON DELETE NO ACTION
61    ON UPDATE NO ACTION)
62ENGINE = InnoDB;
63
64
65-- -----------------------------------------------------
66-- Table `smra`.`Alertas`
67-- -----------------------------------------------------
68CREATE TABLE IF NOT EXISTS `smra`.`Alertas` (
69  `idAlertas` INT NOT NULL,
70  `alerta` VARCHAR(125) NULL,
71  `Reservatorio_idReservatorio` INT NOT NULL,
72  PRIMARY KEY (`idAlertas`),
73  INDEX `fk_Alertas_Reservatorio_idx` (`Reservatorio_idReservatorio` ASC),
74  CONSTRAINT `fk_Alertas_Reservatorio`
75    FOREIGN KEY (`Reservatorio_idReservatorio`)
76    REFERENCES `smra`.`Reservatorio` (`idReservatorio`)
77    ON DELETE NO ACTION
78    ON UPDATE NO ACTION)
79ENGINE = InnoDB;
80
81
82-- -----------------------------------------------------
83-- Table `smra`.`Previsoes`
84-- -----------------------------------------------------
85CREATE TABLE IF NOT EXISTS `smra`.`Previsoes` (
86  `idPrevisoes` INT NOT NULL,
87  `previsao_nivel` VARCHAR(45) NULL,
88  `previsao_manutencao` VARCHAR(45) NULL,
89  `Reservatorio_idReservatorio` INT NOT NULL,
90  PRIMARY KEY (`idPrevisoes`),
91  INDEX `fk_Previsoes_Reservatorio1_idx` (`Reservatorio_idReservatorio` ASC),
92  CONSTRAINT `fk_Previsoes_Reservatorio1`
93    FOREIGN KEY (`Reservatorio_idReservatorio`)
94    REFERENCES `smra`.`Reservatorio` (`idReservatorio`)
95    ON DELETE NO ACTION
96    ON UPDATE NO ACTION)
97ENGINE = InnoDB;
98
99
100-- -----------------------------------------------------
101-- Table `smra`.`ParamAlertas`
102-- -----------------------------------------------------
103CREATE TABLE IF NOT EXISTS `smra`.`ParamAlertas` (
104  `idParamAlertas` INT NOT NULL,
105  `ph_MIN` DECIMAL(5) NULL,
106  `ph_MAX` DECIMAL(5) NULL,
107  `nivel_MIN` DECIMAL(5) NULL,
108  `nivel_MAX` DECIMAL(5) NULL,
109  `turbidez_MIN` DECIMAL(5) NULL,
110  `turbidez_MAX` DECIMAL(5) NULL,
111  `minerais_MIN` DECIMAL(5) NULL,
112  `minerais_MAX` DECIMAL(5) NULL,
113  `Reservatorio_idReservatorio` INT NOT NULL,
114  PRIMARY KEY (`idParamAlertas`),
115  INDEX `fk_ParamAlertas_Reservatorio1_idx` (`Reservatorio_idReservatorio` ASC),
116  CONSTRAINT `fk_ParamAlertas_Reservatorio1`
117    FOREIGN KEY (`Reservatorio_idReservatorio`)
118    REFERENCES `smra`.`Reservatorio` (`idReservatorio`)
119    ON DELETE NO ACTION
120    ON UPDATE NO ACTION)
121ENGINE = InnoDB;
122
123
124SET SQL_MODE=@OLD_SQL_MODE;
125SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
126SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;