-- MySQL Script generated by MySQL Workbench
-- Thu Jun 20 20:14:23 2019
-- Model: New Model    Version: 1.0
-- MySQL Workbench Forward Engineering

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @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';

-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------

-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
USE `mydb` ;

-- -----------------------------------------------------
-- Table `mydb`.`AJAsistent`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`AJAsistent` (
  `idAsistent` INT NOT NULL,
  `ime` VARCHAR(20) NOT NULL,
  `prezime` VARCHAR(20) NOT NULL,
  `username` VARCHAR(15) NOT NULL,
  PRIMARY KEY (`idAsistent`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`AJStudent`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`AJStudent` (
  `idStudent` INT GENERATED ALWAYS AS () VIRTUAL,
  `brojIndeksa` INT NOT NULL,
  `ime` VARCHAR(20) NOT NULL,
  `Prezime` VARCHAR(20) NOT NULL,
  `datumR` DATE NOT NULL,
  `username` VARCHAR(15) NOT NULL,
  PRIMARY KEY (`idStudent`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`AJProfesor`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`AJProfesor` (
  `idProfesor` INT GENERATED ALWAYS AS () VIRTUAL,
  `ime` VARCHAR(45) NOT NULL,
  `prezime` VARCHAR(45) NOT NULL,
  `zvanje` VARCHAR(45) NOT NULL,
  `username` VARCHAR(15) NOT NULL,
  PRIMARY KEY (`idProfesor`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`AJPredmet`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`AJPredmet` (
  `idPredmet` INT NOT NULL,
  `naziv` VARCHAR(20) NOT NULL,
  `Asistent_idAsistent` INT NOT NULL,
  `Profesor_idProfesor` INT NOT NULL,
  PRIMARY KEY (`idPredmet`),
  INDEX `fk_Predmet_Asistent1_idx` (`Asistent_idAsistent` ASC),
  INDEX `fk_Predmet_Profesor1_idx` (`Profesor_idProfesor` ASC),
  CONSTRAINT `fk_Predmet_Asistent1`
    FOREIGN KEY (`Asistent_idAsistent`)
    REFERENCES `mydb`.`AJAsistent` (`idAsistent`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Predmet_Profesor1`
    FOREIGN KEY (`Profesor_idProfesor`)
    REFERENCES `mydb`.`AJProfesor` (`idProfesor`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`AJTest`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`AJTest` (
  `idSemaTest` INT NOT NULL,
  `AJPredmet_idPredmet` INT NOT NULL,
  `imeTesta` VARCHAR(20) NOT NULL,
  PRIMARY KEY (`idSemaTest`),
  INDEX `fk_AJSemaTest_AJPredmet1_idx` (`AJPredmet_idPredmet` ASC),
  CONSTRAINT `fk_AJSemaTest_AJPredmet1`
    FOREIGN KEY (`AJPredmet_idPredmet`)
    REFERENCES `mydb`.`AJPredmet` (`idPredmet`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`AJPitanja`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`AJPitanja` (
  `idPitanja` INT NOT NULL,
  `pitanje` VARCHAR(40) NOT NULL,
  `brojPoena` INT NOT NULL,
  `AJTest_idSemaTest` INT NOT NULL,
  PRIMARY KEY (`idPitanja`),
  INDEX `fk_AJPitanja_AJTest1_idx` (`AJTest_idSemaTest` ASC),
  CONSTRAINT `fk_AJPitanja_AJTest1`
    FOREIGN KEY (`AJTest_idSemaTest`)
    REFERENCES `mydb`.`AJTest` (`idSemaTest`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`AJUser`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`AJUser` (
  `idUser` INT GENERATED ALWAYS AS () VIRTUAL,
  `username` VARCHAR(20) NOT NULL,
  `password` VARCHAR(45) NOT NULL,
  `uloga` VARCHAR(1) NOT NULL,
  PRIMARY KEY (`idUser`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`AJRole`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`AJRole` (
  `idRole` INT GENERATED ALWAYS AS () VIRTUAL,
  `Naziv` VARCHAR(20) NOT NULL,
  PRIMARY KEY (`idRole`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`Predmet_has_Student`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Predmet_has_Student` (
  `Predmet_idPredmet` INT NOT NULL,
  `Student_idStudent` INT NOT NULL,
  PRIMARY KEY (`Predmet_idPredmet`, `Student_idStudent`),
  INDEX `fk_Predmet_has_Student_Student1_idx` (`Student_idStudent` ASC),
  INDEX `fk_Predmet_has_Student_Predmet_idx` (`Predmet_idPredmet` ASC),
  CONSTRAINT `fk_Predmet_has_Student_Predmet`
    FOREIGN KEY (`Predmet_idPredmet`)
    REFERENCES `mydb`.`AJPredmet` (`idPredmet`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Predmet_has_Student_Student1`
    FOREIGN KEY (`Student_idStudent`)
    REFERENCES `mydb`.`AJStudent` (`idStudent`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`AJStudent_has_Predmet`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`AJStudent_has_Predmet` (
  `Student_idStudent` INT NOT NULL,
  `Predmet_idPredmet` INT NOT NULL,
  PRIMARY KEY (`Student_idStudent`, `Predmet_idPredmet`),
  INDEX `fk_Student_has_Predmet_Predmet1_idx` (`Predmet_idPredmet` ASC),
  INDEX `fk_Student_has_Predmet_Student1_idx` (`Student_idStudent` ASC),
  CONSTRAINT `fk_Student_has_Predmet_Student1`
    FOREIGN KEY (`Student_idStudent`)
    REFERENCES `mydb`.`AJStudent` (`idStudent`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Student_has_Predmet_Predmet1`
    FOREIGN KEY (`Predmet_idPredmet`)
    REFERENCES `mydb`.`AJPredmet` (`idPredmet`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`AJUser_has_Role`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`AJUser_has_Role` (
  `User_idUser` INT NOT NULL,
  `Role_idRole` INT NOT NULL,
  PRIMARY KEY (`User_idUser`, `Role_idRole`),
  INDEX `fk_User_has_Role_Role1_idx` (`Role_idRole` ASC),
  INDEX `fk_User_has_Role_User1_idx` (`User_idUser` ASC),
  CONSTRAINT `fk_User_has_Role_User1`
    FOREIGN KEY (`User_idUser`)
    REFERENCES `mydb`.`AJUser` (`idUser`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_User_has_Role_Role1`
    FOREIGN KEY (`Role_idRole`)
    REFERENCES `mydb`.`AJRole` (`idRole`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`AJObavestenje`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`AJObavestenje` (
  `idObavestenje` INT NOT NULL,
  `tekst` VARCHAR(100) NOT NULL,
  `datum` DATETIME NOT NULL,
  `AJPredmet_idPredmet` INT NOT NULL,
  PRIMARY KEY (`idObavestenje`),
  INDEX `fk_Obavestenje_AJPredmet1_idx` (`AJPredmet_idPredmet` ASC),
  CONSTRAINT `fk_Obavestenje_AJPredmet1`
    FOREIGN KEY (`AJPredmet_idPredmet`)
    REFERENCES `mydb`.`AJPredmet` (`idPredmet`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`AJOdgovor`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`AJOdgovor` (
  `idOdgovor` INT NOT NULL,
  `odgovor` VARCHAR(45) NOT NULL,
  `AJPitanja_idPitanja` INT NOT NULL,
  `AJStudent_idStudent` INT NOT NULL,
  `tacnost` INT NOT NULL DEFAULT 1,
  `AJPredmet_idPredmet` INT NOT NULL,
  PRIMARY KEY (`idOdgovor`),
  INDEX `fk_AJOdgovor_AJPitanja1_idx` (`AJPitanja_idPitanja` ASC),
  INDEX `fk_AJOdgovor_AJStudent1_idx` (`AJStudent_idStudent` ASC),
  INDEX `fk_AJOdgovor_AJPredmet1_idx` (`AJPredmet_idPredmet` ASC),
  CONSTRAINT `fk_AJOdgovor_AJPitanja1`
    FOREIGN KEY (`AJPitanja_idPitanja`)
    REFERENCES `mydb`.`AJPitanja` (`idPitanja`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_AJOdgovor_AJStudent1`
    FOREIGN KEY (`AJStudent_idStudent`)
    REFERENCES `mydb`.`AJStudent` (`idStudent`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_AJOdgovor_AJPredmet1`
    FOREIGN KEY (`AJPredmet_idPredmet`)
    REFERENCES `mydb`.`AJPredmet` (`idPredmet`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;