a3X7DGzx

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 soufflerie
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema soufflerie
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `soufflerie` DEFAULT CHARACTER SET utf8 ;
15USE `soufflerie` ;
16
17-- -----------------------------------------------------
18-- Table `soufflerie`.`scenario`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `soufflerie`.`scenario` (
21  `id` INT NOT NULL AUTO_INCREMENT,
22  `nom` VARCHAR(255) NOT NULL,
23  PRIMARY KEY (`id`))
24ENGINE = InnoDB;
25
26
27-- -----------------------------------------------------
28-- Table `soufflerie`.`phase`
29-- -----------------------------------------------------
30CREATE TABLE IF NOT EXISTS `soufflerie`.`phase` (
31  `id` INT NOT NULL AUTO_INCREMENT,
32  `fk_scenario` INT NOT NULL,
33  `temps` INT NOT NULL,
34  `consigne` INT NOT NULL,
35  PRIMARY KEY (`id`),
36  INDEX `test_idx` (`fk_scenario` ASC),
37  CONSTRAINT `fkk_scenario`
38    FOREIGN KEY (`fk_scenario`)
39    REFERENCES `soufflerie`.`scenario` (`id`)
40    ON DELETE NO ACTION
41    ON UPDATE NO ACTION)
42ENGINE = InnoDB;
43
44
45-- -----------------------------------------------------
46-- Table `soufflerie`.`capteurs`
47-- -----------------------------------------------------
48CREATE TABLE IF NOT EXISTS `soufflerie`.`capteurs` (
49  `id` INT NOT NULL AUTO_INCREMENT,
50  `nom` VARCHAR(45) NOT NULL,
51  PRIMARY KEY (`id`))
52ENGINE = InnoDB;
53
54
55-- -----------------------------------------------------
56-- Table `soufflerie`.`etatCapteur`
57-- -----------------------------------------------------
58CREATE TABLE IF NOT EXISTS `soufflerie`.`etatCapteur` (
59  `id` INT NOT NULL AUTO_INCREMENT,
60  `fk_capteur` INT NOT NULL,
61  `relevé` DATETIME NOT NULL,
62  PRIMARY KEY (`id`),
63  INDEX `fk_capteur_idx` (`fk_capteur` ASC),
64  CONSTRAINT `fk_capteur`
65    FOREIGN KEY (`fk_capteur`)
66    REFERENCES `soufflerie`.`capteurs` (`id`)
67    ON DELETE NO ACTION
68    ON UPDATE NO ACTION)
69ENGINE = InnoDB;
70
71
72-- -----------------------------------------------------
73-- Table `soufflerie`.`eolienne`
74-- -----------------------------------------------------
75CREATE TABLE IF NOT EXISTS `soufflerie`.`eolienne` (
76  `id` INT NOT NULL AUTO_INCREMENT,
77  `model` VARCHAR(255) NOT NULL,
78  `type` VARCHAR(255) NOT NULL,
79  `fabricant` VARCHAR(255) NOT NULL,
80  `chemin` VARCHAR(255) NULL,
81  PRIMARY KEY (`id`))
82ENGINE = InnoDB;
83
84
85-- -----------------------------------------------------
86-- Table `soufflerie`.`resultat`
87-- -----------------------------------------------------
88CREATE TABLE IF NOT EXISTS `soufflerie`.`resultat` (
89  `id` INT NOT NULL AUTO_INCREMENT,
90  `fk_scenario` INT NOT NULL,
91  `fk_phase` INT NOT NULL,
92  `fk_eolienne` INT NOT NULL,
93  `puissance` INT NOT NULL,
94  `vent` INT NOT NULL,
95  `date` DATETIME NOT NULL,
96  PRIMARY KEY (`id`),
97  INDEX `fk_scenario_idx` (`fk_scenario` ASC),
98  INDEX `fk_phase_idx` (`fk_phase` ASC),
99  INDEX `fk_eolienne_idx` (`fk_eolienne` ASC),
100  CONSTRAINT `fk_scenario`
101    FOREIGN KEY (`fk_scenario`)
102    REFERENCES `soufflerie`.`scenario` (`id`)
103    ON DELETE NO ACTION
104    ON UPDATE NO ACTION,
105  CONSTRAINT `fk_phase`
106    FOREIGN KEY (`fk_phase`)
107    REFERENCES `soufflerie`.`phase` (`id`)
108    ON DELETE NO ACTION
109    ON UPDATE NO ACTION,
110  CONSTRAINT `fk_eolienne`
111    FOREIGN KEY (`fk_eolienne`)
112    REFERENCES `soufflerie`.`eolienne` (`id`)
113    ON DELETE NO ACTION
114    ON UPDATE NO ACTION)
115ENGINE = InnoDB;
116
117
118-- -----------------------------------------------------
119-- Table `soufflerie`.`direct`
120-- -----------------------------------------------------
121CREATE TABLE IF NOT EXISTS `soufflerie`.`direct` (
122  `id` INT NOT NULL,
123  `puissance` INT NOT NULL,
124  `vent` INT NOT NULL,
125  PRIMARY KEY (`id`))
126ENGINE = InnoDB;
127
128
129SET SQL_MODE=@OLD_SQL_MODE;
130SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
131SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;