· 8 years ago · Dec 14, 2017, 06:26 PM
1-- MySQL Script generated by MySQL Workbench
2-- Thu Dec 14 19:20:01 2017
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='TRADITIONAL,ALLOW_INVALID_DATES';
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`.`grupa`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`grupa` (
24 `ID_grupa` INT UNSIGNED ZEROFILL NOT NULL,
25 `naziv_grupa` VARCHAR(45) NULL,
26 PRIMARY KEY (`ID_grupa`),
27 UNIQUE INDEX `idtip_kuhinja_jelo_UNIQUE` (`ID_grupa` ASC))
28ENGINE = InnoDB;
29
30
31-- -----------------------------------------------------
32-- Table `mydb`.`tip`
33-- -----------------------------------------------------
34CREATE TABLE IF NOT EXISTS `mydb`.`tip` (
35 `ID_tip` INT ZEROFILL UNSIGNED NOT NULL AUTO_INCREMENT,
36 `naziv_tip` VARCHAR(45) NULL,
37 PRIMARY KEY (`ID_tip`),
38 UNIQUE INDEX `id_tip_UNIQUE` (`ID_tip` ASC))
39ENGINE = InnoDB;
40
41
42-- -----------------------------------------------------
43-- Table `mydb`.`kuhar`
44-- -----------------------------------------------------
45CREATE TABLE IF NOT EXISTS `mydb`.`kuhar` (
46 `ID_kuhar` INT ZEROFILL UNSIGNED NOT NULL AUTO_INCREMENT,
47 `ime_kuhar` VARCHAR(45) NULL,
48 `prezime_kuhar` VARCHAR(45) NULL,
49 `datum_rod` DATE NULL,
50 `adresa_kuhar` VARCHAR(45) NULL,
51 `grad_kuhar` VARCHAR(45) NULL,
52 `postanski_broj_kuhar` VARCHAR(45) NULL,
53 `placa_kuhar` FLOAT NULL,
54 `tel_kuhar` VARCHAR(45) NULL,
55 `mail_kuhar` VARCHAR(45) NULL,
56 `lozinka_kuhar` VARCHAR(45) NULL,
57 PRIMARY KEY (`ID_kuhar`),
58 UNIQUE INDEX `id_kuhar_UNIQUE` (`ID_kuhar` ASC))
59ENGINE = InnoDB;
60
61
62-- -----------------------------------------------------
63-- Table `mydb`.`jelo`
64-- -----------------------------------------------------
65CREATE TABLE IF NOT EXISTS `mydb`.`jelo` (
66 `ID_jelo` INT(100) UNSIGNED ZEROFILL NOT NULL,
67 `tip_ID_tip` INT ZEROFILL UNSIGNED NOT NULL,
68 `grupa_ID_grupa` INT UNSIGNED ZEROFILL NOT NULL,
69 `kuhar_ID_kuhar` INT ZEROFILL UNSIGNED NOT NULL,
70 `ime_jelo` VARCHAR(45) NULL,
71 `cijena` INT(4) UNSIGNED NULL,
72 `ocjena` FLOAT UNSIGNED NULL,
73 `opis` VARCHAR(100) NULL,
74 `preporuka` VARCHAR(50) NULL,
75 PRIMARY KEY (`ID_jelo`, `tip_ID_tip`, `grupa_ID_grupa`, `kuhar_ID_kuhar`),
76 UNIQUE INDEX `idjelo_UNIQUE` (`ID_jelo` ASC),
77 INDEX `fk_jelo_tip_kuhinja_jelo1_idx` (`grupa_ID_grupa` ASC),
78 INDEX `fk_jelo_tip1_idx` (`tip_ID_tip` ASC),
79 INDEX `fk_jelo_kuhar1_idx` (`kuhar_ID_kuhar` ASC),
80 CONSTRAINT `fk_jelo_tip_kuhinja_jelo1`
81 FOREIGN KEY (`grupa_ID_grupa`)
82 REFERENCES `mydb`.`grupa` (`ID_grupa`)
83 ON DELETE NO ACTION
84 ON UPDATE NO ACTION,
85 CONSTRAINT `fk_jelo_tip1`
86 FOREIGN KEY (`tip_ID_tip`)
87 REFERENCES `mydb`.`tip` (`ID_tip`)
88 ON DELETE NO ACTION
89 ON UPDATE NO ACTION,
90 CONSTRAINT `fk_jelo_kuhar1`
91 FOREIGN KEY (`kuhar_ID_kuhar`)
92 REFERENCES `mydb`.`kuhar` (`ID_kuhar`)
93 ON DELETE NO ACTION
94 ON UPDATE NO ACTION)
95ENGINE = InnoDB;
96
97
98-- -----------------------------------------------------
99-- Table `mydb`.`sastojak`
100-- -----------------------------------------------------
101CREATE TABLE IF NOT EXISTS `mydb`.`sastojak` (
102 `ID_sastojak` INT ZEROFILL UNSIGNED NOT NULL AUTO_INCREMENT,
103 `naziv_sastojak` VARCHAR(45) NULL,
104 `kolicina_sastojak` FLOAT(15) NULL,
105 `cijena_sastojak` FLOAT(15) NULL,
106 `kalorije_sastojak` INT NULL,
107 PRIMARY KEY (`ID_sastojak`),
108 UNIQUE INDEX `id_sastojci_UNIQUE` (`ID_sastojak` ASC))
109ENGINE = InnoDB;
110
111
112-- -----------------------------------------------------
113-- Table `mydb`.`konobar`
114-- -----------------------------------------------------
115CREATE TABLE IF NOT EXISTS `mydb`.`konobar` (
116 `ID_konobar` INT UNSIGNED ZEROFILL NOT NULL,
117 `ime_konobar` VARCHAR(45) NULL,
118 `prezime_konobar` VARCHAR(45) NULL,
119 `datum_rod_konobar` DATE NULL,
120 `adresa_konobar` VARCHAR(45) NULL,
121 `grad_konobar` VARCHAR(45) NULL,
122 `postanski_broj_konobar` VARCHAR(45) NULL,
123 `placa_konobar` FLOAT NULL,
124 `tel_konobar` VARCHAR(45) NULL,
125 `mail_konobar` VARCHAR(45) NULL,
126 `lozinka_konobar` VARCHAR(45) NULL,
127 PRIMARY KEY (`ID_konobar`))
128ENGINE = InnoDB;
129
130
131-- -----------------------------------------------------
132-- Table `mydb`.`gost`
133-- -----------------------------------------------------
134CREATE TABLE IF NOT EXISTS `mydb`.`gost` (
135 `ID_gost` INT ZEROFILL UNSIGNED NOT NULL AUTO_INCREMENT,
136 `ime_gost` VARCHAR(45) NULL,
137 `prezime_gost` VARCHAR(45) NULL,
138 `adresa_gost` VARCHAR(45) NULL,
139 `sifra_gost` VARCHAR(45) NULL,
140 `postanski_broj_gost` VARCHAR(45) NULL,
141 `bodovi_gost` INT NULL,
142 `mail_gost` VARCHAR(45) NULL,
143 `lozinka_gost` VARCHAR(15) NULL,
144 PRIMARY KEY (`ID_gost`))
145ENGINE = InnoDB;
146
147
148-- -----------------------------------------------------
149-- Table `mydb`.`stol`
150-- -----------------------------------------------------
151CREATE TABLE IF NOT EXISTS `mydb`.`stol` (
152 `ID_stol` INT UNSIGNED NOT NULL AUTO_INCREMENT,
153 `tip_stol` VARCHAR(45) NULL,
154 `br_mjesta_stol` INT UNSIGNED NULL,
155 PRIMARY KEY (`ID_stol`))
156ENGINE = InnoDB;
157
158
159-- -----------------------------------------------------
160-- Table `mydb`.`raÄun`
161-- -----------------------------------------------------
162CREATE TABLE IF NOT EXISTS `mydb`.`raÄun` (
163 `ID_raÄun` INT ZEROFILL UNSIGNED NOT NULL AUTO_INCREMENT,
164 `konobar_ID_konobar` INT UNSIGNED ZEROFILL NOT NULL,
165 `stol_ID_stol` INT UNSIGNED NOT NULL,
166 `gost_ID_gost` INT ZEROFILL UNSIGNED NOT NULL,
167 `datum` DATE NULL,
168 `iznost_racun` FLOAT(45) NULL,
169 PRIMARY KEY (`ID_raÄun`, `konobar_ID_konobar`, `stol_ID_stol`, `gost_ID_gost`),
170 INDEX `fk_raÄun_konobar1_idx` (`konobar_ID_konobar` ASC),
171 INDEX `fk_raÄun_gost1_idx` (`gost_ID_gost` ASC),
172 INDEX `fk_raÄun_stol1_idx` (`stol_ID_stol` ASC),
173 CONSTRAINT `fk_raÄun_konobar1`
174 FOREIGN KEY (`konobar_ID_konobar`)
175 REFERENCES `mydb`.`konobar` (`ID_konobar`)
176 ON DELETE NO ACTION
177 ON UPDATE NO ACTION,
178 CONSTRAINT `fk_raÄun_gost1`
179 FOREIGN KEY (`gost_ID_gost`)
180 REFERENCES `mydb`.`gost` (`ID_gost`)
181 ON DELETE NO ACTION
182 ON UPDATE NO ACTION,
183 CONSTRAINT `fk_raÄun_stol1`
184 FOREIGN KEY (`stol_ID_stol`)
185 REFERENCES `mydb`.`stol` (`ID_stol`)
186 ON DELETE NO ACTION
187 ON UPDATE NO ACTION)
188ENGINE = InnoDB;
189
190
191-- -----------------------------------------------------
192-- Table `mydb`.`sastojci_jela`
193-- -----------------------------------------------------
194CREATE TABLE IF NOT EXISTS `mydb`.`sastojci_jela` (
195 `jelo_ID_jelo` INT UNSIGNED ZEROFILL NOT NULL,
196 `sastojak_ID_sastojak` INT ZEROFILL UNSIGNED NOT NULL,
197 PRIMARY KEY (`jelo_ID_jelo`, `sastojak_ID_sastojak`),
198 INDEX `fk_jelo_has_sastojak_sastojak1_idx` (`sastojak_ID_sastojak` ASC),
199 INDEX `fk_jelo_has_sastojak_jelo_idx` (`jelo_ID_jelo` ASC),
200 CONSTRAINT `fk_jelo_has_sastojak_jelo`
201 FOREIGN KEY (`jelo_ID_jelo`)
202 REFERENCES `mydb`.`jelo` (`ID_jelo`)
203 ON DELETE NO ACTION
204 ON UPDATE NO ACTION,
205 CONSTRAINT `fk_jelo_has_sastojak_sastojak1`
206 FOREIGN KEY (`sastojak_ID_sastojak`)
207 REFERENCES `mydb`.`sastojak` (`ID_sastojak`)
208 ON DELETE NO ACTION
209 ON UPDATE NO ACTION)
210ENGINE = InnoDB;
211
212
213-- -----------------------------------------------------
214-- Table `mydb`.`jela_na_raÄun`
215-- -----------------------------------------------------
216CREATE TABLE IF NOT EXISTS `mydb`.`jela_na_raÄun` (
217 `jelo_ID_jelo` INT UNSIGNED ZEROFILL NOT NULL,
218 `raÄun_ID_raÄun` INT ZEROFILL UNSIGNED NOT NULL,
219 PRIMARY KEY (`jelo_ID_jelo`, `raÄun_ID_raÄun`),
220 INDEX `fk_jelo_has_raÄun_raÄun1_idx` (`raÄun_ID_raÄun` ASC),
221 INDEX `fk_jelo_has_raÄun_jelo1_idx` (`jelo_ID_jelo` ASC),
222 CONSTRAINT `fk_jelo_has_raÄun_jelo1`
223 FOREIGN KEY (`jelo_ID_jelo`)
224 REFERENCES `mydb`.`jelo` (`ID_jelo`)
225 ON DELETE NO ACTION
226 ON UPDATE NO ACTION,
227 CONSTRAINT `fk_jelo_has_raÄun_raÄun1`
228 FOREIGN KEY (`raÄun_ID_raÄun`)
229 REFERENCES `mydb`.`raÄun` (`ID_raÄun`)
230 ON DELETE NO ACTION
231 ON UPDATE NO ACTION)
232ENGINE = InnoDB
233COMMENT = ' ';
234
235
236-- -----------------------------------------------------
237-- Table `mydb`.`pice`
238-- -----------------------------------------------------
239CREATE TABLE IF NOT EXISTS `mydb`.`pice` (
240 `ID_pice` INT UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
241 `naziv_pice` VARCHAR(45) NULL,
242 `cijena_pice` INT UNSIGNED NULL,
243 `kolicina_pice` FLOAT NULL,
244 PRIMARY KEY (`ID_pice`))
245ENGINE = InnoDB;
246
247
248-- -----------------------------------------------------
249-- Table `mydb`.`pića_na_raÄunu`
250-- -----------------------------------------------------
251CREATE TABLE IF NOT EXISTS `mydb`.`pića_na_raÄunu` (
252 `pice_ID_pice` INT UNSIGNED ZEROFILL NOT NULL,
253 `raÄun_ID_raÄun` INT ZEROFILL UNSIGNED NOT NULL,
254 PRIMARY KEY (`pice_ID_pice`, `raÄun_ID_raÄun`),
255 INDEX `fk_pice_has_raÄun_raÄun1_idx` (`raÄun_ID_raÄun` ASC),
256 INDEX `fk_pice_has_raÄun_pice1_idx` (`pice_ID_pice` ASC),
257 CONSTRAINT `fk_pice_has_raÄun_pice1`
258 FOREIGN KEY (`pice_ID_pice`)
259 REFERENCES `mydb`.`pice` (`ID_pice`)
260 ON DELETE NO ACTION
261 ON UPDATE NO ACTION,
262 CONSTRAINT `fk_pice_has_raÄun_raÄun1`
263 FOREIGN KEY (`raÄun_ID_raÄun`)
264 REFERENCES `mydb`.`raÄun` (`ID_raÄun`)
265 ON DELETE NO ACTION
266 ON UPDATE NO ACTION)
267ENGINE = InnoDB;
268
269
270-- -----------------------------------------------------
271-- Table `mydb`.`kuhar_priprema_jelo`
272-- -----------------------------------------------------
273CREATE TABLE IF NOT EXISTS `mydb`.`kuhar_priprema_jelo` (
274 `kuhar_ID_kuhar` INT ZEROFILL UNSIGNED NOT NULL,
275 `jelo_ID_jelo` INT UNSIGNED ZEROFILL NOT NULL,
276 PRIMARY KEY (`kuhar_ID_kuhar`, `jelo_ID_jelo`),
277 INDEX `fk_kuhar_has_jelo_jelo1_idx` (`jelo_ID_jelo` ASC),
278 INDEX `fk_kuhar_has_jelo_kuhar1_idx` (`kuhar_ID_kuhar` ASC),
279 CONSTRAINT `fk_kuhar_has_jelo_kuhar1`
280 FOREIGN KEY (`kuhar_ID_kuhar`)
281 REFERENCES `mydb`.`kuhar` (`ID_kuhar`)
282 ON DELETE NO ACTION
283 ON UPDATE NO ACTION,
284 CONSTRAINT `fk_kuhar_has_jelo_jelo1`
285 FOREIGN KEY (`jelo_ID_jelo`)
286 REFERENCES `mydb`.`jelo` (`ID_jelo`)
287 ON DELETE NO ACTION
288 ON UPDATE NO ACTION)
289ENGINE = InnoDB;
290
291
292SET SQL_MODE=@OLD_SQL_MODE;
293SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
294SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;