INSERT INTO `tbl_audit_logs` (`log_id`, `created_at`, `user_id`, `session_id`, `ip_address`, `user_agent`, `device`, `os`, `module`, `action`, `description`, `entity`, `entity_id`, `db_action`, `data_before`, `data_after`, `endpoint`, `http_method`, `status_code`, `response_time_ms`, `event_type`, `is_failed_attempt`, `is_critical`, `request_id`, `event_origin`, `environment`, `app_version`) VALUES
(5247, '2026-04-04 01:03:59', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '50b35a786cd38620', 'BACKEND', 'PROD', '1.0.0'),
(5248, '2026-04-04 01:07:54', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'b2734c6e92532781', 'BACKEND', 'PROD', '1.0.0'),
(5249, '2026-04-04 01:10:42', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '99667ddaaa645959', 'BACKEND', 'PROD', '1.0.0'),
(5250, '2026-04-04 01:10:58', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '8433f6b182d27776', 'BACKEND', 'PROD', '1.0.0'),
(5251, '2026-04-04 01:11:00', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'f9af63e98491e187', 'BACKEND', 'PROD', '1.0.0'),
(5252, '2026-04-04 01:11:16', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '6ee7c696306a9859', 'BACKEND', 'PROD', '1.0.0'),
(5253, '2026-04-04 01:16:12', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'd6e2c5bb313607d4', 'BACKEND', 'PROD', '1.0.0'),
(5254, '2026-04-04 01:16:24', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '9760324a66b9f54e', 'BACKEND', 'PROD', '1.0.0'),
(5255, '2026-04-04 01:19:19', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'd86ef8879a54b76c', 'BACKEND', 'PROD', '1.0.0'),
(5256, '2026-04-04 01:22:09', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '5d7633def5202e01', 'BACKEND', 'PROD', '1.0.0'),
(5257, '2026-04-04 01:23:08', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'fffae76095e647bd', 'BACKEND', 'PROD', '1.0.0'),
(5258, '2026-04-04 01:23:09', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'ed76eddd617197a1', 'BACKEND', 'PROD', '1.0.0'),
(5259, '2026-04-04 01:28:14', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '2fd0351234027c5a', 'BACKEND', 'PROD', '1.0.0'),
(5260, '2026-04-04 01:28:16', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'fc7c56efa3e7e457', 'BACKEND', 'PROD', '1.0.0'),
(5261, '2026-04-04 01:29:43', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'f5ab73abca9e913f', 'BACKEND', 'PROD', '1.0.0'),
(5262, '2026-04-04 01:29:52', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'b707a22789ad7e62', 'BACKEND', 'PROD', '1.0.0'),
(5263, '2026-04-04 01:29:58', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'd5277e957413cd04', 'BACKEND', 'PROD', '1.0.0'),
(5264, '2026-04-04 01:33:17', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '396b1e6de36287c1', 'BACKEND', 'PROD', '1.0.0'),
(5265, '2026-04-04 01:44:49', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '640ffa733f4ad8fb', 'BACKEND', 'PROD', '1.0.0'),
(5266, '2026-04-04 01:45:34', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '7f7a07dea17a0077', 'BACKEND', 'PROD', '1.0.0'),
(5267, '2026-04-04 01:45:57', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '7b22f812a7a0fe6c', 'BACKEND', 'PROD', '1.0.0'),
(5268, '2026-04-04 01:46:20', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'bdbc47d4012a52ba', 'BACKEND', 'PROD', '1.0.0'),
(5269, '2026-04-04 01:48:11', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '93ccc87486dd4341', 'BACKEND', 'PROD', '1.0.0'),
(5270, '2026-04-04 01:48:14', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '64a031e1f08b92a1', 'BACKEND', 'PROD', '1.0.0'),
(5271, '2026-04-04 01:48:17', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '7533650541a5279b', 'BACKEND', 'PROD', '1.0.0'),
(5272, '2026-04-04 01:48:20', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '40848c533c50ec87', 'BACKEND', 'PROD', '1.0.0'),
(5273, '2026-04-04 01:48:34', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '7df3bb349ec117c5', 'BACKEND', 'PROD', '1.0.0'),
(5274, '2026-04-04 01:52:21', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '94ed60604e35c5c4', 'BACKEND', 'PROD', '1.0.0'),
(5275, '2026-04-04 01:52:25', 1, '786fhc322vq7r3t57crjmoiovt', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'AUTH', 'LOGOUT', 'Cierre de sesión manual: ADMIN GENERAL', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/logout', 'GET', NULL, NULL, 'NORMAL', 0, 0, '183874ecd45bf9c0', 'BACKEND', 'PROD', '1.0.0'),
(5276, '2026-04-04 01:52:51', NULL, '9rbpqs3tg945ur8gr9n438s8qi', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'AUTH', 'LOGIN_FAILED', 'Intento fallido para: gorge', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/login', 'POST', NULL, NULL, 'SECURITY', 0, 0, 'd2d111b0b514c1c3', 'BACKEND', 'PROD', '1.0.0'),
(5277, '2026-04-04 01:52:59', 22, '9rbpqs3tg945ur8gr9n438s8qi', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'AUTH', 'LOGIN', 'Inicio de sesión exitoso: DEMETRIO OLIVARES ARGÜELLES', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/login', 'POST', NULL, NULL, '', 0, 0, 'becc42b5db980d74', 'BACKEND', 'PROD', '1.0.0'),
(5278, '2026-04-04 01:53:01', 22, '9rbpqs3tg945ur8gr9n438s8qi', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'STUDENT_PANEL', 'VIEW_INDEX', 'Acceso autorizado al Panel Estudiantil central.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/students', 'GET', NULL, NULL, 'NORMAL', 0, 0, '805f902b9160da0b', 'BACKEND', 'PROD', '1.0.0'),
(5279, '2026-04-04 01:53:40', 22, '9rbpqs3tg945ur8gr9n438s8qi', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'STUDENT_PANEL', 'VIEW_INDEX', 'Acceso autorizado al Panel Estudiantil central.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/students', 'GET', NULL, NULL, 'NORMAL', 0, 0, '6a3960ce16fcfd06', 'BACKEND', 'PROD', '1.0.0'),
(5280, '2026-04-04 01:53:47', 22, '9rbpqs3tg945ur8gr9n438s8qi', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'AUTH', 'LOGOUT', 'Cierre de sesión manual: DEMETRIO OLIVARES ARGÜELLES', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/logout', 'GET', NULL, NULL, 'NORMAL', 0, 0, 'c4d6dab5b1635ea0', 'BACKEND', 'PROD', '1.0.0'),
(5281, '2026-04-04 01:53:55', 1, '9rai2i3uel12g6dd4hfpc95e0q', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'AUTH', 'LOGIN', 'Inicio de sesión exitoso: ADMIN GENERAL', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/login', 'POST', NULL, NULL, '', 0, 0, '70f50d9051c235ec', 'BACKEND', 'PROD', '1.0.0'),
(5282, '2026-04-04 01:53:57', 1, '9rai2i3uel12g6dd4hfpc95e0q', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '0d5d2afb6471d3a8', 'BACKEND', 'PROD', '1.0.0'),
(5283, '2026-04-04 01:56:04', 1, '9rai2i3uel12g6dd4hfpc95e0q', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '6cb30f70e5d7225b', 'BACKEND', 'PROD', '1.0.0'),
(5284, '2026-04-04 01:56:56', 1, '9rai2i3uel12g6dd4hfpc95e0q', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '66114c1b1e0ebe81', 'BACKEND', 'PROD', '1.0.0'),
(5285, '2026-04-04 01:58:31', 1, '9rai2i3uel12g6dd4hfpc95e0q', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'f74b946d929ba397', 'BACKEND', 'PROD', '1.0.0'),
(5286, '2026-04-04 02:09:43', 1, '9rai2i3uel12g6dd4hfpc95e0q', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '49f9dff292c9d25a', 'BACKEND', 'PROD', '1.0.0'),
(5287, '2026-04-04 02:20:12', 1, '9rai2i3uel12g6dd4hfpc95e0q', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '846b80ddf8057828', 'BACKEND', 'PROD', '1.0.0'),
(5288, '2026-04-04 02:22:12', 1, '9rai2i3uel12g6dd4hfpc95e0q', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'AUTH', 'LOGOUT', 'Cierre de sesión manual: ADMIN GENERAL', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/logout', 'GET', NULL, NULL, 'NORMAL', 0, 0, 'f7b5dd6cd9ab01f6', 'BACKEND', 'PROD', '1.0.0'),
(5289, '2026-04-04 02:22:19', 22, 'u88mqf6tqu2srbog26kv6tk3p7', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'AUTH', 'LOGIN', 'Inicio de sesión exitoso: DEMETRIO OLIVARES ARGÜELLES', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/login', 'POST', NULL, NULL, '', 0, 0, '3132397f622cdf03', 'BACKEND', 'PROD', '1.0.0'),
(5290, '2026-04-04 02:22:21', 22, 'u88mqf6tqu2srbog26kv6tk3p7', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'STUDENT_PANEL', 'VIEW_INDEX', 'Acceso autorizado al Panel Estudiantil central.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/students', 'GET', NULL, NULL, 'NORMAL', 0, 0, 'cd27dc3a989f82ef', 'BACKEND', 'PROD', '1.0.0'),
(5291, '2026-04-04 02:23:04', 22, 'u88mqf6tqu2srbog26kv6tk3p7', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'STUDENT_PANEL', 'VIEW_INDEX', 'Acceso autorizado al Panel Estudiantil central.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/students', 'GET', NULL, NULL, 'NORMAL', 0, 0, 'eb7ed98ef1d4de39', 'BACKEND', 'PROD', '1.0.0'),
(5292, '2026-04-04 02:24:01', 22, 'u88mqf6tqu2srbog26kv6tk3p7', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'STUDENT_PANEL', 'VIEW_INDEX', 'Acceso autorizado al Panel Estudiantil central.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/students', 'GET', NULL, NULL, 'NORMAL', 0, 0, '4d9fcd88cbc16960', 'BACKEND', 'PROD', '1.0.0'),
(5293, '2026-04-04 02:26:10', 22, 'u88mqf6tqu2srbog26kv6tk3p7', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'STUDENT_PANEL', 'VIEW_INDEX', 'Acceso autorizado al Panel Estudiantil central.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/students', 'GET', NULL, NULL, 'NORMAL', 0, 0, '508973f8cf8795c7', 'BACKEND', 'PROD', '1.0.0'),
(5294, '2026-04-04 02:26:55', 22, 'u88mqf6tqu2srbog26kv6tk3p7', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'AUTH', 'LOGOUT', 'Cierre de sesión manual: DEMETRIO OLIVARES ARGÜELLES', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/logout', 'GET', NULL, NULL, 'NORMAL', 0, 0, '0dcaf45d059bbab2', 'BACKEND', 'PROD', '1.0.0'),
(5295, '2026-04-04 02:27:03', 1, '4irkpagbl54fdoq8i3bgd75tto', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'AUTH', 'LOGIN', 'Inicio de sesión exitoso: ADMIN GENERAL', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/login', 'POST', NULL, NULL, '', 0, 0, '0440aaef5e535b4f', 'BACKEND', 'PROD', '1.0.0'),
(5296, '2026-04-04 02:27:04', 1, '4irkpagbl54fdoq8i3bgd75tto', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '673fdec9bd4636aa', 'BACKEND', 'PROD', '1.0.0'),
(5297, '2026-04-04 02:34:16', 1, '4irkpagbl54fdoq8i3bgd75tto', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'b2b9d5c483fcb993', 'BACKEND', 'PROD', '1.0.0'),
(5298, '2026-04-04 02:34:29', 1, '4irkpagbl54fdoq8i3bgd75tto', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'ADMINISTRATIVE_PANEL', 'VIEW_INDEX', 'Acceso al Dashboard Administrativo.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/administrative', 'GET', NULL, NULL, 'NORMAL', 0, 0, '4723b5577bdb2d01', 'BACKEND', 'PROD', '1.0.0'),
(5299, '2026-04-04 02:34:31', 1, '4irkpagbl54fdoq8i3bgd75tto', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'ADMINISTRATIVE_PANEL', 'VIEW_INDEX', 'Acceso al Dashboard Administrativo.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/administrative', 'GET', NULL, NULL, 'NORMAL', 0, 0, 'ff6ece69b1d36ac5', 'BACKEND', 'PROD', '1.0.0'),
(5300, '2026-04-04 02:34:33', 1, '4irkpagbl54fdoq8i3bgd75tto', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'f4d8670df60caca6', 'BACKEND', 'PROD', '1.0.0'),
(5301, '2026-04-04 02:35:58', 1, '4irkpagbl54fdoq8i3bgd75tto', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '7c733284c29f6f63', 'BACKEND', 'PROD', '1.0.0'),
(5302, '2026-04-04 02:36:39', 1, '4irkpagbl54fdoq8i3bgd75tto', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '2500ce9d107b0b25', 'BACKEND', 'PROD', '1.0.0'),
(5303, '2026-04-04 02:45:21', 1, '4irkpagbl54fdoq8i3bgd75tto', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '540623d4b4b282ee', 'BACKEND', 'PROD', '1.0.0'),
(5304, '2026-04-04 02:46:44', 1, '4irkpagbl54fdoq8i3bgd75tto', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '64f55ff3379c8762', 'BACKEND', 'PROD', '1.0.0'),
(5305, '2026-04-04 02:52:33', 1, '4irkpagbl54fdoq8i3bgd75tto', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL_VALIDATIONS_BINANCE', 'APPROVE_PAYMENT', 'Pago Binance aprobado y aplicado a Ledger. ID Pago: 35', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial/payment_validations/binance/validatePayment', 'POST', NULL, NULL, '', 0, 0, '993e4f9cd62b0755', 'BACKEND', 'PROD', '1.0.0'),
(5306, '2026-04-04 02:53:59', 1, '4irkpagbl54fdoq8i3bgd75tto', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '169ce2a172090ce0', 'BACKEND', 'PROD', '1.0.0'),
(5307, '2026-04-04 02:55:04', 1, '4irkpagbl54fdoq8i3bgd75tto', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '5182ab950871f05f', 'BACKEND', 'PROD', '1.0.0'),
(5308, '2026-04-04 02:55:19', 1, '4irkpagbl54fdoq8i3bgd75tto', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL_VALIDATIONS_BINANCE', 'APPROVE_PAYMENT', 'Pago Binance aprobado y aplicado a Ledger. ID Pago: 36', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial/payment_validations/binance/validatePayment', 'POST', NULL, NULL, '', 0, 0, '9b693ba96a50fcf6', 'BACKEND', 'PROD', '1.0.0'),
(5309, '2026-04-04 02:55:27', 1, '4irkpagbl54fdoq8i3bgd75tto', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'bdaeb84302472759', 'BACKEND', 'PROD', '1.0.0'),
(5310, '2026-04-04 02:55:36', 1, '4irkpagbl54fdoq8i3bgd75tto', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'f5eb3755a261ec1e', 'BACKEND', 'PROD', '1.0.0'),
(5311, '2026-04-04 14:14:15', 1, 'tliracdl0adphfj1t5cv58plo4', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'AUTH', 'LOGIN', 'Inicio de sesión exitoso: ADMIN GENERAL', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/login', 'POST', NULL, NULL, '', 0, 0, '4ee3549e93c2f058', 'BACKEND', 'PROD', '1.0.0'),
(5312, '2026-04-04 14:14:17', 1, 'tliracdl0adphfj1t5cv58plo4', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'ac1500f6be36ce93', 'BACKEND', 'PROD', '1.0.0'),
(5313, '2026-04-04 14:27:01', 1, 'tliracdl0adphfj1t5cv58plo4', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '8c86d7789636648d', 'BACKEND', 'PROD', '1.0.0'),
(5314, '2026-04-04 14:27:06', 1, 'tliracdl0adphfj1t5cv58plo4', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '336cca298d79b0d2', 'BACKEND', 'PROD', '1.0.0'),
(5315, '2026-04-04 14:29:46', 1, 'tliracdl0adphfj1t5cv58plo4', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'ADMINISTRATIVE_PANEL', 'VIEW_INDEX', 'Acceso al Dashboard Administrativo.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/administrative', 'GET', NULL, NULL, 'NORMAL', 0, 0, '802adac15436216c', 'BACKEND', 'PROD', '1.0.0'),
(5316, '2026-04-04 14:29:49', 1, 'tliracdl0adphfj1t5cv58plo4', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '9b48211be64daeb1', 'BACKEND', 'PROD', '1.0.0'),
(5317, '2026-04-04 14:30:31', 1, 'tliracdl0adphfj1t5cv58plo4', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'd00fc195b9dc9112', 'BACKEND', 'PROD', '1.0.0'),
(5318, '2026-04-04 14:45:08', 1, 'tliracdl0adphfj1t5cv58plo4', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL_CASH_VALIDATION', 'APPROVE_CASH', 'Pago ID 37 validado en ventanilla por 15 USD', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial/payment_validations/efectivo/validatePayment', 'POST', NULL, NULL, '', 0, 0, 'f66edbd4dd28f24c', 'BACKEND', 'PROD', '1.0.0'),
(5319, '2026-04-04 14:45:25', 1, 'tliracdl0adphfj1t5cv58plo4', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'e9e55b34e8cb6b29', 'BACKEND', 'PROD', '1.0.0'),
(5320, '2026-04-04 14:45:38', 1, 'tliracdl0adphfj1t5cv58plo4', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'a450d1bc706465af', 'BACKEND', 'PROD', '1.0.0'),
(5321, '2026-04-04 14:45:41', 1, 'tliracdl0adphfj1t5cv58plo4', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'AUTH', 'LOGOUT', 'Cierre de sesión manual: ADMIN GENERAL', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/logout', 'GET', NULL, NULL, 'NORMAL', 0, 0, 'd476270e115c6a6a', 'BACKEND', 'PROD', '1.0.0'),
(5322, '2026-04-04 15:56:47', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'AUTH', 'LOGIN', 'Inicio de sesión exitoso: ADMIN GENERAL', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/login', 'POST', NULL, NULL, '', 0, 0, '04cb0f9db3488659', 'BACKEND', 'PROD', '1.0.0'),
(5323, '2026-04-04 15:56:49', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'efaa68848f5f476b', 'BACKEND', 'PROD', '1.0.0'),
(5324, '2026-04-04 15:57:58', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'efa63447d53ea3b8', 'BACKEND', 'PROD', '1.0.0'),
(5325, '2026-04-04 15:58:01', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'b44aa9a7c9b6eb9f', 'BACKEND', 'PROD', '1.0.0'),
(5326, '2026-04-04 15:58:14', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '3b710f5da4bc9831', 'BACKEND', 'PROD', '1.0.0'),
(5327, '2026-04-04 15:59:30', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'bdb48e74cdb8a85a', 'BACKEND', 'PROD', '1.0.0'),
(5328, '2026-04-04 17:09:10', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'c7d601438829e739', 'BACKEND', 'PROD', '1.0.0'),
(5329, '2026-04-04 17:09:46', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '4788052fece5562c', 'BACKEND', 'PROD', '1.0.0'),
(5330, '2026-04-04 17:13:30', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '0dfd6318aca24326', 'BACKEND', 'PROD', '1.0.0'),
(5331, '2026-04-04 17:13:34', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'a5e9fa2e277f1beb', 'BACKEND', 'PROD', '1.0.0'),
(5332, '2026-04-04 17:13:43', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'ADMINISTRATIVE_PANEL', 'VIEW_INDEX', 'Acceso al Dashboard Administrativo.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/administrative', 'GET', NULL, NULL, 'NORMAL', 0, 0, '57f00f97a7aa94b4', 'BACKEND', 'PROD', '1.0.0'),
(5333, '2026-04-04 17:13:46', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'ADMINISTRATIVE_PANEL', 'VIEW_INDEX', 'Acceso al Dashboard Administrativo.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/administrative', 'GET', NULL, NULL, 'NORMAL', 0, 0, 'f13e8ff80178167d', 'BACKEND', 'PROD', '1.0.0'),
(5334, '2026-04-04 17:13:51', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'ADMINISTRATIVE_PANEL', 'VIEW_INDEX', 'Acceso al Dashboard Administrativo.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/administrative', 'GET', NULL, NULL, 'NORMAL', 0, 0, '641ad179effaeb9c', 'BACKEND', 'PROD', '1.0.0'),
(5335, '2026-04-04 17:13:53', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'bfbbc1c63215d0d9', 'BACKEND', 'PROD', '1.0.0'),
(5336, '2026-04-04 17:13:56', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '03f8557fa2b09fd0', 'BACKEND', 'PROD', '1.0.0'),
(5337, '2026-04-04 17:13:59', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '7cde26cf27e1c045', 'BACKEND', 'PROD', '1.0.0'),
(5338, '2026-04-04 17:16:03', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '7b69d15f94ac6849', 'BACKEND', 'PROD', '1.0.0'),
(5339, '2026-04-04 17:17:25', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'ec33ba6256bb9a4b', 'BACKEND', 'PROD', '1.0.0'),
(5340, '2026-04-04 17:19:38', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '255cefab5f9c7a35', 'BACKEND', 'PROD', '1.0.0'),
(5341, '2026-04-04 18:26:36', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'EXPORT_PDF_PAYMENTS', 'Exportó historial de pagos de: 149795233', NULL, 22, NULL, NULL, NULL, '/diplomatic/public/financial/student_statement/exportPaymentPdf?user_id=22', 'GET', NULL, NULL, 'NORMAL', 0, 0, 'fbce1517d1fb982f', 'BACKEND', 'PROD', '1.0.0'),
(5342, '2026-04-04 18:31:41', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '24492761c7c6fe35', 'BACKEND', 'PROD', '1.0.0'),
(5343, '2026-04-04 18:32:00', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '650b78511d111de8', 'BACKEND', 'PROD', '1.0.0'),
(5344, '2026-04-04 18:37:27', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '368bde6c32a8a94a', 'BACKEND', 'PROD', '1.0.0'),
(5345, '2026-04-04 18:39:36', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'ADMINISTRATIVE_PANEL', 'VIEW_INDEX', 'Acceso al Dashboard Administrativo.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/administrative', 'GET', NULL, NULL, 'NORMAL', 0, 0, '882aba8bb357c2cd', 'BACKEND', 'PROD', '1.0.0'),
(5346, '2026-04-04 18:39:44', 1, 'ji3vteu52a6hti9u48njfksv9i', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'AUTH', 'LOGOUT', 'Cierre de sesión manual: ADMIN GENERAL', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/logout', 'GET', NULL, NULL, 'NORMAL', 0, 0, '01155b8935e6b2ae', 'BACKEND', 'PROD', '1.0.0'),
(5347, '2026-04-04 18:39:53', 22, 'tma9dvjjeum5p1f6i2r5i9q2qo', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'AUTH', 'LOGIN', 'Inicio de sesión exitoso: DEMETRIO OLIVARES ARGÜELLES', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/login', 'POST', NULL, NULL, '', 0, 0, 'cd946f567dab4a67', 'BACKEND', 'PROD', '1.0.0'),
(5348, '2026-04-04 18:39:54', 22, 'tma9dvjjeum5p1f6i2r5i9q2qo', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'STUDENT_PANEL', 'VIEW_INDEX', 'Acceso autorizado al Panel Estudiantil central.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/students', 'GET', NULL, NULL, 'NORMAL', 0, 0, 'ecab2484619f8d79', 'BACKEND', 'PROD', '1.0.0'),
(5349, '2026-04-04 18:54:40', 22, 'tma9dvjjeum5p1f6i2r5i9q2qo', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'STUDENT_PANEL', 'VIEW_INDEX', 'Acceso autorizado al Panel Estudiantil central.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/students', 'GET', NULL, NULL, 'NORMAL', 0, 0, '04ed11a88163b0eb', 'BACKEND', 'PROD', '1.0.0'),
(5350, '2026-04-04 18:54:43', 22, 'tma9dvjjeum5p1f6i2r5i9q2qo', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'STUDENT_PANEL', 'VIEW_INDEX', 'Acceso autorizado al Panel Estudiantil central.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/students', 'GET', NULL, NULL, 'NORMAL', 0, 0, '27ceb578137e69a1', 'BACKEND', 'PROD', '1.0.0'),
(5351, '2026-04-04 18:57:23', 22, 'tma9dvjjeum5p1f6i2r5i9q2qo', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'STUDENT_PANEL', 'VIEW_INDEX', 'Acceso autorizado al Panel Estudiantil central.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/students', 'GET', NULL, NULL, 'NORMAL', 0, 0, '7aaf9367a5813d8b', 'BACKEND', 'PROD', '1.0.0'),
(5352, '2026-04-04 18:58:08', 22, 'tma9dvjjeum5p1f6i2r5i9q2qo', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'STUDENT_PANEL', 'VIEW_INDEX', 'Acceso autorizado al Panel Estudiantil central.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/students', 'GET', NULL, NULL, 'NORMAL', 0, 0, '49e4747ebbd2f1b5', 'BACKEND', 'PROD', '1.0.0'),
(5353, '2026-04-04 18:58:12', 22, 'tma9dvjjeum5p1f6i2r5i9q2qo', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'STUDENT_PANEL', 'VIEW_INDEX', 'Acceso autorizado al Panel Estudiantil central.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/students', 'GET', NULL, NULL, 'NORMAL', 0, 0, '8e3fd7925f2d1ec6', 'BACKEND', 'PROD', '1.0.0'),
(5354, '2026-04-04 18:58:18', 22, 'tma9dvjjeum5p1f6i2r5i9q2qo', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'STUDENT_PANEL', 'VIEW_INDEX', 'Acceso autorizado al Panel Estudiantil central.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/students', 'GET', NULL, NULL, 'NORMAL', 0, 0, 'c366cf0cfe936625', 'BACKEND', 'PROD', '1.0.0'),
(5355, '2026-04-04 18:58:29', 22, 'tma9dvjjeum5p1f6i2r5i9q2qo', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'STUDENT_PANEL', 'VIEW_INDEX', 'Acceso autorizado al Panel Estudiantil central.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/students', 'GET', NULL, NULL, 'NORMAL', 0, 0, 'be1a43116950dffc', 'BACKEND', 'PROD', '1.0.0'),
(5356, '2026-04-04 18:59:27', 22, 'tma9dvjjeum5p1f6i2r5i9q2qo', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'STUDENT_PANEL', 'VIEW_INDEX', 'Acceso autorizado al Panel Estudiantil central.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/students', 'GET', NULL, NULL, 'NORMAL', 0, 0, '0cefc8b11e4c7724', 'BACKEND', 'PROD', '1.0.0'),
(5357, '2026-04-04 18:59:49', 22, 'tma9dvjjeum5p1f6i2r5i9q2qo', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'STUDENT_PANEL', 'VIEW_INDEX', 'Acceso autorizado al Panel Estudiantil central.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/students', 'GET', NULL, NULL, 'NORMAL', 0, 0, '1a6e08a46ede61e5', 'BACKEND', 'PROD', '1.0.0'),
(5358, '2026-04-04 19:30:39', 22, 'tma9dvjjeum5p1f6i2r5i9q2qo', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'STUDENT_PANEL', 'VIEW_INDEX', 'Acceso autorizado al Panel Estudiantil central.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/students', 'GET', NULL, NULL, 'NORMAL', 0, 0, '9a00eef09b449135', 'BACKEND', 'PROD', '1.0.0'),
(5359, '2026-04-04 20:00:24', 22, 'tma9dvjjeum5p1f6i2r5i9q2qo', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'STUDENT_PANEL', 'VIEW_INDEX', 'Acceso autorizado al Panel Estudiantil central.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/students', 'GET', NULL, NULL, 'NORMAL', 0, 0, 'ce77795b74dc529a', 'BACKEND', 'PROD', '1.0.0'),
(5360, '2026-04-04 20:00:28', 22, 'tma9dvjjeum5p1f6i2r5i9q2qo', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'STUDENT_PANEL', 'VIEW_INDEX', 'Acceso autorizado al Panel Estudiantil central.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/students', 'GET', NULL, NULL, 'NORMAL', 0, 0, '223d4db6fb54d69b', 'BACKEND', 'PROD', '1.0.0'),
(5361, '2026-04-04 20:08:41', 22, 'tma9dvjjeum5p1f6i2r5i9q2qo', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'STUDENT_PANEL', 'VIEW_INDEX', 'Acceso autorizado al Panel Estudiantil central.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/students', 'GET', NULL, NULL, 'NORMAL', 0, 0, '39b38d4ed59c52d9', 'BACKEND', 'PROD', '1.0.0');
INSERT INTO `tbl_audit_logs` (`log_id`, `created_at`, `user_id`, `session_id`, `ip_address`, `user_agent`, `device`, `os`, `module`, `action`, `description`, `entity`, `entity_id`, `db_action`, `data_before`, `data_after`, `endpoint`, `http_method`, `status_code`, `response_time_ms`, `event_type`, `is_failed_attempt`, `is_critical`, `request_id`, `event_origin`, `environment`, `app_version`) VALUES
(5362, '2026-04-04 20:09:00', 22, 'tma9dvjjeum5p1f6i2r5i9q2qo', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'STUDENT_PANEL', 'VIEW_INDEX', 'Acceso autorizado al Panel Estudiantil central.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/students', 'GET', NULL, NULL, 'NORMAL', 0, 0, '8c317011b9163bb2', 'BACKEND', 'PROD', '1.0.0'),
(5363, '2026-04-04 20:10:53', 22, 'tma9dvjjeum5p1f6i2r5i9q2qo', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'AUTH', 'LOGOUT', 'Cierre de sesión manual: DEMETRIO OLIVARES ARGÜELLES', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/logout', 'GET', NULL, NULL, 'NORMAL', 0, 0, 'b35db5060b0b9d25', 'BACKEND', 'PROD', '1.0.0'),
(5364, '2026-04-04 20:10:58', 1, '4n65lu2dkm63gnd3im3sh51dhf', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'AUTH', 'LOGIN', 'Inicio de sesión exitoso: ADMIN GENERAL', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/login', 'POST', NULL, NULL, '', 0, 0, 'c4056ae546d98b07', 'BACKEND', 'PROD', '1.0.0'),
(5365, '2026-04-04 20:10:59', 1, '4n65lu2dkm63gnd3im3sh51dhf', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'fc1b8e506f132cf3', 'BACKEND', 'PROD', '1.0.0'),
(5366, '2026-04-04 20:11:01', 1, '4n65lu2dkm63gnd3im3sh51dhf', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'ADMINISTRATIVE_PANEL', 'VIEW_INDEX', 'Acceso al Dashboard Administrativo.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/administrative', 'GET', NULL, NULL, 'NORMAL', 0, 0, 'a93480ec576a458b', 'BACKEND', 'PROD', '1.0.0'),
(5367, '2026-04-04 20:11:13', 1, '4n65lu2dkm63gnd3im3sh51dhf', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'df8a53a07910abec', 'BACKEND', 'PROD', '1.0.0'),
(5368, '2026-04-04 20:11:27', 1, '4n65lu2dkm63gnd3im3sh51dhf', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'a34a6f0803170021', 'BACKEND', 'PROD', '1.0.0'),
(5369, '2026-04-04 20:11:28', 1, '4n65lu2dkm63gnd3im3sh51dhf', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'ADMINISTRATIVE_PANEL', 'VIEW_INDEX', 'Acceso al Dashboard Administrativo.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/administrative', 'GET', NULL, NULL, 'NORMAL', 0, 0, '05b380ebb62d89fd', 'BACKEND', 'PROD', '1.0.0'),
(5370, '2026-04-04 20:11:49', 1, '4n65lu2dkm63gnd3im3sh51dhf', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'ADMINISTRATIVE_PANEL', 'VIEW_INDEX', 'Acceso al Dashboard Administrativo.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/administrative', 'GET', NULL, NULL, 'NORMAL', 0, 0, '34b9eb3eae333df5', 'BACKEND', 'PROD', '1.0.0'),
(5371, '2026-04-04 20:11:50', 1, '4n65lu2dkm63gnd3im3sh51dhf', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'ADMINISTRATIVE_PANEL', 'VIEW_INDEX', 'Acceso al Dashboard Administrativo.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/administrative', 'GET', NULL, NULL, 'NORMAL', 0, 0, '177fc5a9d25acfa1', 'BACKEND', 'PROD', '1.0.0'),
(5372, '2026-04-04 20:18:40', 1, '4n65lu2dkm63gnd3im3sh51dhf', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'SETTINGS_EMAIL', 'ACCESS', 'Acceso al módulo independiente de correo', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/settings/correo', 'GET', NULL, NULL, 'NORMAL', 0, 0, '994504088df31050', 'BACKEND', 'PROD', '1.0.0'),
(5373, '2026-04-04 21:06:51', 1, '4n65lu2dkm63gnd3im3sh51dhf', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, '5e643725ee46a144', 'BACKEND', 'PROD', '1.0.0'),
(5374, '2026-04-04 21:06:51', 1, '4n65lu2dkm63gnd3im3sh51dhf', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'FINANCIAL', 'ACCESS', 'Ingreso autorizado al Panel Financiero.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/financial', 'GET', NULL, NULL, '', 0, 0, 'f79f187a7632398f', 'BACKEND', 'PROD', '1.0.0'),
(5375, '2026-04-04 21:06:52', 1, '4n65lu2dkm63gnd3im3sh51dhf', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'ADMINISTRATIVE_PANEL', 'VIEW_INDEX', 'Acceso al Dashboard Administrativo.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/administrative', 'GET', NULL, NULL, 'NORMAL', 0, 0, '6b0447535c204ae4', 'BACKEND', 'PROD', '1.0.0'),
(5376, '2026-04-04 21:07:28', 1, '4n65lu2dkm63gnd3im3sh51dhf', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'ADMINISTRATIVE_PANEL', 'VIEW_INDEX', 'Acceso al Dashboard Administrativo.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/administrative', 'GET', NULL, NULL, 'NORMAL', 0, 0, '3bf2470fd4c142fc', 'BACKEND', 'PROD', '1.0.0'),
(5377, '2026-04-04 21:10:46', 1, '4n65lu2dkm63gnd3im3sh51dhf', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'ADMINISTRATIVE_PANEL', 'VIEW_INDEX', 'Acceso al Dashboard Administrativo.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/administrative', 'GET', NULL, NULL, 'NORMAL', 0, 0, 'e722d62c2e807f72', 'BACKEND', 'PROD', '1.0.0'),
(5378, '2026-04-04 21:56:34', 1, '4n65lu2dkm63gnd3im3sh51dhf', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'SETTINGS_EMAIL', 'ACCESS', 'Acceso al módulo independiente de correo', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/settings/correo', 'GET', NULL, NULL, 'NORMAL', 0, 0, 'aa8365c3cbd49610', 'BACKEND', 'PROD', '1.0.0'),
(5379, '2026-04-04 21:56:52', 1, '4n65lu2dkm63gnd3im3sh51dhf', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'SETTINGS_EMAIL', 'TEST_SEND', 'Envío de prueba exitoso a: gorgepereira@gmail.com', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/settings/test-correo', 'POST', NULL, NULL, '', 0, 0, '3e0da7f7819237f9', 'BACKEND', 'PROD', '1.0.0'),
(5380, '2026-04-04 22:00:23', 1, '4n65lu2dkm63gnd3im3sh51dhf', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'ADMINISTRATIVE_PANEL', 'VIEW_INDEX', 'Acceso al Dashboard Administrativo.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/administrative', 'GET', NULL, NULL, 'NORMAL', 0, 0, '62bd0f9975c53ce3', 'BACKEND', 'PROD', '1.0.0'),
(5381, '2026-04-04 23:11:09', 1, '4n65lu2dkm63gnd3im3sh51dhf', '200.8.212.43', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36', 'desktop', 'Windows', 'ADMINISTRATIVE_PANEL', 'VIEW_INDEX', 'Acceso al Dashboard Administrativo.', NULL, NULL, NULL, NULL, NULL, '/diplomatic/public/administrative/', 'GET', NULL, NULL, 'NORMAL', 0, 0, '2929d942d273b383', 'BACKEND', 'PROD', '1.0.0');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_campuses`
--

CREATE TABLE `tbl_campuses` (
  `id` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish_ci;

--
-- Volcado de datos para la tabla `tbl_campuses`
--

INSERT INTO `tbl_campuses` (`id`, `name`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Decanato de Ciencias de la Salud', 1, '2026-03-02 12:51:05', NULL),
(2, 'Sede Principal Barquisimeto', 1, '2026-03-02 12:51:05', NULL),
(3, 'Extensión Cabudare', 1, '2026-03-02 12:51:05', NULL),
(4, 'Campus Virtual', 1, '2026-03-02 12:51:05', NULL);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_cohortes`
--

CREATE TABLE `tbl_cohortes` (
  `id` int(11) NOT NULL,
  `diplomado_id` int(11) DEFAULT NULL,
  `cohort_code` varchar(20) NOT NULL COMMENT 'Código institucional (ej: 2026-I)',
  `name` varchar(100) NOT NULL COMMENT 'Nombre descriptivo del periodo',
  `start_date` date NOT NULL COMMENT 'Inicio oficial del periodo académico',
  `end_date` date NOT NULL COMMENT 'Fin oficial del periodo académico',
  `enrollment_start` date DEFAULT NULL COMMENT 'Inicio de ventana de inscripción',
  `enrollment_end` date DEFAULT NULL COMMENT 'Cierre de ventana de inscripción',
  `description` text DEFAULT NULL,
  `base_campus` varchar(150) DEFAULT NULL COMMENT 'Sede base institucional',
  `cohort_status` enum('Planificada','En curso','Finalizada','Reabierta','Suspendida','Cancelada') NOT NULL DEFAULT 'Planificada',
  `is_active` tinyint(1) DEFAULT 1,
  `created_by` int(10) UNSIGNED DEFAULT NULL,
  `updated_by` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `tbl_cohortes`
--

INSERT INTO `tbl_cohortes` (`id`, `diplomado_id`, `cohort_code`, `name`, `start_date`, `end_date`, `enrollment_start`, `enrollment_end`, `description`, `base_campus`, `cohort_status`, `is_active`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, NULL, '2026-I', 'Cohorte ENERO - MAYO - 2026', '2026-01-01', '2026-05-30', '2026-01-01', '2026-02-15', 'Notas de la Cohorte', 'Decanato de Ciencias de la Salud', 'Planificada', 1, 1, 1, '2026-02-18 11:54:35', '2026-03-10 03:36:13'),
(6, NULL, '2026-EJEMPLO', 'COHORTE EJEMPLO', '2026-03-09', '2026-03-30', '2026-03-02', '2026-03-08', 'EJEMPLO', NULL, 'Planificada', 0, 1, 1, '2026-03-05 22:08:15', '2026-03-05 22:28:39');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_cohort_campuses`
--

CREATE TABLE `tbl_cohort_campuses` (
  `cohort_id` int(11) NOT NULL,
  `campus_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish_ci;

--
-- Volcado de datos para la tabla `tbl_cohort_campuses`
--

INSERT INTO `tbl_cohort_campuses` (`cohort_id`, `campus_id`) VALUES
(1, 1),
(1, 2),
(1, 3),
(6, 1),
(6, 2),
(6, 3),
(6, 4);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_company_settings`
--

CREATE TABLE `tbl_company_settings` (
  `id` int(11) NOT NULL,
  `nombre_legal` varchar(255) DEFAULT NULL,
  `nombre_comercial` varchar(255) DEFAULT NULL,
  `siglas_estudiantes` varchar(5) DEFAULT 'DCS',
  `id_fiscal` varchar(100) DEFAULT NULL,
  `direccion` text DEFAULT NULL,
  `telefono` varchar(50) DEFAULT NULL,
  `email` varchar(150) DEFAULT NULL,
  `sitio_web` varchar(255) DEFAULT NULL,
  `representante` varchar(255) DEFAULT NULL,
  `cargo_rep` varchar(150) DEFAULT NULL,
  `tel_rep` varchar(50) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `tbl_company_settings`
--

INSERT INTO `tbl_company_settings` (`id`, `nombre_legal`, `nombre_comercial`, `siglas_estudiantes`, `id_fiscal`, `direccion`, `telefono`, `email`, `sitio_web`, `representante`, `cargo_rep`, `tel_rep`, `created_at`, `updated_at`) VALUES
(1, 'Diplomados', 'Plataforma Diplomados', 'DCS', 'G1212121212', '10773 NW 58th ST, Doral FL 33178', '+584145365380', 'admin@plataformadiplomados.com', 'www.plataformadiplomados.com', 'JORGE PEREIRA', 'PROGRAMADOR', '+584145042125', '2026-02-12 15:54:22', '2026-02-12 15:58:10');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_diplomados`
--

CREATE TABLE `tbl_diplomados` (
  `id` int(11) NOT NULL,
  `code` varchar(20) NOT NULL COMMENT 'Código institucional del diplomado',
  `name` varchar(255) NOT NULL COMMENT 'Nombre completo del diplomado',
  `description` text DEFAULT NULL COMMENT 'Propósito y enfoque científico',
  `directed_to` text DEFAULT NULL COMMENT 'Perfil profesional admitido',
  `total_hours` int(5) DEFAULT 200 COMMENT 'Carga horaria total (según oferta)',
  `status` enum('ACTIVO','INACTIVO','BORRADOR') DEFAULT 'BORRADOR',
  `created_by` int(10) UNSIGNED DEFAULT NULL,
  `updated_by` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `tbl_diplomados`
--

INSERT INTO `tbl_diplomados` (`id`, `code`, `name`, `description`, `directed_to`, `total_hours`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'DCS-DIP-GR-033-2025', 'DIPLOMADO EN TERAPIA RESPIRATORIA\r\nCLÍNICA Y MANEJO INTEGRAL DEL\r\nPACIENTE', 'Estimado participante, le damos la mas cordial bienvenida. Esta pagina es de carácter\r\ninformativo en relación con el Diplomado en Terapia Respiratoria Clínica y Manejo Integral\r\ndel Paciente. Para nosotros es un placer atenderte.\r\nLa terapia respiratoria constituye un pilar fundamental en la atención multidisciplinaria del\r\npaciente crítico, crónico y con patologías respiratorias agudas. Este Diplomado ha sido\r\ndiseñado bajo un enfoque bimodal (virtual y presencial), que permite articular la\r\nflexibilidad del aprendizaje en línea con la rigurosidad de la práctica clínica supervisada. A\r\nlo largo del Diplomado, los participantes adquirirán competencias teóricas y prácticas para\r\nel manejo seguro y eficaz de gases medicinales, la implementación de estrategias de\r\noxigenoterapia, la aplicación de ventilación no invasiva, la ejecución de técnicas de\r\nfisioterapia torácica y el monitoreo respiratorio avanzado. Estos saberes se integran en un\r\nmarco ético, científico y humanizado, orientado a optimizar la calidad asistencial y\r\nfortalecer la toma de decisiones clínicas en diversos contextos de atención.\r\nEl objetivo es formar profesionales de la salud con competencias teóricas, clínicas y éticas\r\nque les permitan intervenir de manera segura, eficaz y humanizada en el manejo de\r\npacientes con patologías respiratorias agudas y crónicas, mediante el análisis, la\r\naplicación y la evaluación crítica de procedimientos terapéuticos, el uso racional de\r\ntecnologías respiratorias, y la toma de decisiones interdisciplinarias orientadas a la mejora\r\ncontinua de la atención.', ' Médicos, Profesionales de Enfermería (TSU o Licenciados) y\r\ntodo Profesional del área de la salud que desee actualizarse en el área de la Terapia\r\nRespiratoria', 200, 'ACTIVO', NULL, 1, '2026-02-18 00:10:49', '2026-03-04 12:40:01'),
(2, 'DCS-DIP-GR-007-2024', 'DIPLOMADO EN MEDICINA LEGAL Y\r\nCIENCIAS FORENSES ', 'Estimado participante, le damos la mas cordial bienvenida. Esta pagina es de carácter\r\ninformativo en relación con el Diplomado en Medicina Legal y Ciencias Forenses ofertado\r\npara Profesionales del área de Ciencias de la Salud, Ciencias Jurídicas, Ciencias Sociales y\r\nPoliciales. Para nosotros es un placer atenderte.\r\nEl objetivo principal de este Diplomado es proporcionar a los Profesionales una\r\noportunidad única para actualizar y fortalecer sus conocimientos, habilidades y destrezas\r\nen el campo de la Medicina Forense y Legal. Los profesionales capacitados en esta área\r\ndesempeñan roles cruciales en la administración de justicia y en la protección de los\r\nderechos individuales, de la misma manera, estarán capacitados para desempeñarse en\r\nuna variedad de roles, incluyendo la consultoría, el peritaje, la investigación y la asesoría\r\nforense en el ámbito sanitario y jurídico. Su formación les permitirá contribuir de manera\r\nsignificativa a la búsqueda de la verdad y la justicia en contextos legales y forenses.\r\nEl término \"forense\" abarca todo lo relacionado con la ley y lo legal. En el contexto de la\r\nciencia forense, los profesionales se adentran en la intersección entre la salud y la justicia.\r\nLa Medicina Legal y Forense abarca diversas sub especialidades, y quienes la practican\r\npueden asumir múltiples roles en diferentes escenarios del sector público de salud. Estos\r\nprofesionales, capacitados en Medicina Legal y Forense, intervienen en aspectos legales\r\nde la comunidad, recopilan evidencia en escenarios de crimen, interrogan a víctimas de\r\ncrímenes y pueden participar en la determinación de la causa y el momento de la muerte.\r\nAdemás, brindan asesoramiento a individuos con antecedentes criminales o a infractores\r\ncon trastornos emocionales. La Medicina Legal y Forense ha surgido como una respuesta\r\nintegral y multidisciplinaria en el Sistema de Justicia Criminal, llenando vacíos que existían\r\nen este sistema. Con un enfoque interdisciplinario, los profesionales de la Medicina Legal\r\ny Forense desempeñan un papel esencial en la búsqueda de la verdad y la justicia.', 'TODOS LOS MÉDICOS, ENFERMERAS (OS), ABOGADOS,\r\nPOLICÍAS, MILITARES, CUERPO DE SEGURIDAD EN GENERAL, PERSONAL DE SALUD Y\r\nPROFESIONALES CON DESEOS DE INCURSIONAR EN EL CAMPO DE LA MEDICINA LEGAL\r\nY FORENSE.', 200, 'ACTIVO', NULL, 1, '2026-02-18 00:48:17', '2026-03-04 12:35:34'),
(8, 'EJEMPLO 001', 'DIPLOMADO EJEMPLO', '', '', 200, 'ACTIVO', 1, 1, '2026-03-04 16:27:11', '2026-03-05 16:26:16'),
(9, 'DCS-DIP-EN-001', 'DIPLOMADOS PARA ENFERMERÍA', 'Estimado participante, le damos la mas cordial bienvenida. Esta pagina es de carácter\r\ninformativo en relación con los Diplomados ofertados para los Profesionales de\r\nEnfermería, para nosotros es un placer atenderte. La Universidad Centroccidental\r\n\"Lisandro Alvarado\" se complace en anunciar la oferta académica NOVIEMBRE 2025 para\r\nla Carrera de Enfermería, Diplomados con una duración de 200 horas (5 MESES).\r\nEl objetivo principal de los Diplomados es actualizar los conocimientos de los\r\nProfesionales de Enfermería en las diversas áreas de competencia, mediante la\r\nintegración de conocimientos teóricos y prácticos para el desarrollo de habilidades y\r\ndestrezas.\r\nLas clases teóricas serán semi presenciales en el Decanato de Ciencias de la Salud de la\r\nUCLA los días sábados cada 15 días (sujeto a modificaciones) en el horario diurno (de\r\n8am a 2pm), dirigidas por un equipo multidisciplinario de alto nivel quienes serán los\r\nencargados de formar un Profesional integral con visión humanista. Las prácticas serán 1\r\nvez por semana , luego del periodo teórico, bajo un modelo andrológico desarrolladas en\r\nlos escenarios clínicos públicos o privados más importantes con los cuales se mantiene el\r\nconvenio, que permitirá al participante alcanzar su máximo potencial según los\r\nparámetros establecidos a nivel nacional e Internacional según las normas estipuladas por\r\nlos Coordinadores del Diplomado.\r\n', 'Técnicos Superior en Enfermería o Licenciados en\r\nEnfermería.\r\n', 200, 'ACTIVO', 1, 1, '2026-03-17 02:26:52', '2026-03-17 03:05:20');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_diplomados_conditions`
--

CREATE TABLE `tbl_diplomados_conditions` (
  `id` int(11) NOT NULL,
  `diplomado_id` int(11) NOT NULL,
  `condition_text` text NOT NULL COMMENT 'Ej: La nota mínima aprobatoria es 15 puntos',
  `order_priority` int(2) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `tbl_diplomados_conditions`
--

INSERT INTO `tbl_diplomados_conditions` (`id`, `diplomado_id`, `condition_text`, `order_priority`) VALUES
(33, 2, 'La nota mínima aprobatoria del diplomado es de 15 puntos.', 1),
(34, 2, 'El participante debe mantenerse solvente y cumplir con las cuotas establecidas para\r\nmantenerse activo dentro del Diplomado.', 1),
(35, 2, 'El dinero no es reembolsable ni es transferible a otro participante bajo ninguna causa.', 1),
(36, 2, 'En caso de insolvencia el participante estará sujeto a las políticas administrativas\r\nestablecidas por el Diplomado.', 1),
(45, 1, 'El participante debe mantenerse solvente y cumplir con las cuotas establecidas para mantenerse activo dentro del Diplomado.', 1),
(46, 1, 'El dinero no es reembolsable ni es transferible a otro participante bajo ninguna causa.', 1),
(47, 1, 'En caso de insolvencia el participante estará sujeto a las políticas administrativas establecidas por el Diplomado.', 1),
(48, 1, 'La nota mínima aprobatoria del diplomado es 15 puntos.', 1),
(73, 9, 'El participante debe mantenerse solvente y cumplir con las cuotas establecidas para\r\nmantenerse activo dentro del Diplomado.\r\n', 1),
(74, 9, ' El dinero no es reembolsable ni es transferible a otro participante bajo ninguna causa.', 1),
(75, 9, ' En caso de insolvencia el participante estará sujeto a las políticas administrativas\r\nestablecidas por el Diplomado', 1),
(76, 9, 'La nota mínima aprobatoria del diplomado es 15 puntos.\r\n', 1);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_diplomados_requirements`
--

CREATE TABLE `tbl_diplomados_requirements` (
  `id` int(11) NOT NULL,
  `diplomado_id` int(11) NOT NULL,
  `requirement_text` varchar(255) NOT NULL COMMENT 'Ej: Copia del Título Universitario',
  `is_mandatory` tinyint(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `tbl_diplomados_requirements`
--

INSERT INTO `tbl_diplomados_requirements` (`id`, `diplomado_id`, `requirement_text`, `is_mandatory`) VALUES
(41, 2, 'Profesionales del área de Ciencias de la Salud, Ciencias Jurídicas, Cs Sociales y\r\nPoliciales que se desempeñen con interés de actualizarse o que deseen incursionar en el\r\nÁrea de la Medicina legal y Ciencias Forenses.', 1),
(42, 2, 'Planilla de Inscripción. Esta planilla será enviada al correo registrado en la pre\r\ninscripción.', 1),
(43, 2, 'Cancelar la inscripción (Dólares en físico) o pago móvil. También se pueden realizar\r\nadelanto de cuotas o pago total.', 1),
(44, 2, 'Copia del Título o constancia de trabajo según el caso.', 1),
(45, 2, 'Copia de la cédula.', 1),
(56, 1, 'Ser Médico, Técnico Superior en Enfermería, Licenciado en Enfermería o Profesional en el área de Ciencias de la Salud.', 1),
(57, 1, 'Planilla de Inscripción. Esta planilla será enviada al correo electrónico registrado inmediatamente luego de la pre inscripción (IMPRIMIR 2 PLANILLAS).', 1),
(58, 1, 'Cancelar la inscripción (Dólares en físico) o pago móvil. También se pueden realizar adelanto de cuotas o pago total.', 1),
(59, 1, 'Copia del Título Universitario.', 1),
(60, 1, 'Copia de la cédula.', 1),
(90, 9, 'Ser Técnico Superior en Enfermería o Licenciado en Enfermería', 1),
(91, 9, 'Planilla de Inscripción. Esta planilla será enviada al correo electrónico registrado\r\ninmediatamente luego de la pre inscripción (IMPRIMIR 2 PLANILLAS).\r\n', 1),
(92, 9, 'Cancelar la inscripción (Dólares en físico) o pago móvil. También se pueden realizar\r\nadelanto de cuotas o pago total.\r\n', 1),
(93, 9, 'Copia del Título Universitario TSU o LCDO', 1),
(94, 9, 'Copia de la cédula.', 1),
(95, 9, ' En el caso del Diplomado en Especialidades Quirúrgicas, debe tener APROBADO el\r\nDiplomado de Instrumentación Quirúrgica y Cuidados Post Anestésicos', 1);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_email_settings`
--

CREATE TABLE `tbl_email_settings` (
  `id` int(11) NOT NULL,
  `tipo_correo` enum('INSCRIPCION','DOCUMENTOS','RECUPERACION') NOT NULL,
  `smtp_host` varchar(255) DEFAULT NULL,
  `smtp_port` int(11) DEFAULT NULL,
  `smtp_security` enum('TLS','SSL','NONE') DEFAULT NULL,
  `smtp_user` varchar(255) DEFAULT NULL,
  `smtp_password` varchar(255) DEFAULT NULL,
  `from_name` varchar(255) DEFAULT NULL,
  `from_email` varchar(255) DEFAULT NULL,
  `reply_to` varchar(255) DEFAULT NULL,
  `asunto` varchar(255) DEFAULT NULL,
  `contenido` longtext DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `tbl_email_settings`
--

INSERT INTO `tbl_email_settings` (`id`, `tipo_correo`, `smtp_host`, `smtp_port`, `smtp_security`, `smtp_user`, `smtp_password`, `from_name`, `from_email`, `reply_to`, `asunto`, `contenido`, `created_at`, `updated_at`) VALUES
(1, 'INSCRIPCION', 'mail.plataformadiplomados.com', 465, 'SSL', 'info@plataformadiplomados.com', 'i1;r+e}kmkoBDJ!W', 'Soporte de Inscripción Plataforma Diplomados', 'info@plataformadiplomados.com', NULL, 'Confirma tu registro en Plataforma Diplomados', '<!doctype html>\r\n<html>\r\n<body style=\"margin:0; padding:0; font-family: Arial, sans-serif; color:#333; line-height:1.5;\">\r\n\r\n<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\r\n  <tr>\r\n    <td align=\"center\">\r\n\r\n      <table width=\"600\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" style=\"padding:20px;\">\r\n\r\n        <tr>\r\n          <td>\r\n\r\n            <p>Hola {nombre} {apellido},</p>\r\n\r\n            <p>\r\n              Gracias por registrarte en Plataforma Diplomados.\r\n            </p>\r\n\r\n            <p>\r\n              Para completar la activación de tu cuenta, haz clic en el siguiente botón:\r\n            </p>\r\n\r\n            <!-- BOTÓN -->\r\n            <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" style=\"margin:20px 0;\">\r\n              <tr>\r\n                <td align=\"center\" bgcolor=\"#1a73e8\" style=\"border-radius:4px;\">\r\n                  <a href=\"{link_inscripcion}\" \r\n                     style=\"display:inline-block; padding:12px 20px; color:#ffffff; text-decoration:none; font-family:Arial, sans-serif; font-size:14px;\">\r\n                    Confirmar mi cuenta\r\n                  </a>\r\n                </td>\r\n              </tr>\r\n            </table>\r\n\r\n            <p>\r\n              Si no puedes hacer clic en el botón, copia y pega el siguiente enlace en tu navegador:\r\n            </p>\r\n\r\n            <p style=\"word-break: break-all;\">\r\n              {link_inscripcion}\r\n            </p>\r\n\r\n            <p>\r\n              Si no realizaste este registro, puedes ignorar este mensaje.\r\n            </p>\r\n\r\n            <p>\r\n              Saludos,<br>\r\n              Equipo Plataforma Diplomados\r\n            </p>\r\n\r\n          </td>\r\n        </tr>\r\n\r\n      </table>\r\n\r\n    </td>\r\n  </tr>\r\n</table>\r\n\r\n</body>\r\n</html>\r\n', '2026-02-16 18:29:44', '2026-02-16 19:12:35'),
(2, 'DOCUMENTOS', 'mail.plataformadiplomados.com', 465, 'SSL', 'info@plataformadiplomados.com', 'i1;r+e}kmkoBDJ!W', 'Soporte de Certificados Plataforma Diplomados ', 'info@plataformadiplomados.com', NULL, 'Tu constancia está disponible para descarga', '<!doctype html>\r\n<html lang=\"es\">\r\n<body style=\"margin:0; padding:0; font-family: Arial, sans-serif; color:#333; line-height:1.5;\">\r\n\r\n<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\r\n  <tr>\r\n    <td align=\"center\">\r\n\r\n      <table width=\"600\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" style=\"padding:20px;\">\r\n        <tr>\r\n          <td>\r\n\r\n            <p>Hola {nombre} {apellido},</p>\r\n\r\n            <p>\r\n              Tu constancia de estudio ya está disponible en <strong>Plataforma Diplomados Online</strong>.\r\n            </p>\r\n\r\n            <p>\r\n              Para descargarla, haz clic en el siguiente botón:\r\n            </p>\r\n\r\n            <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" style=\"margin:20px 0;\">\r\n              <tr>\r\n                <td align=\"center\" bgcolor=\"#1a73e8\" style=\"border-radius:4px;\">\r\n                  <a href=\"{link_descarga}\"\r\n                     style=\"display:inline-block; padding:12px 20px; color:#ffffff; text-decoration:none; font-family:Arial, sans-serif; font-size:14px;\">\r\n                    Descargar constancia\r\n                  </a>\r\n                </td>\r\n              </tr>\r\n            </table>\r\n\r\n            <p>\r\n              Si no puedes hacer clic en el botón, copia y pega el siguiente enlace en tu navegador:\r\n            </p>\r\n\r\n            <p style=\"word-break: break-all;\">\r\n              {link_descarga}\r\n            </p>\r\n\r\n            <p>\r\n              Si no solicitaste esta constancia, puedes ignorar este mensaje.\r\n            </p>\r\n\r\n            <p>\r\n              Saludos,<br>\r\n              Equipo Plataforma Diplomados Online\r\n            </p>\r\n\r\n          </td>\r\n        </tr>\r\n      </table>\r\n\r\n    </td>\r\n  </tr>\r\n</table>\r\n\r\n</body>\r\n</html>\r\n', '2026-02-16 18:30:18', '2026-02-16 21:10:26'),
(23, 'RECUPERACION', 'mail.plataformadiplomados.com', 465, 'SSL', 'info@plataformadiplomados.com', 'i1;r+e}kmkoBDJ!W', 'Soporte de Recuperación Plataforma Diplomados', 'info@plataformadiplomados.com', NULL, 'Recupera tu contraseña en Plataforma Diplomados', '<!doctype html><html><body style=\"font-family: Arial; color:#333;\"><p>Hola {{nombre}} {{apellido}},</p><p>Para recuperar tu contraseña en Plataforma Diplomados, haz clic en el siguiente botón:</p><div style=\"margin:20px 0;\"><a href=\"{{link_inscripcion}}\" style=\"background:#1a73e8; color:#ffffff; padding:12px 20px; text-decoration:none; border-radius:4px;\">Cambiar mi contraseña</a></div><p>Si no puedes hacer clic, usa este enlace:<br>{{link_inscripcion}}</p><p>Saludos,<br>Equipo Plataforma Diplomados</p></body></html>', '2026-02-17 00:40:14', '2026-02-17 00:40:14');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_enrollments`
--

CREATE TABLE `tbl_enrollments` (
  `id` int(11) NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `offering_id` int(11) NOT NULL,
  `undergraduate_degree` varchar(255) DEFAULT 'N/A',
  `provenance` varchar(255) DEFAULT 'N/A',
  `doc_id_card` varchar(255) DEFAULT NULL,
  `doc_degree` varchar(255) DEFAULT NULL,
  `doc_cv` varchar(255) DEFAULT NULL,
  `status` enum('REVISION','COMPROMISO','APROBADO','RECHAZADO') NOT NULL,
  `observations` text DEFAULT NULL,
  `type` enum('AUTO','MANUAL') DEFAULT 'AUTO',
  `created_by` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `tbl_enrollments`
--

INSERT INTO `tbl_enrollments` (`id`, `user_id`, `offering_id`, `undergraduate_degree`, `provenance`, `doc_id_card`, `doc_degree`, `doc_cv`, `status`, `observations`, `type`, `created_by`, `created_at`, `updated_at`) VALUES
(1, 23, 6, 'Medico Cirujano', 'Barquisimeto', 'uploads/enrollments/23/DOC_23_doc_id_1775183100.pdf', 'uploads/enrollments/23/DOC_23_doc_degree_1775183101.pdf', 'uploads/enrollments/23/DOC_23_doc_cv_1775183101.pdf', 'APROBADO', NULL, 'AUTO', 23, '2026-04-03 02:25:01', '2026-04-03 03:09:06'),
(2, 22, 6, 'Ingeniero', 'Barquisimeto', 'uploads/enrollments/22/DOC_22_doc_id_1775185994.pdf', 'uploads/enrollments/22/DOC_22_doc_degree_1775185994.pdf', 'uploads/enrollments/22/DOC_22_doc_cv_1775185994.pdf', 'APROBADO', NULL, 'AUTO', 22, '2026-04-03 03:13:14', '2026-04-03 03:25:21'),
(3, 21, 6, 'Medicina', 'Cabudare', 'uploads/enrollments/21/DOC_21_doc_id_1775186960.pdf', 'uploads/enrollments/21/DOC_21_doc_degree_1775186960.pdf', 'uploads/enrollments/21/DOC_21_doc_cv_1775186960.pdf', 'APROBADO', NULL, 'MANUAL', 1, '2026-04-03 03:29:20', '2026-04-03 03:31:36'),
(4, 24, 6, 'Medico Cirujano', 'Yaracuy', 'uploads/enrollments/24/DOC_24_doc_id_1775187948.pdf', 'uploads/enrollments/24/DOC_24_doc_degree_1775187948.pdf', 'uploads/enrollments/24/DOC_24_doc_cv_1775187948.pdf', 'APROBADO', NULL, 'MANUAL', 1, '2026-04-03 03:45:48', '2026-04-03 03:47:25');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_enrollments_payments`
--

CREATE TABLE `tbl_enrollments_payments` (
  `id` int(11) NOT NULL,
  `enrollment_id` int(11) NOT NULL,
  `method` enum('CASH','ZELLE','BINANCE','PAGOMOVIL') NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `currency` varchar(10) NOT NULL DEFAULT 'USD',
  `reference_id` varchar(100) DEFAULT NULL,
  `payment_metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`payment_metadata`)),
  `screenshot_path` varchar(255) DEFAULT NULL,
  `status` enum('PENDING','APPROVED','REJECTED') DEFAULT 'PENDING',
  `observation` text DEFAULT NULL,
  `validated_by` int(10) UNSIGNED DEFAULT NULL,
  `rejection_reason` text DEFAULT NULL,
  `validation_date` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `import_batch_id` int(11) DEFAULT NULL COMMENT 'ID de la carga masiva de Excel'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `tbl_enrollments_payments`
--

INSERT INTO `tbl_enrollments_payments` (`id`, `enrollment_id`, `method`, `amount`, `currency`, `reference_id`, `payment_metadata`, `screenshot_path`, `status`, `observation`, `validated_by`, `rejection_reason`, `validation_date`, `created_at`, `import_batch_id`) VALUES
(1, 1, 'PAGOMOVIL', 28443.59, 'BS', '887766', '{\"metodo\":\"PAGOMOVIL\",\"monto_sistema_usd\":0,\"tasa_cambio\":474.0598,\"detalles_origen\":{\"identificador\":\"21301474\",\"cuenta_correo_telf\":\"0412-4571599\",\"nombre_titular\":\"NO_SUMINISTRADO\",\"banco_emisor\":\"0134 - BANESCO\"},\"detalles_transaccion\":{\"referencia\":\"887766\",\"fecha_comprobante\":\"2026-04-02\",\"monto_nativo\":28443.59,\"moneda_nativa\":\"BS\"},\"auditoria\":{\"fecha_registro\":\"2026-04-03 04:25:01\",\"agente\":\"23 - Reactor Nuclear\"}}', 'uploads/enrollments/23/payment/DOC_23_pay_screenshot_1775183101.png', 'APPROVED', NULL, 1, NULL, '2026-04-03 03:08:47', '2026-04-03 02:25:01', NULL),
(2, 2, 'CASH', 60.00, 'USD', 'CASH-989811', '{\"tipo_validacion\":\"ARQUEO_FISICO\",\"desglose_billetes\":{\"1\":0,\"5\":0,\"10\":1,\"20\":0,\"50\":1,\"100\":0},\"auditoria\":{\"agente_receptor\":1,\"fecha_recepcion\":\"2026-04-03 05:24:35\"}}', NULL, 'APPROVED', NULL, 1, NULL, '2026-04-03 03:24:35', '2026-04-03 03:13:14', NULL),
(3, 3, 'BINANCE', 60.00, 'USDT', 'XDXD124578', '{\"metodo\":\"BINANCE\",\"monto_sistema_usd\":60,\"tasa_cambio\":1,\"detalles_origen\":{\"identificador\":\"149795231\",\"cuenta_correo_telf\":\"gorgepereira@gmail.com\",\"nombre_titular\":\"BINANCE_PAY\",\"banco_emisor\":\"BINANCE PAY\"},\"detalles_transaccion\":{\"referencia\":\"XDXD124578\",\"fecha_comprobante\":\"2026-04-02\",\"monto_nativo\":60,\"moneda_nativa\":\"USDT\"},\"auditoria\":{\"fecha_registro\":\"2026-04-03 05:29:20\",\"agente\":1}}', 'uploads/enrollments/21/payment/DOC_21_pay_screenshot_1775186960.jpeg', 'APPROVED', NULL, 1, NULL, '2026-04-03 03:30:04', '2026-04-03 03:29:20', NULL),
(4, 4, 'ZELLE', 60.00, 'USD', 'POL123654', '{\"metodo\":\"ZELLE\",\"monto_sistema_usd\":60,\"tasa_cambio\":1,\"detalles_origen\":{\"identificador\":\"21301474\",\"cuenta_correo_telf\":\"prueba@prueba.com\",\"nombre_titular\":\"Jorge Pereira\",\"banco_emisor\":\"ZELLE\"},\"detalles_transaccion\":{\"referencia\":\"POL123654\",\"fecha_comprobante\":\"2026-04-02\",\"monto_nativo\":60,\"moneda_nativa\":\"USD\"},\"auditoria\":{\"fecha_registro\":\"2026-04-03 05:45:48\",\"agente\":1}}', 'uploads/enrollments/24/payment/DOC_24_pay_screenshot_1775187948.png', 'APPROVED', NULL, 1, NULL, '2026-04-03 03:47:04', '2026-04-03 03:45:48', NULL);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_event_catalog`
--

CREATE TABLE `tbl_event_catalog` (
  `id` int(10) UNSIGNED NOT NULL,
  `event_code` varchar(30) NOT NULL,
  `event_type` enum('SECURITY','ACADEMIC','FINANCIAL','SYSTEM','DOCUMENT') NOT NULL,
  `severity` enum('LOW','MEDIUM','HIGH','CRITICAL') NOT NULL DEFAULT 'LOW',
  `title` varchar(120) NOT NULL,
  `message_template` varchar(255) NOT NULL,
  `status` enum('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_event_logs`
--

CREATE TABLE `tbl_event_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `event_catalog_id` int(10) UNSIGNED NOT NULL,
  `event_code` varchar(30) NOT NULL,
  `user_id` int(10) UNSIGNED DEFAULT NULL,
  `role_key` varchar(60) DEFAULT NULL,
  `session_id` int(10) UNSIGNED DEFAULT NULL,
  `module_key` varchar(60) DEFAULT NULL,
  `action_key` varchar(60) DEFAULT NULL,
  `result` enum('SUCCESS','FAIL') NOT NULL DEFAULT 'SUCCESS',
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  `entity_table` varchar(80) DEFAULT NULL,
  `entity_id` bigint(20) UNSIGNED DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `occurred_at` datetime NOT NULL DEFAULT current_timestamp(),
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_financial_bank_transactions_mobile`
--

CREATE TABLE `tbl_financial_bank_transactions_mobile` (
  `id` int(11) NOT NULL,
  `op_type` varchar(5) DEFAULT 'NC',
  `op_date` date DEFAULT NULL,
  `reference_id` varchar(25) DEFAULT NULL,
  `origin_phone` varchar(25) DEFAULT NULL,
  `origin_bank` varchar(150) DEFAULT NULL,
  `amount` decimal(18,2) DEFAULT NULL,
  `is_reconciled` tinyint(1) DEFAULT 0,
  `admin_id` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='Registro de transacciones de Pago Móvil conciliadas o por conciliar - Mod. Finanzas';

--
-- Volcado de datos para la tabla `tbl_financial_bank_transactions_mobile`
--

INSERT INTO `tbl_financial_bank_transactions_mobile` (`id`, `op_type`, `op_date`, `reference_id`, `origin_phone`, `origin_bank`, `amount`, `is_reconciled`, `admin_id`, `created_at`) VALUES
(392, 'NC', '2026-03-15', '3860134', '4124571599', 'BANCO PROVINCIAL S.A. BANCO UNIVERSAL', 14221.79, 1, 1, '2026-04-03 22:35:33'),
(393, 'NC', '2026-03-15', '204329007969', '4124571599', 'BANCO PROVINCIAL S.A. BANCO UNIVERSAL', 15.00, 0, 1, '2026-04-03 22:35:33'),
(394, 'NC', '2026-03-15', '204353007971', '4124571599', 'BANCO PROVINCIAL S.A. BANCO UNIVERSAL', 20.00, 0, 1, '2026-04-03 22:35:33'),
(395, 'NC', '2026-03-15', '204448007973', '4124571599', 'BANCO PROVINCIAL S.A. BANCO UNIVERSAL', 25.00, 0, 1, '2026-04-03 22:35:33'),
(396, 'NC', '2026-03-15', '204633007975', '4124571599', 'BANCO PROVINCIAL S.A. BANCO UNIVERSAL', 30.00, 0, 1, '2026-04-03 22:35:33'),
(397, 'NC', '2026-03-15', '204757007977', '4124571599', 'BANCO PROVINCIAL S.A. BANCO UNIVERSAL', 36.00, 0, 1, '2026-04-03 22:35:33'),
(398, 'NC', '2026-03-15', '204830007979', '4124571599', 'BANCO PROVINCIAL S.A. BANCO UNIVERSAL', 19.00, 0, 1, '2026-04-03 22:35:33'),
(399, 'NC', '2026-03-08', '102931019041', '4245178964', 'BANCO PROVINCIAL S.A. BANCO UNIVERSAL', 1724045.00, 0, 1, '2026-04-03 22:35:33'),
(400, 'NC', '2026-03-08', '48311480140', '4241857421', 'BANCO MERCANTIL', 63184.00, 0, 1, '2026-04-03 22:35:33'),
(401, 'NC', '2026-03-03', '5263865266', '4245502553', 'BANCO DE VENEZUELA S.A. BANCO UNIVERSAL', 2300.00, 0, 1, '2026-04-03 22:35:33'),
(402, 'NC', '2026-03-02', '220212618781', '4143578773', 'BANCAMIGA BANCO UNIVERSAL, C.A.', 1900.00, 0, 1, '2026-04-03 22:35:33'),
(403, 'NC', '2026-03-02', '5258463576', '4127884363', 'BANCO DE VENEZUELA S.A. BANCO UNIVERSAL', 3000.00, 0, 1, '2026-04-03 22:35:33'),
(416, 'NC', '2026-03-15', '204245007967', '4124571599', 'BANCO PROVINCIAL S.A. BANCO UNIVERSAL', 10.00, 1, 1, '2026-04-03 23:34:55');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_financial_exchange_rates`
--

CREATE TABLE `tbl_financial_exchange_rates` (
  `id` int(10) UNSIGNED NOT NULL,
  `rate_date` date NOT NULL COMMENT 'Fecha a la que aplica la tasa',
  `dolar_bcv` decimal(10,4) NOT NULL,
  `euro_bcv` decimal(10,4) NOT NULL,
  `user_id` int(11) NOT NULL COMMENT 'Usuario que registró la tasa',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `status` enum('ACTIVE','INACTIVE') DEFAULT 'ACTIVE'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `tbl_financial_exchange_rates`
--

INSERT INTO `tbl_financial_exchange_rates` (`id`, `rate_date`, `dolar_bcv`, `euro_bcv`, `user_id`, `created_at`, `updated_at`, `status`) VALUES
(2, '2026-03-26', 466.6014, 540.1704, 1, '2026-03-26 12:23:12', '2026-03-26 12:23:12', 'ACTIVE'),
(3, '2026-03-29', 471.7004, 543.9413, 1, '2026-03-29 17:21:08', '2026-03-29 17:21:08', 'ACTIVE'),
(4, '2026-03-31', 473.8702, 542.6382, 1, '2026-03-31 12:00:24', '2026-03-31 12:00:24', 'ACTIVE'),
(5, '2026-04-01', 473.9176, 545.9483, 1, '2026-04-01 11:16:18', '2026-04-01 11:16:18', 'ACTIVE'),
(6, '2026-04-02', 474.0598, 550.8954, 1, '2026-04-02 18:25:00', '2026-04-02 18:25:00', 'ACTIVE'),
(8, '2026-04-03', 474.0598, 550.8954, 1, '2026-04-03 18:54:26', '2026-04-03 18:54:26', 'ACTIVE');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_financial_payments`
--

CREATE TABLE `tbl_financial_payments` (
  `id` int(11) NOT NULL,
  `student_id` int(11) NOT NULL COMMENT 'ID del estudiante en tbl_students',
  `matriculation_id` int(11) NOT NULL COMMENT 'ID de la matrícula en tbl_student_matriculations',
  `method` enum('CASH','ZELLE','BINANCE','PAGOMOVIL') NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `currency` varchar(10) NOT NULL DEFAULT 'USD',
  `reference_id` varchar(100) DEFAULT NULL,
  `payment_metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`payment_metadata`)),
  `screenshot_path` varchar(255) DEFAULT NULL COMMENT 'Comprobante si es digital',
  `status` enum('PENDING','APPROVED','REJECTED') DEFAULT 'PENDING',
  `observation` text DEFAULT NULL,
  `collector_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'Usuario que registra el pago',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `tbl_financial_payments`
--

INSERT INTO `tbl_financial_payments` (`id`, `student_id`, `matriculation_id`, `method`, `amount`, `currency`, `reference_id`, `payment_metadata`, `screenshot_path`, `status`, `observation`, `collector_id`, `created_at`) VALUES
(34, 9, 11, 'ZELLE', 10.00, 'USD', '1497523', '{\"metodo\":\"ZELLE\",\"monto_sistema_usd\":10,\"tasa_cambio\":474.06,\"detalles_origen\":{\"identificador\":\"DCS-2026-I-002\",\"cuenta_correo_telf\":\"prueba@prueba.com\",\"nombre_titular\":\"JORGE PEREIRA\",\"banco_emisor\":\"N\\/A\"},\"detalles_transaccion\":{\"referencia\":\"1497523\",\"fecha_comprobante\":\"2026-04-03\",\"monto_nativo\":10,\"moneda_nativa\":\"USD\"},\"auditoria\":{\"fecha_registro\":\"2026-04-04 04:35:11\",\"agente\":1}}', 'uploads/enrollments/22/payment/DOC_22_pay_1775270111_1b3b60c4.png', 'APPROVED', NULL, 1, '2026-04-04 02:35:11'),
(35, 9, 11, 'BINANCE', 10.00, 'USD', '149795231', '{\"metodo\":\"BINANCE\",\"monto_sistema_usd\":10,\"tasa_cambio\":474.06,\"detalles_origen\":{\"identificador\":\"DCS-2026-I-002\",\"cuenta_correo_telf\":\"N\\/A\",\"nombre_titular\":\"N\\/A\",\"banco_emisor\":\"N\\/A\"},\"detalles_transaccion\":{\"referencia\":\"149795231\",\"fecha_comprobante\":\"2026-04-03\",\"monto_nativo\":10,\"moneda_nativa\":\"USDT\"},\"auditoria\":{\"fecha_registro\":\"2026-04-04 04:46:40\",\"agente\":1}}', 'uploads/enrollments/22/payment/DOC_22_pay_1775270800_9018593b.jpeg', 'APPROVED', NULL, 1, '2026-04-04 02:46:40'),
(36, 9, 11, 'BINANCE', 10.00, 'USD', 'asdf', '{\"metodo\":\"BINANCE\",\"monto_sistema_usd\":10,\"tasa_cambio\":474.06,\"detalles_origen\":{\"identificador\":\"DCS-2026-I-002\",\"cuenta_correo_telf\":\"N\\/A\",\"nombre_titular\":\"N\\/A\",\"banco_emisor\":\"N\\/A\"},\"detalles_transaccion\":{\"referencia\":\"asdf\",\"fecha_comprobante\":\"2026-04-03\",\"monto_nativo\":10,\"moneda_nativa\":\"USDT\"},\"auditoria\":{\"fecha_registro\":\"2026-04-04 04:54:47\",\"agente\":1}}', 'uploads/enrollments/22/payment/DOC_22_pay_1775271287_f56e0cb1.jpeg', 'APPROVED', NULL, 1, '2026-04-04 02:54:47'),
(37, 9, 11, 'CASH', 15.00, 'USD', 'CASH-000441', '{\"metodo\":\"CASH\",\"monto_sistema_usd\":15,\"tasa_cambio\":1,\"detalles_origen\":{\"identificador\":\"DCS-2026-I-002\",\"cuenta_correo_telf\":\"RECEPCIÓN\",\"nombre_titular\":\"DEMETRIO OLIVARES ARGÜELLES\",\"banco_emisor\":\"CASH\"},\"detalles_transaccion\":{\"referencia\":\"CASH-000441\",\"fecha_comprobante\":\"2026-04-04\",\"monto_nativo\":15,\"moneda_nativa\":\"USD\"},\"auditoria\":{\"fecha_registro\":\"2026-04-04 16:30:03\",\"agente\":1},\"arqueo_caja\":{\"desglose\":{\"5\":1,\"10\":1},\"monto_fisico\":15,\"moneda_fisica\":\"USD\",\"validado_por\":1,\"fecha_validacion\":\"2026-04-04 16:45:08\"}}', NULL, 'APPROVED', NULL, 1, '2026-04-04 14:30:03');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_financial_student_ledger`
--

CREATE TABLE `tbl_financial_student_ledger` (
  `id` int(11) NOT NULL,
  `enrollment_id` int(11) NOT NULL,
  `payment_id` int(11) DEFAULT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `concept` varchar(150) NOT NULL,
  `amount_due` decimal(12,2) NOT NULL,
  `amount_paid` decimal(12,2) DEFAULT 0.00,
  `exchange_rate` decimal(12,4) DEFAULT 1.0000,
  `due_date` date NOT NULL,
  `processed_at` datetime DEFAULT NULL,
  `status` enum('PENDIENTE','PAGADO','VENCIDO','ABONADO','A FAVOR') NOT NULL DEFAULT 'PENDIENTE',
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `tbl_financial_student_ledger`
--

INSERT INTO `tbl_financial_student_ledger` (`id`, `enrollment_id`, `payment_id`, `user_id`, `concept`, `amount_due`, `amount_paid`, `exchange_rate`, `due_date`, `processed_at`, `status`, `notes`) VALUES
(1, 1, 1, 23, 'INSCRIPCIÓN', 30.00, 30.00, 474.0598, '2026-03-15', '2026-04-02 23:08:47', 'PAGADO', NULL),
(2, 1, 1, 23, 'CUOTA 1', 30.00, 30.00, 474.0598, '2026-03-15', '2026-04-02 23:08:47', 'PAGADO', NULL),
(3, 1, NULL, 23, 'CUOTA 2', 30.00, 0.00, 474.0598, '2026-03-15', '2026-04-02 23:08:47', 'PENDIENTE', NULL),
(4, 1, NULL, 23, 'CUOTA 3', 30.00, 0.00, 474.0598, '2026-03-15', '2026-04-03 20:42:38', 'PENDIENTE', NULL),
(5, 1, NULL, 23, 'CUOTA 4', 30.00, 0.00, 474.0598, '2026-03-15', '2026-04-02 23:08:47', 'PENDIENTE', NULL),
(6, 1, NULL, 23, 'CUOTA 5', 30.00, 0.00, 474.0598, '2026-03-15', '2026-04-02 23:08:47', 'PENDIENTE', NULL),
(13, 2, 2, 22, 'INSCRIPCIÓN', 30.00, 30.00, 1.0000, '2026-03-15', '2026-04-02 23:24:35', 'PAGADO', NULL),
(14, 2, 2, 22, 'CUOTA 1', 30.00, 30.00, 1.0000, '2026-03-15', '2026-04-02 23:24:35', 'PAGADO', NULL),
(15, 2, 36, 22, 'CUOTA 2', 30.00, 30.00, 1.0000, '2026-03-15', '2026-04-03 22:55:19', 'PAGADO', NULL),
(16, 2, 37, 22, 'CUOTA 3', 30.00, 15.00, 1.0000, '2026-03-15', '2026-04-04 10:45:08', 'ABONADO', NULL),
(17, 2, NULL, 22, 'CUOTA 4', 30.00, 0.00, 1.0000, '2026-03-15', '2026-04-03 20:44:35', 'PENDIENTE', NULL),
(18, 2, NULL, 22, 'CUOTA 5', 30.00, 0.00, 1.0000, '2026-03-15', '2026-04-02 23:24:35', 'PENDIENTE', NULL),
(19, 3, 3, 21, 'INSCRIPCIÓN', 30.00, 30.00, 1.0000, '2026-03-15', '2026-04-02 23:30:04', 'PAGADO', NULL),
(20, 3, 3, 21, 'CUOTA 1', 30.00, 30.00, 1.0000, '2026-03-15', '2026-04-02 23:30:04', 'PAGADO', NULL),
(21, 3, NULL, 21, 'CUOTA 2', 30.00, 0.00, 1.0000, '2026-03-15', '2026-04-02 23:30:04', 'PENDIENTE', NULL),
(22, 3, NULL, 21, 'CUOTA 3', 30.00, 0.00, 1.0000, '2026-03-15', '2026-04-02 23:30:04', 'PENDIENTE', NULL),
(23, 3, NULL, 21, 'CUOTA 4', 30.00, 0.00, 1.0000, '2026-03-15', '2026-04-02 23:30:04', 'PENDIENTE', NULL),
(24, 3, NULL, 21, 'CUOTA 5', 30.00, 0.00, 1.0000, '2026-03-15', '2026-04-02 23:30:04', 'PENDIENTE', NULL),
(25, 4, 4, 24, 'INSCRIPCIÓN', 30.00, 30.00, 1.0000, '2026-03-15', '2026-04-02 23:47:04', 'PAGADO', NULL),
(26, 4, 4, 24, 'CUOTA 1', 30.00, 30.00, 1.0000, '2026-03-15', '2026-04-02 23:47:04', 'PAGADO', NULL),
(27, 4, NULL, 24, 'CUOTA 2', 30.00, 0.00, 1.0000, '2026-03-15', '2026-04-02 23:47:04', 'PENDIENTE', NULL),
(28, 4, NULL, 24, 'CUOTA 3', 30.00, 0.00, 1.0000, '2026-03-15', '2026-04-02 23:47:04', 'PENDIENTE', NULL),
(29, 4, NULL, 24, 'CUOTA 4', 30.00, 0.00, 1.0000, '2026-03-15', '2026-04-02 23:47:04', 'PENDIENTE', NULL),
(30, 4, NULL, 24, 'CUOTA 5', 30.00, 0.00, 1.0000, '2026-03-15', '2026-04-02 23:47:04', 'PENDIENTE', NULL);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_grupos`
--

CREATE TABLE `tbl_grupos` (
  `id` int(11) NOT NULL,
  `diplomado_id` int(11) DEFAULT NULL,
  `name` varchar(100) NOT NULL COMMENT 'Ej: Grupo Viernes, Grupo Online',
  `modality` enum('Presencial','Virtual','Mixta') NOT NULL DEFAULT 'Presencial',
  `description` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1: Activo, 0: Eliminado/Inactivo',
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish_ci;

--
-- Volcado de datos para la tabla `tbl_grupos`
--

INSERT INTO `tbl_grupos` (`id`, `diplomado_id`, `name`, `modality`, `description`, `is_active`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, NULL, 'GRUPO VIERNES', 'Presencial', 'Clases cada 15 días en horario diurno (viernes)\r\n2:00 pm a 5:00 pm', 1, 1, NULL, '2026-02-19 05:01:33', NULL),
(2, NULL, 'GRUPO SABADO', 'Presencial', 'Clases cada 15 días en horario diurno (sábado)\r\n8:00 am a 12:00 m', 1, 1, 1, '2026-02-19 05:02:46', '2026-03-04 15:18:17'),
(3, NULL, 'ONLINE', 'Virtual', 'Clases en modalidad virtual', 1, 1, NULL, '2026-02-19 05:03:08', NULL),
(4, NULL, 'SEMI PRESENCIAL', 'Mixta', 'Clases combinadas presencial y online', 1, 1, NULL, '2026-02-19 05:03:30', NULL);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_permissions`
--

CREATE TABLE `tbl_permissions` (
  `id` int(10) UNSIGNED NOT NULL,
  `perm_key` varchar(80) NOT NULL,
  `module_key` varchar(60) NOT NULL,
  `action_key` varchar(60) NOT NULL,
  `description` varchar(255) NOT NULL,
  `status` enum('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_pre_users`
--

CREATE TABLE `tbl_pre_users` (
  `id` int(10) UNSIGNED NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `email` varchar(190) NOT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `document_id` varchar(60) DEFAULT NULL,
  `status` enum('PENDING','VERIFIED','EXPIRED','BLOCKED') NOT NULL DEFAULT 'PENDING',
  `email_verified` tinyint(1) NOT NULL DEFAULT 0,
  `temp_password_hash` varchar(255) DEFAULT NULL,
  `temp_password_expires_at` datetime DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `tbl_pre_users`
--

INSERT INTO `tbl_pre_users` (`id`, `first_name`, `last_name`, `email`, `phone`, `document_id`, `status`, `email_verified`, `temp_password_hash`, `temp_password_expires_at`, `created_at`, `updated_at`) VALUES
(13, 'JORGE LUIS', 'PEREIRA OLIVARES', 'gorgepereira@gmail.com', '(+58)-(414)-(536-5380)', '14979523', 'VERIFIED', 1, NULL, NULL, '2026-02-26 10:42:10', '2026-02-26 10:42:28'),
(14, 'DEMETRIO', 'OLIVARES ARGÜELLES', 'jorge@amarellus.ys', '(+58)-(414)-(536-5380)', '149795232', 'PENDING', 0, NULL, NULL, '2026-03-12 15:34:29', NULL),
(15, 'DEMETRIO', 'OLIVARES ARGÜELLES', 'jorge@amarellus.us', '(+58)-(414)-(536-5380)', '149795233', 'VERIFIED', 1, NULL, NULL, '2026-03-12 15:34:55', '2026-03-12 15:36:38'),
(16, 'Carlos', 'Paez', 'carlos@amarellus.com', '(+58)-(414)-(536-5380)', '13567117', 'PENDING', 0, NULL, NULL, '2026-04-02 22:16:55', NULL),
(17, 'Pedro', 'Gutierrez', 'terabit@amarellus.net', '(+58)-(414)-(504-2125)', '3679343', 'PENDING', 0, NULL, NULL, '2026-04-02 22:18:52', NULL),
(18, 'Reactor', 'Nuclear', 'plataformadiplomados.com@gmail.com', '(+58)-(416)-(556-7845)', '21301474', 'VERIFIED', 1, NULL, NULL, '2026-04-02 22:21:41', '2026-04-02 22:22:32');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_pre_user_tokens`
--

CREATE TABLE `tbl_pre_user_tokens` (
  `id` int(11) UNSIGNED NOT NULL,
  `pre_user_id` int(11) DEFAULT NULL,
  `token_hash` varchar(255) NOT NULL,
  `expires_at` datetime NOT NULL,
  `used_at` datetime DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `tbl_pre_user_tokens`
--

INSERT INTO `tbl_pre_user_tokens` (`id`, `pre_user_id`, `token_hash`, `expires_at`, `used_at`, `created_at`) VALUES
(11, 13, '927f1fa70bd645847e8485167aa5ca3cfb203e4f2629e2628319aad89ea1c93f', '2026-02-27 10:42:10', '2026-02-26 10:42:28', '2026-02-26 10:42:10'),
(12, 14, 'aa34ab7ca9cc64cd751104ba60939cdf87df065eee0df6c97d7c97690765dd1c', '2026-03-13 15:34:29', NULL, '2026-03-12 15:34:29'),
(13, 15, '64ef9adee4f95f09cfdca0077924d1b592e904128e333c1032f6dd4f5f5e4b9e', '2026-03-13 15:34:55', '2026-03-12 15:36:38', '2026-03-12 15:34:55'),
(14, 16, 'b4ed48cb29fb875d86c105bb621593c87a5355f4f21a05a458c752bcd2e0e2e0', '2026-04-03 22:16:55', NULL, '2026-04-02 22:16:55'),
(15, 17, '8aae367f7f6bb2470b7c9a1a5aff0be60778309676c6691f00de01f60205b94b', '2026-04-03 22:18:52', NULL, '2026-04-02 22:18:52'),
(16, 18, '83b40f2e98d9d323ff1684d866ecb6810bedbb23d3902c2aa9b17070f6505ca0', '2026-04-03 22:21:41', '2026-04-02 22:22:32', '2026-04-02 22:21:41');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_professors`
--

CREATE TABLE `tbl_professors` (
  `id` int(11) NOT NULL,
  `identification` varchar(50) NOT NULL COMMENT 'DNI, Cédula o Pasaporte',
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `full_name` varchar(200) NOT NULL COMMENT 'Nombre completo concatenado para búsquedas rápidas',
  `professor_type` enum('Docente','Coordinador','Invitado','Tutor') NOT NULL DEFAULT 'Docente',
  `photo_path` varchar(255) DEFAULT NULL COMMENT 'Ruta de la foto de perfil',
  `biography` text DEFAULT NULL COMMENT 'Resumen profesional o perfil',
  `is_active` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1: Activo, 0: Inactivo/Eliminado',
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish_ci;

--
-- Volcado de datos para la tabla `tbl_professors`
--

INSERT INTO `tbl_professors` (`id`, `identification`, `first_name`, `last_name`, `full_name`, `professor_type`, `photo_path`, `biography`, `is_active`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(2, '14979523', 'Jorge Luis', 'Pereira Olivares', 'Jorge Luis Pereira Olivares', 'Docente', '/diplomatic/public/assets/uploads/profesores/prof_avatar_2_1771509776.png', 'CEO', 1, 1, 1, '2026-02-19 12:51:51', '2026-02-19 14:04:03'),
(3, '135671171', 'Luis Jorge', 'Olivares Pereira', 'Luis Jorge Olivares Pereira', 'Coordinador', '/diplomatic/public/assets/uploads/profesores/prof_avatar_3_1771510031.png', 'Coordinador Academico', 1, 6, 20, '2026-02-19 14:05:55', '2026-02-26 18:54:43'),
(6, '13567117', 'HOMER', 'PEREIRA', 'HOMER PEREIRA', 'Coordinador', '/diplomatic/public/assets/uploads/profesores/prof_6_1771588026.png', 'Coordinador Academico General', 1, 6, 1, '2026-02-19 14:53:10', '2026-03-04 15:29:22'),
(7, '21301474', 'RAIZA', 'BARROS', 'RAIZA BARROS', 'Docente', '/diplomatic/public/assets/uploads/profesores/prof_7_1771977600.png', NULL, 1, 1, NULL, '2026-02-24 23:59:52', '2026-02-25 00:00:00');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_professor_academic_formations`
--

CREATE TABLE `tbl_professor_academic_formations` (
  `id` int(11) NOT NULL,
  `professor_id` int(11) NOT NULL,
  `degree_title` varchar(150) NOT NULL COMMENT 'Título obtenido (Ej. Ingeniero en Sistemas)',
  `academic_level` enum('Pregrado','Especialista','Magister','Doctorado','Postdoctorado','Diplomado') NOT NULL,
  `study_area` varchar(100) DEFAULT NULL COMMENT 'Área de estudio',
  `institution` varchar(150) NOT NULL,
  `year_obtained` year(4) DEFAULT NULL,
  `display_order` int(11) NOT NULL DEFAULT 0 COMMENT 'Para ordenar el CV visualmente'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish_ci;

--
-- Volcado de datos para la tabla `tbl_professor_academic_formations`
--

INSERT INTO `tbl_professor_academic_formations` (`id`, `professor_id`, `degree_title`, `academic_level`, `study_area`, `institution`, `year_obtained`, `display_order`) VALUES
(1, 2, 'Ingeniero Electronico', 'Pregrado', NULL, 'Universidad Yacambu', '2005', 0),
(3, 6, 'Ingeniero Quimico', 'Pregrado', 'Quimica General', 'Universidad Nacional Experimental Antonio Jose de Sucre', '2026', 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_professor_contacts`
--

CREATE TABLE `tbl_professor_contacts` (
  `id` int(11) NOT NULL,
  `professor_id` int(11) NOT NULL,
  `email` varchar(150) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `linkedin_url` varchar(255) DEFAULT NULL,
  `other_contact` varchar(255) DEFAULT NULL COMMENT 'Otras redes, web personal o método de contacto'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish_ci;

--
-- Volcado de datos para la tabla `tbl_professor_contacts`
--

INSERT INTO `tbl_professor_contacts` (`id`, `professor_id`, `email`, `phone`, `linkedin_url`, `other_contact`) VALUES
(1, 2, 'gorgepereira@gmail.com', '+584145365380', '', 'www.amarellus.com'),
(11, 3, 'jorgeluispereiraolivares@gmail.com', '+584145042125', '', ''),
(13, 6, 'ddrgomes@gmail.com', '+584145365380', NULL, NULL);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_professor_documents`
--

CREATE TABLE `tbl_professor_documents` (
  `id` int(11) NOT NULL,
  `professor_id` int(11) NOT NULL,
  `document_type` enum('CV','Reseña','Certificación Académica','Documento de Identidad','Otro') NOT NULL,
  `document_name` varchar(150) NOT NULL COMMENT 'Nombre legible del archivo',
  `file_path` varchar(255) NOT NULL COMMENT 'Ruta física del archivo en el servidor',
  `uploaded_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish_ci;

--
-- Volcado de datos para la tabla `tbl_professor_documents`
--

INSERT INTO `tbl_professor_documents` (`id`, `professor_id`, `document_type`, `document_name`, `file_path`, `uploaded_at`) VALUES
(1, 2, 'CV', 'Resumen Curricular', '/diplomatic/public/assets/uploads/profesores_docs/doc_2_1771508554.pdf', '2026-02-19 13:42:34'),
(3, 6, 'CV', 'Resumen Curricular', '/diplomatic/public/assets/uploads/profesores_docs/doc_6_1772455294.pdf', '2026-03-02 12:41:34');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_professor_specialties`
--

CREATE TABLE `tbl_professor_specialties` (
  `id` int(11) NOT NULL,
  `professor_id` int(11) NOT NULL,
  `specialty_name` varchar(100) NOT NULL COMMENT 'Ej. Ciberseguridad, Derecho Penal',
  `is_main` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1: Especialidad principal'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish_ci;

--
-- Volcado de datos para la tabla `tbl_professor_specialties`
--

INSERT INTO `tbl_professor_specialties` (`id`, `professor_id`, `specialty_name`, `is_main`) VALUES
(1, 2, 'Maestria en Ingenieria de Control de Procesos', 1),
(2, 6, 'Especialización en Control Industrial', 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_professor_work_experiences`
--

CREATE TABLE `tbl_professor_work_experiences` (
  `id` int(11) NOT NULL,
  `professor_id` int(11) NOT NULL,
  `job_title` varchar(150) NOT NULL COMMENT 'Cargo ocupado',
  `institution` varchar(150) NOT NULL,
  `description` text DEFAULT NULL COMMENT 'Funciones o logros principales',
  `start_date` date NOT NULL,
  `end_date` date DEFAULT NULL,
  `is_current` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1: Cargo actual (end_date se ignora)',
  `display_order` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish_ci;

--
-- Volcado de datos para la tabla `tbl_professor_work_experiences`
--

INSERT INTO `tbl_professor_work_experiences` (`id`, `professor_id`, `job_title`, `institution`, `description`, `start_date`, `end_date`, `is_current`, `display_order`) VALUES
(1, 2, 'Director General', 'Amarellus', NULL, '2019-08-23', NULL, 1, 0),
(2, 6, 'Gerente de Control de Calidad', 'Alimentos Polar', NULL, '2007-02-01', NULL, 1, 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_roles`
--

CREATE TABLE `tbl_roles` (
  `id` int(10) UNSIGNED NOT NULL,
  `role_key` varchar(60) NOT NULL,
  `name` varchar(120) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `level` int(11) NOT NULL DEFAULT 1,
  `status` enum('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `tbl_roles`
--

INSERT INTO `tbl_roles` (`id`, `role_key`, `name`, `description`, `level`, `status`, `created_at`, `updated_at`) VALUES
(1, 'ADMIN', 'Administrador', 'Control total, auditoría y configuración global del sistema', 10, 'ACTIVE', '2026-02-11 08:40:30', '2026-02-11 08:40:30'),
(2, 'FINANZAS', 'Finanzas', 'Gestión centralizada de cobros, validación de soportes y reportes financieros', 5, 'ACTIVE', '2026-02-11 08:40:30', '2026-02-11 08:40:30'),
(3, 'ACADEMIC', 'Académico', 'Administración de diplomados, cohortes, profesores y control de estudios', 5, 'ACTIVE', '2026-02-11 08:40:30', '2026-02-11 08:40:30'),
(4, 'OPERATOR', 'Operador', 'Administración de cartelera digital, noticias y soporte a inscripciones', 3, 'ACTIVE', '2026-02-11 08:40:30', '2026-02-11 08:40:30'),
(5, 'PARTICIPANT', 'Participante', 'Acceso a oferta académica, registro de pagos y estado de cuenta', 1, 'ACTIVE', '2026-02-11 08:40:30', '2026-02-11 08:40:30');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_role_permissions`
--

CREATE TABLE `tbl_role_permissions` (
  `id` int(10) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL,
  `permission_id` int(10) UNSIGNED NOT NULL,
  `status` enum('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_sessions`
--

CREATE TABLE `tbl_sessions` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `session_token` varchar(255) NOT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` varchar(255) DEFAULT NULL,
  `started_at` datetime NOT NULL DEFAULT current_timestamp(),
  `last_activity_at` datetime DEFAULT NULL,
  `ended_at` datetime DEFAULT NULL,
  `end_reason` enum('LOGOUT','TIMEOUT','FORCED','UNKNOWN') DEFAULT NULL,
  `status` enum('ACTIVE','CLOSED') NOT NULL DEFAULT 'ACTIVE',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_students`
--

CREATE TABLE `tbl_students` (
  `id` int(11) NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `enrollment_id` int(11) NOT NULL,
  `student_code` varchar(50) NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `document_id` varchar(30) NOT NULL,
  `email` varchar(190) NOT NULL,
  `undergraduate_degree` varchar(150) DEFAULT NULL,
  `admission_date` date NOT NULL,
  `status` enum('ACTIVO','EGRESADO','RETIRADO','SUSPENDIDO','CONGELADO') DEFAULT 'ACTIVO',
  `observations` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `tbl_students`
--

INSERT INTO `tbl_students` (`id`, `user_id`, `enrollment_id`, `student_code`, `first_name`, `last_name`, `document_id`, `email`, `undergraduate_degree`, `admission_date`, `status`, `observations`, `created_at`) VALUES
(8, 23, 1, 'DCS-2026-I-001', 'Reactor', 'Nuclear', '21301474', 'plataformadiplomados.com@gmail.com', 'Medico Cirujano', '2026-04-02', 'ACTIVO', NULL, '2026-04-03 03:09:06'),
(9, 22, 2, 'DCS-2026-I-002', 'DEMETRIO', 'OLIVARES ARGÜELLES', '149795233', 'gorgepereira@gmail.com', 'Ingeniero', '2026-04-02', 'ACTIVO', NULL, '2026-04-03 03:25:21'),
(10, 21, 3, 'DCS-2026-I-003', 'LUIS JORGE', 'OLIVARES DICORSO', '149795231', 'jorge@plataformadiplomados.com', 'Medicina', '2026-04-02', 'ACTIVO', NULL, '2026-04-03 03:31:36'),
(11, 24, 4, 'DCS-2026-I-004', 'MARIA', 'TALAVERA', '21301474', 'raizamileva@hotmail.com', 'Medico Cirujano', '2026-04-02', 'ACTIVO', NULL, '2026-04-03 03:47:25');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_student_matriculations`
--

CREATE TABLE `tbl_student_matriculations` (
  `id` int(11) NOT NULL,
  `student_id` int(11) NOT NULL COMMENT 'ID de la ficha del estudiante',
  `offering_id` int(11) NOT NULL COMMENT 'A qué diplomado/cohorte entró',
  `enrollment_id` int(11) NOT NULL COMMENT 'La inscripción que originó esta matrícula',
  `academic_status` enum('CURSANDO','APROBADO','REPROBADO','RETIRADO','CONGELADO') DEFAULT 'CURSANDO',
  `final_grade` decimal(5,2) DEFAULT NULL COMMENT 'Nota final obtenida',
  `certificate_issued` tinyint(1) DEFAULT 0 COMMENT '¿Se le emitió diploma?',
  `registered_by` int(10) UNSIGNED NOT NULL COMMENT 'Admin que aprobó los papeles',
  `registered_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `tbl_student_matriculations`
--

INSERT INTO `tbl_student_matriculations` (`id`, `student_id`, `offering_id`, `enrollment_id`, `academic_status`, `final_grade`, `certificate_issued`, `registered_by`, `registered_at`, `updated_at`) VALUES
(10, 8, 6, 1, 'CURSANDO', 0.00, 0, 1, '2026-04-03 03:09:06', '2026-04-03 04:22:44'),
(11, 9, 6, 2, 'CURSANDO', NULL, 0, 1, '2026-04-03 03:25:21', '2026-04-03 03:25:21'),
(12, 10, 6, 3, 'CURSANDO', NULL, 0, 1, '2026-04-03 03:31:36', '2026-04-03 03:31:36'),
(13, 11, 6, 4, 'CURSANDO', NULL, 0, 1, '2026-04-03 03:47:25', '2026-04-03 03:47:25');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_users`
--

CREATE TABLE `tbl_users` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_type` enum('INTERNAL','PARTICIPANT') NOT NULL DEFAULT 'INTERNAL',
  `status` enum('ACTIVE','SUSPENDED','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `email` varchar(190) NOT NULL,
  `role` varchar(60) DEFAULT 'PARTICIPANT',
  `phone` varchar(30) DEFAULT NULL,
  `document_id` varchar(30) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `provenance` varchar(150) DEFAULT NULL,
  `undergraduate_degree` varchar(150) DEFAULT NULL,
  `avatar` varchar(255) DEFAULT 'default_avatar.png',
  `password_hash` varchar(255) NOT NULL,
  `last_login_at` datetime DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `profile_complete` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `tbl_users`
--

INSERT INTO `tbl_users` (`id`, `user_type`, `status`, `first_name`, `last_name`, `email`, `role`, `phone`, `document_id`, `address`, `provenance`, `undergraduate_degree`, `avatar`, `password_hash`, `last_login_at`, `created_at`, `updated_at`, `profile_complete`) VALUES
(1, 'INTERNAL', 'ACTIVE', 'ADMIN', 'GENERAL', 'admin@diplomatic.local', 'ADMIN', '', '1', '', '', '', 'default_avatar.png', '$2y$10$00VC/qpQDbIDycCmDk0.Au4AEP7EfpgQ8J451Zs9YOvzdH4Vpty5K', '2026-04-04 16:10:57', '2026-02-07 17:08:04', '2026-04-04 16:10:57', 0),
(2, 'INTERNAL', 'ACTIVE', 'JORGE', 'PEREIRA', 'raizamileva@gmail.com', 'FINANZAS', '+584145365380', '149795231', 'Urb El Valle, Calle Principal, Casa Nro 23, Cabudare, Jose Gregorio Bastidas, Palavecino', 'Cabudare', 'Ingenieria', 'usr_1770810835.png', '$2y$10$Pa.672SkyV7tzG8yfpeI5uInUoOt7T/YKWdtVa.dfqqsKjjLFn8pG', NULL, '2026-02-08 11:35:40', '2026-03-22 11:41:18', 0),
(4, 'INTERNAL', 'ACTIVE', 'Homer', 'Pereira', 'ddrgomes@gmail.com', 'PARTICIPANT', '+584145278577', '13567117', 'Urb Club Hipico Las Trinitarias, Res La Trinitaria Piso 4 Apartament 44', 'Barquisimeto', 'Ingenieria Quimica', 'usr_1770811774.png', '$2y$10$QswXlqG07r/h6hGKMdOoUu0gQWNShrTrl37F0QWoMDSn8QnHcw6aG', '2026-02-13 21:19:11', '2026-02-11 08:05:52', '2026-02-13 21:19:11', 1),
(17, 'INTERNAL', 'ACTIVE', 'OPERADOR', 'DIPLOMATIC', 'oper@diplomatic.local', 'OPERATOR', '', 'S/D', '', '', 'N/A', 'default_avatar.png', '$2y$10$thbIkbLpKBOAHqSKe8cP7OSr1zPPhcG50X7MqY8fjC3cL9ICWlez2', '2026-03-12 15:29:15', '2026-02-16 22:09:14', '2026-03-12 15:29:15', 0),
(20, 'INTERNAL', 'ACTIVE', 'JORGE LUIS', 'PEREIRA OLIVARES', 'gorgepereira@yahoo.es', 'ADMIN', '(+58)-(414)-(536-5380)', '14979523', '', 'Barquisimeto', 'Ingeniero', 'usr_1772117429.webp', '$2y$10$kuBJl/k3HtoTsWcPKWUu/OS5ztC5VJtI0kZ8SDweS1ivmpkZeCqk.', '2026-03-19 08:12:29', '2026-02-26 10:42:28', '2026-03-19 08:12:29', 1),
(21, 'PARTICIPANT', 'ACTIVE', 'LUIS JORGE', 'OLIVARES DICORSO', 'jorge@plataformadiplomados.com', 'PARTICIPANT', '+584145365380', '149795231', 'Urb El Valle, Calle Principal, Casa Nro 23, Cabudare, Jose Gregorio Bastidas, Palavecino', 'Cabudare', 'Medicina', 'usr_1773176014.png', '$2y$10$KBndFpIWxmUDyk5RwPszuunDeMt.zEhvMm3CR/HdmKf1AHHRvjpEa', NULL, '2026-03-10 16:52:45', '2026-03-22 19:16:03', 0),
(22, 'PARTICIPANT', 'ACTIVE', 'DEMETRIO', 'OLIVARES ARGÜELLES', 'gorgepereira@gmail.com', 'PARTICIPANT', '(+58)-(414)-(536-5380)', '149795233', 'Urb El Valle, Calle Principal, Casa Nro 23, Cabudare, Jose Gregorio Bastidas, Palavecino', 'Barquisimeto', 'Ingeniero', 'usr_1773414669.jpg', '$2y$10$Bs8GC3/ilYSw.Xym1vtzAeV.eCy.eXEhcTNIzq1IjjR7g7aGS4Nvu', '2026-04-04 14:39:52', '2026-03-12 15:36:38', '2026-04-04 14:39:52', 1),
(23, 'PARTICIPANT', 'ACTIVE', 'Reactor', 'Nuclear', 'plataformadiplomados.com@gmail.com', 'PARTICIPANT', '(+58)-(416)-(556-7845)', '21301474', '10773 NW 58th ST, Doral FL 33178', 'Barquisimeto', 'Medico Cirujano', 'usr_1775183032.jpg', '$2y$10$VgkaNwraV0ZQPGrE8MFOxOtkSU57iK.pI0zof1BYcaBodtpLQJkQG', '2026-04-02 23:09:57', '2026-04-02 22:22:32', '2026-04-02 23:09:57', 1),
(24, 'PARTICIPANT', 'ACTIVE', 'MARIA', 'TALAVERA', 'raizamileva@hotmail.com', 'PARTICIPANT', '+584144571599', '21301474', 'Urb El Valle, Calle Principal, Casa Nro 23, Cabudare, Jose Gregorio Bastidas, Palavecino', 'Yaracuy', 'Medico Cirujano', 'usr_1775187407.jpg', '$2y$10$.wNCFkaWpWjEZOH3qk9AyuZHLua6zoeOu8k9cE2JVNIQJ3gdjyEx.', '2026-04-02 23:46:15', '2026-04-02 23:36:48', '2026-04-02 23:46:15', 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_user_recovery_tokens`
--

CREATE TABLE `tbl_user_recovery_tokens` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `token_hash` varchar(64) NOT NULL,
  `expires_at` datetime NOT NULL,
  `used_at` datetime DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `tbl_user_recovery_tokens`
--

INSERT INTO `tbl_user_recovery_tokens` (`id`, `user_id`, `token_hash`, `expires_at`, `used_at`, `created_at`) VALUES
(9, 16, 'dafdfee6440e6603b402d58297e63e4980a23372804e7c46297a85cc839723cc', '2026-02-16 23:55:59', '2026-02-16 21:58:17', '2026-02-17 01:55:59'),
(10, 16, '4136b5b091c1ba4482248531b53e0ff505b038a999624f203af896ebc80192fb', '2026-02-17 00:04:37', '2026-02-16 22:05:18', '2026-02-17 02:04:37'),
(11, 18, 'f5cd38fb57ed18c283c7d540a8146fca563f099e573d62493142b2b218ded8aa', '2026-02-17 00:28:14', '2026-02-16 22:28:38', '2026-02-17 02:28:14'),
(12, 20, '66b3412edc0a6442877edce9416c52abf489b07b7525187263a7b3c2f0aeb77f', '2026-02-26 12:43:48', NULL, '2026-02-26 14:43:48'),
(13, 20, '7ad2739c7b7de6c303eec286de228ebc9bf450fe3b610b37cdc844260dba5b40', '2026-02-26 12:47:34', '2026-02-26 10:47:53', '2026-02-26 14:47:34');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_user_remember_tokens`
--

CREATE TABLE `tbl_user_remember_tokens` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `token_hash` varchar(255) NOT NULL,
  `expires_at` datetime NOT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_wa_manual_logs`
--

CREATE TABLE `tbl_wa_manual_logs` (
  `id` int(11) NOT NULL,
  `estudiante` varchar(255) DEFAULT NULL,
  `evento` varchar(50) DEFAULT NULL,
  `telefono` varchar(50) DEFAULT NULL,
  `fecha_envio` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `tbl_wa_manual_logs`
--

INSERT INTO `tbl_wa_manual_logs` (`id`, `estudiante`, `evento`, `telefono`, `fecha_envio`) VALUES
(1, 'Jorge Pereira', 'INSCRIPCION', '+584145365380', '2026-02-12 17:31:26'),
(2, 'Raiza Mileva', 'CONSTANCIA_ESTUDIO', '+584124571599', '2026-02-12 17:31:59'),
(3, 'Juan Pérez', 'CONSTANCIA_ESTUDIO', '+584145042125', '2026-02-13 16:39:33'),
(4, 'jorge pereira', 'INSCRIPCION', '+584145365380', '2026-02-24 23:45:19'),
(5, 'Pereira', 'PAGO', '+584145365380', '2026-02-24 23:45:58'),
(6, 'Pereira', 'PAGO', '+584145365380', '2026-02-24 23:46:30');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `tbl_wa_manual_templates`
--

CREATE TABLE `tbl_wa_manual_templates` (
  `id` int(11) NOT NULL,
  `evento` varchar(50) NOT NULL,
  `mensaje` text DEFAULT NULL,
  `activo` tinyint(1) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `tbl_wa_manual_templates`
--

INSERT INTO `tbl_wa_manual_templates` (`id`, `evento`, `mensaje`, `activo`) VALUES
(1, 'INSCRIPCION', 'Hola {NOMBRE}, tu inscripción al diplomado {DIPLOMADO} ha sido confirmada. ¡Nos vemos pronto! {URL_PORTAL}', 1),
(2, 'CONSTANCIA_ESTUDIO', 'Hola {NOMBRE}, tu constancia de estudio para {DIPLOMADO} ya está disponible aquí: {URL_PORTAL}', 1),
(3, 'CONSTANCIA_INSCRIPCION', 'Hola {NOMBRE}, adjuntamos tu constancia de inscripción al diplomado {DIPLOMADO}: {URL_PORTAL}', 1),
(4, 'PAGO', 'Hola {NOMBRE}, te recordamos que tienes un pago pendiente en el diplomado {DIPLOMADO}. Puedes gestionarlo aquí: {URL_PORTAL}', 1);

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `tbl_academic_offerings`
--
ALTER TABLE `tbl_academic_offerings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_offering_diploma` (`diploma_id`),
  ADD KEY `fk_offering_cohort` (`cohort_id`),
  ADD KEY `fk_offering_creator` (`created_by`);

--
-- Indices de la tabla `tbl_academic_offering_campuses`
--
ALTER TABLE `tbl_academic_offering_campuses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_rel_offering_camp` (`offering_id`),
  ADD KEY `fk_rel_campus_master` (`campus_id`);

--
-- Indices de la tabla `tbl_academic_offering_groups`
--
ALTER TABLE `tbl_academic_offering_groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_rel_offering_grp` (`offering_id`),
  ADD KEY `fk_rel_group_master` (`group_id`);

--
-- Indices de la tabla `tbl_academic_offering_payment_plans`
--
ALTER TABLE `tbl_academic_offering_payment_plans`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_rel_offering_pay` (`offering_id`);

--
-- Indices de la tabla `tbl_academic_offering_professors`
--
ALTER TABLE `tbl_academic_offering_professors`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_rel_offering_prof` (`offering_id`),
  ADD KEY `fk_rel_prof_master` (`professor_id`);

--
-- Indices de la tabla `tbl_audit_logs`
--
ALTER TABLE `tbl_audit_logs`
  ADD PRIMARY KEY (`log_id`),
  ADD KEY `idx_created_at` (`created_at`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_event_type` (`event_type`);

--
-- Indices de la tabla `tbl_campuses`
--
ALTER TABLE `tbl_campuses`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tbl_cohortes`
--
ALTER TABLE `tbl_cohortes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_cohort_code` (`cohort_code`),
  ADD KEY `fk_cohort_created_by` (`created_by`),
  ADD KEY `fk_cohort_updated_by` (`updated_by`);

--
-- Indices de la tabla `tbl_cohort_campuses`
--
ALTER TABLE `tbl_cohort_campuses`
  ADD PRIMARY KEY (`cohort_id`,`campus_id`),
  ADD KEY `fk_campus_rel` (`campus_id`);

--
-- Indices de la tabla `tbl_company_settings`
--
ALTER TABLE `tbl_company_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tbl_diplomados`
--
ALTER TABLE `tbl_diplomados`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`),
  ADD KEY `fk_dip_created_by` (`created_by`),
  ADD KEY `fk_dip_updated_by` (`updated_by`);

--
-- Indices de la tabla `tbl_diplomados_conditions`
--
ALTER TABLE `tbl_diplomados_conditions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_cond_diplomado` (`diplomado_id`);

--
-- Indices de la tabla `tbl_diplomados_requirements`
--
ALTER TABLE `tbl_diplomados_requirements`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_req_diplomado` (`diplomado_id`);

--
-- Indices de la tabla `tbl_email_settings`
--
ALTER TABLE `tbl_email_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tipo_correo` (`tipo_correo`);

--
-- Indices de la tabla `tbl_enrollments`
--
ALTER TABLE `tbl_enrollments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_enroll_user` (`user_id`),
  ADD KEY `fk_enroll_offer` (`offering_id`),
  ADD KEY `fk_enroll_creator` (`created_by`);

--
-- Indices de la tabla `tbl_enrollments_payments`
--
ALTER TABLE `tbl_enrollments_payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_pay_enroll` (`enrollment_id`);

--
-- Indices de la tabla `tbl_event_catalog`
--
ALTER TABLE `tbl_event_catalog`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_event_catalog_code` (`event_code`),
  ADD KEY `idx_event_catalog_type` (`event_type`),
  ADD KEY `idx_event_catalog_severity` (`severity`);

--
-- Indices de la tabla `tbl_event_logs`
--
ALTER TABLE `tbl_event_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_event_logs_code` (`event_code`),
  ADD KEY `idx_event_logs_user` (`user_id`),
  ADD KEY `idx_event_logs_session` (`session_id`),
  ADD KEY `idx_event_logs_occurred` (`occurred_at`),
  ADD KEY `idx_event_logs_entity` (`entity_table`,`entity_id`),
  ADD KEY `fk_event_logs_catalog` (`event_catalog_id`);

--
-- Indices de la tabla `tbl_financial_bank_transactions_mobile`
--
ALTER TABLE `tbl_financial_bank_transactions_mobile`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `reference_id` (`reference_id`),
  ADD UNIQUE KEY `unique_transaction_idx` (`op_type`,`op_date`,`reference_id`,`origin_phone`);

--
-- Indices de la tabla `tbl_financial_exchange_rates`
--
ALTER TABLE `tbl_financial_exchange_rates`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_rate_date` (`rate_date`),
  ADD KEY `idx_user_rate` (`user_id`);

--
-- Indices de la tabla `tbl_financial_payments`
--
ALTER TABLE `tbl_financial_payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_fin_pay_student` (`student_id`),
  ADD KEY `fk_fin_pay_matriculation` (`matriculation_id`);

--
-- Indices de la tabla `tbl_financial_student_ledger`
--
ALTER TABLE `tbl_financial_student_ledger`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_ledger_enroll_v4` (`enrollment_id`),
  ADD KEY `fk_ledger_user_v4` (`user_id`),
  ADD KEY `idx_ledger_payment` (`payment_id`);

--
-- Indices de la tabla `tbl_grupos`
--
ALTER TABLE `tbl_grupos`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tbl_permissions`
--
ALTER TABLE `tbl_permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_permissions_key` (`perm_key`),
  ADD KEY `idx_permissions_module` (`module_key`),
  ADD KEY `idx_permissions_action` (`action_key`);

--
-- Indices de la tabla `tbl_pre_users`
--
ALTER TABLE `tbl_pre_users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq_pre_users_email` (`email`);

--
-- Indices de la tabla `tbl_pre_user_tokens`
--
ALTER TABLE `tbl_pre_user_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_pre_tokens_pre_user_id` (`pre_user_id`);

--
-- Indices de la tabla `tbl_professors`
--
ALTER TABLE `tbl_professors`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_identification` (`identification`);

--
-- Indices de la tabla `tbl_professor_academic_formations`
--
ALTER TABLE `tbl_professor_academic_formations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_academic_professor` (`professor_id`);

--
-- Indices de la tabla `tbl_professor_contacts`
--
ALTER TABLE `tbl_professor_contacts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_professor_contact` (`professor_id`);

--
-- Indices de la tabla `tbl_professor_documents`
--
ALTER TABLE `tbl_professor_documents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_document_professor` (`professor_id`);

--
-- Indices de la tabla `tbl_professor_specialties`
--
ALTER TABLE `tbl_professor_specialties`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_specialty_professor` (`professor_id`);

--
-- Indices de la tabla `tbl_professor_work_experiences`
--
ALTER TABLE `tbl_professor_work_experiences`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_work_professor` (`professor_id`);

--
-- Indices de la tabla `tbl_roles`
--
ALTER TABLE `tbl_roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_roles_key` (`role_key`);

--
-- Indices de la tabla `tbl_role_permissions`
--
ALTER TABLE `tbl_role_permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_role_permission` (`role_id`,`permission_id`),
  ADD KEY `fk_role_permissions_permission` (`permission_id`);

--
-- Indices de la tabla `tbl_sessions`
--
ALTER TABLE `tbl_sessions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_sessions_token` (`session_token`),
  ADD KEY `idx_sessions_user` (`user_id`),
  ADD KEY `idx_sessions_status` (`status`);

--
-- Indices de la tabla `tbl_students`
--
ALTER TABLE `tbl_students`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `student_code` (`student_code`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `enrollment_id` (`enrollment_id`);

--
-- Indices de la tabla `tbl_student_matriculations`
--
ALTER TABLE `tbl_student_matriculations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `student_id` (`student_id`),
  ADD KEY `offering_id` (`offering_id`),
  ADD KEY `enrollment_id` (`enrollment_id`);

--
-- Indices de la tabla `tbl_users`
--
ALTER TABLE `tbl_users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_users_email` (`email`);

--
-- Indices de la tabla `tbl_user_recovery_tokens`
--
ALTER TABLE `tbl_user_recovery_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq_token_hash` (`token_hash`),
  ADD KEY `idx_recovery_user` (`user_id`);

--
-- Indices de la tabla `tbl_user_remember_tokens`
--
ALTER TABLE `tbl_user_remember_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indices de la tabla `tbl_wa_manual_logs`
--
ALTER TABLE `tbl_wa_manual_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `tbl_wa_manual_templates`
--
ALTER TABLE `tbl_wa_manual_templates`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `idx_evento_wa` (`evento`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `tbl_academic_offerings`
--
ALTER TABLE `tbl_academic_offerings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT de la tabla `tbl_academic_offering_campuses`
--
ALTER TABLE `tbl_academic_offering_campuses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=180;

--
-- AUTO_INCREMENT de la tabla `tbl_academic_offering_groups`
--
ALTER TABLE `tbl_academic_offering_groups`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=137;

--
-- AUTO_INCREMENT de la tabla `tbl_academic_offering_payment_plans`
--
ALTER TABLE `tbl_academic_offering_payment_plans`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=387;

--
-- AUTO_INCREMENT de la tabla `tbl_academic_offering_professors`
--
ALTER TABLE `tbl_academic_offering_professors`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=121;

--
-- AUTO_INCREMENT de la tabla `tbl_audit_logs`
--
ALTER TABLE `tbl_audit_logs`
  MODIFY `log_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5382;

--
-- AUTO_INCREMENT de la tabla `tbl_campuses`
--
ALTER TABLE `tbl_campuses`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT de la tabla `tbl_cohortes`
--
ALTER TABLE `tbl_cohortes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT de la tabla `tbl_company_settings`
--
ALTER TABLE `tbl_company_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `tbl_diplomados`
--
ALTER TABLE `tbl_diplomados`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT de la tabla `tbl_diplomados_conditions`
--
ALTER TABLE `tbl_diplomados_conditions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77;

--
-- AUTO_INCREMENT de la tabla `tbl_diplomados_requirements`
--
ALTER TABLE `tbl_diplomados_requirements`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=96;

--
-- AUTO_INCREMENT de la tabla `tbl_email_settings`
--
ALTER TABLE `tbl_email_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT de la tabla `tbl_enrollments`
--
ALTER TABLE `tbl_enrollments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT de la tabla `tbl_enrollments_payments`
--
ALTER TABLE `tbl_enrollments_payments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT de la tabla `tbl_event_catalog`
--
ALTER TABLE `tbl_event_catalog`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tbl_event_logs`
--
ALTER TABLE `tbl_event_logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tbl_financial_bank_transactions_mobile`
--
ALTER TABLE `tbl_financial_bank_transactions_mobile`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=428;

--
-- AUTO_INCREMENT de la tabla `tbl_financial_exchange_rates`
--
ALTER TABLE `tbl_financial_exchange_rates`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT de la tabla `tbl_financial_payments`
--
ALTER TABLE `tbl_financial_payments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT de la tabla `tbl_financial_student_ledger`
--
ALTER TABLE `tbl_financial_student_ledger`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT de la tabla `tbl_grupos`
--
ALTER TABLE `tbl_grupos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT de la tabla `tbl_permissions`
--
ALTER TABLE `tbl_permissions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tbl_pre_users`
--
ALTER TABLE `tbl_pre_users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT de la tabla `tbl_pre_user_tokens`
--
ALTER TABLE `tbl_pre_user_tokens`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT de la tabla `tbl_professors`
--
ALTER TABLE `tbl_professors`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT de la tabla `tbl_professor_academic_formations`
--
ALTER TABLE `tbl_professor_academic_formations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de la tabla `tbl_professor_contacts`
--
ALTER TABLE `tbl_professor_contacts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT de la tabla `tbl_professor_documents`
--
ALTER TABLE `tbl_professor_documents`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de la tabla `tbl_professor_specialties`
--
ALTER TABLE `tbl_professor_specialties`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de la tabla `tbl_professor_work_experiences`
--
ALTER TABLE `tbl_professor_work_experiences`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de la tabla `tbl_roles`
--
ALTER TABLE `tbl_roles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT de la tabla `tbl_role_permissions`
--
ALTER TABLE `tbl_role_permissions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tbl_sessions`
--
ALTER TABLE `tbl_sessions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `tbl_students`
--
ALTER TABLE `tbl_students`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT de la tabla `tbl_student_matriculations`
--
ALTER TABLE `tbl_student_matriculations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT de la tabla `tbl_users`
--
ALTER TABLE `tbl_users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT de la tabla `tbl_user_recovery_tokens`
--
ALTER TABLE `tbl_user_recovery_tokens`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT de la tabla `tbl_user_remember_tokens`
--
ALTER TABLE `tbl_user_remember_tokens`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT de la tabla `tbl_wa_manual_logs`
--
ALTER TABLE `tbl_wa_manual_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT de la tabla `tbl_wa_manual_templates`
--
ALTER TABLE `tbl_wa_manual_templates`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- Restricciones para tablas volcadas
--

--
-- Filtros para la tabla `tbl_academic_offerings`
--
ALTER TABLE `tbl_academic_offerings`
  ADD CONSTRAINT `fk_offering_cohort` FOREIGN KEY (`cohort_id`) REFERENCES `tbl_cohortes` (`id`),
  ADD CONSTRAINT `fk_offering_creator` FOREIGN KEY (`created_by`) REFERENCES `tbl_users` (`id`) ON DELETE NO ACTION,
  ADD CONSTRAINT `fk_offering_diploma` FOREIGN KEY (`diploma_id`) REFERENCES `tbl_diplomados` (`id`);

--
-- Filtros para la tabla `tbl_academic_offering_campuses`
--
ALTER TABLE `tbl_academic_offering_campuses`
  ADD CONSTRAINT `fk_rel_campus_master` FOREIGN KEY (`campus_id`) REFERENCES `tbl_campuses` (`id`),
  ADD CONSTRAINT `fk_rel_offering_camp` FOREIGN KEY (`offering_id`) REFERENCES `tbl_academic_offerings` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `tbl_academic_offering_groups`
--
ALTER TABLE `tbl_academic_offering_groups`
  ADD CONSTRAINT `fk_rel_group_master` FOREIGN KEY (`group_id`) REFERENCES `tbl_grupos` (`id`),
  ADD CONSTRAINT `fk_rel_offering_grp` FOREIGN KEY (`offering_id`) REFERENCES `tbl_academic_offerings` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `tbl_academic_offering_payment_plans`
--
ALTER TABLE `tbl_academic_offering_payment_plans`
  ADD CONSTRAINT `fk_rel_offering_pay` FOREIGN KEY (`offering_id`) REFERENCES `tbl_academic_offerings` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `tbl_academic_offering_professors`
--
ALTER TABLE `tbl_academic_offering_professors`
  ADD CONSTRAINT `fk_rel_offering_prof` FOREIGN KEY (`offering_id`) REFERENCES `tbl_academic_offerings` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_rel_prof_master` FOREIGN KEY (`professor_id`) REFERENCES `tbl_professors` (`id`);

--
-- Filtros para la tabla `tbl_cohortes`
--
ALTER TABLE `tbl_cohortes`
  ADD CONSTRAINT `fk_cohort_created_by` FOREIGN KEY (`created_by`) REFERENCES `tbl_users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_cohort_updated_by` FOREIGN KEY (`updated_by`) REFERENCES `tbl_users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Filtros para la tabla `tbl_cohort_campuses`
--
ALTER TABLE `tbl_cohort_campuses`
  ADD CONSTRAINT `fk_campus_rel` FOREIGN KEY (`campus_id`) REFERENCES `tbl_campuses` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_cohort_rel` FOREIGN KEY (`cohort_id`) REFERENCES `tbl_cohortes` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `tbl_diplomados`
--
ALTER TABLE `tbl_diplomados`
  ADD CONSTRAINT `fk_dip_created_by` FOREIGN KEY (`created_by`) REFERENCES `tbl_users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_dip_updated_by` FOREIGN KEY (`updated_by`) REFERENCES `tbl_users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Filtros para la tabla `tbl_diplomados_conditions`
--
ALTER TABLE `tbl_diplomados_conditions`
  ADD CONSTRAINT `fk_cond_diplomado` FOREIGN KEY (`diplomado_id`) REFERENCES `tbl_diplomados` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `tbl_diplomados_requirements`
--
ALTER TABLE `tbl_diplomados_requirements`
  ADD CONSTRAINT `fk_req_diplomado` FOREIGN KEY (`diplomado_id`) REFERENCES `tbl_diplomados` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `tbl_enrollments`
--
ALTER TABLE `tbl_enrollments`
  ADD CONSTRAINT `fk_enroll_creator_v4` FOREIGN KEY (`created_by`) REFERENCES `tbl_users` (`id`),
  ADD CONSTRAINT `fk_enroll_offer_v4` FOREIGN KEY (`offering_id`) REFERENCES `tbl_academic_offerings` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_enroll_user_v4` FOREIGN KEY (`user_id`) REFERENCES `tbl_users` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `tbl_enrollments_payments`
--
ALTER TABLE `tbl_enrollments_payments`
  ADD CONSTRAINT `fk_pay_enroll_v4` FOREIGN KEY (`enrollment_id`) REFERENCES `tbl_enrollments` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `tbl_event_logs`
--
ALTER TABLE `tbl_event_logs`
  ADD CONSTRAINT `fk_event_logs_catalog` FOREIGN KEY (`event_catalog_id`) REFERENCES `tbl_event_catalog` (`id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_event_logs_session` FOREIGN KEY (`session_id`) REFERENCES `tbl_sessions` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_event_logs_user` FOREIGN KEY (`user_id`) REFERENCES `tbl_users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Filtros para la tabla `tbl_financial_student_ledger`
--
ALTER TABLE `tbl_financial_student_ledger`
  ADD CONSTRAINT `fk_ledger_enroll_v4` FOREIGN KEY (`enrollment_id`) REFERENCES `tbl_enrollments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_ledger_user_v4` FOREIGN KEY (`user_id`) REFERENCES `tbl_users` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `tbl_professor_academic_formations`
--
ALTER TABLE `tbl_professor_academic_formations`
  ADD CONSTRAINT `fk_academic_professor` FOREIGN KEY (`professor_id`) REFERENCES `tbl_professors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `tbl_professor_contacts`
--
ALTER TABLE `tbl_professor_contacts`
  ADD CONSTRAINT `fk_contact_professor` FOREIGN KEY (`professor_id`) REFERENCES `tbl_professors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `tbl_professor_documents`
--
ALTER TABLE `tbl_professor_documents`
  ADD CONSTRAINT `fk_document_professor` FOREIGN KEY (`professor_id`) REFERENCES `tbl_professors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `tbl_professor_specialties`
--
ALTER TABLE `tbl_professor_specialties`
  ADD CONSTRAINT `fk_specialty_professor` FOREIGN KEY (`professor_id`) REFERENCES `tbl_professors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `tbl_professor_work_experiences`
--
ALTER TABLE `tbl_professor_work_experiences`
  ADD CONSTRAINT `fk_work_professor` FOREIGN KEY (`professor_id`) REFERENCES `tbl_professors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Filtros para la tabla `tbl_role_permissions`
--
ALTER TABLE `tbl_role_permissions`
  ADD CONSTRAINT `fk_role_permissions_permission` FOREIGN KEY (`permission_id`) REFERENCES `tbl_permissions` (`id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_role_permissions_role` FOREIGN KEY (`role_id`) REFERENCES `tbl_roles` (`id`) ON UPDATE CASCADE;

--
-- Filtros para la tabla `tbl_sessions`
--
ALTER TABLE `tbl_sessions`
  ADD CONSTRAINT `fk_sessions_user` FOREIGN KEY (`user_id`) REFERENCES `tbl_users` (`id`) ON UPDATE CASCADE;

--
-- Filtros para la tabla `tbl_students`
--
ALTER TABLE `tbl_students`
  ADD CONSTRAINT `tbl_students_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `tbl_users` (`id`),
  ADD CONSTRAINT `tbl_students_ibfk_2` FOREIGN KEY (`enrollment_id`) REFERENCES `tbl_enrollments` (`id`);

--
-- Filtros para la tabla `tbl_student_matriculations`
--
ALTER TABLE `tbl_student_matriculations`
  ADD CONSTRAINT `tbl_student_matriculations_ibfk_1` FOREIGN KEY (`student_id`) REFERENCES `tbl_students` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `tbl_student_matriculations_ibfk_2` FOREIGN KEY (`offering_id`) REFERENCES `tbl_academic_offerings` (`id`),
  ADD CONSTRAINT `tbl_student_matriculations_ibfk_3` FOREIGN KEY (`enrollment_id`) REFERENCES `tbl_enrollments` (`id`);

--
-- Filtros para la tabla `tbl_user_remember_tokens`
--
ALTER TABLE `tbl_user_remember_tokens`
  ADD CONSTRAINT `tbl_user_remember_tokens_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `tbl_users` (`id`) ON DELETE CASCADE;
COMMIT;

