
--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2024_11_04_055718_create_titles_table',2),(5,'2024_11_04_055727_create_countries_table',2),(6,'2024_11_04_065457_create_fetp_statuses_table',3),(7,'2024_11_04_065505_create_fetp_tiers_table',3),(9,'2024_11_04_070258_create_workshops_table',4),(12,'2024_11_05_140637_create_sub_themes_table',6),(13,'2024_11_05_093523_create_submit_abstracts_table',7),(14,'0001_01_01_000000_create_users_table',1),(16,'2024_11_05_093542_create_confirms_table',8),(17,'2024_11_06_113907_create_permission_tables',8),(18,'2024_11_07_064833_create_notifications_table',9),(19,'2024_12_03_120344_create_deadlines_table',10),(20,'2024_12_14_132119_create_review_criterias_table',11),(21,'2024_12_14_132204_create_reviews_table',12),(23,'2024_12_06_165359_create_abstract_assignments_table',13);

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--


--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\User',4),(2,'App\\Models\\User',5),(2,'App\\Models\\User',7),(4,'App\\Models\\User',8),(3,'App\\Models\\User',9),(2,'App\\Models\\User',10),(4,'App\\Models\\User',10),(3,'App\\Models\\User',11),(3,'App\\Models\\User',12),(4,'App\\Models\\User',13),(4,'App\\Models\\User',14),(2,'App\\Models\\User',15),(2,'App\\Models\\User',16),(2,'App\\Models\\User',17),(2,'App\\Models\\User',18),(1,'App\\Models\\User',19),(4,'App\\Models\\User',20),(2,'App\\Models\\User',21),(2,'App\\Models\\User',22),(2,'App\\Models\\User',23),(4,'App\\Models\\User',24),(2,'App\\Models\\User',25),(2,'App\\Models\\User',26),(2,'App\\Models\\User',27),(2,'App\\Models\\User',28),(2,'App\\Models\\User',29),(2,'App\\Models\\User',30),(2,'App\\Models\\User',31),(2,'App\\Models\\User',32),(2,'App\\Models\\User',33),(2,'App\\Models\\User',34),(2,'App\\Models\\User',35),(2,'App\\Models\\User',36),(2,'App\\Models\\User',37),(2,'App\\Models\\User',38),(2,'App\\Models\\User',39),(2,'App\\Models\\User',40),(2,'App\\Models\\User',41),(2,'App\\Models\\User',42),(2,'App\\Models\\User',43),(2,'App\\Models\\User',44),(2,'App\\Models\\User',45),(2,'App\\Models\\User',46),(2,'App\\Models\\User',47),(2,'App\\Models\\User',48),(2,'App\\Models\\User',49),(2,'App\\Models\\User',50),(2,'App\\Models\\User',51),(2,'App\\Models\\User',52),(2,'App\\Models\\User',53),(2,'App\\Models\\User',54),(2,'App\\Models\\User',55),(2,'App\\Models\\User',56),(2,'App\\Models\\User',57),(2,'App\\Models\\User',58),(2,'App\\Models\\User',59),(2,'App\\Models\\User',60),(2,'App\\Models\\User',61),(2,'App\\Models\\User',62),(2,'App\\Models\\User',63),(2,'App\\Models\\User',64),(2,'App\\Models\\User',65),(4,'App\\Models\\User',66),(2,'App\\Models\\User',67),(2,'App\\Models\\User',68),(2,'App\\Models\\User',69),(2,'App\\Models\\User',70),(2,'App\\Models\\User',71),(2,'App\\Models\\User',72),(2,'App\\Models\\User',73),(2,'App\\Models\\User',74),(2,'App\\Models\\User',75),(2,'App\\Models\\User',76),(2,'App\\Models\\User',77),(2,'App\\Models\\User',78),(2,'App\\Models\\User',79),(2,'App\\Models\\User',80),(2,'App\\Models\\User',81),(2,'App\\Models\\User',82),(2,'App\\Models\\User',83),(2,'App\\Models\\User',84),(2,'App\\Models\\User',85),(2,'App\\Models\\User',86),(2,'App\\Models\\User',87),(2,'App\\Models\\User',88),(2,'App\\Models\\User',89),(2,'App\\Models\\User',90),(2,'App\\Models\\User',91),(2,'App\\Models\\User',92),(2,'App\\Models\\User',93),(2,'App\\Models\\User',94),(2,'App\\Models\\User',95),(2,'App\\Models\\User',96),(2,'App\\Models\\User',97),(2,'App\\Models\\User',98),(2,'App\\Models\\User',99),(2,'App\\Models\\User',100),(4,'App\\Models\\User',101),(2,'App\\Models\\User',102),(2,'App\\Models\\User',103),(2,'App\\Models\\User',104),(2,'App\\Models\\User',105),(2,'App\\Models\\User',106),(2,'App\\Models\\User',107),(2,'App\\Models\\User',108),(2,'App\\Models\\User',109),(2,'App\\Models\\User',110),(2,'App\\Models\\User',111),(2,'App\\Models\\User',112),(2,'App\\Models\\User',113),(2,'App\\Models\\User',114),(2,'App\\Models\\User',115),(2,'App\\Models\\User',116),(2,'App\\Models\\User',117),(2,'App\\Models\\User',118),(2,'App\\Models\\User',119),(2,'App\\Models\\User',120),(4,'App\\Models\\User',121),(4,'App\\Models\\User',122),(4,'App\\Models\\User',123),(4,'App\\Models\\User',126),(4,'App\\Models\\User',131),(4,'App\\Models\\User',132),(4,'App\\Models\\User',134),(4,'App\\Models\\User',135),(4,'App\\Models\\User',136),(4,'App\\Models\\User',137),(4,'App\\Models\\User',138),(4,'App\\Models\\User',139),(4,'App\\Models\\User',140),(4,'App\\Models\\User',141),(4,'App\\Models\\User',142),(4,'App\\Models\\User',143),(4,'App\\Models\\User',144),(4,'App\\Models\\User',145),(4,'App\\Models\\User',147),(4,'App\\Models\\User',148),(4,'App\\Models\\User',149),(4,'App\\Models\\User',150),(4,'App\\Models\\User',151),(4,'App\\Models\\User',152),(4,'App\\Models\\User',153),(4,'App\\Models\\User',154),(4,'App\\Models\\User',155),(4,'App\\Models\\User',156),(4,'App\\Models\\User',157),(4,'App\\Models\\User',158),(4,'App\\Models\\User',159),(4,'App\\Models\\User',160),(4,'App\\Models\\User',161),(4,'App\\Models\\User',162),(4,'App\\Models\\User',163),(4,'App\\Models\\User',164),(4,'App\\Models\\User',165),(4,'App\\Models\\User',166),(4,'App\\Models\\User',167),(4,'App\\Models\\User',168),(4,'App\\Models\\User',169),(4,'App\\Models\\User',170),(4,'App\\Models\\User',171),(4,'App\\Models\\User',172),(4,'App\\Models\\User',173),(4,'App\\Models\\User',174),(4,'App\\Models\\User',175);

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_id` bigint unsigned NOT NULL,
  `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` VALUES ('03a4fa88-3fe6-4491-b478-df472d7cd052','Filament\\Notifications\\DatabaseNotification','App\\Models\\User',4,'{\"actions\":[{\"name\":\"markAsUnread\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as unread\",\"shouldClose\":false,\"shouldMarkAsRead\":false,\"shouldMarkAsUnread\":true,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"},{\"name\":\"markAsRead\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as read\",\"shouldClose\":false,\"shouldMarkAsRead\":true,\"shouldMarkAsUnread\":false,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"}],\"body\":\"Please note: An Abstract with the following details has been created: \\n                **Abstract Name:** <p>Health care workers knowledge, perceptions and attitudes towards Coronavirus Disease 19 prevention and control during the pandemic in Tigray, Ethiopia<\\/p>\\n                **Track:** Maternal, Reproductive, and Child Health\\n                **Author:** Munir Makumbi\\n                **Date Submitted:** 2024-11-07 07:40:00\",\"color\":null,\"duration\":\"persistent\",\"icon\":\"heroicon-o-clipboard-document-check\",\"iconColor\":\"success\",\"status\":\"success\",\"title\":\"An Abstract titled \'<p>Health care workers knowledge, perceptions and attitudes towards Coronavirus Disease 19 prevention and control during the pandemic in Tigray, Ethiopia<\\/p>\' has been Edited\",\"view\":\"filament-notifications::notification\",\"viewData\":[],\"format\":\"filament\"}',NULL,'2024-11-07 04:56:54','2024-11-07 04:56:54'),('20f0bbab-a29f-4953-b8d0-6390fa2c27d0','Filament\\Notifications\\DatabaseNotification','App\\Models\\User',4,'{\"actions\":[{\"name\":\"markAsUnread\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as unread\",\"shouldClose\":false,\"shouldMarkAsRead\":false,\"shouldMarkAsUnread\":true,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"},{\"name\":\"markAsRead\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as read\",\"shouldClose\":false,\"shouldMarkAsRead\":true,\"shouldMarkAsUnread\":false,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"}],\"body\":\"Please note: A country with the following details has been Edited: \\n                    Country Name:\'Oman.\', Country Code:\'OMN\', Dialing Code:\'+968\'.\",\"color\":null,\"duration\":\"persistent\",\"icon\":\"heroicon-o-clipboard-document-check\",\"iconColor\":\"success\",\"status\":\"success\",\"title\":\"Counntry \'Oman.\' has been created\",\"view\":\"filament-notifications::notification\",\"viewData\":[],\"format\":\"filament\"}',NULL,'2024-11-07 04:24:24','2024-11-07 04:24:24'),('476dc31b-6ab9-43c3-9d74-9419f064d1db','Filament\\Notifications\\DatabaseNotification','App\\Models\\User',19,'{\"actions\":[{\"name\":\"markAsUnread\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as unread\",\"shouldClose\":false,\"shouldMarkAsRead\":false,\"shouldMarkAsUnread\":true,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"},{\"name\":\"markAsRead\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as read\",\"shouldClose\":false,\"shouldMarkAsRead\":true,\"shouldMarkAsUnread\":false,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"}],\"body\":\"Please note: An Abstract with the following details has been created: \\n                    Name:<p>Communications in EFETP<\\/p>, Track:Communication & Technological Innovations for Public Health, Auther:Adamu Addissie on 2024-11-16 08:11:37.\",\"color\":null,\"duration\":\"persistent\",\"icon\":\"heroicon-o-clipboard-document-check\",\"iconColor\":\"success\",\"status\":\"success\",\"title\":\"An Abstract titled \'<p>Communications in EFETP<\\/p>\' has been created\",\"view\":\"filament-notifications::notification\",\"viewData\":[],\"format\":\"filament\"}',NULL,'2024-11-18 13:31:45','2024-11-18 13:31:45'),('4a87a7f2-d2e1-4924-93b7-3f36d7fdbf96','Filament\\Notifications\\DatabaseNotification','App\\Models\\User',19,'{\"actions\":[{\"name\":\"markAsUnread\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as unread\",\"shouldClose\":false,\"shouldMarkAsRead\":false,\"shouldMarkAsUnread\":true,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"},{\"name\":\"markAsRead\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as read\",\"shouldClose\":false,\"shouldMarkAsRead\":true,\"shouldMarkAsUnread\":false,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"}],\"body\":\"Please note: An Abstract with the following details has been created: \\n                    Name:<p>NCDs Surveillance in Ethiopia&nbsp;<\\/p>, Track:Non-communicable Diseases (NCDs), Injuries & Mental Health, Auther:Adamu Addissie on 2024-11-16 08:29:34.\",\"color\":null,\"duration\":\"persistent\",\"icon\":\"heroicon-o-clipboard-document-check\",\"iconColor\":\"success\",\"status\":\"success\",\"title\":\"An Abstract titled \'<p>NCDs Surveillance in Ethiopia&nbsp;<\\/p>\' has been created\",\"view\":\"filament-notifications::notification\",\"viewData\":[],\"format\":\"filament\"}',NULL,'2024-11-18 13:31:45','2024-11-18 13:31:45'),('4cb41108-ef05-4ec5-af8a-f79717307a08','Filament\\Notifications\\DatabaseNotification','App\\Models\\User',4,'{\"actions\":[{\"name\":\"markAsUnread\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as unread\",\"shouldClose\":false,\"shouldMarkAsRead\":false,\"shouldMarkAsUnread\":true,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"},{\"name\":\"markAsRead\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as read\",\"shouldClose\":false,\"shouldMarkAsRead\":true,\"shouldMarkAsUnread\":false,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"}],\"body\":\"Please note: A country with the following details has been Edited: \\n                    Country Name:\'Oman.\', Country Code:\'OMN\', Dialing Code:\'+999\'.\",\"color\":null,\"duration\":\"persistent\",\"icon\":\"heroicon-o-clipboard-document-check\",\"iconColor\":\"success\",\"status\":\"success\",\"title\":\"Counntry \'Oman.\' has been created\",\"view\":\"filament-notifications::notification\",\"viewData\":[],\"format\":\"filament\"}',NULL,'2024-11-07 04:23:51','2024-11-07 04:23:51'),('54363c69-70af-4c3c-83ef-88e1a17f4ffd','Filament\\Notifications\\DatabaseNotification','App\\Models\\User',4,'{\"actions\":[{\"name\":\"markAsUnread\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as unread\",\"shouldClose\":false,\"shouldMarkAsRead\":false,\"shouldMarkAsUnread\":true,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"},{\"name\":\"markAsRead\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as read\",\"shouldClose\":false,\"shouldMarkAsRead\":true,\"shouldMarkAsUnread\":false,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"}],\"body\":\"Please note: An Abstract with the following details has been created: \\n                    Name:<p>Health care workers knowledge, perceptions and attitudes towards Coronavirus Disease 19 prevention and control during the pandemic in Tigray, Ethiopia<\\/p>, Track:Maternal, Reproductive, and Child Health, Auther:Munir Makumbi on 2024-11-07 07:40:00.\",\"color\":null,\"duration\":\"persistent\",\"icon\":\"heroicon-o-clipboard-document-check\",\"iconColor\":\"success\",\"status\":\"success\",\"title\":\"An Abstract titled \'<p>Health care workers knowledge, perceptions and attitudes towards Coronavirus Disease 19 prevention and control during the pandemic in Tigray, Ethiopia<\\/p>\' has been Edited\",\"view\":\"filament-notifications::notification\",\"viewData\":[],\"format\":\"filament\"}',NULL,'2024-11-07 04:50:15','2024-11-07 04:50:15'),('54ef2a74-7ca4-4a97-b0c4-30a0a78fa9ff','Filament\\Notifications\\DatabaseNotification','App\\Models\\User',4,'{\"actions\":[{\"name\":\"markAsUnread\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as unread\",\"shouldClose\":false,\"shouldMarkAsRead\":false,\"shouldMarkAsUnread\":true,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"},{\"name\":\"markAsRead\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as read\",\"shouldClose\":false,\"shouldMarkAsRead\":true,\"shouldMarkAsUnread\":false,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"}],\"body\":\"Please note: An Abstract with the following details has been created: \\n                    Name:\'<p>y<\\/p>\', Track:\'One Health and Climate Change\', Auther:\'Munir\' \'Makumbi\' on \'\'.\",\"color\":null,\"duration\":\"persistent\",\"icon\":\"heroicon-o-clipboard-document-check\",\"iconColor\":\"success\",\"status\":\"success\",\"title\":\"An Abstract titled \'<p>y<\\/p>\' has been created\",\"view\":\"filament-notifications::notification\",\"viewData\":[],\"format\":\"filament\"}',NULL,'2024-11-07 04:45:50','2024-11-07 04:45:50'),('558ac631-b351-4e24-a71a-dfafd2c2dd62','Filament\\Notifications\\DatabaseNotification','App\\Models\\User',11,'{\"actions\":[{\"name\":\"markAsUnread\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as unread\",\"shouldClose\":false,\"shouldMarkAsRead\":false,\"shouldMarkAsUnread\":true,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"},{\"name\":\"markAsRead\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as read\",\"shouldClose\":false,\"shouldMarkAsRead\":true,\"shouldMarkAsUnread\":false,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"}],\"body\":\"Please note: An Abstract with the following details has been created: \\n                    Name:<p>Communications in EFETP<\\/p>, Track:Communication & Technological Innovations for Public Health, Auther:Adamu Addissie on 2024-11-16 08:11:37.\",\"color\":null,\"duration\":\"persistent\",\"icon\":\"heroicon-o-clipboard-document-check\",\"iconColor\":\"success\",\"status\":\"success\",\"title\":\"An Abstract titled \'<p>Communications in EFETP<\\/p>\' has been created\",\"view\":\"filament-notifications::notification\",\"viewData\":[],\"format\":\"filament\"}',NULL,'2024-11-18 13:31:45','2024-11-18 13:31:45'),('aaa8c571-d561-4d53-a930-00a1d9a8d581','Filament\\Notifications\\DatabaseNotification','App\\Models\\User',4,'{\"actions\":[{\"name\":\"markAsUnread\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as unread\",\"shouldClose\":false,\"shouldMarkAsRead\":false,\"shouldMarkAsUnread\":true,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"},{\"name\":\"markAsRead\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as read\",\"shouldClose\":false,\"shouldMarkAsRead\":true,\"shouldMarkAsUnread\":false,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"}],\"body\":\"Please note: A country with the following details has been created: \\n                    Country Name:\'Oman\', Country Code:\'OMN\', Dialing Code:\'+968\'.\",\"color\":null,\"duration\":\"persistent\",\"icon\":\"heroicon-o-clipboard-document-check\",\"iconColor\":\"success\",\"status\":\"success\",\"title\":\"Counntry \'Oman\' has been created\",\"view\":\"filament-notifications::notification\",\"viewData\":[],\"format\":\"filament\"}',NULL,'2024-11-07 04:17:12','2024-11-07 04:17:12'),('b4f9cfdd-11eb-40b7-a7e2-bc83a791a787','Filament\\Notifications\\DatabaseNotification','App\\Models\\User',11,'{\"actions\":[{\"name\":\"markAsUnread\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as unread\",\"shouldClose\":false,\"shouldMarkAsRead\":false,\"shouldMarkAsUnread\":true,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"},{\"name\":\"markAsRead\",\"color\":null,\"event\":null,\"eventData\":[],\"dispatchDirection\":false,\"dispatchToComponent\":null,\"extraAttributes\":[],\"icon\":null,\"iconPosition\":\"before\",\"iconSize\":null,\"isOutlined\":false,\"isDisabled\":false,\"label\":\"Mark as read\",\"shouldClose\":false,\"shouldMarkAsRead\":true,\"shouldMarkAsUnread\":false,\"shouldOpenUrlInNewTab\":false,\"size\":\"sm\",\"tooltip\":null,\"url\":null,\"view\":\"filament-actions::button-action\"}],\"body\":\"Please note: An Abstract with the following details has been created: \\n                    Name:<p>NCDs Surveillance in Ethiopia&nbsp;<\\/p>, Track:Non-communicable Diseases (NCDs), Injuries & Mental Health, Auther:Adamu Addissie on 2024-11-16 08:29:34.\",\"color\":null,\"duration\":\"persistent\",\"icon\":\"heroicon-o-clipboard-document-check\",\"iconColor\":\"success\",\"status\":\"success\",\"title\":\"An Abstract titled \'<p>NCDs Surveillance in Ethiopia&nbsp;<\\/p>\' has been created\",\"view\":\"filament-notifications::notification\",\"viewData\":[],\"format\":\"filament\"}',NULL,'2024-11-18 13:31:45','2024-11-18 13:31:45');

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (1,'view_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(2,'view_any_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(3,'create_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(4,'update_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(5,'restore_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(6,'restore_any_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(7,'replicate_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(8,'reorder_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(9,'delete_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(10,'delete_any_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(11,'force_delete_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(12,'force_delete_any_country','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(13,'view_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(14,'view_any_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(15,'create_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(16,'update_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(17,'restore_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(18,'restore_any_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(19,'replicate_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(20,'reorder_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(21,'delete_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(22,'delete_any_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(23,'force_delete_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(24,'force_delete_any_fetp::status','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(25,'view_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(26,'view_any_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(27,'create_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(28,'update_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(29,'restore_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(30,'restore_any_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(31,'replicate_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(32,'reorder_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(33,'delete_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(34,'delete_any_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(35,'force_delete_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(36,'force_delete_any_fetp::tier','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(37,'view_role','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(38,'view_any_role','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(39,'create_role','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(40,'update_role','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(41,'delete_role','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(42,'delete_any_role','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(43,'view_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(44,'view_any_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(45,'create_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(46,'update_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(47,'restore_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(48,'restore_any_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(49,'replicate_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(50,'reorder_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(51,'delete_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(52,'delete_any_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(53,'force_delete_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(54,'force_delete_any_sub::theme','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(55,'view_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(56,'view_any_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(57,'create_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(58,'update_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(59,'restore_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(60,'restore_any_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(61,'replicate_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(62,'reorder_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(63,'delete_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(64,'delete_any_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(65,'force_delete_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(66,'force_delete_any_submit::abstract','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(67,'view_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(68,'view_any_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(69,'create_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(70,'update_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(71,'restore_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(72,'restore_any_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(73,'replicate_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(74,'reorder_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(75,'delete_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(76,'delete_any_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(77,'force_delete_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(78,'force_delete_any_title','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(79,'view_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(80,'view_any_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(81,'create_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(82,'update_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(83,'restore_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(84,'restore_any_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(85,'replicate_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(86,'reorder_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(87,'delete_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(88,'delete_any_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(89,'force_delete_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(90,'force_delete_any_workshop','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(91,'page_MyProfilePage','web','2024-11-06 08:41:48','2024-11-06 08:41:48'),(92,'view_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(93,'view_any_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(94,'create_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(95,'update_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(96,'restore_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(97,'restore_any_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(98,'replicate_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(99,'reorder_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(100,'delete_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(101,'delete_any_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(102,'force_delete_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(103,'force_delete_any_user','web','2024-11-06 08:53:43','2024-11-06 08:53:43'),(104,'view_notification','web','2024-11-07 05:21:39','2024-11-07 05:21:39'),(105,'view_any_notification','web','2024-11-07 05:21:39','2024-11-07 05:21:39'),(106,'widget_StatsOverview','web','2024-11-18 13:29:18','2024-11-18 13:29:18'),(107,'widget_AbstractsButtonWidget','web','2024-11-18 13:29:18','2024-11-18 13:29:18'),(108,'widget_AccordionWidget','web','2024-11-18 13:29:18','2024-11-18 13:29:18'),(109,'view_review::criteria','web','2024-12-22 10:58:50','2024-12-22 10:58:50'),(110,'view_any_review::criteria','web','2024-12-22 10:58:50','2024-12-22 10:58:50'),(111,'create_review::criteria','web','2024-12-22 10:58:50','2024-12-22 10:58:50'),(112,'update_review::criteria','web','2024-12-22 10:58:50','2024-12-22 10:58:50'),(113,'restore_review::criteria','web','2024-12-22 10:58:50','2024-12-22 10:58:50'),(114,'restore_any_review::criteria','web','2024-12-22 10:58:50','2024-12-22 10:58:50'),(115,'replicate_review::criteria','web','2024-12-22 10:58:50','2024-12-22 10:58:50'),(116,'reorder_review::criteria','web','2024-12-22 10:58:50','2024-12-22 10:58:50'),(117,'delete_review::criteria','web','2024-12-22 10:58:50','2024-12-22 10:58:50'),(118,'delete_any_review::criteria','web','2024-12-22 10:58:50','2024-12-22 10:58:50'),(119,'force_delete_review::criteria','web','2024-12-22 10:58:50','2024-12-22 10:58:50'),(120,'force_delete_any_review::criteria','web','2024-12-22 10:58:50','2024-12-22 10:58:50'),(121,'view_abstract::assignment','web','2024-12-22 10:59:19','2024-12-22 10:59:19'),(122,'view_any_abstract::assignment','web','2024-12-22 10:59:19','2024-12-22 10:59:19'),(123,'create_abstract::assignment','web','2024-12-22 10:59:19','2024-12-22 10:59:19'),(124,'update_abstract::assignment','web','2024-12-22 10:59:19','2024-12-22 10:59:19'),(125,'restore_abstract::assignment','web','2024-12-22 10:59:19','2024-12-22 10:59:19'),(126,'restore_any_abstract::assignment','web','2024-12-22 10:59:19','2024-12-22 10:59:19'),(127,'replicate_abstract::assignment','web','2024-12-22 10:59:19','2024-12-22 10:59:19'),(128,'reorder_abstract::assignment','web','2024-12-22 10:59:19','2024-12-22 10:59:19'),(129,'delete_abstract::assignment','web','2024-12-22 10:59:19','2024-12-22 10:59:19'),(130,'delete_any_abstract::assignment','web','2024-12-22 10:59:19','2024-12-22 10:59:19'),(131,'force_delete_abstract::assignment','web','2024-12-22 10:59:19','2024-12-22 10:59:19'),(132,'force_delete_any_abstract::assignment','web','2024-12-22 10:59:19','2024-12-22 10:59:19'),(133,'view_deadline','web','2024-12-22 10:59:28','2024-12-22 10:59:28'),(134,'view_any_deadline','web','2024-12-22 10:59:28','2024-12-22 10:59:28'),(135,'create_deadline','web','2024-12-22 10:59:28','2024-12-22 10:59:28'),(136,'update_deadline','web','2024-12-22 10:59:28','2024-12-22 10:59:28'),(137,'restore_deadline','web','2024-12-22 10:59:28','2024-12-22 10:59:28'),(138,'restore_any_deadline','web','2024-12-22 10:59:28','2024-12-22 10:59:28'),(139,'replicate_deadline','web','2024-12-22 10:59:28','2024-12-22 10:59:28'),(140,'reorder_deadline','web','2024-12-22 10:59:28','2024-12-22 10:59:28'),(141,'delete_deadline','web','2024-12-22 10:59:28','2024-12-22 10:59:28'),(142,'delete_any_deadline','web','2024-12-22 10:59:28','2024-12-22 10:59:28'),(143,'force_delete_deadline','web','2024-12-22 10:59:28','2024-12-22 10:59:28'),(144,'force_delete_any_deadline','web','2024-12-22 10:59:28','2024-12-22 10:59:28'),(145,'view_review','web','2024-12-22 11:01:20','2024-12-22 11:01:20'),(146,'view_any_review','web','2024-12-22 11:01:20','2024-12-22 11:01:20'),(147,'create_review','web','2024-12-22 11:01:20','2024-12-22 11:01:20'),(148,'update_review','web','2024-12-22 11:01:20','2024-12-22 11:01:20');

--
-- Table structure for table `review_criterias`
--

CREATE TABLE `review_criterias` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `max_score` int NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `review_criterias`
--


--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `abstract_id` bigint unsigned NOT NULL,
  `reviewer_id` bigint unsigned NOT NULL,
  `status` enum('draft','submitted') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `submitted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `originality_score` int DEFAULT NULL,
  `originality_comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `clinical_relevance_score` int DEFAULT NULL,
  `clinical_relevance_comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `methodology_score` int DEFAULT NULL,
  `methodology_comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `presentation_score` int DEFAULT NULL,
  `presentation_comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `feasibility_score` int DEFAULT NULL,
  `feasibility_comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `overall_clarity_score` int DEFAULT NULL,
  `overall_clarity_comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reviews`
--

INSERT INTO `reviews` VALUES (2,19,8,'submitted',NULL,'2024-12-28 11:55:05','2024-12-28 11:55:05',5,'N/A',5,'N/A',5,'N/A',4,'N/A',5,'N/A',5,NULL),(3,16,20,'submitted',NULL,'2024-12-28 22:52:50','2024-12-28 22:52:50',3,'N/A',5,'N/A',3,'N/A',5,'N/A',4,'N/A',5,NULL),(4,29,20,'submitted',NULL,'2024-12-28 22:53:46','2024-12-28 22:53:46',4,'N/A',5,'N/A',5,'N/A',5,'N/A',5,'N/A',5,NULL),(5,20,150,'submitted',NULL,'2024-12-30 09:44:28','2024-12-30 09:44:28',3,'N/A',3,'N/A',2,'N/A',2,'N/A',3,'N/A',3,NULL),(6,38,150,'submitted',NULL,'2024-12-30 09:46:28','2024-12-30 09:46:28',3,'N/A',3,'N/A',3,'N/A',3,'N/A',3,'N/A',2,NULL),(7,54,150,'submitted',NULL,'2024-12-30 09:47:44','2024-12-30 09:47:44',3,'N/A',4,'N/A',4,'N/A',3,'N/A',4,'N/A',3,NULL),(8,75,150,'submitted',NULL,'2024-12-30 09:48:47','2024-12-30 09:48:47',2,'N/A',3,'N/A',3,'N/A',2,'N/A',4,'N/A',2,NULL),(9,94,150,'submitted',NULL,'2024-12-30 09:49:42','2024-12-30 09:49:42',3,'N/A',3,'N/A',3,'N/A',3,'N/A',3,'N/A',3,NULL),(10,22,149,'submitted',NULL,'2024-12-30 10:23:51','2024-12-30 10:23:51',4,'Objectives for addressing the problem not sufficiently described ',3,'No case definitions, statistical measures inadequately described ',4,'N/A',4,'N/A',4,'N/A',4,NULL),(11,14,123,'submitted',NULL,'2024-12-30 17:21:05','2024-12-30 17:21:05',2,'The Background should cover the importance of the disease and why surveillance for it matters in Ethiopia. It is not necessary to give a textbook definition of surveillance, but instead the author should think about WHY this particular system needs to be evaluated here and now. What is it about measles in Ethiopia that makes it important to have a surveillance system? Why was the system developed? What concerns are there about the data quality or use? Why Chena?',2,'Not adequately described. What characteristics were evaluated? How were data collected? Who was interviewed or what records were used?',2,'While a few details about the system are presented, it\'s not clear if they address the objectives. Does the system meet its objectives? It\'s not possible to tell. There needs to be a more close mapping between the Methods and the Results.',0,'The conclusion should be an interpretation of the meaning of the results as they apply to the objective, not additional results. Ideally, the conclusion would tell us whether or not the surveillance system meets its objectives, based on the results presented in the abstract.',1,'This could have been a useful study but the abstract is not making it possible to tell.',1,NULL),(12,30,123,'submitted',NULL,'2024-12-30 17:35:26','2024-12-30 17:35:26',3,'It would have been nice to see information in the background about Strep pyogenes. The reader may know nothing about it. Even though the investigators did not know what was causing the outbreak in the beginning, it\'s still ok to provide info about the pathogen and where it\'s found, who it affects. There is no description of the lesions at all that helps the reader understand how the investigators started to make guesses about the pathogen.',4,'Very nice methods. I would have liked to see information about what the swabs were tested for and where they were tested.',3,'It is not clear how they knew that S. pyogenes (please check your spelling!) was the causative agent. Was 1/11 samples positive? 11/11? Some more information on patient symptoms is needed. In addition, it is not clear that cases were different ages than the controls. Since it was unmatched, I assume that controls were selected randomly. As age is not shown as a risk factor, the conclusion that it disproportionately affected young people is not substantiated.',2,'See comments above. However, I would also like the authors to answer: why did this outbreak happen here and now? What changed that made this outbreak happen during this time period and in this place? Presumably people have been living under the same conditions for many years. So why did this happen?',4,'N/A',5,NULL),(13,51,123,'submitted',NULL,'2024-12-30 17:43:25','2024-12-30 17:43:25',4,'The background is fairly good but it should be noted that surveillance is not an intervention. It is a tool to assess trends and disease burden.',5,'N/A',3,'It is clear from the Results that the cases are increasing. However, the reader doesn\'t know the geography of this area. Is Bahr Zur district one of two districts? One of ten? If Bahr Zur district has 25% of the population, then we would expect them to have 25% of the malaria cases. This needs to be clear.  It also would have been nice to see the proportion of cases <5 years for each year. In my experience, 14% being <5 years is very low! Usually most of the cases are <5 years. ',3,'What does \'it occurs in the form of outbreak\' mean? How is this defined here? I think this is not a good use of the words in the abstract. ',4,'N/A',4,NULL),(14,65,123,'submitted',NULL,'2024-12-30 17:59:07','2024-12-30 17:59:07',5,NULL,4,'Where and when was this study carried out? Where were women enrolled?',4,'It was not clear which direction the \'husband education\' and \'maternal decision-making autonomy\' was associated with stunting at birth.',1,'The conclusions are a repetition of results. The purpose of the Conclusion section is to interpret the results, not repeat them. What do the results mean, taken together? Why are they important and what recommendations should be made?',4,'N/A',4,NULL),(15,84,123,'submitted',NULL,'2024-12-30 18:02:11','2024-12-30 18:02:11',5,'Very nice background.',5,'Well done.',4,'I would have liked to see some demographic information about cases.',3,'The conclusions just repeat the results. What should be taken from this? Is this new information on chronic kidney disease? The concluding sentence is not clear.',4,'N/A',4,NULL),(16,103,123,'submitted',NULL,'2024-12-30 18:05:02','2024-12-30 18:05:02',5,'N/A',5,'N/A',4,'What does \'not knowledgeable mothers\' mean here? This could be explained in the Methods.',4,'The conclusions start by repeating the results. This is not necessary. ',4,'N/A',5,NULL),(17,24,153,'submitted',NULL,'2024-12-30 19:04:55','2024-12-30 19:04:55',3,'The study issue is among the priority health problems in the Region. However, the title and background and the rationale didn\'t explicitly describe the reason for comparison of adherence among public and private health facilities, which is the main focus of the study.\nThe objectives are not also indicated in the title.',3,'Most of the issues in the methods sections are touched. But, the way how the sample size is calculated, the study units in each stage of sampling are selected, the outcome variable (adherence) is measured are not clearly described.',4,'It is relatively good.\nStill it needs recommended method of writing proportions and AORs with their 95%CIs: estimate (95%CI: lower bound - upper bound).\nIt is also better to indicate the direction of association and keep the consistency of decimals.',2,'The conclusion is not directly based on the results.\nHow much was the standard of adherence to the national malarial case management guideline is not indicated.\nThe need of comparison is not concluded based on the finding.',2,'The Recommendations are not based on the objective and results of the finding.',3,NULL),(18,18,134,'submitted',NULL,'2024-12-30 20:31:55','2024-12-30 20:31:55',3,'N/A',2,'N/A',3,'N/A',1,'N/A',2,'N/A',3,NULL),(19,19,135,'submitted',NULL,'2024-12-31 06:08:59','2024-12-31 06:08:59',3,'N/A',3,'N/A',3,'N/A',3,'N/A',4,'N/A',3,NULL),(20,19,143,'submitted',NULL,'2024-12-31 06:56:40','2024-12-31 06:56:40',3,'N/A',3,'Study population is not stated, control section and definition is not clear, Analysis plan were not clearly mentioned.',3,'N/A',1,'The conclusion is simply the repetition of the result section and there is also conclusion is not supported by the findings.',0,'The study does not add any significance',2,NULL),(21,26,167,'submitted',NULL,'2024-12-31 07:50:45','2024-12-31 07:50:45',4,'Everything is well-presented; however, including more background on the specific geographical context would improve the understanding of the study\'s relevance.',3,'The methods section did not explain how the qualitative and quantitative data complemented or were linked to each other. Additionally, it did not specify how the data were analyzed or mention specific statistical methods. Furthermore, the process of data collection was not described.',5,'N/A',4,'Everything is well done; however, the study does not explain how data quality was maintained or how potential biases and confounding variables were addressed, which is important for drawing a more reliable conclusion. Additionally, the conclusion should focus more on the identified factors influencing prevention practices, rather than recommending general prevention mechanisms.',5,'N/A',5,NULL),(22,39,143,'submitted',NULL,'2024-12-31 08:45:55','2024-12-31 08:45:55',2,'The problem is not mentioned clearly.',3,'-',3,'N/A',2,'N/A',2,'N/A',3,NULL),(23,25,154,'submitted',NULL,'2024-12-31 21:04:58','2024-12-31 21:04:58',2,'The authors were narrated very shallow  to the burden of malaria cases from globe to local in the current situation. The authors were not expressed the aim this study.',1,'The authors were not clearly expressed what did they used study design and also wasn\'t stated study unit definition which is cases or controls . and also this study was not indicated the way of data collected or accessed. not determined the sample size. Authors weren\'t expressed the laboratory result which was labratory supported or not?',2,'The authors weren\'t keep the coherence. they weren\'t mentioned the slide positivity rate(SPR) from their study area. they haven\'t expressed which species were dominant in their study.In addition , the authors title said malaria outbreak investigation and response but at the result part haven\'t put which type response conducted in that study area.',1,'Simply the authors are put findings of the result so it wasn\'t appropriate. not recommended the specific intervention based on the findings.',1,'Author\'s recommended activities are not their result finding it is the general recommendation.',1,NULL),(24,116,154,'submitted',NULL,'2024-12-31 21:23:10','2024-12-31 21:23:10',5,'No comments because of they are well expressed way.',5,'N/A',4,'Authors weren\'t expressed in findings with time.',4,'they weren\'t recommended specific intervention based on their found findings in the study area, simply only put further study.',4,'It was better data organized and ideas flow. they presented the findings appropriately but based on their finding not recommended in their study area',5,NULL),(25,85,154,'submitted',NULL,'2024-12-31 21:38:20','2024-12-31 21:38:20',3,'Not narrated the burden of malaria cases in nowadays from globe to local area.',4,'N/A',3,'Not expressed where more affected place or district or kebeles in the study period, age group, slide positivity rate. Not stated the contribution of malaria cases from total outpatient cases',3,'The recommendations tasks aren\'t fit the objective set and not specific intervention in the study area',3,'N/A',3,NULL),(26,30,172,'submitted',NULL,'2024-12-31 21:42:57','2024-12-31 21:42:57',3,'The authors did not clearly describe the objective of the study ',4,'the method part has some basic components like study design, sample size, data collection methods and analysis techniques. But it lacks population and sampling procedure  ',5,'it is written well except it lacks logical flow of ideas. it was best to start with descriptive part. ',4,'The result in this abstract does not contain adequate background information for such conclusion.  ',4,'This study aimed to investigate the outbreak of Streptococcus pyogenes skin infection in South Gondar Zone that affected  more than 914 people within 1 month. ',4,NULL),(27,49,172,'submitted',NULL,'2024-12-31 22:02:59','2024-12-31 22:02:59',5,'it is well written and clearly state the objective. ',4,'the method part is very clear and contain most of the necessary information. however, the quantitative part was not describe adequately. ',5,'Similarly, it contains pertinent findings related with the objective of the study.  ',5,'The conclusion addressed objectives. ',5,'the study bring one of the key public health problem of the country ',5,NULL),(28,66,172,'submitted',NULL,'2024-12-31 22:13:27','2024-12-31 22:13:27',4,'The author explicitly state the study objective. but it lacks the gap of the study. ',3,'the method section was not clear. it lacks many of the sections of the method. ',4,'it was best to start with the total number of participants. the result part also shallow ',4,'the conclusion part was just repetition of the result part. the recommendation was not based on the result of the study. it was just general recommendation ',4,'the study bring critical public health problem (magnitude of new HIV infection). but it lacks many critical parts ',4,NULL),(29,86,172,'submitted',NULL,'2024-12-31 22:41:52','2024-12-31 22:41:52',4,'The objective of the study well presented as \"to assess health and health related problems among internally displaced persons residing at South Wollo Zone, Amhara region\" but the title is to vague ',3,'The method part was not adequately described. ',4,'the result section has some basic part but it lacks numerical descriptions of the main finding like the leading causes of morbidity and others ',4,'It is just repetition of the result section ',5,'internal displacement is one of the main public health problem of the current situation of the country. the study bring this critical problem ',4,NULL),(30,104,172,'submitted',NULL,'2024-12-31 23:09:29','2024-12-31 23:09:29',5,'well presented objective ',4,'good methods but it is not comprehensive ',5,'Well written, focused and organized ',5,'the conclusion, interpretation and recommendations are based on the findings of the study. ',5,'The study bring the current public health issue ',5,NULL),(31,112,150,'submitted',NULL,'2025-01-01 05:20:50','2025-01-01 05:20:50',2,'N/A',3,'N/A',3,'N/A',3,'N/A',3,'N/A',3,NULL),(32,24,165,'submitted',NULL,'2025-01-01 11:07:31','2025-01-01 11:07:31',3,'The authors could strengthen the significance of the study by:\n-Highlighting the impact of suboptimal adherence to malaria guidelines on malaria control.\n-Including specific data or trends on malaria in the Afar \n',4,'It is not clear how the authors selected charts and healthcare providers. Does this mean that both the healthcare provider and the patient charts they managed were selected? Otherwise, how do they combine results from charts with the interview with health care providers?',4,'The authors should report the chi-square test to check if there is a significant difference in adherence to malaria case management guidelines between the public and private facilities.',3,'N/A',4,'N/A',3,NULL),(33,19,135,'submitted',NULL,'2025-01-01 13:07:31','2025-01-01 13:07:31',3,'N/A',3,'N/A',3,'N/A',3,'N/A',3,'N/A',3,NULL),(34,37,135,'submitted',NULL,'2025-01-01 13:45:42','2025-01-01 13:45:42',4,'N/A',4,'N/A',4,'N/A',3,'N/A',4,'N/A',5,NULL),(35,51,135,'submitted',NULL,'2025-01-01 14:06:09','2025-01-01 14:06:09',5,'N/A',4,'N/A',4,'N/A',4,'N/A',4,'N/A',5,NULL),(36,17,23,'submitted',NULL,'2025-01-01 16:02:39','2025-01-01 16:02:39',3,'Even if malaria is a core public health problem in the nation, the problem is not described well.',2,'There is no explanation of the sample size and statistical methods used to analyze the data.',2,'There is no well-defined description of epidemiological variables such as person, place, and time. The entire numerical figure is overlooked. ',3,' Since the sampling technique is purposive sampling, the result may be affected by bias, chance, and confounding. ',3,'N/A',3,NULL),(37,43,149,'submitted',NULL,'2025-01-01 18:00:09','2025-01-01 18:00:09',3,'The study didn\'t address the public health problem in the specific study area ',4,'N/A',4,'N/A',4,'N/A',5,'N/A',4,NULL),(38,76,149,'submitted',NULL,'2025-01-01 18:09:01','2025-01-01 18:09:01',3,'Very broad topic and the health problem or questions inadequately described ',2,'The study design not clear, the mixed method study evidences inadequately described, data collection method not clear, how published articles reviewed and included not clear ',3,'N/A',3,'Seems generic ',4,'N/A',3,NULL),(39,96,149,'submitted',NULL,'2025-01-01 18:11:56','2025-01-01 18:11:56',4,'N/A',3,'How life style modification practice measured is not clear ',4,'N/A',4,'N/A',4,'N/A',4,NULL),(40,114,149,'submitted',NULL,'2025-01-01 18:17:20','2025-01-01 18:17:20',3,'The public health problem or questions that the study will address not adequately described ',4,'N/A',4,'N/A',4,'N/A',4,'N/A',4,NULL),(41,16,13,'submitted',NULL,'2025-01-02 07:55:24','2025-01-02 07:55:24',3,'Needs some information on how many are affected by the conflict',4,'The study area is not mentioned',4,'Description of study participants (such as socio-demography) not stated',3,'Not based on the findings',5,'The topic is a priority and mostly undermined area',4,NULL),(42,34,13,'submitted',NULL,'2025-01-02 08:09:02','2025-01-02 08:09:02',5,'N/A',4,'Other covariates included in the study were not discussed',5,'N/A',5,'N/A',5,'N/A',4,NULL),(43,53,13,'submitted',NULL,'2025-01-02 08:16:11','2025-01-02 08:16:11',3,'Did not acknowledge the existing knowledge regarding factors ',3,'Inclusion criteria not mentioned. Outbreak case definition is different from the standard case definition mentioned on PHEM Guideline',3,'Nothing is mentioned about the  holy water utilization ',3,'Repetition of the result section',5,'N/A',3,NULL),(44,67,13,'submitted',NULL,'2025-01-02 08:20:46','2025-01-02 08:20:46',4,'N/A',3,'Criteria for selection not discussed',4,'No description of study participants',4,'N/A',4,'N/A',4,NULL),(45,86,13,'submitted',NULL,'2025-01-02 08:28:58','2025-01-02 08:28:58',4,'N/A',2,'Number of participants was not described',4,'N/A',2,'Results are included in the conclusion section',3,'N/A',3,NULL),(46,105,13,'submitted',NULL,'2025-01-02 08:32:27','2025-01-02 08:32:27',5,'N/A',4,'N/A',5,'N/A',4,'N/A',5,'N/A',4,NULL),(47,35,23,'submitted',NULL,'2025-01-02 11:12:14','2025-01-02 11:12:14',4,'It is well described.',5,'It has a well-written description of epidemiological and statistical methods, including study design and data analysis. ',4,'The results are well-narrated, giving an explanation of significant relationships with the dependent variable. However, I believe it is preferable to use terms such as biomass fuel and fossil fuel rather than clean fuel and solid fuel.',4,'The conclusion clearly indicates the strategies to reduce childhood morbidity risk.',5,'The public health significance of the study is high since it also includes recommendations.',5,NULL),(48,74,135,'submitted',NULL,'2025-01-02 11:48:47','2025-01-02 11:48:47',3,'The abstract information not well addressed the significant of this study.',2,'N/A',3,'The information presented in the result section are not proper to reach to the conclusion. ',3,'The conclusion will provide enough information to take the proper action',2,'The data can\'t able to give enough information to build on existing knowledge. ',3,NULL),(49,56,143,'submitted',NULL,'2025-01-02 12:20:10','2025-01-02 12:20:10',3,'N/A',3,'N/A',2,'N/A',2,'N/A',2,'N/A',3,NULL),(50,92,135,'submitted',NULL,'2025-01-02 12:45:32','2025-01-02 12:45:32',4,'N/A',4,'N/A',4,'N/A',4,'N/A',5,'N/A',4,NULL),(51,111,135,'submitted',NULL,'2025-01-02 13:14:16','2025-01-02 13:14:16',4,'N/A',4,'N/A',4,'N/A',4,'N/A',4,'N/A',4,NULL),(52,37,8,'submitted',NULL,'2025-01-03 05:56:19','2025-01-03 05:56:19',4,'N/A',3,'Not sure whether a prevalence study is appropriate for such a seasonal acute infection. We have no information about endemicity of the malaria in the area',4,'N/A',3,'The conclusion doesn\'t match with the objectives. Recommendations on asymptomatic malaria are made without any data on the same. ',3,'N/A',3,NULL),(53,57,8,'submitted',NULL,'2025-01-03 06:36:13','2025-01-03 06:36:13',2,'N/A',1,'N/A',1,'N/A',2,'N/A',2,'N/A',2,NULL),(54,105,173,'submitted',NULL,'2025-01-03 06:54:18','2025-01-03 06:54:18',2,'Even though the authors indicated the objective of the study the gap they claimed is not true as several studies (large scale, and national level) were conducted, and issues related to recurrence is well stablished ',3,'The method is okay but could be more appropriate if authors used survival analysis methods that handles recurrent events as recurrence is not one time event but could be more than single recurrence.',3,'similar with method part.',1,'vague recommendation (there is no strong evidence from this study to recommend distribution of primaquine)',1,'They repeated already know fact',2,NULL),(55,66,167,'submitted',NULL,'2025-01-03 06:57:28','2025-01-03 06:57:28',3,'Even though the significance of recent HIV infections is explained, it lacks more information on local HIV prevalence and trends in recent infections in the region. In addition, how the Asante test improves the existing strategies should be added in the background to be more explanatory.',3,'The data collection process, participant selection, sample size, sampling method, key definitions (e.g., newly diagnosed cases), adjustment for potential confounders, and the nature of the data were not specified or described. All data were sourced from REDCap, but further details on inclusion criteria and study design were lacking.',4,'The overall sample size and the methods used to control potential confounders were not specified, limiting the adequacy of the conclusion.',5,'N/A',5,'N/A',5,NULL),(56,47,165,'submitted',NULL,'2025-01-03 07:21:06','2025-01-03 07:21:06',4,'The known impact of IDP in health care could be mentioned to show the rationale of the study. The author does not state the objective(s ) of the study',3,'The author does not provide enough detail on the methods used for data collection and sampling. Additionally, there is an apparent inconsistency; while they claim to have employed qualitative data collection methods, the data presentation techniques described appear to align solely with quantitative approaches.',2,'The author does not provide adequate data for readers to engage with meaningfully, presenting only the total number of internally displaced persons (IDPs) and their gender distribution.',3,'The conclusions are not based on the data presented in the result section. ',4,'The study undoubtedly addresses a significant and timely issue. However, the recommendations provided are not adequately supported by the data. For instance, the author suggests strengthening immunization programs without presenting information on the vaccination status within the studied IDP site.',3,NULL),(57,117,165,'submitted',NULL,'2025-01-03 08:12:18','2025-01-03 08:12:18',4,'It would be better if the author contextualized the problem in relation to the study area instead of focusing on global cholera cases.',3,'The chosen study design is inadequate to answer one of the research objectives, identifying risk factors. The sample size, sampling procedures, and method of analysis are not clearly indicated.\n',4,'It lacks details on the source and risk factors for the outbreak. ',3,'The conclusions are not supported by data and appear to reflect personal opinion rather than evidence-based findings',4,'N/A',3,NULL),(58,96,152,'submitted',NULL,'2025-01-03 10:54:49','2025-01-03 10:54:49',5,'N/A',4,'N/A',5,'N/A',4,'N/A',3,'N/A',5,NULL),(59,63,165,'submitted',NULL,'2025-01-03 13:31:27','2025-01-03 13:31:27',5,'N/A',4,'The sampling procedure is not clear\n-lacks clarity on how the samples were collected for the parasitological examination\n-',4,'-The authors didn\'t present what percentage of the NTDs were soil-transmitted helmithes, Trachoma , and skin-related NTDs\n-The authors consider similar factors for the NTDs mentioned above in the regression analysis. However, factors for soil-transmitted heminths may not work for trachoma and vice versa.',4,'The conclusion is likely attributable to chance, as indicated in a very wide CIs Adjusted odds ratio ( e.g. government employment AOR: 12.5 (95%CI: 1.17, 132.4)) ',4,'N/A',3,NULL),(60,57,152,'submitted',NULL,'2025-01-04 07:10:46','2025-01-04 07:10:46',3,'N/A',4,'N/A',3,'N/A',4,'N/A',4,'N/A',3,NULL),(61,40,152,'submitted',NULL,'2025-01-04 07:20:01','2025-01-04 07:20:01',5,'N/A',4,'N/A',4,'N/A',4,'N/A',4,'N/A',4,NULL),(62,77,152,'submitted',NULL,'2025-01-04 07:30:16','2025-01-04 07:30:16',4,'N/A',4,'N/A',5,'N/A',4,'N/A',5,'N/A',4,NULL),(63,114,152,'submitted',NULL,'2025-01-04 07:54:25','2025-01-04 07:54:25',4,'N/A',4,'N/A',4,'N/A',3,'N/A',3,'N/A',5,NULL),(64,22,152,'submitted',NULL,'2025-01-04 08:08:29','2025-01-04 08:08:29',3,'The objective was not clearly stated',4,'N/A',4,'N/A',4,'N/A',5,'N/A',5,NULL),(65,24,160,'submitted',NULL,'2025-01-04 09:45:44','2025-01-04 09:45:44',1,'No attention is given on the knowledge gap the study is going to add\nThe research gap is not clear\nRational of the study is missed',3,'superficial, does not tell how each variable had been measured\nMeasure of strength of association is not described in the method section\nData collection methods are not clearly described\nBut element of methodological review missed\n',3,'There is room for improving interpretation of data due to the result interpretation lacks comparison group\nComputing odds ratio above selected variables are not scientifically sound rather than computing proportion i.e better to compute chi-square test considering above variables ',4,'N/A',2,'Research gap is not clear\nlacks adequate detail in the methods section',3,NULL),(66,44,160,'submitted',NULL,'2025-01-04 10:24:44','2025-01-04 10:24:44',3,'But the knowledge gap that led to the study is not described at all \nstudy setting gap is not clear\nRational of the study is not clear',2,'Study design is not clear\nDescriptive analysis for continuous and categorical variables are not clearly described\nElement of methodological review missed is missed like case definition is not clear\nMeasure of the strength of association between variable is not clear\nMethods: superficial, does not tell how each variable had been measured and classified\n\n',4,'There is room for improving interpretation of data by including comparison groups\nThe result variable category is not clear',3,'There is room for improving synthesis of data based on big pictures\nStrong justification of the study is not clear\n\n',3,'Strong justification and public health importance of the study are not described at all \n',4,NULL),(67,99,165,'submitted',NULL,'2025-01-04 10:57:07','2025-01-04 10:57:07',5,'-The author could briefly address recent measles outbreaks in Ethiopia or the study setting to highlight the urgency and importance of this study rather than mentioning global data.\n-Further elaboration on the \"inconsistent coverage\" would provide richer context. Is this inconsistency observed among African countries, or are there regions within Ethiopia with particularly low coverage?',4,'-The sampling technique and data collection methods should be mentioned.\n-Who was included in the study? all under five?',4,'The author doesn\'t provide enough statistical details, such as 95% confidence intervals for the AOR, used to assess the precision of the findings.',5,'N/A',5,'N/A',4,NULL),(68,23,159,'submitted',NULL,'2025-01-04 11:42:13','2025-01-04 11:42:13',3,'The investigator did not clearly show the knowledge gap. However, the objectives are clearly stated.',3,'The design is described and it is also appropriate to efficiently address the objectives.  The outcome variable, vaccination status is not clearly defined. Otherwise, the method section is described including, statistical procedures. The data source is also presented, self administered questionnaire. \nThe study on uptake is well investigated, and an important research approach, qualitative study, would have been addressed to complement the quantitative study.',4,'The investigator has clearly summarized the result using appropriate numerical summary measure and also compared different groups. Appropriate statistical model is also used. However, we don\'t know whether the model assumptions are checked or not.',3,'The conclusion is partly consistent with objective. The investigator missed to conclude for the second part of his/her objectives, factors associated. ',3,'This finding might be used by local implementers for planning purpose ',3,NULL),(69,60,159,'submitted',NULL,'2025-01-04 12:18:42','2025-01-04 12:18:42',5,'The study addressed public health problem, and clearly stated the objectives.',3,'The study design is well stated and appropriate for the objectives. Treatment adherence need definition but not defined. The method of selecting the study institutions and two groups are not explicitly presented.',4,'The results presented following the described methods. The investigator tried to sufficiently present the result.',4,'The conclusions are as consistent with the objectives. ',3,'The investigator has tried to investigate whether there is a difference  between the two approach. But, it is not clear how the two groups selected.',4,NULL),(70,79,165,'submitted',NULL,'2025-01-04 12:24:28','2025-01-04 12:24:28',4,'N/A',4,'-To my understanding, a parallel evaluation design typically refers to an experimental or quasi-experimental design where interventions or treatments are tested simultaneously. However, in this study, the authors collect data from both pilot and non-pilot facilities at the same point in time and compare the outcomes (e.g., hypertension prevention, treatment, and control) between the two groups. This makes it a comparative cross-sectional study. \n-The authors didn\'t mention the sample size and sampling technique',4,'N/A',5,'N/A',5,'N/A',4,NULL),(71,61,160,'submitted',NULL,'2025-01-04 12:46:29','2025-01-04 12:46:29',3,'Rationale of the study is not clear\nOverall gaps of the study setting are not clear\nthe knowledge gap that led to the study is not described at all \n',2,'Independent variables are not systematically presented\nLacks adequate detail in the methods sub-section\nsample size of the participants is not clear\nCase definition is not clear \nStatistical methods are not clear  \n',1,'The study result is not logical presented\nGood to present based on the objective\nThe average of the variable is not presented by using percentage % --however, better to report using mean and standard deviation\n',2,'General pictures of the conclusion are not clear\nLack of the recommendation of the study end of the conclusion',2,'Lack of strong justification for this study\nMethodology of the study is not clear',2,NULL),(72,43,159,'submitted',NULL,'2025-01-04 13:12:02','2025-01-04 13:12:02',2,'The research question is not clearly shown. But, the objectives are clearly presented',4,'The study design is appropriate for the stated objectives. However, how some variables, such as knowledge and trust are measured is not clear. ',4,'The result is presented in logical order and consistent with the objectives. ',3,'It is not clear why 84% acceptance is considered as low. Some of the issues raised in the conclusion is not consistent with the objectives',3,'It could be used as input for local health service provider, otherwise has no new finding',3,NULL),(73,79,160,'submitted',NULL,'2025-01-04 13:13:43','2025-01-04 13:13:43',3,'No attention is given on the knowledge gap the study is going to add. \nRationale of the study is not described well\n',2,'Lacks adequate detail in the methods sub-section \nOverall study design is not clearly described\nEpidemiological/statistical methods not clearly described\nSample size is not clear \nStatistical procedures not described merely naming software packages',3,'How did you measure the rate of opportunistic blood pressure (BP) screening it is not clear\nThere is room for improving interpretation of data\n Why you present mean performance across the three domains by proportion this is the conflicting results (76.1% vs. 51.2%).',3,'This conclusion is not clear ---the evaluation of the pilot hypertension program in the Amhara region of Ethiopia demonstrated promising results.---good to write just exact figures\nSome of the texts are simply repeating of the results\n',4,'No attention is given on the knowledge gap the study is going to add',4,NULL),(74,98,160,'submitted',NULL,'2025-01-04 13:38:48','2025-01-04 13:38:48',3,'Public health problem that questions that the study was addressed is not clear\nExisting gaps is not clearly described at all\nknowledge gaps of the study are not considered',2,'Methodology is not comprehensive \nLacks adequate detail in the methods \nMeasurement and category of the variables is not clear\nStatistical software is not clear\nStatistical analysis is not described well\nMethodology of the study are superficial, does not tell how each variable had been measured\n',2,'This result is not clear --Analysis revealed a significant increase in controlled DM cases, rising from zero in 2019-2020 to 1,258 in 2022-2023---how many percentages that increased??\nPercentage of the data do not allow the reader to reach a conclusion\n',2,'synthesis of the conclusion is not based on the results\nAuthors synthesize results into a conclusion is not clear\nNo exact figure results under conclusion',3,'it needs strong justification of this study',3,NULL),(75,115,160,'submitted',NULL,'2025-01-04 14:03:24','2025-01-04 14:03:24',4,'But the knowledge gap that led to the study is not described at all \n',4,'overall methods is not adequately described \nContents of some of the methods not presented well\nModel diagnostic criteria is not presented   \n',4,'How did you measure poor knowledge on scabies and not clear\nThere is room for improving interpretation of data considering comparison groups\n',4,'N/A',3,'It needs strong justification for the study',4,NULL),(76,18,142,'submitted',NULL,'2025-01-05 04:14:18','2025-01-05 04:14:18',2,'The background is written in a way that makes it seem like the assessment was on \'surveillance\' rather than \'surveillance system evaluation\'. e.g. \"Hypertension surveillance plays a crucial role \"\nThe author/s didn`t put the significance of evaluating both private and public health facilities together.  ',2,'The study design was not mentioned. In addition, the authors didn`t mention the sample size for the record review/quantitative study that was entered into EPIINFO and analyzed with stata. They mentioned only for qualitative. why the evaluated public and private health facilities together? ',3,'The author reported in the method section that they used both percentages and proportions. However, it is not clear why they mentioned reporting both, and also unclear which one they used in reporting results. ',3,'The authors concluded the \'unstable of the system due to lack of dedicated resources\'. However, issues related to resource/s were not reported in the result section so the conclusion is based on results. ',2,'Such a study should be well designed so that appropriate public health significance would be indicated. ',3,NULL),(77,38,142,'submitted',NULL,'2025-01-05 04:37:40','2025-01-05 04:37:40',3,'The way the background was written seems as if the study was conducted on the impacts of social determinants on  hypertension mortality...... \".........impact of social determinants on hypertension-related mortality is poorly understood......\"\nThat means the gap is not clearly identified. ',4,'The authors didn`t mention which logistic regression was employed. The study population is missed. The author didn\'t mention what type of population was included in their study (is not found in the objective and method section also)',5,'N/A',4,'The authors forwarded recommendations for only health professionals. ',4,'The authors forwarded recommendations for only health professionals. ',4,NULL),(78,55,142,'submitted',NULL,'2025-01-05 04:56:00','2025-01-05 04:56:00',3,'The way the background was written seems as if it was aimed to focus on new HIV infections. \".......new infections continue to pose a major public health challenge\"',5,'well written ',2,'The expected key finding of this study, 5 years trend, was not reported. They reported the magnitude of HIV within those 5 years and among males and females as well as in place only. ',3,'Trend isn\'t concluded, wether it was increasing or decreasing ',4,'N/A',3,NULL),(79,71,142,'submitted',NULL,'2025-01-05 05:11:37','2025-01-05 05:11:37',3,'The objective is not well-written ',3,'the sample size included was not mentioned. Only 45 health facilities included in the study were mentioned. \nEthical issue is not expected to be written under the abstract. ',3,'The way the results are narrated lacks clarity. Besides, a new sentence should not start by number....\"61.57% of cases were......\"',4,'No recommendation was made for the high prevalence of HIV in urban settings. ',4,NULL,3,NULL),(80,91,142,'submitted',NULL,'2025-01-05 05:42:29','2025-01-05 05:42:29',3,'The study gap was not well identified ',2,'The study compared insured and non-insured populations. However, the study design employed was cross-section. why they didn`t employ comparative cross-sectional? They employed chi-square and logistic regression together. They used also convenience sampling which is non-probability sampling. ',4,'The way the Adjusted odds ratio is interpreted is not clear. ',2,'Since appropriate study design and sampling were employed, the conclusion and recommendation made from this study aren`t scientifically sound. ',3,'since proper sampling and design were not utilized, we can`t conclude that this study has public health significance. ',3,NULL),(81,109,142,'submitted',NULL,'2025-01-05 06:01:04','2025-01-05 06:01:04',2,'The objective mentioned is not supposed to be addressed by a case-control study. ',2,'The objective was magnitude and associated factors which is expected to be addressed by cross-sectional study. Hence, the objective and design employed, case-control, don`t match. ',1,'The study objective was the magnitude and associated factors. But they utilized case-control study. Hover, in the result they reported the incidence rate which is supposed to be reported if a cohort study was used. They calculated 50 sample size for cases but they recruited 1,267  for cases. ',2,'Is not based on results. ',2,'Is not based on proper design and results found. ',1,NULL),(82,23,25,'submitted',NULL,'2025-01-05 06:16:39','2025-01-05 06:16:39',4,'N/A',3,'N/A',5,'N/A',5,'N/A',3,'N/A',5,NULL),(83,42,25,'submitted',NULL,'2025-01-05 06:23:49','2025-01-05 06:23:49',4,'N/A',4,'N/A',4,'N/A',5,'N/A',5,'N/A',4,NULL),(84,46,25,'submitted',NULL,'2025-01-05 06:35:25','2025-01-05 06:35:25',3,'N/A',4,'N/A',4,'N/A',4,'N/A',4,'N/A',4,NULL),(85,62,25,'submitted',NULL,'2025-01-05 06:42:58','2025-01-05 06:42:58',5,'N/A',4,'N/A',4,'N/A',5,'N/A',4,'N/A',4,NULL),(86,78,25,'submitted',NULL,'2025-01-05 06:49:53','2025-01-05 06:49:53',5,'N/A',4,'N/A',5,'N/A',5,'N/A',4,'N/A',4,NULL),(87,98,25,'submitted',NULL,'2025-01-05 06:54:43','2025-01-05 06:54:43',2,'N/A',1,'N/A',2,'N/A',3,'N/A',2,'N/A',0,NULL),(88,115,25,'submitted',NULL,'2025-01-05 07:57:26','2025-01-05 07:57:26',4,'N/A',3,'Who are cases and whoare controls?',3,'N/A',4,'N/A',3,'N/A',4,NULL),(89,49,23,'submitted',NULL,'2025-01-05 08:49:16','2025-01-05 08:49:16',4,'Although the background is well-written, it would be more impactful if it included some statistical data regarding the MPDSR problem in the area.',4,'It would be better to use qualitative data analysis software rather than conducting it manually.',4,'It\'s only focused on the quantitative result. What about the qualitative findings? ',5,'The conclusions and recommendations are clear and directly associated with the findings that are mentioned under the results section, and it will have a good impact for the region. ',4,'It will have a great impact on the future improvement of this gap in the region as well as at the national level. ',5,NULL),(90,82,167,'submitted',NULL,'2025-01-05 09:11:04','2025-01-05 09:11:04',5,'N/A',5,'The study is well-described, but lacks explicit definitions of key terms and a concise explanation of statistical methods, such as model selection steps.',5,'N/A',5,'The conclusions and interpretations are well-described, but the specific recommended strategy and the responsible bodies for implementation are not clearly identified.',4,'The study recommends a salt intake reduction strategy, but no specific public health actions have been implemented. Targeted interventions, such as education campaigns or policy changes, could significantly reduce excessive salt intake in Bahir Dar City and similar areas.',5,NULL),(91,72,23,'submitted',NULL,'2025-01-05 12:45:17','2025-01-05 12:45:17',4,'The problems of schistosomiasis, geohelminthiasis, and anemia are well addressed by associating the problems with IDPs.',5,'The method is well described. \n\n',5,'The results section is well written.',5,'The conclusion and interpretation of the study describe a lot of things. ',5,'This study provides insightful information about the Neglected Tropical Disease. ',5,NULL),(92,20,144,'submitted',NULL,'2025-01-05 14:47:14','2025-01-05 14:47:14',3,'The author tried to describe the problem statement. Its significance or key antecedent data was not well described.  However, some writing styles need to be improved. eg. the word \'describe\' inappropriately used in \"Hence, this evaluation aims to describe the implementation status of the system, describe the attributes........, describe the knowledge of healthcare providers, and describe......................',3,'The importance of calculating sample size \"70 case report forms (CRF) samples were calculated using a single population proportion formula\" was not clear in the sense that single population proportion context.',3,'How the overall implementation status of the HIV CS system was measured?',3,'N/A',2,'Some recommendations are not derived directly from study results. eg. The overall implementation status of the HIV CS system is not sufficient compared to the regional and national targets.',3,NULL),(93,42,144,'submitted',NULL,'2025-01-05 15:17:51','2025-01-05 15:17:51',3,'The author has tried to describe the magnitude of the problem. However, The background has unnecessary details. eg. In 2016, approximately 1.13 billion adults were affected by hypertension, with about 7.5 million deaths attributed to it globally in 2021. ',3,'N/A',2,'Some of the data presented in the result section were not supported by the figure (data) except for completeness and timelines. Summarizing in proportions is important.',3,'Surveillance system attributes were not described quantitatively. eg proportion of .......',3,'N/A',3,NULL),(94,64,163,'submitted',NULL,'2025-01-05 17:57:51','2025-01-05 17:57:51',4,'The scientific background and the significance of the public health should be mentioned ',4,'The method of summarizing the results should be mentioned.\nthe case definitions should be also mentioned',4,'The total participants the study should be mentioned as it is. it could be in rates/percents',4,'N/A',4,'N/A',4,NULL),(95,71,8,'submitted',NULL,'2025-01-05 18:05:05','2025-01-05 18:05:05',4,'N/A',2,'N/A',2,'N/A',2,'The conclusions are not based on strong epidemiological evidence',2,'N/A',3,NULL),(96,93,8,'submitted',NULL,'2025-01-05 18:09:45','2025-01-05 18:09:45',3,'No justification provided ',2,'No case definition, only descriptive analysis. No advanced epidemiology methods employed. ',2,'Only number of cases is reported and described. No proportions were discussed. ',3,'N/A',3,'N/A',3,NULL),(97,109,8,'submitted',NULL,'2025-01-05 18:11:35','2025-01-05 18:11:35',4,'N/A',5,'N/A',5,'N/A',5,'N/A',4,'N/A',5,NULL),(98,103,163,'submitted',NULL,'2025-01-05 18:15:39','2025-01-05 18:15:39',4,'The scientific and significance of the public health problems should be mentioned. the literature review of the public health problem should be mentioned ',5,NULL,5,'N/A',5,'N/A',4,'N/A',4,NULL),(99,14,138,'submitted',NULL,'2025-01-06 06:35:32','2025-01-06 06:35:32',3,'N/A',3,'N/A',3,'N/A',3,'N/A',3,'N/A',3,NULL),(100,33,138,'submitted',NULL,'2025-01-06 06:54:06','2025-01-06 06:54:06',4,'N/A',4,'N/A',3,'N/A',3,'N/A',3,'N/A',4,NULL),(101,53,138,'submitted',NULL,'2025-01-06 07:13:02','2025-01-06 07:13:02',4,'N/A',3,'N/A',4,'N/A',3,'N/A',3,'N/A',3,NULL),(102,72,138,'submitted',NULL,'2025-01-06 07:20:04','2025-01-06 07:20:04',4,'N/A',3,'There is information about sample size, sampling procedure and study settings clearly.',3,'All the stated objectives were not responded or there is no result for all specifice objectives.',3,'N/A',3,'N/A',3,NULL),(103,12,14,'submitted',NULL,'2025-01-06 07:37:34','2025-01-06 07:37:34',3,'NCD  data and information of Ethiopia were not well addressed,the objective was not explicitly stated',5,'N/A',4,'age ,sex and other factors association with NCD were not explicitly stated',4,'N/A',4,'public health significance  were not that much emphasized',4,NULL),(104,91,138,'submitted',NULL,'2025-01-06 07:40:26','2025-01-06 07:40:26',4,'N/A',4,'N/A',4,'N/A',3,'N/A',4,'N/A',4,NULL),(105,30,14,'submitted',NULL,'2025-01-06 07:46:10','2025-01-06 07:46:10',3,'global situation was not captured as background',5,'well addressed',5,'N/A',4,'N/A',4,'N/A',4,NULL),(106,46,14,'submitted',NULL,'2025-01-06 07:57:10','2025-01-06 07:57:10',4,'N/A',5,'N/A',4,'N/A',4,'N/A',5,'N/A',4,NULL),(107,71,14,'submitted',NULL,'2025-01-06 08:02:05','2025-01-06 08:02:05',5,'N/A',4,'N/A',4,'N/A',4,'N/A',5,'N/A',4,NULL),(108,86,14,'submitted',NULL,'2025-01-06 08:08:02','2025-01-06 08:08:02',4,'N/A',4,'N/A',3,'not well stated according to the objective',5,'N/A',4,'N/A',4,NULL),(109,90,23,'submitted',NULL,'2025-01-06 08:23:42','2025-01-06 08:23:42',3,'It lacks statistical data to elaborate on the public health issues of Visceral Leishmaniasis and other parasitic infections. ',3,'This study only uses binary logistic regression to determine the risk factor for VL. It will be better to consider multiple logistic regression to consider the effect of confounding. ',5,'The study has well-written results. ',4,'Better to consider specific recommendations regarding the issues.',4,'When we see the VL issues, it\'s only observed in a limited area. ',4,NULL),(110,102,14,'submitted',NULL,'2025-01-06 08:25:24','2025-01-06 08:25:24',4,'N/A',4,'N/A',3,'N/A',3,'the important intervention for TB prevention was not well stated',4,'N/A',3,NULL),(111,109,23,'submitted',NULL,'2025-01-06 08:41:34','2025-01-06 08:41:34',5,' The issue is entertained from global to local presentation with statistical figures. ',4,'The method section is good; however, it lacks clarification between bivariable and bivariate logistic regression. ',5,'The result section is well described. ',5,'The conclusion includes general and specific recommendations.',4,'Even if the recommendations are not new, it will help as a reminder. ',5,NULL),(112,110,138,'submitted',NULL,'2025-01-06 09:02:44','2025-01-06 09:02:44',4,'N/A',4,'N/A',3,'N/A',3,'N/A',3,'N/A',4,NULL),(113,114,159,'submitted',NULL,'2025-01-06 12:20:11','2025-01-06 12:20:11',3,'It is well known that the topic of interest is a public health problem in Ethiopia. The objective of the study is presented. However, the reason for conducting this study was not clearly indicated. ',3,'The investigator has described the study design. The stated study design, can\'t answer all of the objectives. For example, verifying the existence of an outbreak can\'t be addressed by case-control study.',4,'The results are present in a logical flow. It is not clear, whether the two groups are comparable or not ',3,'Conclusion is partly based the data.',3,'The finding could be taken into account by local implementers',4,NULL),(114,57,144,'submitted',NULL,'2025-01-06 14:49:13','2025-01-06 14:49:13',1,'Not written in the Abstract protocol ( some contents were directly taken from the Internet (International Journal for Quality in Health Care, 2019, 31(10), G180–G186doi: 10.1093/intqhc/mzz127)',1,'Too large to capture, Not written in the Abstract protocol ( some contents were directly taken from the Internet (International Journal for Quality in Health Care, 2019, 31(10), G180–G186doi: 10.1093/intqhc/mzz127)',1,'N/A',2,'N/A',2,'N/A',1,NULL);

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1),(16,1),(17,1),(18,1),(19,1),(20,1),(21,1),(22,1),(23,1),(24,1),(25,1),(26,1),(27,1),(28,1),(29,1),(30,1),(31,1),(32,1),(33,1),(34,1),(35,1),(36,1),(37,1),(38,1),(39,1),(40,1),(41,1),(42,1),(43,1),(44,1),(45,1),(46,1),(47,1),(48,1),(49,1),(50,1),(51,1),(52,1),(53,1),(54,1),(55,1),(56,1),(57,1),(58,1),(59,1),(60,1),(61,1),(62,1),(63,1),(64,1),(65,1),(66,1),(67,1),(68,1),(69,1),(70,1),(71,1),(72,1),(73,1),(74,1),(75,1),(76,1),(77,1),(78,1),(79,1),(80,1),(81,1),(82,1),(83,1),(84,1),(85,1),(86,1),(87,1),(88,1),(89,1),(90,1),(91,1),(92,1),(93,1),(94,1),(95,1),(96,1),(97,1),(98,1),(99,1),(100,1),(101,1),(102,1),(103,1),(109,1),(110,1),(111,1),(112,1),(113,1),(114,1),(115,1),(116,1),(117,1),(118,1),(119,1),(120,1),(121,1),(122,1),(123,1),(124,1),(125,1),(126,1),(127,1),(128,1),(129,1),(130,1),(131,1),(132,1),(133,1),(134,1),(135,1),(136,1),(137,1),(138,1),(139,1),(140,1),(141,1),(142,1),(143,1),(144,1),(55,2),(56,2),(57,2),(58,2),(104,2),(105,2),(1,3),(2,3),(3,3),(5,3),(6,3),(7,3),(8,3),(13,3),(14,3),(15,3),(16,3),(17,3),(18,3),(19,3),(20,3),(25,3),(26,3),(27,3),(28,3),(29,3),(30,3),(31,3),(32,3),(43,3),(44,3),(45,3),(47,3),(48,3),(49,3),(50,3),(54,3),(55,3),(56,3),(57,3),(67,3),(68,3),(69,3),(71,3),(72,3),(73,3),(74,3),(79,3),(80,3),(81,3),(82,3),(83,3),(84,3),(85,3),(86,3),(91,3),(92,3),(93,3),(104,3),(105,3),(106,3),(107,3),(108,3),(145,4),(146,4),(147,4),(148,4);

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'super_admin','web','2024-11-06 08:41:47','2024-11-06 08:41:47'),(2,'user','web','2024-11-06 08:42:40','2024-11-06 08:42:40'),(3,'Conf_admin','web','2024-11-07 03:10:44','2024-11-07 03:10:44'),(4,'Reviewer','web','2024-12-22 11:01:20','2024-12-22 11:01:20');

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` VALUES ('3jtBFHyVkauY7TBm97A7DkcvhFkAK3MObwe7twGi',NULL,'66.249.93.98','Mozilla/5.0 (Linux; Android 7.0; SM-G930V Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiNkZXNVBVd1M4V0RwdDhNajNNY1lMelV0ZkMyRWtQY1k5YVRuVHBJSSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0ODoiaHR0cHM6Ly9wb3J0YWwuYWZlbmV0Lm9yZy9hZG1pbi9zdWJtaXQtYWJzdHJhY3RzIjt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDg6Imh0dHBzOi8vcG9ydGFsLmFmZW5ldC5vcmcvYWRtaW4vc3VibWl0LWFic3RyYWN0cyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1736172728),('3q2fjBY4WLDQOQ1yYUtwxiwEAbwQrALiOrekIx9x',102,'196.189.127.138','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','YTo2OntzOjY6Il90b2tlbiI7czo0MDoidVBxZUx0UEtKUlhVRjBoODNvOHp5SXhLeDV3bFBheUpaS3pXNHA0RyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHBzOi8vcG9ydGFsLmFmZW5ldC5vcmcvYWRtaW4vcmV2aWV3cyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjEwMjtzOjE3OiJwYXNzd29yZF9oYXNoX3dlYiI7czo2MDoiJDJ5JDEyJFdKSTVRVkcuS1VsUUlXUkpxSGI4RS5VYWxoOC9abEx0ekp4WnZNdDVPMC5IZlg2TC9NVnNLIjtzOjg6ImZpbGFtZW50IjthOjA6e319',1736179930),('4xXujZVnOc61J4gZEW2hW8aKamui0jiTn7dvaVs6',NULL,'66.249.93.99','Mozilla/5.0 (Linux; Android 7.0; SM-G930V Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZllUZml6MmhxWFBHd1dtbzRMdE1CZHJ5ZE44MTRycEw4ekhUVEhnViI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vcG9ydGFsLmFmZW5ldC5vcmcvYWRtaW4vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1736173905),('7X4G5CKOE3TFeHEBUvcGy3HKjrYwqQzI4U0V1zFE',NULL,'66.249.93.97','Mozilla/5.0 (Linux; Android 7.0; SM-G930V Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZ1AwVzB5YjBoekJHYVBVZ3NicXNYNWVnV0FScnJYa05oNE42YXVRUiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vcG9ydGFsLmFmZW5ldC5vcmcvYWRtaW4vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1736172728),('7YNNBIzpD2OSNjMhiKSL9QFNN8hv2lKGx1Ebb89J',NULL,'196.190.63.79','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMTk5NW1pUGpCeDhHZnd6SkxPMEJGcDlRbEdFZ2NHQUdNSk84alM0bCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHBzOi8vcG9ydGFsLmFmZW5ldC5vcmciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1736172522),('96GPg1hrHVnrMfUHx6JRpXQVNjH7G4i2KlazrKi9',NULL,'66.249.93.99','Mozilla/5.0 (Linux; Android 7.0; SM-G930V Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiVnFONTFMVHJFYll5TWpLU0FqeGF2dnFIbW56bmhKNG93WXJJWXdKdiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czozOToiaHR0cHM6Ly9wb3J0YWwuYWZlbmV0Lm9yZy9hZG1pbi9yZXZpZXdzIjt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vcG9ydGFsLmFmZW5ldC5vcmcvYWRtaW4vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1736178672),('ADQKKiw1a2Gv5U99tJ8m9LYeRRMFh4bvG3hSW5nj',144,'213.55.92.81','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','YTo2OntzOjY6Il90b2tlbiI7czo0MDoiVTRWa1ZMYXFRVGhMZDMxSkI2VEFhWWRjb1RHakVCUm1ZQmdJOEhBWCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NzI6Imh0dHBzOi8vcG9ydGFsLmFmZW5ldC5vcmcvYWRtaW4vcmV2aWV3cy9jcmVhdGU/ZGF0YSU1QmFic3RyYWN0X2lkJTVEPTExMiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE0NDtzOjE3OiJwYXNzd29yZF9oYXNoX3dlYiI7czo2MDoiJDJ5JDEyJFhlM2d2ZHVndktiQnFUNFpPRHNOUk9BejBhU0FTMWkyeUpDNUs0bUJPQXFCVXhUdHRBUXZXIjtzOjg6ImZpbGFtZW50IjthOjA6e319',1736177835),('C8Up8uP5OdRm9ylFaS5gBXIApZ1hAZW1Pp2e7oHF',NULL,'66.249.93.97','Mozilla/5.0 (Linux; Android 7.0; SM-G930V Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZm1aRVFLOUVIQUNtR1FOTHc1bzdaa3J5Ynl0RnhuOHA4TkFBUjM1UyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vcG9ydGFsLmFmZW5ldC5vcmcvYWRtaW4vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1736173877),('EJP12c1fA6qN5eSDh1SQmTFuvWqCG0InI0ArZH86',NULL,'66.249.93.97','Mozilla/5.0 (Linux; Android 7.0; SM-G930V Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoib3FRSVNSdGR3SU9jQk51NkpKMkZZV2tKNHdtTXZXUkk2bzcydU50ayI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo1NzoiaHR0cHM6Ly9wb3J0YWwuYWZlbmV0Lm9yZy9hZG1pbi9zdWJtaXQtYWJzdHJhY3RzLzEwOC9lZGl0Ijt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTc6Imh0dHBzOi8vcG9ydGFsLmFmZW5ldC5vcmcvYWRtaW4vc3VibWl0LWFic3RyYWN0cy8xMDgvZWRpdCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1736178692),('F9u6p2yNnDLEIO1R8LzwSXKxmqWEmOfoxlTZsU8m',NULL,'66.249.83.35','Mozilla/5.0 (Linux; Android 7.0; SM-G930V Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoid1ZLMGNOZktJdDBJNnE4dEpzYTlITElRejFnYXc3bUlzV1JFVjdiViI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czozOToiaHR0cHM6Ly9wb3J0YWwuYWZlbmV0Lm9yZy9hZG1pbi9yZXZpZXdzIjt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vcG9ydGFsLmFmZW5ldC5vcmcvYWRtaW4vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1736178671),('gPrwtb6BLCw70f9wdRCLZc4nBX5UTbu3RAIgjwOo',NULL,'66.249.93.98','Mozilla/5.0 (Linux; Android 7.0; SM-G930V Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTUJLdUZ4N1Q0c3dncDlDM0tXaEdGd0Q2dEVMTE5lQk9LS0kxYjhVbyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vcG9ydGFsLmFmZW5ldC5vcmcvYWRtaW4vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1736173874),('h35BdLrUMQTIkgoucPHvFvanPtY3WIgGFvyUmzwF',NULL,'66.249.83.36','Mozilla/5.0 (Linux; Android 7.0; SM-G930V Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiY2VaTkNzOEExZlJFcElWbjdPUDJueEFmVzVTcXhWRUFZOEQyTHNvOSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vcG9ydGFsLmFmZW5ldC5vcmcvYWRtaW4vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1736172529),('jmcopmFJmL5cChLkRzmAfACLyHdcN45DyhSGaaxj',NULL,'66.249.93.97','Mozilla/5.0 (Linux; Android 7.0; SM-G930V Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiTEJKd05CSmNnaTZ3TG5GTHY4RUNTNEJwaHFjUkNsM2VaOTRmbDY2bSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo5MjoiaHR0cHM6Ly9wb3J0YWwuYWZlbmV0Lm9yZy9hZG1pbi9zdWJtaXQtYWJzdHJhY3RzP3RhYmxlU29ydENvbHVtbj1uYW1lJnRhYmxlU29ydERpcmVjdGlvbj1hc2MiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo5MjoiaHR0cHM6Ly9wb3J0YWwuYWZlbmV0Lm9yZy9hZG1pbi9zdWJtaXQtYWJzdHJhY3RzP3RhYmxlU29ydENvbHVtbj1uYW1lJnRhYmxlU29ydERpcmVjdGlvbj1hc2MiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1736173874),('MmzvRXqEvffgGmlJYGOqh6pEcm2SGYjLxui2bKZd',19,'216.104.205.202','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','YTo2OntzOjY6Il90b2tlbiI7czo0MDoieGRxMFpnQW03RDAwSE03NEwwbm9TTGhSNDIzUUFuSVgzaVBiV0l5TCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTk7czoxNzoicGFzc3dvcmRfaGFzaF93ZWIiO3M6NjA6IiQyeSQxMiQxbER5TmkyakJsUy9sWVFUQjBFT2xlZnlnUVY2LjhLTEZZZy53NXVrUDNoRjhGbXoyLzJvNiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6ODU6Imh0dHBzOi8vcG9ydGFsLmFmZW5ldC5vcmcvYWRtaW4vcmV2aWV3cz90YWJsZUZpbHRlcnMlNUJzdGF0dXMlNUQlNUJ2YWx1ZSU1RD1zdWJtaXR0ZWQiO31zOjY6InRhYmxlcyI7YToxOntzOjIwOiJMaXN0UmV2aWV3c19wZXJfcGFnZSI7czozOiJhbGwiO319',1736173225),('OnzKgDOg6AXTk2x39C9AzZSFmS69jxEkniQmNTNx',NULL,'66.249.93.99','Mozilla/5.0 (Linux; Android 7.0; SM-G930V Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSkFvTE5IM2NZWksyMmU1d3lmNm5uWlhWbXhYdjdiSlJMbE1ZcXNQcyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vcG9ydGFsLmFmZW5ldC5vcmcvYWRtaW4vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1736172529),('QiKdNbP2iGDqNXFWdHFD2A3YyNxSRliqn2MYhOa6',NULL,'66.249.93.99','Mozilla/5.0 (Linux; Android 7.0; SM-G930V Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiQ3RkWE5PVmR3S3BqcWRLY1pMRFNEbENRVWMzbTd3MUdMSnR5M3VpcCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo1NzoiaHR0cHM6Ly9wb3J0YWwuYWZlbmV0Lm9yZy9hZG1pbi9zdWJtaXQtYWJzdHJhY3RzLzEwMi92aWV3Ijt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTc6Imh0dHBzOi8vcG9ydGFsLmFmZW5ldC5vcmcvYWRtaW4vc3VibWl0LWFic3RyYWN0cy8xMDIvdmlldyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1736173905),('rB4gHGhjyq8RUxq5dC6p4PesNLrXlFhlh4IZgFs7',NULL,'196.190.63.79','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiYUVLbUJySU1iTm5HT1ZMNFRITmZzV2R6OElMWHZCQzZ4d3RCVUxmTCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHBzOi8vcG9ydGFsLmFmZW5ldC5vcmciO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1736172522),('sddGjKYul7jEMPF9CSTpdo4kpkAZ2lKE2xrcqvuT',NULL,'66.249.93.97','Mozilla/5.0 (Linux; Android 7.0; SM-G930V Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSERJR0JvVkxmbm9PZFdxSDFYMDh5TFRpRURycDNkaWJWOWVGbmZ3RyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vcG9ydGFsLmFmZW5ldC5vcmcvYWRtaW4vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1736178693),('veBQohQUJbXpKARf2dM1watTOik838c7hjAqQZ3e',NULL,'66.249.93.98','Mozilla/5.0 (Linux; Android 7.0; SM-G930V Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)','YTozOntzOjY6Il90b2tlbiI7czo0MDoiWFMxMHI0VWFGRnd1UmN5OE5pTERFZVhBTVBkbnBSMDRGbW5uWEZnYSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzc6Imh0dHBzOi8vcG9ydGFsLmFmZW5ldC5vcmcvYWRtaW4vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1736173753),('X12qeWcUXB9DC9G6zagJ6wXpZozxIPPZvnjnFVMK',NULL,'66.249.93.97','Mozilla/5.0 (Linux; Android 7.0; SM-G930V Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoicVQ4N3VibjkxTU40VG1ReGUwMnpIUTRadTZBcmViTHNWc2tFa3Q5YiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo1NzoiaHR0cHM6Ly9wb3J0YWwuYWZlbmV0Lm9yZy9hZG1pbi9zdWJtaXQtYWJzdHJhY3RzLzEwMi9lZGl0Ijt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTc6Imh0dHBzOi8vcG9ydGFsLmFmZW5ldC5vcmcvYWRtaW4vc3VibWl0LWFic3RyYWN0cy8xMDIvZWRpdCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1736173877),('xPsnlmNo2kU54gV2n0rVYSVAGrgVAaZAkLKqBjrk',172,'197.156.116.65','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36 OPR/115.0.0.0','YTo1OntzOjY6Il90b2tlbiI7czo0MDoiZ2g4Y05BRzBORTFpekR0ZXVtZmhqQm1UVlZGa1ptaWdnOG1DWXd5byI7czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTcyO3M6MTc6InBhc3N3b3JkX2hhc2hfd2ViIjtzOjYwOiIkMnkkMTIkWGUzZ3ZkdWd2S2JCcVQ0Wk9Ec05ST0F6MGFTQVMxaTJ5SkM1SzRtQk9BcUJVeFR0dEFRdlciO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjcxOiJodHRwczovL3BvcnRhbC5hZmVuZXQub3JnL2FkbWluL3Jldmlld3MvY3JlYXRlP2RhdGElNUJhYnN0cmFjdF9pZCU1RD0zMCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1736177686),('xUqkfw9E1eol3F7FD3KusxYRLyyDAlWuOI5OgE0v',NULL,'66.249.93.97','Mozilla/5.0 (Linux; Android 7.0; SM-G930V Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36 (compatible; Google-Read-Aloud; +https://support.google.com/webmasters/answer/1061943)','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiNW9FMTN2Wk9SY2RCQW1oREZxVEViOFpLdDZQU0FhVkdrU1V6bUtSUSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czozOToiaHR0cHM6Ly9wb3J0YWwuYWZlbmV0Lm9yZy9hZG1pbi9yZXZpZXdzIjt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mzk6Imh0dHBzOi8vcG9ydGFsLmFmZW5ldC5vcmcvYWRtaW4vcmV2aWV3cyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1736173753);

--
-- Table structure for table `sub_themes`
--

CREATE TABLE `sub_themes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sub_themes`
--

INSERT INTO `sub_themes` VALUES (16,'Public Health Emergency Preparedness, Surveillance, Outbreak Investigations and Response.','2024-11-13 09:37:41','2024-11-13 09:37:41'),(17,'Vaccine Preventable Diseases','2024-11-13 09:37:50','2024-11-13 09:37:50'),(18,'HIV/AIDS, Tuberculosis and Other Opportunistic Infections','2024-11-13 09:37:57','2024-11-13 09:37:57'),(19,'Vector-Borne and Neglected Tropical Diseases (NTDs)','2024-11-13 09:38:06','2024-11-13 09:38:06'),(20,'Non-communicable Diseases (NCDs), Injuries & Mental Health','2024-11-13 09:38:13','2024-11-13 09:38:13'),(21,'Maternal, Reproductive and Child Health','2024-11-13 09:38:19','2024-11-13 09:38:19'),(22,'Public Health Laboratory Systems and Infection Prevention Control ','2024-11-13 09:38:29','2024-11-13 09:38:29'),(23,'One Health & Climate Change','2024-11-13 09:38:35','2024-11-13 09:38:35'),(24,'Public Health Systems Strengthening Initiatives','2024-11-13 09:38:41','2024-11-13 09:38:41'),(25,'Communication & Technological Innovations for Public Health','2024-11-13 09:38:48','2024-11-13 09:38:48');

--
-- Table structure for table `submit_abstracts`
--

CREATE TABLE `submit_abstracts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `subtheme_id` int DEFAULT NULL,
  `co_authors` text COLLATE utf8mb4_unicode_ci,
  `abstract_title` text COLLATE utf8mb4_unicode_ci,
  `abstract_backgound` text COLLATE utf8mb4_unicode_ci,
  `abstract_methods` text COLLATE utf8mb4_unicode_ci,
  `abstract_results` text COLLATE utf8mb4_unicode_ci,
  `abstract_conclusion` text COLLATE utf8mb4_unicode_ci,
  `key_words` text COLLATE utf8mb4_unicode_ci,
  `user_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `submit_abstracts`
--



--
-- Table structure for table `titles`
--

CREATE TABLE `titles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `titles`
--

INSERT INTO `titles` VALUES (1,'Mr.','2024-11-04 03:24:14','2024-11-04 03:27:15'),(2,'Mrs.','2024-11-04 03:24:19','2024-11-04 03:27:20'),(3,'Ms.','2024-11-04 03:24:22','2024-11-04 03:27:29'),(4,'Dr.','2024-11-04 03:24:26','2024-11-04 03:27:49'),(5,'Prof.','2024-11-04 03:24:32','2024-11-04 03:27:56');

--
-- Table structure for table `workshops`
--

CREATE TABLE `workshops` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `workshops`
--

INSERT INTO `workshops` VALUES (2,'N/A','<p>Not Applicable</p>','2024-11-04 04:12:42','2024-11-04 04:12:42'),(3,'7-1-7 A for early detection & response','<p>Training on 7-1-7 Planning and Implementation for Timely Detection, Notification and Response to Outbreaks</p>','2024-11-04 04:13:37','2024-11-16 07:52:38'),(5,'FETP Quality Assurance: Accreditation/AFENET Star Rating System/REDPETT ','<p>FETP Quality Assurance: Accreditation/AFENET Star Rating System/REDPETT&nbsp;</p>','2024-11-04 04:14:07','2024-11-04 04:14:07'),(7,'Toxicological Outbreak Investigation','<ul><li><strong><em>Toxicological Outbreak Investigation</em></strong></li></ul><p><br></p>','2024-11-16 07:50:54','2024-11-16 07:50:54'),(8,'Residents Driven Project Tracking Tool (ReDPETT)','<ul><li><strong><em>Residents Driven Project Tracking Tool (ReDPETT)</em></strong></li></ul><p><br></p>','2024-11-16 07:51:58','2024-11-16 07:51:58'),(9,'Food Safety','<ul><li><strong><em>Food Safety</em></strong></li></ul><p><br></p>','2024-11-16 07:52:20','2024-11-16 07:52:20'),(10,'Mental Health Surveillance Systems','<p><strong><em>Mental Health Surveillance Systems</em></strong>&nbsp;</p>','2024-11-16 07:53:05','2024-11-16 07:53:05'),(11,'Climate Change and Health (Planetary Health)','<ul><li><strong><em>Climate Change and Health (Planetary Health)</em></strong></li></ul><p><br></p>','2024-11-16 07:53:32','2024-11-16 07:53:32'),(12,'Antimicrobial resistance (AMR)','<ul><li><strong><em>Antimicrobial resistance (AMR)</em></strong></li></ul><p><br></p>','2024-11-16 07:54:01','2024-11-16 07:54:01'),(13,'One Health','<p><strong><em>One Health</em></strong>&nbsp;</p>','2024-11-16 07:54:17','2024-11-16 07:54:17');


