DROP SCHEMA IF EXISTS `nikola.trajkovic.v16_2` ;
-- -----------------------------------------------------
-- Schema prezime.ime.v16_2
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `nikola.trajkovic.v16_2` DEFAULT CHARACTER SET utf8 ;
USE `nikola.trajkovic.v16_2` ;
-- -----------------------------------------------------
-- Table `nikola.trajkovic.v16_2`.`Podrucje_rada`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `nikola.trajkovic.v16_2`.`Podrucje_rada` ;

CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Podrucje_rada` (
  `Podrucje_rada_id` INT NOT NULL AUTO_INCREMENT,
  `Podrucje_rada_naziv` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`Podrucje_rada_id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin2
COLLATE = latin2_bin;

-- -----------------------------------------------------
-- Table `nikola.trajkovic.v16_2`.`Obrazovni_profil`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `nikola.trajkovic.v16_2`.`Obrazovni_profil` ;

CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Obrazovni_profil` (
  `Obrazovni_profil_id` INT NOT NULL AUTO_INCREMENT,
  `Obrazovni_profil_naziv` VARCHAR(200) NOT NULL,
  `Podrucje_rada_id` INT NOT NULL,
  PRIMARY KEY (`Obrazovni_profil_id`)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin2
COLLATE = latin2_bin;

-- -----------------------------------------------------
-- Table `nikola.trajkovic.v16_2`.`Ucenik`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `nikola.trajkovic.v16_2`.`Ucenik` ;

CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Ucenik` (
  `Ucenik_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `Ucenik_prezime` VARCHAR(100) NOT NULL,
  `Ucenik_ime` VARCHAR(100) NOT NULL,
  `Obrazovni_profil_id` INT NOT NULL,
  PRIMARY KEY (`Ucenik_id`)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin2
COLLATE = latin2_bin;

-- -----------------------------------------------------
-- Table `nikola.trajkovic.v16_2`.`Profesor`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `nikola.trajkovic.v16_2`.`Profesor` ;

CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Profesor` (
  `Profesor_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `Profesor_prezime` VARCHAR(100) NOT NULL,
  `Profesor_ime` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`Profesor_id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin2
COLLATE = latin2_bin;

-- -----------------------------------------------------
-- Table `nikola.trajkovic.v16_2`.`Predmet`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `nikola.trajkovic.v16_2`.`Predmet` ;
CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Predmet` (
  `Predmet_id` INT NOT NULL AUTO_INCREMENT,
  `Predmet_naziv` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`Predmet_id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin2
COLLATE = latin2_bin;

-- -----------------------------------------------------
-- Table `nikola.trajkovic.v16_2`.`Skolska_godina`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `nikola.trajkovic.v16_2`.`Skolska_godina` ;

CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Skolska_godina` (
  `Skolska_godina_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `Skolska_godina` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`Skolska_godina_id`)
  )
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin2
COLLATE = latin2_bin;

-- -----------------------------------------------------
-- Table `nikola.trajkovic.v16_2`.`Profesor2Predmet`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `nikola.trajkovic.v16_2`.`Profesor2Predmet` ;

CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Profesor2Predmet` (
  `Profesor2Predmet_id` INT NOT NULL AUTO_INCREMENT,
  `Profesor_id` INT UNSIGNED NOT NULL,
  `Predmet_id` INT NOT NULL,
  `Skolska_godina_Skolska_godina_id` INT UNSIGNED NOT NULL,
  PRIMARY KEY (`Profesor2Predmet_id`, `Profesor_id`, `Predmet_id`, `Skolska_godina_Skolska_godina_id`)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin2
COLLATE = latin2_bin;

-- -----------------------------------------------------
-- Table `nikola.trajkovic.v16_2`.`Ocena`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `nikola.trajkovic.v16_2`.`Ocena` ;

CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Ocena` (
  `Ocena_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `Ocena_vrednost` INT NULL,
  PRIMARY KEY (`Ocena_id`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin2
COLLATE = latin2_bin;

-- -----------------------------------------------------
-- Table `nikola.trajkovic.v16_2`.`Izvestaj`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `nikola.trajkovic.v16_2`.`Izvestaj` ;

CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Izvestaj` (
  `Izvestaj_id` INT NOT NULL AUTO_INCREMENT,
  `Izvestaj_period` VARCHAR(45) NOT NULL,
  `Ucenik_Ucenik_id` INT UNSIGNED NOT NULL,
  `Predmet_Predmet_id` INT NOT NULL,
  `Ocena_Ocena_id` INT UNSIGNED NOT NULL,
  PRIMARY KEY (`Izvestaj_id`)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin2
COLLATE = latin2_bin;

-- -----------------------------------------------------
-- Table `nikola.trajkovic.v16_2`.`Predmet2Profil`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `nikola.trajkovic.v16_2`.`Predmet2Profil` ;

CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Predmet2Profil` (
  `Predmet2Profil_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `Obrazovni_profil_id` INT NOT NULL,
  `Predmet_id` INT NOT NULL,
  PRIMARY KEY (`Predmet2Profil_id`, `Obrazovni_profil_id`, `Predmet_id`)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin2
COLLATE = latin2_bin;

CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Adresa` (
  `Adresa_id` INT NOT NULL AUTO_INCREMENT,
  `Ulica_i_broj` VARCHAR(45) NOT NULL,
  `Mesto_stanovanja_Mesto_stanovanja_id` INT NOT NULL,
  PRIMARY KEY (`Adresa_id`)
  )
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin2
COLLATE = latin2_bin;

CREATE TABLE IF NOT EXISTS `nikola.trajkovic.v16_2`.`Mesto_stanovanja` (
  `Mesto_stanovanja_id` INT NOT NULL AUTO_INCREMENT,
  `Mesto_stanovanja_naziv` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`Mesto_stanovanja_id`)
  )
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin2
COLLATE = latin2_bin;

ALTER TABLE `nikola.trajkovic.v16_2`.`Obrazovni_profil`
ADD FOREIGN KEY (`Podrucje_rada_id`) REFERENCES `nikola.trajkovic.v16_2`.`Podrucje_rada` (`Podrucje_rada_id`);

ALTER TABLE `nikola.trajkovic.v16_2`.`Ucenik`
ADD FOREIGN KEY (`Obrazovni_profil_id`) REFERENCES `nikola.trajkovic.v16_2`.`Obrazovni_profil` (`Obrazovni_profil_id`);

ALTER TABLE `nikola.trajkovic.v16_2`.`Profesor2Predmet`
ADD CONSTRAINT `fk_Profesor2Predmet_Profesor1`
FOREIGN KEY (`Profesor_id`) REFERENCES `nikola.trajkovic.v16_2`.`Profesor` (`Profesor_id`);

 ALTER TABLE `nikola.trajkovic.v16_2`.`Profesor2Predmet`
ADD CONSTRAINT `fk_Profesor2Predmet_Predmet1`
FOREIGN KEY (`Predmet_id`) REFERENCES `nikola.trajkovic.v16_2`.`Predmet` (`Predmet_id`);

ALTER TABLE `nikola.trajkovic.v16_2`.`Profesor2Predmet`
ADD CONSTRAINT `fk_Profesor2Predmet_Skolska_godina1`
FOREIGN KEY (`Skolska_godina_Skolska_godina_id`) REFERENCES `nikola.trajkovic.v16_2`.`Skolska_godina` (`Skolska_godina_id`);

ALTER TABLE `nikola.trajkovic.v16_2`.`Izvestaj`
ADD CONSTRAINT `fk_Izvestaj_Ucenik1`
FOREIGN KEY (`Ucenik_Ucenik_id`) REFERENCES `nikola.trajkovic.v16_2`.`Ucenik` (`Ucenik_id`);

 ALTER TABLE `nikola.trajkovic.v16_2`.`Izvestaj`
ADD CONSTRAINT `fk_Izvestaj_Predmet1`
FOREIGN KEY (`Predmet_Predmet_id`) REFERENCES `nikola.trajkovic.v16_2`.`Predmet` (`Predmet_id`);

ALTER TABLE `nikola.trajkovic.v16_2`.`Izvestaj`
ADD CONSTRAINT `fk_Izvestaj_Ocena1`
FOREIGN KEY (`Ocena_Ocena_id`) REFERENCES `nikola.trajkovic.v16_2`.`Ocena` (`Ocena_id`);

ALTER TABLE `nikola.trajkovic.v16_2`.`Predmet2Profil`
ADD CONSTRAINT `fk_Predmet2Profil_Obrazovni_profil1`
FOREIGN KEY (`Obrazovni_profil_id`) REFERENCES `nikola.trajkovic.v16_2`.`Obrazovni_profil` (`Obrazovni_profil_id`);

ALTER TABLE `nikola.trajkovic.v16_2`.`Predmet2Profil`
ADD CONSTRAINT `fk_Predmet2Profil_Predmet1`
FOREIGN KEY (`Predmet_id`) REFERENCES `nikola.trajkovic.v16_2`.`Predmet` (`Predmet_id`);

ALTER TABLE `nikola.trajkovic.v16_2`.`Adresa`
ADD CONSTRAINT `fk_Adresa_Mesto_stanovanja1`
FOREIGN KEY (`Mesto_stanovanja_Mesto_stanovanja_id`) REFERENCES `nikola.trajkovic.v16_2`.`Mesto_stanovanja` (`Mesto_stanovanja_id`);

ALTER TABLE `nikola.trajkovic.v16_2`.`Ucenik`
ADD CONSTRAINT `fk_Ucenik_Adresa1`
FOREIGN KEY (`Adresa_Adresa_id`) REFERENCES `nikola.trajkovic.v16_2`.`Adresa` (`Adresa_id`);