· 6 years ago · Jun 13, 2019, 07:48 PM
1-- MySQL Script generated by MySQL Workbench
2-- Thu Jun 13 21:44:34 2019
3-- Model: New Model Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
9
10-- -----------------------------------------------------
11-- Schema mydb
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema mydb
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
18USE `mydb` ;
19
20-- -----------------------------------------------------
21-- Table `mydb`.`AJAsistent`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`AJAsistent` (
24 `idAsistent` INT NOT NULL,
25 `ime` VARCHAR(20) NOT NULL,
26 `prezime` VARCHAR(20) NOT NULL,
27 `username` VARCHAR(15) NOT NULL,
28 PRIMARY KEY (`idAsistent`))
29ENGINE = InnoDB;
30
31
32-- -----------------------------------------------------
33-- Table `mydb`.`AJStudent`
34-- -----------------------------------------------------
35CREATE TABLE IF NOT EXISTS `mydb`.`AJStudent` (
36 `idStudent` INT GENERATED ALWAYS AS () VIRTUAL,
37 `brojIndeksa` INT NOT NULL,
38 `ime` VARCHAR(20) NOT NULL,
39 `Prezime` VARCHAR(20) NOT NULL,
40 `datumR` DATE NOT NULL,
41 `username` VARCHAR(15) NOT NULL,
42 PRIMARY KEY (`idStudent`))
43ENGINE = InnoDB;
44
45
46-- -----------------------------------------------------
47-- Table `mydb`.`AJProfesor`
48-- -----------------------------------------------------
49CREATE TABLE IF NOT EXISTS `mydb`.`AJProfesor` (
50 `idProfesor` INT GENERATED ALWAYS AS () VIRTUAL,
51 `ime` VARCHAR(45) NOT NULL,
52 `prezime` VARCHAR(45) NOT NULL,
53 `zvanje` VARCHAR(45) NOT NULL,
54 `username` VARCHAR(15) NOT NULL,
55 PRIMARY KEY (`idProfesor`))
56ENGINE = InnoDB;
57
58
59-- -----------------------------------------------------
60-- Table `mydb`.`AJPredmet`
61-- -----------------------------------------------------
62CREATE TABLE IF NOT EXISTS `mydb`.`AJPredmet` (
63 `idPredmet` INT NOT NULL,
64 `naziv` VARCHAR(20) NOT NULL,
65 `Asistent_idAsistent` INT NOT NULL,
66 `Profesor_idProfesor` INT NOT NULL,
67 PRIMARY KEY (`idPredmet`),
68 INDEX `fk_Predmet_Asistent1_idx` (`Asistent_idAsistent` ASC) VISIBLE,
69 INDEX `fk_Predmet_Profesor1_idx` (`Profesor_idProfesor` ASC) VISIBLE,
70 CONSTRAINT `fk_Predmet_Asistent1`
71 FOREIGN KEY (`Asistent_idAsistent`)
72 REFERENCES `mydb`.`AJAsistent` (`idAsistent`)
73 ON DELETE NO ACTION
74 ON UPDATE NO ACTION,
75 CONSTRAINT `fk_Predmet_Profesor1`
76 FOREIGN KEY (`Profesor_idProfesor`)
77 REFERENCES `mydb`.`AJProfesor` (`idProfesor`)
78 ON DELETE NO ACTION
79 ON UPDATE NO ACTION)
80ENGINE = InnoDB;
81
82
83-- -----------------------------------------------------
84-- Table `mydb`.`AJTest`
85-- -----------------------------------------------------
86CREATE TABLE IF NOT EXISTS `mydb`.`AJTest` (
87 `idSemaTest` INT NOT NULL,
88 `AJPredmet_idPredmet` INT NOT NULL,
89 `imeTesta` VARCHAR(20) NOT NULL,
90 PRIMARY KEY (`idSemaTest`),
91 INDEX `fk_AJSemaTest_AJPredmet1_idx` (`AJPredmet_idPredmet` ASC) VISIBLE,
92 CONSTRAINT `fk_AJSemaTest_AJPredmet1`
93 FOREIGN KEY (`AJPredmet_idPredmet`)
94 REFERENCES `mydb`.`AJPredmet` (`idPredmet`)
95 ON DELETE NO ACTION
96 ON UPDATE NO ACTION)
97ENGINE = InnoDB;
98
99
100-- -----------------------------------------------------
101-- Table `mydb`.`AJPitanja`
102-- -----------------------------------------------------
103CREATE TABLE IF NOT EXISTS `mydb`.`AJPitanja` (
104 `idPitanja` INT NOT NULL,
105 `pitanje` VARCHAR(40) NOT NULL,
106 `brojPoena` INT NOT NULL,
107 `AJTest_idSemaTest` INT NOT NULL,
108 PRIMARY KEY (`idPitanja`),
109 INDEX `fk_AJPitanja_AJTest1_idx` (`AJTest_idSemaTest` ASC) VISIBLE,
110 CONSTRAINT `fk_AJPitanja_AJTest1`
111 FOREIGN KEY (`AJTest_idSemaTest`)
112 REFERENCES `mydb`.`AJTest` (`idSemaTest`)
113 ON DELETE NO ACTION
114 ON UPDATE NO ACTION)
115ENGINE = InnoDB;
116
117
118-- -----------------------------------------------------
119-- Table `mydb`.`AJUser`
120-- -----------------------------------------------------
121CREATE TABLE IF NOT EXISTS `mydb`.`AJUser` (
122 `idUser` INT GENERATED ALWAYS AS () VIRTUAL,
123 `username` VARCHAR(20) NOT NULL,
124 `password` VARCHAR(45) NOT NULL,
125 `uloga` VARCHAR(1) NOT NULL,
126 PRIMARY KEY (`idUser`))
127ENGINE = InnoDB;
128
129
130-- -----------------------------------------------------
131-- Table `mydb`.`AJRole`
132-- -----------------------------------------------------
133CREATE TABLE IF NOT EXISTS `mydb`.`AJRole` (
134 `idRole` INT GENERATED ALWAYS AS () VIRTUAL,
135 `Naziv` VARCHAR(20) NOT NULL,
136 PRIMARY KEY (`idRole`))
137ENGINE = InnoDB;
138
139
140-- -----------------------------------------------------
141-- Table `mydb`.`Predmet_has_Student`
142-- -----------------------------------------------------
143CREATE TABLE IF NOT EXISTS `mydb`.`Predmet_has_Student` (
144 `Predmet_idPredmet` INT NOT NULL,
145 `Student_idStudent` INT NOT NULL,
146 PRIMARY KEY (`Predmet_idPredmet`, `Student_idStudent`),
147 INDEX `fk_Predmet_has_Student_Student1_idx` (`Student_idStudent` ASC) VISIBLE,
148 INDEX `fk_Predmet_has_Student_Predmet_idx` (`Predmet_idPredmet` ASC) VISIBLE,
149 CONSTRAINT `fk_Predmet_has_Student_Predmet`
150 FOREIGN KEY (`Predmet_idPredmet`)
151 REFERENCES `mydb`.`AJPredmet` (`idPredmet`)
152 ON DELETE NO ACTION
153 ON UPDATE NO ACTION,
154 CONSTRAINT `fk_Predmet_has_Student_Student1`
155 FOREIGN KEY (`Student_idStudent`)
156 REFERENCES `mydb`.`AJStudent` (`idStudent`)
157 ON DELETE NO ACTION
158 ON UPDATE NO ACTION)
159ENGINE = InnoDB;
160
161
162-- -----------------------------------------------------
163-- Table `mydb`.`AJStudent_has_Predmet`
164-- -----------------------------------------------------
165CREATE TABLE IF NOT EXISTS `mydb`.`AJStudent_has_Predmet` (
166 `Student_idStudent` INT NOT NULL,
167 `Predmet_idPredmet` INT NOT NULL,
168 `brPolozenihTestova` INT NOT NULL,
169 PRIMARY KEY (`Student_idStudent`, `Predmet_idPredmet`),
170 INDEX `fk_Student_has_Predmet_Predmet1_idx` (`Predmet_idPredmet` ASC) VISIBLE,
171 INDEX `fk_Student_has_Predmet_Student1_idx` (`Student_idStudent` ASC) VISIBLE,
172 CONSTRAINT `fk_Student_has_Predmet_Student1`
173 FOREIGN KEY (`Student_idStudent`)
174 REFERENCES `mydb`.`AJStudent` (`idStudent`)
175 ON DELETE NO ACTION
176 ON UPDATE NO ACTION,
177 CONSTRAINT `fk_Student_has_Predmet_Predmet1`
178 FOREIGN KEY (`Predmet_idPredmet`)
179 REFERENCES `mydb`.`AJPredmet` (`idPredmet`)
180 ON DELETE NO ACTION
181 ON UPDATE NO ACTION)
182ENGINE = InnoDB;
183
184
185-- -----------------------------------------------------
186-- Table `mydb`.`AJUser_has_Role`
187-- -----------------------------------------------------
188CREATE TABLE IF NOT EXISTS `mydb`.`AJUser_has_Role` (
189 `User_idUser` INT NOT NULL,
190 `Role_idRole` INT NOT NULL,
191 PRIMARY KEY (`User_idUser`, `Role_idRole`),
192 INDEX `fk_User_has_Role_Role1_idx` (`Role_idRole` ASC) VISIBLE,
193 INDEX `fk_User_has_Role_User1_idx` (`User_idUser` ASC) VISIBLE,
194 CONSTRAINT `fk_User_has_Role_User1`
195 FOREIGN KEY (`User_idUser`)
196 REFERENCES `mydb`.`AJUser` (`idUser`)
197 ON DELETE NO ACTION
198 ON UPDATE NO ACTION,
199 CONSTRAINT `fk_User_has_Role_Role1`
200 FOREIGN KEY (`Role_idRole`)
201 REFERENCES `mydb`.`AJRole` (`idRole`)
202 ON DELETE NO ACTION
203 ON UPDATE NO ACTION)
204ENGINE = InnoDB;
205
206
207-- -----------------------------------------------------
208-- Table `mydb`.`AJObavestenje`
209-- -----------------------------------------------------
210CREATE TABLE IF NOT EXISTS `mydb`.`AJObavestenje` (
211 `idObavestenje` INT NOT NULL,
212 `tekst` VARCHAR(100) NOT NULL,
213 `datum` DATETIME NOT NULL,
214 `AJPredmet_idPredmet` INT NOT NULL,
215 PRIMARY KEY (`idObavestenje`),
216 INDEX `fk_Obavestenje_AJPredmet1_idx` (`AJPredmet_idPredmet` ASC) VISIBLE,
217 CONSTRAINT `fk_Obavestenje_AJPredmet1`
218 FOREIGN KEY (`AJPredmet_idPredmet`)
219 REFERENCES `mydb`.`AJPredmet` (`idPredmet`)
220 ON DELETE NO ACTION
221 ON UPDATE NO ACTION)
222ENGINE = InnoDB;
223
224
225-- -----------------------------------------------------
226-- Table `mydb`.`AJOdgovor`
227-- -----------------------------------------------------
228CREATE TABLE IF NOT EXISTS `mydb`.`AJOdgovor` (
229 `idOdgovor` INT NOT NULL,
230 `odgovor` VARCHAR(45) NOT NULL,
231 `AJPitanja_idPitanja` INT NOT NULL,
232 `AJStudent_idStudent` INT NOT NULL,
233 `tacnost` INT NOT NULL DEFAULT 1,
234 `AJPredmet_idPredmet` INT NOT NULL,
235 PRIMARY KEY (`idOdgovor`),
236 INDEX `fk_AJOdgovor_AJPitanja1_idx` (`AJPitanja_idPitanja` ASC) VISIBLE,
237 INDEX `fk_AJOdgovor_AJStudent1_idx` (`AJStudent_idStudent` ASC) VISIBLE,
238 INDEX `fk_AJOdgovor_AJPredmet1_idx` (`AJPredmet_idPredmet` ASC) VISIBLE,
239 CONSTRAINT `fk_AJOdgovor_AJPitanja1`
240 FOREIGN KEY (`AJPitanja_idPitanja`)
241 REFERENCES `mydb`.`AJPitanja` (`idPitanja`)
242 ON DELETE NO ACTION
243 ON UPDATE NO ACTION,
244 CONSTRAINT `fk_AJOdgovor_AJStudent1`
245 FOREIGN KEY (`AJStudent_idStudent`)
246 REFERENCES `mydb`.`AJStudent` (`idStudent`)
247 ON DELETE NO ACTION
248 ON UPDATE NO ACTION,
249 CONSTRAINT `fk_AJOdgovor_AJPredmet1`
250 FOREIGN KEY (`AJPredmet_idPredmet`)
251 REFERENCES `mydb`.`AJPredmet` (`idPredmet`)
252 ON DELETE NO ACTION
253 ON UPDATE NO ACTION)
254ENGINE = InnoDB;
255
256
257SET SQL_MODE=@OLD_SQL_MODE;
258SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
259SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;