· 8 years ago · Feb 07, 2018, 09:18 AM
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='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema mydb
9-- -----------------------------------------------------
10-- -----------------------------------------------------
11-- Schema milos.rodic.v16
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema milos.rodic.v16
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `milos.rodic.v16` DEFAULT CHARACTER SET latin1 ;
18USE `milos.rodic.v16` ;
19
20-- -----------------------------------------------------
21-- Table `milos.rodic.v16`.`Podrucje_rada`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `milos.rodic.v16`.`Podrucje_rada` (
24 `Podrucje_rada_ID` INT NOT NULL AUTO_INCREMENT,
25 `Podrucje_rada_naziv` VARCHAR(45) NOT NULL,
26 PRIMARY KEY (`Podrucje_rada_ID`))
27ENGINE = InnoDB;
28
29
30-- -----------------------------------------------------
31-- Table `milos.rodic.v16`.`Obrazovni_profil`
32-- -----------------------------------------------------
33CREATE TABLE IF NOT EXISTS `milos.rodic.v16`.`Obrazovni_profil` (
34 `Obrazovni_profil_ID` INT NOT NULL AUTO_INCREMENT,
35 `Obrazovni_profil_naziv` VARCHAR(200) NOT NULL,
36 `Podrucje_rada_Podrucje_rada_ID` INT NOT NULL,
37 PRIMARY KEY (`Obrazovni_profil_ID`),
38 INDEX `fk_Obrazovni_profil_Podrucje_rada_idx` (`Podrucje_rada_Podrucje_rada_ID` ASC),
39 CONSTRAINT `fk_Obrazovni_profil_Podrucje_rada`
40 FOREIGN KEY (`Podrucje_rada_Podrucje_rada_ID`)
41 REFERENCES `milos.rodic.v16`.`Podrucje_rada` (`Podrucje_rada_ID`)
42 ON DELETE NO ACTION
43 ON UPDATE NO ACTION)
44ENGINE = InnoDB;
45
46
47-- -----------------------------------------------------
48-- Table `milos.rodic.v16`.`Predmet`
49-- -----------------------------------------------------
50CREATE TABLE IF NOT EXISTS `milos.rodic.v16`.`Predmet` (
51 `PredmetID` INT NOT NULL AUTO_INCREMENT,
52 `Predmet_naziv` VARCHAR(45) NOT NULL,
53 PRIMARY KEY (`PredmetID`))
54ENGINE = InnoDB;
55
56
57-- -----------------------------------------------------
58-- Table `milos.rodic.v16`.`Predmet2Profil`
59-- -----------------------------------------------------
60CREATE TABLE IF NOT EXISTS `milos.rodic.v16`.`Predmet2Profil` (
61 `iPredmet2Profil_ID` INT NOT NULL AUTO_INCREMENT,
62 `Obrazovni_profil_Obrazovni_profil_ID` INT NOT NULL,
63 `Predmet_PredmetID` INT NOT NULL,
64 PRIMARY KEY (`iPredmet2Profil_ID`, `Obrazovni_profil_Obrazovni_profil_ID`, `Predmet_PredmetID`),
65 INDEX `fk_Predmet2Profil_Obrazovni_profil1_idx` (`Obrazovni_profil_Obrazovni_profil_ID` ASC),
66 INDEX `fk_Predmet2Profil_Predmet1_idx` (`Predmet_PredmetID` ASC),
67 CONSTRAINT `fk_Predmet2Profil_Obrazovni_profil1`
68 FOREIGN KEY (`Obrazovni_profil_Obrazovni_profil_ID`)
69 REFERENCES `milos.rodic.v16`.`Obrazovni_profil` (`Obrazovni_profil_ID`)
70 ON DELETE NO ACTION
71 ON UPDATE NO ACTION,
72 CONSTRAINT `fk_Predmet2Profil_Predmet1`
73 FOREIGN KEY (`Predmet_PredmetID`)
74 REFERENCES `milos.rodic.v16`.`Predmet` (`PredmetID`)
75 ON DELETE NO ACTION
76 ON UPDATE NO ACTION)
77ENGINE = InnoDB;
78
79
80-- -----------------------------------------------------
81-- Table `milos.rodic.v16`.`Profesor`
82-- -----------------------------------------------------
83CREATE TABLE IF NOT EXISTS `milos.rodic.v16`.`Profesor` (
84 `ProfesorID` INT NOT NULL AUTO_INCREMENT,
85 `Profesor_prezime` VARCHAR(100) NOT NULL,
86 `Profesor_ime` VARCHAR(45) NOT NULL,
87 PRIMARY KEY (`ProfesorID`))
88ENGINE = InnoDB;
89
90
91-- -----------------------------------------------------
92-- Table `milos.rodic.v16`.`Skolska_Godina`
93-- -----------------------------------------------------
94CREATE TABLE IF NOT EXISTS `milos.rodic.v16`.`Skolska_Godina` (
95 `Skolska_Godina_ID` INT NOT NULL AUTO_INCREMENT,
96 `Skolska_godina` VARCHAR(45) NOT NULL,
97 PRIMARY KEY (`Skolska_Godina_ID`))
98ENGINE = InnoDB;
99
100
101-- -----------------------------------------------------
102-- Table `milos.rodic.v16`.`Profesor2Predmet`
103-- -----------------------------------------------------
104CREATE TABLE IF NOT EXISTS `milos.rodic.v16`.`Profesor2Predmet` (
105 `Profesor2Predmet_ID` INT NOT NULL AUTO_INCREMENT,
106 `Predmet_PredmetID` INT NOT NULL,
107 `Profesor_ProfesorID` INT NOT NULL,
108 `Skolska_Godina_Skolska_Godina_ID` INT NOT NULL,
109 PRIMARY KEY (`Profesor2Predmet_ID`, `Predmet_PredmetID`, `Profesor_ProfesorID`, `Skolska_Godina_Skolska_Godina_ID`),
110 INDEX `fk_Profesor2Predmet_Predmet1_idx` (`Predmet_PredmetID` ASC),
111 INDEX `fk_Profesor2Predmet_Profesor1_idx` (`Profesor_ProfesorID` ASC),
112 INDEX `fk_Profesor2Predmet_Skolska_Godina1_idx` (`Skolska_Godina_Skolska_Godina_ID` ASC),
113 CONSTRAINT `fk_Profesor2Predmet_Predmet1`
114 FOREIGN KEY (`Predmet_PredmetID`)
115 REFERENCES `milos.rodic.v16`.`Predmet` (`PredmetID`)
116 ON DELETE NO ACTION
117 ON UPDATE NO ACTION,
118 CONSTRAINT `fk_Profesor2Predmet_Profesor1`
119 FOREIGN KEY (`Profesor_ProfesorID`)
120 REFERENCES `milos.rodic.v16`.`Profesor` (`ProfesorID`)
121 ON DELETE NO ACTION
122 ON UPDATE NO ACTION,
123 CONSTRAINT `fk_Profesor2Predmet_Skolska_Godina1`
124 FOREIGN KEY (`Skolska_Godina_Skolska_Godina_ID`)
125 REFERENCES `milos.rodic.v16`.`Skolska_Godina` (`Skolska_Godina_ID`)
126 ON DELETE NO ACTION
127 ON UPDATE NO ACTION)
128ENGINE = InnoDB;
129
130
131-- -----------------------------------------------------
132-- Table `milos.rodic.v16`.`Ucenik`
133-- -----------------------------------------------------
134CREATE TABLE IF NOT EXISTS `milos.rodic.v16`.`Ucenik` (
135 `UcenikID` INT NOT NULL AUTO_INCREMENT,
136 `Ucenik_ime` VARCHAR(100) NOT NULL,
137 `Ucenik_prezime` VARCHAR(100) NOT NULL,
138 `Obrazovni_profil_Obrazovni_profil_ID` INT NOT NULL,
139 PRIMARY KEY (`UcenikID`),
140 INDEX `fk_Ucenik_Obrazovni_profil1_idx` (`Obrazovni_profil_Obrazovni_profil_ID` ASC),
141 CONSTRAINT `fk_Ucenik_Obrazovni_profil1`
142 FOREIGN KEY (`Obrazovni_profil_Obrazovni_profil_ID`)
143 REFERENCES `milos.rodic.v16`.`Obrazovni_profil` (`Obrazovni_profil_ID`)
144 ON DELETE NO ACTION
145 ON UPDATE NO ACTION)
146ENGINE = InnoDB;
147
148
149-- -----------------------------------------------------
150-- Table `milos.rodic.v16`.`Ocena`
151-- -----------------------------------------------------
152CREATE TABLE IF NOT EXISTS `milos.rodic.v16`.`Ocena` (
153 `OcenaID` INT NOT NULL AUTO_INCREMENT,
154 `Ocena_vrednost` INT NOT NULL,
155 PRIMARY KEY (`OcenaID`))
156ENGINE = InnoDB;
157
158
159-- -----------------------------------------------------
160-- Table `milos.rodic.v16`.`Izvestaj`
161-- -----------------------------------------------------
162CREATE TABLE IF NOT EXISTS `milos.rodic.v16`.`Izvestaj` (
163 `IzvestajID` INT NOT NULL AUTO_INCREMENT,
164 `Izvestaj_period` VARCHAR(45) NOT NULL,
165 `Ucenik_UcenikID` INT NOT NULL,
166 `Predmet_PredmetID` INT NOT NULL,
167 `Ocena_OcenaID` INT NOT NULL,
168 PRIMARY KEY (`IzvestajID`),
169 INDEX `fk_Izvestaj_Ucenik1_idx` (`Ucenik_UcenikID` ASC),
170 INDEX `fk_Izvestaj_Predmet1_idx` (`Predmet_PredmetID` ASC),
171 INDEX `fk_Izvestaj_Ocena1_idx` (`Ocena_OcenaID` ASC),
172 CONSTRAINT `fk_Izvestaj_Ucenik1`
173 FOREIGN KEY (`Ucenik_UcenikID`)
174 REFERENCES `milos.rodic.v16`.`Ucenik` (`UcenikID`)
175 ON DELETE NO ACTION
176 ON UPDATE NO ACTION,
177 CONSTRAINT `fk_Izvestaj_Predmet1`
178 FOREIGN KEY (`Predmet_PredmetID`)
179 REFERENCES `milos.rodic.v16`.`Predmet` (`PredmetID`)
180 ON DELETE NO ACTION
181 ON UPDATE NO ACTION,
182 CONSTRAINT `fk_Izvestaj_Ocena1`
183 FOREIGN KEY (`Ocena_OcenaID`)
184 REFERENCES `milos.rodic.v16`.`Ocena` (`OcenaID`)
185 ON DELETE NO ACTION
186 ON UPDATE NO ACTION)
187ENGINE = InnoDB;
188
189
190SET SQL_MODE=@OLD_SQL_MODE;
191SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
192SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;