g2JqYtzb

1-- -----------------------------------------------------
2-- Table `App`.`patient`
3-- -----------------------------------------------------
4CREATE TABLE IF NOT EXISTS `App`.`patient` (
5  `user` VARCHAR(25) NOT NULL,
6  `id` INT NOT NULL,
7  `pass` VARCHAR(45) NULL,
8  PRIMARY KEY (`user`))
9ENGINE = InnoDB;
10
11
12-- -----------------------------------------------------
13-- Table `App`.`test`
14-- -----------------------------------------------------
15CREATE TABLE IF NOT EXISTS `App`.`test` (
16  `name` VARCHAR(25) NOT NULL,
17  `patient` VARCHAR(25) NOT NULL,
18  PRIMARY KEY (`name`, `patient`),
19  INDEX `fk_patient_idx` (`patient` ASC),
20  CONSTRAINT `fk_patient`
21    FOREIGN KEY (`patient`)
22    REFERENCES `App`.`patient` (`user`)
23    ON DELETE CASCADE
24    ON UPDATE CASCADE)
25ENGINE = InnoDB;
26
27
28-- -----------------------------------------------------
29-- Table `App`.`testdata`
30-- -----------------------------------------------------
31CREATE TABLE IF NOT EXISTS `App`.`testdata` (
32  `testname` VARCHAR(25) NOT NULL,
33  `day` INT NOT NULL,
34  PRIMARY KEY (`testname`, `day`),
35  CONSTRAINT `fk_test`
36    FOREIGN KEY (`testname`)
37    REFERENCES `App`.`test` (`name`)
38    ON DELETE CASCADE
39    ON UPDATE CASCADE)
40ENGINE = InnoDB;