· 8 years ago · Dec 15, 2017, 09:08 PM
1-- MySQL Script generated by MySQL Workbench
2-- Fri Dec 15 18:02:31 2017
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 DB_STA_GAMA
12-- -----------------------------------------------------
13DROP SCHEMA IF EXISTS `DB_STA_GAMA` ;
14
15-- -----------------------------------------------------
16-- Schema DB_STA_GAMA
17-- -----------------------------------------------------
18CREATE SCHEMA IF NOT EXISTS `DB_STA_GAMA` DEFAULT CHARACTER SET utf8 ;
19USE `DB_STA_GAMA` ;
20
21-- -----------------------------------------------------
22-- Table `DB_STA_GAMA`.`REPUESTO`
23-- -----------------------------------------------------
24DROP TABLE IF EXISTS `DB_STA_GAMA`.`REPUESTO` ;
25
26CREATE TABLE IF NOT EXISTS `DB_STA_GAMA`.`REPUESTO` (
27 `ID_REP` INT NOT NULL AUTO_INCREMENT,
28 `NOMBRE` VARCHAR(45) NULL,
29 PRIMARY KEY (`ID_REP`))
30ENGINE = InnoDB;
31
32
33-- -----------------------------------------------------
34-- Table `DB_STA_GAMA`.`PAIS`
35-- -----------------------------------------------------
36DROP TABLE IF EXISTS `DB_STA_GAMA`.`PAIS` ;
37
38CREATE TABLE IF NOT EXISTS `DB_STA_GAMA`.`PAIS` (
39 `ID_PS` INT NOT NULL,
40 `NOMBRE_PAIS` VARCHAR(45) NULL,
41 PRIMARY KEY (`ID_PS`))
42ENGINE = InnoDB;
43
44
45-- -----------------------------------------------------
46-- Table `DB_STA_GAMA`.`REGION`
47-- -----------------------------------------------------
48DROP TABLE IF EXISTS `DB_STA_GAMA`.`REGION` ;
49
50CREATE TABLE IF NOT EXISTS `DB_STA_GAMA`.`REGION` (
51 `COD_REG` INT NOT NULL,
52 `NOMBRE_REGION` VARCHAR(45) NULL,
53 `ID_PS` INT NULL,
54 PRIMARY KEY (`COD_REG`),
55 INDEX `ID_PS_idx` (`ID_PS` ASC),
56 CONSTRAINT `ID_PS`
57 FOREIGN KEY (`ID_PS`)
58 REFERENCES `DB_STA_GAMA`.`PAIS` (`ID_PS`)
59 ON DELETE NO ACTION
60 ON UPDATE NO ACTION)
61ENGINE = InnoDB;
62
63
64-- -----------------------------------------------------
65-- Table `DB_STA_GAMA`.`CIUDAD`
66-- -----------------------------------------------------
67DROP TABLE IF EXISTS `DB_STA_GAMA`.`CIUDAD` ;
68
69CREATE TABLE IF NOT EXISTS `DB_STA_GAMA`.`CIUDAD` (
70 `ID_CIUDAD` INT NOT NULL,
71 `NOMBRE_CIUDAD` VARCHAR(45) NULL,
72 `ID_REG` INT NULL,
73 PRIMARY KEY (`ID_CIUDAD`),
74 INDEX `ID_REG_idx` (`ID_REG` ASC),
75 CONSTRAINT `ID_REG`
76 FOREIGN KEY (`ID_REG`)
77 REFERENCES `DB_STA_GAMA`.`REGION` (`COD_REG`)
78 ON DELETE NO ACTION
79 ON UPDATE NO ACTION)
80ENGINE = InnoDB;
81
82
83-- -----------------------------------------------------
84-- Table `DB_STA_GAMA`.`FABRICA`
85-- -----------------------------------------------------
86DROP TABLE IF EXISTS `DB_STA_GAMA`.`FABRICA` ;
87
88CREATE TABLE IF NOT EXISTS `DB_STA_GAMA`.`FABRICA` (
89 `ID_FAB` INT NOT NULL,
90 `NOMBRE_FAB` VARCHAR(45) NULL,
91 `ID_CIUDAD` INT NULL,
92 PRIMARY KEY (`ID_FAB`),
93 INDEX `ID_CIUDAD_idx` (`ID_CIUDAD` ASC),
94 CONSTRAINT `ID_CIUDAD`
95 FOREIGN KEY (`ID_CIUDAD`)
96 REFERENCES `DB_STA_GAMA`.`CIUDAD` (`ID_CIUDAD`)
97 ON DELETE NO ACTION
98 ON UPDATE NO ACTION)
99ENGINE = InnoDB;
100
101
102-- -----------------------------------------------------
103-- Table `DB_STA_GAMA`.`CENTRO_DISTRIBUCION`
104-- -----------------------------------------------------
105DROP TABLE IF EXISTS `DB_STA_GAMA`.`CENTRO_DISTRIBUCION` ;
106
107CREATE TABLE IF NOT EXISTS `DB_STA_GAMA`.`CENTRO_DISTRIBUCION` (
108 `ID_CD` INT NOT NULL,
109 `NOMBRE_CD` VARCHAR(45) NULL,
110 `ID_CIUDAD` INT NULL,
111 `ID_FAB` INT NULL,
112 PRIMARY KEY (`ID_CD`),
113 INDEX `ID_FAB_idx` (`ID_FAB` ASC),
114 INDEX `ID_CIUDAD_idx` (`ID_CIUDAD` ASC),
115 CONSTRAINT `ID_FAB`
116 FOREIGN KEY (`ID_FAB`)
117 REFERENCES `DB_STA_GAMA`.`FABRICA` (`ID_FAB`)
118 ON DELETE NO ACTION
119 ON UPDATE NO ACTION,
120 CONSTRAINT `ID_CIUDAD`
121 FOREIGN KEY (`ID_CIUDAD`)
122 REFERENCES `DB_STA_GAMA`.`CIUDAD` (`ID_CIUDAD`)
123 ON DELETE NO ACTION
124 ON UPDATE NO ACTION)
125ENGINE = InnoDB;
126
127
128-- -----------------------------------------------------
129-- Table `DB_STA_GAMA`.`SERVICIO_TECNICO`
130-- -----------------------------------------------------
131DROP TABLE IF EXISTS `DB_STA_GAMA`.`SERVICIO_TECNICO` ;
132
133CREATE TABLE IF NOT EXISTS `DB_STA_GAMA`.`SERVICIO_TECNICO` (
134 `ID_SSTT` INT NOT NULL,
135 `NOMBRE_SSTT` VARCHAR(45) NULL,
136 `ID_CIUDAD` INT NULL,
137 `ID_CD` INT NULL,
138 PRIMARY KEY (`ID_SSTT`),
139 INDEX `ID_CD_idx` (`ID_CD` ASC),
140 INDEX `ID_CIUDAD_idx` (`ID_CIUDAD` ASC),
141 CONSTRAINT `ID_CD`
142 FOREIGN KEY (`ID_CD`)
143 REFERENCES `DB_STA_GAMA`.`CENTRO_DISTRIBUCION` (`ID_CD`)
144 ON DELETE NO ACTION
145 ON UPDATE NO ACTION,
146 CONSTRAINT `ID_CIUDAD`
147 FOREIGN KEY (`ID_CIUDAD`)
148 REFERENCES `DB_STA_GAMA`.`CIUDAD` (`ID_CIUDAD`)
149 ON DELETE NO ACTION
150 ON UPDATE NO ACTION)
151ENGINE = InnoDB;
152
153
154-- -----------------------------------------------------
155-- Table `DB_STA_GAMA`.`PEDIDO`
156-- -----------------------------------------------------
157DROP TABLE IF EXISTS `DB_STA_GAMA`.`PEDIDO` ;
158
159CREATE TABLE IF NOT EXISTS `DB_STA_GAMA`.`PEDIDO` (
160 `NRO_PEDIDO` INT NOT NULL AUTO_INCREMENT,
161 `ID_SSTT` INT NULL,
162 PRIMARY KEY (`NRO_PEDIDO`),
163 INDEX `ID_SSTT_idx` (`ID_SSTT` ASC),
164 CONSTRAINT `ID_SSTT`
165 FOREIGN KEY (`ID_SSTT`)
166 REFERENCES `DB_STA_GAMA`.`SERVICIO_TECNICO` (`ID_SSTT`)
167 ON DELETE NO ACTION
168 ON UPDATE NO ACTION)
169ENGINE = InnoDB;
170
171
172-- -----------------------------------------------------
173-- Table `DB_STA_GAMA`.`DETALLE_PEDIDO`
174-- -----------------------------------------------------
175DROP TABLE IF EXISTS `DB_STA_GAMA`.`DETALLE_PEDIDO` ;
176
177CREATE TABLE IF NOT EXISTS `DB_STA_GAMA`.`DETALLE_PEDIDO` (
178 `ID_REP` INT NOT NULL,
179 `NRO_PEDIDO` INT NOT NULL,
180 INDEX `NRO_PEDIDO_idx` (`NRO_PEDIDO` ASC),
181 CONSTRAINT `NRO_PEDIDO`
182 FOREIGN KEY (`NRO_PEDIDO`)
183 REFERENCES `DB_STA_GAMA`.`PEDIDO` (`NRO_PEDIDO`)
184 ON DELETE NO ACTION
185 ON UPDATE NO ACTION,
186 CONSTRAINT `ID_REP`
187 FOREIGN KEY (`NRO_PEDIDO`)
188 REFERENCES `DB_STA_GAMA`.`REPUESTO` (`ID_REP`)
189 ON DELETE NO ACTION
190 ON UPDATE NO ACTION)
191ENGINE = InnoDB;
192
193
194-- -----------------------------------------------------
195-- Table `DB_STA_GAMA`.`PERSONA`
196-- -----------------------------------------------------
197DROP TABLE IF EXISTS `DB_STA_GAMA`.`PERSONA` ;
198
199CREATE TABLE IF NOT EXISTS `DB_STA_GAMA`.`PERSONA` (
200 `RUT` INT NOT NULL,
201 `NOMBRE` VARCHAR(45) NULL,
202 `APELLIDO_P` VARCHAR(45) NULL,
203 `APELLIDO_M` VARCHAR(45) NULL,
204 `ID_CIUDAD` INT NULL,
205 PRIMARY KEY (`RUT`),
206 INDEX `ID_CIUDAD_idx` (`ID_CIUDAD` ASC),
207 CONSTRAINT `ID_CIUDAD`
208 FOREIGN KEY (`ID_CIUDAD`)
209 REFERENCES `DB_STA_GAMA`.`CIUDAD` (`ID_CIUDAD`)
210 ON DELETE NO ACTION
211 ON UPDATE NO ACTION)
212ENGINE = InnoDB;
213
214
215-- -----------------------------------------------------
216-- Table `DB_STA_GAMA`.`CARGO`
217-- -----------------------------------------------------
218DROP TABLE IF EXISTS `DB_STA_GAMA`.`CARGO` ;
219
220CREATE TABLE IF NOT EXISTS `DB_STA_GAMA`.`CARGO` (
221 `ID_CARGO` INT NOT NULL,
222 `NOMBRE_CARGO` VARCHAR(45) NULL,
223 PRIMARY KEY (`ID_CARGO`))
224ENGINE = InnoDB;
225
226
227-- -----------------------------------------------------
228-- Table `DB_STA_GAMA`.`USUARIO_SSTT`
229-- -----------------------------------------------------
230DROP TABLE IF EXISTS `DB_STA_GAMA`.`USUARIO_SSTT` ;
231
232CREATE TABLE IF NOT EXISTS `DB_STA_GAMA`.`USUARIO_SSTT` (
233 `ID_SSTT` INT NOT NULL,
234 `RUT` INT NULL,
235 `ID_CARGO` INT NULL,
236 PRIMARY KEY (`ID_SSTT`),
237 INDEX `RUT_idx` (`RUT` ASC),
238 INDEX `ID_CARGO_idx` (`ID_CARGO` ASC),
239 CONSTRAINT `RUT`
240 FOREIGN KEY (`RUT`)
241 REFERENCES `DB_STA_GAMA`.`PERSONA` (`RUT`)
242 ON DELETE NO ACTION
243 ON UPDATE NO ACTION,
244 CONSTRAINT `ID_CARGO`
245 FOREIGN KEY (`ID_CARGO`)
246 REFERENCES `DB_STA_GAMA`.`CARGO` (`ID_CARGO`)
247 ON DELETE NO ACTION
248 ON UPDATE NO ACTION,
249 CONSTRAINT `ID_SSTT`
250 FOREIGN KEY (`ID_SSTT`)
251 REFERENCES `DB_STA_GAMA`.`SERVICIO_TECNICO` (`ID_SSTT`)
252 ON DELETE NO ACTION
253 ON UPDATE NO ACTION)
254ENGINE = InnoDB;
255
256
257-- -----------------------------------------------------
258-- Table `DB_STA_GAMA`.`USUARIO_CD`
259-- -----------------------------------------------------
260DROP TABLE IF EXISTS `DB_STA_GAMA`.`USUARIO_CD` ;
261
262CREATE TABLE IF NOT EXISTS `DB_STA_GAMA`.`USUARIO_CD` (
263 `ID_CD` INT NOT NULL,
264 `RUT` INT NULL,
265 `ID_CARGO` INT NULL,
266 PRIMARY KEY (`ID_CD`),
267 INDEX `RUT_idx` (`ID_CARGO` ASC),
268 INDEX `RUT_idx1` (`RUT` ASC),
269 CONSTRAINT `ID_CARGO`
270 FOREIGN KEY (`ID_CARGO`)
271 REFERENCES `DB_STA_GAMA`.`CARGO` (`ID_CARGO`)
272 ON DELETE NO ACTION
273 ON UPDATE NO ACTION,
274 CONSTRAINT `RUT`
275 FOREIGN KEY (`RUT`)
276 REFERENCES `DB_STA_GAMA`.`PERSONA` (`RUT`)
277 ON DELETE NO ACTION
278 ON UPDATE NO ACTION,
279 CONSTRAINT `ID_CD`
280 FOREIGN KEY (`ID_CD`)
281 REFERENCES `DB_STA_GAMA`.`CENTRO_DISTRIBUCION` (`ID_CD`)
282 ON DELETE NO ACTION
283 ON UPDATE NO ACTION)
284ENGINE = InnoDB;
285
286
287-- -----------------------------------------------------
288-- Table `DB_STA_GAMA`.`USUARIO_FAB`
289-- -----------------------------------------------------
290DROP TABLE IF EXISTS `DB_STA_GAMA`.`USUARIO_FAB` ;
291
292CREATE TABLE IF NOT EXISTS `DB_STA_GAMA`.`USUARIO_FAB` (
293 `ID_FAB` INT NOT NULL,
294 `RUT` INT NULL,
295 `ID_CARGO` INT NULL,
296 PRIMARY KEY (`ID_FAB`),
297 INDEX `RUT_idx` (`RUT` ASC),
298 INDEX `ID_CARGO_idx` (`ID_CARGO` ASC),
299 CONSTRAINT `RUT`
300 FOREIGN KEY (`RUT`)
301 REFERENCES `DB_STA_GAMA`.`PERSONA` (`RUT`)
302 ON DELETE NO ACTION
303 ON UPDATE NO ACTION,
304 CONSTRAINT `ID_CARGO`
305 FOREIGN KEY (`ID_CARGO`)
306 REFERENCES `DB_STA_GAMA`.`CARGO` (`ID_CARGO`)
307 ON DELETE NO ACTION
308 ON UPDATE NO ACTION,
309 CONSTRAINT `ID_FAB`
310 FOREIGN KEY (`ID_FAB`)
311 REFERENCES `DB_STA_GAMA`.`FABRICA` (`ID_FAB`)
312 ON DELETE NO ACTION
313 ON UPDATE NO ACTION)
314ENGINE = InnoDB;
315
316
317SET SQL_MODE=@OLD_SQL_MODE;
318SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
319SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;