-- MySQL dump 10.13 Distrib 8.0.46, for Win64 (x86_64) -- -- Host: localhost Database: ihm_attendance -- ------------------------------------------------------ -- Server version 8.0.46 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `academic_sessions` -- DROP TABLE IF EXISTS `academic_sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `academic_sessions` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `start_date` date NOT NULL, `end_date` date NOT NULL, `is_current` tinyint(1) NOT NULL DEFAULT '0', `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `updated_at` datetime(3) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `academic_sessions_name_key` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `academic_sessions` -- LOCK TABLES `academic_sessions` WRITE; /*!40000 ALTER TABLE `academic_sessions` DISABLE KEYS */; INSERT INTO `academic_sessions` VALUES ('90d47503-54e7-468a-b1a1-871d9c9c8988','2026-2027','2026-07-01','2027-06-30',1,'2026-10-16 12:10:04.344','2026-10-16 12:10:04.344'); /*!40000 ALTER TABLE `academic_sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `apr_reports` -- DROP TABLE IF EXISTS `apr_reports`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `apr_reports` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `semester_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `report_month` varchar(7) COLLATE utf8mb4_unicode_ci NOT NULL, `policy_version` int NOT NULL, `snapshot_json` json NOT NULL, `checksum_sha256` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `generated_by` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), PRIMARY KEY (`id`), UNIQUE KEY `apr_reports_semester_id_report_month_key` (`semester_id`,`report_month`), CONSTRAINT `apr_reports_semester_id_fkey` FOREIGN KEY (`semester_id`) REFERENCES `semesters` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `apr_reports` -- LOCK TABLES `apr_reports` WRITE; /*!40000 ALTER TABLE `apr_reports` DISABLE KEYS */; INSERT INTO `apr_reports` VALUES ('2a62815b-1784-4324-8517-aad261afe0be','fb69305f-fbe0-4428-adec-2178e01715fc','2026-11',1,'{\"policy\": {\"id\": \"1325ccbb-1c22-472b-b3e2-0610c57a35cb\", \"name\": \"NCHMCT Standard Attendance & Medical Policy\", \"version\": 1, \"warningLevelPct\": 70, \"criticalLevelPct\": 65, \"minAttendancePct\": 75, \"aprExclusionFloorPct\": 20, \"medicalMaxCeilingPct\": 10}, \"semester\": {\"id\": \"fb69305f-fbe0-4428-adec-2178e01715fc\", \"name\": \"Semester V (2026-2027)\", \"courseCode\": \"BHM\", \"courseName\": \"B.Sc. in Hospitality & Hotel Administration\", \"semesterNumber\": 5, \"academicSession\": \"2026-2027\"}, \"students\": [{\"fullName\": \"Aarav Sharma\", \"subjects\": [{\"medical\": 0.3, \"attended\": 2, \"condoned\": 0, \"conducted\": 2, \"percentage\": 100, \"subjectCode\": \"BHM301\", \"subjectName\": \"Advanced Food Production Operations\"}], \"groupName\": \"Batch A\", \"studentId\": \"ad45f3a0-8f76-489d-8a7d-71902cb1db44\", \"nchmctRollNo\": \"NCHM2026001\", \"condonationHours\": 0, \"eligibilityStatus\": \"ELIGIBLE\", \"totalPresentHours\": 2, \"totalConductedHours\": 2, \"approvedMedicalHours\": 0.3, \"effectiveAttendedHours\": 2.3, \"overallAttendancePercentage\": 100}, {\"fullName\": \"Pooja Chatterjee\", \"subjects\": [], \"groupName\": \"Batch B\", \"studentId\": \"d55e8ba9-9cf6-473f-9d13-53a8c34c6b72\", \"nchmctRollNo\": \"NCHM2026101\", \"condonationHours\": 0, \"eligibilityStatus\": \"EXCLUDED_FLOOR_VIOLATION\", \"totalPresentHours\": 0, \"totalConductedHours\": 0, \"approvedMedicalHours\": 0, \"effectiveAttendedHours\": 0, \"overallAttendancePercentage\": 0}, {\"fullName\": \"Debojyoti Ghosh\", \"subjects\": [{\"medical\": 0, \"attended\": 0, \"condoned\": 1, \"conducted\": 2, \"percentage\": 50, \"subjectCode\": \"BHM301\", \"subjectName\": \"Advanced Food Production Operations\"}], \"groupName\": \"Batch A\", \"studentId\": \"df6dabb7-1d6c-4237-b48a-9302e9edfba8\", \"nchmctRollNo\": \"NCHM2026102\", \"condonationHours\": 1, \"eligibilityStatus\": \"DETAINED\", \"totalPresentHours\": 0, \"totalConductedHours\": 2, \"approvedMedicalHours\": 0, \"effectiveAttendedHours\": 1, \"overallAttendancePercentage\": 50}], \"generatedAt\": \"2026-10-17T05:52:07.361Z\", \"institution\": {\"name\": \"Institute of Hotel Management, Catering Technology & Applied Nutrition, Kolkata\", \"affiliatingBody\": \"National Council for Hotel Management and Catering Technology (NCHMCT)\"}, \"reportMonth\": \"2026-11\", \"cohortStatistics\": {\"warningCount\": 0, \"criticalCount\": 0, \"detainedCount\": 2, \"eligibleCount\": 1, \"totalStudents\": 3, \"averageCohortPercentage\": 50}}','8578015456d40d8efa6db0495282ad221c7f92791a021024b554b8914875b238','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','2026-10-17 05:52:07.364'),('7b778629-80d6-4dee-967f-5aa117048b07','fb69305f-fbe0-4428-adec-2178e01715fc','2026-10',1,'{\"policy\": {\"id\": \"1325ccbb-1c22-472b-b3e2-0610c57a35cb\", \"name\": \"NCHMCT Standard Attendance & Medical Policy\", \"version\": 1, \"warningLevelPct\": 70, \"criticalLevelPct\": 65, \"minAttendancePct\": 75, \"aprExclusionFloorPct\": 20, \"medicalMaxCeilingPct\": 10}, \"semester\": {\"id\": \"fb69305f-fbe0-4428-adec-2178e01715fc\", \"name\": \"Semester V (2026-2027)\", \"courseCode\": \"BHM\", \"courseName\": \"B.Sc. in Hospitality & Hotel Administration\", \"semesterNumber\": 5, \"academicSession\": \"2026-2027\"}, \"students\": [{\"fullName\": \"Aarav Sharma\", \"subjects\": [{\"medical\": 0.3, \"attended\": 1, \"condoned\": 0, \"conducted\": 1, \"percentage\": 100, \"subjectCode\": \"BHM301\", \"subjectName\": \"Advanced Food Production Operations\"}], \"groupName\": \"Batch A\", \"studentId\": \"ad45f3a0-8f76-489d-8a7d-71902cb1db44\", \"nchmctRollNo\": \"NCHM2026001\", \"condonationHours\": 0, \"eligibilityStatus\": \"ELIGIBLE\", \"totalPresentHours\": 1, \"totalConductedHours\": 1, \"approvedMedicalHours\": 0.3, \"effectiveAttendedHours\": 1.3, \"overallAttendancePercentage\": 100}, {\"fullName\": \"Pooja Chatterjee\", \"subjects\": [], \"groupName\": \"Batch B\", \"studentId\": \"d55e8ba9-9cf6-473f-9d13-53a8c34c6b72\", \"nchmctRollNo\": \"NCHM2026101\", \"condonationHours\": 0, \"eligibilityStatus\": \"EXCLUDED_FLOOR_VIOLATION\", \"totalPresentHours\": 0, \"totalConductedHours\": 0, \"approvedMedicalHours\": 0, \"effectiveAttendedHours\": 0, \"overallAttendancePercentage\": 0}, {\"fullName\": \"Debojyoti Ghosh\", \"subjects\": [{\"medical\": 0, \"attended\": 0, \"condoned\": 1, \"conducted\": 1, \"percentage\": 100, \"subjectCode\": \"BHM301\", \"subjectName\": \"Advanced Food Production Operations\"}], \"groupName\": \"Batch A\", \"studentId\": \"df6dabb7-1d6c-4237-b48a-9302e9edfba8\", \"nchmctRollNo\": \"NCHM2026102\", \"condonationHours\": 1, \"eligibilityStatus\": \"ELIGIBLE\", \"totalPresentHours\": 0, \"totalConductedHours\": 1, \"approvedMedicalHours\": 0, \"effectiveAttendedHours\": 1, \"overallAttendancePercentage\": 100}], \"generatedAt\": \"2026-10-17T04:49:31.596Z\", \"institution\": {\"name\": \"Institute of Hotel Management, Catering Technology & Applied Nutrition, Kolkata\", \"affiliatingBody\": \"National Council for Hotel Management and Catering Technology (NCHMCT)\"}, \"reportMonth\": \"2026-10\", \"cohortStatistics\": {\"warningCount\": 0, \"criticalCount\": 0, \"detainedCount\": 1, \"eligibleCount\": 2, \"totalStudents\": 3, \"averageCohortPercentage\": 66.67}}','5f6f92e5973a57c2a8f201e68f9d779c17ba3ef405a8fb8f54825976d8e38f62','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','2026-10-17 04:49:31.602'); /*!40000 ALTER TABLE `apr_reports` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `attendance_policies` -- DROP TABLE IF EXISTS `attendance_policies`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `attendance_policies` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `version` int NOT NULL DEFAULT '1', `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `min_attendance_pct` decimal(5,2) NOT NULL DEFAULT '75.00', `warning_level_pct` decimal(5,2) NOT NULL DEFAULT '70.00', `critical_level_pct` decimal(5,2) NOT NULL DEFAULT '65.00', `apr_exclusion_floor_pct` decimal(5,2) NOT NULL DEFAULT '20.00', `medical_max_ceiling_pct` decimal(5,2) NOT NULL DEFAULT '10.00', `is_active` tinyint(1) NOT NULL DEFAULT '0', `effective_from` date NOT NULL, `effective_to` date DEFAULT NULL, `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `updated_at` datetime(3) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `attendance_policies_version_key` (`version`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `attendance_policies` -- LOCK TABLES `attendance_policies` WRITE; /*!40000 ALTER TABLE `attendance_policies` DISABLE KEYS */; INSERT INTO `attendance_policies` VALUES ('1325ccbb-1c22-472b-b3e2-0610c57a35cb',1,'NCHMCT Standard Attendance & Medical Policy',75.00,70.00,65.00,20.00,10.00,1,'2026-01-01',NULL,'2026-10-17 04:38:11.498','2026-10-17 04:38:11.498'); /*!40000 ALTER TABLE `attendance_policies` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `attendance_records` -- DROP TABLE IF EXISTS `attendance_records`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `attendance_records` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `attendance_session_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `student_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `status_code` enum('P','A','C') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'A', `units_awarded` decimal(4,1) NOT NULL DEFAULT '0.0', `remarks` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `updated_at` datetime(3) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `attendance_records_attendance_session_id_student_id_key` (`attendance_session_id`,`student_id`), KEY `attendance_records_student_id_idx` (`student_id`), CONSTRAINT `attendance_records_attendance_session_id_fkey` FOREIGN KEY (`attendance_session_id`) REFERENCES `attendance_sessions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `attendance_records_student_id_fkey` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `attendance_records` -- LOCK TABLES `attendance_records` WRITE; /*!40000 ALTER TABLE `attendance_records` DISABLE KEYS */; INSERT INTO `attendance_records` VALUES ('4d30c07e-d304-45a9-b15c-36309e1bb405','43276f87-a517-4595-9460-ad2f52733e7a','ad45f3a0-8f76-489d-8a7d-71902cb1db44','P',1.0,NULL,'2026-10-17 05:52:07.158','2026-10-17 05:52:07.189'),('56b974bb-dbb2-47b4-91ec-464dcdedf154','0b9d9f43-0746-4d3e-aab0-2edf2cf2d371','d55e8ba9-9cf6-473f-9d13-53a8c34c6b72','A',0.0,'Marked absent in ATT-004 test','2026-10-22 11:53:35.053','2026-10-22 11:53:35.087'),('68653aa8-8b5c-4261-a395-bcfc63b096fe','0dc528bf-0c3a-41ea-b39a-caa880f9f16c','ad45f3a0-8f76-489d-8a7d-71902cb1db44','P',1.0,'Present in kitchen lab','2026-10-17 04:38:52.759','2026-10-17 04:38:52.866'),('c6f186bc-3480-4494-9107-8a88672bd479','0dc528bf-0c3a-41ea-b39a-caa880f9f16c','df6dabb7-1d6c-4237-b48a-9302e9edfba8','C',1.0,'Approved NSS duty','2026-10-17 04:38:52.763','2026-10-17 04:38:52.873'),('e42f9536-1aa0-4d43-9ccb-47021bce926b','43276f87-a517-4595-9460-ad2f52733e7a','df6dabb7-1d6c-4237-b48a-9302e9edfba8','A',0.0,NULL,'2026-10-17 05:52:07.161','2026-10-17 05:52:07.197'); /*!40000 ALTER TABLE `attendance_records` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `attendance_sessions` -- DROP TABLE IF EXISTS `attendance_sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `attendance_sessions` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `timetable_id` varchar(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `academic_session_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `semester_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `subject_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `group_id` varchar(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `session_date` date NOT NULL, `scheduled_start_time` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL, `scheduled_end_time` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL, `scheduled_hours` decimal(4,1) NOT NULL, `actual_start_time` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `actual_end_time` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `actual_conducted_hours` decimal(4,1) NOT NULL DEFAULT '0.0', `attendance_units` decimal(4,1) NOT NULL DEFAULT '1.0', `scheduled_faculty_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `actual_faculty_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `status` enum('SCHEDULED','OPEN','DRAFT','FINALIZED','LOCKED','CANCELLED','RESCHEDULED','HOLIDAY') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'SCHEDULED', `version` int NOT NULL DEFAULT '1', `unlocked_reason` text COLLATE utf8mb4_unicode_ci, `unlocked_by` varchar(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `updated_at` datetime(3) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `attendance_sessions_timetable_id_session_date_scheduled_star_key` (`timetable_id`,`session_date`,`scheduled_start_time`), KEY `attendance_sessions_session_date_status_idx` (`session_date`,`status`), KEY `attendance_sessions_subject_id_session_date_idx` (`subject_id`,`session_date`), KEY `attendance_sessions_academic_session_id_fkey` (`academic_session_id`), KEY `attendance_sessions_semester_id_fkey` (`semester_id`), KEY `attendance_sessions_group_id_fkey` (`group_id`), KEY `attendance_sessions_scheduled_faculty_id_fkey` (`scheduled_faculty_id`), KEY `attendance_sessions_actual_faculty_id_fkey` (`actual_faculty_id`), CONSTRAINT `attendance_sessions_academic_session_id_fkey` FOREIGN KEY (`academic_session_id`) REFERENCES `academic_sessions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `attendance_sessions_actual_faculty_id_fkey` FOREIGN KEY (`actual_faculty_id`) REFERENCES `faculty` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE, CONSTRAINT `attendance_sessions_group_id_fkey` FOREIGN KEY (`group_id`) REFERENCES `student_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `attendance_sessions_scheduled_faculty_id_fkey` FOREIGN KEY (`scheduled_faculty_id`) REFERENCES `faculty` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE, CONSTRAINT `attendance_sessions_semester_id_fkey` FOREIGN KEY (`semester_id`) REFERENCES `semesters` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `attendance_sessions_subject_id_fkey` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `attendance_sessions_timetable_id_fkey` FOREIGN KEY (`timetable_id`) REFERENCES `timetables` (`id`) ON DELETE SET NULL ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `attendance_sessions` -- LOCK TABLES `attendance_sessions` WRITE; /*!40000 ALTER TABLE `attendance_sessions` DISABLE KEYS */; INSERT INTO `attendance_sessions` VALUES ('0b9d9f43-0746-4d3e-aab0-2edf2cf2d371','812033a8-ae3e-4d3d-8177-6fa6a4f969a7','90d47503-54e7-468a-b1a1-871d9c9c8988','fb69305f-fbe0-4428-adec-2178e01715fc','f94445e2-3b73-4f98-a3f3-186950397f2a','ca358a7b-088d-48aa-a7c6-e41150b69e97','2026-10-26','09:00','13:00',4.0,NULL,NULL,4.0,4.0,'c557e8d4-b1ec-45b5-b6d0-1fc0482e7695','c557e8d4-b1ec-45b5-b6d0-1fc0482e7695','DRAFT',3,NULL,NULL,'2026-10-17 04:38:52.659','2026-10-22 11:53:35.090'),('0dc528bf-0c3a-41ea-b39a-caa880f9f16c','14701dfd-f5ff-40fd-ac09-35b67f0d3cdf','90d47503-54e7-468a-b1a1-871d9c9c8988','fb69305f-fbe0-4428-adec-2178e01715fc','f94445e2-3b73-4f98-a3f3-186950397f2a','8e40c464-1e35-472d-8ef4-af81fc1ccd9b','2026-10-26','13:00','14:00',1.0,'13:00','14:00',1.0,1.0,'054364fc-2e0a-4a01-826d-c734590f957e','054364fc-2e0a-4a01-826d-c734590f957e','FINALIZED',5,'HOD approved rectification: Student Aarav Sharma was on official event duty','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','2026-10-17 04:38:52.647','2026-10-17 04:38:52.882'),('43276f87-a517-4595-9460-ad2f52733e7a','14701dfd-f5ff-40fd-ac09-35b67f0d3cdf','90d47503-54e7-468a-b1a1-871d9c9c8988','fb69305f-fbe0-4428-adec-2178e01715fc','f94445e2-3b73-4f98-a3f3-186950397f2a','8e40c464-1e35-472d-8ef4-af81fc1ccd9b','2026-11-16','13:00','14:00',1.0,'13:00','14:00',1.0,1.0,'054364fc-2e0a-4a01-826d-c734590f957e','054364fc-2e0a-4a01-826d-c734590f957e','FINALIZED',3,NULL,NULL,'2026-10-17 05:52:07.098','2026-10-17 05:52:07.203'),('dd6adf7b-78fe-469d-8623-f89ab6939347','14701dfd-f5ff-40fd-ac09-35b67f0d3cdf','90d47503-54e7-468a-b1a1-871d9c9c8988','fb69305f-fbe0-4428-adec-2178e01715fc','f94445e2-3b73-4f98-a3f3-186950397f2a','8e40c464-1e35-472d-8ef4-af81fc1ccd9b','2026-11-02','13:00','14:00',1.0,NULL,NULL,1.0,1.0,'054364fc-2e0a-4a01-826d-c734590f957e','c557e8d4-b1ec-45b5-b6d0-1fc0482e7695','SCHEDULED',2,NULL,NULL,'2026-10-17 04:38:52.911','2026-10-17 04:38:52.957'),('efaac51f-5f86-4c0a-bbbb-0d0df6a0876c','812033a8-ae3e-4d3d-8177-6fa6a4f969a7','90d47503-54e7-468a-b1a1-871d9c9c8988','fb69305f-fbe0-4428-adec-2178e01715fc','f94445e2-3b73-4f98-a3f3-186950397f2a','ca358a7b-088d-48aa-a7c6-e41150b69e97','2026-11-16','09:00','13:00',4.0,NULL,NULL,4.0,4.0,'c557e8d4-b1ec-45b5-b6d0-1fc0482e7695','c557e8d4-b1ec-45b5-b6d0-1fc0482e7695','SCHEDULED',1,NULL,NULL,'2026-10-17 05:52:07.108','2026-10-17 05:52:07.108'),('fbaaa91d-0bb2-47d0-83e6-889f3996eab1','812033a8-ae3e-4d3d-8177-6fa6a4f969a7','90d47503-54e7-468a-b1a1-871d9c9c8988','fb69305f-fbe0-4428-adec-2178e01715fc','f94445e2-3b73-4f98-a3f3-186950397f2a','ca358a7b-088d-48aa-a7c6-e41150b69e97','2026-11-02','09:00','13:00',4.0,NULL,NULL,4.0,4.0,'c557e8d4-b1ec-45b5-b6d0-1fc0482e7695','c557e8d4-b1ec-45b5-b6d0-1fc0482e7695','SCHEDULED',1,NULL,NULL,'2026-10-17 04:38:52.920','2026-10-17 04:38:52.920'); /*!40000 ALTER TABLE `attendance_sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `audit_logs` -- DROP TABLE IF EXISTS `audit_logs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `audit_logs` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` varchar(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `action` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `entity_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `entity_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `previous_state` json DEFAULT NULL, `new_state` json DEFAULT NULL, `reason` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_agent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), PRIMARY KEY (`id`), KEY `audit_logs_entity_name_entity_id_idx` (`entity_name`,`entity_id`), KEY `audit_logs_user_id_fkey` (`user_id`), CONSTRAINT `audit_logs_user_id_fkey` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `audit_logs` -- LOCK TABLES `audit_logs` WRITE; /*!40000 ALTER TABLE `audit_logs` DISABLE KEYS */; INSERT INTO `audit_logs` VALUES ('025e93f6-c5a0-411f-b4fc-e805ac4bcfbc','d2e9d278-5d54-43fc-b106-6f5d1465c70f','ATTENDANCE_FINALIZED','AttendanceSession','ec229797-915d-4d3e-8dda-28423fc62caa','{\"status\": \"DRAFT\", \"version\": 2}','{\"status\": \"FINALIZED\", \"recordsMarked\": 2}',NULL,'::1','node','2026-10-17 05:09:21.821'),('058380b5-eb13-4797-9580-8f0c7331f591','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','ATTENDANCE_UNLOCKED','AttendanceSession','226fac26-5bd9-4c98-a69e-77750e5009e2','{\"status\": \"FINALIZED\"}','{\"status\": \"DRAFT\"}','HOD approved rectification: Student Aarav Sharma was on official event duty','::1','node','2026-10-16 12:51:54.336'),('05b7b4cf-2c31-4907-b90c-69420ad2c908','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','PASSWORD_RESET_COMPLETED','User','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc',NULL,NULL,'Self-service password reset completed via verified email token.',NULL,NULL,'2026-10-17 07:27:34.740'),('0a67430d-903a-4f2a-8bae-415847d2b40d','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','ATTENDANCE_FINALIZED','AttendanceSession','226fac26-5bd9-4c98-a69e-77750e5009e2','{\"status\": \"DRAFT\", \"version\": 4}','{\"status\": \"FINALIZED\", \"recordsMarked\": 2}',NULL,'::1','node','2026-10-16 12:51:54.367'),('104391a9-e84d-49cc-b1ea-fca1fe21d904','37f2fdec-67e6-439b-958d-2ec85e9b1183','MEDICAL_REQUEST_SUBMITTED','MedicalRequest','38bc5941-a0ec-4adf-b65b-4c3347167ce6',NULL,'{\"endDate\": \"2026-10-23\", \"startDate\": \"2026-10-21\", \"studentId\": \"ad45f3a0-8f76-489d-8a7d-71902cb1db44\", \"certificateRef\": \"https://storage.ihm.ac.in/medical/aarav_medical_oct2026.pdf\", \"requestedHours\": 6}',NULL,NULL,NULL,'2026-10-17 04:38:11.559'),('11ebb163-7ac7-4367-b1b0-f21b31ec0cb0','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','ATTENDANCE_UNLOCKED','AttendanceSession','a6a1c7f6-cac9-4add-b27b-786746700bf6','{\"status\": \"FINALIZED\"}','{\"status\": \"DRAFT\"}','HOD approved rectification: Student Aarav Sharma was on official event duty','::1','node','2026-10-16 13:00:04.689'),('19fa706e-1bd0-46bf-ae7a-e4ca8315e121','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','CONDONATION_REQUEST_SUBMITTED','CondonationRequest','76260282-2a3d-4040-9397-f09faeb09734',NULL,'{\"eventName\": \"Unrecognized private club workshop\", \"studentId\": \"ad45f3a0-8f76-489d-8a7d-71902cb1db44\", \"grantedHours\": 5}',NULL,NULL,NULL,'2026-10-17 04:38:11.718'),('220d8ba3-18df-4cde-80b4-83cd45234f48','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','ATTENDANCE_UNLOCKED','AttendanceSession','226fac26-5bd9-4c98-a69e-77750e5009e2','{\"status\": \"FINALIZED\"}','{\"status\": \"DRAFT\"}','HOD approved rectification: Student Aarav Sharma was on official event duty','::1','node','2026-10-16 12:52:45.489'),('2332414a-7a3e-4347-8e1a-01c042a63a8c','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','ATTENDANCE_FINALIZED','AttendanceSession','0dc528bf-0c3a-41ea-b39a-caa880f9f16c','{\"status\": \"DRAFT\", \"version\": 4}','{\"status\": \"FINALIZED\", \"recordsMarked\": 2}',NULL,'::1','node','2026-10-17 04:38:52.885'),('245119e6-74d3-4322-9728-80b92b5806cd','d2e9d278-5d54-43fc-b106-6f5d1465c70f','ATTENDANCE_FINALIZED','AttendanceSession','a6a1c7f6-cac9-4add-b27b-786746700bf6','{\"status\": \"DRAFT\", \"version\": 2}','{\"status\": \"FINALIZED\", \"recordsMarked\": 2}',NULL,'::1','node','2026-10-16 13:00:04.663'),('2c3cc3b8-4db6-46e4-9187-df77d6b2c385','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','SUMMARY_REBUILT','StudentSubjectSummary','fb69305f-fbe0-4428-adec-2178e01715fc',NULL,'{\"filter\": {\"semesterId\": \"fb69305f-fbe0-4428-adec-2178e01715fc\"}, \"summariesRebuilt\": 2}',NULL,NULL,NULL,'2026-10-17 05:52:07.339'),('36951441-4d47-4377-86fd-a3b4c4657e53','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','PASSWORD_RESET_COMPLETED','User','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc',NULL,NULL,'Self-service password reset completed via verified email token.',NULL,NULL,'2026-10-17 07:27:35.007'),('36f15237-cfae-4e52-b71c-d8fd3fe51c83','d2e9d278-5d54-43fc-b106-6f5d1465c70f','ATTENDANCE_FINALIZED','AttendanceSession','5f9089cc-a5bd-4eeb-b67a-af210c99f679','{\"status\": \"DRAFT\", \"version\": 2}','{\"status\": \"FINALIZED\", \"recordsMarked\": 2}',NULL,'::1','node','2026-10-17 05:11:16.157'),('3aabb36d-4b4b-43a5-837a-5f232fa2e89b','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','ATTENDANCE_UNLOCKED','AttendanceSession','0dc528bf-0c3a-41ea-b39a-caa880f9f16c','{\"status\": \"FINALIZED\"}','{\"status\": \"DRAFT\"}','HOD approved rectification: Student Aarav Sharma was on official event duty','::1','node','2026-10-17 04:38:52.848'),('400dfab9-f87e-4261-9b03-8ea235ce2242','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','MEDICAL_REQUEST_REJECTED','MedicalRequest','a1695bb4-a868-41a3-a80a-164d21e0f371','{\"status\": \"PENDING\"}','{\"status\": \"REJECTED\", \"approvedHours\": 0}','Ceiling reached, rejected by policy','::1','node','2026-10-17 05:52:07.251'),('417c4a4b-535b-402f-bf55-2879c9922d1b','ea2d8b70-ca66-4b4f-bf25-595db63689ed','USER_ROLE_UPDATED','User','f222e266-14ab-482c-b819-f712b23bac99','{\"role\": \"ACADEMIC_ADMIN\"}','{\"role\": \"HOD\"}',NULL,NULL,NULL,'2026-10-17 05:51:17.231'),('470ff681-2e01-4184-a7a0-1df247c2ca0f','ea2d8b70-ca66-4b4f-bf25-595db63689ed','USER_CREATED','User','f222e266-14ab-482c-b819-f712b23bac99',NULL,'{\"role\": \"ACADEMIC_ADMIN\", \"email\": \"temp.staff.1792216276944@ihm.ac.in\"}',NULL,NULL,NULL,'2026-10-17 05:51:17.210'),('4a7352ec-0fb6-43eb-98b6-9d96a789cb6f','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','PASSWORD_RESET_COMPLETED','User','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc',NULL,NULL,'Self-service password reset completed via verified email token.',NULL,NULL,'2026-10-17 07:14:29.970'),('57403b3a-f920-4dd7-a3d0-11496116f56b','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','ATTENDANCE_FINALIZED','AttendanceSession','226fac26-5bd9-4c98-a69e-77750e5009e2','{\"status\": \"DRAFT\", \"version\": 6}','{\"status\": \"FINALIZED\", \"recordsMarked\": 2}',NULL,'::1','node','2026-10-16 12:52:45.520'),('57607945-3063-47f9-8175-3638e901b4af','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','MEDICAL_REQUEST_REJECTED','MedicalRequest','7efdc16f-e4a5-4f49-beab-8c3f69853f63','{\"status\": \"PENDING\"}','{\"status\": \"REJECTED\", \"approvedHours\": 0}','Ceiling reached, rejected by policy','::1','node','2026-10-17 05:11:16.206'),('5971e07e-9894-408a-af00-18c03a4ddca0','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','CONDONATION_REQUEST_REJECTED','CondonationRequest','76260282-2a3d-4040-9397-f09faeb09734','{\"status\": \"PENDING\"}','{\"status\": \"REJECTED\", \"grantedHours\": 0}','Not an authorized or approved institutional event.','::1','node','2026-10-17 04:38:11.736'),('5b28ab74-ad24-4b9b-94b1-f65929ad5aac','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','PASSWORD_RESET_COMPLETED','User','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc',NULL,NULL,'Self-service password reset completed via verified email token.',NULL,NULL,'2026-10-17 09:05:39.712'),('5bf23955-764f-4756-9c28-9ba306cb4ee2','ea2d8b70-ca66-4b4f-bf25-595db63689ed','MANUAL_BACKUP_TRIGGERED','Database','ihm_attendance',NULL,'{\"backupFileName\": \"ihm_attendance_backup_2026-10-17T05-51-17-248Z.sql.gz\"}','Super Administrator initiated on-demand transactional database backup.',NULL,NULL,'2026-10-17 05:51:17.249'),('620d1880-ddb3-460b-a305-bf2ecfe08334','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','PASSWORD_RESET_COMPLETED','User','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc',NULL,NULL,'Self-service password reset completed via verified email token.',NULL,NULL,'2026-10-17 10:54:27.394'),('63ea1774-b97b-4078-9250-db6afffeff6a','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','PASSWORD_RESET_COMPLETED','User','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc',NULL,NULL,'Self-service password reset completed via verified email token.',NULL,NULL,'2026-10-17 07:13:21.623'),('6bdcb2f3-117d-4753-93f0-78b1511e29a9','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','APR_FROZEN','APRReport','fa2f4650-67aa-440f-ac06-add69af1d141',NULL,'{\"semesterId\": \"fb69305f-fbe0-4428-adec-2178e01715fc\", \"reportMonth\": \"2026-11\", \"detainedCount\": 2, \"policyVersion\": 1, \"totalStudents\": 3, \"checksumSha256\": \"350f588fae7a8c281d787f1577b24f576771d782e2369e91be561dd4c2045b74\"}',NULL,'::1','node','2026-10-17 05:11:16.317'),('6d1c3c16-eaf6-4757-ae9d-498a06655922','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','SUMMARY_REBUILT','StudentSubjectSummary','fb69305f-fbe0-4428-adec-2178e01715fc',NULL,'{\"filter\": {\"semesterId\": \"fb69305f-fbe0-4428-adec-2178e01715fc\"}, \"summariesRebuilt\": 2}',NULL,NULL,NULL,'2026-10-17 04:49:31.557'),('72b9ca86-8fe7-4328-893a-fba08224492a','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','SUMMARY_REBUILT','StudentSubjectSummary','fb69305f-fbe0-4428-adec-2178e01715fc',NULL,'{\"filter\": {\"semesterId\": \"fb69305f-fbe0-4428-adec-2178e01715fc\"}, \"summariesRebuilt\": 2}',NULL,NULL,NULL,'2026-10-17 05:11:16.284'),('82181b31-42df-49f2-952d-7be0d9c62dcf','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','PASSWORD_RESET_COMPLETED','User','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc',NULL,NULL,'Self-service password reset completed via verified email token.',NULL,NULL,'2026-10-17 07:15:45.952'),('87c50e98-668a-4e4e-8fcd-e6547dbfa19f','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','APR_FROZEN','APRReport','7b778629-80d6-4dee-967f-5aa117048b07',NULL,'{\"semesterId\": \"fb69305f-fbe0-4428-adec-2178e01715fc\", \"reportMonth\": \"2026-10\", \"detainedCount\": 1, \"policyVersion\": 1, \"totalStudents\": 3, \"checksumSha256\": \"5f6f92e5973a57c2a8f201e68f9d779c17ba3ef405a8fb8f54825976d8e38f62\"}',NULL,'::1','node','2026-10-17 04:49:31.606'),('8942fe3e-fa7b-4553-bbb5-09808066a70c','ea2d8b70-ca66-4b4f-bf25-595db63689ed','MANUAL_BACKUP_TRIGGERED','Database','ihm_attendance',NULL,'{\"backupFileName\": \"ihm_attendance_backup_2026-10-17T05-48-50-810Z.sql.gz\"}','Super Administrator initiated on-demand transactional database backup.',NULL,NULL,'2026-10-17 05:48:50.818'),('894df6a1-311b-4fcb-8385-5f6d80133fca','37f2fdec-67e6-439b-958d-2ec85e9b1183','MEDICAL_REQUEST_SUBMITTED','MedicalRequest','85954cb1-5a19-4646-8b01-645927803f27',NULL,'{\"endDate\": \"2026-11-12\", \"startDate\": \"2026-11-10\", \"studentId\": \"ad45f3a0-8f76-489d-8a7d-71902cb1db44\", \"certificateRef\": \"DOC-MED-NOV2026.pdf\", \"requestedHours\": 2}',NULL,NULL,NULL,'2026-10-17 05:09:21.842'),('8bc8d260-8bb0-4054-806c-6d6aca83b61e','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','PASSWORD_RESET_COMPLETED','User','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc',NULL,NULL,'Self-service password reset completed via verified email token.',NULL,NULL,'2026-10-17 07:14:30.324'),('91e2a55a-1945-44a6-8e3d-9c9f2f17da70','37f2fdec-67e6-439b-958d-2ec85e9b1183','MEDICAL_REQUEST_SUBMITTED','MedicalRequest','7efdc16f-e4a5-4f49-beab-8c3f69853f63',NULL,'{\"endDate\": \"2026-11-12\", \"startDate\": \"2026-11-10\", \"studentId\": \"ad45f3a0-8f76-489d-8a7d-71902cb1db44\", \"certificateRef\": \"DOC-MED-NOV2026.pdf\", \"requestedHours\": 2}',NULL,NULL,NULL,'2026-10-17 05:11:16.178'),('91e3bb49-d3cd-4e53-8f36-29822e0cae2b','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','ACCOUNT_TEMPORARILY_LOCKED','User','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc',NULL,NULL,'Account locked for 10 minutes following 5 consecutive failed login attempts. Source IP: ::1.',NULL,NULL,'2026-10-17 10:53:53.652'),('9301788d-36c6-455a-ad11-72516745d394','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','CONDONATION_REQUEST_SUBMITTED','CondonationRequest','18097029-fc4f-4968-a294-89e0d774f721',NULL,'{\"eventName\": \"All India Inter-Hotel Management Culinary Trophy 2026\", \"studentId\": \"ad45f3a0-8f76-489d-8a7d-71902cb1db44\", \"grantedHours\": 4}',NULL,NULL,NULL,'2026-10-17 04:38:11.676'),('9b119677-e79e-44f9-b5d1-82a97fb4b518','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','APR_FROZEN','APRReport','2a62815b-1784-4324-8517-aad261afe0be',NULL,'{\"semesterId\": \"fb69305f-fbe0-4428-adec-2178e01715fc\", \"reportMonth\": \"2026-11\", \"detainedCount\": 2, \"policyVersion\": 1, \"totalStudents\": 3, \"checksumSha256\": \"8578015456d40d8efa6db0495282ad221c7f92791a021024b554b8914875b238\"}',NULL,'::1','node','2026-10-17 05:52:07.368'),('9b555e8e-60bf-4bfb-a2f1-8475661b000b','d2e9d278-5d54-43fc-b106-6f5d1465c70f','ATTENDANCE_FINALIZED','AttendanceSession','0dc528bf-0c3a-41ea-b39a-caa880f9f16c','{\"status\": \"DRAFT\", \"version\": 2}','{\"status\": \"FINALIZED\", \"recordsMarked\": 2}',NULL,'::1','node','2026-10-17 04:38:52.816'),('9d679493-6624-4fc8-8c87-fbbd6595a63c','d2e9d278-5d54-43fc-b106-6f5d1465c70f','ATTENDANCE_FINALIZED','AttendanceSession','43276f87-a517-4595-9460-ad2f52733e7a','{\"status\": \"DRAFT\", \"version\": 2}','{\"status\": \"FINALIZED\", \"recordsMarked\": 2}',NULL,'::1','node','2026-10-17 05:52:07.206'),('a3df3cf4-510e-4cbd-b94d-760dec65fb53','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','MEDICAL_REQUEST_APPROVED','MedicalRequest','38bc5941-a0ec-4adf-b65b-4c3347167ce6','{\"status\": \"PENDING\"}','{\"status\": \"APPROVED\", \"approvedHours\": 0.25}','Medical certificate verified with Woodlands Hospital OPD counter','::1','node','2026-10-17 04:38:11.642'),('a40c0f7b-d2c4-4696-ab94-5942042528f5','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','PASSWORD_RESET_COMPLETED','User','f898fcaf-05a5-43ab-9b9f-f95baef8efd7',NULL,NULL,'Self-service password reset completed via verified email token.',NULL,NULL,'2026-10-17 05:48:49.428'),('b0361407-64b5-4361-b5c9-9e4a996e5950','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','PASSWORD_RESET_COMPLETED','User','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc',NULL,NULL,'Self-service password reset completed via verified email token.',NULL,NULL,'2026-10-17 07:15:46.220'),('b26451e2-c6ec-44b0-b03a-89b30cbca123','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','PASSWORD_RESET_COMPLETED','User','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc',NULL,NULL,'Self-service password reset completed via verified email token.',NULL,NULL,'2026-10-17 07:13:21.892'),('b8966209-d20b-4753-a62f-655e77e8c733','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','CONDONATION_REQUEST_APPROVED','CondonationRequest','18097029-fc4f-4968-a294-89e0d774f721','{\"status\": \"PENDING\"}','{\"status\": \"APPROVED\", \"grantedHours\": 4}','Approved as per institutional co-curricular duty norms','::1','node','2026-10-17 04:38:11.701'),('bb666792-3e2c-4166-916b-bf541cdfd93c','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','APR_FROZEN','APRReport','03f8e1b4-72e7-4ff3-abcb-adfcacfbb8b7',NULL,'{\"semesterId\": \"fb69305f-fbe0-4428-adec-2178e01715fc\", \"reportMonth\": \"2026-11\", \"detainedCount\": 2, \"policyVersion\": 1, \"totalStudents\": 3, \"checksumSha256\": \"eeaaf89ed0750fa7714286e0e414bf17eead7b9808b5f1f7d9ef71540eab0a55\"}',NULL,'::1','node','2026-10-17 05:09:22.023'),('cb9bbf1e-6aaa-4d44-9dd7-e2c7c1de5a36','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','PASSWORD_RESET_COMPLETED','User','f898fcaf-05a5-43ab-9b9f-f95baef8efd7',NULL,NULL,'Self-service password reset completed via verified email token.',NULL,NULL,'2026-10-17 05:51:15.981'),('cf2837ab-45b6-48a8-b771-fe2872500d8d','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','ATTENDANCE_FINALIZED','AttendanceSession','a6a1c7f6-cac9-4add-b27b-786746700bf6','{\"status\": \"DRAFT\", \"version\": 4}','{\"status\": \"FINALIZED\", \"recordsMarked\": 2}',NULL,'::1','node','2026-10-16 13:00:04.720'),('d6ca255f-4c93-4a4a-acc9-07405195a795','d2e9d278-5d54-43fc-b106-6f5d1465c70f','ATTENDANCE_FINALIZED','AttendanceSession','226fac26-5bd9-4c98-a69e-77750e5009e2','{\"status\": \"DRAFT\", \"version\": 2}','{\"status\": \"FINALIZED\", \"recordsMarked\": 2}',NULL,'::1','node','2026-10-16 12:51:54.304'),('e15d8f98-07c9-47f8-899d-b20d29179080','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','SUMMARY_REBUILT','StudentSubjectSummary','fb69305f-fbe0-4428-adec-2178e01715fc',NULL,'{\"filter\": {\"semesterId\": \"fb69305f-fbe0-4428-adec-2178e01715fc\"}, \"summariesRebuilt\": 2}',NULL,NULL,NULL,'2026-10-17 05:09:21.972'),('e1db3a1c-dc71-4c3d-a545-dbe03d5e689a','ea2d8b70-ca66-4b4f-bf25-595db63689ed','USER_ROLE_UPDATED','User','3e870d57-6512-4fbd-847c-2ff980c744e3','{\"role\": \"ACADEMIC_ADMIN\"}','{\"role\": \"HOD\"}',NULL,NULL,NULL,'2026-10-17 05:48:50.797'),('e4ab45ba-cd6f-4fcc-a8f1-6170c9e45fd0','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','ACCOUNT_TEMPORARILY_LOCKED','User','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc',NULL,NULL,'Account locked for 10 minutes following 5 consecutive failed login attempts. Source IP: ::1.',NULL,NULL,'2026-10-17 10:53:49.139'),('f94b85bc-c5e7-4944-878a-144fea66f23b','ea2d8b70-ca66-4b4f-bf25-595db63689ed','USER_CREATED','User','3e870d57-6512-4fbd-847c-2ff980c744e3',NULL,'{\"role\": \"ACADEMIC_ADMIN\", \"email\": \"temp.staff.1792216130476@ihm.ac.in\"}',NULL,NULL,NULL,'2026-10-17 05:48:50.770'),('febe7768-7bc0-433d-a802-2db1e9758d20','37f2fdec-67e6-439b-958d-2ec85e9b1183','MEDICAL_REQUEST_SUBMITTED','MedicalRequest','a1695bb4-a868-41a3-a80a-164d21e0f371',NULL,'{\"endDate\": \"2026-11-12\", \"startDate\": \"2026-11-10\", \"studentId\": \"ad45f3a0-8f76-489d-8a7d-71902cb1db44\", \"certificateRef\": \"DOC-MED-NOV2026.pdf\", \"requestedHours\": 2}',NULL,NULL,NULL,'2026-10-17 05:52:07.223'); /*!40000 ALTER TABLE `audit_logs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auth_sessions` -- DROP TABLE IF EXISTS `auth_sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `auth_sessions` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `refresh_token_hash` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_agent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `expires_at` datetime(3) NOT NULL, `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `revoked_at` datetime(3) DEFAULT NULL, PRIMARY KEY (`id`), KEY `auth_sessions_user_id_idx` (`user_id`), CONSTRAINT `auth_sessions_user_id_fkey` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auth_sessions` -- LOCK TABLES `auth_sessions` WRITE; /*!40000 ALTER TABLE `auth_sessions` DISABLE KEYS */; INSERT INTO `auth_sessions` VALUES ('00cc5191-9106-4dbe-81d1-5971148713a8','13f38306-99d7-4068-9899-744e04793548','0715b85391257ddff81ee19a6e6dc4cefcec7e6b3e552240fb501b8262ddd5c5','::1','node','2026-10-24 09:12:22.144','2026-10-17 09:12:22.147','2026-10-17 11:31:33.197'),('0176771c-8d2e-43b8-a21b-642cc31cee58','ea2d8b70-ca66-4b4f-bf25-595db63689ed','521374c5abc0c5d3a628f107c0d724092112e36f5c2d7bf13d7680edef8b3d48','::1','node','2026-10-24 11:33:20.553','2026-10-17 11:33:20.555','2026-10-17 11:33:20.564'),('019ad1c7-fac6-4bb2-9883-e983e7252ce8','ea2d8b70-ca66-4b4f-bf25-595db63689ed','9ede6df9fe69a574ff00effac28c7ad1406e24c99675bea664490983969181c3','::1','node','2026-10-24 07:15:42.636','2026-10-17 07:15:42.638','2026-10-17 07:15:42.660'),('025ffbbe-b987-4bd0-9af5-488a14fbb32e','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','9ede8c694ea7740b010cf2b976abb60b7acfd73e418f7d4174669f4c353b0da5','::1','node','2026-10-24 07:13:21.324','2026-10-17 07:13:21.326','2026-10-17 07:13:21.622'),('029d62e7-05be-49fd-943d-e4ecce7b0eaf','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','5c6fbbca8d1c03432a6db54d13f16b8026bac6ecf010368928a3b6c29ef9035c','::1','node','2026-10-24 10:55:15.678','2026-10-17 10:55:15.680','2026-10-17 11:31:33.477'),('02db7b8d-b688-40ed-a56e-0d73674bc0e3','d2e9d278-5d54-43fc-b106-6f5d1465c70f','46384288fd6a887f9dadf9f0e8816e6e9ec92b107caf712737e7f98fdcbdf049','::1','node','2026-10-24 09:12:21.504','2026-10-17 09:12:21.506','2026-10-17 11:31:32.567'),('032a8afc-ecdc-4af7-9e5f-871a4e5687ee','ea2d8b70-ca66-4b4f-bf25-595db63689ed','6d48b0d02be402b23690aec041133aa7756e5f22bcb8d217171ba327fa70f4e3','::1','node','2026-10-29 06:36:46.270','2026-10-22 06:36:46.279','2026-10-22 06:36:46.885'),('03655a7a-4351-4a67-8167-900296ed7e81','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','63e8a30e1392a6a2d7e129653de408aae707dda49576643242c01d72969ba251','::1','node','2026-10-24 07:13:18.871','2026-10-17 07:13:18.873','2026-10-17 07:13:19.402'),('053c40e0-a941-4cbc-8b13-d2235d742490','ea2d8b70-ca66-4b4f-bf25-595db63689ed','430d4b06760ea58e8f551cd7e79374e987858ecca4385c3faad9cb729a939904','::1','node','2026-10-24 11:33:21.374','2026-10-17 11:33:21.376','2026-10-17 11:33:21.390'),('05873421-16ea-4ed9-8640-e70b4021dd92','ea2d8b70-ca66-4b4f-bf25-595db63689ed','f7e434c275f628f00a6e1e47a135998b1ce55d58fce6f98fc97b358b45235e6f','::1','node','2026-10-29 07:34:04.520','2026-10-22 07:34:04.528','2026-10-22 07:34:04.553'),('063b1214-bf6a-4bbf-b18a-b6c145cb08de','ea2d8b70-ca66-4b4f-bf25-595db63689ed','257351fe08c0ea87c9175f7d82d08c0e915e016f3ba9b13014d7c96128d1edac','::1','node','2026-10-24 10:55:20.718','2026-10-17 10:55:20.719','2026-10-17 11:29:36.362'),('070a226d-3773-4788-ad1b-15d95e2f8ed8','ea2d8b70-ca66-4b4f-bf25-595db63689ed','f47d241a018dc14af5ca276ee150539ead73dd32ebfff0066526cbfc2675158e','::1','node','2026-10-24 07:00:37.271','2026-10-17 07:00:37.272','2026-10-17 07:13:17.258'),('0746409a-9dfb-4a87-a705-44f6b027a03d','ea2d8b70-ca66-4b4f-bf25-595db63689ed','7331da58d9094871b2a26cbfd2ea492e9f74529ed84aa487b115b90bcacf1db8','::1','node','2026-10-24 06:52:42.796','2026-10-17 06:52:42.798','2026-10-17 06:52:42.827'),('07487201-d4b2-4f24-8020-55b95ecb30bf','ea2d8b70-ca66-4b4f-bf25-595db63689ed','d62375554b784e9011893a9ab8874a3b9f5cd762c2b56a3869bcd97af3b5ef20','::1','node','2026-10-24 11:33:19.357','2026-10-17 11:33:19.359','2026-10-17 11:33:19.367'),('079f2347-5812-44ab-84fa-c91f50ede0cc','37f2fdec-67e6-439b-958d-2ec85e9b1183','0fa47f6f2847c6029139997be28960b5e026eaa27982051ae1b7d534005e0f84','::1','node','2026-10-29 07:34:06.444','2026-10-22 07:34:06.451','2026-10-22 07:34:06.468'),('08e5285f-3dde-478a-92d7-43fc6e4879fd','ea2d8b70-ca66-4b4f-bf25-595db63689ed','042099c0f740fe07cf20f62366cd0eadcb6b6f41304f28c1b3e6700224e2649a','::1','node','2026-10-29 07:34:02.982','2026-10-22 07:34:02.990','2026-10-22 07:34:03.007'),('0a045d67-93d7-45c4-88a9-27872881db42','ea2d8b70-ca66-4b4f-bf25-595db63689ed','69fa6996c046bf831ca481745cd7aa0f7da94136d2fd034af27929d04565c8da','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36','2026-10-29 06:06:52.894','2026-10-22 06:06:52.896','2026-10-22 06:13:33.740'),('0a1dbb74-6e1f-43b3-8941-555ceb33e3de','ea2d8b70-ca66-4b4f-bf25-595db63689ed','c79e1b563a9f40ddcf58e40761fed70dd941ed202f3589aa4924d1dcadb16eaa','::1','node','2026-10-29 07:34:03.917','2026-10-22 07:34:03.925','2026-10-22 07:34:04.574'),('0a5ceec4-6b96-4070-a9e0-fce23ba73cc2','ea2d8b70-ca66-4b4f-bf25-595db63689ed','c990eb810ad0dd8deea313679b7a0aa502805225c68cd7ba2ed94afe92f87c86','::1','node','2026-10-24 09:05:37.632','2026-10-17 09:05:37.634','2026-10-17 09:06:09.620'),('0a91424c-0c52-46c5-ae0e-7ccbc1b00f18','d2e9d278-5d54-43fc-b106-6f5d1465c70f','4acfbb439402aab79ec005bc36d919a0c8b13745664a8f8df19635745c4b7761','::1','node','2026-10-24 09:12:55.504','2026-10-17 09:12:55.507','2026-10-17 11:31:32.567'),('0a9e818c-e619-4d84-8329-50b067730fc3','ea2d8b70-ca66-4b4f-bf25-595db63689ed','a631e2bf3e9e41b974efc1fe52095ba53ca94f0de59f6b6e219e252384391684','::1','node','2026-10-29 07:32:20.661','2026-10-22 07:32:20.667','2026-10-22 07:32:21.001'),('0b1b3f9f-c348-4788-881b-9fe061220012','37f2fdec-67e6-439b-958d-2ec85e9b1183','f90f99a7e82800c79d6a06b2c73976a16a1fb99cd2879efeb64ddb338bafb866','::1','node','2026-10-24 07:27:33.633','2026-10-17 07:27:33.635','2026-10-17 11:31:32.914'),('0c5eea2f-4cf0-4a74-a535-24ae3d7a15c8','ea2d8b70-ca66-4b4f-bf25-595db63689ed','319ac52699891cce18977fecac1ee7df187a8dfe29bc6a9f9f7a13203630330b','::1','node','2026-10-24 07:27:35.569','2026-10-17 07:27:35.571','2026-10-17 09:05:36.239'),('0e1da6d8-c00b-4ea9-9e98-952230e3b045','37f2fdec-67e6-439b-958d-2ec85e9b1183','0dfd84be09a0f8bb2b487a7179d0cda93aa41063393c525ad01a670ddea90d73','::1','node','2026-10-24 09:06:11.119','2026-10-17 09:06:11.121','2026-10-17 11:31:32.914'),('0f5ece2c-fdfb-4023-b466-1898b5cb4318','ea2d8b70-ca66-4b4f-bf25-595db63689ed','7d917f5b824fd836f316985d365b40888ff450b208ff2b81099fe5e43e92e853','::1','node','2026-10-29 07:34:05.495','2026-10-22 07:34:05.503','2026-10-22 07:34:05.509'),('0f725344-3201-4709-95a2-53b808111b0f','ea2d8b70-ca66-4b4f-bf25-595db63689ed','8f60053c834e0473742c4dffb9ab75d825d1a89f4b5426f0077bf0bd332cb676','::1','node','2026-10-24 09:12:54.909','2026-10-17 09:12:54.912','2026-10-17 10:54:22.853'),('0f72bd08-5a4e-4f92-9eda-aa98873b13d5','ea2d8b70-ca66-4b4f-bf25-595db63689ed','bd8f55c60036dcb2d22c4ee106328ee7e133a8dbea1ae9a8cc2bb7ac9bfb582d','::1','node','2026-10-24 10:55:14.935','2026-10-17 10:55:14.937','2026-10-17 10:55:14.987'),('1087f829-96b4-4ddf-a6bf-ac251ed5963d','ea2d8b70-ca66-4b4f-bf25-595db63689ed','734a0784c230e17461b3fc289ead17267a6e9e5b7ae8d51344b3aa77a937e6fc','::1','node','2026-10-24 10:54:22.836','2026-10-17 10:54:22.839','2026-10-17 10:54:22.853'),('10e82aab-5a97-4e08-a9f2-33850c4fdc20','37f2fdec-67e6-439b-958d-2ec85e9b1183','daa7eb48b38c60ace9b3ee80dc264b0ef1a7e9fd56e039a1772024f2d8e66d30','::1','node','2026-10-29 06:36:48.598','2026-10-22 06:36:48.607','2026-10-22 06:36:48.612'),('1189eceb-1d54-47bd-86ee-49ccea7b0c15','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','ecda661ed2e235032f538f6f24e658e86605567ea66684c1ec71ab0e2e38c975','::1','node','2026-10-24 07:07:29.755','2026-10-17 07:07:29.756','2026-10-17 07:13:17.548'),('11a438a0-e11a-46aa-a7be-b1b3baec2e37','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','09a59d20ceebaefddbf3634e0d301e9fe2edf13a3204f42f254d1bc5be397282','::1','node','2026-10-24 05:11:15.307','2026-10-17 05:11:15.313','2026-10-17 05:48:49.407'),('12930c53-1c2b-4476-8ad8-504f472734a9','ea2d8b70-ca66-4b4f-bf25-595db63689ed','3939bfc0daf5014f1ca927ef2251b7bed35c203e8b305165c8b0e409241d230f','::1','node','2026-10-29 07:32:17.585','2026-10-22 07:32:17.591','2026-10-22 07:32:17.625'),('12f675fa-ed50-42d1-ba07-564dd88a9086','ea2d8b70-ca66-4b4f-bf25-595db63689ed','c3703e42c4b3e44ca735ffb552223cd39a9a9cf475b7fc1178cbbc609c22b8f0','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36','2026-10-29 09:16:08.533','2026-10-22 09:16:08.535','2026-10-22 09:16:24.888'),('1312fff0-2fe3-4916-8673-555ca0f239e7','ea2d8b70-ca66-4b4f-bf25-595db63689ed','0c6fc94ab3b472cc572b68eade97faf19d65cb7039934b35a3efdbdb304ee1c6','::1','node','2026-10-24 11:31:28.380','2026-10-17 11:31:28.382','2026-10-17 11:31:28.402'),('13e1d1f6-a65f-4f30-a71b-a4e0808defac','d2e9d278-5d54-43fc-b106-6f5d1465c70f','03ce12c556ce161507a3d344866f486fe3e3e95c4159112a891d298d57e9e69f','::1','node','2026-10-24 05:52:06.717','2026-10-17 05:52:06.719','2026-10-17 11:31:32.567'),('140caadc-6029-4287-b05f-a203c3726f63','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','7d2c8a07aaec6ae64829dd3f4b0751d58aa90b513a0434af0fbfc11285380fb6','::1','node','2026-10-24 05:51:16.249','2026-10-17 05:51:16.250','2026-10-17 05:51:16.779'),('14c58ec2-3b02-4b2e-8895-52b051fcf75a','ea2d8b70-ca66-4b4f-bf25-595db63689ed','e674090e61de50a142c2bb13368b8b6b51d0a627cce1414d0f96a8e970a4db2b','::1','node','2026-10-24 09:06:08.851','2026-10-17 09:06:08.853','2026-10-17 09:06:09.620'),('163d3007-f73a-4b0f-9940-79a469341957','ea2d8b70-ca66-4b4f-bf25-595db63689ed','89622dc2a622c376de61e276977bc75cdfe0f845ce0b88e52bf11bef5d537bcd','::1','node','2026-10-29 06:36:47.151','2026-10-22 06:36:47.160','2026-10-22 06:36:47.166'),('1672b3fd-18e1-4e60-9973-d0cab9d87fbf','ea2d8b70-ca66-4b4f-bf25-595db63689ed','044a91c8e9f57ae67700b26ce9d58c21fca87d9895a1fb3fb35abd8d3462e3d4','::1','node','2026-10-24 07:00:34.819','2026-10-17 07:00:34.820','2026-10-17 07:00:34.831'),('1848b278-67b2-4fca-958e-da5ea52e4b4a','ea2d8b70-ca66-4b4f-bf25-595db63689ed','4140d9aecc9f5cca796816e9e318b66148312790ac71047292fd7198fd860e4d','::1','node','2026-10-24 07:08:06.411','2026-10-17 07:08:06.412','2026-10-17 07:08:06.489'),('18cfc040-fafd-425e-9b7a-cd2a6ca183e8','ea2d8b70-ca66-4b4f-bf25-595db63689ed','720a74fc1f6208e65139c4b8e731a9e6e1c2bc4958fc110b916e3f99f8f48d2a','::1','node','2026-10-24 07:15:43.224','2026-10-17 07:15:43.226','2026-10-17 07:27:31.443'),('1a1aba0e-ef7f-483d-b4e1-e7292de2ee41','ea2d8b70-ca66-4b4f-bf25-595db63689ed','00e781531aa8b37a170db7a79977015e667d8d03f367c0bad0ec67638484b3df','::1','node','2026-10-29 07:34:04.219','2026-10-22 07:34:04.227','2026-10-22 07:34:04.545'),('1a46d70c-722b-4cb8-ae9c-6c5c8c462ca9','37f2fdec-67e6-439b-958d-2ec85e9b1183','a5955c21162a457559f90e56e0e13841bbf57435d8b9b71badde56c028eeea55','::1','node','2026-10-24 09:12:55.795','2026-10-17 09:12:55.798','2026-10-17 11:31:32.914'),('1a7cdea1-a1a5-4d27-b6c2-4a2543f1c943','ea2d8b70-ca66-4b4f-bf25-595db63689ed','b8922265c8321c26548ed2b336e3f063c0a890a7db062755a951d3ed2247f9c6','::1','node','2026-10-23 12:16:24.879','2026-10-16 12:16:24.880','2026-10-16 12:16:24.917'),('1abf1003-5c42-449b-b082-d15ab0aaf137','ea2d8b70-ca66-4b4f-bf25-595db63689ed','2c12c3c296ccf59215bef7a110e6d4cad3bb30696fd91f36d7771edd13d5b351','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36','2026-10-29 06:05:34.623','2026-10-22 06:05:34.624','2026-10-22 06:05:47.338'),('1b7a9608-10db-4a9b-8719-b02517381b7c','ea2d8b70-ca66-4b4f-bf25-595db63689ed','b0a32ca04ff3db4e36260e7f2e03ccd93796ce9288858149aa0b1790a18290ed','::1','node','2026-10-24 11:31:30.869','2026-10-17 11:31:30.870','2026-10-17 11:31:31.140'),('1d3342b7-42bc-43e2-94f8-d408bc6342c8','d2e9d278-5d54-43fc-b106-6f5d1465c70f','86112e6ef242710f23bd655e8840b711ed9f188022de45b2d2464ea824e93638','::1','node','2026-10-24 09:05:38.209','2026-10-17 09:05:38.210','2026-10-17 11:31:32.567'),('1f150649-b54f-4362-b98a-775c8dd02bd4','ea2d8b70-ca66-4b4f-bf25-595db63689ed','7bb4f0f40daaefd9728730ebbd0913f687d79418a85940043ebe2ae312c325df','::1','node','2026-10-24 06:28:36.277','2026-10-17 06:28:36.281','2026-10-17 06:52:42.851'),('1f5647ce-867c-4996-bc50-b72e873c20cb','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','82129edeb2ee4ae578ecc39faca180376c80f4f4b9e7061ec2b9af2a09007208','::1','node','2026-10-24 09:12:54.555','2026-10-17 09:12:54.558','2026-10-17 09:12:54.601'),('207ab012-00e6-40c3-adb6-5f3f69885444','ea2d8b70-ca66-4b4f-bf25-595db63689ed','50c0441f27fea66e00a7b1ec1c573abcca351ba1a6ae8f43b3eb018e99a591d2','::1','node','2026-10-24 11:33:18.761','2026-10-17 11:33:18.763','2026-10-17 11:33:18.773'),('20e14ad2-2474-4fc6-a3cd-b9853e4b3363','ea2d8b70-ca66-4b4f-bf25-595db63689ed','a2a98dc1e71f4a62998efc5ed9c88d5eb42eff61cb4f4f86252b673e6af80ed3','::1','node','2026-10-24 11:31:28.948','2026-10-17 11:31:28.949','2026-10-17 11:31:28.963'),('2132da0c-b68c-43ac-92c7-25434addb38d','ea2d8b70-ca66-4b4f-bf25-595db63689ed','78bb39dca205a839402824d128cd19517bdc67d5d45343974ba6200d7cb2eb0d','::1','node','2026-10-24 07:08:06.495','2026-10-17 07:08:06.497','2026-10-17 07:13:17.258'),('222111f8-ff2a-40b2-8cd9-7f57ffbaf6b6','ea2d8b70-ca66-4b4f-bf25-595db63689ed','489be6f4c11361387c60f6c00c7ebc5a623701547b82f533ea6fc5b57129dabf','::1','node','2026-10-24 09:12:22.574','2026-10-17 09:12:22.577','2026-10-17 09:12:22.607'),('2268f948-84b7-41de-bf42-e8352096d33a','ea2d8b70-ca66-4b4f-bf25-595db63689ed','7f3c8f0158b2304c28499dc04702598ebe521d9974e198e82b8b75436062f95d','::1','node','2026-10-24 06:57:16.386','2026-10-17 06:57:16.388','2026-10-17 06:57:16.715'),('22886a87-006d-4df0-8c2e-7f6898ae340b','13f38306-99d7-4068-9899-744e04793548','e8fe30849803c3bed1256a586996d5ce473bc3f1c615ffdb9718b3026e40f07b','::1','node','2026-10-24 06:57:18.051','2026-10-17 06:57:18.052','2026-10-17 11:31:33.197'),('2325e21f-2243-48b4-8cc1-e29522b6a819','ea2d8b70-ca66-4b4f-bf25-595db63689ed','478787861107dcb89d0428980ffe627cded9cc3337d0816ae6b25a5ffa6d81b1','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36','2026-10-29 06:27:05.793','2026-10-22 06:27:05.796','2026-10-22 06:27:17.185'),('239208d9-a5fd-4472-a20b-d5a9672524de','ea2d8b70-ca66-4b4f-bf25-595db63689ed','f8ca36debd7078336400b1658f3fa45ab7adcc8b2369de20060318b50a6e2f39','::1','node','2026-10-24 10:54:27.959','2026-10-17 10:54:27.961','2026-10-17 10:55:15.019'),('250f6779-10a7-4b7d-8637-0ad41d39243a','ea2d8b70-ca66-4b4f-bf25-595db63689ed','695b11312b5505026337a35dd965d980e42c42aea54e99500a1b6d92d9ace323','::1','node','2026-10-24 06:52:41.988','2026-10-17 06:52:41.990','2026-10-17 06:52:42.851'),('2545c9cb-dbfd-413a-bc0e-34df85ea8240','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','349ea6a2b1ca279ab9e4741594fb119e8ddb71d92a6e63a09b0b3484fa46f045','::1','node','2026-10-24 04:48:18.916','2026-10-17 04:48:18.920','2026-10-17 05:48:49.407'),('25480878-94eb-4c7d-b5e9-eac7549cadba','13f38306-99d7-4068-9899-744e04793548','310182d74eb1fb6832a98937b62fd6d24acfc96280a132c2c335736277f9d09a','::1','node','2026-10-24 07:08:08.226','2026-10-17 07:08:08.227','2026-10-17 11:31:33.197'),('262a60eb-5fed-4a03-95e5-8816cd94d9f5','ea2d8b70-ca66-4b4f-bf25-595db63689ed','847a2bda13244a59796fd77a696fe04007105c82c18a595d55f64b2b02c80fa4','::1','node','2026-10-24 07:15:42.665','2026-10-17 07:15:42.667','2026-10-17 07:15:42.680'),('263fdcb0-7cdd-4975-8016-c626e5506fe8','ea2d8b70-ca66-4b4f-bf25-595db63689ed','3539990cf0eba8960f838b1ebefe9f387b024f569e4930b5a2f4b69952d02049','::1','node','2026-10-24 07:00:34.246','2026-10-17 07:00:34.247','2026-10-17 07:00:34.837'),('280d2e57-16f4-4ec3-9d36-c1b40d00dfbb','ea2d8b70-ca66-4b4f-bf25-595db63689ed','f98d25a78773d3ff2a5780066a0e43f87dbb2fcf11708520c72762b9824f045c','::1','node','2026-10-24 11:33:19.642','2026-10-17 11:33:19.643','2026-10-17 11:33:19.651'),('282b8dbd-a222-433a-b73b-31d04d414aa6','ea2d8b70-ca66-4b4f-bf25-595db63689ed','bb7346c08d0c5a75914ed7f2d42aaa8e0ddb2cbf84f05b3c7f7319d3168fc025','::1','node','2026-10-24 09:05:40.357','2026-10-17 09:05:40.358','2026-10-17 09:06:09.620'),('2874ee81-bf55-4c5d-a638-5aac9e4288dd','13f38306-99d7-4068-9899-744e04793548','fc6c9b9cbca0e161460a4ef208555a77a3708dd74dea6eb5e6b386e547c5ae85','::1','node','2026-10-24 07:07:30.688','2026-10-17 07:07:30.689','2026-10-17 11:31:33.197'),('28f756d4-3e28-45eb-b95f-b8026691a769','ea2d8b70-ca66-4b4f-bf25-595db63689ed','97a8b9f9ca246466fd2ae1c38135112bdf6fa95794b0ae4f6bbbc98c32e74a9d','::1','node','2026-10-29 07:32:20.974','2026-10-22 07:32:20.980','2026-10-22 07:32:21.011'),('2953ea64-5ad4-4cfb-8c41-3c075043ac6e','ea2d8b70-ca66-4b4f-bf25-595db63689ed','8851448ecf91f3a8cfd16b9e3a445b52893ad04f669a7c9ab93506aabe35e8b2','::1','node','2026-10-24 11:33:21.674','2026-10-17 11:33:21.675','2026-10-17 11:33:21.683'),('2ad7aad8-bb92-451b-9f3d-19ca2c1f376f','ea2d8b70-ca66-4b4f-bf25-595db63689ed','2d40fae118f4232bf431152867db742c993177f6438bdbd99e991ac48d74032d','::1','node','2026-10-29 07:32:18.245','2026-10-22 07:32:18.251','2026-10-22 07:32:18.352'),('2b4859d2-47bc-498a-bdc0-e833c3bc3d1a','592860dd-8039-486e-a86e-e366de3b70df','ce23c0d1f08e3804f5a1b94769fadce8fdd7ffe7e9e38ca8da49d1aaaa75f15b','::1','node','2026-10-29 11:53:34.322','2026-10-22 11:53:34.325',NULL),('2c80bd30-bc6a-4149-9fd5-28b6cc11db24','ea2d8b70-ca66-4b4f-bf25-595db63689ed','7e07bed86aa2acea0c96042af99d584a5bb64fd6e4d14174e47065ca9768e97f','::1','node','2026-10-24 06:57:16.118','2026-10-17 06:57:16.120','2026-10-17 06:57:16.715'),('2d9ba443-5251-4afe-bb29-c1540400ab7e','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','fd1d898c10db81b599afada9c43b1b9fa461713a0d0c79359dcc08ab13cbc6b5','::1','node','2026-10-24 05:48:49.710','2026-10-17 05:48:49.718','2026-10-17 05:48:50.301'),('2dc7ed17-22dc-407b-977f-4a9ed47a0166','ea2d8b70-ca66-4b4f-bf25-595db63689ed','3f3714793ee9453218d03b367bfd193344987f305de6708072b8c7b2a79f1992','::1','node','2026-10-24 11:31:30.330','2026-10-17 11:31:30.332','2026-10-17 11:31:30.339'),('2e14f85f-789a-41ca-abd0-900b27f860ef','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','fa5086fd16156064ea55c485a4e4cf8d0321cb181a3c4eb82baa458a787661fa','::1','node','2026-10-24 05:02:40.664','2026-10-17 05:02:40.668','2026-10-17 05:48:49.407'),('2e212217-4f8f-453c-b2ed-2d1b64e0a39d','37f2fdec-67e6-439b-958d-2ec85e9b1183','10147644a78d806678c0cc4200124bc7a8547f9a7356502b2d51641d6139113c','::1','node','2026-10-24 07:15:44.846','2026-10-17 07:15:44.847','2026-10-17 11:31:32.914'),('2fe118e5-ded4-4c1e-88ed-612f1c1457c3','13f38306-99d7-4068-9899-744e04793548','2aaffff2bd27eccb96ce3eddd48d810666a30d55f797905da2a8282a0d6fbf2c','::1','node','2026-10-24 07:15:45.117','2026-10-17 07:15:45.119','2026-10-17 11:31:33.197'),('3005dde7-c8d5-4a7a-b1d0-f0335ebf3e7b','ea2d8b70-ca66-4b4f-bf25-595db63689ed','bf816f776c511e0672ab5da7941f6aa2b77bdc0105795c42b66a695b2ff9a242','::1','node','2026-10-24 10:55:16.863','2026-10-17 10:55:16.864','2026-10-17 11:29:36.362'),('32e0fa9f-87c3-4fa9-bba4-9870c61cd3dc','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','8e41310e343f9b77127a9b13f675b702b8ca2fc145e0f5855be2734ab28720c2','::1','node','2026-10-24 06:57:17.246','2026-10-17 06:57:17.247','2026-10-17 07:13:17.548'),('33cfc341-f9f3-44a3-9e4e-4b5f4dcd4af4','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','424eb6bcfd3b0d0d1b2cee01ae0c3d3b0faa513377479cbfb58a697924e6528d','::1','node','2026-10-24 05:52:06.448','2026-10-17 05:52:06.450','2026-10-17 07:13:17.548'),('3410dcbf-e3bc-4199-96a3-564a6c4d9295','ea2d8b70-ca66-4b4f-bf25-595db63689ed','ef682961ea2a6742bbe3535ef1d3c38f120efcb7d49174ceae004f7f5d3f4306','::1','node','2026-10-24 06:57:18.677','2026-10-17 06:57:18.679','2026-10-17 07:00:34.837'),('34d1f169-b601-4b5d-ae87-3882c8aa20a6','ea2d8b70-ca66-4b4f-bf25-595db63689ed','8c22d59a7b6f8636796922fa900f04d044c0be11c3c3751b9f503562a05be4bb','::1','node','2026-10-24 11:31:31.151','2026-10-17 11:31:31.153','2026-10-17 11:31:31.163'),('35210dba-5349-4873-9219-de5d3102fd76','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','1f2cd6d363e6e8f314489044120b9cbc4585b8ab27426d57d762d858231b0078','::1','node','2026-10-24 07:00:35.367','2026-10-17 07:00:35.368','2026-10-17 07:13:17.548'),('355d217f-3fd6-4ba3-aba6-19cd74b5f02a','d2e9d278-5d54-43fc-b106-6f5d1465c70f','08a18e53be2f7c2520a47bbb4800acd503eacb81d0dd4bb6db087d7d278d5390','::1','node','2026-10-24 07:07:30.064','2026-10-17 07:07:30.065','2026-10-17 11:31:32.567'),('355e3bb5-575b-4adb-881b-e7be07d67f77','37f2fdec-67e6-439b-958d-2ec85e9b1183','2b756e3a5b562ffee5cc84070ef8fda7f0de4616a1b4978cce873543e0ae2fc9','::1','node','2026-10-24 10:55:16.228','2026-10-17 10:55:16.229','2026-10-17 11:31:32.914'),('36786ed6-d13f-4090-bfd9-e97e0fa488c2','ea2d8b70-ca66-4b4f-bf25-595db63689ed','17f065bb2233cb6af2051cbba425db979c5b5d8a4d53b4b7cf76062ebdd01f14','::1','node','2026-10-24 06:57:19.703','2026-10-17 06:57:19.705','2026-10-17 07:00:34.837'),('3755c0c1-34ba-4977-84e6-9501035b1ae4','ea2d8b70-ca66-4b4f-bf25-595db63689ed','01b41af5ebb8ec53f2bb5be871c7e1ccc09eec2d93e7f4e071bf7b13d9de4f3d','::1','node','2026-10-24 09:05:36.807','2026-10-17 09:05:36.808','2026-10-17 09:06:09.620'),('3760d2b9-31f2-4b7a-9984-0b89a2f2d640','ea2d8b70-ca66-4b4f-bf25-595db63689ed','648a334355cd7576314f7c592d55a16b07fe6a3d1af678a0fdb7dad0c43f1045','::1','node','2026-10-24 07:15:44.012','2026-10-17 07:15:44.014','2026-10-17 07:27:31.443'),('3770564f-a1f3-4e58-bc07-18cab80ac177','37f2fdec-67e6-439b-958d-2ec85e9b1183','655e7ef602a3c17f72713e781de98c0ce3894119eae606b18b1bc816047c01e0','::1','node','2026-10-24 06:57:17.783','2026-10-17 06:57:17.784','2026-10-17 11:31:32.914'),('3884637a-68f5-4a0a-a05a-7e9f3023e8ed','37f2fdec-67e6-439b-958d-2ec85e9b1183','047ee33e03ec2ad8b7f05a51a0d8474a0962d035699b00df0eb6848f133e62ae','::1','node','2026-10-24 07:07:30.338','2026-10-17 07:07:30.339','2026-10-17 07:07:30.375'),('395c873d-fc7c-4cd8-82d7-746f96aae344','ea2d8b70-ca66-4b4f-bf25-595db63689ed','ce21d6a9601bbe73de153b83e54d04f75bbd0990236574a9e34e3184cb65b1e4','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36','2026-10-29 06:03:29.954','2026-10-22 06:03:29.958','2026-10-22 06:04:41.368'),('3a13b240-ffc7-4ab5-a9a4-4b9522b9b6e0','ea2d8b70-ca66-4b4f-bf25-595db63689ed','6e7893940177f00c15b39247d8004baf3b4aa4f0f9e1584287bd6ba6d935be05','::1','node','2026-10-24 11:33:19.041','2026-10-17 11:33:19.043','2026-10-17 11:33:19.084'),('3ab30679-98f5-486e-b315-dc3140d19db4','ea2d8b70-ca66-4b4f-bf25-595db63689ed','eaf3ae5ac98779a9c112c552521069c560ab60c66cb390f4f1f40d1f311fc48a','::1','node','2026-10-24 10:55:14.105','2026-10-17 10:55:14.107','2026-10-17 10:55:15.019'),('3b1da308-4333-4206-9265-fc6e43e874e1','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','f01d8ea324aace00a4d63384fef4526bd7e8e603258abbe9daeaf1860213d1a9','::1','node','2026-10-24 07:15:42.946','2026-10-17 07:15:42.948','2026-10-17 07:15:42.957'),('3c959212-77ba-444f-bd33-0aaddbecac7e','ea2d8b70-ca66-4b4f-bf25-595db63689ed','8debc5ab8f98cd166d06cff840c2e87a3f4e47d6290cd75bc3f6b6ed48d760ce','::1','node','2026-10-29 07:32:20.346','2026-10-22 07:32:20.352','2026-10-22 07:32:21.034'),('3f05c64e-0d58-4b19-9792-e9301aed4f45','ea2d8b70-ca66-4b4f-bf25-595db63689ed','12d9acd6e415b3659a2e394766236bb79216aa771d5a09cbdfb2783b2e901a8f','::1','node','2026-10-29 06:36:45.685','2026-10-22 06:36:45.694','2026-10-22 06:36:45.697'),('3f9dd4cb-3a09-4d43-8ba2-1d1c001479da','ea2d8b70-ca66-4b4f-bf25-595db63689ed','4fe4606406dd1f353a4a2af9a6b356b4eca3c2ee2e2f76e6003f27688ac1026f','::1','node','2026-10-24 11:31:29.778','2026-10-17 11:31:29.780','2026-10-17 11:31:29.788'),('4070011f-00e9-4a11-b61d-e9b0a7300ef1','d2e9d278-5d54-43fc-b106-6f5d1465c70f','5382ab57ab48af7ddd8349c08e952eca4a46c5a512f59e31affae1ef1d4b72e8','::1','node','2026-10-24 05:09:21.198','2026-10-17 05:09:21.203','2026-10-17 11:31:32.567'),('40f9a6d2-8fa5-4695-a3a6-da7a480a93d9','13f38306-99d7-4068-9899-744e04793548','f748dc21fa7cbe253c08d41e4430f3c028c558d83640517a33426cbdb496b014','::1','node','2026-10-24 07:08:08.148','2026-10-17 07:08:08.149','2026-10-17 07:08:08.217'),('416ab0ba-e0dd-442a-9b8a-594ac3e4b3b1','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','e1fc6c4e5c501a94bd98ce846d986491deb07a6ee3666808a429f67cf6a51729','::1','node','2026-10-24 09:05:36.504','2026-10-17 09:05:36.506','2026-10-17 09:05:36.529'),('426aa495-e26e-4f23-a18c-6c5c641541b7','ea2d8b70-ca66-4b4f-bf25-595db63689ed','d47962d03b728fdba8e4dc0c221ca5d2267fa25bb0b03dd7caa35d8deb4b1d6a','::1','node','2026-10-24 09:12:22.607','2026-10-17 09:12:22.610','2026-10-17 09:12:22.610'),('438e1024-e110-4314-8be7-57620b8bbc23','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','e47b692bd550093313791bfca8f1b8f66cc97298794577549644a5781efd84ef','::1','node','2026-10-24 07:00:38.863','2026-10-17 07:00:38.864','2026-10-17 07:00:39.437'),('43c17f41-bb23-4237-af71-d2b5b00b31ad','ea2d8b70-ca66-4b4f-bf25-595db63689ed','3c6750218817435ed4abd892bda4548487b88b20c4f4f61a4db32e6356e12860','::1','node','2026-10-24 07:15:46.756','2026-10-17 07:15:46.758','2026-10-17 07:15:46.769'),('443aaced-651a-4fc5-9e6e-d6266b3400e7','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','d89bb935971e17f08a3594e49cf13c78edfb42efe0fa9c46d16ab9c2dc62ebd8','::1','node','2026-10-24 07:13:19.958','2026-10-17 07:13:19.959','2026-10-17 07:14:25.545'),('449a20be-be5c-48e2-a23e-2bb765433bc7','ea2d8b70-ca66-4b4f-bf25-595db63689ed','105f67b553298beb42a222127717cc197a060f793a324eb49d49f807a1eb39fb','::1','node','2026-10-24 06:57:20.060','2026-10-17 06:57:20.062','2026-10-17 07:00:34.837'),('464b3895-5af4-47a2-84d7-2d8c6c8c603f','ea2d8b70-ca66-4b4f-bf25-595db63689ed','f7d469170a12c021dfd0a8767ebded5c7512ce10fba592e07b8af0a271f189ce','::1','node','2026-10-24 11:29:38.931','2026-10-17 11:29:38.933','2026-10-17 11:29:38.946'),('47474f40-f15b-4c94-8747-d48a918d1d57','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','18c4e2c80f2fc8bb32ba032c2e16f525390467e45baba2d0f173212fc6e5ed61','::1','node','2026-10-24 10:53:51.556','2026-10-17 10:53:51.558','2026-10-17 10:54:24.211'),('47708ded-6e05-4c2a-82a2-db90569161bc','37f2fdec-67e6-439b-958d-2ec85e9b1183','8c4416c7fe5d42d68a4ce93020378de70ec2ac91362f78a815288c37675a4796','::1','node','2026-10-24 07:08:07.754','2026-10-17 07:08:07.756','2026-10-17 11:31:32.914'),('48ca5136-f8ce-45b0-9d82-75d1a77c1763','ea2d8b70-ca66-4b4f-bf25-595db63689ed','6b399db69be9b2ca9e531cb2ffd4b105569469f94dc4303d4429268258deebe6','::1','node','2026-10-29 07:32:21.017','2026-10-22 07:32:21.023','2026-10-22 07:32:21.034'),('48f1f7f4-f1b4-4874-944b-9ac7e0ee1a5d','13f38306-99d7-4068-9899-744e04793548','f80b6e2921543827ba250e09436a1b128fe132afd935db22918e1c8727d49c8b','::1','node','2026-10-24 10:55:16.498','2026-10-17 10:55:16.500','2026-10-17 11:31:33.197'),('491291b1-499f-4d5a-b594-e0a54331a5b2','ea2d8b70-ca66-4b4f-bf25-595db63689ed','1b1ee0429128cb8f61f3ef5b489a39602908aa21a3f33d20b20825737e334475','::1','node','2026-10-24 10:55:13.508','2026-10-17 10:55:13.509','2026-10-17 10:55:15.019'),('49214a3d-01f5-4401-b6de-34709c5f873a','ea2d8b70-ca66-4b4f-bf25-595db63689ed','eef34cab62aec8c1fa4be27d710129c560870400c2a0a5323144082f8839ebed','::1','node','2026-10-29 06:35:51.490','2026-10-22 06:35:51.499','2026-10-22 06:36:44.569'),('49ca1ac9-3bec-430e-996a-bf2c2ae99369','ea2d8b70-ca66-4b4f-bf25-595db63689ed','23de510e676d296790a2c37c31f1a2f5d31be6bd6e76f5cab5e38d93557c6757','::1','node','2026-10-24 09:12:22.613','2026-10-17 09:12:22.616','2026-10-17 09:12:22.610'),('4a78572b-9dc4-4c19-b225-4b3c6a35395c','ea2d8b70-ca66-4b4f-bf25-595db63689ed','f2527fcf0b4659c8611062a608a4e62092b49218ca65474f10a75f2127c6f50c','::1','node','2026-10-24 05:52:06.173','2026-10-17 05:52:06.174','2026-10-17 06:52:42.851'),('4bc57274-4e1b-4c07-afe7-41dcf07e5a3f','ea2d8b70-ca66-4b4f-bf25-595db63689ed','06ac19366e4d1e7393b4d548744d6d4f17f6ce7b9af7cd46aaa24c3e46db4870','::1','node','2026-10-24 11:33:22.243','2026-10-17 11:33:22.245','2026-10-17 11:33:22.253'),('4c7117f9-5ba6-4d31-a629-92869c202b2b','ea2d8b70-ca66-4b4f-bf25-595db63689ed','0b5e223e381ef7441f0ef2bdaefc27f0fdbec7172ec17570bed9c12aee1cb8d2','::1','node','2026-10-24 07:13:22.437','2026-10-17 07:13:22.438','2026-10-17 07:13:22.451'),('4c98bd94-8ed0-45e6-93dc-3a3697e16f67','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','8a2beb636cfcff4c3c3874d4cd618904e5ecf8f6f523beb5c2ce542330739853','::1','node','2026-10-24 10:54:23.675','2026-10-17 10:54:23.678','2026-10-17 10:54:24.211'),('4e75d460-dd8e-4b32-a098-c58943192a7a','ea2d8b70-ca66-4b4f-bf25-595db63689ed','6741badf8e4c7ff30628d3e4e3aeeec20c7213e9261181bcdbf8a3989aa1e45f','::1','node','2026-10-24 07:13:22.457','2026-10-17 07:13:22.458','2026-10-17 07:14:25.262'),('4e8fa5a2-8e6e-445a-9740-428514e5596b','ea2d8b70-ca66-4b4f-bf25-595db63689ed','302d96873abab6626bb4d4794adbd9dbd3e600203a8f6303e61267664d73cac5','::1','node','2026-10-24 05:51:15.137','2026-10-17 05:51:15.138','2026-10-17 06:52:42.851'),('4eb70f91-9f58-4f46-a72f-75b6b040ae99','ea2d8b70-ca66-4b4f-bf25-595db63689ed','1e115bbf538735badee0f8125d1738c719cf1211c7db02b03ccc25b453871901','::1','node','2026-10-29 07:32:21.334','2026-10-22 07:32:21.341','2026-10-22 07:32:21.368'),('4f780df7-a66c-4755-8405-4410c644005b','ea2d8b70-ca66-4b4f-bf25-595db63689ed','3986d499087e4ae1d69f229fe8d6c5946182c9fb249997cca0ff1ec6362d8b62','::1','node','2026-10-29 06:36:47.434','2026-10-22 06:36:47.443','2026-10-22 06:36:47.445'),('4f825d5a-457a-4138-a9d5-0e03b2ca97db','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','9cf143166ef85be5f9cae978b178ba20041b658d56844ee4739e74a452f93f1b','::1','node','2026-10-23 13:00:04.200','2026-10-16 13:00:04.202','2026-10-17 05:48:49.407'),('4f85c8de-9807-4c18-993b-f586b1b09e44','ea2d8b70-ca66-4b4f-bf25-595db63689ed','52564c34edf18b2d572ce258533a2b0c98d832c7a33d2995dbea7df104fb4403','::1','node','2026-10-29 07:32:18.646','2026-10-22 07:32:18.651','2026-10-22 07:32:18.673'),('50419fe2-f735-4f57-829e-867acbb2bb3f','37f2fdec-67e6-439b-958d-2ec85e9b1183','1987d41240de5a4f357bb0f5ca6c2daabd1bc38354ea5082c46e522ca0432e7d','::1','node','2026-10-29 07:32:23.017','2026-10-22 07:32:23.023','2026-10-22 07:32:23.043'),('511da760-4c0a-4ebf-831f-5b9c78633a0b','d2e9d278-5d54-43fc-b106-6f5d1465c70f','c8bc4178d2684bf65bfceb54d66238be1d4d0c21dd32dd0b257e0af4a57ba7b0','::1','node','2026-10-24 07:15:44.570','2026-10-17 07:15:44.571','2026-10-17 11:31:32.567'),('51350280-34f9-4d96-a7b9-f7a1018d6827','ea2d8b70-ca66-4b4f-bf25-595db63689ed','843605c0bbb47fec65fa245c75d34e086e94dcae0c18490135a1938e589a3eb7','::1','node','2026-10-24 07:27:32.783','2026-10-17 07:27:32.784','2026-10-17 09:05:36.239'),('526e6d2a-1f83-4511-9c80-d3d3a0142c0f','ea2d8b70-ca66-4b4f-bf25-595db63689ed','2865848126cdea7b80252ba6440d8c81f69828e07e6f86bce7d014616f66b1ec','::1','node','2026-10-24 06:52:42.523','2026-10-17 06:52:42.524','2026-10-17 06:52:42.851'),('527e5bea-b803-4755-b350-3063b58d2ee1','37f2fdec-67e6-439b-958d-2ec85e9b1183','4fd2b25e3cdf961d015f6b1fcb80b587fd874642b5b0aafd26ff2e06bf913721','::1','node','2026-10-24 11:33:23.095','2026-10-17 11:33:23.097','2026-10-17 11:33:23.106'),('5339b783-c078-4ea8-986c-5cbc68915763','ea2d8b70-ca66-4b4f-bf25-595db63689ed','fa1ef03f975e40b7f56202522f4f14e421c437dce5f338671ed86ecf94bc516b','::1','node','2026-10-24 09:05:36.223','2026-10-17 09:05:36.225','2026-10-17 09:05:36.239'),('538855ef-c012-44b7-aded-2beaa04d38b2','d2e9d278-5d54-43fc-b106-6f5d1465c70f','554cc284a034f781772fada246bab6b6159a5f0e423c48ebc2e2a59145caa2d6','::1','node','2026-10-24 04:38:52.598','2026-10-17 04:38:52.601','2026-10-17 11:31:32.567'),('5523393e-35cf-4f79-81fd-9d68a5edeee0','37f2fdec-67e6-439b-958d-2ec85e9b1183','82c5d5e8f14669d4cca6407aea68b8d890e4ff5152e8fc9ce812f5c23438b15c','::1','node','2026-10-24 05:11:15.903','2026-10-17 05:11:15.909','2026-10-17 11:31:32.914'),('55345726-f4b6-4f6d-a5d3-3295b4580625','ea2d8b70-ca66-4b4f-bf25-595db63689ed','38e8d4643cc535bdf6756e72d6f4e39533c91dd4469489cb16c57f8a7fc536bb','::1','node','2026-10-24 06:57:15.229','2026-10-17 06:57:15.231','2026-10-17 06:57:16.715'),('553bcc4b-de2a-49a2-913f-d79aaa0fff36','ea2d8b70-ca66-4b4f-bf25-595db63689ed','3840ddcda7b1d6da879f8ee55eebd96b3f7b5a58536674d052bde79d401f59ff','::1','node','2026-10-24 10:55:15.296','2026-10-17 10:55:15.297','2026-10-17 11:29:36.362'),('55bfbbda-f486-4a30-bae2-f698d9dd78ba','ea2d8b70-ca66-4b4f-bf25-595db63689ed','607683f73385f8319a5ed211c558277e0dd77532f24ee9217f19ee745e645fc8','::1','node','2026-10-24 07:14:25.213','2026-10-17 07:14:25.215','2026-10-17 07:14:25.235'),('560adc1f-8f7a-43ac-90a3-ebbf6f8a5b05','37f2fdec-67e6-439b-958d-2ec85e9b1183','10df821d9c56b81efa7fcaa5f53db64bd4854a4bc3290023311ff08b603d355b','::1','node','2026-10-24 11:31:32.893','2026-10-17 11:31:32.894','2026-10-17 11:31:32.907'),('56c2da7e-d778-4487-aed6-9a28a00b48d9','ea2d8b70-ca66-4b4f-bf25-595db63689ed','6ce0e57a312dc6fa4962a23b09f2ee48c1c01df1bed7faf0fc5e148c8207bc4d','::1','node','2026-10-24 11:29:37.232','2026-10-17 11:29:37.234','2026-10-17 11:29:37.246'),('57de4675-548b-47d2-b106-19cd62038f14','37f2fdec-67e6-439b-958d-2ec85e9b1183','207b1a886dc741dc4afb66c156f72237cc3349a8c34fc29bbbcd591ab06a4ee0','::1','node','2026-10-24 09:05:38.499','2026-10-17 09:05:38.501','2026-10-17 11:31:32.914'),('58e2a22e-c99b-43c1-ae9c-dafe7aadace8','ea2d8b70-ca66-4b4f-bf25-595db63689ed','0e086839b1e809d6a03eb698e2c46b03c9bed64f4746626ba267398e5c973cb5','::1','node','2026-10-29 06:36:48.010','2026-10-22 06:36:48.020','2026-10-22 06:36:48.023'),('5913baf0-2438-47a4-b7fc-529ddada0c0f','37f2fdec-67e6-439b-958d-2ec85e9b1183','9661daf902c5db9893dc627ece5cdbaa143d9131297dcb381f28b31d08ba4053','::1','node','2026-10-24 07:08:07.684','2026-10-17 07:08:07.685','2026-10-17 07:08:07.748'),('59a93313-de60-45b2-8ce5-21f9429d2bf6','d2e9d278-5d54-43fc-b106-6f5d1465c70f','4b7c129bd4be8d597035f5c8a7b5b0bc25cee29f455be19b3a522b38db493b16','::1','node','2026-10-24 05:11:15.605','2026-10-17 05:11:15.611','2026-10-17 11:31:32.567'),('5a674356-0177-4190-afdb-32893e4ca739','ea2d8b70-ca66-4b4f-bf25-595db63689ed','6e667c6ba770e01fb7c170457c69f6f936d5b99a45476d581c0d0cfc33270b39','::1','node','2026-10-29 07:32:22.337','2026-10-22 07:32:22.343','2026-10-22 07:32:22.372'),('5adcf722-bf0e-4ea8-8c8d-dd9b3dfa6fdf','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','f8b54c86bbfea4fd6f41ed5f227aad835cd73ce37b7afec08aba5d021597b9ce','::1','node','2026-10-24 04:38:11.139','2026-10-17 04:38:11.146','2026-10-17 05:48:49.407'),('5b430388-47ec-41e7-8f37-3826cb214454','ea2d8b70-ca66-4b4f-bf25-595db63689ed','0d820b010c28f4251f1122c4400b762a016db7e71ea2f28ac3d7af899b99f645','::1','node','2026-10-29 06:36:44.838','2026-10-22 06:36:44.847','2026-10-22 06:36:44.850'),('5b46c1f3-f897-42ec-bb8f-81c03d2092aa','ea2d8b70-ca66-4b4f-bf25-595db63689ed','6724ee61b8c86baced2f1eef55283ac248e38017908b139091bda7d3dd1cca57','::1','node','2026-10-29 07:34:04.860','2026-10-22 07:34:04.868','2026-10-22 07:34:04.880'),('5ca3d44c-d9d6-4677-a02f-05818d538bf3','ea2d8b70-ca66-4b4f-bf25-595db63689ed','3d9ceef172a3907085531218937867888cdf6533a572803863aaac8ba281555e','::1','node','2026-10-24 09:06:15.857','2026-10-17 09:06:15.858','2026-10-17 09:12:22.610'),('5ec1a733-8051-42b6-bfda-8d754ac1fd60','ea2d8b70-ca66-4b4f-bf25-595db63689ed','ad20d6eec55e5b38f8ce57ad0e477dbff48c900bc99497f5e792f117bde6ec7e','::1','node','2026-10-24 11:29:36.917','2026-10-17 11:29:36.919','2026-10-17 11:29:36.929'),('5f714de5-56bf-4644-9b44-b21631097e03','ea2d8b70-ca66-4b4f-bf25-595db63689ed','cef7e254ef50fa86db49372a15c617ad2e43a01f1f9ce022890c25de8fcaed43','::1','node','2026-10-24 07:14:31.042','2026-10-17 07:14:31.044','2026-10-17 07:15:42.680'),('60bb046d-98ae-4855-a1cc-8a03aa5393a4','ea2d8b70-ca66-4b4f-bf25-595db63689ed','15b81752e98bb7ca9e917238ef49a36dc3471e3fcd6ab007e92e1c920010d3c6','::1','node','2026-10-24 06:57:18.407','2026-10-17 06:57:18.408','2026-10-17 07:00:34.837'),('617cfee4-e7e8-47ff-8f8c-f324b8bda871','d2e9d278-5d54-43fc-b106-6f5d1465c70f','44dbc3a7897b5da2cd27711fe1956c419fc1beb7c6ef34bf4767e969c2cadd5e','::1','node','2026-10-24 11:33:22.812','2026-10-17 11:33:22.813','2026-10-17 11:33:22.822'),('617fefc6-5bf4-4dbd-bec5-575b4eda0727','ea2d8b70-ca66-4b4f-bf25-595db63689ed','9a258e1c789a4112aaf120ec8f90cb7aee20d5a34ee732e6b987d0d05d33d725','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36','2026-10-29 10:54:21.573','2026-10-22 10:54:21.578',NULL),('618f4f62-2593-4ca2-8410-bf07ef5a985c','d2e9d278-5d54-43fc-b106-6f5d1465c70f','8e9fbe3a31b198589b4acc36486dad936bedf56329600be033df8a41bab3daf0','::1','node','2026-10-29 07:34:06.127','2026-10-22 07:34:06.135','2026-10-22 07:34:06.151'),('623e0c9a-13c6-40ce-a7f5-e9f90ff9ad7e','ea2d8b70-ca66-4b4f-bf25-595db63689ed','934101f103889407ac8e09e617f4feb8a46df395ccc1aaa2a3eb0353710aef15','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36','2026-10-29 09:34:20.391','2026-10-22 09:34:20.393','2026-10-22 10:54:14.193'),('627a59bc-bc4c-48c8-b207-76f03aa07532','37f2fdec-67e6-439b-958d-2ec85e9b1183','4ea7b234064a3dfe9dfcf3ba5ae90a216735805d89d44567ff572b8b796028e7','::1','node','2026-10-24 05:09:21.498','2026-10-17 05:09:21.502','2026-10-17 11:31:32.914'),('6444438f-8132-4d0d-95f3-ccf2fc15e475','ea2d8b70-ca66-4b4f-bf25-595db63689ed','ab4e5fce2824e5d491a51375faa9f92ae8b5b14cbb252f7d614417c7335c9a97','::1','node','2026-10-24 07:00:37.803','2026-10-17 07:00:37.803','2026-10-17 07:13:17.258'),('64994336-e913-4907-b098-f0323a507b45','ea2d8b70-ca66-4b4f-bf25-595db63689ed','5282984053e6a514f5dbd7289efba6fd62a0ed6835b7e77c5b9c56c9e70b54a5','::1','node','2026-10-29 07:34:03.305','2026-10-22 07:34:03.313','2026-10-22 07:34:03.317'),('680f0d3a-103e-45f4-b278-13a0ebc58a34','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','8b74a021a2dd5060b6aaf8c305e2cdea6902af5a3084af3cfcc85c27b9fe84bf','::1','node','2026-10-24 09:06:10.410','2026-10-17 09:06:10.412','2026-10-17 09:12:20.505'),('68f79207-6ca0-4fe8-9d66-6891ea7f42f4','d2e9d278-5d54-43fc-b106-6f5d1465c70f','d64f552685aca2b15fe0a740fedf149bf0ab3b421cc954d1010c8d4844821fc7','::1','node','2026-10-24 07:14:27.931','2026-10-17 07:14:27.933','2026-10-17 11:31:32.567'),('6a9fa900-7942-41b6-91c0-6244c346f812','ea2d8b70-ca66-4b4f-bf25-595db63689ed','c15e2d3dfec63de892d233de773937aff6104ba5f06621c0dc1f67874ff4f472','::1','node','2026-10-24 09:05:40.353','2026-10-17 09:05:40.354','2026-10-17 09:06:09.620'),('6ab7decb-1b82-4277-a51d-f6228a88ac00','13f38306-99d7-4068-9899-744e04793548','1f3d4bab17137f13cfcf19a3386d8e5d3701de509766a0c6085d4a5ef045a473','::1','node','2026-10-24 09:06:11.428','2026-10-17 09:06:11.430','2026-10-17 11:31:33.197'),('6ac0aec3-72b6-46ff-b367-291e6097593e','ea2d8b70-ca66-4b4f-bf25-595db63689ed','b6c965eab548f1fc0c467d046530466381bec3f63a5e9686aa661f9ebc283313','::1','node','2026-10-24 10:54:25.277','2026-10-17 10:54:25.280','2026-10-17 10:55:15.019'),('6b7fccf5-4887-4987-bf7d-fceedf2f693b','ea2d8b70-ca66-4b4f-bf25-595db63689ed','89d930d5b14dde411d3b9f50a294726e52831f5f8672875413413750f54bee31','::1','node','2026-10-24 11:33:22.528','2026-10-17 11:33:22.530','2026-10-17 11:33:22.539'),('6c85b05d-2a6c-4995-8db2-301f22cabc9a','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','ba8b46a48df9db81ceebcebfb913a8385ed69bf857065895ff6dda416aa19433','::1','node','2026-10-24 07:27:31.707','2026-10-17 07:27:31.709','2026-10-17 07:27:31.718'),('6c925cc2-c57c-4b5e-9dd5-565653eb3ccf','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','94687ef447fede2035adf9892412c67cb1225bf53e66352856276cca05dddfb7','::1','node','2026-10-24 07:27:33.080','2026-10-17 07:27:33.082','2026-10-17 09:05:36.538'),('6cc74dce-3637-4a77-b095-eb3aa18037b6','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','8fae1dd547572967890a30173428b82efc9e027d06cb82808f4ba628daaf2a2b','::1','node','2026-10-24 10:54:27.085','2026-10-17 10:54:27.088','2026-10-17 10:54:27.392'),('6d2003e4-1822-4dbb-8cc1-fc4e091177fe','ea2d8b70-ca66-4b4f-bf25-595db63689ed','247a0df97f2dac49dd337a1ff063fcae90547662eb9e922c4c449defca503b3e','::1','node','2026-10-24 10:55:17.702','2026-10-17 10:55:17.703','2026-10-17 11:29:36.362'),('6d2c7d4d-e44e-4ee9-b43e-7860ebb0a126','d2e9d278-5d54-43fc-b106-6f5d1465c70f','a4797851a949f8f1f30f81f5134ac8848502856afcbc30d621c1ef8f4f587655','::1','node','2026-10-23 12:52:45.364','2026-10-16 12:52:45.367','2026-10-17 11:31:32.567'),('6e4e440d-795a-4bef-b538-b7df355e93a0','ea2d8b70-ca66-4b4f-bf25-595db63689ed','7e24017e0fe7f055df0ff463b8280cf53e80fcc69ad9b725bd11c7fdbecc0692','::1','node','2026-10-24 07:00:37.802','2026-10-17 07:00:37.803','2026-10-17 07:13:17.258'),('6e5cbd5c-0ffa-450b-867e-e66d26299ce1','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','f69522807b35545673ea41471c1b6385482d16c51a2104613963257c10ae73e8','::1','node','2026-10-24 09:12:20.438','2026-10-17 09:12:20.440','2026-10-17 09:12:20.475'),('6f00a86c-00b0-470a-b8a4-bcff2204fbdf','ea2d8b70-ca66-4b4f-bf25-595db63689ed','ee09ffba1362ddffc2496026956bc94158cea781238f4a2d5ba9713579f9eefd','::1','node','2026-10-24 11:29:37.538','2026-10-17 11:29:37.540','2026-10-17 11:29:37.552'),('6fd1a3ac-d159-4684-b373-64978106658f','ea2d8b70-ca66-4b4f-bf25-595db63689ed','cee86d2e60f2025316298ffa15767b15485225a72ba176279dde3e0b20017e0a','::1','node','2026-10-23 12:32:46.929','2026-10-16 12:32:46.932','2026-10-17 06:52:42.851'),('7263fed2-c657-4caa-8402-63d553253531','d2e9d278-5d54-43fc-b106-6f5d1465c70f','23e36aaa2862d4d719fdabf56cb19bdb350fdee067ea62998bbd39f7e07c7d08','::1','node','2026-10-23 12:51:54.148','2026-10-16 12:51:54.149','2026-10-17 11:31:32.567'),('73282220-233b-419a-8c09-81304cbc11cf','ea2d8b70-ca66-4b4f-bf25-595db63689ed','07d83eb156a2b8d0b73849d145ad43725271a94e8328b1c5d9e4351746c4fe73','::1','node','2026-10-24 07:27:31.987','2026-10-17 07:27:31.988','2026-10-17 09:05:36.239'),('7488ea01-03fc-4415-9d00-a0dac856c3ff','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','20735a7d67617b44491fbd2ea007b424f1799353bd6629637b4d0a25aac3657d','::1','node','2026-10-24 07:15:44.289','2026-10-17 07:15:44.291','2026-10-17 07:27:31.724'),('75879447-f736-42f1-bc91-1e491fee3a54','ea2d8b70-ca66-4b4f-bf25-595db63689ed','a27767f829eb5c2317421eee53ba469c657baf16616ad2ed4d7a518a29c23e4c','::1','node','2026-10-24 11:31:28.669','2026-10-17 11:31:28.670','2026-10-17 11:31:28.683'),('77334da8-3533-4111-882d-6e04a43e8e87','ea2d8b70-ca66-4b4f-bf25-595db63689ed','4cd43643ad22ebcfe08a464743f2e4e11a51c474a67e1e0062bef31672364b06','::1','node','2026-10-23 13:00:23.320','2026-10-16 13:00:23.321','2026-10-17 06:52:42.851'),('7760ee5e-8aa2-4b21-ac7f-2a2c7eb668f7','13f38306-99d7-4068-9899-744e04793548','2910aad3ca51a381419ee8daf324ee32c50de0a2658191faaaa37d54f9e44e32','::1','node','2026-10-24 07:13:21.052','2026-10-17 07:13:21.053','2026-10-17 11:31:33.197'),('77fcf511-4cde-4800-8c39-e7c9c710e874','ea2d8b70-ca66-4b4f-bf25-595db63689ed','fbb67a7f35d61a76f8ba23a11372517f5dec6c22b991986b3e1d5a52db78a755','::1','node','2026-10-24 11:31:30.601','2026-10-17 11:31:30.603','2026-10-17 11:31:31.163'),('78755493-a910-4f57-987a-de88afa2991d','ea2d8b70-ca66-4b4f-bf25-595db63689ed','ae14f499bb383ee2f58a5d0cb0364f8aa9aeab7f1356dcbc6a9b8b7185cc25c5','::1','node','2026-10-24 06:57:15.844','2026-10-17 06:57:15.845','2026-10-17 06:57:16.715'),('78b1e711-e463-4527-8636-87b18ea49214','37f2fdec-67e6-439b-958d-2ec85e9b1183','fe58c0bfe59a47c2d0f0a2846b425eefef8189dfc8460fb645a6c54b7d47a5f4','::1','node','2026-10-24 05:02:41.010','2026-10-17 05:02:41.012','2026-10-17 11:31:32.914'),('7cdea01c-c08a-43c6-b149-85665c93c48f','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','e6e85c8e7b795a6858692a2c299e2c72bbb2803b4164fc002cf243ba159040a5','::1','node','2026-10-24 07:07:29.715','2026-10-17 07:07:29.716','2026-10-17 07:07:29.750'),('7cfdaeee-7437-454b-bd11-d3f75c2ee5c9','ea2d8b70-ca66-4b4f-bf25-595db63689ed','797d65f5e299f547d460f46fb40dc268139a89132c40a0ac767293aea063d4cb','::1','node','2026-10-24 09:06:07.880','2026-10-17 09:06:07.882','2026-10-17 09:06:09.620'),('7d1b6e3a-5ad3-4e5a-b5d3-e504173159cd','ea2d8b70-ca66-4b4f-bf25-595db63689ed','6cc48c26cd7bedccd11ea7a016765f945f5ac3a772872099ef531e33daf5de44','::1','node','2026-10-24 07:14:27.124','2026-10-17 07:14:27.125','2026-10-17 07:15:42.680'),('7d549eec-77fe-43e1-86dd-baf2ff792229','ea2d8b70-ca66-4b4f-bf25-595db63689ed','6b02ca9bce1ed34c56e886fe976ca7cb519d995727da51b0373e6ac5df9c6927','::1','node','2026-10-24 09:12:22.615','2026-10-17 09:12:22.618','2026-10-17 09:12:22.610'),('7e864435-dec6-42c6-969a-11704ef3d3ef','ea2d8b70-ca66-4b4f-bf25-595db63689ed','8d87e72ec0a17ba130dea25e3cb8df8ba61d543525baeb6c1758223a8d6bf297','::1','node','2026-10-29 07:34:05.806','2026-10-22 07:34:05.814','2026-10-22 07:34:05.834'),('82262e0c-a9b5-4468-a787-7bc238e878cc','ea2d8b70-ca66-4b4f-bf25-595db63689ed','d24725670cf8649c8307b6e33716869147b8f8deeda9de1e14025df5666834ae','::1','node','2026-10-24 07:14:31.044','2026-10-17 07:14:31.046','2026-10-17 07:15:42.680'),('825924f7-9ab2-48cf-a7af-e6a58fbb884c','ea2d8b70-ca66-4b4f-bf25-595db63689ed','5abdbebdc073ef0d99d9b66109017b1e22155f37494bc62a6d9305f5578ec678','::1','node','2026-10-24 07:13:17.209','2026-10-17 07:13:17.210','2026-10-17 07:13:17.235'),('83111bc2-f4b9-40eb-98f1-2f5b0a1e5d58','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','b0e5f6678e4180181da202a28ab74c41ec2a6a3f6dd4942893481a5cfd3e098e','::1','node','2026-10-24 09:12:55.208','2026-10-17 09:12:55.211','2026-10-17 10:54:23.138'),('83243446-5d5f-4f40-80ba-133fc3a7a9a5','ea2d8b70-ca66-4b4f-bf25-595db63689ed','801e20ab12009fdca4c92462b292c5e37cf9d0b90f33f861627a8caa74acbbf3','::1','node','2026-10-24 11:29:36.055','2026-10-17 11:29:36.056','2026-10-17 11:29:36.067'),('83e1b3cf-40a9-4ee4-8a89-8d5565d1c773','ea2d8b70-ca66-4b4f-bf25-595db63689ed','3848efd20361e21a4677cf3c2e9b105dd74b76b6d9062d9f3e133f943c83ff76','::1','node','2026-10-24 07:00:34.515','2026-10-17 07:00:34.516','2026-10-17 07:00:34.837'),('84672573-7bb1-42a9-94d6-d78b50e9a513','ea2d8b70-ca66-4b4f-bf25-595db63689ed','42b63577cc55065c27d5b20bdfcad2740dd2eb25553dabc64213b90d6b8062d4','::1','node','2026-10-24 10:55:14.377','2026-10-17 10:55:14.378','2026-10-17 10:55:15.019'),('85f43073-363a-410b-981c-1c119748a433','ea2d8b70-ca66-4b4f-bf25-595db63689ed','f59f19b9217e2304000f40b09a29aac2c04f431513f200953400fb1eeaeee40c','::1','node','2026-10-24 09:12:20.835','2026-10-17 09:12:20.838','2026-10-17 09:12:22.610'),('86345bff-24c4-4377-99e2-0d89dce13664','ea2d8b70-ca66-4b4f-bf25-595db63689ed','b4a7373279ca3b92cee4ff488a0fac28c5a5f875aa087bdb7c642256adfdfb48','::1','node','2026-10-29 07:32:19.703','2026-10-22 07:32:19.709','2026-10-22 07:32:19.732'),('869a6e8c-29dd-49fb-969a-8c0c749fef5f','ea2d8b70-ca66-4b4f-bf25-595db63689ed','efcfc339e0450d5da40696fd111eef621f4dcd8b7688c4f62c70540aa6b6b83a','::1','node','2026-10-24 09:12:56.384','2026-10-17 09:12:56.387','2026-10-17 09:12:56.420'),('87475f7b-ca22-44e4-982c-59a934ea1fdb','ea2d8b70-ca66-4b4f-bf25-595db63689ed','79571686bee36a0eb776c6dad64a50e669b9b6da46cc91c3bb0206ee859ea287','::1','node','2026-10-29 06:36:46.849','2026-10-22 06:36:46.858','2026-10-22 06:36:46.867'),('87e010b3-f806-45f3-9872-c0dd02ceb36a','ea2d8b70-ca66-4b4f-bf25-595db63689ed','7228319ed66e1cd95d1214d09d1e33a3c6c074a6eeb2db6778d2f3885b6f176d','::1','node','2026-10-24 09:05:36.185','2026-10-17 09:05:36.188','2026-10-17 09:05:36.217'),('887b78c3-ae6e-49c2-bdd5-dbff41ccc9ef','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','49611c035cab5c21014addc1052db99ada14ed6a6f8b3f0272589dcf8cc032fc','::1','node','2026-10-29 07:32:23.646','2026-10-22 07:32:23.652','2026-10-22 07:32:23.672'),('88c4fd73-a471-452a-ba36-24482bbb16b9','ea2d8b70-ca66-4b4f-bf25-595db63689ed','e3f9676c0c16b403de5d178ed67180aa446a2ca174c95c5bb7b094fafbea54db','::1','node','2026-10-24 09:12:56.428','2026-10-17 09:12:56.431','2026-10-17 10:54:22.853'),('8b701a4a-7765-49a2-aefc-9ca9d4c77403','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','c024645fcf69d4771888a587bf4adc2b81941f6ae3b884ed19561909e54aea5c','::1','node','2026-10-23 12:52:45.079','2026-10-16 12:52:45.082','2026-10-17 05:48:49.407'),('8bc6beb1-a3ed-4933-91e0-c90a00c0ce2d','ea2d8b70-ca66-4b4f-bf25-595db63689ed','4bbc665ed1fc8df93e66aae4162dcd56adf4d3fa313dbb7b154b8ffad8226eb7','::1','node','2026-10-24 06:57:19.761','2026-10-17 06:57:19.762','2026-10-17 07:00:34.837'),('8c6c56ab-afb0-4c04-9fb2-ea3d5aa29d8b','ea2d8b70-ca66-4b4f-bf25-595db63689ed','0902cd3df100fbc22dbe75404b754d903340827520ba373612426d43b2612bcf','::1','node','2026-10-24 11:31:32.270','2026-10-17 11:31:32.272','2026-10-17 11:31:32.282'),('8ee5c95c-595b-4611-b98c-8bd3fdb33ea1','ea2d8b70-ca66-4b4f-bf25-595db63689ed','b2b451142847f1ff899ea9136a4801934cf8348c6e980f1bc38e0aa5f886b496','::1','node','2026-10-24 11:31:29.232','2026-10-17 11:31:29.233','2026-10-17 11:31:29.241'),('8f34ea8c-fab4-464f-98c2-fb1446304ae9','ea2d8b70-ca66-4b4f-bf25-595db63689ed','d3a08e5a0a76ee8b034a9a35a925ca3b07036dbade2f561206012bbe2a541c25','::1','node','2026-10-24 11:31:31.427','2026-10-17 11:31:31.429','2026-10-17 11:31:31.441'),('8f9d92b2-9f70-41af-9b4d-42bd221acea9','d2e9d278-5d54-43fc-b106-6f5d1465c70f','81463a40ebab25239dc7a1f5befffbf34981901f3e03b7f0fe9667b341e98c84','::1','node','2026-10-24 06:57:17.516','2026-10-17 06:57:17.517','2026-10-17 11:31:32.567'),('90110e9e-07d6-4ff0-959b-349aa395ff6b','ea2d8b70-ca66-4b4f-bf25-595db63689ed','5cf01e0c2345d962eae9af0a348cb32bf5b7d6a31fdc2d0db35a7e18a939e8c0','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36','2026-10-29 09:33:57.878','2026-10-22 09:33:57.880','2026-10-22 09:34:06.441'),('90434c9e-ac34-4612-8fe9-05df975ed0f2','ea2d8b70-ca66-4b4f-bf25-595db63689ed','4b0b69aee2a9346c6fea44e78b0ce027c165b60477401b0de2d01fa9c75f60ac','::1','node','2026-10-24 07:07:29.380','2026-10-17 07:07:29.381','2026-10-17 07:07:29.438'),('9081d100-39b6-462a-8369-2dc9dcec8c5f','13f38306-99d7-4068-9899-744e04793548','29ab746b96b7a33d4141d7889b6a336aea12b725ef5651f327296c637695f416','::1','node','2026-10-24 07:13:20.775','2026-10-17 07:13:20.776','2026-10-17 11:31:33.197'),('90ae407f-1fc3-4d7e-a4da-c6362f57fc28','d2e9d278-5d54-43fc-b106-6f5d1465c70f','dbdc9e4ac38662b4a5e899c20b5725559cb71d5219da832d8a182db9a9bb60ca','::1','node','2026-10-29 07:32:22.704','2026-10-22 07:32:22.710','2026-10-22 07:32:22.719'),('90d7b52b-91ed-44ca-9553-1ac1cc109152','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','52695aace1f85a5368510efa7691b51796ab73cab7ebac0259370c798ff54b2a','::1','node','2026-10-24 09:05:37.931','2026-10-17 09:05:37.932','2026-10-17 09:12:20.505'),('91440301-fafd-49bb-8d33-72aea80b544f','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','7f8c4bb1869dac6e232f79eded1d1803d0ac81b7579cc361e15817db5d57e10c','::1','node','2026-10-24 10:55:19.890','2026-10-17 10:55:19.891','2026-10-17 10:55:20.433'),('91b390dd-9655-4902-bb80-03d9af39ff2c','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','7cfef62659bea83e80c65d65ac1e045631e83be477ec0e4152f1251cff80145d','::1','node','2026-10-23 12:51:53.855','2026-10-16 12:51:53.856','2026-10-17 05:48:49.407'),('942fa0d9-5434-4bce-a9d6-e0dafc49b63c','ea2d8b70-ca66-4b4f-bf25-595db63689ed','817f55401945f681b290986d2110816a204c219355202e068db584223654695a','::1','node','2026-10-29 06:36:44.482','2026-10-22 06:36:44.491','2026-10-22 06:36:44.561'),('9462cc53-5b28-4633-b526-96a8396ae902','ea2d8b70-ca66-4b4f-bf25-595db63689ed','ecc4d6042307f4526ff1a70bc4205f7fae7f6217386767ca037a210bb73816f7','::1','node','2026-10-24 07:00:33.979','2026-10-17 07:00:33.980','2026-10-17 07:00:34.837'),('948862d1-4f21-4be1-8920-0effc1c36fc0','ea2d8b70-ca66-4b4f-bf25-595db63689ed','91ae74c20d82de0660200aa696866eb2dabd7fca11436f2bcff9d71246e9b554','::1','node','2026-10-24 11:33:19.923','2026-10-17 11:33:19.925','2026-10-17 11:33:19.934'),('94c53353-9d0c-430e-ac4a-fd2f69c8b1c6','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','ccd0dd8401cfe766befb15e7941c690c713141ba13421e0319598d410b7ef30b','::1','node','2026-10-24 07:13:17.522','2026-10-17 07:13:17.523','2026-10-17 07:13:17.539'),('94c8b526-0cc6-4502-8d21-374c8680f1d3','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','6a80d8b618f8be39e9a3fe37639c7042ddf282d9e61d487505e064e732c6cff8','::1','node','2026-10-24 07:13:18.086','2026-10-17 07:13:18.087','2026-10-17 07:13:18.608'),('9507f1d5-d24f-4d8c-a768-335168a73936','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','47618095a92b452341894ae4205839aa0df364df6487c8a25d89e040874712b7','::1','node','2026-10-29 06:36:49.167','2026-10-22 06:36:49.177','2026-10-22 06:36:49.182'),('954eb5dc-8332-40ee-87e8-59a4a5e47e80','13f38306-99d7-4068-9899-744e04793548','60f9bdc00909a593552b9548b8e46053557b6c4c79e2aa90a07b502a38cf2c81','::1','node','2026-10-29 06:36:48.884','2026-10-22 06:36:48.893','2026-10-22 06:36:48.897'),('956edbd7-3925-4ce6-938a-245eda9c0b8d','ea2d8b70-ca66-4b4f-bf25-595db63689ed','f5dc6589c79c0d473a0be61ba1e0d5faf9452ba9ac133f5b06844fbf3a989bf7','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36','2026-10-24 10:07:44.275','2026-10-17 10:07:44.277','2026-10-17 10:54:22.853'),('95f75b8c-0d59-42d4-a489-39fc1e507ef2','ea2d8b70-ca66-4b4f-bf25-595db63689ed','d1a3cd30c4e2781e125f5c79858ce86e4d0005c5551671a52e4b9469454cfec3','::1','node','2026-10-24 11:33:21.395','2026-10-17 11:33:21.397','2026-10-17 11:33:21.409'),('962a3158-25b7-45c5-905d-aff0141c01ae','ea2d8b70-ca66-4b4f-bf25-595db63689ed','6f726eb4326bbbc1de5c0880d77d54333f4795107141e6920dc88ba9040cedd9','::1','node','2026-10-24 09:06:08.535','2026-10-17 09:06:08.537','2026-10-17 09:06:09.620'),('9651c989-0675-4b73-8922-4bb79b8f230b','ea2d8b70-ca66-4b4f-bf25-595db63689ed','e77b0d1f139ffc2a526de0ef4b49e554ccfb2148eb07b1c1d9e3c67a668875b4','::1','node','2026-10-24 09:12:56.421','2026-10-17 09:12:56.424','2026-10-17 10:54:22.853'),('96671c02-4dc5-4c35-918b-930c8c906276','ea2d8b70-ca66-4b4f-bf25-595db63689ed','0137ba4118cf03002bb2333b604ab577e21d08165e1eab96431c39a8d1ec67fb','::1','node','2026-10-24 11:33:21.950','2026-10-17 11:33:21.952','2026-10-17 11:33:21.966'),('96c9d432-60ff-4dfa-8a52-4d15551b2023','37f2fdec-67e6-439b-958d-2ec85e9b1183','67d84ab8aac13db0892474661320859308f764f1c66ec2dab0c8edd8e1fd1e50','::1','node','2026-10-29 11:53:34.949','2026-10-22 11:53:34.951',NULL),('96cd11f3-2cef-4e78-978c-e4cc6c0c6cd5','d2e9d278-5d54-43fc-b106-6f5d1465c70f','2a6d7bee6b3ff0bd8dd8b1d64017ac3ea32b65fef4151aa39ccbcfb4070eafcd','::1','node','2026-10-24 07:08:07.330','2026-10-17 07:08:07.332','2026-10-17 11:31:32.567'),('9737713f-1c48-4a03-af40-0728122df978','13f38306-99d7-4068-9899-744e04793548','ae5b025094e59af0ad0dd89ea67fec5eab783f8bf7f9117c9fc1462fabc6d9b6','::1','node','2026-10-24 09:12:56.088','2026-10-17 09:12:56.091','2026-10-17 11:31:33.197'),('9c7e41be-7fca-42c2-a638-4a1630804353','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','4bd666fff99aeb6e409bfec654ce05ea168791fe88beae933ebd42a0c99fdae3','::1','node','2026-10-24 10:54:25.564','2026-10-17 10:54:25.566','2026-10-17 11:31:33.477'),('9ccf9a02-7f0e-4e74-ae8a-eba6ecf4c75a','ea2d8b70-ca66-4b4f-bf25-595db63689ed','839a36c887027ecc2c035797655929d6d529c1d7641fd17eb60f4b9b2062e058','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36','2026-10-29 06:13:58.021','2026-10-22 06:13:58.024','2026-10-22 06:26:22.877'),('9da7e9c1-c928-4888-af69-a7cc87c3369c','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','1e238ddb5585f716d1b1c9fb4dd6d86f1fecf8ea77707bb50dbb395c1cb1661c','::1','node','2026-10-24 10:53:49.635','2026-10-17 10:53:49.638','2026-10-17 10:54:24.211'),('9e74a78e-18d4-4210-b4b7-a5d8cbfd3579','ea2d8b70-ca66-4b4f-bf25-595db63689ed','f4e19e0c27838d047b449233afa111cce942444b658a65f5773825f4f5760333','::1','node','2026-10-24 07:14:31.015','2026-10-17 07:14:31.017','2026-10-17 07:14:31.037'),('9f30f748-97e7-4a5b-8ebc-e864ac819137','ea2d8b70-ca66-4b4f-bf25-595db63689ed','d98a87b95ad3905a9a25313df68804d8daa15f8f13385b1178e44ab457c42d82','::1','node','2026-10-24 06:57:19.225','2026-10-17 06:57:19.227','2026-10-17 07:00:34.837'),('9f329061-5bce-4235-9d3a-2d4301dc9ede','ea2d8b70-ca66-4b4f-bf25-595db63689ed','81b1e7124c23c5a880e89569fe960c21f49e0e084c44a1580f545a699b0ad4e4','::1','node','2026-10-29 07:34:01.627','2026-10-22 07:34:01.635','2026-10-22 07:34:01.654'),('9fc867cd-a2b7-414f-a440-60e03c2dfb20','ea2d8b70-ca66-4b4f-bf25-595db63689ed','184620678b13d288f2ac5f2efffe30eb0c061780cc3c0d3b04b8c7abb0ec28c7','::1','node','2026-10-24 07:27:31.429','2026-10-17 07:27:31.431','2026-10-17 07:27:31.443'),('9fd52cc3-4776-4ab9-a8a5-5a140a9dd3ca','37f2fdec-67e6-439b-958d-2ec85e9b1183','59086f4477b8ca3b2fd8765bb0d9a21d46a69d3951cba81a6673e0c7b0d65166','::1','node','2026-10-24 05:48:49.092','2026-10-17 05:48:49.100','2026-10-17 11:31:32.914'),('9ff0fd59-a0c5-4e47-8453-47a076aecf48','13f38306-99d7-4068-9899-744e04793548','5a989901fa095a2748847fd1ead9919ceed4afc83f52e13c8a30c5fc2dda9a7a','::1','node','2026-10-24 07:14:29.191','2026-10-17 07:14:29.193','2026-10-17 11:31:33.197'),('a0eefec1-244c-4cb8-b237-fb1d74fe76a9','ea2d8b70-ca66-4b4f-bf25-595db63689ed','12615c7ab5f861731edaa067710c4f9f03ac535756f9b9d9e3d6667b667e647e','::1','node','2026-10-24 11:33:20.831','2026-10-17 11:33:20.833','2026-10-17 11:33:21.409'),('a0f02a88-2cef-4695-9978-0711a4aeee5f','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','4a9206c829e364a33f0a4ce03e36dd5f1180df35fc3fbde55de8e218e3a62f74','::1','node','2026-10-24 11:31:33.461','2026-10-17 11:31:33.463','2026-10-17 11:31:33.470'),('a11b0d52-b81e-4ae0-bbf9-090dd158d9ca','ea2d8b70-ca66-4b4f-bf25-595db63689ed','0d7a9bff3e784a9dce7250262d45f071adcd387c594099033bd92c132c220b6a','::1','node','2026-10-29 07:32:20.025','2026-10-22 07:32:20.031','2026-10-22 07:32:20.051'),('a12c144a-8f63-4edb-a33c-84b8af544fee','ea2d8b70-ca66-4b4f-bf25-595db63689ed','f0146418182da51eeac6998b2475213ca69bd8d7c04205672d87b4c8aee30f8b','::1','node','2026-10-24 10:55:17.140','2026-10-17 10:55:17.142','2026-10-17 11:29:36.362'),('a23bc7ca-f039-4568-916f-c07ce1464de5','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','11e0fbf26fda36645ad1f775f630c95b2eb82d0c8ad118ad7f289a4c684f0abf','::1','node','2026-10-24 04:38:52.281','2026-10-17 04:38:52.284','2026-10-17 05:48:49.407'),('a245f602-e390-4a80-b5e0-2f1b3c149a30','37f2fdec-67e6-439b-958d-2ec85e9b1183','245402673cd89019acde160bd480fb26c4cfb6e8629b345b1f6a93fbc73a2f84','::1','node','2026-10-24 07:00:35.908','2026-10-17 07:00:35.909','2026-10-17 11:31:32.914'),('a352ee67-e7b5-4368-8136-e7de36184372','ea2d8b70-ca66-4b4f-bf25-595db63689ed','54ff7ab9e75733224752bf0516e17b57e5964587dbc49e581a29be56c07add9b','::1','node','2026-10-24 07:27:35.572','2026-10-17 07:27:35.573','2026-10-17 09:05:36.239'),('a384a0e3-cb80-42a1-8c44-fb0af7741852','ea2d8b70-ca66-4b4f-bf25-595db63689ed','b96b045e770b395d7b0ac3acef1acd6782f0b9e7d5dc5b5b3d870c90d736631a','::1','node','2026-10-24 07:00:39.707','2026-10-17 07:00:39.708','2026-10-17 07:13:17.258'),('a41316a1-0de7-45a6-ad74-c78c5cdf6e84','ea2d8b70-ca66-4b4f-bf25-595db63689ed','e5b967eddc6eea79b25c78db1ce7f51e3e738e3b2e0584a0cb4bc85b42d2c676','::1','node','2026-10-24 09:12:56.435','2026-10-17 09:12:56.438','2026-10-17 10:54:22.853'),('a43dfc38-a5ae-42d7-8230-0f2a8f1137a2','ea2d8b70-ca66-4b4f-bf25-595db63689ed','54d5ff487e15233eb686e1508ab1487a790307dde3349746e93c9848f69fb705','::1','node','2026-10-29 07:34:02.336','2026-10-22 07:34:02.344','2026-10-22 07:34:02.363'),('a5beccc6-9b7e-44be-8dec-f6641f0f6e17','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','84a9918c703cb3a864db90b108aa0f2f553bc3ee4e529ff1fb2fff098ff1ad5d','::1','node','2026-10-24 07:08:06.855','2026-10-17 07:08:06.857','2026-10-17 07:08:06.906'),('a7363a10-ca07-4431-b318-0d51f69c7147','13f38306-99d7-4068-9899-744e04793548','7babf27cf036459008638fc2c8d43a9571054da13f50d4a6dbdeb45a794987b6','::1','node','2026-10-24 09:05:38.792','2026-10-17 09:05:38.793','2026-10-17 11:31:33.197'),('a8caf303-3660-4724-86b1-7a13ca31de78','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','836b0b79ec4eda4826faabe04fe66da96f4ddec88ba575f8fc9b4d841e9c060f','::1','node','2026-10-24 10:54:24.482','2026-10-17 10:54:24.484','2026-10-17 10:54:25.005'),('a910a326-d967-4937-860f-789c35c239b3','ea2d8b70-ca66-4b4f-bf25-595db63689ed','ad8ae6824cdb8bd61d2c683d30fe657ff8f42eba0ab7a256b47db85955e058ab','::1','node','2026-10-24 11:29:36.340','2026-10-17 11:29:36.342','2026-10-17 11:29:36.355'),('aa0ec9ab-a823-41b6-8a5c-f9055861b8cc','ea2d8b70-ca66-4b4f-bf25-595db63689ed','034526e760cede41fb61a81e5c3c711809878e33f3377fe2602884e2c2843798','::1','node','2026-10-24 07:27:31.391','2026-10-17 07:27:31.392','2026-10-17 07:27:31.419'),('aa5b635b-5d26-4880-b80a-2488f0e7966c','13f38306-99d7-4068-9899-744e04793548','25f9a7c7a531ce09f127edad0457d257afdb184d3a1afab657c074b68ee8cc5b','::1','node','2026-10-24 07:15:45.402','2026-10-17 07:15:45.404','2026-10-17 11:31:33.197'),('ab91d5c9-627b-4c21-9a98-10c5662620ba','ea2d8b70-ca66-4b4f-bf25-595db63689ed','6129ffacb669a95f4bce8d489ec1dd74e82afcf5c97e243094203200c8dfef4d','::1','node','2026-10-24 07:15:46.773','2026-10-17 07:15:46.774','2026-10-17 07:27:31.443'),('ac05648d-606b-4da5-a1bf-41570b95b6dc','ea2d8b70-ca66-4b4f-bf25-595db63689ed','4b87f0dac29e4e4059616aa843e3d6689bb12eb789c5065bfb33caad68609536','::1','node','2026-10-24 09:06:13.188','2026-10-17 09:06:13.189','2026-10-17 09:12:22.610'),('ac635a9a-cd7c-457a-a619-81e3b8cc4fee','ea2d8b70-ca66-4b4f-bf25-595db63689ed','1e314176cb4615fe774c6c3581410a4ecd2ce8efb653a21570a45366d1367339','::1','node','2026-10-24 05:11:15.005','2026-10-17 05:11:15.011','2026-10-17 06:52:42.851'),('ac6fd993-e904-499a-9575-42ed93a0e070','d2e9d278-5d54-43fc-b106-6f5d1465c70f','bc4510aa7df5b48d0b1f45ef56880516befacfd9bf77fa5780e9ba44900fbd84','::1','node','2026-10-24 07:00:35.636','2026-10-17 07:00:35.638','2026-10-17 11:31:32.567'),('acf373d6-bf1e-472b-8da0-94da2481b8c8','13f38306-99d7-4068-9899-744e04793548','2d745a93dc17c5dab0c981bca92e180996400ab29306a025e9f429389a407965','::1','node','2026-10-29 07:32:23.331','2026-10-22 07:32:23.337','2026-10-22 07:32:23.357'),('adfecd27-ba04-4963-a6ba-f495277d3a39','ea2d8b70-ca66-4b4f-bf25-595db63689ed','8793420163dc143976d277abe1a126dcaaf8df30bded6956d19501a9c7aeca3a','::1','node','2026-10-24 11:29:38.378','2026-10-17 11:29:38.379','2026-10-17 11:29:38.658'),('af78c7b2-5d51-4dd3-8cb2-6320d0e9852e','ea2d8b70-ca66-4b4f-bf25-595db63689ed','d0f4f4e0aa866614d5abd13d3fd1be252d59b82b77ed55a3dda2d28a9968c344','::1','node','2026-10-24 10:54:27.956','2026-10-17 10:54:27.959','2026-10-17 10:55:15.019'),('afb1b16c-6749-4aac-ac90-8c742e640215','ea2d8b70-ca66-4b4f-bf25-595db63689ed','3c8382ff2f7305fc8c4f6af9df2cbb31d9fd866b5ffbabd83c8b05643bf1eb21','::1','node','2026-10-29 07:34:01.317','2026-10-22 07:34:01.325','2026-10-22 07:34:01.340'),('afcaadee-f225-48fa-b058-b099d60436d4','ea2d8b70-ca66-4b4f-bf25-595db63689ed','73a37e673ca7c99b1d086ad69c5810e69070e1f389e19428798e6269c452b2fa','::1','node','2026-10-29 06:36:46.872','2026-10-22 06:36:46.881','2026-10-22 06:36:46.885'),('afd34819-7bdc-4fbf-b518-219a4b664e73','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','01bf67573937cc40666dd8312654355adcd2b7b2f3b652d14a5c400e8742b1a5','::1','node','2026-10-24 10:54:23.115','2026-10-17 10:54:23.117','2026-10-17 10:54:23.130'),('b1d4e972-b609-4190-b99e-628536f67e98','ea2d8b70-ca66-4b4f-bf25-595db63689ed','d43c94c88a50c9278af352707a3bf245c2cd7f6965996146d5d9fe4fb4e0eac7','::1','node','2026-10-24 09:05:40.325','2026-10-17 09:05:40.326','2026-10-17 09:05:40.345'),('b21e122d-37cd-4613-9ee4-b1469c869731','ea2d8b70-ca66-4b4f-bf25-595db63689ed','3a9702f026f0f1ac384edf5dc875598c54620a80fab19de7fcc59d5a3509e118','::1','node','2026-10-24 07:13:17.241','2026-10-17 07:13:17.242','2026-10-17 07:13:17.258'),('b2808fd2-3614-400a-92f1-cd531e2a3d69','ea2d8b70-ca66-4b4f-bf25-595db63689ed','827a79f0a1fa9d93944ad43753ad13d0a404bf5b79b7bb9bcd39169549461fc8','::1','node','2026-10-24 11:33:20.265','2026-10-17 11:33:20.267','2026-10-17 11:33:20.285'),('b37488be-5904-4bb5-a95d-abe4426c2370','ea2d8b70-ca66-4b4f-bf25-595db63689ed','3dcd23fd66ef29a197ef98c42338db66a2c4fa0b5caa9639eee2790067a2158b','::1','node','2026-10-24 11:29:37.823','2026-10-17 11:29:37.825','2026-10-17 11:29:37.835'),('b4aefff2-90fb-4975-b209-07f99a191d0d','d2e9d278-5d54-43fc-b106-6f5d1465c70f','0c94f78067af8f92eaa473d41e7dca27fb08e9999f3591cf94ae078a03717c6c','::1','node','2026-10-24 07:07:30.029','2026-10-17 07:07:30.030','2026-10-17 07:07:30.060'),('b4e5c021-f513-4cbf-920d-68a734fea62d','ea2d8b70-ca66-4b4f-bf25-595db63689ed','d74677469afa8851f3feb8913ad940bb3dc247cda079966418c7af954f6d46a5','::1','node','2026-10-24 11:31:30.056','2026-10-17 11:31:30.057','2026-10-17 11:31:30.066'),('b5161daf-ea2a-493b-bfe2-aebdb3d3e563','ea2d8b70-ca66-4b4f-bf25-595db63689ed','3c26b392b0e0f1d97d88e3775ba0d493f197099a0375f9900ca18253a39eba67','::1','node','2026-10-24 10:54:27.938','2026-10-17 10:54:27.940','2026-10-17 10:54:27.952'),('b61eb41b-79ce-4779-bc10-90860de84523','ea2d8b70-ca66-4b4f-bf25-595db63689ed','142dc137881ea7000ea3c9d8c642bed80fac85a75c1b1e0206cea1d73deceb7d','::1','node','2026-10-24 11:33:18.481','2026-10-17 11:33:18.483','2026-10-17 11:33:18.497'),('b6ff9924-f901-4d14-a2c3-798813864adb','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','6f16b924eec0cb972c236edcfbd5ca4c89394198edd0fa5d2ede383c0fa5d5c1','::1','node','2026-10-24 11:33:23.661','2026-10-17 11:33:23.663','2026-10-17 11:33:23.672'),('b7c7d979-37d5-461e-949a-5fffc34faec3','ea2d8b70-ca66-4b4f-bf25-595db63689ed','1de981128dd825c40be45ca8d7c1c5df9fe92b23d424748359b896fa88a43648','::1','node','2026-10-29 07:34:02.655','2026-10-22 07:34:02.663','2026-10-22 07:34:02.679'),('b84491b0-33ee-480f-994e-93a5b3a25193','ea2d8b70-ca66-4b4f-bf25-595db63689ed','8031a810f278bcf97ad2fb6c569a844c4a1220e4ca93928568dc34086f2c6e1d','::1','node','2026-10-29 06:36:46.577','2026-10-22 06:36:46.586','2026-10-22 06:36:46.860'),('ba21fb70-7254-4baa-8577-66d4438eb978','ea2d8b70-ca66-4b4f-bf25-595db63689ed','6f51faaf9578b226ec2ff1a7778c43b0620131753511f4d63dec4d8eb244a59b','::1','node','2026-10-24 06:52:42.255','2026-10-17 06:52:42.256','2026-10-17 06:52:42.851'),('baca7376-a8c5-44ec-9e11-b69ccc9cd519','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','8f4440ccbfdcd8d15806d65b78bc9969a7f6f449c4b63ab7e5b4f8dc3d300413','::1','node','2026-10-24 09:06:15.075','2026-10-17 09:06:15.076','2026-10-17 09:06:15.582'),('bad5f707-114b-4284-9314-ad06247e9b81','ea2d8b70-ca66-4b4f-bf25-595db63689ed','9b4b821d39828024e6c87701cd6e780b712db6653f57cb96d8308eb9567950cf','::1','node','2026-10-24 09:06:11.829','2026-10-17 09:06:11.830','2026-10-17 09:12:22.610'),('bb08358a-31f7-43ad-937e-eddd0a69513f','13f38306-99d7-4068-9899-744e04793548','bfb23461f3b8cb0c45472a7dc3c095ce4e43f5bee76206068aba78c518724bdb','::1','node','2026-10-24 05:02:42.116','2026-10-17 05:02:42.119','2026-10-17 11:31:33.197'),('bb29dd37-77ae-43e3-ba6e-bdaa0be4f73f','ea2d8b70-ca66-4b4f-bf25-595db63689ed','3965e2751eda71a9609d70947ff5269c4269ec0e2aa4f82c601de9e7afc4e8ce','::1','node','2026-10-23 12:39:20.173','2026-10-16 12:39:20.175','2026-10-17 06:52:42.851'),('bc7c1b4b-1bf4-4840-8de2-c7beafbeb685','ea2d8b70-ca66-4b4f-bf25-595db63689ed','bdeba49d55930ce1e0cc24d2336cb62b04cf76537711f1008fa076dac1f2f6ea','::1','node','2026-10-24 10:55:14.651','2026-10-17 10:55:14.652','2026-10-17 10:55:15.019'),('bcb22860-6cd0-4b5c-b5b0-d50ecd2bebc7','13f38306-99d7-4068-9899-744e04793548','c858829175ab4eef6cac8406267788542dd21f6fb87cc1a21dfa50fd5b034dac','::1','node','2026-10-24 07:27:33.900','2026-10-17 07:27:33.902','2026-10-17 11:31:33.197'),('bd7fe052-ffff-444a-a073-8b8de771d05b','ea2d8b70-ca66-4b4f-bf25-595db63689ed','d35defc3900211ce03ec25925bc5ab3dfcbd7eab8c66e8b7ed27f3ab059ceb64','::1','node','2026-10-24 11:29:39.217','2026-10-17 11:29:39.219','2026-10-17 11:29:39.228'),('bdd2cb90-386b-4221-be77-04a487df9546','ea2d8b70-ca66-4b4f-bf25-595db63689ed','020ad140a7ba131c42fcb70fac4d9081932133c01674c7eb147329b384ba9ed1','::1','node','2026-10-24 05:09:20.588','2026-10-17 05:09:20.593','2026-10-17 06:52:42.851'),('be0fcf2f-7149-4bdc-bc9c-09470609451b','ea2d8b70-ca66-4b4f-bf25-595db63689ed','6989ea0bc9872aa47e578e793993ab4f81141aed466e04023208ccdb1184a1c6','::1','node','2026-10-29 06:36:44.202','2026-10-22 06:36:44.211','2026-10-22 06:36:44.214'),('be67afca-9304-43ca-a9e9-6f499dc687a5','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','421dc8f3eb26ff607929fb7fef32a6b1d3b29277789a9d2210eb0e73b9303ccb','::1','node','2026-10-24 05:09:20.893','2026-10-17 05:09:20.897','2026-10-17 05:48:49.407'),('befb9e69-58ee-49a2-ba49-f5ea570da475','ea2d8b70-ca66-4b4f-bf25-595db63689ed','2cfe5cc8450d4c08b82df09282bd815b98ef7172f5d7fddf94505737a68878c0','::1','node','2026-10-24 11:29:35.751','2026-10-17 11:29:35.754','2026-10-17 11:29:35.780'),('c218c189-8f38-48ad-91b5-8d065aff58d5','ea2d8b70-ca66-4b4f-bf25-595db63689ed','a695682b8fd4dd55bdf76cfe85ff8c50c9e156b314808a3db2a4212b57a3aecc','::1','node','2026-10-23 12:16:24.922','2026-10-16 12:16:24.923','2026-10-16 12:16:24.937'),('c22a7eb9-f5d1-4479-8312-8563382d68fc','ea2d8b70-ca66-4b4f-bf25-595db63689ed','ad0cfe78f66fc138411ca2d356cc62b41b614e0cc5d647633bc25d95defe712d','::1','node','2026-10-24 11:29:39.502','2026-10-17 11:29:39.504','2026-10-17 11:29:39.514'),('c26853e5-bbbf-4502-9a11-a364d729d936','ea2d8b70-ca66-4b4f-bf25-595db63689ed','17f3aadec45e25c3b5dc9ef1cd6e2b9ec91d8066988e999af8da256d7fe631b4','::1','node','2026-10-24 06:57:16.697','2026-10-17 06:57:16.699','2026-10-17 06:57:16.709'),('c2a336b9-d18a-46e0-aeec-636908b3a756','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','b3c93bc1df121e1a0b90ca2480d5392a050288b5a7d9f6a6973923741a50b937','::1','node','2026-10-24 09:06:13.901','2026-10-17 09:06:13.902','2026-10-17 09:06:14.511'),('c44c239b-f81a-4770-84d2-27d4f005f429','13f38306-99d7-4068-9899-744e04793548','d9f648af691cb4f3b1a88e86d6c3c7d996ef84b5edd5844a8076910fd82673cf','::1','node','2026-10-24 10:54:26.809','2026-10-17 10:54:26.811','2026-10-17 11:31:33.197'),('c4ca259a-aecf-47ce-af4b-5bf2e87f5648','13f38306-99d7-4068-9899-744e04793548','c37a2409a7e99550bd2d84011571bd45b27ffbec0f5677e9eaa27cf2c0fa5a68','::1','node','2026-10-24 05:51:15.692','2026-10-17 05:51:15.693','2026-10-17 11:31:33.197'),('c5f8832a-5e0a-4427-9260-7061c3293956','ea2d8b70-ca66-4b4f-bf25-595db63689ed','6a1851f404e2981e30a4bce51c81d89bf98b1606b41d08730a1aee24ab43f8f8','::1','node','2026-10-24 07:15:46.775','2026-10-17 07:15:46.776','2026-10-17 07:27:31.443'),('c60e7574-a708-454e-90c6-41de2308d397','ea2d8b70-ca66-4b4f-bf25-595db63689ed','130709e77c3cada64d1d582910526c7f63d408b8adf13857a9475a38eb79f8fb','::1','node','2026-10-24 09:12:56.426','2026-10-17 09:12:56.428','2026-10-17 10:54:22.853'),('c6755893-0aca-4ce8-987e-b23aeacd41cc','ea2d8b70-ca66-4b4f-bf25-595db63689ed','a841132f4f0e7d4e8f215f114fbe203ab10ecb6d81f326fb75b9ae523364d804','::1','node','2026-10-24 10:54:22.803','2026-10-17 10:54:22.805','2026-10-17 10:54:22.829'),('c6ad1328-a08c-4f6d-bba7-7a7df0378f64','13f38306-99d7-4068-9899-744e04793548','b380b29af03981aafc55b60da79f1bfd6d54f12910bedc08aff98cf1183df4be','::1','node','2026-10-29 07:34:06.760','2026-10-22 07:34:06.769','2026-10-22 07:34:06.786'),('c770ba91-aaa7-4722-ad93-346eb46f151d','ea2d8b70-ca66-4b4f-bf25-595db63689ed','3133fc568034c3a67062961b275127201f2dd50c7bf6144609eeb3bd35b2da59','::1','node','2026-10-24 11:31:31.130','2026-10-17 11:31:31.132','2026-10-17 11:31:31.147'),('c799a722-f0a6-4272-9aa1-357f5fd4dcf3','13f38306-99d7-4068-9899-744e04793548','abe6637447e19c34d1000f31e3d7247238aaadaa295af35f035c77139e060a7d','::1','node','2026-10-24 09:05:39.096','2026-10-17 09:05:39.097','2026-10-17 11:31:33.197'),('c8b7dd8d-1cfd-4b00-9daf-ae186d2f4f59','ea2d8b70-ca66-4b4f-bf25-595db63689ed','f0c0ada1aa2f8e64f5a363d5219f08319977caaf9230c42d73878e1018ed8bb5','::1','node','2026-10-24 09:06:13.234','2026-10-17 09:06:13.235','2026-10-17 09:12:22.610'),('ca28d3eb-5f07-42af-b1fd-2a1d6f7c08dd','37f2fdec-67e6-439b-958d-2ec85e9b1183','a39ca12c7177c17a9806d18d19dc56325d640e88af6aafa74608921b1e15c47c','::1','node','2026-10-24 04:38:11.467','2026-10-17 04:38:11.470','2026-10-17 11:31:32.914'),('caae0e23-6c0a-49f1-b2db-1db9d61ef4c8','ea2d8b70-ca66-4b4f-bf25-595db63689ed','8532cc8d438d4474d2679d7d9c218aac7cccf4509e7ae62b2793399b67b6641d','::1','node','2026-10-29 07:28:56.988','2026-10-22 07:28:56.991','2026-10-22 07:28:57.024'),('cc5afb44-bb70-4668-a43b-f213ac619ff4','37f2fdec-67e6-439b-958d-2ec85e9b1183','8b3683ae1c00161fbe4083a05461475e0bb701946afa6bcd01908ced25b490de','::1','node','2026-10-24 10:54:26.143','2026-10-17 10:54:26.145','2026-10-17 11:31:32.914'),('ccbccb3d-4a9a-45cc-805b-c91555516833','ea2d8b70-ca66-4b4f-bf25-595db63689ed','0f460d4ef986aacaf5fdc20f232bb5084afdf3eb594754c142488672d2671020','::1','node','2026-10-29 07:34:03.604','2026-10-22 07:34:03.612','2026-10-22 07:34:03.628'),('ccccedb5-7f25-4213-be7a-bdd5407e39f1','37f2fdec-67e6-439b-958d-2ec85e9b1183','bf2eb6e301a58b0154fa642d2355937bceee5772999c09689524c8c0538ba47b','::1','node','2026-10-23 12:16:25.459','2026-10-16 12:16:25.461','2026-10-17 11:31:32.914'),('cebddc37-7d10-4def-a5a7-7cfbfca985b1','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','839b20badd6662592f52f2ccffacea3941407c62dab49927ef10a8fa63b8d0fc','::1','node','2026-10-24 10:55:18.787','2026-10-17 10:55:18.788','2026-10-17 10:55:19.325'),('cf12ae26-526a-4736-8910-26943a34dbb1','d2e9d278-5d54-43fc-b106-6f5d1465c70f','09970540208b40dfd2c817e74eaa875b115dfb5b1e19bb1ce8c3a59e4548a84e','::1','node','2026-10-24 10:54:25.848','2026-10-17 10:54:25.851','2026-10-17 11:31:32.567'),('d03e1bac-4c29-493a-bc3c-605e29514668','ea2d8b70-ca66-4b4f-bf25-595db63689ed','063e49d20fdcfd978063c46f5a9e90aafc9cdb003480fbdbdf30ebfa5b58be36','::1','node','2026-10-24 07:13:19.691','2026-10-17 07:13:19.693','2026-10-17 07:14:25.262'),('d0469319-d046-440c-a7ae-71f1b8b44082','d2e9d278-5d54-43fc-b106-6f5d1465c70f','b4221325f81680ce4fc71b7644f617e569168fdc70cbf6031ba59087596abe11','::1','node','2026-10-23 13:00:04.508','2026-10-16 13:00:04.509','2026-10-17 11:31:32.567'),('d0a1e1aa-b02c-4c75-b570-02f060c0c8d2','ea2d8b70-ca66-4b4f-bf25-595db63689ed','13afc8586fc76e4958229200838ce6a06d92a69ed6e1c473dd0283e3f0d64d1c','::1','node','2026-10-24 07:00:35.100','2026-10-17 07:00:35.101','2026-10-17 07:13:17.258'),('d1305bb4-1096-4180-875f-b7d8a54e1457','ea2d8b70-ca66-4b4f-bf25-595db63689ed','eb6a55d921db59a0c605c8baa5aaea11a040507d4e2ddd4c9c706b50c2a7dd09','::1','node','2026-10-29 07:32:19.045','2026-10-22 07:32:19.051','2026-10-22 07:32:19.071'),('d16e0208-771c-4a2f-b6f1-efe521280042','ea2d8b70-ca66-4b4f-bf25-595db63689ed','e963d2e0966ce102ffbd60c2e33ca7bb15ca0bda559fb9f0db4699c4e682ab7f','::1','node','2026-10-24 07:00:34.789','2026-10-17 07:00:34.790','2026-10-17 07:00:34.815'),('d16f74fb-f07f-4257-8547-1b76088a3772','ea2d8b70-ca66-4b4f-bf25-595db63689ed','5f9ae8a3aefe8eab7a7d9d5e852016e790891721c2170d053207720e7bee3ae0','::1','node','2026-10-24 07:07:29.443','2026-10-17 07:07:29.444','2026-10-17 07:13:17.258'),('d1a62a0d-eb73-4cd1-bd38-6f68d5f23db6','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','60239e07f00ad7be6a5ca11d8b3bc5744c0821dedd928e6e2bc4f779666ba00a','::1','node','2026-10-24 04:49:31.351','2026-10-17 04:49:31.355','2026-10-17 05:48:49.407'),('d1ff8c4b-99fa-4f1f-ae0e-5ee7cda00eb5','ea2d8b70-ca66-4b4f-bf25-595db63689ed','4b834b040291cd969533f8c51bd5a3bb561f6b783588814050c7055fb2d714fb','::1','node','2026-10-24 07:00:33.416','2026-10-17 07:00:33.417','2026-10-17 07:00:34.837'),('d243a512-7e3a-49c0-aba8-c500dd7536bb','ea2d8b70-ca66-4b4f-bf25-595db63689ed','7d6ec6e910f001872ea9fda11c4cc4b64091d6938324a7bba9e61ae2eaac9f74','::1','node','2026-10-24 09:06:09.195','2026-10-17 09:06:09.197','2026-10-17 09:06:09.620'),('d5820aa1-fade-4334-b8ec-3e017001cc47','13f38306-99d7-4068-9899-744e04793548','1bffe8619f9914729986dc86e1d75ea9c4c1f72be3573e3b6a88a8e8dfd7af28','::1','node','2026-10-24 10:54:26.498','2026-10-17 10:54:26.500','2026-10-17 11:31:33.197'),('d5a26f11-eb4a-4a4f-bea5-bf0364fc92cf','d2e9d278-5d54-43fc-b106-6f5d1465c70f','dd90f94148040c62c1f595d3b3c83c7b5e59940279da859286deba726580b942','::1','node','2026-10-24 09:06:10.768','2026-10-17 09:06:10.770','2026-10-17 11:31:32.567'),('d7b19567-bc39-4fbd-9730-f3f4dff7f43e','37f2fdec-67e6-439b-958d-2ec85e9b1183','7c2fcee72d92ec1e00c68bdc2cfc4ed11005bad0cf9ed26eda7fe9fc33520d11','::1','node','2026-10-24 07:13:20.503','2026-10-17 07:13:20.504','2026-10-17 11:31:32.914'),('da01f230-96ad-4d53-8c65-8776eb7b3d5b','d2e9d278-5d54-43fc-b106-6f5d1465c70f','8bc79c1c09f25620cb21f26a0fff036617adb4620306af4dcb5426e3037a48d2','::1','node','2026-10-24 07:08:07.260','2026-10-17 07:08:07.262','2026-10-17 07:08:07.322'),('da2cc564-d5c7-4eff-9764-93b8f5f99419','ea2d8b70-ca66-4b4f-bf25-595db63689ed','62302790318e7e6141680bde89bba78581ef25e7b6abd600e78202d16bae8f57','::1','node','2026-10-24 11:29:36.629','2026-10-17 11:29:36.630','2026-10-17 11:29:36.646'),('db3f339a-4075-464b-baab-ee0b72a02d06','d2e9d278-5d54-43fc-b106-6f5d1465c70f','ce243ea6764846e4006e1a9ba81403a41326704f4a34c3de7498075a512a978f','::1','node','2026-10-29 11:53:34.652','2026-10-22 11:53:34.655',NULL),('db66c315-5215-4b9a-b46f-2528a8464f83','ea2d8b70-ca66-4b4f-bf25-595db63689ed','702dd78af912300cc14a8b33d5424f4cb3c75dbaa61a1c536859b219574c4120','::1','node','2026-10-24 09:12:56.427','2026-10-17 09:12:56.430','2026-10-17 10:54:22.853'),('db67a95a-9255-4ac8-82cf-fb1c0430ec16','13f38306-99d7-4068-9899-744e04793548','3523501d6df5918fed593d206b25a9cf750f7399ad9d85adfb0a588b1defb236','::1','node','2026-10-24 07:07:30.654','2026-10-17 07:07:30.656','2026-10-17 07:07:30.684'),('dc01c4a5-8227-4bf6-90ca-56604332cbc2','ea2d8b70-ca66-4b4f-bf25-595db63689ed','22b4103a4be9a4143d0c39125b07385cb67251bc7c5cc2735fb24e3bf8af73cc','::1','node','2026-10-24 11:33:21.104','2026-10-17 11:33:21.106','2026-10-17 11:33:21.383'),('dca034fe-4b1e-4033-b4ab-7b989dbd47f3','ea2d8b70-ca66-4b4f-bf25-595db63689ed','3283045267d351bc4e865aecbc2c60c93d95f5fc60ff4b2aecbd4200d186fc40','::1','node','2026-10-24 07:13:22.457','2026-10-17 07:13:22.458','2026-10-17 07:14:25.262'),('dd62e948-e047-4bc2-aa63-e7e0486e3786','ea2d8b70-ca66-4b4f-bf25-595db63689ed','e54127944ec5602dceafe924e467abc95050e3cd5958f55ef71de13af59ca429','::1','node','2026-10-24 11:29:39.795','2026-10-17 11:29:39.796','2026-10-17 11:29:39.814'),('dd8838d5-d748-4ded-aeea-cb52598024bb','ea2d8b70-ca66-4b4f-bf25-595db63689ed','c9a0be5c9b3dd39c653be74cc66ad4c4ad940a97c69e9a1707e9a70ef40e59db','::1','node','2026-10-24 07:27:35.547','2026-10-17 07:27:35.549','2026-10-17 07:27:35.564'),('ddaa1071-7433-41a1-9f2c-0c9d5918b079','ea2d8b70-ca66-4b4f-bf25-595db63689ed','c42dcd704b926e2bc55fcbf02448daebe980feacb69a28defa5ab926df85c0fc','::1','node','2026-10-24 06:57:16.662','2026-10-17 06:57:16.663','2026-10-17 06:57:16.693'),('ded02cfe-9e27-41e3-bfcf-97d584d373a6','ea2d8b70-ca66-4b4f-bf25-595db63689ed','014d9714cf7b2d56134309a3756c648e9d457b0fbd491b7995d54b8ce3673f9a','::1','node','2026-10-24 06:52:41.397','2026-10-17 06:52:41.398','2026-10-17 06:52:42.851'),('dfb3e9b6-a7ec-4351-b95f-5b66897f28fd','37f2fdec-67e6-439b-958d-2ec85e9b1183','30374ace61db46bf3018cdf08668652d816681043aab355cde6021aff14ae90a','::1','node','2026-10-24 07:14:28.345','2026-10-17 07:14:28.347','2026-10-17 11:31:32.914'),('e03f9f4f-924a-4f03-8099-60bb143c9cda','ea2d8b70-ca66-4b4f-bf25-595db63689ed','22184ac49e767e22c173f6beab1d4a4f0f84289d235be0b4d370f3ec9241dc20','::1','node','2026-10-24 11:29:38.646','2026-10-17 11:29:38.648','2026-10-17 11:29:38.665'),('e07083fb-a57e-4a0f-b0c2-b4de76d5d4fe','ea2d8b70-ca66-4b4f-bf25-595db63689ed','824c3a6fa6d64a83ec8a21ac72a16c74e7462d264fad47e33c3cf0c949269824','::1','node','2026-10-29 06:56:49.842','2026-10-22 06:56:49.843','2026-10-22 06:56:49.863'),('e0b3262b-ff4a-4330-81bf-25a77672ff6d','ea2d8b70-ca66-4b4f-bf25-595db63689ed','82aa6bddccf3091a428aca1d3958ce47c1e505c011eee2ebac11c1a998380cd4','::1','node','2026-10-24 07:14:25.983','2026-10-17 07:14:25.985','2026-10-17 07:15:42.680'),('e0b60771-3e32-4633-a80e-ea112fa824c9','ea2d8b70-ca66-4b4f-bf25-595db63689ed','7d5289923de5f3ab303d6f4e4d28cf4de84e2720c58439532e70512402ac757c','::1','node','2026-10-24 09:06:10.041','2026-10-17 09:06:10.043','2026-10-17 09:12:22.610'),('e1b41a8f-20f0-486a-8d40-04d162d8a863','ea2d8b70-ca66-4b4f-bf25-595db63689ed','96b1ebcf78990fc21e9ea3314e9b18262dfabd3929e416782d978c0b586b648d','::1','node','2026-10-29 06:36:43.908','2026-10-22 06:36:43.917','2026-10-22 06:36:43.933'),('e23b5897-6d68-48f1-ad87-6181b157bffc','ea2d8b70-ca66-4b4f-bf25-595db63689ed','a0320482cfab67bc5e10dfcc9e9b6a0c9b3c4d76317a56e6b8e4f5e01b00e909','::1','node','2026-10-24 07:13:17.812','2026-10-17 07:13:17.813','2026-10-17 07:14:25.262'),('e2f8f660-b3eb-4dca-9c88-2f0b1ad2206f','ea2d8b70-ca66-4b4f-bf25-595db63689ed','546484ac122a47fe52389c9809d45721c6ae0f8f71a15fb9b601e3946c436990','::1','node','2026-10-24 11:31:31.707','2026-10-17 11:31:31.709','2026-10-17 11:31:31.717'),('e31be05d-7c43-477f-9b6f-d12190c2880f','13f38306-99d7-4068-9899-744e04793548','f06062c21468bf79b53a2aba7f06fa04e142862b7667ed0b4fecf4305ff1f765','::1','node','2026-10-24 07:00:36.177','2026-10-17 07:00:36.178','2026-10-17 11:31:33.197'),('e3345fba-1dae-4961-b3ac-817b8ab32b2e','d2e9d278-5d54-43fc-b106-6f5d1465c70f','353dd114cfccbb874a05245b8d3fe0cb3a651318e8490a324fdb5040e4e38f65','::1','node','2026-10-29 06:36:48.297','2026-10-22 06:36:48.307','2026-10-22 06:36:48.314'),('e36b25f5-6231-417f-bea1-924cb35beac7','ea2d8b70-ca66-4b4f-bf25-595db63689ed','6fe6f4f16f6f0443182038b529bc303197bcbad384a87557cb91abf5fc3e63c2','::1','node','2026-10-24 11:31:31.990','2026-10-17 11:31:31.992','2026-10-17 11:31:32.001'),('e3921ba3-fbfb-4107-b218-06f05de4a18f','d2e9d278-5d54-43fc-b106-6f5d1465c70f','2bb1217b9b5f8a1aeed2a0644f06abc89068f646c87ae76a78e648fef1af2465','::1','node','2026-10-24 10:55:15.959','2026-10-17 10:55:15.960','2026-10-17 11:31:32.567'),('e4612c65-8317-4f71-93ce-47d6d09d628d','37f2fdec-67e6-439b-958d-2ec85e9b1183','30ddbf263642e29b790e05130eb6222f75e31f542ad0203eb41fac98dd947a71','::1','node','2026-10-24 05:51:15.422','2026-10-17 05:51:15.423','2026-10-17 11:31:32.914'),('e4748596-f456-47ef-bbd5-9f4e6dc75541','ea2d8b70-ca66-4b4f-bf25-595db63689ed','b462d9333336659592be2a0d503c7db5b5455adbe654ef6d7cf2924432392162','::1','node','2026-10-24 11:29:38.103','2026-10-17 11:29:38.105','2026-10-17 11:29:38.665'),('e495712c-ea7f-4c90-8db6-1d4481f3cbe2','ea2d8b70-ca66-4b4f-bf25-595db63689ed','f57ae8cc61179014da8acaa731b42ea421e004a31ef8d6720594a54eb27aeb56','::1','node','2026-10-29 07:34:04.558','2026-10-22 07:34:04.566','2026-10-22 07:34:04.574'),('e4fb0b6e-c7a1-4464-8c91-ad1f5b664069','ea2d8b70-ca66-4b4f-bf25-595db63689ed','1f5894e5c6d08ed7e826b4c7ec0e0608097e5a67367aea44ed4bcd01b9f0891a','::1','node','2026-10-24 10:55:18.177','2026-10-17 10:55:18.178','2026-10-17 11:29:36.362'),('e52de2c7-ed54-43ae-beba-abe8a368cc5d','ea2d8b70-ca66-4b4f-bf25-595db63689ed','2081892dfdccb790c471ed79749873c8e30539516f774452fa32e626389a2996','::1','node','2026-10-24 09:06:12.686','2026-10-17 09:06:12.688','2026-10-17 09:12:22.610'),('e5c017bb-7a5b-4f64-bf74-78c4869b8190','ea2d8b70-ca66-4b4f-bf25-595db63689ed','05635ae53dfbb84c1aaed4248ca9cd71a885dd549ea30fd820dcbc39c4da6057','::1','node','2026-10-24 05:48:48.779','2026-10-17 05:48:48.787','2026-10-17 06:52:42.851'),('e62f49f5-0a39-4e47-968a-5f0df1f95377','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','01df1caadb6143e69124d9f4d49bbe529ae022147f141ad96402284accc5a72e','::1','node','2026-10-24 07:14:25.525','2026-10-17 07:14:25.527','2026-10-17 07:14:25.537'),('e6a55c12-b8e6-4884-9a42-3db5e572cc30','d2e9d278-5d54-43fc-b106-6f5d1465c70f','c2d5c87c805148bee2f1a9b759dbaa451043d731d7fc3fe7b28ded82591aecd4','::1','node','2026-10-24 07:27:33.359','2026-10-17 07:27:33.361','2026-10-17 11:31:32.567'),('e7095749-30bd-4ca2-a3c4-43e55208b68d','13f38306-99d7-4068-9899-744e04793548','354b10f617a8a437a9b9bae4f9ff0819c4258e3603879b0749d84960af00a7cd','::1','node','2026-10-24 07:27:34.181','2026-10-17 07:27:34.182','2026-10-17 11:31:33.197'),('e75e1c6b-72bf-4e04-a5c3-1590e5995c5f','ea2d8b70-ca66-4b4f-bf25-595db63689ed','6c1b85165cd6c1fff137e668a5623b7660ae1fac3d86b601eb4e742c57b673df','::1','node','2026-10-24 06:52:42.832','2026-10-17 06:52:42.833','2026-10-17 06:52:42.843'),('e7c04f58-1a4b-44bd-bda7-92ea4f1e98c0','ea2d8b70-ca66-4b4f-bf25-595db63689ed','7168c79167a4eeeba46389de98256bcb27ff8f4cae34452586b92d28cbac3194','::1','node','2026-10-24 09:06:09.585','2026-10-17 09:06:09.587','2026-10-17 09:06:09.608'),('e87a9669-6e85-465b-92c3-a4c084ed96d9','ea2d8b70-ca66-4b4f-bf25-595db63689ed','7588bdc2d63e8f573a3b77fdf87bba64705b6a4814bc8b0bde6027dabb7e98ab','::1','node','2026-10-24 09:06:09.514','2026-10-17 09:06:09.515','2026-10-17 09:06:09.578'),('e8d7cd0f-80bc-4180-ac58-73ef50dcf78d','ea2d8b70-ca66-4b4f-bf25-595db63689ed','faeef4c62ee584a0580f4bfc5369ad8f4254d4cc95b60ea0b9b4f396d579b6a8','::1','node','2026-10-24 11:31:29.507','2026-10-17 11:31:29.509','2026-10-17 11:31:29.519'),('e916c52b-0b1d-4e59-a7be-e7a4d6edab48','13f38306-99d7-4068-9899-744e04793548','b9c46349dda837eab674e60adcbc0ce0803a1137b2712eb888bc3402f8a9f5fa','::1','node','2026-10-24 07:14:28.745','2026-10-17 07:14:28.747','2026-10-17 11:31:33.197'),('e9e8d6b1-516a-4add-9afc-8454d7f64735','ea2d8b70-ca66-4b4f-bf25-595db63689ed','93197c9b41ca6284e750593e031aae7d532a003410b761c7a3d086cc6bac05a6','::1','node','2026-10-24 07:00:36.727','2026-10-17 07:00:36.728','2026-10-17 07:13:17.258'),('ea673544-a5f6-4966-addf-e721c5d0e650','37f2fdec-67e6-439b-958d-2ec85e9b1183','39037a0c3dd826c8f874b4f80c8433a1912a224341101e97c54adcf103d53f99','::1','node','2026-10-24 07:07:30.381','2026-10-17 07:07:30.382','2026-10-17 11:31:32.914'),('eb99da54-313f-4e1a-bbd0-ea34151fa783','ea2d8b70-ca66-4b4f-bf25-595db63689ed','11dd4d8d262d2d6e93b5854defddf343c99aa2e87068608a29d2bd0e0e9eee8a','::1','node','2026-10-29 07:34:05.171','2026-10-22 07:34:05.178','2026-10-22 07:34:05.195'),('ebff6a68-07f6-44de-b10e-a79c92a68ad0','13f38306-99d7-4068-9899-744e04793548','ef5ad696570da0b21a3949f369f9821c49556b8a261edff9b9a1dbc719f0060c','::1','node','2026-10-24 11:31:33.181','2026-10-17 11:31:33.183','2026-10-17 11:31:33.190'),('ec2b241f-35d3-4479-8113-3b2a4f6e9d31','ea2d8b70-ca66-4b4f-bf25-595db63689ed','f37342ac6a14021feb0bf81ee0c3ef1a1ff37c436e2f48ea4a763410b68ac442','::1','node','2026-10-24 09:06:12.123','2026-10-17 09:06:12.125','2026-10-17 09:12:22.610'),('ed45f49c-c37b-4620-9530-5434b11b3d0a','ea2d8b70-ca66-4b4f-bf25-595db63689ed','3c10ee0a7ccc850b8a9f4cb150aac77355e2ca8b33068a1a39b676014bde2ded','::1','node','2026-10-24 10:55:18.235','2026-10-17 10:55:18.236','2026-10-17 11:29:36.362'),('edb4cb12-7b5f-4465-8e2e-fa279cd0efba','ea2d8b70-ca66-4b4f-bf25-595db63689ed','2c65ed2b4128234ac74b33da876b3653166afb09144879d48108395c72f1dc58','::1','node','2026-10-29 07:32:19.357','2026-10-22 07:32:19.363','2026-10-22 07:32:19.383'),('ede4bbe9-38c9-4720-859c-56d08ba059bd','ea2d8b70-ca66-4b4f-bf25-595db63689ed','e1a37e250153ab57bf437c1c2cc5e9a45466e703bf8544f4b817b28a07335a6c','::1','node','2026-10-24 10:54:23.401','2026-10-17 10:54:23.403','2026-10-17 10:55:15.019'),('ee267e80-97f7-4843-a658-91145379ac1a','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','6d34d7297af45cf4825aa8a2ad660b8f78b8cf806c8c90108e0cb28cc1493b33','::1','node','2026-10-24 07:08:06.914','2026-10-17 07:08:06.915','2026-10-17 07:13:17.548'),('ee323da8-652d-4e4c-b35e-f786b87020fe','ea2d8b70-ca66-4b4f-bf25-595db63689ed','d5a21697755fa6c805564ae5f430e017397375c299a787cc157434155f8f1ffc','::1','node','2026-10-24 10:55:14.994','2026-10-17 10:55:14.995','2026-10-17 10:55:15.011'),('ee49f8b7-3747-4d0c-9149-93ed47cb3613','37f2fdec-67e6-439b-958d-2ec85e9b1183','fe4f4ba68d2d94ea5044c0993cbd37b08f9b69ce7d4c0d1b5018733d1e64d143','::1','node','2026-10-24 05:52:06.986','2026-10-17 05:52:06.988','2026-10-17 11:31:32.914'),('ee968f22-aee1-4fa7-98c0-df1b5a5de194','ea2d8b70-ca66-4b4f-bf25-595db63689ed','e9f00638ec718fb92f27de0efc530c62c813088bbce11d8911fda7827a7a14e5','::1','node','2026-10-29 07:34:01.942','2026-10-22 07:34:01.951','2026-10-22 07:34:02.049'),('ef78e0d0-71e1-407a-90ad-149d2f9fae2e','d2e9d278-5d54-43fc-b106-6f5d1465c70f','b4cd4a47ad3ac8f57e488fed14743d0a032dc0ffccce0d93ba3e80435893fb39','::1','node','2026-10-23 12:16:25.195','2026-10-16 12:16:25.196','2026-10-17 11:31:32.567'),('f0347c44-9803-41ca-a3f9-28aa8b6d4718','ea2d8b70-ca66-4b4f-bf25-595db63689ed','e5a90c6d48691abd55383001193e6e638a8385f77a592a22acf7f0666f201d37','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36','2026-10-24 09:45:33.986','2026-10-17 09:45:33.987','2026-10-17 10:06:54.965'),('f1b74727-57ce-40e6-a953-d8474996c588','ea2d8b70-ca66-4b4f-bf25-595db63689ed','c099a0db9bea77cc83ffab9e127a646448ae185b7faa2d6b3f3d359feb48b828','::1','node','2026-10-29 07:32:21.658','2026-10-22 07:32:21.664','2026-10-22 07:32:21.683'),('f2ca6fbf-7db0-4777-a013-278940ede9fd','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','6750d02ccb21fb954d42bcc9ac8a13d3a165a84f6fd002b9fcaecc683e191559','::1','node','2026-10-24 09:12:21.176','2026-10-17 09:12:21.179','2026-10-17 09:12:54.623'),('f40a4ea8-fe31-4574-a276-b767ba21b656','d2e9d278-5d54-43fc-b106-6f5d1465c70f','0c5046d09bd0ff7632c7107e2154df0f5cb6047f3bbb9a170c924406aefc7de6','::1','node','2026-10-24 11:31:32.550','2026-10-17 11:31:32.552','2026-10-17 11:31:32.560'),('f52d9143-6c1d-4e77-afc9-d2f27f647b0a','592860dd-8039-486e-a86e-e366de3b70df','5024c96c1e40e4ad726b3ee4f58223e5bb973209d0d5b76b91547461817c94b6','::1','node','2026-10-29 11:33:14.294','2026-10-22 11:33:14.297',NULL),('f63e272c-d10d-4564-8b62-da8b2582ede2','ea2d8b70-ca66-4b4f-bf25-595db63689ed','7498e9f695cae7babeeea12f90ee7fe1083d9f0545342e40dad556672b6d62cc','::1','node','2026-10-29 06:36:45.405','2026-10-22 06:36:45.415','2026-10-22 06:36:45.417'),('f6b33522-4c56-4bc4-842a-69bafdb13326','ea2d8b70-ca66-4b4f-bf25-595db63689ed','1148b9500ab664ca53e4a3f977c0c5563483dc87f759c941663c681168845ce1','::1','node','2026-10-29 06:36:47.719','2026-10-22 06:36:47.728','2026-10-22 06:36:47.732'),('f8be6b81-28e2-46e4-8a02-95f30d9d890b','37f2fdec-67e6-439b-958d-2ec85e9b1183','4708a786142d1432cefa2b10ee37f51b9b56546c52a66c9bb065a292a65e478f','::1','node','2026-10-24 09:12:21.833','2026-10-17 09:12:21.835','2026-10-17 11:31:32.914'),('f909c653-cbb1-4352-a8e5-d05da791638b','ea2d8b70-ca66-4b4f-bf25-595db63689ed','91ebff037a886c9b72084f468808f02a5770a5a0877b7ceecb8683f95b705d15','::1','node','2026-10-29 07:32:21.987','2026-10-22 07:32:21.993','2026-10-22 07:32:22.013'),('f937626a-43b2-4992-8534-24f1958b01d0','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','5a7a98b911da02233771fcac8afb639529520303a9a5ad32cc2769e0d461fcc2','::1','node','2026-10-29 07:34:07.086','2026-10-22 07:34:07.093','2026-10-22 07:34:07.099'),('f9ad5b92-827f-4ff0-93d9-9503fa17f22d','13f38306-99d7-4068-9899-744e04793548','a56238b9dc22424c47ac9140c24c914cc903f9c3320286b41720fd93bc36e2b1','::1','node','2026-10-24 11:33:23.375','2026-10-17 11:33:23.377','2026-10-17 11:33:23.391'),('fa5496cb-5b52-4459-9c39-88e9102c517e','fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','81d9ef50d4526261c6ae601926a3d820ccc6875cbda2f3527f773db84d539448','::1','node','2026-10-24 07:00:37.994','2026-10-17 07:00:37.995','2026-10-17 07:00:38.329'),('faeaf684-012a-4654-8c0d-e2047d2b2b57','ea2d8b70-ca66-4b4f-bf25-595db63689ed','00bf047764c527bda7cf8208f2f34a8ec6b5adfb55aa94e278dfb0407869af65','::1','node','2026-10-24 07:00:36.458','2026-10-17 07:00:36.459','2026-10-17 07:13:17.258'),('fb8e2f37-46ef-42c5-9c12-e9227069ec0c','d2e9d278-5d54-43fc-b106-6f5d1465c70f','1550b7fff30ef57624544a82b02173180ac012b2b48aa5092ded4660a0c72014','::1','node','2026-10-24 07:13:20.234','2026-10-17 07:13:20.235','2026-10-17 11:31:32.567'),('fc1ee77f-b23a-4f50-b1cf-1a866d4862f5','ea2d8b70-ca66-4b4f-bf25-595db63689ed','3b8fee31f4b900887efbe8d2bacf12ccae54009d3f6dfeee3842008bbd7ae7a2','::1','node','2026-10-24 07:14:25.239','2026-10-17 07:14:25.241','2026-10-17 07:14:25.262'),('fcf23c7e-b424-4c81-bed9-f0dd1574d5a9','ea2d8b70-ca66-4b4f-bf25-595db63689ed','f04a95d5c540a7be9de8d836e865dc553062b23db937e7eff6ceeaa914df77a6','::1','node','2026-10-29 06:36:45.965','2026-10-22 06:36:45.974','2026-10-22 06:36:45.981'),('fd57fcf4-85b7-4782-af44-6114cc53afad','ea2d8b70-ca66-4b4f-bf25-595db63689ed','91fc87250619aeb0010109fa29b87dd9999a3ef6605b96cf1fab13fa3ecfd374','::1','node','2026-10-24 06:57:16.978','2026-10-17 06:57:16.980','2026-10-17 07:00:34.837'),('fdca1ac1-09a4-4e0d-8030-abae314cd1da','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','cfd11f8b53c8e30d0743c5530566ae4d93d4b12be694e6a884b085fca7aaa4d6','::1','node','2026-10-24 07:14:27.499','2026-10-17 07:14:27.501','2026-10-17 07:15:42.964'),('ff443572-ff6b-4c7e-8d84-6710481ca669','ea2d8b70-ca66-4b4f-bf25-595db63689ed','9061e38c5290134b03e84d933c427274ca125e3a508c5bf59888b045c5eacc96','::1','node','2026-10-29 06:36:45.118','2026-10-22 06:36:45.127','2026-10-22 06:36:45.134'),('ffc687dc-336b-4931-ab80-a9f72372da43','ea2d8b70-ca66-4b4f-bf25-595db63689ed','491b1b21497c8d2d9f6f76f86d41420cd2473e63ef192178819d7683bfa6f8d6','::1','node','2026-10-29 07:32:17.928','2026-10-22 07:32:17.934','2026-10-22 07:32:17.955'); /*!40000 ALTER TABLE `auth_sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `condonation_requests` -- DROP TABLE IF EXISTS `condonation_requests`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `condonation_requests` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `student_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `event_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `granted_hours` decimal(5,1) NOT NULL, `status` enum('PENDING','APPROVED','REJECTED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING', `reviewed_by` varchar(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reviewed_at` datetime(3) DEFAULT NULL, `remarks` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `updated_at` datetime(3) NOT NULL, PRIMARY KEY (`id`), KEY `condonation_requests_student_id_idx` (`student_id`), CONSTRAINT `condonation_requests_student_id_fkey` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `condonation_requests` -- LOCK TABLES `condonation_requests` WRITE; /*!40000 ALTER TABLE `condonation_requests` DISABLE KEYS */; INSERT INTO `condonation_requests` VALUES ('18097029-fc4f-4968-a294-89e0d774f721','ad45f3a0-8f76-489d-8a7d-71902cb1db44','All India Inter-Hotel Management Culinary Trophy 2026',4.0,'APPROVED','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','2026-10-17 04:38:11.693','Approved as per institutional co-curricular duty norms','2026-10-17 04:38:11.668','2026-10-17 04:38:11.696'),('76260282-2a3d-4040-9397-f09faeb09734','ad45f3a0-8f76-489d-8a7d-71902cb1db44','Unrecognized private club workshop',5.0,'REJECTED','f898fcaf-05a5-43ab-9b9f-f95baef8efd7','2026-10-17 04:38:11.728','Not an authorized or approved institutional event.','2026-10-17 04:38:11.714','2026-10-17 04:38:11.732'); /*!40000 ALTER TABLE `condonation_requests` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `courses` -- DROP TABLE IF EXISTS `courses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `courses` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `duration_years` int NOT NULL DEFAULT '3', `total_semesters` int NOT NULL DEFAULT '6', `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `updated_at` datetime(3) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `courses_code_key` (`code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `courses` -- LOCK TABLES `courses` WRITE; /*!40000 ALTER TABLE `courses` DISABLE KEYS */; INSERT INTO `courses` VALUES ('030836fd-4714-4b99-a0c8-9ce4c6813e52','BHM','B.Sc. in Hospitality & Hotel Administration',3,6,'2026-10-16 12:10:04.349','2026-10-16 12:10:04.349'),('c04701e7-051b-4e40-89f3-c92d8604592c','MHM','M.Sc. in Hospitality Administration',2,4,'2026-10-16 12:32:46.994','2026-10-16 12:32:46.994'); /*!40000 ALTER TABLE `courses` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `faculty` -- DROP TABLE IF EXISTS `faculty`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `faculty` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `employee_code` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `department` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `designation` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `updated_at` datetime(3) NOT NULL, `status` enum('ACTIVE','INACTIVE','ON_LEAVE') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ACTIVE', PRIMARY KEY (`id`), UNIQUE KEY `faculty_user_id_key` (`user_id`), UNIQUE KEY `faculty_employee_code_key` (`employee_code`), CONSTRAINT `faculty_user_id_fkey` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faculty` -- LOCK TABLES `faculty` WRITE; /*!40000 ALTER TABLE `faculty` DISABLE KEYS */; INSERT INTO `faculty` VALUES ('054364fc-2e0a-4a01-826d-c734590f957e','d2e9d278-5d54-43fc-b106-6f5d1465c70f','FAC-FP-001','Food Production','Senior Lecturer','2026-10-16 12:10:05.156','2026-10-16 12:10:05.156','ACTIVE'),('c557e8d4-b1ec-45b5-b6d0-1fc0482e7695','592860dd-8039-486e-a86e-e366de3b70df','FAC-FP-002','Food Production','Lecturer','2026-10-16 12:32:47.355','2026-10-16 12:32:47.355','ACTIVE'); /*!40000 ALTER TABLE `faculty` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `faculty_subject_allocations` -- DROP TABLE IF EXISTS `faculty_subject_allocations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `faculty_subject_allocations` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `academic_session_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `faculty_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `subject_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `group_id` varchar(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `updated_at` datetime(3) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `faculty_subject_allocations_academic_session_id_faculty_id_s_key` (`academic_session_id`,`faculty_id`,`subject_id`,`group_id`), KEY `faculty_subject_allocations_faculty_id_fkey` (`faculty_id`), KEY `faculty_subject_allocations_subject_id_fkey` (`subject_id`), KEY `faculty_subject_allocations_group_id_fkey` (`group_id`), CONSTRAINT `faculty_subject_allocations_academic_session_id_fkey` FOREIGN KEY (`academic_session_id`) REFERENCES `academic_sessions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `faculty_subject_allocations_faculty_id_fkey` FOREIGN KEY (`faculty_id`) REFERENCES `faculty` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `faculty_subject_allocations_group_id_fkey` FOREIGN KEY (`group_id`) REFERENCES `student_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `faculty_subject_allocations_subject_id_fkey` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faculty_subject_allocations` -- LOCK TABLES `faculty_subject_allocations` WRITE; /*!40000 ALTER TABLE `faculty_subject_allocations` DISABLE KEYS */; INSERT INTO `faculty_subject_allocations` VALUES ('ab995f3e-da2d-4490-9bf0-8ed7a2adbd2c','90d47503-54e7-468a-b1a1-871d9c9c8988','c557e8d4-b1ec-45b5-b6d0-1fc0482e7695','f94445e2-3b73-4f98-a3f3-186950397f2a','ca358a7b-088d-48aa-a7c6-e41150b69e97','2026-10-16 12:32:47.374','2026-10-16 12:32:47.374'),('c1a23963-392c-46b7-b1e7-456a0a010ed5','90d47503-54e7-468a-b1a1-871d9c9c8988','054364fc-2e0a-4a01-826d-c734590f957e','f94445e2-3b73-4f98-a3f3-186950397f2a','8e40c464-1e35-472d-8ef4-af81fc1ccd9b','2026-10-16 12:39:20.276','2026-10-16 12:39:20.276'); /*!40000 ALTER TABLE `faculty_subject_allocations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `faculty_substitutions` -- DROP TABLE IF EXISTS `faculty_substitutions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `faculty_substitutions` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `attendance_session_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `original_faculty_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `substitute_faculty_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `reason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `status` enum('PENDING','APPROVED','REJECTED','CANCELLED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'APPROVED', `assigned_by` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `reviewed_by` varchar(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reviewed_at` datetime(3) DEFAULT NULL, `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `updated_at` datetime(3) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `faculty_substitutions_attendance_session_id_key` (`attendance_session_id`), KEY `faculty_substitutions_original_faculty_id_fkey` (`original_faculty_id`), KEY `faculty_substitutions_substitute_faculty_id_fkey` (`substitute_faculty_id`), CONSTRAINT `faculty_substitutions_attendance_session_id_fkey` FOREIGN KEY (`attendance_session_id`) REFERENCES `attendance_sessions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `faculty_substitutions_original_faculty_id_fkey` FOREIGN KEY (`original_faculty_id`) REFERENCES `faculty` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE, CONSTRAINT `faculty_substitutions_substitute_faculty_id_fkey` FOREIGN KEY (`substitute_faculty_id`) REFERENCES `faculty` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faculty_substitutions` -- LOCK TABLES `faculty_substitutions` WRITE; /*!40000 ALTER TABLE `faculty_substitutions` DISABLE KEYS */; INSERT INTO `faculty_substitutions` VALUES ('0bb6d474-708f-4acb-8009-55ff47eea9b4','dd6adf7b-78fe-469d-8623-f89ab6939347','054364fc-2e0a-4a01-826d-c734590f957e','c557e8d4-b1ec-45b5-b6d0-1fc0482e7695','Chef Sanjeev on leave for NCHMCT Culinary Assessment','APPROVED','f898fcaf-05a5-43ab-9b9f-f95baef8efd7',NULL,NULL,'2026-10-17 04:38:52.953','2026-10-17 04:38:52.953'); /*!40000 ALTER TABLE `faculty_substitutions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `guardians` -- DROP TABLE IF EXISTS `guardians`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `guardians` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` varchar(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL, `relationship` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `mobile` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `updated_at` datetime(3) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `guardians_email_key` (`email`), UNIQUE KEY `guardians_user_id_key` (`user_id`), CONSTRAINT `guardians_user_id_fkey` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `guardians` -- LOCK TABLES `guardians` WRITE; /*!40000 ALTER TABLE `guardians` DISABLE KEYS */; INSERT INTO `guardians` VALUES ('32749d92-2ec9-4279-99d1-a422511c7ca2','13f38306-99d7-4068-9899-744e04793548','Rajesh Sharma','Father','parent.sharma@example.com','+91 98765 43210','2026-10-17 05:02:41.440','2026-10-17 05:02:41.440'); /*!40000 ALTER TABLE `guardians` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `holidays` -- DROP TABLE IF EXISTS `holidays`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `holidays` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `academic_session_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `holiday_date` date NOT NULL, `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `updated_at` datetime(3) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `holidays_academic_session_id_holiday_date_key` (`academic_session_id`,`holiday_date`), CONSTRAINT `holidays_academic_session_id_fkey` FOREIGN KEY (`academic_session_id`) REFERENCES `academic_sessions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `holidays` -- LOCK TABLES `holidays` WRITE; /*!40000 ALTER TABLE `holidays` DISABLE KEYS */; INSERT INTO `holidays` VALUES ('f5475874-d8b0-4234-a2d8-58dcbf064f5d','90d47503-54e7-468a-b1a1-871d9c9c8988','Durga Puja Maha Ashtami','2026-10-19','2026-10-16 12:39:20.373','2026-10-16 12:39:20.373'); /*!40000 ALTER TABLE `holidays` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `medical_requests` -- DROP TABLE IF EXISTS `medical_requests`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `medical_requests` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `student_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `start_date` date NOT NULL, `end_date` date NOT NULL, `requested_hours` decimal(5,1) NOT NULL, `certificate_ref` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `status` enum('PENDING','APPROVED','REJECTED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING', `approved_hours` decimal(5,1) DEFAULT NULL, `reviewed_by` varchar(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reviewed_at` datetime(3) DEFAULT NULL, `remarks` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `updated_at` datetime(3) NOT NULL, PRIMARY KEY (`id`), KEY `medical_requests_student_id_idx` (`student_id`), CONSTRAINT `medical_requests_student_id_fkey` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `medical_requests` -- LOCK TABLES `medical_requests` WRITE; /*!40000 ALTER TABLE `medical_requests` DISABLE KEYS */; INSERT INTO `medical_requests` VALUES ('38bc5941-a0ec-4adf-b65b-4c3347167ce6','ad45f3a0-8f76-489d-8a7d-71902cb1db44','2026-10-21','2026-10-23',6.0,'https://storage.ihm.ac.in/medical/aarav_medical_oct2026.pdf','APPROVED',0.3,'f898fcaf-05a5-43ab-9b9f-f95baef8efd7','2026-10-17 04:38:11.633','Medical certificate verified with Woodlands Hospital OPD counter','2026-10-17 04:38:11.553','2026-10-17 04:38:11.637'),('7efdc16f-e4a5-4f49-beab-8c3f69853f63','ad45f3a0-8f76-489d-8a7d-71902cb1db44','2026-11-10','2026-11-12',2.0,'DOC-MED-NOV2026.pdf','REJECTED',NULL,'f898fcaf-05a5-43ab-9b9f-f95baef8efd7','2026-10-17 05:11:16.196','Ceiling reached, rejected by policy','2026-10-17 05:11:16.173','2026-10-17 05:11:16.202'),('85954cb1-5a19-4646-8b01-645927803f27','ad45f3a0-8f76-489d-8a7d-71902cb1db44','2026-11-10','2026-11-12',2.0,'DOC-MED-NOV2026.pdf','PENDING',NULL,NULL,NULL,'Acute allergic reaction','2026-10-17 05:09:21.838','2026-10-17 05:09:21.838'),('a1695bb4-a868-41a3-a80a-164d21e0f371','ad45f3a0-8f76-489d-8a7d-71902cb1db44','2026-11-10','2026-11-12',2.0,'DOC-MED-NOV2026.pdf','REJECTED',NULL,'f898fcaf-05a5-43ab-9b9f-f95baef8efd7','2026-10-17 05:52:07.245','Ceiling reached, rejected by policy','2026-10-17 05:52:07.220','2026-10-17 05:52:07.247'); /*!40000 ALTER TABLE `medical_requests` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `notices` -- DROP TABLE IF EXISTS `notices`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `notices` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `content` text COLLATE utf8mb4_unicode_ci NOT NULL, `target_role` enum('ALL','STUDENTS','FACULTY','PARENTS','STAFF') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ALL', `is_active` tinyint(1) NOT NULL DEFAULT '1', `created_by` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `updated_at` datetime(3) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `notices` -- LOCK TABLES `notices` WRITE; /*!40000 ALTER TABLE `notices` DISABLE KEYS */; INSERT INTO `notices` VALUES ('6394b078-cd21-4205-873b-bcc016f7553a','Confidential: Faculty Board Meeting Notice','HODs and Chef Instructors are requested to attend the meeting at 4 PM.','FACULTY',1,'f898fcaf-05a5-43ab-9b9f-f95baef8efd7','2026-10-17 05:02:42.292','2026-10-17 05:02:42.292'),('718d90c4-4bd7-4e30-b978-7d166b0a2587','Annual Culinary Fest 2026','IHM Kolkata will host the National Hospitality Expo from Nov 15-18.','ALL',1,'f898fcaf-05a5-43ab-9b9f-f95baef8efd7','2026-10-17 05:02:42.249','2026-10-17 05:02:42.249'),('cf7a5254-99ae-4b16-b0e6-5f038bb36587','Semester End Practical Examination Timetable','All BHM semester practical schedules are published on the academic board.','STUDENTS',1,'f898fcaf-05a5-43ab-9b9f-f95baef8efd7','2026-10-17 05:02:42.271','2026-10-17 05:02:42.271'); /*!40000 ALTER TABLE `notices` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `role_permissions` -- DROP TABLE IF EXISTS `role_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `role_permissions` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `role` enum('SUPER_ADMIN','ACADEMIC_ADMIN','HOD','FACULTY','STUDENT','PARENT') COLLATE utf8mb4_unicode_ci NOT NULL, `permission` enum('USER_VIEW','USER_CREATE','USER_EDIT','USER_DELETE','ACADEMIC_VIEW','ACADEMIC_MANAGE','TIMETABLE_VIEW','TIMETABLE_MANAGE','ATTENDANCE_VIEW','ATTENDANCE_ENTRY','ATTENDANCE_MODIFY','ATTENDANCE_FINALIZE','ATTENDANCE_LOCK','ATTENDANCE_UNLOCK','ATTENDANCE_SUBSTITUTE','ATTENDANCE_RESCHEDULE','ADJUSTMENT_VIEW','ADJUSTMENT_REVIEW','POLICY_VIEW','POLICY_MANAGE','REPORT_VIEW','REPORT_EXPORT','APR_GENERATE','APR_FREEZE','AUDIT_VIEW','SYSTEM_CONFIG','BACKUP_MANAGE') COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), PRIMARY KEY (`id`), UNIQUE KEY `role_permissions_role_permission_key` (`role`,`permission`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `role_permissions` -- LOCK TABLES `role_permissions` WRITE; /*!40000 ALTER TABLE `role_permissions` DISABLE KEYS */; INSERT INTO `role_permissions` VALUES ('033a1f36-f5c9-44d9-b029-f86c72a5ca4c','ACADEMIC_ADMIN','ATTENDANCE_FINALIZE','2026-10-16 12:10:04.200'),('0500fe9f-f3f5-4e00-80ad-f81bc1118a73','STUDENT','ADJUSTMENT_VIEW','2026-10-16 12:10:04.330'),('05ae83e4-744b-4532-95b7-7c2c01ffaf74','SUPER_ADMIN','USER_CREATE','2026-10-16 12:10:04.050'),('0d62b052-305a-4b78-9009-8e8e161f2dfd','HOD','ATTENDANCE_SUBSTITUTE','2026-10-16 12:10:04.265'),('0e890fe6-68f9-4f92-a50c-7baf206ab48f','STUDENT','TIMETABLE_VIEW','2026-10-16 12:10:04.326'),('10807d3b-eb45-42c7-b868-a7798a8c7dee','ACADEMIC_ADMIN','APR_GENERATE','2026-10-16 12:10:04.237'),('14cc8c54-e8a3-4681-ab73-d369526de86b','ACADEMIC_ADMIN','ATTENDANCE_RESCHEDULE','2026-10-16 12:10:04.211'),('16231e91-8f0d-43d4-84a5-6c59bf71a26b','ACADEMIC_ADMIN','AUDIT_VIEW','2026-10-16 12:10:04.245'),('1697c198-192f-4d67-9ebf-b2620ac7c70b','SUPER_ADMIN','APR_FREEZE','2026-10-16 12:10:04.149'),('1c44ee6d-5e25-4313-bf33-d88945c0b03b','ACADEMIC_ADMIN','USER_EDIT','2026-10-16 12:10:04.174'),('1dccb562-fcfc-4a4d-9252-5921cee2248d','FACULTY','ATTENDANCE_ENTRY','2026-10-16 12:10:04.306'),('2597195d-6681-4763-9f81-20ff5ab3f13b','FACULTY','ATTENDANCE_MODIFY','2026-10-16 12:10:04.310'),('268384e9-7f5c-4956-81fe-b1b981e85b01','FACULTY','REPORT_VIEW','2026-10-16 12:10:04.314'),('2f7ad5b1-95ad-4c6e-ad2f-c1841e1527d4','SUPER_ADMIN','BACKUP_MANAGE','2026-10-16 12:10:04.162'),('32219217-19f3-417b-a024-64e7af04ac1d','ACADEMIC_ADMIN','TIMETABLE_VIEW','2026-10-16 12:10:04.186'),('3450bd70-5572-4c4c-84c8-6b235414f059','SUPER_ADMIN','ATTENDANCE_UNLOCK','2026-10-16 12:10:04.105'),('34a82070-d9a7-4c13-ad72-1af3eb2101d4','FACULTY','TIMETABLE_VIEW','2026-10-16 12:10:04.299'),('37ca6d44-9672-44a6-80ee-d628def11bc7','HOD','REPORT_VIEW','2026-10-16 12:10:04.282'),('3ac138b1-7178-4ecf-afde-87e7ffe64ba7','SUPER_ADMIN','USER_VIEW','2026-10-16 12:10:04.038'),('3c16eae6-4e4e-494c-8e69-55e924fecf68','SUPER_ADMIN','ATTENDANCE_ENTRY','2026-10-16 12:10:04.087'),('3cdabd2b-5eae-4c83-8bee-ffe9db64b195','FACULTY','ACADEMIC_VIEW','2026-10-16 12:10:04.294'),('3e640653-b627-43ff-986f-1cd71ee6de82','SUPER_ADMIN','ACADEMIC_MANAGE','2026-10-16 12:10:04.070'),('41e8f81e-1511-46e8-b128-33709128045b','SUPER_ADMIN','ATTENDANCE_VIEW','2026-10-16 12:10:04.082'),('4698fc7d-b1e9-4e71-99d5-dea76785a8b6','HOD','ATTENDANCE_FINALIZE','2026-10-16 12:10:04.261'),('4a11c905-593f-4c21-a888-a3c2ede2870a','SUPER_ADMIN','POLICY_VIEW','2026-10-16 12:10:04.127'),('4f12595f-4a2d-4c0a-99ee-d05a1b61bc31','STUDENT','ATTENDANCE_VIEW','2026-10-16 12:10:04.318'),('4fa7f361-5bb3-4105-8007-a19a8715a0cf','ACADEMIC_ADMIN','REPORT_EXPORT','2026-10-16 12:10:04.234'),('50ab5295-5550-4d12-9f7a-c27e50c6f47e','ACADEMIC_ADMIN','REPORT_VIEW','2026-10-16 12:10:04.229'),('541d06ca-8a05-4c1c-b9dd-26e05359b4ab','SUPER_ADMIN','TIMETABLE_MANAGE','2026-10-16 12:10:04.078'),('54d21528-d7fd-4c3a-8f2f-1152e42dad02','HOD','APR_GENERATE','2026-10-16 12:10:04.290'),('56c31284-e79d-463b-8b18-e3b1cbaad5ee','SUPER_ADMIN','TIMETABLE_VIEW','2026-10-16 12:10:04.074'),('57a26d89-2f1d-4ac6-ae7f-9b7562c357fe','ACADEMIC_ADMIN','ACADEMIC_MANAGE','2026-10-16 12:10:04.182'),('5fd5b623-6d13-41ff-be5e-629a7f61166d','SUPER_ADMIN','ATTENDANCE_MODIFY','2026-10-16 12:10:04.091'),('66ced946-0a4a-472c-8d0c-198f6993634f','HOD','TIMETABLE_VIEW','2026-10-16 12:10:04.253'),('67440d66-cdba-4e59-a7d5-06790d2c8764','ACADEMIC_ADMIN','USER_VIEW','2026-10-16 12:10:04.166'),('68af4dc2-77dc-4f27-99d9-c19179aaa779','ACADEMIC_ADMIN','ATTENDANCE_UNLOCK','2026-10-16 12:10:04.207'),('6bec64e0-450a-4ea1-8b4e-772cac1d37a8','STUDENT','REPORT_VIEW','2026-10-16 12:10:04.322'),('73c6cbde-5777-45b7-99ca-51d03ec174f5','SUPER_ADMIN','REPORT_EXPORT','2026-10-16 12:10:04.140'),('782864ac-1e34-4b56-9f3f-bddeca7bdaa0','SUPER_ADMIN','POLICY_MANAGE','2026-10-16 12:10:04.131'),('7c1b5546-789e-46a8-8273-e8bbc42685c3','SUPER_ADMIN','USER_EDIT','2026-10-16 12:10:04.057'),('7e47d434-18e5-44c6-8cd1-2ebb5452826f','ACADEMIC_ADMIN','ADJUSTMENT_VIEW','2026-10-16 12:10:04.215'),('7f82584e-0b4d-4e21-aab5-dba393540e8c','SUPER_ADMIN','APR_GENERATE','2026-10-16 12:10:04.145'),('83c53dfb-29fd-440d-af66-491797a1161e','SUPER_ADMIN','ATTENDANCE_RESCHEDULE','2026-10-16 12:10:04.114'),('88d8eb99-2161-413d-950d-a24a377d34ef','ACADEMIC_ADMIN','POLICY_VIEW','2026-10-16 12:10:04.226'),('8930680f-2471-42b3-8756-fffad71665ce','SUPER_ADMIN','ATTENDANCE_SUBSTITUTE','2026-10-16 12:10:04.109'),('8cff7421-5f92-4a1d-90a2-3c3e3ab874c2','ACADEMIC_ADMIN','ADJUSTMENT_REVIEW','2026-10-16 12:10:04.221'),('8f028bc4-ce72-4c53-9c83-f46ef232498e','SUPER_ADMIN','ADJUSTMENT_VIEW','2026-10-16 12:10:04.118'),('8f5cc1d1-f8fd-4ec3-a34e-4b4eee62c24d','PARENT','ATTENDANCE_VIEW','2026-10-16 12:10:04.334'),('8fc96470-8287-42d8-a284-2bb0a5fc0731','SUPER_ADMIN','ACADEMIC_VIEW','2026-10-16 12:10:04.065'),('949f98f4-143b-484b-a62a-7466badd0951','ACADEMIC_ADMIN','ATTENDANCE_VIEW','2026-10-16 12:10:04.196'),('9717dec0-69a9-42c2-a3c3-13d723b82d95','ACADEMIC_ADMIN','ATTENDANCE_LOCK','2026-10-16 12:10:04.204'),('9cb341b8-0887-45dc-96fa-d59eebfb1406','SUPER_ADMIN','SYSTEM_CONFIG','2026-10-16 12:10:04.158'),('9cea220f-4903-450f-b37b-c1e75dd5ad58','SUPER_ADMIN','ADJUSTMENT_REVIEW','2026-10-16 12:10:04.122'),('b3485fd3-229c-489b-98da-f5eda817aaa3','SUPER_ADMIN','REPORT_VIEW','2026-10-16 12:10:04.135'),('b48e8c3f-a1db-48ca-bd89-b7ae1f44484a','FACULTY','ATTENDANCE_VIEW','2026-10-16 12:10:04.302'),('b4b2d90c-23d3-4e44-934e-d08ad644af77','HOD','ATTENDANCE_VIEW','2026-10-16 12:10:04.257'),('b76aafc5-d659-4e70-9ebd-2a7ba496dfdc','SUPER_ADMIN','ATTENDANCE_FINALIZE','2026-10-16 12:10:04.097'),('c30cca3a-dde6-4035-bce8-fa40fbfa834a','ACADEMIC_ADMIN','TIMETABLE_MANAGE','2026-10-16 12:10:04.191'),('c4a6e2b1-533e-4c0e-9ce5-130ac49a4bc1','ACADEMIC_ADMIN','USER_CREATE','2026-10-16 12:10:04.170'),('cb40dfd6-adc0-4bb0-9875-face021a4156','HOD','ADJUSTMENT_REVIEW','2026-10-16 12:10:04.273'),('cba0028d-9bb2-4e64-95de-37773413f033','ACADEMIC_ADMIN','ACADEMIC_VIEW','2026-10-16 12:10:04.178'),('cc906d6f-b012-4e12-9703-cd7316432c62','PARENT','REPORT_VIEW','2026-10-16 12:10:04.338'),('d0392213-ecc0-4982-87c9-be58b16db31a','HOD','REPORT_EXPORT','2026-10-16 12:10:04.286'),('d0c435f5-030c-4e70-bccf-0f9124619754','SUPER_ADMIN','USER_DELETE','2026-10-16 12:10:04.061'),('d40ffa14-2d48-42ff-a9c6-eb70cbb13394','HOD','ADJUSTMENT_VIEW','2026-10-16 12:10:04.269'),('d8558990-5697-4a3d-a5e8-71226a9d4551','SUPER_ADMIN','ATTENDANCE_LOCK','2026-10-16 12:10:04.101'),('e1997648-4520-44fb-8878-8a68b6bee0b7','SUPER_ADMIN','AUDIT_VIEW','2026-10-16 12:10:04.153'),('ef2041a4-edd9-4967-9727-8ab4b80da4a3','ACADEMIC_ADMIN','APR_FREEZE','2026-10-16 12:10:04.241'),('fdcc0087-e89a-4765-9475-cabc762ccf80','HOD','ACADEMIC_VIEW','2026-10-16 12:10:04.250'); /*!40000 ALTER TABLE `role_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rooms` -- DROP TABLE IF EXISTS `rooms`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `rooms` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `code` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `capacity` int NOT NULL DEFAULT '30', `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `updated_at` datetime(3) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `rooms_code_key` (`code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rooms` -- LOCK TABLES `rooms` WRITE; /*!40000 ALTER TABLE `rooms` DISABLE KEYS */; INSERT INTO `rooms` VALUES ('01466f7e-ef78-46ae-8359-a3ed548ba5b6','Basic Training Kitchen 2','BTK-102',35,'2026-10-16 12:32:47.070','2026-10-16 12:32:47.070'); /*!40000 ALTER TABLE `rooms` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `semesters` -- DROP TABLE IF EXISTS `semesters`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `semesters` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `academic_session_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `course_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `semester_number` int NOT NULL, `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `is_active` tinyint(1) NOT NULL DEFAULT '1', `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `updated_at` datetime(3) NOT NULL, `end_date` date DEFAULT NULL, `start_date` date DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `semesters_academic_session_id_course_id_semester_number_key` (`academic_session_id`,`course_id`,`semester_number`), KEY `semesters_course_id_fkey` (`course_id`), CONSTRAINT `semesters_academic_session_id_fkey` FOREIGN KEY (`academic_session_id`) REFERENCES `academic_sessions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `semesters_course_id_fkey` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `semesters` -- LOCK TABLES `semesters` WRITE; /*!40000 ALTER TABLE `semesters` DISABLE KEYS */; INSERT INTO `semesters` VALUES ('fb69305f-fbe0-4428-adec-2178e01715fc','90d47503-54e7-468a-b1a1-871d9c9c8988','030836fd-4714-4b99-a0c8-9ce4c6813e52',5,'Semester V (2026-2027)',1,'2026-10-16 12:10:04.355','2026-10-16 12:10:04.355',NULL,NULL); /*!40000 ALTER TABLE `semesters` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `student_enrollments` -- DROP TABLE IF EXISTS `student_enrollments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `student_enrollments` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `student_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `semester_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `academic_session_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `roll_number` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ACTIVE', `enrolled_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), PRIMARY KEY (`id`), UNIQUE KEY `student_enrollments_student_id_semester_id_academic_session__key` (`student_id`,`semester_id`,`academic_session_id`), KEY `student_enrollments_semester_id_fkey` (`semester_id`), KEY `student_enrollments_academic_session_id_fkey` (`academic_session_id`), CONSTRAINT `student_enrollments_academic_session_id_fkey` FOREIGN KEY (`academic_session_id`) REFERENCES `academic_sessions` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE, CONSTRAINT `student_enrollments_semester_id_fkey` FOREIGN KEY (`semester_id`) REFERENCES `semesters` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE, CONSTRAINT `student_enrollments_student_id_fkey` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `student_enrollments` -- LOCK TABLES `student_enrollments` WRITE; /*!40000 ALTER TABLE `student_enrollments` DISABLE KEYS */; INSERT INTO `student_enrollments` VALUES ('0483511c-09ee-4253-97fb-2475465330bc','df6dabb7-1d6c-4237-b48a-9302e9edfba8','fb69305f-fbe0-4428-adec-2178e01715fc','90d47503-54e7-468a-b1a1-871d9c9c8988','NCHM2026102','ACTIVE','2026-10-16 12:32:47.727'),('a1ab5eed-83dd-46fd-80f9-60b40ab5e4f7','d55e8ba9-9cf6-473f-9d13-53a8c34c6b72','fb69305f-fbe0-4428-adec-2178e01715fc','90d47503-54e7-468a-b1a1-871d9c9c8988','NCHM2026101','ACTIVE','2026-10-16 12:32:47.720'); /*!40000 ALTER TABLE `student_enrollments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `student_groups` -- DROP TABLE IF EXISTS `student_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `student_groups` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `semester_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `updated_at` datetime(3) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `student_groups_semester_id_name_key` (`semester_id`,`name`), CONSTRAINT `student_groups_semester_id_fkey` FOREIGN KEY (`semester_id`) REFERENCES `semesters` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `student_groups` -- LOCK TABLES `student_groups` WRITE; /*!40000 ALTER TABLE `student_groups` DISABLE KEYS */; INSERT INTO `student_groups` VALUES ('8e40c464-1e35-472d-8ef4-af81fc1ccd9b','fb69305f-fbe0-4428-adec-2178e01715fc','Batch A','2026-10-16 12:10:04.361','2026-10-16 12:10:04.361'),('ca358a7b-088d-48aa-a7c6-e41150b69e97','fb69305f-fbe0-4428-adec-2178e01715fc','Batch B','2026-10-16 12:32:47.051','2026-10-16 12:32:47.051'); /*!40000 ALTER TABLE `student_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `student_subject_summaries` -- DROP TABLE IF EXISTS `student_subject_summaries`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `student_subject_summaries` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `student_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `subject_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `semester_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `academic_session_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `theory_conducted_hours` decimal(6,1) NOT NULL DEFAULT '0.0', `theory_present_hours` decimal(6,1) NOT NULL DEFAULT '0.0', `practical_conducted_hours` decimal(6,1) NOT NULL DEFAULT '0.0', `practical_present_hours` decimal(6,1) NOT NULL DEFAULT '0.0', `total_conducted_hours` decimal(6,1) NOT NULL DEFAULT '0.0', `total_present_hours` decimal(6,1) NOT NULL DEFAULT '0.0', `condonation_hours` decimal(6,1) NOT NULL DEFAULT '0.0', `approved_medical_hours` decimal(6,1) NOT NULL DEFAULT '0.0', `attendance_percentage` decimal(5,2) NOT NULL DEFAULT '0.00', `last_calculated_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), PRIMARY KEY (`id`), UNIQUE KEY `student_subject_summaries_student_id_subject_id_academic_ses_key` (`student_id`,`subject_id`,`academic_session_id`), KEY `student_subject_summaries_semester_id_attendance_percentage_idx` (`semester_id`,`attendance_percentage`), KEY `student_subject_summaries_subject_id_fkey` (`subject_id`), KEY `student_subject_summaries_academic_session_id_fkey` (`academic_session_id`), CONSTRAINT `student_subject_summaries_academic_session_id_fkey` FOREIGN KEY (`academic_session_id`) REFERENCES `academic_sessions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `student_subject_summaries_semester_id_fkey` FOREIGN KEY (`semester_id`) REFERENCES `semesters` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `student_subject_summaries_student_id_fkey` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `student_subject_summaries_subject_id_fkey` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `student_subject_summaries` -- LOCK TABLES `student_subject_summaries` WRITE; /*!40000 ALTER TABLE `student_subject_summaries` DISABLE KEYS */; INSERT INTO `student_subject_summaries` VALUES ('57d49b9e-c7fa-439c-ad0f-aeade8330316','ad45f3a0-8f76-489d-8a7d-71902cb1db44','f94445e2-3b73-4f98-a3f3-186950397f2a','fb69305f-fbe0-4428-adec-2178e01715fc','90d47503-54e7-468a-b1a1-871d9c9c8988',0.0,0.0,2.0,2.0,2.0,2.0,0.0,0.3,100.00,'2026-10-17 05:52:07.331'),('ed436729-ac71-4e25-a9f1-651978e8d39d','df6dabb7-1d6c-4237-b48a-9302e9edfba8','f94445e2-3b73-4f98-a3f3-186950397f2a','fb69305f-fbe0-4428-adec-2178e01715fc','90d47503-54e7-468a-b1a1-871d9c9c8988',0.0,0.0,2.0,0.0,2.0,0.0,1.0,0.0,50.00,'2026-10-17 05:52:07.334'); /*!40000 ALTER TABLE `student_subject_summaries` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `students` -- DROP TABLE IF EXISTS `students`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `students` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `semester_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `student_group_id` varchar(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nchmct_roll_no` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `reg_no` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `admission_year` int NOT NULL, `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `updated_at` datetime(3) NOT NULL, `course_id` varchar(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `gender` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `guardian_id` varchar(36) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('ACTIVE','INACTIVE','TRANSFERRED','COMPLETED','DROPPED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ACTIVE', PRIMARY KEY (`id`), UNIQUE KEY `students_user_id_key` (`user_id`), UNIQUE KEY `students_nchmct_roll_no_key` (`nchmct_roll_no`), UNIQUE KEY `students_reg_no_key` (`reg_no`), KEY `students_semester_id_idx` (`semester_id`), KEY `students_student_group_id_idx` (`student_group_id`), KEY `students_course_id_fkey` (`course_id`), KEY `students_guardian_id_fkey` (`guardian_id`), CONSTRAINT `students_course_id_fkey` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `students_guardian_id_fkey` FOREIGN KEY (`guardian_id`) REFERENCES `guardians` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `students_semester_id_fkey` FOREIGN KEY (`semester_id`) REFERENCES `semesters` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE, CONSTRAINT `students_student_group_id_fkey` FOREIGN KEY (`student_group_id`) REFERENCES `student_groups` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `students_user_id_fkey` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `students` -- LOCK TABLES `students` WRITE; /*!40000 ALTER TABLE `students` DISABLE KEYS */; INSERT INTO `students` VALUES ('ad45f3a0-8f76-489d-8a7d-71902cb1db44','37f2fdec-67e6-439b-958d-2ec85e9b1183','fb69305f-fbe0-4428-adec-2178e01715fc','8e40c464-1e35-472d-8ef4-af81fc1ccd9b','NCHM2026001','IHMK-2024-001',2024,'2026-10-16 12:10:05.420','2026-10-17 05:02:41.447','030836fd-4714-4b99-a0c8-9ce4c6813e52','Male','32749d92-2ec9-4279-99d1-a422511c7ca2','ACTIVE'),('d55e8ba9-9cf6-473f-9d13-53a8c34c6b72','a8adb617-861d-4327-926a-2c2414c98705','fb69305f-fbe0-4428-adec-2178e01715fc','ca358a7b-088d-48aa-a7c6-e41150b69e97','NCHM2026101',NULL,2024,'2026-10-16 12:32:47.716','2026-10-16 12:32:47.716','030836fd-4714-4b99-a0c8-9ce4c6813e52','Female',NULL,'ACTIVE'),('df6dabb7-1d6c-4237-b48a-9302e9edfba8','43581dc1-80d4-4de1-997a-bb5f22bbc35c','fb69305f-fbe0-4428-adec-2178e01715fc','8e40c464-1e35-472d-8ef4-af81fc1ccd9b','NCHM2026102',NULL,2024,'2026-10-16 12:32:47.724','2026-10-16 12:32:47.724','030836fd-4714-4b99-a0c8-9ce4c6813e52','Male',NULL,'ACTIVE'); /*!40000 ALTER TABLE `students` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `subjects` -- DROP TABLE IF EXISTS `subjects`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `subjects` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `semester_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `type` enum('THEORY','PRACTICAL','HYBRID') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'THEORY', `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `updated_at` datetime(3) NOT NULL, `credits` int NOT NULL DEFAULT '3', `practical_contact_hours` decimal(4,1) NOT NULL DEFAULT '2.0', `theory_contact_hours` decimal(4,1) NOT NULL DEFAULT '2.0', `total_contact_hours` decimal(5,1) NOT NULL DEFAULT '60.0', `weekly_teaching_hours` decimal(4,1) NOT NULL DEFAULT '4.0', PRIMARY KEY (`id`), UNIQUE KEY `subjects_semester_id_code_key` (`semester_id`,`code`), CONSTRAINT `subjects_semester_id_fkey` FOREIGN KEY (`semester_id`) REFERENCES `semesters` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `subjects` -- LOCK TABLES `subjects` WRITE; /*!40000 ALTER TABLE `subjects` DISABLE KEYS */; INSERT INTO `subjects` VALUES ('f94445e2-3b73-4f98-a3f3-186950397f2a','fb69305f-fbe0-4428-adec-2178e01715fc','BHM301','Advanced Food Production Operations','PRACTICAL','2026-10-16 12:32:47.028','2026-10-16 12:32:47.028',4,4.0,2.0,60.0,6.0); /*!40000 ALTER TABLE `subjects` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `timetables` -- DROP TABLE IF EXISTS `timetables`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `timetables` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `allocation_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `room_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `day_of_week` enum('MONDAY','TUESDAY','WEDNESDAY','THURSDAY','FRIDAY','SATURDAY') COLLATE utf8mb4_unicode_ci NOT NULL, `start_time` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL, `end_time` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL, `planned_hours` decimal(4,1) NOT NULL, `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `updated_at` datetime(3) NOT NULL, PRIMARY KEY (`id`), KEY `timetables_allocation_id_fkey` (`allocation_id`), KEY `timetables_room_id_fkey` (`room_id`), CONSTRAINT `timetables_allocation_id_fkey` FOREIGN KEY (`allocation_id`) REFERENCES `faculty_subject_allocations` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `timetables_room_id_fkey` FOREIGN KEY (`room_id`) REFERENCES `rooms` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `timetables` -- LOCK TABLES `timetables` WRITE; /*!40000 ALTER TABLE `timetables` DISABLE KEYS */; INSERT INTO `timetables` VALUES ('14701dfd-f5ff-40fd-ac09-35b67f0d3cdf','c1a23963-392c-46b7-b1e7-456a0a010ed5','01466f7e-ef78-46ae-8359-a3ed548ba5b6','MONDAY','13:00','14:00',1.0,'2026-10-16 12:39:20.318','2026-10-16 12:39:20.318'),('812033a8-ae3e-4d3d-8177-6fa6a4f969a7','ab995f3e-da2d-4490-9bf0-8ed7a2adbd2c','01466f7e-ef78-46ae-8359-a3ed548ba5b6','MONDAY','09:00','13:00',4.0,'2026-10-16 12:39:20.297','2026-10-16 12:39:20.297'); /*!40000 ALTER TABLE `timetables` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_permissions` -- DROP TABLE IF EXISTS `user_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_permissions` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `permission` enum('USER_VIEW','USER_CREATE','USER_EDIT','USER_DELETE','ACADEMIC_VIEW','ACADEMIC_MANAGE','TIMETABLE_VIEW','TIMETABLE_MANAGE','ATTENDANCE_VIEW','ATTENDANCE_ENTRY','ATTENDANCE_MODIFY','ATTENDANCE_FINALIZE','ATTENDANCE_LOCK','ATTENDANCE_UNLOCK','ATTENDANCE_SUBSTITUTE','ATTENDANCE_RESCHEDULE','ADJUSTMENT_VIEW','ADJUSTMENT_REVIEW','POLICY_VIEW','POLICY_MANAGE','REPORT_VIEW','REPORT_EXPORT','APR_GENERATE','APR_FREEZE','AUDIT_VIEW','SYSTEM_CONFIG','BACKUP_MANAGE') COLLATE utf8mb4_unicode_ci NOT NULL, `granted` tinyint(1) NOT NULL DEFAULT '1', `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), PRIMARY KEY (`id`), UNIQUE KEY `user_permissions_user_id_permission_key` (`user_id`,`permission`), CONSTRAINT `user_permissions_user_id_fkey` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_permissions` -- LOCK TABLES `user_permissions` WRITE; /*!40000 ALTER TABLE `user_permissions` DISABLE KEYS */; /*!40000 ALTER TABLE `user_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `password_hash` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `full_name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL, `phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `role` enum('SUPER_ADMIN','ACADEMIC_ADMIN','HOD','FACULTY','STUDENT','PARENT') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'STUDENT', `status` enum('ACTIVE','INACTIVE','SUSPENDED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ACTIVE', `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `updated_at` datetime(3) NOT NULL, `failed_login_attempts` int NOT NULL DEFAULT '0', `locked_until` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_key` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES ('13f38306-99d7-4068-9899-744e04793548','parent.sharma@example.com','$2b$12$c2K.mhGtQ4SlYfzxKlzPqOt7aWcXFD9D4W6NOEr4DL1gge7nOYno.','Rajesh Sharma (Father)','+91 98765 43210','PARENT','ACTIVE','2026-10-17 05:02:41.433','2026-10-17 05:02:41.433',0,NULL),('37f2fdec-67e6-439b-958d-2ec85e9b1183','student.kolkata@ihm.ac.in','$2b$12$OHDyTetJd0X1tsvQlsCiMOISSkxcfu0kZ/h5VwbggbssVHloVdp72','Aarav Sharma','+91 98765 00004','STUDENT','ACTIVE','2026-10-16 12:10:05.414','2026-10-16 12:10:05.414',0,NULL),('43581dc1-80d4-4de1-997a-bb5f22bbc35c','debojyoti.g@ihm.ac.in','$2b$12$25IcplLgjGgQ1vdBTGRjYO3Xl0yiLyf9BfowC7AL4gpMNgjWiwKKK','Debojyoti Ghosh','+91 98300 22222','STUDENT','ACTIVE','2026-10-16 12:32:47.723','2026-10-16 12:32:47.723',0,NULL),('592860dd-8039-486e-a86e-e366de3b70df','vikrant.roy@ihm.ac.in','$2b$12$1VksBfFjuIwJEiBVMwNBK.UvLJWI.Dkhuhjf0fIvDAti6JhV1DTDO','Chef Vikrant Roy',NULL,'FACULTY','ACTIVE','2026-10-16 12:32:47.352','2026-10-16 12:32:47.352',0,NULL),('a8adb617-861d-4327-926a-2c2414c98705','pooja.c@ihm.ac.in','$2b$12$25IcplLgjGgQ1vdBTGRjYO3Xl0yiLyf9BfowC7AL4gpMNgjWiwKKK','Pooja Chatterjee','+91 98300 11111','STUDENT','ACTIVE','2026-10-16 12:32:47.713','2026-10-16 12:32:47.713',0,NULL),('d2e9d278-5d54-43fc-b106-6f5d1465c70f','faculty.chef@ihm.ac.in','$2b$12$Jr8yRSX4eyy4Zk0SEkdEB.gDUmkEP1TQZ6iyZ6PmVT/oWrYcKucdS','Chef Sanjeev Kumar','+91 98765 00003','FACULTY','ACTIVE','2026-10-16 12:10:05.151','2026-10-16 12:10:05.151',0,NULL),('ea2d8b70-ca66-4b4f-bf25-595db63689ed','superadmin@ihm.com','$2b$12$geT0LuOs5yR2NBLf4MUaqugdQArYjLrPcJN8AYTJSJJUE1uoBQUNS','Super Administrator','+91 98765 00001','SUPER_ADMIN','ACTIVE','2026-10-16 12:10:04.627','2026-10-17 10:55:17.696',0,NULL),('f898fcaf-05a5-43ab-9b9f-f95baef8efd7','academic@ihm.ac.in','$2b$12$e4z08qlbvWYrCCwFj9MFOevbSR1ksOq8oncAUgUGgwwIZrcD/KS2G','Academic In-Charge','+91 98765 00002','ACADEMIC_ADMIN','ACTIVE','2026-10-16 12:10:04.889','2026-10-17 05:51:16.780',0,NULL),('fdbdc344-e62e-40c5-bab1-e3554fa3a7fc','duplicate_test_trigger@ihm.ac.in','$2b$12$j6Aazta7sHNZq8cKF1EKfecdEtT7ZzlwD5nulYsGj/.PZMZ45l0zi','Test Trigger User',NULL,'STUDENT','ACTIVE','2026-10-16 12:02:23.169','2026-10-17 10:55:20.434',0,NULL); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-10-23 10:30:32