· 3 years ago · Feb 24, 2022, 03:30 AM
1-- MySQL Script generated by MySQL Workbench
2-- Wed Feb 23 21:27:17 2022
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-- -----------------------------------------------------
15-- Schema mydb
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
18USE `mydb` ;
19
20-- -----------------------------------------------------
21-- Table `mydb`.`TAdministrador`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`TAdministrador` (
24 `idTAdministrador` INT NOT NULL AUTO_INCREMENT,
25 `usuario` VARCHAR(45) NULL,
26 `password` VARCHAR(45) NULL,
27 PRIMARY KEY (`idTAdministrador`))
28ENGINE = InnoDB;
29
30
31-- -----------------------------------------------------
32-- Table `mydb`.`THistorial`
33-- -----------------------------------------------------
34CREATE TABLE IF NOT EXISTS `mydb`.`THistorial` (
35 `idTPerfil` INT NOT NULL AUTO_INCREMENT,
36 `agenda` VARCHAR(45) NULL,
37 `planalimenticio` VARCHAR(45) NULL,
38 `citasprevias` VARCHAR(45) NULL,
39 PRIMARY KEY (`idTPerfil`))
40ENGINE = InnoDB;
41
42
43-- -----------------------------------------------------
44-- Table `mydb`.`TInfoPaciente`
45-- -----------------------------------------------------
46CREATE TABLE IF NOT EXISTS `mydb`.`TInfoPaciente` (
47 `idTInfoPaciente` INT NOT NULL AUTO_INCREMENT,
48 `nombre` VARCHAR(45) NULL,
49 `edad` VARCHAR(45) NULL,
50 `peso` VARCHAR(45) NULL,
51 `alergias` VARCHAR(45) NULL,
52 `enfermedadcronica` VARCHAR(45) NULL,
53 `telefono` VARCHAR(45) NULL,
54 `THistorial_idTPerfil` INT NOT NULL,
55 PRIMARY KEY (`idTInfoPaciente`),
56 INDEX `fk_TInfoPaciente_THistorial1_idx` (`THistorial_idTPerfil` ASC) VISIBLE,
57 CONSTRAINT `fk_TInfoPaciente_THistorial1`
58 FOREIGN KEY (`THistorial_idTPerfil`)
59 REFERENCES `mydb`.`THistorial` (`idTPerfil`)
60 ON DELETE NO ACTION
61 ON UPDATE NO ACTION)
62ENGINE = InnoDB;
63
64
65-- -----------------------------------------------------
66-- Table `mydb`.`TPaciente`
67-- -----------------------------------------------------
68CREATE TABLE IF NOT EXISTS `mydb`.`TPaciente` (
69 `idTPaciente` INT NOT NULL AUTO_INCREMENT,
70 `usuario` VARCHAR(45) NULL,
71 `password` VARCHAR(45) NULL,
72 `TInfoPaciente_idTInfoPaciente` INT NOT NULL,
73 PRIMARY KEY (`idTPaciente`),
74 INDEX `fk_TPaciente_TInfoPaciente_idx` (`TInfoPaciente_idTInfoPaciente` ASC) VISIBLE,
75 CONSTRAINT `fk_TPaciente_TInfoPaciente`
76 FOREIGN KEY (`TInfoPaciente_idTInfoPaciente`)
77 REFERENCES `mydb`.`TInfoPaciente` (`idTInfoPaciente`)
78 ON DELETE NO ACTION
79 ON UPDATE NO ACTION)
80ENGINE = InnoDB;
81
82
83-- -----------------------------------------------------
84-- Table `mydb`.`TAgenda`
85-- -----------------------------------------------------
86CREATE TABLE IF NOT EXISTS `mydb`.`TAgenda` (
87 `idTAgenda` INT NOT NULL AUTO_INCREMENT,
88 `mes` INT NULL,
89 `dia` INT NULL,
90 `hora` INT NULL,
91 `THistorial_idTPerfil` INT NOT NULL,
92 `estatus` VARCHAR(45) NULL,
93 PRIMARY KEY (`idTAgenda`),
94 INDEX `fk_TAgenda_THistorial1_idx` (`THistorial_idTPerfil` ASC) VISIBLE,
95 CONSTRAINT `fk_TAgenda_THistorial1`
96 FOREIGN KEY (`THistorial_idTPerfil`)
97 REFERENCES `mydb`.`THistorial` (`idTPerfil`)
98 ON DELETE NO ACTION
99 ON UPDATE NO ACTION)
100ENGINE = InnoDB;
101
102
103-- -----------------------------------------------------
104-- Table `mydb`.`TPlanAlimenticio`
105-- -----------------------------------------------------
106CREATE TABLE IF NOT EXISTS `mydb`.`TPlanAlimenticio` (
107 `idTPlanAlimenticio` INT NOT NULL AUTO_INCREMENT,
108 `fecha` VARCHAR(45) NULL,
109 `plan` MEDIUMTEXT NULL,
110 `THistorial_idTPerfil` INT NOT NULL,
111 PRIMARY KEY (`idTPlanAlimenticio`),
112 INDEX `fk_TPlanAlimenticio_THistorial1_idx` (`THistorial_idTPerfil` ASC) VISIBLE,
113 CONSTRAINT `fk_TPlanAlimenticio_THistorial1`
114 FOREIGN KEY (`THistorial_idTPerfil`)
115 REFERENCES `mydb`.`THistorial` (`idTPerfil`)
116 ON DELETE NO ACTION
117 ON UPDATE NO ACTION)
118ENGINE = InnoDB;
119
120
121-- -----------------------------------------------------
122-- Table `mydb`.`TCitasPrevias`
123-- -----------------------------------------------------
124CREATE TABLE IF NOT EXISTS `mydb`.`TCitasPrevias` (
125 `idTCitasPrevias` INT NOT NULL AUTO_INCREMENT,
126 `mes` INT NULL,
127 `dia` INT NULL,
128 `hora` INT NULL,
129 `THistorial_idTPerfil` INT NOT NULL,
130 `TAgenda_idTAgenda` INT NOT NULL,
131 PRIMARY KEY (`idTCitasPrevias`),
132 INDEX `fk_TCitasPrevias_THistorial1_idx` (`THistorial_idTPerfil` ASC) VISIBLE,
133 INDEX `fk_TCitasPrevias_TAgenda1_idx` (`TAgenda_idTAgenda` ASC) VISIBLE,
134 CONSTRAINT `fk_TCitasPrevias_THistorial1`
135 FOREIGN KEY (`THistorial_idTPerfil`)
136 REFERENCES `mydb`.`THistorial` (`idTPerfil`)
137 ON DELETE NO ACTION
138 ON UPDATE NO ACTION,
139 CONSTRAINT `fk_TCitasPrevias_TAgenda1`
140 FOREIGN KEY (`TAgenda_idTAgenda`)
141 REFERENCES `mydb`.`TAgenda` (`idTAgenda`)
142 ON DELETE NO ACTION
143 ON UPDATE NO ACTION)
144ENGINE = InnoDB;
145
146
147-- -----------------------------------------------------
148-- Table `mydb`.`TServicios`
149-- -----------------------------------------------------
150CREATE TABLE IF NOT EXISTS `mydb`.`TServicios` (
151 `idTServicios` INT NOT NULL AUTO_INCREMENT,
152 `nombre` VARCHAR(45) NULL,
153 `precio` INT NULL,
154 PRIMARY KEY (`idTServicios`))
155ENGINE = InnoDB;
156
157
158-- -----------------------------------------------------
159-- Table `mydb`.`TContacto`
160-- -----------------------------------------------------
161CREATE TABLE IF NOT EXISTS `mydb`.`TContacto` (
162 `idTContacto` INT NOT NULL AUTO_INCREMENT,
163 `telefono` VARCHAR(45) NULL,
164 `correo` VARCHAR(45) NULL,
165 PRIMARY KEY (`idTContacto`))
166ENGINE = InnoDB;
167
168
169SET SQL_MODE=@OLD_SQL_MODE;
170SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
171SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
172