· 9 years ago · Sep 30, 2016, 09:12 AM
1-- MySQL Script generated by MySQL Workbench
2-- 09/30/16 11:10:43
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='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema skola
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema skola
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `skola` DEFAULT CHARACTER SET utf8 COLLATE utf8_slovak_ci ;
18USE `skola` ;
19
20-- -----------------------------------------------------
21-- Table `skola`.`mesto`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `skola`.`mesto` (
24 `ID_mesto` INT UNSIGNED NOT NULL AUTO_INCREMENT,
25 `nazov` VARCHAR(45) NOT NULL,
26 `psc` CHAR(5) NULL,
27 PRIMARY KEY (`ID_mesto`),
28 UNIQUE INDEX `ID_mesto_UNIQUE` (`ID_mesto` ASC))
29ENGINE = InnoDB;
30
31
32-- -----------------------------------------------------
33-- Table `skola`.`ucitel`
34-- -----------------------------------------------------
35CREATE TABLE IF NOT EXISTS `skola`.`ucitel` (
36 `ID_ucitel` INT UNSIGNED NOT NULL AUTO_INCREMENT,
37 `meno` VARCHAR(45) NOT NULL,
38 `priezvisko` VARCHAR(45) NOT NULL,
39 `datum_narodenia` DATE NULL,
40 `ulica` VARCHAR(45) NULL,
41 `mesto_ID_mesto` INT UNSIGNED NOT NULL,
42 PRIMARY KEY (`ID_ucitel`),
43 UNIQUE INDEX `ID_ucitel_UNIQUE` (`ID_ucitel` ASC),
44 INDEX `fk_ucitel_mesto1_idx` (`mesto_ID_mesto` ASC),
45 CONSTRAINT `fk_ucitel_mesto1`
46 FOREIGN KEY (`mesto_ID_mesto`)
47 REFERENCES `skola`.`mesto` (`ID_mesto`)
48 ON DELETE NO ACTION
49 ON UPDATE NO ACTION)
50ENGINE = InnoDB;
51
52
53-- -----------------------------------------------------
54-- Table `skola`.`ucebna`
55-- -----------------------------------------------------
56CREATE TABLE IF NOT EXISTS `skola`.`ucebna` (
57 `ID_ucebna` INT UNSIGNED NOT NULL AUTO_INCREMENT,
58 `cislo` VARCHAR(4) NOT NULL,
59 `poschodie` INT NULL,
60 `trakt` VARCHAR(10) NULL,
61 `miest` TINYINT UNSIGNED NULL,
62 `ucitel_ID_ucitel` INT UNSIGNED NOT NULL,
63 PRIMARY KEY (`ID_ucebna`),
64 UNIQUE INDEX `ID_ucebna_UNIQUE` (`ID_ucebna` ASC),
65 UNIQUE INDEX `cislo_UNIQUE` (`cislo` ASC),
66 INDEX `fk_ucebna_ucitel1_idx` (`ucitel_ID_ucitel` ASC),
67 CONSTRAINT `fk_ucebna_ucitel1`
68 FOREIGN KEY (`ucitel_ID_ucitel`)
69 REFERENCES `skola`.`ucitel` (`ID_ucitel`)
70 ON DELETE NO ACTION
71 ON UPDATE NO ACTION)
72ENGINE = InnoDB;
73
74
75-- -----------------------------------------------------
76-- Table `skola`.`trieda`
77-- -----------------------------------------------------
78CREATE TABLE IF NOT EXISTS `skola`.`trieda` (
79 `ID_trieda` INT UNSIGNED NOT NULL AUTO_INCREMENT,
80 `oznacenie` VARCHAR(5) NOT NULL,
81 `pocet_ziakov` INT NULL,
82 `popis` TEXT NULL,
83 `ucebna_ID_ucebna` INT UNSIGNED NOT NULL,
84 `ucitel_ID_ucitel` INT UNSIGNED NOT NULL,
85 PRIMARY KEY (`ID_trieda`),
86 UNIQUE INDEX `ID_trieda_UNIQUE` (`ID_trieda` ASC),
87 INDEX `fk_trieda_ucebna_idx` (`ucebna_ID_ucebna` ASC),
88 INDEX `fk_trieda_ucitel1_idx` (`ucitel_ID_ucitel` ASC),
89 CONSTRAINT `fk_trieda_ucebna`
90 FOREIGN KEY (`ucebna_ID_ucebna`)
91 REFERENCES `skola`.`ucebna` (`ID_ucebna`)
92 ON DELETE NO ACTION
93 ON UPDATE NO ACTION,
94 CONSTRAINT `fk_trieda_ucitel1`
95 FOREIGN KEY (`ucitel_ID_ucitel`)
96 REFERENCES `skola`.`ucitel` (`ID_ucitel`)
97 ON DELETE NO ACTION
98 ON UPDATE NO ACTION)
99ENGINE = InnoDB;
100
101
102-- -----------------------------------------------------
103-- Table `skola`.`predmet`
104-- -----------------------------------------------------
105CREATE TABLE IF NOT EXISTS `skola`.`predmet` (
106 `ID_predmet` INT UNSIGNED NOT NULL AUTO_INCREMENT,
107 `nazov` VARCHAR(45) NOT NULL,
108 `skratka` CHAR(3) NOT NULL,
109 `popis` TEXT NULL,
110 PRIMARY KEY (`ID_predmet`),
111 UNIQUE INDEX `ID_predmet_UNIQUE` (`ID_predmet` ASC),
112 UNIQUE INDEX `skratka_UNIQUE` (`skratka` ASC))
113ENGINE = InnoDB;
114
115
116-- -----------------------------------------------------
117-- Table `skola`.`ucitel_has_predmet`
118-- -----------------------------------------------------
119CREATE TABLE IF NOT EXISTS `skola`.`ucitel_has_predmet` (
120 `ucitel_ID_ucitel` INT UNSIGNED NOT NULL,
121 `predmet_ID_predmet` INT UNSIGNED NOT NULL,
122 PRIMARY KEY (`ucitel_ID_ucitel`, `predmet_ID_predmet`),
123 INDEX `fk_ucitel_has_predmet_predmet1_idx` (`predmet_ID_predmet` ASC),
124 INDEX `fk_ucitel_has_predmet_ucitel1_idx` (`ucitel_ID_ucitel` ASC),
125 CONSTRAINT `fk_ucitel_has_predmet_ucitel1`
126 FOREIGN KEY (`ucitel_ID_ucitel`)
127 REFERENCES `skola`.`ucitel` (`ID_ucitel`)
128 ON DELETE NO ACTION
129 ON UPDATE NO ACTION,
130 CONSTRAINT `fk_ucitel_has_predmet_predmet1`
131 FOREIGN KEY (`predmet_ID_predmet`)
132 REFERENCES `skola`.`predmet` (`ID_predmet`)
133 ON DELETE NO ACTION
134 ON UPDATE NO ACTION)
135ENGINE = InnoDB;
136
137
138SET SQL_MODE=@OLD_SQL_MODE;
139SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
140SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;