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