Oct 07, 2023, 07:41 PM
Site: innovahealthy.co
Rows : 114575
Field:
CREATE TABLE `listaespera` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`llamada1` timestamp NULL DEFAULT NULL,
`llamada2` timestamp NULL DEFAULT NULL,
`llamada3` timestamp NULL DEFAULT NULL,
`tipodoc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`doc` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`paciente` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`celular1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`celular2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`fijo1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`servicio` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`convenio` int(11) NOT NULL DEFAULT -1,
`autorizacion` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`fechaautorizacion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`estado` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT 'SIN AGENDA',
`observacion` varchar(3000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`usuario` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`Sede` int(11) NOT NULL DEFAULT -1,
`observaciones` varchar(3000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`Observacion2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`Observacion3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`municipio` int(11) NULL DEFAULT 1,
`cups` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`fechanacimiento` date NULL DEFAULT NULL,
`email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`archivo` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`eps` int(11) NULL DEFAULT NULL,
`troncal` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `listaespera_UN`(`doc`, `servicio`, `convenio`, `autorizacion`, `estado`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 388060 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
Sample:
INSERT INTO `listaespera` VALUES (283123, '2022-01-27 11:49:40', '2022-02-01 13:01:57', '2022-02-04 10:30:22', 'CC', '1095937285', 'MAYRA FERNANDA PARADA ALVAREZ', '3165620643', '', '', 'NEUROLOGIA (Consulta de Primera Vez)', 12, 'PREAUTORIZADO', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 16:49:40', '2023-09-27 07:11:07', 'ERIKA YAJAIRA SANCHEZ VARGAS', 4, '[email protected] SOLICITA CITA URGENTE // LLAMA NUEVAMENTE 01/02/2022// LLAMA NUEAMENTE 04/02/2022// LLAMA NUEVAMENTE 07/02/2022// LLAMA NUEVAMENTE 09/02/2022// LLAMA NUEVAMENTE 14/02/2022// PACIENTE SIN MEDICACION BASTANTE ENFERMA/ BASTANTE MOLESTA.', 'CC', NULL, 118, '890274', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283124, '2022-01-27 11:51:49', '2022-04-16 11:53:46', NULL, 'CC', '21179345', 'FLOR MARIA REYES', '3214263127', '', '', 'MEDICINA INTERNA (Consulta de Primera Vez)', 19, '', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 16:51:49', '2022-04-22 11:02:41', 'ALEJANDRA SILVA', 4, 'PRESENCIAL', 'CC', NULL, 8, '890266', NULL, NULL, NULL, 2, NULL);
INSERT INTO `listaespera` VALUES (283125, '2022-01-27 11:54:55', '2022-02-08 08:44:16', '2022-05-12 15:22:10', 'TI', '1097122271', 'JORGE LUIS RIVERA', '3135073174', '', '', 'NUTRICION Y DIETETICA (Consulta de Primera Vez)', 8, '', 'Invalid date', 'SIN AGENDA', NULL, '2022-01-27 16:54:55', '2022-05-12 15:22:10', 'ALEJANDRA SILVA', 4, 'NO CONTESTAN 08/02/2022 \n\nLLAMA 12/05/2022', 'CC', NULL, 8, '890206', NULL, NULL, NULL, 4, NULL);
INSERT INTO `listaespera` VALUES (283126, '2022-01-27 11:56:34', NULL, NULL, 'CC', '28468666', 'EUMELINA BARON DE MOSQUERA', '3152796767', '', '', 'MEDICINA FISICA Y REHABILITACION (Consulta de Primera Vez)', 12, '', '27/01/2022', 'AGENDADA', NULL, '2022-01-27 16:56:34', '2022-07-14 11:40:19', 'MARTHA VILLAMIZAR VILLAMIZAR', 4, '', 'CC', NULL, 118, '890264', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283127, '2022-01-27 11:58:23', NULL, NULL, 'CC', '13834000', 'JOSE VICENTE BUENO CALDERON', '3134671545', '3042132948', '', 'OTORRINOLARINGOLOGIA (Consulta de Primera Vez)', 12, '', '27/01/2022', 'AGENDADA', NULL, '2022-01-27 16:58:23', '2022-02-17 16:17:20', 'LILIANA QUIROGA CRISTANCHO', 4, '', 'CC', NULL, 118, '890282', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283128, '2022-01-27 12:04:51', NULL, NULL, 'CC', '37822980', 'AURA SANETH MEJIA MERCHAN', '3125903125', '3138068100', '', 'ECOGRAFIA DE MAMA, CON TRANSDUCTOR DE 7 MHZ O MAS', 8, '290561', '27/01/2022', 'AGENDADA', NULL, '2022-01-27 17:04:51', '2022-07-14 11:55:04', 'LILIANA QUIROGA CRISTANCHO', 4, '', 'CC', NULL, 118, '881201', NULL, NULL, NULL, 4, NULL);
INSERT INTO `listaespera` VALUES (283129, '2022-01-27 12:05:02', NULL, NULL, 'RC', '1095846750', 'ERICH DANIEL CRIOLLO ALVARADO', '3185340571', '3185527480', '', 'RADIOGRAFIA DE CADERA COMPARATIVA', 8, '', '', 'AGENDADA', NULL, '2022-01-27 17:05:02', '2022-11-27 22:19:59', 'ERIKA YAJAIRA SANCHEZ VARGAS', 4, '', 'CC', NULL, 118, '873412', NULL, NULL, NULL, 4, NULL);
INSERT INTO `listaespera` VALUES (283130, '2022-01-27 12:07:08', NULL, NULL, 'CC', '13360392', 'ORLANDO CARRASCAL ZORRILLA', '3165725594', '3112498390', '', 'ESOFAGOGASTRODUODENOSCOPIA [EGD] CON BIOPSIA CERRADA SOD', 17, '', '', 'AGENDADA', NULL, '2022-01-27 17:07:08', '2022-07-14 11:40:19', 'KAREN ORTEGA', 1, '', 'CC', NULL, 612, '451600', NULL, NULL, NULL, 4, NULL);
INSERT INTO `listaespera` VALUES (283131, '2022-01-27 12:07:49', NULL, NULL, 'CC', '1149436516', 'DORIS ESTHER GALVAN', '3126798329', '', '', 'MEDICINA GENERAL (Consulta de Primera Vez)', 1, '', '', 'AGENDADA', NULL, '2022-01-27 17:07:49', '2022-04-22 11:02:41', 'SAIDY MELO', 4, '', 'CC', NULL, 118, '890201', NULL, NULL, NULL, 0, NULL);
INSERT INTO `listaespera` VALUES (283132, '2022-01-27 12:25:38', '2022-02-01 10:15:54', NULL, 'CC', '1065882994', 'CONSTANZA AVILA HERNANDEZ', '3167306178', '3168393144', '', 'MEDICINA FISICA Y REHABILITACION (Consulta de Primera Vez)', 14, '', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 17:25:38', '2022-07-14 11:55:01', 'ROSA HAYDEE LEON ABREU', 1, 'EN LOS POSIBLE EL DIA 08/01/2022 TIENE OTREA CONSULTA ', 'CC', NULL, 1, '890264', NULL, NULL, NULL, 4, NULL);
INSERT INTO `listaespera` VALUES (283133, '2022-01-27 12:28:43', NULL, NULL, 'CC', '13817245', 'AGUSTIN FLOREZ MENDEZ', '3506322012', '3167115151', NULL, 'NEUROLOGIA (Consulta de Primera Vez)', 12, '', '27/01/2022', 'AGENDADA', NULL, '2022-01-27 17:28:43', '2022-07-14 11:55:01', 'LILIANA QUIROGA CRISTANCHO', 4, '', 'CC', NULL, 118, '890274', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283134, '2022-01-27 12:32:23', '2022-02-02 08:42:22', '2022-02-16 11:57:19', 'PEP', '108296122121954', 'ALEX ENRIQUE PINO VILLALOBOS', '3028455358', '3106093992', '', 'MEDICINA INTERNA (Consulta de Control)', 7, '', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 17:32:23', '2022-02-21 15:11:51', 'ERIKA YAJAIRA SANCHEZ VARGAS', 4, 'se vuelve a comunicar 2/02/2022\nSE VUELVE A COMUNICAR 16/02\nLLAMA 21/02/2022\n', 'CC', NULL, 118, '890366', NULL, NULL, NULL, 9, NULL);
INSERT INTO `listaespera` VALUES (283135, '2022-01-27 12:34:38', NULL, NULL, 'CC', '13840361', 'EXPEDITO RODRIGUEZ CASTILLO', '3204390087', '', '6907006', 'CIRUGIA GENERAL (Consulta de Control)', 12, '', '27/01/2022', 'AGENDADA', NULL, '2022-01-27 17:34:38', '2022-07-14 11:40:19', 'LILIANA QUIROGA CRISTANCHO', 4, 'DRA AMELIA QUIERE CON ELLA', 'CC', NULL, 118, '890335', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283136, '2022-01-27 12:41:16', NULL, NULL, 'CC', '91274623', 'ARNULFO JIMENEZ ORTIZ', '3175731009', '', '', 'OTORRINOLARINGOLOGIA (Consulta de Primera Vez)', 12, '', '', 'AGENDADA', NULL, '2022-01-27 17:41:16', '2022-07-14 11:54:59', 'MARYELI MENESES IBAÑEZ', 4, '', 'CC', NULL, 118, '890282', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283137, '2022-01-27 12:41:51', NULL, NULL, 'CC', '13839132 ', 'ALVARO BLANCO SANCHEZ', '3156349658', '', '', 'GASTROENTEROLOGIA (Consulta de Primera Vez)', 12, '', '27/01/2022', 'AGENDADA', NULL, '2022-01-27 17:41:51', '2022-07-14 11:40:19', 'LILIANA QUIROGA CRISTANCHO', 4, '', 'CC', NULL, 118, '890246', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283138, '2022-01-27 12:42:22', NULL, NULL, 'CC', '63280007', 'OLINDA AFANADOR DE VARGAS', '3184725980', '3123589428', '', 'MONITOREO AMBULATORIO DE PRESION ARTERIAL SISTEMICA', 8, '', '', 'AGENDADA', NULL, '2022-01-27 17:42:22', '2022-06-03 09:14:39', 'ERIKA YAJAIRA SANCHEZ VARGAS', 4, '', 'CC', NULL, 118, '895004', NULL, NULL, NULL, 4, NULL);
INSERT INTO `listaespera` VALUES (283139, '2022-01-27 12:42:48', '2022-02-07 11:39:37', '2022-03-02 07:32:18', 'CC', '37893196', 'ROSALBA CABANILLA GOMEZ', '3002443415', '3168674455', '', 'OTORRINOLARINGOLOGIA (Consulta de Primera Vez)', 12, '32805-2200242553', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 17:42:48', '2022-07-14 11:40:19', 'MARYELI MENESES IBAÑEZ', 4, 'OTORRINO.', 'CC', NULL, 118, '890282', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283140, '2022-01-27 12:46:46', NULL, NULL, 'CC', '26766559', 'MARGOT SANCHEZ CARDOZO', '3163931668', '3178871804', '', 'ECOGRAFIA DE MAMA, CON TRANSDUCTOR DE 7 MHZ O MAS', 8, '', '', 'AGENDADA', NULL, '2022-01-27 17:46:46', '2022-11-27 22:19:52', 'ERIKA YAJAIRA SANCHEZ VARGAS', 4, '', 'CC', NULL, 118, '881201', NULL, NULL, NULL, 4, NULL);
INSERT INTO `listaespera` VALUES (283141, '2022-01-27 12:47:18', NULL, NULL, 'CC', '1098665437', 'DEYSI PAOLA GUERRERO VANEGAS', '3172687007', '3155143003', '', 'OTORRINOLARINGOLOGIA (Consulta de Primera Vez)', 12, '', '27/01/2022', 'AGENDADA', NULL, '2022-01-27 17:47:18', '2022-07-14 11:55:03', 'LILIANA QUIROGA CRISTANCHO', 4, '', 'CC', NULL, 118, '890282', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283142, '2022-01-27 12:48:24', '2022-02-15 17:22:05', '2022-02-17 11:00:55', 'CC', '13241185', 'JUAN NEPOMUCENO BLANCO SEQUERA', '3124236576', '', '', 'NEUROLOGIA (Consulta de Control)', 12, '', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 17:48:24', '2023-05-18 19:25:46', 'MARYELI MENESES IBAÑEZ', 4, 'SE VUELVE A COMUNICAR 15/02\nSE VUELVE A COMUNICAR 17/02', 'CC', NULL, 118, '890374', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283143, '2022-01-27 12:51:07', '2022-01-31 09:51:41', NULL, 'CC', '28209723', 'ANA (ANITA) HERNANDEZ', '3175459310', '3156800688', '', 'MEDICINA INTERNA (Consulta de Primera Vez)', 8, '', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 17:51:07', '2022-07-14 11:55:03', 'LILIANA QUIROGA CRISTANCHO', 4, 'LLAMA 31/01/2022\n', 'CC', NULL, 118, '890266', NULL, NULL, NULL, 4, NULL);
INSERT INTO `listaespera` VALUES (283144, '2022-01-27 12:52:59', NULL, NULL, 'CC', '5739052', 'CARLOS JULIO MEJIA ZARATE', '3204859490', '', '', 'UROLOGIA (Consulta de Primera Vez)', 12, '', '', 'AGENDADA', NULL, '2022-01-27 17:52:59', '2022-06-03 09:14:20', 'MARYELI MENESES IBAÑEZ', 4, 'presenta discapcidad vive en la provincia de velez // requiere la cita urgente en horas de las mañana ', 'CC', NULL, 118, '890294', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283145, '2022-01-27 13:04:53', NULL, NULL, 'CC', '37752962', 'EDUVINA ACEVEDO', '3176480281', '3156482980', '', 'ECOGRAFIA DE VIAS URINARIAS (RIÑONES, VEJIGA Y PROSTATA TRANSABDOMINAL)', 7, '', '', 'AGENDADA', NULL, '2022-01-27 18:04:53', '2022-07-14 11:40:19', 'SILVIA PATRICIA DUARTE', 4, 'LLAMA 27/01/2022\n', 'CC', NULL, 118, '881332', NULL, NULL, NULL, 9, NULL);
INSERT INTO `listaespera` VALUES (283146, '2022-01-27 13:07:31', NULL, NULL, 'CC', '1098082317', 'IAM FELIPE SANCHEZ ESPINOSA', '3166453300', '', '', 'RADIOGRAFIA DE CADERA COMPARATIVA', 7, '', '', 'AGENDADA', NULL, '2022-01-27 18:07:31', '2022-07-14 11:55:00', 'SILVIA PATRICIA DUARTE', 4, 'LLAMA 27/01/2022\n', 'CC', NULL, 118, '873412', NULL, NULL, NULL, 9, NULL);
INSERT INTO `listaespera` VALUES (283147, '2022-01-27 13:08:54', '2022-02-02 16:44:59', '2022-02-15 07:47:48', 'CC', '1065863417', 'DIMAS SOLANO', '3185709242', '3233033840', '', 'CIRUGIA PLASTICA (Consulta de Primera Vez)', 9, '7000744009', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 18:08:54', '2023-01-27 18:05:28', 'LILIANA QUIROGA CRISTANCHO', 4, 'PRIORITARIA POSIBLE CANCER SOLICITA CITA DE CIRUGIA PLASTICA', 'CC', NULL, 8, '890239', NULL, NULL, NULL, 5, NULL);
INSERT INTO `listaespera` VALUES (283148, '2022-01-27 13:09:24', '2022-01-31 11:03:24', '2022-02-15 14:36:33', 'CC', '1012326221', 'PEDRO ANDRES GOMEZ APONTE', '3103131261', '3108779990', '', 'ECOGRAFIA DE ABDOMEN TOTAL (HIGADO, PANCREAS, VESICULA, VIAS BILIARES, RIÑONES, BAZO, GRANDES VASOS, PELVIS Y FLANCOS)', 7, '', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 18:09:24', '2022-07-14 11:40:20', 'SILVIA PATRICIA DUARTE', 4, 'LLAMA 27/01/2022** LLAMA 31/01/2022 SE VUELVE A COMUNICR 15/02\n', 'CC', NULL, 118, '881302', NULL, NULL, NULL, 9, NULL);
INSERT INTO `listaespera` VALUES (283149, '2022-01-27 13:11:14', '2022-02-10 12:33:57', NULL, 'CC', '6742105', 'LUIS FRANCISCO NEIRA', '3175062910', '3007607716', NULL, 'MEDICINA INTERNA (Consulta de Primera Vez)', 7, '', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 18:11:14', '2022-07-14 11:55:03', 'SILVIA PATRICIA DUARTE', 4, 'LLAMA 27/01/2022\nse vuelve a comunicar 10/02\n', 'CC', NULL, 118, '890266', NULL, NULL, NULL, 9, NULL);
INSERT INTO `listaespera` VALUES (283150, '2022-01-27 13:35:40', NULL, NULL, 'CC', '91217859', 'REINALDO GUATE PRADA', '3178089675', '3209255831', '', 'MEDICINA INTERNA (Consulta de Primera Vez)', 8, '', '24/08/2021', 'AGENDADA', NULL, '2022-01-27 18:35:40', '2022-02-07 11:19:36', 'Yessika Marlen Vargas Méndez', 4, 'CONTROL EN 3 MESES ', 'CC', NULL, 118, '890266', NULL, NULL, NULL, 4, NULL);
INSERT INTO `listaespera` VALUES (283151, '2022-01-27 13:37:35', '2022-02-01 10:48:38', '2022-02-11 12:12:16', 'CC', '63303862', 'NUBBY LISETT HIGUERA DAGOVETT', '3167498288', '3107515635', NULL, 'UROLOGIA (Consulta de Primera Vez)', 12, 'PREAUTORIZADO', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 18:37:35', '2022-07-14 11:55:07', 'DEYI YANIRA CUSPOCA', 4, 'URGENTE// LLAMA NUEVAMENTE 01/02/2022** 22/02/2022 LLAMA ** LLAMA 18/02/2022 ', 'CC', NULL, 118, '890294', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283152, '2022-01-27 13:37:49', NULL, NULL, 'CC', '1098712981', 'YERLY SURLEY BARCENAS MARTINEZ', '3176831519', '', '', 'MEDICINA INTERNA (Consulta de Primera Vez)', 7, '', '', 'AGENDADA', NULL, '2022-01-27 18:37:49', '2022-11-27 22:20:00', 'SILVIA PATRICIA DUARTE', 4, 'LLAMA 27/01/2022\n\n', 'CC', NULL, 118, '890266', NULL, NULL, NULL, 9, NULL);
INSERT INTO `listaespera` VALUES (283153, '2022-01-27 13:41:04', '2022-02-04 14:25:01', '2022-02-08 11:31:20', 'CC', '1125248724', ' PAOLA ALEJANDRA MIQUELES PALACIO', '3156897675', '', '', 'OTORRINOLARINGOLOGIA (Consulta de Control)', 12, '', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 18:41:04', '2022-02-10 13:07:19', 'SAIDY MELO', 4, 'OTORRINO', 'CC', NULL, 118, '890382', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283154, '2022-01-27 13:49:45', '2022-03-12 08:06:33', '2022-04-05 14:03:53', 'CC', '28403969', 'LETICIA PARRA RIOS', '3124613278', '3144012792', '', 'GASTROENTEROLOGIA (Consulta de Control)', 8, '', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 18:49:45', '2022-11-27 22:19:53', 'MARTHA VILLAMIZAR VILLAMIZAR', 4, '** SE VUELVE A COMUNICAR 12/03 *** LLAMA 5/04 ***', 'CC', NULL, 118, '890346', NULL, NULL, NULL, 4, NULL);
Rows : 114575
Field:
Spoiler Spoiler
CREATE TABLE `listaespera` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`llamada1` timestamp NULL DEFAULT NULL,
`llamada2` timestamp NULL DEFAULT NULL,
`llamada3` timestamp NULL DEFAULT NULL,
`tipodoc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`doc` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`paciente` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`celular1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`celular2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`fijo1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`servicio` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`convenio` int(11) NOT NULL DEFAULT -1,
`autorizacion` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`fechaautorizacion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`estado` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT 'SIN AGENDA',
`observacion` varchar(3000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`usuario` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`Sede` int(11) NOT NULL DEFAULT -1,
`observaciones` varchar(3000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`Observacion2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`Observacion3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`municipio` int(11) NULL DEFAULT 1,
`cups` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`fechanacimiento` date NULL DEFAULT NULL,
`email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`archivo` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
`eps` int(11) NULL DEFAULT NULL,
`troncal` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `listaespera_UN`(`doc`, `servicio`, `convenio`, `autorizacion`, `estado`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 388060 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
Sample:
Spoiler Spoiler
INSERT INTO `listaespera` VALUES (283123, '2022-01-27 11:49:40', '2022-02-01 13:01:57', '2022-02-04 10:30:22', 'CC', '1095937285', 'MAYRA FERNANDA PARADA ALVAREZ', '3165620643', '', '', 'NEUROLOGIA (Consulta de Primera Vez)', 12, 'PREAUTORIZADO', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 16:49:40', '2023-09-27 07:11:07', 'ERIKA YAJAIRA SANCHEZ VARGAS', 4, '[email protected] SOLICITA CITA URGENTE // LLAMA NUEVAMENTE 01/02/2022// LLAMA NUEAMENTE 04/02/2022// LLAMA NUEVAMENTE 07/02/2022// LLAMA NUEVAMENTE 09/02/2022// LLAMA NUEVAMENTE 14/02/2022// PACIENTE SIN MEDICACION BASTANTE ENFERMA/ BASTANTE MOLESTA.', 'CC', NULL, 118, '890274', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283124, '2022-01-27 11:51:49', '2022-04-16 11:53:46', NULL, 'CC', '21179345', 'FLOR MARIA REYES', '3214263127', '', '', 'MEDICINA INTERNA (Consulta de Primera Vez)', 19, '', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 16:51:49', '2022-04-22 11:02:41', 'ALEJANDRA SILVA', 4, 'PRESENCIAL', 'CC', NULL, 8, '890266', NULL, NULL, NULL, 2, NULL);
INSERT INTO `listaespera` VALUES (283125, '2022-01-27 11:54:55', '2022-02-08 08:44:16', '2022-05-12 15:22:10', 'TI', '1097122271', 'JORGE LUIS RIVERA', '3135073174', '', '', 'NUTRICION Y DIETETICA (Consulta de Primera Vez)', 8, '', 'Invalid date', 'SIN AGENDA', NULL, '2022-01-27 16:54:55', '2022-05-12 15:22:10', 'ALEJANDRA SILVA', 4, 'NO CONTESTAN 08/02/2022 \n\nLLAMA 12/05/2022', 'CC', NULL, 8, '890206', NULL, NULL, NULL, 4, NULL);
INSERT INTO `listaespera` VALUES (283126, '2022-01-27 11:56:34', NULL, NULL, 'CC', '28468666', 'EUMELINA BARON DE MOSQUERA', '3152796767', '', '', 'MEDICINA FISICA Y REHABILITACION (Consulta de Primera Vez)', 12, '', '27/01/2022', 'AGENDADA', NULL, '2022-01-27 16:56:34', '2022-07-14 11:40:19', 'MARTHA VILLAMIZAR VILLAMIZAR', 4, '', 'CC', NULL, 118, '890264', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283127, '2022-01-27 11:58:23', NULL, NULL, 'CC', '13834000', 'JOSE VICENTE BUENO CALDERON', '3134671545', '3042132948', '', 'OTORRINOLARINGOLOGIA (Consulta de Primera Vez)', 12, '', '27/01/2022', 'AGENDADA', NULL, '2022-01-27 16:58:23', '2022-02-17 16:17:20', 'LILIANA QUIROGA CRISTANCHO', 4, '', 'CC', NULL, 118, '890282', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283128, '2022-01-27 12:04:51', NULL, NULL, 'CC', '37822980', 'AURA SANETH MEJIA MERCHAN', '3125903125', '3138068100', '', 'ECOGRAFIA DE MAMA, CON TRANSDUCTOR DE 7 MHZ O MAS', 8, '290561', '27/01/2022', 'AGENDADA', NULL, '2022-01-27 17:04:51', '2022-07-14 11:55:04', 'LILIANA QUIROGA CRISTANCHO', 4, '', 'CC', NULL, 118, '881201', NULL, NULL, NULL, 4, NULL);
INSERT INTO `listaespera` VALUES (283129, '2022-01-27 12:05:02', NULL, NULL, 'RC', '1095846750', 'ERICH DANIEL CRIOLLO ALVARADO', '3185340571', '3185527480', '', 'RADIOGRAFIA DE CADERA COMPARATIVA', 8, '', '', 'AGENDADA', NULL, '2022-01-27 17:05:02', '2022-11-27 22:19:59', 'ERIKA YAJAIRA SANCHEZ VARGAS', 4, '', 'CC', NULL, 118, '873412', NULL, NULL, NULL, 4, NULL);
INSERT INTO `listaespera` VALUES (283130, '2022-01-27 12:07:08', NULL, NULL, 'CC', '13360392', 'ORLANDO CARRASCAL ZORRILLA', '3165725594', '3112498390', '', 'ESOFAGOGASTRODUODENOSCOPIA [EGD] CON BIOPSIA CERRADA SOD', 17, '', '', 'AGENDADA', NULL, '2022-01-27 17:07:08', '2022-07-14 11:40:19', 'KAREN ORTEGA', 1, '', 'CC', NULL, 612, '451600', NULL, NULL, NULL, 4, NULL);
INSERT INTO `listaespera` VALUES (283131, '2022-01-27 12:07:49', NULL, NULL, 'CC', '1149436516', 'DORIS ESTHER GALVAN', '3126798329', '', '', 'MEDICINA GENERAL (Consulta de Primera Vez)', 1, '', '', 'AGENDADA', NULL, '2022-01-27 17:07:49', '2022-04-22 11:02:41', 'SAIDY MELO', 4, '', 'CC', NULL, 118, '890201', NULL, NULL, NULL, 0, NULL);
INSERT INTO `listaespera` VALUES (283132, '2022-01-27 12:25:38', '2022-02-01 10:15:54', NULL, 'CC', '1065882994', 'CONSTANZA AVILA HERNANDEZ', '3167306178', '3168393144', '', 'MEDICINA FISICA Y REHABILITACION (Consulta de Primera Vez)', 14, '', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 17:25:38', '2022-07-14 11:55:01', 'ROSA HAYDEE LEON ABREU', 1, 'EN LOS POSIBLE EL DIA 08/01/2022 TIENE OTREA CONSULTA ', 'CC', NULL, 1, '890264', NULL, NULL, NULL, 4, NULL);
INSERT INTO `listaespera` VALUES (283133, '2022-01-27 12:28:43', NULL, NULL, 'CC', '13817245', 'AGUSTIN FLOREZ MENDEZ', '3506322012', '3167115151', NULL, 'NEUROLOGIA (Consulta de Primera Vez)', 12, '', '27/01/2022', 'AGENDADA', NULL, '2022-01-27 17:28:43', '2022-07-14 11:55:01', 'LILIANA QUIROGA CRISTANCHO', 4, '', 'CC', NULL, 118, '890274', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283134, '2022-01-27 12:32:23', '2022-02-02 08:42:22', '2022-02-16 11:57:19', 'PEP', '108296122121954', 'ALEX ENRIQUE PINO VILLALOBOS', '3028455358', '3106093992', '', 'MEDICINA INTERNA (Consulta de Control)', 7, '', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 17:32:23', '2022-02-21 15:11:51', 'ERIKA YAJAIRA SANCHEZ VARGAS', 4, 'se vuelve a comunicar 2/02/2022\nSE VUELVE A COMUNICAR 16/02\nLLAMA 21/02/2022\n', 'CC', NULL, 118, '890366', NULL, NULL, NULL, 9, NULL);
INSERT INTO `listaespera` VALUES (283135, '2022-01-27 12:34:38', NULL, NULL, 'CC', '13840361', 'EXPEDITO RODRIGUEZ CASTILLO', '3204390087', '', '6907006', 'CIRUGIA GENERAL (Consulta de Control)', 12, '', '27/01/2022', 'AGENDADA', NULL, '2022-01-27 17:34:38', '2022-07-14 11:40:19', 'LILIANA QUIROGA CRISTANCHO', 4, 'DRA AMELIA QUIERE CON ELLA', 'CC', NULL, 118, '890335', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283136, '2022-01-27 12:41:16', NULL, NULL, 'CC', '91274623', 'ARNULFO JIMENEZ ORTIZ', '3175731009', '', '', 'OTORRINOLARINGOLOGIA (Consulta de Primera Vez)', 12, '', '', 'AGENDADA', NULL, '2022-01-27 17:41:16', '2022-07-14 11:54:59', 'MARYELI MENESES IBAÑEZ', 4, '', 'CC', NULL, 118, '890282', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283137, '2022-01-27 12:41:51', NULL, NULL, 'CC', '13839132 ', 'ALVARO BLANCO SANCHEZ', '3156349658', '', '', 'GASTROENTEROLOGIA (Consulta de Primera Vez)', 12, '', '27/01/2022', 'AGENDADA', NULL, '2022-01-27 17:41:51', '2022-07-14 11:40:19', 'LILIANA QUIROGA CRISTANCHO', 4, '', 'CC', NULL, 118, '890246', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283138, '2022-01-27 12:42:22', NULL, NULL, 'CC', '63280007', 'OLINDA AFANADOR DE VARGAS', '3184725980', '3123589428', '', 'MONITOREO AMBULATORIO DE PRESION ARTERIAL SISTEMICA', 8, '', '', 'AGENDADA', NULL, '2022-01-27 17:42:22', '2022-06-03 09:14:39', 'ERIKA YAJAIRA SANCHEZ VARGAS', 4, '', 'CC', NULL, 118, '895004', NULL, NULL, NULL, 4, NULL);
INSERT INTO `listaespera` VALUES (283139, '2022-01-27 12:42:48', '2022-02-07 11:39:37', '2022-03-02 07:32:18', 'CC', '37893196', 'ROSALBA CABANILLA GOMEZ', '3002443415', '3168674455', '', 'OTORRINOLARINGOLOGIA (Consulta de Primera Vez)', 12, '32805-2200242553', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 17:42:48', '2022-07-14 11:40:19', 'MARYELI MENESES IBAÑEZ', 4, 'OTORRINO.', 'CC', NULL, 118, '890282', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283140, '2022-01-27 12:46:46', NULL, NULL, 'CC', '26766559', 'MARGOT SANCHEZ CARDOZO', '3163931668', '3178871804', '', 'ECOGRAFIA DE MAMA, CON TRANSDUCTOR DE 7 MHZ O MAS', 8, '', '', 'AGENDADA', NULL, '2022-01-27 17:46:46', '2022-11-27 22:19:52', 'ERIKA YAJAIRA SANCHEZ VARGAS', 4, '', 'CC', NULL, 118, '881201', NULL, NULL, NULL, 4, NULL);
INSERT INTO `listaespera` VALUES (283141, '2022-01-27 12:47:18', NULL, NULL, 'CC', '1098665437', 'DEYSI PAOLA GUERRERO VANEGAS', '3172687007', '3155143003', '', 'OTORRINOLARINGOLOGIA (Consulta de Primera Vez)', 12, '', '27/01/2022', 'AGENDADA', NULL, '2022-01-27 17:47:18', '2022-07-14 11:55:03', 'LILIANA QUIROGA CRISTANCHO', 4, '', 'CC', NULL, 118, '890282', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283142, '2022-01-27 12:48:24', '2022-02-15 17:22:05', '2022-02-17 11:00:55', 'CC', '13241185', 'JUAN NEPOMUCENO BLANCO SEQUERA', '3124236576', '', '', 'NEUROLOGIA (Consulta de Control)', 12, '', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 17:48:24', '2023-05-18 19:25:46', 'MARYELI MENESES IBAÑEZ', 4, 'SE VUELVE A COMUNICAR 15/02\nSE VUELVE A COMUNICAR 17/02', 'CC', NULL, 118, '890374', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283143, '2022-01-27 12:51:07', '2022-01-31 09:51:41', NULL, 'CC', '28209723', 'ANA (ANITA) HERNANDEZ', '3175459310', '3156800688', '', 'MEDICINA INTERNA (Consulta de Primera Vez)', 8, '', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 17:51:07', '2022-07-14 11:55:03', 'LILIANA QUIROGA CRISTANCHO', 4, 'LLAMA 31/01/2022\n', 'CC', NULL, 118, '890266', NULL, NULL, NULL, 4, NULL);
INSERT INTO `listaespera` VALUES (283144, '2022-01-27 12:52:59', NULL, NULL, 'CC', '5739052', 'CARLOS JULIO MEJIA ZARATE', '3204859490', '', '', 'UROLOGIA (Consulta de Primera Vez)', 12, '', '', 'AGENDADA', NULL, '2022-01-27 17:52:59', '2022-06-03 09:14:20', 'MARYELI MENESES IBAÑEZ', 4, 'presenta discapcidad vive en la provincia de velez // requiere la cita urgente en horas de las mañana ', 'CC', NULL, 118, '890294', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283145, '2022-01-27 13:04:53', NULL, NULL, 'CC', '37752962', 'EDUVINA ACEVEDO', '3176480281', '3156482980', '', 'ECOGRAFIA DE VIAS URINARIAS (RIÑONES, VEJIGA Y PROSTATA TRANSABDOMINAL)', 7, '', '', 'AGENDADA', NULL, '2022-01-27 18:04:53', '2022-07-14 11:40:19', 'SILVIA PATRICIA DUARTE', 4, 'LLAMA 27/01/2022\n', 'CC', NULL, 118, '881332', NULL, NULL, NULL, 9, NULL);
INSERT INTO `listaespera` VALUES (283146, '2022-01-27 13:07:31', NULL, NULL, 'CC', '1098082317', 'IAM FELIPE SANCHEZ ESPINOSA', '3166453300', '', '', 'RADIOGRAFIA DE CADERA COMPARATIVA', 7, '', '', 'AGENDADA', NULL, '2022-01-27 18:07:31', '2022-07-14 11:55:00', 'SILVIA PATRICIA DUARTE', 4, 'LLAMA 27/01/2022\n', 'CC', NULL, 118, '873412', NULL, NULL, NULL, 9, NULL);
INSERT INTO `listaespera` VALUES (283147, '2022-01-27 13:08:54', '2022-02-02 16:44:59', '2022-02-15 07:47:48', 'CC', '1065863417', 'DIMAS SOLANO', '3185709242', '3233033840', '', 'CIRUGIA PLASTICA (Consulta de Primera Vez)', 9, '7000744009', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 18:08:54', '2023-01-27 18:05:28', 'LILIANA QUIROGA CRISTANCHO', 4, 'PRIORITARIA POSIBLE CANCER SOLICITA CITA DE CIRUGIA PLASTICA', 'CC', NULL, 8, '890239', NULL, NULL, NULL, 5, NULL);
INSERT INTO `listaespera` VALUES (283148, '2022-01-27 13:09:24', '2022-01-31 11:03:24', '2022-02-15 14:36:33', 'CC', '1012326221', 'PEDRO ANDRES GOMEZ APONTE', '3103131261', '3108779990', '', 'ECOGRAFIA DE ABDOMEN TOTAL (HIGADO, PANCREAS, VESICULA, VIAS BILIARES, RIÑONES, BAZO, GRANDES VASOS, PELVIS Y FLANCOS)', 7, '', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 18:09:24', '2022-07-14 11:40:20', 'SILVIA PATRICIA DUARTE', 4, 'LLAMA 27/01/2022** LLAMA 31/01/2022 SE VUELVE A COMUNICR 15/02\n', 'CC', NULL, 118, '881302', NULL, NULL, NULL, 9, NULL);
INSERT INTO `listaespera` VALUES (283149, '2022-01-27 13:11:14', '2022-02-10 12:33:57', NULL, 'CC', '6742105', 'LUIS FRANCISCO NEIRA', '3175062910', '3007607716', NULL, 'MEDICINA INTERNA (Consulta de Primera Vez)', 7, '', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 18:11:14', '2022-07-14 11:55:03', 'SILVIA PATRICIA DUARTE', 4, 'LLAMA 27/01/2022\nse vuelve a comunicar 10/02\n', 'CC', NULL, 118, '890266', NULL, NULL, NULL, 9, NULL);
INSERT INTO `listaespera` VALUES (283150, '2022-01-27 13:35:40', NULL, NULL, 'CC', '91217859', 'REINALDO GUATE PRADA', '3178089675', '3209255831', '', 'MEDICINA INTERNA (Consulta de Primera Vez)', 8, '', '24/08/2021', 'AGENDADA', NULL, '2022-01-27 18:35:40', '2022-02-07 11:19:36', 'Yessika Marlen Vargas Méndez', 4, 'CONTROL EN 3 MESES ', 'CC', NULL, 118, '890266', NULL, NULL, NULL, 4, NULL);
INSERT INTO `listaespera` VALUES (283151, '2022-01-27 13:37:35', '2022-02-01 10:48:38', '2022-02-11 12:12:16', 'CC', '63303862', 'NUBBY LISETT HIGUERA DAGOVETT', '3167498288', '3107515635', NULL, 'UROLOGIA (Consulta de Primera Vez)', 12, 'PREAUTORIZADO', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 18:37:35', '2022-07-14 11:55:07', 'DEYI YANIRA CUSPOCA', 4, 'URGENTE// LLAMA NUEVAMENTE 01/02/2022** 22/02/2022 LLAMA ** LLAMA 18/02/2022 ', 'CC', NULL, 118, '890294', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283152, '2022-01-27 13:37:49', NULL, NULL, 'CC', '1098712981', 'YERLY SURLEY BARCENAS MARTINEZ', '3176831519', '', '', 'MEDICINA INTERNA (Consulta de Primera Vez)', 7, '', '', 'AGENDADA', NULL, '2022-01-27 18:37:49', '2022-11-27 22:20:00', 'SILVIA PATRICIA DUARTE', 4, 'LLAMA 27/01/2022\n\n', 'CC', NULL, 118, '890266', NULL, NULL, NULL, 9, NULL);
INSERT INTO `listaespera` VALUES (283153, '2022-01-27 13:41:04', '2022-02-04 14:25:01', '2022-02-08 11:31:20', 'CC', '1125248724', ' PAOLA ALEJANDRA MIQUELES PALACIO', '3156897675', '', '', 'OTORRINOLARINGOLOGIA (Consulta de Control)', 12, '', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 18:41:04', '2022-02-10 13:07:19', 'SAIDY MELO', 4, 'OTORRINO', 'CC', NULL, 118, '890382', NULL, NULL, NULL, 7, NULL);
INSERT INTO `listaespera` VALUES (283154, '2022-01-27 13:49:45', '2022-03-12 08:06:33', '2022-04-05 14:03:53', 'CC', '28403969', 'LETICIA PARRA RIOS', '3124613278', '3144012792', '', 'GASTROENTEROLOGIA (Consulta de Control)', 8, '', 'Invalid date', 'AGENDADA', NULL, '2022-01-27 18:49:45', '2022-11-27 22:19:53', 'MARTHA VILLAMIZAR VILLAMIZAR', 4, '** SE VUELVE A COMUNICAR 12/03 *** LLAMA 5/04 ***', 'CC', NULL, 118, '890346', NULL, NULL, NULL, 4, NULL);
