Advertisement
swalter

Untitled

Oct 31st, 2014
175
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 4.48 KB | None | 0 0
  1. -- MySQL Script generated by MySQL Workbench
  2. -- 10/30/14 15:24:43
  3. -- Model: New Model    Version: 1.0
  4. -- MySQL Workbench Forward Engineering
  5.  
  6. SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
  7. SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
  8. SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
  9.  
  10. -- -----------------------------------------------------
  11. -- Schema ServicioSocial
  12. -- -----------------------------------------------------
  13. -- Base de datos del departamento de Servicio Social
  14.  
  15. -- -----------------------------------------------------
  16. -- Schema ServicioSocial
  17. --
  18. -- Base de datos del departamento de Servicio Social
  19. -- -----------------------------------------------------
  20. CREATE SCHEMA IF NOT EXISTS `ServicioSocial` DEFAULT CHARACTER SET utf8 ;
  21. USE `ServicioSocial` ;
  22.  
  23. -- -----------------------------------------------------
  24. -- Table `ServicioSocial`.`Dependencias`
  25. -- -----------------------------------------------------
  26. CREATE TABLE IF NOT EXISTS `ServicioSocial`.`Dependencias` (
  27.   `Nombre_Dependencia` VARCHAR(80) NOT NULL,
  28.   `Domicilio` VARCHAR(100) NOT NULL,
  29.   `Ciudad` VARCHAR(45) NOT NULL,
  30.   `Cp` CHAR(5) NOT NULL,
  31.   `Responzable` VARCHAR(150) NOT NULL,
  32.   `Telefono` CHAR(10) NULL,
  33.   PRIMARY KEY (`Nombre_Dependencia`))
  34. ENGINE = InnoDB;
  35.  
  36.  
  37. -- -----------------------------------------------------
  38. -- Table `ServicioSocial`.`Auditoria`
  39. -- -----------------------------------------------------
  40. CREATE TABLE IF NOT EXISTS `ServicioSocial`.`Auditoria` (
  41.   `idEvento` INT NOT NULL AUTO_INCREMENT,
  42.   `Accion` VARCHAR(80) NOT NULL,
  43.   `Tabla` VARCHAR(45) NOT NULL,
  44.   `Fecha` TIMESTAMP NOT NULL,
  45.   `Usuario` VARCHAR(150) NOT NULL,
  46.   PRIMARY KEY (`idEvento`))
  47. ENGINE = InnoDB;
  48.  
  49.  
  50. -- -----------------------------------------------------
  51. -- Table `ServicioSocial`.`Alumno`
  52. -- -----------------------------------------------------
  53. CREATE TABLE IF NOT EXISTS `ServicioSocial`.`Alumno` (
  54.   `Num_Control` CHAR(8) NOT NULL,
  55.   `Nombre` VARCHAR(100) NOT NULL,
  56.   `Apellidos` VARCHAR(150) NOT NULL,
  57.   `Edad` CHAR(2) NULL,
  58.   `Sexo` CHAR(1) NULL,
  59.   `Domicilio` VARCHAR(150) NULL,
  60.   `Ciudad` VARCHAR(45) NULL,
  61.   `Estado` VARCHAR(45) NULL,
  62.   `Codigo_Postal` CHAR(5) NULL,
  63.   `Telefono` CHAR(10) NULL,
  64.   `Cuatrimestre` CHAR(2) NULL,
  65.   `Becas` VARCHAR(100) NULL,
  66.   `IdPrograma_Educativo` INT NOT NULL,
  67.   PRIMARY KEY (`Num_Control`))
  68. ENGINE = InnoDB;
  69.  
  70.  
  71. -- -----------------------------------------------------
  72. -- Table `ServicioSocial`.`Programa_Educativo`
  73. -- -----------------------------------------------------
  74. CREATE TABLE IF NOT EXISTS `ServicioSocial`.`Programa_Educativo` (
  75.   `idPrograma_Educativo` INT NOT NULL AUTO_INCREMENT,
  76.   `Nombre` VARCHAR(150) NULL,
  77.   PRIMARY KEY (`idPrograma_Educativo`))
  78. ENGINE = InnoDB;
  79.  
  80.  
  81. -- -----------------------------------------------------
  82. -- Table `ServicioSocial`.`Datos_Programa`
  83. -- -----------------------------------------------------
  84. CREATE TABLE IF NOT EXISTS `ServicioSocial`.`Datos_Programa` (
  85.   `Nombre_Programa` INT NOT NULL,
  86.   `Objetivo` VARCHAR(150) NULL,
  87.   `Area_Asignacion` VARCHAR(100) NOT NULL,
  88.   `Fecha_Inicio` VARCHAR(45) NOT NULL,
  89.   `Fecha_Termino` VARCHAR(45) NOT NULL,
  90.   `Asesor_Academico` VARCHAR(100) NULL,
  91.   `Asesor_Externo` VARCHAR(100) NOT NULL,
  92.   `Numero_Control_Alumno` CHAR(8) NOT NULL,
  93.   `Nombre_Dependencia` VARCHAR(80) NOT NULL,
  94.   INDEX `Alumno_idx` (`Numero_Control_Alumno` ASC),
  95.   INDEX `Dependencia_idx` (`Nombre_Dependencia` ASC),
  96.   CONSTRAINT `Alumno`
  97.     FOREIGN KEY (`Numero_Control_Alumno`)
  98.     REFERENCES `ServicioSocial`.`Alumno` (`Num_Control`)
  99.     ON DELETE CASCADE
  100.     ON UPDATE CASCADE,
  101.   CONSTRAINT `Dependencia`
  102.     FOREIGN KEY (`Nombre_Dependencia`)
  103.     REFERENCES `ServicioSocial`.`Dependencias` (`Nombre_Dependencia`)
  104.     ON DELETE CASCADE
  105.     ON UPDATE CASCADE)
  106. ENGINE = InnoDB;
  107.  
  108.  
  109. -- -----------------------------------------------------
  110. -- Table `ServicioSocial`.`Avances`
  111. -- -----------------------------------------------------
  112. CREATE TABLE IF NOT EXISTS `ServicioSocial`.`Avances` (
  113.   `Descripcion` VARCHAR(100) NOT NULL,
  114.   `Fecha` VARCHAR(45) NOT NULL,
  115.   `Num_Control` CHAR(8) NOT NULL,
  116.   INDEX `Alumno_idx` (`Num_Control` ASC),
  117.   CONSTRAINT `Alumno`
  118.     FOREIGN KEY (`Num_Control`)
  119.     REFERENCES `ServicioSocial`.`Alumno` (`Num_Control`)
  120.     ON DELETE CASCADE
  121.     ON UPDATE CASCADE)
  122. ENGINE = InnoDB;
  123.  
  124.  
  125. SET SQL_MODE=@OLD_SQL_MODE;
  126. SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
  127. SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement