uGq4sN8r

1CREATE TABLE IF NOT EXISTS `mydb`.`review` (
2  `id_review` INT NOT NULL AUTO_INCREMENT,
3  `score` VARCHAR(45) NOT NULL,
4  `coment` VARCHAR(45) NULL,
5  `id_business` INT NOT NULL,
6  PRIMARY KEY (`id_review`),
7  UNIQUE INDEX `id_review_UNIQUE` (`id_review` ASC),
8  INDEX `fk_business_idx` (`id_business` ASC),
9  CONSTRAINT `fk_business`
10    FOREIGN KEY (`id_business`)
11    REFERENCES `mydb`.`business` (`id_business`)
12    ON DELETE NO ACTION
13    ON UPDATE NO ACTION)
14ENGINE = InnoDB;
15	
16CREATE TABLE IF NOT EXISTS `mydb`.`business` (
17  `id_business` INT NOT NULL AUTO_INCREMENT,
18  `name` VARCHAR(255) NOT NULL,
19  `logo` VARCHAR(45) NULL,
20  `address` VARCHAR(45) NOT NULL,
21  `phone` VARCHAR(45) NULL,
22  `responsible` VARCHAR(45) NULL,
23  `status` VARCHAR(45) NOT NULL,
24  `id_user` INT NOT NULL,
25  PRIMARY KEY (`id_business`),
26  UNIQUE INDEX `id_business_UNIQUE` (`id_business` ASC),
27  UNIQUE INDEX `name_UNIQUE` (`name` ASC),
28  UNIQUE INDEX `address_UNIQUE` (`address` ASC),
29  INDEX `fk_user_idx` (`id_user` ASC),
30  CONSTRAINT `fk_user`
31    FOREIGN KEY (`id_user`)
32    REFERENCES `mydb`.`user` (`id_user`)
33    ON DELETE NO ACTION
34    ON UPDATE NO ACTION)
35ENGINE = InnoDB;
36	
37CREATE TABLE IF NOT EXISTS `mydb`.`claims` (
38  `id_claims` INT NOT NULL AUTO_INCREMENT,
39  `coment` VARCHAR(45) NOT NULL,
40  `answer` VARCHAR(45) NULL,
41  `status` VARCHAR(45) NOT NULL,
42  `id_business` INT NOT NULL,
43  PRIMARY KEY (`id_claims`),
44  UNIQUE INDEX `id_claims_UNIQUE` (`id_claims` ASC),
45  INDEX `fk_business_idx` (`id_business` ASC),
46  CONSTRAINT `fk_business`
47    FOREIGN KEY (`id_business`)
48    REFERENCES `mydb`.`business` (`id_business`)
49    ON DELETE NO ACTION
50    ON UPDATE NO ACTION)
51ENGINE = InnoDB;