-- ----------------------------------------------------------------------
-- MySQL GRT Application
-- SQL Script
-- ----------------------------------------------------------------------
SET FOREIGN_KEY_CHECKS = 0;
CREATE DATABASE IF NOT EXISTS `teleasistencia`
CHARACTER SET latin1;
-- -------------------------------------
-- Tables
DROP TABLE IF EXISTS `teleasistencia`.`ambulancias`;
CREATE TABLE `teleasistencia`.`ambulancias` (
`codigo` INT(10) unsigned NOT NULL AUTO_INCREMENT,
`MSISDN` BIGINT(20) unsigned NOT NULL,
PRIMARY KEY (`codigo`)
)
ENGINE = InnoDB
ROW_FORMAT = Compact
CHARACTER SET latin1 COLLATE latin1_swedish_ci;
DROP TABLE IF EXISTS `teleasistencia`.`cuidadores`;
CREATE TABLE `teleasistencia`.`cuidadores` (
`id_cuidador` INT(8) unsigned NOT NULL,
`MSISDN` BIGINT(20) unsigned NOT NULL,
`nombre` VARCHAR(20) NOT NULL,
`apellido1` VARCHAR(20) NOT NULL,
`apellido2` VARCHAR(20) NOT NULL,
PRIMARY KEY (`id_cuidador`)
)
ENGINE = InnoDB
ROW_FORMAT = Compact
CHARACTER SET latin1 COLLATE latin1_swedish_ci;
DROP TABLE IF EXISTS `teleasistencia`.`estadopacloc`;
CREATE TABLE `teleasistencia`.`estadopacloc` (
`MSISDN` BIGINT(20) unsigned NOT NULL,
`estadoLoc` INT(10) unsigned NOT NULL,
PRIMARY KEY (`MSISDN`)
)
ENGINE = InnoDB
ROW_FORMAT = Compact
CHARACTER SET latin1 COLLATE latin1_swedish_ci;
DROP TABLE IF EXISTS `teleasistencia`.`pacientes`;
CREATE TABLE `teleasistencia`.`pacientes` (
`id_paciente` INT(8) unsigned NOT NULL,
`MSISDN` BIGINT(20) unsigned NOT NULL,
`nombre` VARCHAR(20) NOT NULL,
`apellido1` VARCHAR(20) NOT NULL,
`apellido2` VARCHAR(20) NOT NULL,
`id_cuidador` INT(8) unsigned NOT NULL,
`longitud` DOUBLE(, ) NULL,
`latitud` DOUBLE(, ) NULL,
PRIMARY KEY (`id_paciente`),
INDEX `FK_cuidadores` (`id_cuidador`),
CONSTRAINT `FK_cuidadores` FOREIGN KEY `FK_cuidadores` (`id_cuidador`)
REFERENCES `teleasistencia`.`cuidadores` (`id_cuidador`)
ON DELETE RESTRICT
ON UPDATE RESTRICT
)
ENGINE = InnoDB
ROW_FORMAT = Compact
CHARACTER SET latin1 COLLATE latin1_swedish_ci;
DROP TABLE IF EXISTS `teleasistencia`.`servicios_contratados`;
CREATE TABLE `teleasistencia`.`servicios_contratados` (
`codigo` INT(10) unsigned NOT NULL AUTO_INCREMENT,
`id_paciente` INT(8) unsigned NOT NULL,
`cod_alarma` INT(3) unsigned NOT NULL,
PRIMARY KEY (`codigo`),
INDEX `FK_servicios_contratados_1` (`id_paciente`),
CONSTRAINT `FK_servicios_contratados_1` FOREIGN KEY `FK_servicios_contratados_1` (`id_paciente`)
REFERENCES `teleasistencia`.`pacientes` (`id_paciente`)
ON DELETE RESTRICT
ON UPDATE RESTRICT
)
ENGINE = InnoDB
ROW_FORMAT = Compact
CHARACTER SET latin1 COLLATE latin1_swedish_ci;
SET FOREIGN_KEY_CHECKS = 1;
-- ----------------------------------------------------------------------
-- EOF
e-REdING. Biblioteca de la Escuela Superior de Ingenieros de Sevilla.
