XBuYLdsk

1-- MySQL Script generated by MySQL Workbench
2-- Fri Jan 25 13:21:15 2019
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='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
9
10-- -----------------------------------------------------
11-- Schema mydb
12-- -----------------------------------------------------
13-- -----------------------------------------------------
14-- Schema centro_salud
15-- -----------------------------------------------------
16
17-- -----------------------------------------------------
18-- Schema centro_salud
19-- -----------------------------------------------------
20CREATE SCHEMA IF NOT EXISTS `centro_salud` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
21USE `centro_salud` ;
22
23-- -----------------------------------------------------
24-- Table `centro_salud`.`paciente`
25-- -----------------------------------------------------
26CREATE TABLE IF NOT EXISTS `centro_salud`.`paciente` (
27  `id` INT(11) NOT NULL,
28  `nombre` VARCHAR(255) NOT NULL,
29  `telefono` VARCHAR(9) NOT NULL,
30  `direccion` VARCHAR(255) NOT NULL,
31  `localidad` VARCHAR(255) NOT NULL,
32  PRIMARY KEY (`id`))
33ENGINE = InnoDB
34DEFAULT CHARACTER SET = utf8
35COLLATE = utf8_unicode_ci;
36
37
38-- -----------------------------------------------------
39-- Table `centro_salud`.`especialidad`
40-- -----------------------------------------------------
41CREATE TABLE IF NOT EXISTS `centro_salud`.`especialidad` (
42  `id` INT(11) NOT NULL,
43  `nombre` VARCHAR(255) NOT NULL,
44  PRIMARY KEY (`id`))
45ENGINE = InnoDB
46DEFAULT CHARACTER SET = utf8
47COLLATE = utf8_unicode_ci;
48
49
50-- -----------------------------------------------------
51-- Table `centro_salud`.`especialista`
52-- -----------------------------------------------------
53CREATE TABLE IF NOT EXISTS `centro_salud`.`especialista` (
54  `id` INT(11) NOT NULL,
55  `nombre` VARCHAR(255) NOT NULL,
56  `telefono` VARCHAR(9) NOT NULL,
57  PRIMARY KEY (`id`))
58ENGINE = InnoDB
59DEFAULT CHARACTER SET = utf8
60COLLATE = utf8_unicode_ci;
61
62
63-- -----------------------------------------------------
64-- Table `centro_salud`.`especialista-especialidad`
65-- -----------------------------------------------------
66CREATE TABLE IF NOT EXISTS `centro_salud`.`especialista-especialidad` (
67  `idEspecialista` INT(11) NOT NULL,
68  `idEspecialidad` INT(11) NOT NULL,
69  PRIMARY KEY (`idEspecialista`, `idEspecialidad`),
70  CONSTRAINT `especialista-especialidad_ibfk_1`
71    FOREIGN KEY (`idEspecialidad`)
72    REFERENCES `centro_salud`.`especialidad` (`id`),
73  CONSTRAINT `especialista-especialidad_ibfk_2`
74    FOREIGN KEY (`idEspecialista`)
75    REFERENCES `centro_salud`.`especialista` (`id`))
76ENGINE = InnoDB
77DEFAULT CHARACTER SET = utf8
78COLLATE = utf8_unicode_ci;
79
80
81-- -----------------------------------------------------
82-- Table `centro_salud`.`cita`
83-- -----------------------------------------------------
84CREATE TABLE IF NOT EXISTS `centro_salud`.`cita` (
85  `idPaciente` INT(11) NOT NULL,
86  `idEspecialista` INT(11) NOT NULL,
87  `idEspecialidad` INT(11) NOT NULL,
88  `fechaHora` DATETIME NOT NULL,
89  PRIMARY KEY (`idPaciente`, `idEspecialista`, `idEspecialidad`, `fechaHora`),
90  CONSTRAINT `cita_ibfk_1`
91    FOREIGN KEY (`idPaciente`)
92    REFERENCES `centro_salud`.`paciente` (`id`),
93  CONSTRAINT `fk_cita_especialista-especialidad1`
94    FOREIGN KEY (`idEspecialista` , `idEspecialidad`)
95    REFERENCES `centro_salud`.`especialista-especialidad` (`idEspecialista` , `idEspecialidad`)
96    ON DELETE NO ACTION
97    ON UPDATE NO ACTION)
98ENGINE = InnoDB
99DEFAULT CHARACTER SET = utf8
100COLLATE = utf8_unicode_ci;
101
102
103SET SQL_MODE=@OLD_SQL_MODE;
104SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
105SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;