Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- MySQL Script generated by MySQL Workbench
- -- 10/30/14 15:24:43
- -- 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='TRADITIONAL,ALLOW_INVALID_DATES';
- -- -----------------------------------------------------
- -- Schema ServicioSocial
- -- -----------------------------------------------------
- -- Base de datos del departamento de Servicio Social
- -- -----------------------------------------------------
- -- Schema ServicioSocial
- --
- -- Base de datos del departamento de Servicio Social
- -- -----------------------------------------------------
- CREATE SCHEMA IF NOT EXISTS `ServicioSocial` DEFAULT CHARACTER SET utf8 ;
- USE `ServicioSocial` ;
- -- -----------------------------------------------------
- -- Table `ServicioSocial`.`Dependencias`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `ServicioSocial`.`Dependencias` (
- `Nombre_Dependencia` VARCHAR(80) NOT NULL,
- `Domicilio` VARCHAR(100) NOT NULL,
- `Ciudad` VARCHAR(45) NOT NULL,
- `Cp` CHAR(5) NOT NULL,
- `Responzable` VARCHAR(150) NOT NULL,
- `Telefono` CHAR(10) NULL,
- PRIMARY KEY (`Nombre_Dependencia`))
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `ServicioSocial`.`Auditoria`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `ServicioSocial`.`Auditoria` (
- `idEvento` INT NOT NULL AUTO_INCREMENT,
- `Accion` VARCHAR(80) NOT NULL,
- `Tabla` VARCHAR(45) NOT NULL,
- `Fecha` TIMESTAMP NOT NULL,
- `Usuario` VARCHAR(150) NOT NULL,
- PRIMARY KEY (`idEvento`))
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `ServicioSocial`.`Alumno`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `ServicioSocial`.`Alumno` (
- `Num_Control` CHAR(8) NOT NULL,
- `Nombre` VARCHAR(100) NOT NULL,
- `Apellidos` VARCHAR(150) NOT NULL,
- `Edad` CHAR(2) NULL,
- `Sexo` CHAR(1) NULL,
- `Domicilio` VARCHAR(150) NULL,
- `Ciudad` VARCHAR(45) NULL,
- `Estado` VARCHAR(45) NULL,
- `Codigo_Postal` CHAR(5) NULL,
- `Telefono` CHAR(10) NULL,
- `Cuatrimestre` CHAR(2) NULL,
- `Becas` VARCHAR(100) NULL,
- `IdPrograma_Educativo` INT NOT NULL,
- PRIMARY KEY (`Num_Control`))
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `ServicioSocial`.`Programa_Educativo`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `ServicioSocial`.`Programa_Educativo` (
- `idPrograma_Educativo` INT NOT NULL AUTO_INCREMENT,
- `Nombre` VARCHAR(150) NULL,
- PRIMARY KEY (`idPrograma_Educativo`))
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `ServicioSocial`.`Datos_Programa`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `ServicioSocial`.`Datos_Programa` (
- `Nombre_Programa` INT NOT NULL,
- `Objetivo` VARCHAR(150) NULL,
- `Area_Asignacion` VARCHAR(100) NOT NULL,
- `Fecha_Inicio` VARCHAR(45) NOT NULL,
- `Fecha_Termino` VARCHAR(45) NOT NULL,
- `Asesor_Academico` VARCHAR(100) NULL,
- `Asesor_Externo` VARCHAR(100) NOT NULL,
- `Numero_Control_Alumno` CHAR(8) NOT NULL,
- `Nombre_Dependencia` VARCHAR(80) NOT NULL,
- INDEX `Alumno_idx` (`Numero_Control_Alumno` ASC),
- INDEX `Dependencia_idx` (`Nombre_Dependencia` ASC),
- CONSTRAINT `Alumno`
- FOREIGN KEY (`Numero_Control_Alumno`)
- REFERENCES `ServicioSocial`.`Alumno` (`Num_Control`)
- ON DELETE CASCADE
- ON UPDATE CASCADE,
- CONSTRAINT `Dependencia`
- FOREIGN KEY (`Nombre_Dependencia`)
- REFERENCES `ServicioSocial`.`Dependencias` (`Nombre_Dependencia`)
- ON DELETE CASCADE
- ON UPDATE CASCADE)
- ENGINE = InnoDB;
- -- -----------------------------------------------------
- -- Table `ServicioSocial`.`Avances`
- -- -----------------------------------------------------
- CREATE TABLE IF NOT EXISTS `ServicioSocial`.`Avances` (
- `Descripcion` VARCHAR(100) NOT NULL,
- `Fecha` VARCHAR(45) NOT NULL,
- `Num_Control` CHAR(8) NOT NULL,
- INDEX `Alumno_idx` (`Num_Control` ASC),
- CONSTRAINT `Alumno`
- FOREIGN KEY (`Num_Control`)
- REFERENCES `ServicioSocial`.`Alumno` (`Num_Control`)
- ON DELETE CASCADE
- ON UPDATE CASCADE)
- 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