· 9 years ago · Dec 12, 2016, 10:41 AM
1-- MySQL Script generated by MySQL Workbench
2-- 12/11/16 22:32:22
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 mydb
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema mydb
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
18USE `mydb` ;
19
20-- -----------------------------------------------------
21-- Table `mydb`.`Skola`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`Skola` (
24 `Skola_ID` INT NOT NULL AUTO_INCREMENT,
25 `Nosaukums` VARCHAR(45) NULL,
26 `Adrese` VARCHAR(45) NULL,
27 PRIMARY KEY (`Skola_ID`))
28ENGINE = InnoDB;
29
30
31-- -----------------------------------------------------
32-- Table `mydb`.`Skolotajs`
33-- -----------------------------------------------------
34CREATE TABLE IF NOT EXISTS `mydb`.`Skolotajs` (
35 `Skolotajs_ID` INT NOT NULL AUTO_INCREMENT,
36 `Vards` VARCHAR(45) NULL,
37 `Uzvards` VARCHAR(45) NULL,
38 `Adrese` VARCHAR(45) NULL,
39 `Tel_numurs` VARCHAR(45) NULL,
40 `Skola_ID` INT NOT NULL,
41 PRIMARY KEY (`Skolotajs_ID`),
42 INDEX `fk_Skolotajs_Skola1_idx` (`Skola_ID` ASC),
43 CONSTRAINT `fk_Skolotajs_Skola1`
44 FOREIGN KEY (`Skola_ID`)
45 REFERENCES `mydb`.`Skola` (`Skola_ID`)
46 ON DELETE NO ACTION
47 ON UPDATE NO ACTION)
48ENGINE = InnoDB;
49
50
51-- -----------------------------------------------------
52-- Table `mydb`.`Klase`
53-- -----------------------------------------------------
54CREATE TABLE IF NOT EXISTS `mydb`.`Klase` (
55 `Klase_ID` INT NOT NULL AUTO_INCREMENT,
56 `Klase` VARCHAR(45) NULL,
57 `Skolotajs_ID` INT NOT NULL,
58 PRIMARY KEY (`Klase_ID`),
59 INDEX `fk_Klase_Skolotajs1_idx` (`Skolotajs_ID` ASC),
60 CONSTRAINT `fk_Klase_Skolotajs1`
61 FOREIGN KEY (`Skolotajs_ID`)
62 REFERENCES `mydb`.`Skolotajs` (`Skolotajs_ID`)
63 ON DELETE NO ACTION
64 ON UPDATE NO ACTION)
65ENGINE = InnoDB;
66
67
68-- -----------------------------------------------------
69-- Table `mydb`.`Skolnieks`
70-- -----------------------------------------------------
71CREATE TABLE IF NOT EXISTS `mydb`.`Skolnieks` (
72 `Skolnieks_ID` INT NOT NULL AUTO_INCREMENT,
73 `Vards` VARCHAR(45) NULL,
74 `Uzvards` VARCHAR(45) NULL,
75 `Dzim_datums` DATE NULL,
76 `Adrese` VARCHAR(45) NULL,
77 `Tel_numurs` INT NULL,
78 `Skola_ID` INT NOT NULL,
79 `Klase_ID` INT NOT NULL,
80 PRIMARY KEY (`Skolnieks_ID`),
81 INDEX `fk_Skolnieks_Skola1_idx` (`Skola_ID` ASC),
82 INDEX `fk_Skolnieks_Klase1_idx` (`Klase_ID` ASC),
83 CONSTRAINT `fk_Skolnieks_Skola1`
84 FOREIGN KEY (`Skola_ID`)
85 REFERENCES `mydb`.`Skola` (`Skola_ID`)
86 ON DELETE NO ACTION
87 ON UPDATE NO ACTION,
88 CONSTRAINT `fk_Skolnieks_Klase1`
89 FOREIGN KEY (`Klase_ID`)
90 REFERENCES `mydb`.`Klase` (`Klase_ID`)
91 ON DELETE NO ACTION
92 ON UPDATE NO ACTION)
93ENGINE = InnoDB;
94
95
96-- -----------------------------------------------------
97-- Table `mydb`.`Prieksmets`
98-- -----------------------------------------------------
99CREATE TABLE IF NOT EXISTS `mydb`.`Prieksmets` (
100 `Prieksmets_ID` INT NOT NULL AUTO_INCREMENT,
101 `Nosaukums` VARCHAR(45) NULL,
102 `Skolotajs_ID` INT NOT NULL,
103 PRIMARY KEY (`Prieksmets_ID`),
104 INDEX `fk_Prieksmets_Skolotajs1_idx` (`Skolotajs_ID` ASC),
105 CONSTRAINT `fk_Prieksmets_Skolotajs1`
106 FOREIGN KEY (`Skolotajs_ID`)
107 REFERENCES `mydb`.`Skolotajs` (`Skolotajs_ID`)
108 ON DELETE NO ACTION
109 ON UPDATE NO ACTION)
110ENGINE = InnoDB;
111
112
113-- -----------------------------------------------------
114-- Table `mydb`.`Kavejums`
115-- -----------------------------------------------------
116CREATE TABLE IF NOT EXISTS `mydb`.`Kavejums` (
117 `Kavejums_ID` INT NOT NULL AUTO_INCREMENT,
118 `Kavejums` INT NULL,
119 `Datums` DATE NULL,
120 `Prieksmets_ID` INT NOT NULL,
121 `Skolnieks_ID` INT NOT NULL,
122 PRIMARY KEY (`Kavejums_ID`),
123 INDEX `fk_Kavejums_Prieksmets1_idx` (`Prieksmets_ID` ASC),
124 INDEX `fk_Kavejums_Skolnieks1_idx` (`Skolnieks_ID` ASC),
125 CONSTRAINT `fk_Kavejums_Prieksmets1`
126 FOREIGN KEY (`Prieksmets_ID`)
127 REFERENCES `mydb`.`Prieksmets` (`Prieksmets_ID`)
128 ON DELETE NO ACTION
129 ON UPDATE NO ACTION,
130 CONSTRAINT `fk_Kavejums_Skolnieks1`
131 FOREIGN KEY (`Skolnieks_ID`)
132 REFERENCES `mydb`.`Skolnieks` (`Skolnieks_ID`)
133 ON DELETE NO ACTION
134 ON UPDATE NO ACTION)
135ENGINE = InnoDB;
136
137
138-- -----------------------------------------------------
139-- Table `mydb`.`Majasdarbs`
140-- -----------------------------------------------------
141CREATE TABLE IF NOT EXISTS `mydb`.`Majasdarbs` (
142 `Majasdarbs_ID` INT NOT NULL AUTO_INCREMENT,
143 `Majasdarbs` VARCHAR(255) NULL,
144 `Skolnieks_ID` INT NOT NULL,
145 `Prieksmets_ID` INT NOT NULL,
146 `Klase_ID` INT NOT NULL,
147 PRIMARY KEY (`Majasdarbs_ID`),
148 INDEX `fk_Majasdarbs_Skolnieks1_idx` (`Skolnieks_ID` ASC),
149 INDEX `fk_Majasdarbs_Prieksmets1_idx` (`Prieksmets_ID` ASC),
150 INDEX `fk_Majasdarbs_Klase1_idx` (`Klase_ID` ASC),
151 CONSTRAINT `fk_Majasdarbs_Skolnieks1`
152 FOREIGN KEY (`Skolnieks_ID`)
153 REFERENCES `mydb`.`Skolnieks` (`Skolnieks_ID`)
154 ON DELETE NO ACTION
155 ON UPDATE NO ACTION,
156 CONSTRAINT `fk_Majasdarbs_Prieksmets1`
157 FOREIGN KEY (`Prieksmets_ID`)
158 REFERENCES `mydb`.`Prieksmets` (`Prieksmets_ID`)
159 ON DELETE NO ACTION
160 ON UPDATE NO ACTION,
161 CONSTRAINT `fk_Majasdarbs_Klase1`
162 FOREIGN KEY (`Klase_ID`)
163 REFERENCES `mydb`.`Klase` (`Klase_ID`)
164 ON DELETE NO ACTION
165 ON UPDATE NO ACTION)
166ENGINE = InnoDB;
167
168
169-- -----------------------------------------------------
170-- Table `mydb`.`Kontroldarbs`
171-- -----------------------------------------------------
172CREATE TABLE IF NOT EXISTS `mydb`.`Kontroldarbs` (
173 `Kontroldarbs_ID` INT NOT NULL AUTO_INCREMENT,
174 `Kontroldarbs` VARCHAR(45) NULL,
175 `Prieksmets_ID` INT NOT NULL,
176 `Skolnieks_ID` INT NOT NULL,
177 `Klase_ID` INT NOT NULL,
178 PRIMARY KEY (`Kontroldarbs_ID`),
179 INDEX `fk_Kontroldarbs_Prieksmets1_idx` (`Prieksmets_ID` ASC),
180 INDEX `fk_Kontroldarbs_Skolnieks1_idx` (`Skolnieks_ID` ASC),
181 INDEX `fk_Kontroldarbs_Klase1_idx` (`Klase_ID` ASC),
182 CONSTRAINT `fk_Kontroldarbs_Prieksmets1`
183 FOREIGN KEY (`Prieksmets_ID`)
184 REFERENCES `mydb`.`Prieksmets` (`Prieksmets_ID`)
185 ON DELETE NO ACTION
186 ON UPDATE NO ACTION,
187 CONSTRAINT `fk_Kontroldarbs_Skolnieks1`
188 FOREIGN KEY (`Skolnieks_ID`)
189 REFERENCES `mydb`.`Skolnieks` (`Skolnieks_ID`)
190 ON DELETE NO ACTION
191 ON UPDATE NO ACTION,
192 CONSTRAINT `fk_Kontroldarbs_Klase1`
193 FOREIGN KEY (`Klase_ID`)
194 REFERENCES `mydb`.`Klase` (`Klase_ID`)
195 ON DELETE NO ACTION
196 ON UPDATE NO ACTION)
197ENGINE = InnoDB;
198
199
200-- -----------------------------------------------------
201-- Table `mydb`.`Atzime_MD`
202-- -----------------------------------------------------
203CREATE TABLE IF NOT EXISTS `mydb`.`Atzime_MD` (
204 `Atzime_MD_ID` INT NOT NULL AUTO_INCREMENT,
205 `Atzime` INT NULL,
206 `Skolnieks_ID` INT NOT NULL,
207 `Prieksmets_ID` INT NOT NULL,
208 `Majasdarbs_ID` INT NOT NULL,
209 PRIMARY KEY (`Atzime_MD_ID`),
210 INDEX `fk_Atzime_MD_Skolnieks1_idx` (`Skolnieks_ID` ASC),
211 INDEX `fk_Atzime_MD_Prieksmets1_idx` (`Prieksmets_ID` ASC),
212 INDEX `fk_Atzime_MD_Majasdarbs1_idx` (`Majasdarbs_ID` ASC),
213 CONSTRAINT `fk_Atzime_MD_Skolnieks1`
214 FOREIGN KEY (`Skolnieks_ID`)
215 REFERENCES `mydb`.`Skolnieks` (`Skolnieks_ID`)
216 ON DELETE NO ACTION
217 ON UPDATE NO ACTION,
218 CONSTRAINT `fk_Atzime_MD_Prieksmets1`
219 FOREIGN KEY (`Prieksmets_ID`)
220 REFERENCES `mydb`.`Prieksmets` (`Prieksmets_ID`)
221 ON DELETE NO ACTION
222 ON UPDATE NO ACTION,
223 CONSTRAINT `fk_Atzime_MD_Majasdarbs1`
224 FOREIGN KEY (`Majasdarbs_ID`)
225 REFERENCES `mydb`.`Majasdarbs` (`Majasdarbs_ID`)
226 ON DELETE NO ACTION
227 ON UPDATE NO ACTION)
228ENGINE = InnoDB;
229
230
231-- -----------------------------------------------------
232-- Table `mydb`.`Atzime_KD`
233-- -----------------------------------------------------
234CREATE TABLE IF NOT EXISTS `mydb`.`Atzime_KD` (
235 `Atzime_KD_ID` INT NOT NULL AUTO_INCREMENT,
236 `Atzime` INT NULL,
237 `Skolnieks_ID` INT NOT NULL,
238 `Kontroldarbs_ID` INT NOT NULL,
239 `Prieksmets_ID` INT NOT NULL,
240 PRIMARY KEY (`Atzime_KD_ID`),
241 INDEX `fk_Atzime_KD_Skolnieks1_idx` (`Skolnieks_ID` ASC),
242 INDEX `fk_Atzime_KD_Kontroldarbs1_idx` (`Kontroldarbs_ID` ASC),
243 INDEX `fk_Atzime_KD_Prieksmets1_idx` (`Prieksmets_ID` ASC),
244 CONSTRAINT `fk_Atzime_KD_Skolnieks1`
245 FOREIGN KEY (`Skolnieks_ID`)
246 REFERENCES `mydb`.`Skolnieks` (`Skolnieks_ID`)
247 ON DELETE NO ACTION
248 ON UPDATE NO ACTION,
249 CONSTRAINT `fk_Atzime_KD_Kontroldarbs1`
250 FOREIGN KEY (`Kontroldarbs_ID`)
251 REFERENCES `mydb`.`Kontroldarbs` (`Kontroldarbs_ID`)
252 ON DELETE NO ACTION
253 ON UPDATE NO ACTION,
254 CONSTRAINT `fk_Atzime_KD_Prieksmets1`
255 FOREIGN KEY (`Prieksmets_ID`)
256 REFERENCES `mydb`.`Prieksmets` (`Prieksmets_ID`)
257 ON DELETE NO ACTION
258 ON UPDATE NO ACTION)
259ENGINE = InnoDB;
260
261
262SET SQL_MODE=@OLD_SQL_MODE;
263SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
264SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;