Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- MySQL Script generated by MySQL Workbench
- -- Thu Jun 20 20:18:53 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 AUTO_INCREMENT,
- `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 NOT NULL AUTO_INCREMENT,
- `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 NOT NULL AUTO_INCREMENT,
- `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 AUTO_INCREMENT,
- `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 AUTO_INCREMENT,
- `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 AUTO_INCREMENT,
- `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 NOT NULL AUTO_INCREMENT,
- `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 NOT NULL AUTO_INCREMENT,
- `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 AUTO_INCREMENT,
- `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 AUTO_INCREMENT,
- `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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement