Kp8Bu9p2

1DROP SCHEMA IF EXISTS `nikola.trajkovic.v16_2` ;
2-- -----------------------------------------------------
3-- Schema prezime.ime.v16_2
4-- -----------------------------------------------------
5CREATE SCHEMA IF NOT EXISTS `nikola.trajkovic.v16_2` DEFAULT CHARACTER SET utf8 ;
6USE `nikola.trajkovic.v16_2` ;
7-- -----------------------------------------------------
8-- Table `nikola.trajkovic.v16_2`.`Podrucje_rada`
9-- -----------------------------------------------------
10DROP TABLE IF EXISTS `nikola.trajkovic.v16_2`.`Podrucje_rada` ;
11
12CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Podrucje_rada` (
13  `Podrucje_rada_id` INT NOT NULL AUTO_INCREMENT,
14  `Podrucje_rada_naziv` VARCHAR(45) NOT NULL,
15  PRIMARY KEY (`Podrucje_rada_id`))
16ENGINE = InnoDB
17DEFAULT CHARACTER SET = latin2
18COLLATE = latin2_bin;
19
20-- -----------------------------------------------------
21-- Table `nikola.trajkovic.v16_2`.`Obrazovni_profil`
22-- -----------------------------------------------------
23DROP TABLE IF EXISTS `nikola.trajkovic.v16_2`.`Obrazovni_profil` ;
24
25CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Obrazovni_profil` (
26  `Obrazovni_profil_id` INT NOT NULL AUTO_INCREMENT,
27  `Obrazovni_profil_naziv` VARCHAR(200) NOT NULL,
28  `Podrucje_rada_id` INT NOT NULL,
29  PRIMARY KEY (`Obrazovni_profil_id`)
30)
31ENGINE = InnoDB
32DEFAULT CHARACTER SET = latin2
33COLLATE = latin2_bin;
34
35-- -----------------------------------------------------
36-- Table `nikola.trajkovic.v16_2`.`Ucenik`
37-- -----------------------------------------------------
38DROP TABLE IF EXISTS `nikola.trajkovic.v16_2`.`Ucenik` ;
39
40CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Ucenik` (
41  `Ucenik_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
42  `Ucenik_prezime` VARCHAR(100) NOT NULL,
43  `Ucenik_ime` VARCHAR(100) NOT NULL,
44  `Obrazovni_profil_id` INT NOT NULL,
45  PRIMARY KEY (`Ucenik_id`)
46)
47ENGINE = InnoDB
48DEFAULT CHARACTER SET = latin2
49COLLATE = latin2_bin;
50
51-- -----------------------------------------------------
52-- Table `nikola.trajkovic.v16_2`.`Profesor`
53-- -----------------------------------------------------
54DROP TABLE IF EXISTS `nikola.trajkovic.v16_2`.`Profesor` ;
55
56CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Profesor` (
57  `Profesor_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
58  `Profesor_prezime` VARCHAR(100) NOT NULL,
59  `Profesor_ime` VARCHAR(45) NOT NULL,
60  PRIMARY KEY (`Profesor_id`))
61ENGINE = InnoDB
62DEFAULT CHARACTER SET = latin2
63COLLATE = latin2_bin;
64
65-- -----------------------------------------------------
66-- Table `nikola.trajkovic.v16_2`.`Predmet`
67-- -----------------------------------------------------
68DROP TABLE IF EXISTS `nikola.trajkovic.v16_2`.`Predmet` ;
69CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Predmet` (
70  `Predmet_id` INT NOT NULL AUTO_INCREMENT,
71  `Predmet_naziv` VARCHAR(45) NOT NULL,
72  PRIMARY KEY (`Predmet_id`))
73ENGINE = InnoDB
74DEFAULT CHARACTER SET = latin2
75COLLATE = latin2_bin;
76
77-- -----------------------------------------------------
78-- Table `nikola.trajkovic.v16_2`.`Skolska_godina`
79-- -----------------------------------------------------
80DROP TABLE IF EXISTS `nikola.trajkovic.v16_2`.`Skolska_godina` ;
81
82CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Skolska_godina` (
83  `Skolska_godina_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
84  `Skolska_godina` VARCHAR(45) NOT NULL,
85  PRIMARY KEY (`Skolska_godina_id`)
86  )
87ENGINE = InnoDB
88DEFAULT CHARACTER SET = latin2
89COLLATE = latin2_bin;
90
91-- -----------------------------------------------------
92-- Table `nikola.trajkovic.v16_2`.`Profesor2Predmet`
93-- -----------------------------------------------------
94DROP TABLE IF EXISTS `nikola.trajkovic.v16_2`.`Profesor2Predmet` ;
95
96CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Profesor2Predmet` (
97  `Profesor2Predmet_id` INT NOT NULL AUTO_INCREMENT,
98  `Profesor_id` INT UNSIGNED NOT NULL,
99  `Predmet_id` INT NOT NULL,
100  `Skolska_godina_Skolska_godina_id` INT UNSIGNED NOT NULL,
101  PRIMARY KEY (`Profesor2Predmet_id`, `Profesor_id`, `Predmet_id`, `Skolska_godina_Skolska_godina_id`)
102)
103ENGINE = InnoDB
104DEFAULT CHARACTER SET = latin2
105COLLATE = latin2_bin;
106
107-- -----------------------------------------------------
108-- Table `nikola.trajkovic.v16_2`.`Ocena`
109-- -----------------------------------------------------
110DROP TABLE IF EXISTS `nikola.trajkovic.v16_2`.`Ocena` ;
111
112CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Ocena` (
113  `Ocena_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
114  `Ocena_vrednost` INT NULL,
115  PRIMARY KEY (`Ocena_id`))
116ENGINE = InnoDB
117DEFAULT CHARACTER SET = latin2
118COLLATE = latin2_bin;
119
120-- -----------------------------------------------------
121-- Table `nikola.trajkovic.v16_2`.`Izvestaj`
122-- -----------------------------------------------------
123DROP TABLE IF EXISTS `nikola.trajkovic.v16_2`.`Izvestaj` ;
124
125CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Izvestaj` (
126  `Izvestaj_id` INT NOT NULL AUTO_INCREMENT,
127  `Izvestaj_period` VARCHAR(45) NOT NULL,
128  `Ucenik_Ucenik_id` INT UNSIGNED NOT NULL,
129  `Predmet_Predmet_id` INT NOT NULL,
130  `Ocena_Ocena_id` INT UNSIGNED NOT NULL,
131  PRIMARY KEY (`Izvestaj_id`)
132)
133ENGINE = InnoDB
134DEFAULT CHARACTER SET = latin2
135COLLATE = latin2_bin;
136
137-- -----------------------------------------------------
138-- Table `nikola.trajkovic.v16_2`.`Predmet2Profil`
139-- -----------------------------------------------------
140DROP TABLE IF EXISTS `nikola.trajkovic.v16_2`.`Predmet2Profil` ;
141
142CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Predmet2Profil` (
143  `Predmet2Profil_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
144  `Obrazovni_profil_id` INT NOT NULL,
145  `Predmet_id` INT NOT NULL,
146  PRIMARY KEY (`Predmet2Profil_id`, `Obrazovni_profil_id`, `Predmet_id`)
147)
148ENGINE = InnoDB
149DEFAULT CHARACTER SET = latin2
150COLLATE = latin2_bin;
151
152CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Adresa` (
153  `Adresa_id` INT NOT NULL AUTO_INCREMENT,
154  `Ulica_i_broj` VARCHAR(45) NOT NULL,
155  `Mesto_stanovanja_Mesto_stanovanja_id` INT NOT NULL,
156  PRIMARY KEY (`Adresa_id`)
157  )
158ENGINE = InnoDB
159DEFAULT CHARACTER SET = latin2
160COLLATE = latin2_bin;
161
162CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Mesto_stanovanja` (
163  `Mesto_stanovanja_id` INT NOT NULL AUTO_INCREMENT,
164  `Mesto_stanovanja_naziv` VARCHAR(45) NOT NULL,
165  PRIMARY KEY (`Mesto_stanovanja_id`)
166  )
167ENGINE = InnoDB
168DEFAULT CHARACTER SET = latin2
169COLLATE = latin2_bin;
170
171ALTER TABLE `nikola.trajkovic.v16_2`.`Obrazovni_profil`
172ADD FOREIGN KEY (`Podrucje_rada_id`) REFERENCES `nikola.trajkovic.v16_2`.`Podrucje_rada` (`Podrucje_rada_id`);
173
174ALTER TABLE `nikola.trajkovic.v16_2`.`Ucenik`
175ADD FOREIGN KEY (`Obrazovni_profil_id`) REFERENCES `nikola.trajkovic.v16_2`.`Obrazovni_profil` (`Obrazovni_profil_id`);
176
177ALTER TABLE `nikola.trajkovic.v16_2`.`Profesor2Predmet`
178ADD CONSTRAINT `fk_Profesor2Predmet_Profesor1`
179FOREIGN KEY (`Profesor_id`) REFERENCES `nikola.trajkovic.v16_2`.`Profesor` (`Profesor_id`);
180 
181 ALTER TABLE `nikola.trajkovic.v16_2`.`Profesor2Predmet`
182ADD CONSTRAINT `fk_Profesor2Predmet_Predmet1`
183FOREIGN KEY (`Predmet_id`) REFERENCES `nikola.trajkovic.v16_2`.`Predmet` (`Predmet_id`);
184
185ALTER TABLE `nikola.trajkovic.v16_2`.`Profesor2Predmet`
186ADD CONSTRAINT `fk_Profesor2Predmet_Skolska_godina1`
187FOREIGN KEY (`Skolska_godina_Skolska_godina_id`) REFERENCES `nikola.trajkovic.v16_2`.`Skolska_godina` (`Skolska_godina_id`);
188
189ALTER TABLE `nikola.trajkovic.v16_2`.`Izvestaj`
190ADD CONSTRAINT `fk_Izvestaj_Ucenik1`
191FOREIGN KEY (`Ucenik_Ucenik_id`) REFERENCES `nikola.trajkovic.v16_2`.`Ucenik` (`Ucenik_id`);
192 
193 ALTER TABLE `nikola.trajkovic.v16_2`.`Izvestaj`
194ADD CONSTRAINT `fk_Izvestaj_Predmet1`
195FOREIGN KEY (`Predmet_Predmet_id`) REFERENCES `nikola.trajkovic.v16_2`.`Predmet` (`Predmet_id`);
196
197ALTER TABLE `nikola.trajkovic.v16_2`.`Izvestaj`
198ADD CONSTRAINT `fk_Izvestaj_Ocena1`
199FOREIGN KEY (`Ocena_Ocena_id`) REFERENCES `nikola.trajkovic.v16_2`.`Ocena` (`Ocena_id`);
200
201ALTER TABLE `nikola.trajkovic.v16_2`.`Predmet2Profil`
202ADD CONSTRAINT `fk_Predmet2Profil_Obrazovni_profil1`
203FOREIGN KEY (`Obrazovni_profil_id`) REFERENCES `nikola.trajkovic.v16_2`.`Obrazovni_profil` (`Obrazovni_profil_id`);
204
205ALTER TABLE `nikola.trajkovic.v16_2`.`Predmet2Profil`
206ADD CONSTRAINT `fk_Predmet2Profil_Predmet1`
207FOREIGN KEY (`Predmet_id`) REFERENCES `nikola.trajkovic.v16_2`.`Predmet` (`Predmet_id`);
208
209ALTER TABLE `nikola.trajkovic.v16_2`.`Adresa`
210ADD CONSTRAINT `fk_Adresa_Mesto_stanovanja1`
211FOREIGN KEY (`Mesto_stanovanja_Mesto_stanovanja_id`) REFERENCES `nikola.trajkovic.v16_2`.`Mesto_stanovanja` (`Mesto_stanovanja_id`);
212
213ALTER TABLE `nikola.trajkovic.v16_2`.`Ucenik`
214ADD CONSTRAINT `fk_Ucenik_Adresa1`
215FOREIGN KEY (`Adresa_Adresa_id`) REFERENCES `nikola.trajkovic.v16_2`.`Adresa` (`Adresa_id`);