xNXUQ9yA

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 SensorMonitoring
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Table `server`
13-- -----------------------------------------------------
14DROP TABLE IF EXISTS `server` ;
15
16CREATE TABLE IF NOT EXISTS `server` (
17  `idServer` INT NOT NULL,
18  `alarmStatus` TINYINT NOT NULL,
19  `sysAdmin` VARCHAR(45) NOT NULL,
20  `lastTrigger` DATE NULL,
21  PRIMARY KEY (`idServer`))
22ENGINE = InnoDB;
23
24
25-- -----------------------------------------------------
26-- Table `Sensor`
27-- -----------------------------------------------------
28DROP TABLE IF EXISTS `Sensor` ;
29
30CREATE TABLE IF NOT EXISTS `Sensor` (
31  `idSensor` INT NOT NULL,
32  `temperature` VARCHAR(45) NOT NULL,
33  `upperLimit` INT NOT NULL,
34  `idServer` INT NOT NULL,
35  PRIMARY KEY (`idSensor`),
36  INDEX `fk_digitalSensor_server(c++)1_idx` (`idServer` ASC),
37  CONSTRAINT `fk_digitalSensor_server(c++)1`
38    FOREIGN KEY (`idServer`)
39    REFERENCES `server` (`idServer`)
40    ON DELETE NO ACTION
41    ON UPDATE NO ACTION)
42ENGINE = InnoDB;
43
44
45-- -----------------------------------------------------
46-- Table `Employee`
47-- -----------------------------------------------------
48DROP TABLE IF EXISTS `Employee` ;
49
50CREATE TABLE IF NOT EXISTS `Employee` (
51  `idEmployee` INT NOT NULL,
52  `employeeName` VARCHAR(45) NOT NULL,
53  `adminRights` VARCHAR(45) NOT NULL,
54  `employeeAddress` VARCHAR(45) NULL,
55  PRIMARY KEY (`idEmployee`))
56ENGINE = InnoDB;
57
58
59-- -----------------------------------------------------
60-- Table `clientPC`
61-- -----------------------------------------------------
62DROP TABLE IF EXISTS `clientPC` ;
63
64CREATE TABLE IF NOT EXISTS `clientPC` (
65  `idclient` INT NOT NULL,
66  `department` VARCHAR(45) NOT NULL,
67  `idServer` INT NOT NULL,
68  PRIMARY KEY (`idclient`),
69  INDEX `fk_clientPC_server1_idx` (`idServer` ASC),
70  CONSTRAINT `fk_clientPC_server1`
71    FOREIGN KEY (`idServer`)
72    REFERENCES `server` (`idServer`)
73    ON DELETE NO ACTION
74    ON UPDATE NO ACTION)
75ENGINE = InnoDB;
76
77
78-- -----------------------------------------------------
79-- Table `Controlls`
80-- -----------------------------------------------------
81DROP TABLE IF EXISTS `Controlls` ;
82
83CREATE TABLE IF NOT EXISTS `Controlls` (
84  `Employee_idEmployee` INT NOT NULL,
85  `clientPC_idClient` INT NOT NULL,
86  PRIMARY KEY (`Employee_idEmployee`, `clientPC_idClient`),
87  INDEX `fk_table1_Employee1_idx` (`Employee_idEmployee` ASC),
88  INDEX `fk_table1_clientPC(java)1_idx` (`clientPC_idClient` ASC),
89  CONSTRAINT `fk_table1_Employee1`
90    FOREIGN KEY (`Employee_idEmployee`)
91    REFERENCES `Employee` (`idEmployee`)
92    ON DELETE NO ACTION
93    ON UPDATE NO ACTION,
94  CONSTRAINT `fk_table1_clientPC(java)1`
95    FOREIGN KEY (`clientPC_idClient`)
96    REFERENCES `clientPC` (`idclient`)
97    ON DELETE NO ACTION
98    ON UPDATE NO ACTION)
99ENGINE = InnoDB;
100
101
102SET SQL_MODE=@OLD_SQL_MODE;
103SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
104SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;