· 8 years ago · Jan 02, 2018, 06:38 PM
1-- MySQL Script generated by MySQL Workbench
2-- Tue Jan 2 19:36:43 2018
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 `ocjena_konobar` VARCHAR(45) NULL,
128 PRIMARY KEY (`ID_konobar`))
129ENGINE = InnoDB;
130
131
132-- -----------------------------------------------------
133-- Table `mydb`.`gost`
134-- -----------------------------------------------------
135CREATE TABLE IF NOT EXISTS `mydb`.`gost` (
136 `ID_gost` INT ZEROFILL UNSIGNED NOT NULL AUTO_INCREMENT,
137 `ime_gost` VARCHAR(45) NULL,
138 `prezime_gost` VARCHAR(45) NULL,
139 `datum_rod_gost` DATE NULL,
140 `adresa_gost` VARCHAR(45) NULL,
141 `grad_gost` VARCHAR(45) NULL,
142 `postanski_broj_gost` VARCHAR(45) NULL,
143 `spol_gost` VARCHAR(45) NULL,
144 `bodovi_gost` INT NULL,
145 `mail_gost` VARCHAR(45) NULL,
146 `lozinka_gost` VARCHAR(15) NULL,
147 PRIMARY KEY (`ID_gost`))
148ENGINE = InnoDB;
149
150
151-- -----------------------------------------------------
152-- Table `mydb`.`stol`
153-- -----------------------------------------------------
154CREATE TABLE IF NOT EXISTS `mydb`.`stol` (
155 `ID_stol` INT UNSIGNED NOT NULL AUTO_INCREMENT,
156 `tip_stol` VARCHAR(45) NULL,
157 `br_mjesta_stol` INT UNSIGNED NULL,
158 PRIMARY KEY (`ID_stol`))
159ENGINE = InnoDB;
160
161
162-- -----------------------------------------------------
163-- Table `mydb`.`racun`
164-- -----------------------------------------------------
165CREATE TABLE IF NOT EXISTS `mydb`.`racun` (
166 `ID_racun` INT ZEROFILL UNSIGNED NOT NULL AUTO_INCREMENT,
167 `konobar_ID_konobar` INT UNSIGNED ZEROFILL NOT NULL,
168 `stol_ID_stol` INT UNSIGNED NOT NULL,
169 `gost_ID_gost` INT ZEROFILL UNSIGNED NOT NULL,
170 `datum` DATE NULL,
171 `iznost_racun` FLOAT(45) NULL,
172 PRIMARY KEY (`ID_racun`, `konobar_ID_konobar`, `stol_ID_stol`, `gost_ID_gost`),
173 INDEX `fk_raÄun_konobar1_idx` (`konobar_ID_konobar` ASC),
174 INDEX `fk_raÄun_gost1_idx` (`gost_ID_gost` ASC),
175 INDEX `fk_raÄun_stol1_idx` (`stol_ID_stol` ASC),
176 CONSTRAINT `fk_raÄun_konobar1`
177 FOREIGN KEY (`konobar_ID_konobar`)
178 REFERENCES `mydb`.`konobar` (`ID_konobar`)
179 ON DELETE NO ACTION
180 ON UPDATE NO ACTION,
181 CONSTRAINT `fk_raÄun_gost1`
182 FOREIGN KEY (`gost_ID_gost`)
183 REFERENCES `mydb`.`gost` (`ID_gost`)
184 ON DELETE NO ACTION
185 ON UPDATE NO ACTION,
186 CONSTRAINT `fk_raÄun_stol1`
187 FOREIGN KEY (`stol_ID_stol`)
188 REFERENCES `mydb`.`stol` (`ID_stol`)
189 ON DELETE NO ACTION
190 ON UPDATE NO ACTION)
191ENGINE = InnoDB;
192
193
194-- -----------------------------------------------------
195-- Table `mydb`.`sastojci_jela`
196-- -----------------------------------------------------
197CREATE TABLE IF NOT EXISTS `mydb`.`sastojci_jela` (
198 `jelo_ID_jelo` INT UNSIGNED ZEROFILL NOT NULL,
199 `sastojak_ID_sastojak` INT ZEROFILL UNSIGNED NOT NULL,
200 PRIMARY KEY (`jelo_ID_jelo`, `sastojak_ID_sastojak`),
201 INDEX `fk_jelo_has_sastojak_sastojak1_idx` (`sastojak_ID_sastojak` ASC),
202 INDEX `fk_jelo_has_sastojak_jelo_idx` (`jelo_ID_jelo` ASC),
203 CONSTRAINT `fk_jelo_has_sastojak_jelo`
204 FOREIGN KEY (`jelo_ID_jelo`)
205 REFERENCES `mydb`.`jelo` (`ID_jelo`)
206 ON DELETE NO ACTION
207 ON UPDATE NO ACTION,
208 CONSTRAINT `fk_jelo_has_sastojak_sastojak1`
209 FOREIGN KEY (`sastojak_ID_sastojak`)
210 REFERENCES `mydb`.`sastojak` (`ID_sastojak`)
211 ON DELETE NO ACTION
212 ON UPDATE NO ACTION)
213ENGINE = InnoDB;
214
215
216-- -----------------------------------------------------
217-- Table `mydb`.`narudzba`
218-- -----------------------------------------------------
219CREATE TABLE IF NOT EXISTS `mydb`.`narudzba` (
220 `jelo_ID_jelo` INT UNSIGNED ZEROFILL NOT NULL,
221 `racun_ID_racun` INT ZEROFILL UNSIGNED NOT NULL,
222 PRIMARY KEY (`jelo_ID_jelo`, `racun_ID_racun`),
223 INDEX `fk_jelo_has_raÄun_raÄun1_idx` (`racun_ID_racun` ASC),
224 INDEX `fk_jelo_has_raÄun_jelo1_idx` (`jelo_ID_jelo` ASC),
225 CONSTRAINT `fk_jelo_has_raÄun_jelo1`
226 FOREIGN KEY (`jelo_ID_jelo`)
227 REFERENCES `mydb`.`jelo` (`ID_jelo`)
228 ON DELETE NO ACTION
229 ON UPDATE NO ACTION,
230 CONSTRAINT `fk_jelo_has_raÄun_raÄun1`
231 FOREIGN KEY (`racun_ID_racun`)
232 REFERENCES `mydb`.`racun` (`ID_racun`)
233 ON DELETE NO ACTION
234 ON UPDATE NO ACTION)
235ENGINE = InnoDB
236COMMENT = ' ';
237
238
239-- -----------------------------------------------------
240-- Table `mydb`.`pice`
241-- -----------------------------------------------------
242CREATE TABLE IF NOT EXISTS `mydb`.`pice` (
243 `ID_pice` INT UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
244 `naziv_pice` VARCHAR(45) NULL,
245 `cijena_pice` INT UNSIGNED NULL,
246 `kolicina_pice` FLOAT NULL,
247 PRIMARY KEY (`ID_pice`))
248ENGINE = InnoDB;
249
250
251-- -----------------------------------------------------
252-- Table `mydb`.`pica_na_racunu`
253-- -----------------------------------------------------
254CREATE TABLE IF NOT EXISTS `mydb`.`pica_na_racunu` (
255 `pice_ID_pice` INT UNSIGNED ZEROFILL NOT NULL,
256 `raÄun_ID_raÄun` INT ZEROFILL UNSIGNED NOT NULL,
257 PRIMARY KEY (`pice_ID_pice`, `raÄun_ID_raÄun`),
258 INDEX `fk_pice_has_raÄun_raÄun1_idx` (`raÄun_ID_raÄun` ASC),
259 INDEX `fk_pice_has_raÄun_pice1_idx` (`pice_ID_pice` ASC),
260 CONSTRAINT `fk_pice_has_raÄun_pice1`
261 FOREIGN KEY (`pice_ID_pice`)
262 REFERENCES `mydb`.`pice` (`ID_pice`)
263 ON DELETE NO ACTION
264 ON UPDATE NO ACTION,
265 CONSTRAINT `fk_pice_has_raÄun_raÄun1`
266 FOREIGN KEY (`raÄun_ID_raÄun`)
267 REFERENCES `mydb`.`racun` (`ID_racun`)
268 ON DELETE NO ACTION
269 ON UPDATE NO ACTION)
270ENGINE = InnoDB;
271
272
273-- -----------------------------------------------------
274-- Table `mydb`.`kuhar_priprema_jelo`
275-- -----------------------------------------------------
276CREATE TABLE IF NOT EXISTS `mydb`.`kuhar_priprema_jelo` (
277 `kuhar_ID_kuhar` INT ZEROFILL UNSIGNED NOT NULL,
278 `jelo_ID_jelo` INT UNSIGNED ZEROFILL NOT NULL,
279 PRIMARY KEY (`kuhar_ID_kuhar`, `jelo_ID_jelo`),
280 INDEX `fk_kuhar_has_jelo_jelo1_idx` (`jelo_ID_jelo` ASC),
281 INDEX `fk_kuhar_has_jelo_kuhar1_idx` (`kuhar_ID_kuhar` ASC),
282 CONSTRAINT `fk_kuhar_has_jelo_kuhar1`
283 FOREIGN KEY (`kuhar_ID_kuhar`)
284 REFERENCES `mydb`.`kuhar` (`ID_kuhar`)
285 ON DELETE NO ACTION
286 ON UPDATE NO ACTION,
287 CONSTRAINT `fk_kuhar_has_jelo_jelo1`
288 FOREIGN KEY (`jelo_ID_jelo`)
289 REFERENCES `mydb`.`jelo` (`ID_jelo`)
290 ON DELETE NO ACTION
291 ON UPDATE NO ACTION)
292ENGINE = InnoDB;
293
294
295SET SQL_MODE=@OLD_SQL_MODE;
296SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
297SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;