· 7 years ago · Jan 20, 2019, 02:18 PM
1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @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';
6
7-- -----------------------------------------------------
8-- Schema mydbOI
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema mydbOI
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `mydbOI` DEFAULT CHARACTER SET utf8 ;
15USE `mydbOI` ;
16
17-- -----------------------------------------------------
18-- Table `mydbOI`.`KomentatorskaKabina`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `mydbOI`.`KomentatorskaKabina` (
21 `idkomentatorskaKabina` INT NOT NULL AUTO_INCREMENT,
22 `oznaka` VARCHAR(45) NOT NULL,
23 PRIMARY KEY (`idkomentatorskaKabina`))
24ENGINE = InnoDB;
25
26
27-- -----------------------------------------------------
28-- Table `mydbOI`.`Kraj`
29-- -----------------------------------------------------
30CREATE TABLE IF NOT EXISTS `mydbOI`.`Kraj` (
31 `idKraj` INT NOT NULL AUTO_INCREMENT,
32 `postnaStevilka` INT NOT NULL,
33 `imePoste` VARCHAR(45) NOT NULL,
34 PRIMARY KEY (`idKraj`))
35ENGINE = InnoDB;
36
37
38-- -----------------------------------------------------
39-- Table `mydbOI`.`Naslov`
40-- -----------------------------------------------------
41CREATE TABLE IF NOT EXISTS `mydbOI`.`Naslov` (
42 `idNaslov` INT NOT NULL AUTO_INCREMENT,
43 `ulica` VARCHAR(45) NOT NULL,
44 `hisnaSt` VARCHAR(45) NOT NULL,
45 `Kraj_idKraj` INT NOT NULL,
46 PRIMARY KEY (`idNaslov`),
47 INDEX `fk_Naslov_Pošta1_idx` (`Kraj_idKraj` ASC) VISIBLE,
48 CONSTRAINT `fk_Naslov_Pošta1`
49 FOREIGN KEY (`Kraj_idKraj`)
50 REFERENCES `mydbOI`.`Kraj` (`idKraj`)
51 ON DELETE NO ACTION
52 ON UPDATE NO ACTION)
53ENGINE = InnoDB;
54
55
56-- -----------------------------------------------------
57-- Table `mydbOI`.`Prizorisce`
58-- -----------------------------------------------------
59CREATE TABLE IF NOT EXISTS `mydbOI`.`Prizorisce` (
60 `idPrizorisce` INT NOT NULL AUTO_INCREMENT,
61 `ime` VARCHAR(45) NOT NULL,
62 `oznaka` VARCHAR(45) NOT NULL,
63 `tipPrizorisca` VARCHAR(45) NOT NULL,
64 `stSedezev` VARCHAR(45) NOT NULL,
65 `KomentatorskaKabina_idKomentatorskaKabina` INT NOT NULL,
66 `Naslov_idNaslov` INT NOT NULL,
67 PRIMARY KEY (`idPrizorisce`),
68 INDEX `fk_PrizoriÅ¡Äe_komentatorskaKabina1_idx` (`KomentatorskaKabina_idKomentatorskaKabina` ASC) VISIBLE,
69 INDEX `fk_Prizorisce_Naslov1_idx` (`Naslov_idNaslov` ASC) VISIBLE,
70 CONSTRAINT `fk_PrizoriÅ¡Äe_komentatorskaKabina1`
71 FOREIGN KEY (`KomentatorskaKabina_idKomentatorskaKabina`)
72 REFERENCES `mydbOI`.`KomentatorskaKabina` (`idkomentatorskaKabina`)
73 ON DELETE NO ACTION
74 ON UPDATE NO ACTION,
75 CONSTRAINT `fk_Prizorisce_Naslov1`
76 FOREIGN KEY (`Naslov_idNaslov`)
77 REFERENCES `mydbOI`.`Naslov` (`idNaslov`)
78 ON DELETE NO ACTION
79 ON UPDATE NO ACTION)
80ENGINE = InnoDB;
81
82
83-- -----------------------------------------------------
84-- Table `mydbOI`.`Panoga`
85-- -----------------------------------------------------
86CREATE TABLE IF NOT EXISTS `mydbOI`.`Panoga` (
87 `idPanoga` INT NOT NULL,
88 `naziv` VARCHAR(45) NOT NULL,
89 PRIMARY KEY (`idPanoga`))
90ENGINE = InnoDB;
91
92
93-- -----------------------------------------------------
94-- Table `mydbOI`.`Disciplina`
95-- -----------------------------------------------------
96CREATE TABLE IF NOT EXISTS `mydbOI`.`Disciplina` (
97 `idDisciplina` INT NOT NULL AUTO_INCREMENT,
98 `naziv` VARCHAR(45) NOT NULL,
99 `Panoga_idPanoga` INT NOT NULL,
100 PRIMARY KEY (`idDisciplina`),
101 INDEX `fk_Disciplina_panoga1_idx` (`Panoga_idPanoga` ASC) VISIBLE,
102 CONSTRAINT `fk_Disciplina_panoga1`
103 FOREIGN KEY (`Panoga_idPanoga`)
104 REFERENCES `mydbOI`.`Panoga` (`idPanoga`)
105 ON DELETE NO ACTION
106 ON UPDATE NO ACTION)
107ENGINE = InnoDB;
108
109
110-- -----------------------------------------------------
111-- Table `mydbOI`.`Tekma`
112-- -----------------------------------------------------
113CREATE TABLE IF NOT EXISTS `mydbOI`.`Tekma` (
114 `idTekma` INT NOT NULL,
115 `naziv` VARCHAR(45) NOT NULL,
116 `datumTekme` DATETIME NOT NULL,
117 `Prizorisce_idPrizorisce` INT NOT NULL,
118 `Disciplina_idDisciplina` INT NOT NULL,
119 PRIMARY KEY (`idTekma`),
120 INDEX `fk_tekma_PrizoriÅ¡Äe1_idx` (`Prizorisce_idPrizorisce` ASC) VISIBLE,
121 INDEX `fk_tekma_Disciplina1_idx` (`Disciplina_idDisciplina` ASC) VISIBLE,
122 CONSTRAINT `fk_tekma_PrizoriÅ¡Äe1`
123 FOREIGN KEY (`Prizorisce_idPrizorisce`)
124 REFERENCES `mydbOI`.`Prizorisce` (`idPrizorisce`)
125 ON DELETE NO ACTION
126 ON UPDATE NO ACTION,
127 CONSTRAINT `fk_tekma_Disciplina1`
128 FOREIGN KEY (`Disciplina_idDisciplina`)
129 REFERENCES `mydbOI`.`Disciplina` (`idDisciplina`)
130 ON DELETE NO ACTION
131 ON UPDATE NO ACTION)
132ENGINE = InnoDB;
133
134
135-- -----------------------------------------------------
136-- Table `mydbOI`.`RezultatTekme`
137-- -----------------------------------------------------
138CREATE TABLE IF NOT EXISTS `mydbOI`.`RezultatTekme` (
139 `idRezultatTekme` INT NOT NULL AUTO_INCREMENT,
140 `tocke` DOUBLE NULL,
141 `cas` VARCHAR(45) NULL,
142 `zasedenoMesto` INT NOT NULL,
143 `tekma_idtekma` INT NOT NULL,
144 PRIMARY KEY (`idRezultatTekme`),
145 INDEX `fk_RezultatTekme_tekma1_idx` (`tekma_idtekma` ASC) VISIBLE,
146 CONSTRAINT `fk_RezultatTekme_tekma1`
147 FOREIGN KEY (`tekma_idtekma`)
148 REFERENCES `mydbOI`.`Tekma` (`idTekma`)
149 ON DELETE NO ACTION
150 ON UPDATE NO ACTION)
151ENGINE = InnoDB;
152
153
154-- -----------------------------------------------------
155-- Table `mydbOI`.`StartnaLista`
156-- -----------------------------------------------------
157CREATE TABLE IF NOT EXISTS `mydbOI`.`StartnaLista` (
158 `idStartnaLista` INT NOT NULL AUTO_INCREMENT,
159 `datumStarta` DATETIME NOT NULL,
160 PRIMARY KEY (`idStartnaLista`))
161ENGINE = InnoDB;
162
163
164-- -----------------------------------------------------
165-- Table `mydbOI`.`OllimpijskaVas`
166-- -----------------------------------------------------
167CREATE TABLE IF NOT EXISTS `mydbOI`.`OllimpijskaVas` (
168 `idOlimpijskaVas` INT NOT NULL AUTO_INCREMENT,
169 `naziv` VARCHAR(45) NOT NULL,
170 PRIMARY KEY (`idOlimpijskaVas`))
171ENGINE = InnoDB;
172
173
174-- -----------------------------------------------------
175-- Table `mydbOI`.`Novinarji`
176-- -----------------------------------------------------
177CREATE TABLE IF NOT EXISTS `mydbOI`.`Novinarji` (
178 `idNovinarji` INT NOT NULL AUTO_INCREMENT,
179 `ime` VARCHAR(45) NOT NULL,
180 `priimek` VARCHAR(45) NOT NULL,
181 `delovnoMesto` VARCHAR(45) NOT NULL,
182 `medijskaHisa` VARCHAR(45) NOT NULL,
183 `olimpijskaVas_idolimpijskaVas` INT NOT NULL,
184 PRIMARY KEY (`idNovinarji`),
185 INDEX `fk_Novinarji_olimpijskaVas1_idx` (`olimpijskaVas_idolimpijskaVas` ASC) VISIBLE,
186 CONSTRAINT `fk_Novinarji_olimpijskaVas1`
187 FOREIGN KEY (`olimpijskaVas_idolimpijskaVas`)
188 REFERENCES `mydbOI`.`OllimpijskaVas` (`idOlimpijskaVas`)
189 ON DELETE NO ACTION
190 ON UPDATE NO ACTION)
191ENGINE = InnoDB;
192
193
194-- -----------------------------------------------------
195-- Table `mydbOI`.`SnemalnaEkipa`
196-- -----------------------------------------------------
197CREATE TABLE IF NOT EXISTS `mydbOI`.`SnemalnaEkipa` (
198 `idSnemalnaEkipa` INT NOT NULL AUTO_INCREMENT,
199 `oznaka` VARCHAR(45) NOT NULL,
200 `OlimpijskaVas_idOlimpijskaVas` INT NOT NULL,
201 PRIMARY KEY (`idSnemalnaEkipa`),
202 INDEX `fk_snemalnaEkipa_olimpijskaVas1_idx` (`OlimpijskaVas_idOlimpijskaVas` ASC) VISIBLE,
203 CONSTRAINT `fk_snemalnaEkipa_olimpijskaVas1`
204 FOREIGN KEY (`OlimpijskaVas_idOlimpijskaVas`)
205 REFERENCES `mydbOI`.`OllimpijskaVas` (`idOlimpijskaVas`)
206 ON DELETE NO ACTION
207 ON UPDATE NO ACTION)
208ENGINE = InnoDB;
209
210
211-- -----------------------------------------------------
212-- Table `mydbOI`.`SnemalnaOprema`
213-- -----------------------------------------------------
214CREATE TABLE IF NOT EXISTS `mydbOI`.`SnemalnaOprema` (
215 `idSnemalnaOprema` INT NOT NULL AUTO_INCREMENT,
216 `naziv` VARCHAR(45) NOT NULL,
217 `znamka` VARCHAR(45) NOT NULL,
218 `namen` VARCHAR(45) NOT NULL,
219 PRIMARY KEY (`idSnemalnaOprema`))
220ENGINE = InnoDB;
221
222
223-- -----------------------------------------------------
224-- Table `mydbOI`.`Sodnik`
225-- -----------------------------------------------------
226CREATE TABLE IF NOT EXISTS `mydbOI`.`Sodnik` (
227 `idSodnik` INT NOT NULL AUTO_INCREMENT,
228 `ime` VARCHAR(45) NOT NULL,
229 `priimek` VARCHAR(45) NOT NULL,
230 `datumRojstva` DATE NOT NULL,
231 `nacionalnost` VARCHAR(45) NOT NULL,
232 `olimpijskaVas_idolimpijskaVas` INT NOT NULL,
233 PRIMARY KEY (`idSodnik`),
234 INDEX `fk_Sodnik_olimpijskaVas1_idx` (`olimpijskaVas_idolimpijskaVas` ASC) VISIBLE,
235 CONSTRAINT `fk_Sodnik_olimpijskaVas1`
236 FOREIGN KEY (`olimpijskaVas_idolimpijskaVas`)
237 REFERENCES `mydbOI`.`OllimpijskaVas` (`idOlimpijskaVas`)
238 ON DELETE NO ACTION
239 ON UPDATE NO ACTION)
240ENGINE = InnoDB;
241
242
243-- -----------------------------------------------------
244-- Table `mydbOI`.`TipEkipe`
245-- -----------------------------------------------------
246CREATE TABLE IF NOT EXISTS `mydbOI`.`TipEkipe` (
247 `idTipEkipe` INT NOT NULL,
248 `tip` VARCHAR(45) NOT NULL,
249 PRIMARY KEY (`idTipEkipe`))
250ENGINE = InnoDB;
251
252
253-- -----------------------------------------------------
254-- Table `mydbOI`.`Drzava`
255-- -----------------------------------------------------
256CREATE TABLE IF NOT EXISTS `mydbOI`.`Drzava` (
257 `idDrzava` INT NOT NULL,
258 `naziv` VARCHAR(45) NOT NULL,
259 `himna` VARCHAR(45) NOT NULL,
260 `stPrebivalcev` INT NOT NULL,
261 `celina` VARCHAR(45) NOT NULL,
262 PRIMARY KEY (`idDrzava`))
263ENGINE = InnoDB;
264
265
266-- -----------------------------------------------------
267-- Table `mydbOI`.`Ekipa`
268-- -----------------------------------------------------
269CREATE TABLE IF NOT EXISTS `mydbOI`.`Ekipa` (
270 `idEkipa` INT NOT NULL AUTO_INCREMENT,
271 `naziv` VARCHAR(45) NOT NULL,
272 `stClanov` INT NOT NULL,
273 `tipEkipe_idtipEkipe` INT NOT NULL,
274 `drzava_iddrzava` INT NOT NULL,
275 `RezultatTekme_idRezultatTekme` INT NOT NULL,
276 PRIMARY KEY (`idEkipa`),
277 INDEX `fk_Ekipa_tipEkipe1_idx` (`tipEkipe_idtipEkipe` ASC) VISIBLE,
278 INDEX `fk_Ekipa_drzava1_idx` (`drzava_iddrzava` ASC) VISIBLE,
279 INDEX `fk_Ekipa_RezultatTekme1_idx` (`RezultatTekme_idRezultatTekme` ASC) VISIBLE,
280 CONSTRAINT `fk_Ekipa_tipEkipe1`
281 FOREIGN KEY (`tipEkipe_idtipEkipe`)
282 REFERENCES `mydbOI`.`TipEkipe` (`idTipEkipe`)
283 ON DELETE NO ACTION
284 ON UPDATE NO ACTION,
285 CONSTRAINT `fk_Ekipa_drzava1`
286 FOREIGN KEY (`drzava_iddrzava`)
287 REFERENCES `mydbOI`.`Drzava` (`idDrzava`)
288 ON DELETE NO ACTION
289 ON UPDATE NO ACTION,
290 CONSTRAINT `fk_Ekipa_RezultatTekme1`
291 FOREIGN KEY (`RezultatTekme_idRezultatTekme`)
292 REFERENCES `mydbOI`.`RezultatTekme` (`idRezultatTekme`)
293 ON DELETE NO ACTION
294 ON UPDATE NO ACTION)
295ENGINE = InnoDB;
296
297
298-- -----------------------------------------------------
299-- Table `mydbOI`.`Sportnik`
300-- -----------------------------------------------------
301CREATE TABLE IF NOT EXISTS `mydbOI`.`Sportnik` (
302 `idSportnik` INT NOT NULL AUTO_INCREMENT,
303 `ime` VARCHAR(45) NOT NULL,
304 `priimek` VARCHAR(45) NOT NULL,
305 `datumRojstva` DATE NOT NULL,
306 `visina` DOUBLE NOT NULL,
307 `teza` VARCHAR(45) NOT NULL,
308 `kategorija` VARCHAR(45) NULL,
309 `Ekipa_idEkipa` INT NOT NULL,
310 PRIMARY KEY (`idSportnik`),
311 INDEX `fk_Sportnik_Ekipa1_idx` (`Ekipa_idEkipa` ASC) VISIBLE,
312 CONSTRAINT `fk_Sportnik_Ekipa1`
313 FOREIGN KEY (`Ekipa_idEkipa`)
314 REFERENCES `mydbOI`.`Ekipa` (`idEkipa`)
315 ON DELETE NO ACTION
316 ON UPDATE NO ACTION)
317ENGINE = InnoDB;
318
319
320-- -----------------------------------------------------
321-- Table `mydbOI`.`Hotel`
322-- -----------------------------------------------------
323CREATE TABLE IF NOT EXISTS `mydbOI`.`Hotel` (
324 `idHotel` INT NOT NULL AUTO_INCREMENT,
325 `naziv` VARCHAR(45) NOT NULL,
326 `zvezdice` INT NOT NULL,
327 `Naslov_idNaslov` INT NOT NULL,
328 `olimpijskaVas_idolimpijskaVas` INT NOT NULL,
329 PRIMARY KEY (`idHotel`),
330 INDEX `fk_Hotel_Naslov1_idx` (`Naslov_idNaslov` ASC) VISIBLE,
331 INDEX `fk_Hotel_olimpijskaVas1_idx` (`olimpijskaVas_idolimpijskaVas` ASC) VISIBLE,
332 CONSTRAINT `fk_Hotel_Naslov1`
333 FOREIGN KEY (`Naslov_idNaslov`)
334 REFERENCES `mydbOI`.`Naslov` (`idNaslov`)
335 ON DELETE NO ACTION
336 ON UPDATE NO ACTION,
337 CONSTRAINT `fk_Hotel_olimpijskaVas1`
338 FOREIGN KEY (`olimpijskaVas_idolimpijskaVas`)
339 REFERENCES `mydbOI`.`OllimpijskaVas` (`idOlimpijskaVas`)
340 ON DELETE NO ACTION
341 ON UPDATE NO ACTION)
342ENGINE = InnoDB;
343
344
345-- -----------------------------------------------------
346-- Table `mydbOI`.`ZasebnaHiska`
347-- -----------------------------------------------------
348CREATE TABLE IF NOT EXISTS `mydbOI`.`ZasebnaHiska` (
349 `idZasebnaHiska` INT NOT NULL AUTO_INCREMENT,
350 `tipHiske` VARCHAR(45) NOT NULL,
351 `stPostelj` VARCHAR(45) NOT NULL,
352 `zvezdice` INT NOT NULL,
353 `Naslov_idNaslov` INT NOT NULL,
354 `OlimpijskaVas_idOlimpijskaVas` INT NOT NULL,
355 PRIMARY KEY (`idZasebnaHiska`),
356 INDEX `fk_zasebnaHiška_Naslov1_idx` (`Naslov_idNaslov` ASC) VISIBLE,
357 INDEX `fk_zasebnaHiška_olimpijskaVas1_idx` (`OlimpijskaVas_idOlimpijskaVas` ASC) VISIBLE,
358 CONSTRAINT `fk_zasebnaHiška_Naslov1`
359 FOREIGN KEY (`Naslov_idNaslov`)
360 REFERENCES `mydbOI`.`Naslov` (`idNaslov`)
361 ON DELETE NO ACTION
362 ON UPDATE NO ACTION,
363 CONSTRAINT `fk_zasebnaHiška_olimpijskaVas1`
364 FOREIGN KEY (`OlimpijskaVas_idOlimpijskaVas`)
365 REFERENCES `mydbOI`.`OllimpijskaVas` (`idOlimpijskaVas`)
366 ON DELETE NO ACTION
367 ON UPDATE NO ACTION)
368ENGINE = InnoDB;
369
370
371-- -----------------------------------------------------
372-- Table `mydbOI`.`Prizorisce_has_StartnaLista`
373-- -----------------------------------------------------
374CREATE TABLE IF NOT EXISTS `mydbOI`.`Prizorisce_has_StartnaLista` (
375 `idPrizorisce_has_StartnaLista` INT NOT NULL,
376 `Prizorisce_idPrizorisce` INT NOT NULL,
377 `StartnaLista_idStartnaLista` INT NOT NULL,
378 INDEX `fk_PrizoriÅ¡Äe_has_startnaLista_startnaLista1_idx` (`StartnaLista_idStartnaLista` ASC) VISIBLE,
379 INDEX `fk_PrizoriÅ¡Äe_has_startnaLista_PrizoriÅ¡Äe1_idx` (`Prizorisce_idPrizorisce` ASC) VISIBLE,
380 PRIMARY KEY (`idPrizorisce_has_StartnaLista`),
381 CONSTRAINT `fk_PrizoriÅ¡Äe_has_startnaLista_PrizoriÅ¡Äe1`
382 FOREIGN KEY (`Prizorisce_idPrizorisce`)
383 REFERENCES `mydbOI`.`Prizorisce` (`idPrizorisce`)
384 ON DELETE NO ACTION
385 ON UPDATE NO ACTION,
386 CONSTRAINT `fk_PrizoriÅ¡Äe_has_startnaLista_startnaLista1`
387 FOREIGN KEY (`StartnaLista_idStartnaLista`)
388 REFERENCES `mydbOI`.`StartnaLista` (`idStartnaLista`)
389 ON DELETE NO ACTION
390 ON UPDATE NO ACTION)
391ENGINE = InnoDB;
392
393
394-- -----------------------------------------------------
395-- Table `mydbOI`.`Sportnik_has_RezultatTekme`
396-- -----------------------------------------------------
397CREATE TABLE IF NOT EXISTS `mydbOI`.`Sportnik_has_RezultatTekme` (
398 `idSportnik_has_RezultatTekme` INT NOT NULL,
399 `Sportnik_idSportnik` INT NOT NULL,
400 `RezultatTekme_idRezultatTekme` INT NOT NULL,
401 INDEX `fk_Å portnik_has_RezultatTekme_RezultatTekme1_idx` (`RezultatTekme_idRezultatTekme` ASC) VISIBLE,
402 INDEX `fk_Å portnik_has_RezultatTekme_Å portnik1_idx` (`Sportnik_idSportnik` ASC) VISIBLE,
403 PRIMARY KEY (`idSportnik_has_RezultatTekme`),
404 CONSTRAINT `fk_Å portnik_has_RezultatTekme_Å portnik1`
405 FOREIGN KEY (`Sportnik_idSportnik`)
406 REFERENCES `mydbOI`.`Sportnik` (`idSportnik`)
407 ON DELETE NO ACTION
408 ON UPDATE NO ACTION,
409 CONSTRAINT `fk_Å portnik_has_RezultatTekme_RezultatTekme1`
410 FOREIGN KEY (`RezultatTekme_idRezultatTekme`)
411 REFERENCES `mydbOI`.`RezultatTekme` (`idRezultatTekme`)
412 ON DELETE NO ACTION
413 ON UPDATE NO ACTION)
414ENGINE = InnoDB;
415
416
417-- -----------------------------------------------------
418-- Table `mydbOI`.`SnemalnaOprema_has_SnemalnaEkipa`
419-- -----------------------------------------------------
420CREATE TABLE IF NOT EXISTS `mydbOI`.`SnemalnaOprema_has_SnemalnaEkipa` (
421 `idSnemalnaOprema_has_SnemalnaEkipa` VARCHAR(45) NOT NULL,
422 `SnemalnaOprema_idSnemalnaOprema` INT NOT NULL,
423 `SnemalnaEkipa_idSnemalnaEkipa` INT NOT NULL,
424 PRIMARY KEY (`idSnemalnaOprema_has_SnemalnaEkipa`),
425 INDEX `fk_snemalnaOprema_has_snemalnaEkipa_snemalnaEkipa1_idx` (`SnemalnaEkipa_idSnemalnaEkipa` ASC) VISIBLE,
426 INDEX `fk_snemalnaOprema_has_snemalnaEkipa_snemalnaOprema1_idx` (`SnemalnaOprema_idSnemalnaOprema` ASC) VISIBLE,
427 CONSTRAINT `fk_snemalnaOprema_has_snemalnaEkipa_snemalnaOprema1`
428 FOREIGN KEY (`SnemalnaOprema_idSnemalnaOprema`)
429 REFERENCES `mydbOI`.`SnemalnaOprema` (`idSnemalnaOprema`)
430 ON DELETE NO ACTION
431 ON UPDATE NO ACTION,
432 CONSTRAINT `fk_snemalnaOprema_has_snemalnaEkipa_snemalnaEkipa1`
433 FOREIGN KEY (`SnemalnaEkipa_idSnemalnaEkipa`)
434 REFERENCES `mydbOI`.`SnemalnaEkipa` (`idSnemalnaEkipa`)
435 ON DELETE NO ACTION
436 ON UPDATE NO ACTION)
437ENGINE = InnoDB;
438
439
440-- -----------------------------------------------------
441-- Table `mydbOI`.`Novinarji_has_KomentatorskaKabina`
442-- -----------------------------------------------------
443CREATE TABLE IF NOT EXISTS `mydbOI`.`Novinarji_has_KomentatorskaKabina` (
444 `idNovinarji_has_komentatorskaKabina` VARCHAR(45) NOT NULL,
445 `Novinarji_idNovinarji` INT NOT NULL,
446 `KomentatorskaKabina_idKomentatorskaKabina` INT NOT NULL,
447 INDEX `fk_Novinarji_has_komentatorskaKabina_komentatorskaKabina1_idx` (`KomentatorskaKabina_idKomentatorskaKabina` ASC) VISIBLE,
448 INDEX `fk_Novinarji_has_komentatorskaKabina_Novinarji1_idx` (`Novinarji_idNovinarji` ASC) VISIBLE,
449 PRIMARY KEY (`idNovinarji_has_komentatorskaKabina`),
450 CONSTRAINT `fk_Novinarji_has_komentatorskaKabina_Novinarji1`
451 FOREIGN KEY (`Novinarji_idNovinarji`)
452 REFERENCES `mydbOI`.`Novinarji` (`idNovinarji`)
453 ON DELETE NO ACTION
454 ON UPDATE NO ACTION,
455 CONSTRAINT `fk_Novinarji_has_komentatorskaKabina_komentatorskaKabina1`
456 FOREIGN KEY (`KomentatorskaKabina_idKomentatorskaKabina`)
457 REFERENCES `mydbOI`.`KomentatorskaKabina` (`idkomentatorskaKabina`)
458 ON DELETE NO ACTION
459 ON UPDATE NO ACTION)
460ENGINE = InnoDB;
461
462
463-- -----------------------------------------------------
464-- Table `mydbOI`.`Prizorisce_has_snemalnaEkipa`
465-- -----------------------------------------------------
466CREATE TABLE IF NOT EXISTS `mydbOI`.`Prizorisce_has_snemalnaEkipa` (
467 `idPrizorisce_has_SnemalnaEkipa` INT NOT NULL,
468 `PrizoriÅ¡Äe_idPrizoriÅ¡Äe` INT NOT NULL,
469 `SnemalnaEkipa_idSnemalnaEkipa` INT NOT NULL,
470 INDEX `fk_PrizoriÅ¡Äe_has_snemalnaEkipa_snemalnaEkipa1_idx` (`SnemalnaEkipa_idSnemalnaEkipa` ASC) VISIBLE,
471 INDEX `fk_PrizoriÅ¡Äe_has_snemalnaEkipa_PrizoriÅ¡Äe1_idx` (`PrizoriÅ¡Äe_idPrizoriÅ¡Äe` ASC) VISIBLE,
472 PRIMARY KEY (`idPrizorisce_has_SnemalnaEkipa`),
473 CONSTRAINT `fk_PrizoriÅ¡Äe_has_snemalnaEkipa_PrizoriÅ¡Äe1`
474 FOREIGN KEY (`PrizoriÅ¡Äe_idPrizoriÅ¡Äe`)
475 REFERENCES `mydbOI`.`Prizorisce` (`idPrizorisce`)
476 ON DELETE NO ACTION
477 ON UPDATE NO ACTION,
478 CONSTRAINT `fk_PrizoriÅ¡Äe_has_snemalnaEkipa_snemalnaEkipa1`
479 FOREIGN KEY (`SnemalnaEkipa_idSnemalnaEkipa`)
480 REFERENCES `mydbOI`.`SnemalnaEkipa` (`idSnemalnaEkipa`)
481 ON DELETE NO ACTION
482 ON UPDATE NO ACTION)
483ENGINE = InnoDB;
484
485
486-- -----------------------------------------------------
487-- Table `mydbOI`.`StartnaLista_has_Sportnik`
488-- -----------------------------------------------------
489CREATE TABLE IF NOT EXISTS `mydbOI`.`StartnaLista_has_Sportnik` (
490 `idStartnaLista_has_Sportnik` INT NOT NULL,
491 `StartnaLista_idStartnaLista` INT NOT NULL,
492 `Sportnik_idSportnik` INT NOT NULL,
493 PRIMARY KEY (`idStartnaLista_has_Sportnik`),
494 INDEX `fk_startnaLista_has_Å portnik_Å portnik1_idx` (`Sportnik_idSportnik` ASC) VISIBLE,
495 INDEX `fk_startnaLista_has_Å portnik_startnaLista1_idx` (`StartnaLista_idStartnaLista` ASC) VISIBLE,
496 CONSTRAINT `fk_startnaLista_has_Å portnik_startnaLista1`
497 FOREIGN KEY (`StartnaLista_idStartnaLista`)
498 REFERENCES `mydbOI`.`StartnaLista` (`idStartnaLista`)
499 ON DELETE NO ACTION
500 ON UPDATE NO ACTION,
501 CONSTRAINT `fk_startnaLista_has_Å portnik_Å portnik1`
502 FOREIGN KEY (`Sportnik_idSportnik`)
503 REFERENCES `mydbOI`.`Sportnik` (`idSportnik`)
504 ON DELETE NO ACTION
505 ON UPDATE NO ACTION)
506ENGINE = InnoDB;
507
508
509-- -----------------------------------------------------
510-- Table `mydbOI`.`Trener`
511-- -----------------------------------------------------
512CREATE TABLE IF NOT EXISTS `mydbOI`.`Trener` (
513 `idTrener` INT NOT NULL,
514 `ime` VARCHAR(45) NOT NULL,
515 `priimek` VARCHAR(45) NOT NULL,
516 `datumRojstva` DATE NOT NULL,
517 `Ekipa_idEkipa` INT NOT NULL,
518 PRIMARY KEY (`idTrener`),
519 INDEX `fk_trener_Ekipa1_idx` (`Ekipa_idEkipa` ASC) VISIBLE,
520 CONSTRAINT `fk_trener_Ekipa1`
521 FOREIGN KEY (`Ekipa_idEkipa`)
522 REFERENCES `mydbOI`.`Ekipa` (`idEkipa`)
523 ON DELETE NO ACTION
524 ON UPDATE NO ACTION)
525ENGINE = InnoDB;
526
527
528-- -----------------------------------------------------
529-- Table `mydbOI`.`Sodnik_has_Tekma`
530-- -----------------------------------------------------
531CREATE TABLE IF NOT EXISTS `mydbOI`.`Sodnik_has_Tekma` (
532 `idSodnik_has_tekma` INT NOT NULL,
533 `Sodnik_idSodnik` INT NOT NULL,
534 `Tekma_idTekma` INT NOT NULL,
535 INDEX `fk_Sodnik_has_tekma_tekma1_idx` (`Tekma_idTekma` ASC) VISIBLE,
536 INDEX `fk_Sodnik_has_tekma_Sodnik1_idx` (`Sodnik_idSodnik` ASC) VISIBLE,
537 PRIMARY KEY (`idSodnik_has_tekma`),
538 CONSTRAINT `fk_Sodnik_has_tekma_Sodnik1`
539 FOREIGN KEY (`Sodnik_idSodnik`)
540 REFERENCES `mydbOI`.`Sodnik` (`idSodnik`)
541 ON DELETE NO ACTION
542 ON UPDATE NO ACTION,
543 CONSTRAINT `fk_Sodnik_has_tekma_tekma1`
544 FOREIGN KEY (`Tekma_idTekma`)
545 REFERENCES `mydbOI`.`Tekma` (`idTekma`)
546 ON DELETE NO ACTION
547 ON UPDATE NO ACTION)
548ENGINE = InnoDB;
549
550
551-- -----------------------------------------------------
552-- Table `mydbOI`.`Sportnik_has_Panoga`
553-- -----------------------------------------------------
554CREATE TABLE IF NOT EXISTS `mydbOI`.`Sportnik_has_Panoga` (
555 `idSportnik_has_Panoga` INT NOT NULL,
556 `Sportnik_idSportnik` INT NOT NULL,
557 `Panoga_idPanoga` INT NOT NULL,
558 PRIMARY KEY (`idSportnik_has_Panoga`),
559 INDEX `fk_Å portnik_has_panoga_panoga1_idx` (`Panoga_idPanoga` ASC) VISIBLE,
560 INDEX `fk_Å portnik_has_panoga_Å portnik1_idx` (`Sportnik_idSportnik` ASC) VISIBLE,
561 CONSTRAINT `fk_Å portnik_has_panoga_Å portnik1`
562 FOREIGN KEY (`Sportnik_idSportnik`)
563 REFERENCES `mydbOI`.`Sportnik` (`idSportnik`)
564 ON DELETE NO ACTION
565 ON UPDATE NO ACTION,
566 CONSTRAINT `fk_Å portnik_has_panoga_panoga1`
567 FOREIGN KEY (`Panoga_idPanoga`)
568 REFERENCES `mydbOI`.`Panoga` (`idPanoga`)
569 ON DELETE NO ACTION
570 ON UPDATE NO ACTION)
571ENGINE = InnoDB;
572
573
574-- -----------------------------------------------------
575-- Table `mydbOI`.`Panoga_has_Ekipa`
576-- -----------------------------------------------------
577CREATE TABLE IF NOT EXISTS `mydbOI`.`Panoga_has_Ekipa` (
578 `idPanoga_has_Ekipa` INT NOT NULL,
579 `Panoga_idPanoga` INT NOT NULL,
580 `Ekipa_idEkipa` INT NOT NULL,
581 INDEX `fk_panoga_has_Ekipa_Ekipa1_idx` (`Ekipa_idEkipa` ASC) VISIBLE,
582 INDEX `fk_panoga_has_Ekipa_panoga1_idx` (`Panoga_idPanoga` ASC) VISIBLE,
583 PRIMARY KEY (`idPanoga_has_Ekipa`),
584 CONSTRAINT `fk_panoga_has_Ekipa_panoga1`
585 FOREIGN KEY (`Panoga_idPanoga`)
586 REFERENCES `mydbOI`.`Panoga` (`idPanoga`)
587 ON DELETE NO ACTION
588 ON UPDATE NO ACTION,
589 CONSTRAINT `fk_panoga_has_Ekipa_Ekipa1`
590 FOREIGN KEY (`Ekipa_idEkipa`)
591 REFERENCES `mydbOI`.`Ekipa` (`idEkipa`)
592 ON DELETE NO ACTION
593 ON UPDATE NO ACTION)
594ENGINE = InnoDB;
595
596
597SET SQL_MODE=@OLD_SQL_MODE;
598SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
599SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;