[mysql] recintos
Viewer
- CREATE DATABASE IF NOT EXISTS `recintos` /*!40100 DEFAULT CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish_ci */;
- USE `recintos`;
- -- Table structure for table `horarios`
- DROP TABLE IF EXISTS `horarios`;
- CREATE TABLE `horarios` (
- `ID_HORARIO` int NOT NULL AUTO_INCREMENT,
- `ID_TARIFA` int NOT NULL,
- `ID_RECINTO` int NOT NULL,
- `FECHA_HORARIO` date NOT NULL,
- `HORA_INICIO` time NOT NULL,
- `HORA_FIN` time NOT NULL,
- `ESTADO_HORARIO` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish_ci NOT NULL,
- PRIMARY KEY (`ID_HORARIO`),
- KEY `FK_HORARIOS_RECINTO` (`ID_RECINTO`),
- KEY `FK_HORARIOS_TARIFA` (`ID_TARIFA`),
- CONSTRAINT `FK_HORARIOS_RECINTO` FOREIGN KEY (`ID_RECINTO`) REFERENCES `recintos` (`ID_RECINTO`) ON DELETE RESTRICT ON UPDATE RESTRICT,
- CONSTRAINT `FK_HORARIOS_TARIFA` FOREIGN KEY (`ID_TARIFA`) REFERENCES `tarifas` (`ID_TARIFA`) ON DELETE RESTRICT ON UPDATE RESTRICT
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish_ci;
- -- Table structure for table `recintos`
- DROP TABLE IF EXISTS `recintos`;
- CREATE TABLE `recintos` (
- `ID_RECINTO` int NOT NULL AUTO_INCREMENT,
- `NOMBRE_RECINTO` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish_ci NOT NULL,
- `COMUNA` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish_ci NOT NULL,
- `DIRECCION` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish_ci NOT NULL,
- `ESTADO_RECINTO` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish_ci NOT NULL,
- PRIMARY KEY (`ID_RECINTO`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish_ci;
- -- Table structure for table `registro_cambios_reserva`
- DROP TABLE IF EXISTS `registro_cambios_reserva`;
- CREATE TABLE `registro_cambios_reserva` (
- `ID_CAMBIO` int NOT NULL AUTO_INCREMENT,
- `ID_RESERVA` int NOT NULL,
- `CAMPO_MODIFICADO` varchar(50) COLLATE utf8mb3_spanish_ci NOT NULL,
- `VALOR_ANTERIOR` text COLLATE utf8mb3_spanish_ci,
- `VALOR_NUEVO` text COLLATE utf8mb3_spanish_ci,
- `FECHA_CAMBIO` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
- PRIMARY KEY (`ID_CAMBIO`),
- KEY `ID_RESERVA` (`ID_RESERVA`),
- CONSTRAINT `FK_RESERVA_CAMBIO` FOREIGN KEY (`ID_RESERVA`) REFERENCES `reserva` (`ID_RESERVA`) ON DELETE CASCADE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish_ci;
- -- Table structure for table `reserva`
- DROP TABLE IF EXISTS `reserva`;
- CREATE TABLE `reserva` (
- `ID_RESERVA` int NOT NULL AUTO_INCREMENT,
- `ID_USUARIO` varchar(12) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish_ci NOT NULL,
- `ESTADO_RESERVA` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish_ci NOT NULL,
- `ID_HORARIO` int NOT NULL,
- `ESTADO_PAGO` varchar(45) COLLATE utf8mb3_spanish_ci NOT NULL,
- PRIMARY KEY (`ID_RESERVA`),
- KEY `FK_USUARIOS_RESERVA` (`ID_USUARIO`),
- KEY `FK_HORARIO_RESERVA` (`ID_HORARIO`),
- CONSTRAINT `FK_USUARIOS_RESERVA` FOREIGN KEY (`ID_USUARIO`) REFERENCES `usuarios` (`ID_USUARIO`) ON DELETE RESTRICT ON UPDATE RESTRICT,
- CONSTRAINT `FK_HORARIO_RESERVA` FOREIGN KEY (`ID_HORARIO`) REFERENCES `horarios` (`ID_HORARIO`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish_ci;
- -- Table structure for table `tarifas`
- DROP TABLE IF EXISTS `tarifas`;
- CREATE TABLE `tarifas` (
- `ID_TARIFA` int NOT NULL AUTO_INCREMENT,
- `NOMBRE_TARIFA` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish_ci NOT NULL,
- `PRECIO` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish_ci NOT NULL,
- PRIMARY KEY (`ID_TARIFA`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish_ci;
- -- Table structure for table `usuarios`
- DROP TABLE IF EXISTS `usuarios`;
- CREATE TABLE `usuarios` (
- `ID_USUARIO` varchar(12) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish_ci NOT NULL,
- `NOMBRE_USUARIO` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish_ci NOT NULL,
- `APELLIDO` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish_ci NOT NULL,
- `MAIL` varchar(60) CHARACTER SET utf8mb3 COLLATE utf8mb3_spanish_ci NOT NULL,
- `TELEFONO` decimal(9,0) NOT NULL,
- PRIMARY KEY (`ID_USUARIO`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_spanish_ci;
- Cambia a utf8 COLLATE=utf8_spanish_ci;
Editor
You can edit this paste and save as new:
File Description
- recintos
- Paste Code
- 09 May-2024
- 4.08 Kb
You can Share it:
Latest Code Pastes