qpGifGHw

1
2-- -----------------------------------------------------
3-- Table `users`
4-- -----------------------------------------------------
5CREATE  TABLE IF NOT EXISTS `users` (
6  `id` INT NOT NULL ,
7  `name` VARCHAR(45) NOT NULL ,
8  `email` VARCHAR(255) NOT NULL ,
9  PRIMARY KEY (`id`) ,
10  UNIQUE INDEX `email_UNIQUE` (`email` ASC) )
11ENGINE = InnoDB;
12
13
14-- -----------------------------------------------------
15-- Table `criterias`
16-- -----------------------------------------------------
17CREATE  TABLE IF NOT EXISTS `criterias` (
18  `id` INT NOT NULL ,
19  `name` VARCHAR(45) NOT NULL ,
20  `weight` INT NOT NULL ,
21  PRIMARY KEY (`id`) )
22ENGINE = InnoDB;
23
24
25-- -----------------------------------------------------
26-- Table `concepts`
27-- -----------------------------------------------------
28CREATE  TABLE IF NOT EXISTS `concepts` (
29  `id` INT NOT NULL ,
30  `name` VARCHAR(45) NOT NULL ,
31  PRIMARY KEY (`id`) )
32ENGINE = InnoDB;
33
34
35-- -----------------------------------------------------
36-- Table `concepts_criterias`
37-- -----------------------------------------------------
38CREATE  TABLE IF NOT EXISTS `concepts_criterias` (
39  `id` INT NOT NULL ,
40  `concept_id` INT NOT NULL ,
41  `criteria_id` INT NOT NULL ,
42  `score` INT NOT NULL ,
43  PRIMARY KEY (`id`, `concept_id`, `criteria_id`) ,
44  INDEX `fk_concepts_criterias_concepts1` (`concept_id` ASC) ,
45  INDEX `fk_concepts_criterias_criterias1` (`criteria_id` ASC) ,
46  CONSTRAINT `fk_concepts_criterias_concepts1`
47    FOREIGN KEY (`concept_id` )
48    REFERENCES `concepts` (`id` )
49    ON DELETE NO ACTION
50    ON UPDATE NO ACTION,
51  CONSTRAINT `fk_concepts_criterias_criterias1`
52    FOREIGN KEY (`criteria_id` )
53    REFERENCES `criterias` (`id` )
54    ON DELETE NO ACTION
55    ON UPDATE NO ACTION)
56ENGINE = InnoDB;
57
58
59-- -----------------------------------------------------
60-- Table `matrices`
61-- -----------------------------------------------------
62CREATE  TABLE IF NOT EXISTS `matrices` (
63  `id` INT NOT NULL ,
64  `name` VARCHAR(45) NOT NULL ,
65  PRIMARY KEY (`id`) )
66ENGINE = InnoDB;
67
68
69-- -----------------------------------------------------
70-- Table `concepts_matrices`
71-- -----------------------------------------------------
72CREATE  TABLE IF NOT EXISTS `concepts_matrices` (
73  `id` INT NOT NULL ,
74  `matrix_id` INT NOT NULL ,
75  `concept_id` INT NOT NULL ,
76  PRIMARY KEY (`id`, `matrix_id`, `concept_id`) ,
77  INDEX `fk_concept_matrix_matrices1` (`matrix_id` ASC) ,
78  INDEX `fk_concept_matrix_concepts1` (`concept_id` ASC) ,
79  CONSTRAINT `fk_concept_matrix_matrices1`
80    FOREIGN KEY (`matrix_id` )
81    REFERENCES `matrices` (`id` )
82    ON DELETE NO ACTION
83    ON UPDATE NO ACTION,
84  CONSTRAINT `fk_concept_matrix_concepts1`
85    FOREIGN KEY (`concept_id` )
86    REFERENCES `concepts` (`id` )
87    ON DELETE NO ACTION
88    ON UPDATE NO ACTION)
89ENGINE = InnoDB;
90
91
92-- -----------------------------------------------------
93-- Table `matrices_users`
94-- -----------------------------------------------------
95CREATE  TABLE IF NOT EXISTS `matrices_users` (
96  `id` INT NOT NULL ,
97  `user_id` INT NOT NULL ,
98  `matrix_id` INT NOT NULL ,
99  `is_owner` INT NOT NULL DEFAULT 0 ,
100  PRIMARY KEY (`id`, `user_id`, `matrix_id`) ,
101  INDEX `fk_matrices_users_users` (`user_id` ASC) ,
102  INDEX `fk_matrices_users_matrices1` (`matrix_id` ASC) ,
103  CONSTRAINT `fk_matrices_users_users`
104    FOREIGN KEY (`user_id` )
105    REFERENCES `users` (`id` )
106    ON DELETE NO ACTION
107    ON UPDATE NO ACTION,
108  CONSTRAINT `fk_matrices_users_matrices1`
109    FOREIGN KEY (`matrix_id` )
110    REFERENCES `matrices` (`id` )
111    ON DELETE NO ACTION
112    ON UPDATE NO ACTION)
113ENGINE = InnoDB;
114
115
116-- -----------------------------------------------------
117-- Table `criterias_matrices`
118-- -----------------------------------------------------
119CREATE  TABLE IF NOT EXISTS `criterias_matrices` (
120  `id` INT NOT NULL ,
121  `matrix_id` INT NOT NULL ,
122  `criteria_id` INT NOT NULL ,
123  PRIMARY KEY (`id`, `matrix_id`, `criteria_id`) ,
124  INDEX `fk_criterias_matrices_matrices1` (`matrix_id` ASC) ,
125  INDEX `fk_criterias_matrices_criterias1` (`criteria_id` ASC) ,
126  CONSTRAINT `fk_criterias_matrices_matrices1`
127    FOREIGN KEY (`matrix_id` )
128    REFERENCES `matrices` (`id` )
129    ON DELETE NO ACTION
130    ON UPDATE NO ACTION,
131  CONSTRAINT `fk_criterias_matrices_criterias1`
132    FOREIGN KEY (`criteria_id` )
133    REFERENCES `criterias` (`id` )
134    ON DELETE NO ACTION
135    ON UPDATE NO ACTION)
136ENGINE = InnoDB;