9ptWe8eZ

1-- -----------------------------------------------------
2-- Table `pci_api`.`assuntos`
3-- -----------------------------------------------------
4DROP TABLE IF EXISTS `pci_api`.`assuntos` ;
5
6CREATE TABLE IF NOT EXISTS `pci_api`.`assuntos` (
7  `assu_id` INT NOT NULL,
8  `assu_nome` VARCHAR(150) NOT NULL,
9  `assu_ordem` TINYINT NULL,
10  `disc_id` INT NOT NULL,
11  `tp_ques_id` INT NOT NULL,
12  `usua_id` INT NOT NULL,
13  PRIMARY KEY (`assu_id`),
14  CONSTRAINT `fk_disciplinas_assuntos_tipo_questao1`
15    FOREIGN KEY (`tp_ques_id`)
16    REFERENCES `pci_api`.`tipo_questao` (`tp_ques_id`)
17    ON DELETE NO ACTION
18    ON UPDATE NO ACTION,
19  CONSTRAINT `fk_disciplinas_assuntos_usuarios1`
20    FOREIGN KEY (`usua_id`)
21    REFERENCES `pci_api`.`usuarios` (`usua_id`)
22    ON DELETE NO ACTION
23    ON UPDATE NO ACTION,
24  CONSTRAINT `fk_disciplinas_assuntos_disciplinas1`
25    FOREIGN KEY (`disc_id`)
26    REFERENCES `pci_api`.`disciplinas` (`disc_id`)
27    ON DELETE NO ACTION
28    ON UPDATE NO ACTION)
29ENGINE = InnoDB;
30
31CREATE INDEX `fk_disciplinas_assuntos_tipo_questao1_idx` ON `pci_api`.`assuntos` (`tp_ques_id` ASC) ;
32
33CREATE INDEX `fk_disciplinas_assuntos_usuarios1_idx` ON `pci_api`.`assuntos` (`usua_id` ASC) ;
34
35CREATE INDEX `fk_disciplinas_assuntos_disciplinas1_idx` ON `pci_api`.`assuntos` (`disc_id` ASC) ;
36
37CREATE UNIQUE INDEX `assu_nome_disc_id_tp_ques_id_UNIQUE` ON `pci_api`.`assuntos` (`assu_nome` ASC, `disc_id` ASC, `tp_ques_id` ASC) ;