· 8 years ago · Nov 25, 2017, 02:56 PM
1-- MySQL Script generated by MySQL Workbench
2-- Sat Nov 25 11:54:38 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 examen
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema examen
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `examen` DEFAULT CHARACTER SET utf8 ;
18USE `examen` ;
19
20-- -----------------------------------------------------
21-- Table `examen`.`sistemasPlanetarios`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `examen`.`sistemasPlanetarios` (
24 `idSistema` INT NOT NULL,
25 `nombreSistema` VARCHAR(45) NULL,
26 PRIMARY KEY (`idSistema`))
27ENGINE = InnoDB;
28
29
30-- -----------------------------------------------------
31-- Table `examen`.`estrellas`
32-- -----------------------------------------------------
33CREATE TABLE IF NOT EXISTS `examen`.`estrellas` (
34 `idestrellas` INT NOT NULL,
35 `nombreEstrella` VARCHAR(45) NULL,
36 `idSistema` INT NULL,
37 PRIMARY KEY (`idestrellas`),
38 INDEX `a_idx` (`idSistema` ASC),
39 CONSTRAINT `a`
40 FOREIGN KEY (`idSistema`)
41 REFERENCES `examen`.`sistemasPlanetarios` (`idSistema`)
42 ON DELETE NO ACTION
43 ON UPDATE NO ACTION)
44ENGINE = InnoDB;
45
46
47-- -----------------------------------------------------
48-- Table `examen`.`asteroides`
49-- -----------------------------------------------------
50CREATE TABLE IF NOT EXISTS `examen`.`asteroides` (
51 `idAsteroide` INT NOT NULL,
52 `nombreAsteroide` VARCHAR(45) NULL,
53 `idSistema` INT NULL,
54 PRIMARY KEY (`idAsteroide`),
55 INDEX `asteroide_sistema_idx` (`idSistema` ASC),
56 CONSTRAINT `asteroide_sistema`
57 FOREIGN KEY (`idSistema`)
58 REFERENCES `examen`.`sistemasPlanetarios` (`idSistema`)
59 ON DELETE NO ACTION
60 ON UPDATE NO ACTION)
61ENGINE = InnoDB;
62
63
64-- -----------------------------------------------------
65-- Table `examen`.`cometas`
66-- -----------------------------------------------------
67CREATE TABLE IF NOT EXISTS `examen`.`cometas` (
68 `idCometa` INT NOT NULL,
69 `nombreCometa` VARCHAR(45) NULL,
70 `idSistema` INT NULL,
71 PRIMARY KEY (`idCometa`),
72 INDEX `cometa_sistema_idx` (`idSistema` ASC),
73 CONSTRAINT `cometa_sistema`
74 FOREIGN KEY (`idSistema`)
75 REFERENCES `examen`.`sistemasPlanetarios` (`idSistema`)
76 ON DELETE NO ACTION
77 ON UPDATE NO ACTION)
78ENGINE = InnoDB;
79
80
81-- -----------------------------------------------------
82-- Table `examen`.`meteoritos`
83-- -----------------------------------------------------
84CREATE TABLE IF NOT EXISTS `examen`.`meteoritos` (
85 `idMeteorito` INT NOT NULL,
86 `nombreMeteorito` VARCHAR(45) NULL,
87 `idSistema` INT NULL,
88 PRIMARY KEY (`idMeteorito`),
89 INDEX `meteorito_sistema_idx` (`idSistema` ASC),
90 CONSTRAINT `meteorito_sistema`
91 FOREIGN KEY (`idSistema`)
92 REFERENCES `examen`.`sistemasPlanetarios` (`idSistema`)
93 ON DELETE NO ACTION
94 ON UPDATE NO ACTION)
95ENGINE = InnoDB;
96
97
98-- -----------------------------------------------------
99-- Table `examen`.`planetas`
100-- -----------------------------------------------------
101CREATE TABLE IF NOT EXISTS `examen`.`planetas` (
102 `idplaneta` INT NOT NULL,
103 `nombre` VARCHAR(45) NULL,
104 `simbologia` VARCHAR(45) NULL,
105 `diametroEcuatorial` VARCHAR(20) NULL,
106 `masa` VARCHAR(45) NULL,
107 `radioOrbital` VARCHAR(45) NULL,
108 `periodoOrbital` VARCHAR(45) NULL,
109 `periodoRotacion` VARCHAR(45) NULL,
110 `idSistema` INT NULL,
111 PRIMARY KEY (`idplaneta`),
112 INDEX `planetas_Sistemas_idx` (`idSistema` ASC),
113 CONSTRAINT `planetas_Sistemas`
114 FOREIGN KEY (`idSistema`)
115 REFERENCES `examen`.`sistemasPlanetarios` (`idSistema`)
116 ON DELETE NO ACTION
117 ON UPDATE NO ACTION)
118ENGINE = InnoDB;
119
120
121-- -----------------------------------------------------
122-- Table `examen`.`planetasEnanos`
123-- -----------------------------------------------------
124CREATE TABLE IF NOT EXISTS `examen`.`planetasEnanos` (
125 `idplaneta` INT NOT NULL,
126 `nombre` VARCHAR(45) NULL,
127 `simbologia` VARCHAR(45) NULL,
128 `diametroEcuatorial` VARCHAR(20) NULL,
129 `masa` VARCHAR(45) NULL,
130 `radioOrbital` VARCHAR(45) NULL,
131 `periodoOrbital` VARCHAR(45) NULL,
132 `periodoRotacion` VARCHAR(45) NULL,
133 `idSistema` INT NULL,
134 PRIMARY KEY (`idplaneta`),
135 INDEX `planetasEnanos_sistema_idx` (`idSistema` ASC),
136 CONSTRAINT `planetasEnanos_sistema`
137 FOREIGN KEY (`idSistema`)
138 REFERENCES `examen`.`sistemasPlanetarios` (`idSistema`)
139 ON DELETE NO ACTION
140 ON UPDATE NO ACTION)
141ENGINE = InnoDB;
142
143
144SET SQL_MODE=@OLD_SQL_MODE;
145SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
146SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;