· 6 years ago · May 13, 2019, 05:34 PM
1-- MySQL Script generated by MySQL Workbench
2-- Mon May 13 19:22:37 2019
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='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
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`.`KategorijaPorudzbina`
22-- -----------------------------------------------------
23DROP TABLE IF EXISTS `mydb`.`KategorijaPorudzbina` ;
24
25CREATE TABLE IF NOT EXISTS `mydb`.`KategorijaPorudzbina` (
26 `KategorijaPorudzbinaID` INT NOT NULL AUTO_INCREMENT,
27 `Ime` VARCHAR(45) NOT NULL,
28 PRIMARY KEY (`KategorijaPorudzbinaID`))
29ENGINE = InnoDB;
30
31
32-- -----------------------------------------------------
33-- Table `mydb`.`Ocena`
34-- -----------------------------------------------------
35DROP TABLE IF EXISTS `mydb`.`Ocena` ;
36
37CREATE TABLE IF NOT EXISTS `mydb`.`Ocena` (
38 `OcenaID` INT NOT NULL AUTO_INCREMENT,
39 `TipOcene` INT NOT NULL,
40 PRIMARY KEY (`OcenaID`))
41ENGINE = InnoDB;
42
43
44-- -----------------------------------------------------
45-- Table `mydb`.`Proizvodi`
46-- -----------------------------------------------------
47DROP TABLE IF EXISTS `mydb`.`Proizvodi` ;
48
49CREATE TABLE IF NOT EXISTS `mydb`.`Proizvodi` (
50 `ProizvodID` INT NOT NULL AUTO_INCREMENT,
51 `Ime` VARCHAR(45) NOT NULL,
52 `Brend` VARCHAR(45) NOT NULL,
53 `Kolicina` VARCHAR(45) NOT NULL,
54 `Tip` VARCHAR(45) NOT NULL,
55 `NabavnaCena` DOUBLE NOT NULL,
56 `ProdajnaCena` DOUBLE NOT NULL,
57 `KategorijaPorudzbina_KategorijaPorudzbinaID` INT NOT NULL,
58 `Ocena_OcenaID` INT NOT NULL,
59 PRIMARY KEY (`ProizvodID`),
60 INDEX `fk_Proizvodi_KategorijaPorudzbina1_idx` (`KategorijaPorudzbina_KategorijaPorudzbinaID` ASC) VISIBLE,
61 INDEX `fk_Proizvodi_Ocena1_idx` (`Ocena_OcenaID` ASC) VISIBLE,
62 CONSTRAINT `fk_Proizvodi_KategorijaPorudzbina1`
63 FOREIGN KEY (`KategorijaPorudzbina_KategorijaPorudzbinaID`)
64 REFERENCES `mydb`.`KategorijaPorudzbina` (`KategorijaPorudzbinaID`)
65 ON DELETE NO ACTION
66 ON UPDATE NO ACTION,
67 CONSTRAINT `fk_Proizvodi_Ocena1`
68 FOREIGN KEY (`Ocena_OcenaID`)
69 REFERENCES `mydb`.`Ocena` (`OcenaID`)
70 ON DELETE NO ACTION
71 ON UPDATE NO ACTION)
72ENGINE = InnoDB;
73
74
75-- -----------------------------------------------------
76-- Table `mydb`.`NacinPlacanja`
77-- -----------------------------------------------------
78DROP TABLE IF EXISTS `mydb`.`NacinPlacanja` ;
79
80CREATE TABLE IF NOT EXISTS `mydb`.`NacinPlacanja` (
81 `NacinPlacanjaID` INT NOT NULL AUTO_INCREMENT,
82 `TipPlacanja` VARCHAR(45) NOT NULL,
83 PRIMARY KEY (`NacinPlacanjaID`))
84ENGINE = InnoDB;
85
86
87-- -----------------------------------------------------
88-- Table `mydb`.`Kupac`
89-- -----------------------------------------------------
90DROP TABLE IF EXISTS `mydb`.`Kupac` ;
91
92CREATE TABLE IF NOT EXISTS `mydb`.`Kupac` (
93 `KupacID` INT NOT NULL AUTO_INCREMENT,
94 `Ime` VARCHAR(45) NOT NULL,
95 `Prezime` VARCHAR(45) NOT NULL,
96 `Pol` VARCHAR(45) NOT NULL,
97 `DatumRodjenja` DATE NOT NULL,
98 `BrojTelefona` INT NOT NULL,
99 `Drzava` VARCHAR(45) NOT NULL,
100 `Grad` VARCHAR(45) NOT NULL,
101 `Adresa` VARCHAR(45) NOT NULL,
102 `PostanskiBroj` INT NOT NULL,
103 PRIMARY KEY (`KupacID`))
104ENGINE = InnoDB;
105
106
107-- -----------------------------------------------------
108-- Table `mydb`.`Ogranak`
109-- -----------------------------------------------------
110DROP TABLE IF EXISTS `mydb`.`Ogranak` ;
111
112CREATE TABLE IF NOT EXISTS `mydb`.`Ogranak` (
113 `OgranakID` INT NOT NULL AUTO_INCREMENT,
114 `Ime` VARCHAR(45) NOT NULL,
115 `Drzava` VARCHAR(45) NOT NULL,
116 `Grad` VARCHAR(45) NOT NULL,
117 PRIMARY KEY (`OgranakID`))
118ENGINE = InnoDB;
119
120
121-- -----------------------------------------------------
122-- Table `mydb`.`Prodavac`
123-- -----------------------------------------------------
124DROP TABLE IF EXISTS `mydb`.`Prodavac` ;
125
126CREATE TABLE IF NOT EXISTS `mydb`.`Prodavac` (
127 `ProdavacID` INT NOT NULL AUTO_INCREMENT,
128 `Ime` VARCHAR(45) NOT NULL,
129 `Prezime` VARCHAR(45) NOT NULL,
130 `Pol` VARCHAR(45) NOT NULL,
131 `DatumRodjenja` DATE NOT NULL,
132 `BrojTelefona` INT NOT NULL,
133 `Adresa` VARCHAR(45) NOT NULL,
134 `Zarada` INT NOT NULL,
135 `Ogranak_OgranakID` INT NOT NULL,
136 PRIMARY KEY (`ProdavacID`),
137 INDEX `fk_Prodavac_Ogranak1_idx` (`Ogranak_OgranakID` ASC) VISIBLE,
138 CONSTRAINT `fk_Prodavac_Ogranak1`
139 FOREIGN KEY (`Ogranak_OgranakID`)
140 REFERENCES `mydb`.`Ogranak` (`OgranakID`)
141 ON DELETE NO ACTION
142 ON UPDATE NO ACTION)
143ENGINE = InnoDB;
144
145
146-- -----------------------------------------------------
147-- Table `mydb`.`Porudzbine`
148-- -----------------------------------------------------
149DROP TABLE IF EXISTS `mydb`.`Porudzbine` ;
150
151CREATE TABLE IF NOT EXISTS `mydb`.`Porudzbine` (
152 `PorudzbineID` INT NOT NULL AUTO_INCREMENT,
153 `Popust` INT NOT NULL,
154 `NacinPlacanja_NacinPlacanjaID` INT NOT NULL,
155 `Kupac_KupacID` INT NOT NULL,
156 `Prodavac_ProdavacID` INT NOT NULL,
157 `UkupnaCena` DOUBLE NOT NULL,
158 PRIMARY KEY (`PorudzbineID`),
159 INDEX `fk_Porudzbine_NacinPlacanja1_idx` (`NacinPlacanja_NacinPlacanjaID` ASC) VISIBLE,
160 INDEX `fk_Porudzbine_Kupac1_idx` (`Kupac_KupacID` ASC) VISIBLE,
161 INDEX `fk_Porudzbine_Prodavac1_idx` (`Prodavac_ProdavacID` ASC) VISIBLE,
162 CONSTRAINT `fk_Porudzbine_NacinPlacanja1`
163 FOREIGN KEY (`NacinPlacanja_NacinPlacanjaID`)
164 REFERENCES `mydb`.`NacinPlacanja` (`NacinPlacanjaID`)
165 ON DELETE NO ACTION
166 ON UPDATE NO ACTION,
167 CONSTRAINT `fk_Porudzbine_Kupac1`
168 FOREIGN KEY (`Kupac_KupacID`)
169 REFERENCES `mydb`.`Kupac` (`KupacID`)
170 ON DELETE NO ACTION
171 ON UPDATE NO ACTION,
172 CONSTRAINT `fk_Porudzbine_Prodavac1`
173 FOREIGN KEY (`Prodavac_ProdavacID`)
174 REFERENCES `mydb`.`Prodavac` (`ProdavacID`)
175 ON DELETE NO ACTION
176 ON UPDATE NO ACTION)
177ENGINE = InnoDB;
178
179
180-- -----------------------------------------------------
181-- Table `mydb`.`DetaljiPorudzbine`
182-- -----------------------------------------------------
183DROP TABLE IF EXISTS `mydb`.`DetaljiPorudzbine` ;
184
185CREATE TABLE IF NOT EXISTS `mydb`.`DetaljiPorudzbine` (
186 `DetaljiPorudzbineID` INT NOT NULL AUTO_INCREMENT,
187 `Kolicina` INT NOT NULL,
188 `Proizvodi_ProizvodID` INT NOT NULL,
189 `Porudzbine_PorudzbineID` INT NOT NULL,
190 PRIMARY KEY (`DetaljiPorudzbineID`),
191 INDEX `fk_DetaljiPorudzbine_Proizvodi1_idx` (`Proizvodi_ProizvodID` ASC) VISIBLE,
192 INDEX `fk_DetaljiPorudzbine_Porudzbine1_idx` (`Porudzbine_PorudzbineID` ASC) VISIBLE,
193 CONSTRAINT `fk_DetaljiPorudzbine_Proizvodi1`
194 FOREIGN KEY (`Proizvodi_ProizvodID`)
195 REFERENCES `mydb`.`Proizvodi` (`ProizvodID`)
196 ON DELETE NO ACTION
197 ON UPDATE NO ACTION,
198 CONSTRAINT `fk_DetaljiPorudzbine_Porudzbine1`
199 FOREIGN KEY (`Porudzbine_PorudzbineID`)
200 REFERENCES `mydb`.`Porudzbine` (`PorudzbineID`)
201 ON DELETE NO ACTION
202 ON UPDATE NO ACTION)
203ENGINE = InnoDB;
204
205
206-- -----------------------------------------------------
207-- Table `mydb`.`Zalbe`
208-- -----------------------------------------------------
209DROP TABLE IF EXISTS `mydb`.`Zalbe` ;
210
211CREATE TABLE IF NOT EXISTS `mydb`.`Zalbe` (
212 `ZalbeID` INT NOT NULL AUTO_INCREMENT,
213 `TipZalbe` VARCHAR(45) NOT NULL,
214 `Porudzbine_PorudzbineID` INT NOT NULL,
215 PRIMARY KEY (`ZalbeID`),
216 INDEX `fk_Zalbe_Porudzbine1_idx` (`Porudzbine_PorudzbineID` ASC) VISIBLE,
217 CONSTRAINT `fk_Zalbe_Porudzbine1`
218 FOREIGN KEY (`Porudzbine_PorudzbineID`)
219 REFERENCES `mydb`.`Porudzbine` (`PorudzbineID`)
220 ON DELETE NO ACTION
221 ON UPDATE NO ACTION)
222ENGINE = InnoDB;
223
224
225SET SQL_MODE=@OLD_SQL_MODE;
226SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
227SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;