dFh9U1qP

1-- MySQL Script generated by MySQL Workbench
2-- Tue Dec  5 23:56:52 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`.`kuhar`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`kuhar` (
24  `id_kuhar` INT ZEROFILL UNSIGNED NOT NULL AUTO_INCREMENT,
25  `ime_kuhar` VARCHAR(45) NULL,
26  PRIMARY KEY (`id_kuhar`),
27  UNIQUE INDEX `id_kuhar_UNIQUE` (`id_kuhar` ASC))
28ENGINE = InnoDB;
29
30
31-- -----------------------------------------------------
32-- Table `mydb`.`tip_kuhinja_jelo`
33-- -----------------------------------------------------
34CREATE TABLE IF NOT EXISTS `mydb`.`tip_kuhinja_jelo` (
35  `idtip_kuhinja_jelo` INT UNSIGNED ZEROFILL NOT NULL,
36  `naziv_kuhinja` VARCHAR(45) NULL,
37  PRIMARY KEY (`idtip_kuhinja_jelo`),
38  UNIQUE INDEX `idtip_kuhinja_jelo_UNIQUE` (`idtip_kuhinja_jelo` ASC))
39ENGINE = InnoDB;
40
41
42-- -----------------------------------------------------
43-- Table `mydb`.`tip`
44-- -----------------------------------------------------
45CREATE TABLE IF NOT EXISTS `mydb`.`tip` (
46  `id_tip` INT ZEROFILL UNSIGNED NOT NULL AUTO_INCREMENT,
47  `ime_tipa` VARCHAR(45) NULL,
48  PRIMARY KEY (`id_tip`),
49  UNIQUE INDEX `id_tip_UNIQUE` (`id_tip` ASC))
50ENGINE = InnoDB;
51
52
53-- -----------------------------------------------------
54-- Table `mydb`.`jelo`
55-- -----------------------------------------------------
56CREATE TABLE IF NOT EXISTS `mydb`.`jelo` (
57  `idjelo` INT UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
58  `ime_jelo` VARCHAR(45) NULL,
59  `cijena` INT(4) UNSIGNED NULL,
60  `kuhar_id_kuhar` INT ZEROFILL UNSIGNED NOT NULL,
61  `tip_kuhinja_jelo_idtip_kuhinja_jelo` INT UNSIGNED ZEROFILL NOT NULL,
62  `tip_id_tip` INT ZEROFILL UNSIGNED NOT NULL,
63  PRIMARY KEY (`idjelo`, `kuhar_id_kuhar`, `tip_kuhinja_jelo_idtip_kuhinja_jelo`, `tip_id_tip`),
64  UNIQUE INDEX `idjelo_UNIQUE` (`idjelo` ASC),
65  INDEX `fk_jelo_kuhar1_idx` (`kuhar_id_kuhar` ASC),
66  INDEX `fk_jelo_tip_kuhinja_jelo1_idx` (`tip_kuhinja_jelo_idtip_kuhinja_jelo` ASC),
67  INDEX `fk_jelo_tip1_idx` (`tip_id_tip` ASC),
68  CONSTRAINT `fk_jelo_kuhar1`
69    FOREIGN KEY (`kuhar_id_kuhar`)
70    REFERENCES `mydb`.`kuhar` (`id_kuhar`)
71    ON DELETE NO ACTION
72    ON UPDATE NO ACTION,
73  CONSTRAINT `fk_jelo_tip_kuhinja_jelo1`
74    FOREIGN KEY (`tip_kuhinja_jelo_idtip_kuhinja_jelo`)
75    REFERENCES `mydb`.`tip_kuhinja_jelo` (`idtip_kuhinja_jelo`)
76    ON DELETE NO ACTION
77    ON UPDATE NO ACTION,
78  CONSTRAINT `fk_jelo_tip1`
79    FOREIGN KEY (`tip_id_tip`)
80    REFERENCES `mydb`.`tip` (`id_tip`)
81    ON DELETE NO ACTION
82    ON UPDATE NO ACTION)
83ENGINE = InnoDB;
84
85
86-- -----------------------------------------------------
87-- Table `mydb`.`sastojak`
88-- -----------------------------------------------------
89CREATE TABLE IF NOT EXISTS `mydb`.`sastojak` (
90  `id_sastojak` INT ZEROFILL UNSIGNED NOT NULL AUTO_INCREMENT,
91  `naziv_sastojak` VARCHAR(45) NULL,
92  PRIMARY KEY (`id_sastojak`),
93  UNIQUE INDEX `id_sastojci_UNIQUE` (`id_sastojak` ASC))
94ENGINE = InnoDB;
95
96
97-- -----------------------------------------------------
98-- Table `mydb`.`konobar`
99-- -----------------------------------------------------
100CREATE TABLE IF NOT EXISTS `mydb`.`konobar` (
101  `id_konobar` INT UNSIGNED ZEROFILL NOT NULL,
102  `ime_konobar` VARCHAR(45) NULL,
103  PRIMARY KEY (`id_konobar`))
104ENGINE = InnoDB;
105
106
107-- -----------------------------------------------------
108-- Table `mydb`.`stol`
109-- -----------------------------------------------------
110CREATE TABLE IF NOT EXISTS `mydb`.`stol` (
111  `id_stol` INT UNSIGNED NOT NULL AUTO_INCREMENT,
112  `tip_stola` VARCHAR(45) NULL,
113  `broj_sjedecih_mjesta` INT UNSIGNED NULL,
114  PRIMARY KEY (`id_stol`))
115ENGINE = InnoDB;
116
117
118-- -----------------------------------------------------
119-- Table `mydb`.`gost`
120-- -----------------------------------------------------
121CREATE TABLE IF NOT EXISTS `mydb`.`gost` (
122  `id_gost` INT ZEROFILL UNSIGNED NOT NULL AUTO_INCREMENT,
123  `ime_gost` VARCHAR(45) NULL,
124  `stol_id_stol` INT UNSIGNED NOT NULL,
125  PRIMARY KEY (`id_gost`, `stol_id_stol`),
126  INDEX `fk_gost_stol1_idx` (`stol_id_stol` ASC),
127  CONSTRAINT `fk_gost_stol1`
128    FOREIGN KEY (`stol_id_stol`)
129    REFERENCES `mydb`.`stol` (`id_stol`)
130    ON DELETE NO ACTION
131    ON UPDATE NO ACTION)
132ENGINE = InnoDB;
133
134
135-- -----------------------------------------------------
136-- Table `mydb`.`račun`
137-- -----------------------------------------------------
138CREATE TABLE IF NOT EXISTS `mydb`.`račun` (
139  `id_račun` INT ZEROFILL UNSIGNED NOT NULL AUTO_INCREMENT,
140  `stol` INT UNSIGNED ZEROFILL NULL,
141  `datum` DATE NULL,
142  `konobar_id_konobar` INT UNSIGNED ZEROFILL NOT NULL,
143  `gost_id_gost` INT ZEROFILL UNSIGNED NOT NULL,
144  PRIMARY KEY (`id_račun`, `konobar_id_konobar`, `gost_id_gost`),
145  INDEX `fk_račun_konobar1_idx` (`konobar_id_konobar` ASC),
146  INDEX `fk_račun_gost1_idx` (`gost_id_gost` ASC),
147  CONSTRAINT `fk_račun_konobar1`
148    FOREIGN KEY (`konobar_id_konobar`)
149    REFERENCES `mydb`.`konobar` (`id_konobar`)
150    ON DELETE NO ACTION
151    ON UPDATE NO ACTION,
152  CONSTRAINT `fk_račun_gost1`
153    FOREIGN KEY (`gost_id_gost`)
154    REFERENCES `mydb`.`gost` (`id_gost`)
155    ON DELETE NO ACTION
156    ON UPDATE NO ACTION)
157ENGINE = InnoDB;
158
159
160-- -----------------------------------------------------
161-- Table `mydb`.`jelo_has_sastojak`
162-- -----------------------------------------------------
163CREATE TABLE IF NOT EXISTS `mydb`.`jelo_has_sastojak` (
164  `jelo_idjelo` INT UNSIGNED ZEROFILL NOT NULL,
165  `sastojak_id_sastojak` INT ZEROFILL UNSIGNED NOT NULL,
166  PRIMARY KEY (`jelo_idjelo`, `sastojak_id_sastojak`),
167  INDEX `fk_jelo_has_sastojak_sastojak1_idx` (`sastojak_id_sastojak` ASC),
168  INDEX `fk_jelo_has_sastojak_jelo_idx` (`jelo_idjelo` ASC),
169  CONSTRAINT `fk_jelo_has_sastojak_jelo`
170    FOREIGN KEY (`jelo_idjelo`)
171    REFERENCES `mydb`.`jelo` (`idjelo`)
172    ON DELETE NO ACTION
173    ON UPDATE NO ACTION,
174  CONSTRAINT `fk_jelo_has_sastojak_sastojak1`
175    FOREIGN KEY (`sastojak_id_sastojak`)
176    REFERENCES `mydb`.`sastojak` (`id_sastojak`)
177    ON DELETE NO ACTION
178    ON UPDATE NO ACTION)
179ENGINE = InnoDB;
180
181
182-- -----------------------------------------------------
183-- Table `mydb`.`jelo_has_račun`
184-- -----------------------------------------------------
185CREATE TABLE IF NOT EXISTS `mydb`.`jelo_has_račun` (
186  `jelo_idjelo` INT UNSIGNED ZEROFILL NOT NULL,
187  `račun_id_račun` INT ZEROFILL UNSIGNED NOT NULL,
188  PRIMARY KEY (`jelo_idjelo`, `račun_id_račun`),
189  INDEX `fk_jelo_has_račun_račun1_idx` (`račun_id_račun` ASC),
190  INDEX `fk_jelo_has_račun_jelo1_idx` (`jelo_idjelo` ASC),
191  CONSTRAINT `fk_jelo_has_račun_jelo1`
192    FOREIGN KEY (`jelo_idjelo`)
193    REFERENCES `mydb`.`jelo` (`idjelo`)
194    ON DELETE NO ACTION
195    ON UPDATE NO ACTION,
196  CONSTRAINT `fk_jelo_has_račun_račun1`
197    FOREIGN KEY (`račun_id_račun`)
198    REFERENCES `mydb`.`račun` (`id_račun`)
199    ON DELETE NO ACTION
200    ON UPDATE NO ACTION)
201ENGINE = InnoDB;
202
203
204-- -----------------------------------------------------
205-- Table `mydb`.`piće`
206-- -----------------------------------------------------
207CREATE TABLE IF NOT EXISTS `mydb`.`piće` (
208  `id_pice` INT UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
209  `naziv_pica` VARCHAR(45) NULL,
210  PRIMARY KEY (`id_pice`))
211ENGINE = InnoDB;
212
213
214-- -----------------------------------------------------
215-- Table `mydb`.`piće_has_račun`
216-- -----------------------------------------------------
217CREATE TABLE IF NOT EXISTS `mydb`.`piće_has_račun` (
218  `pice_id_pice` INT UNSIGNED ZEROFILL NOT NULL,
219  `račun_id_račun` INT ZEROFILL UNSIGNED NOT NULL,
220  PRIMARY KEY (`pice_id_pice`, `račun_id_račun`),
221  INDEX `fk_pice_has_račun_račun1_idx` (`račun_id_račun` ASC),
222  INDEX `fk_pice_has_račun_pice1_idx` (`pice_id_pice` ASC),
223  CONSTRAINT `fk_pice_has_račun_pice1`
224    FOREIGN KEY (`pice_id_pice`)
225    REFERENCES `mydb`.`piće` (`id_pice`)
226    ON DELETE NO ACTION
227    ON UPDATE NO ACTION,
228  CONSTRAINT `fk_pice_has_račun_račun1`
229    FOREIGN KEY (`račun_id_račun`)
230    REFERENCES `mydb`.`račun` (`id_račun`)
231    ON DELETE NO ACTION
232    ON UPDATE NO ACTION)
233ENGINE = InnoDB;
234
235
236SET SQL_MODE=@OLD_SQL_MODE;
237SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
238SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;