--
-- Host: localhost    Database: 2rrt
-- ------------------------------------------------------


--
-- Table structure for table `agency_roles`
--

CREATE TABLE `agency_roles` (
  `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,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `agency_roles_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `agency_roles`
--

INSERT INTO `agency_roles` VALUES (1,'test','2023-08-06 08:53:57','2023-08-06 09:10:02','2023-08-06 09:10:02'),(4,'	health communicator','2023-08-06 09:10:17','2023-08-06 09:10:17',NULL),(5,'	logistician','2023-08-06 09:10:19','2023-08-06 09:10:19',NULL),(6,'	epidemiologist','2023-08-06 09:10:23','2023-08-06 09:10:23',NULL),(7,'	laboratory technician','2023-08-06 09:10:29','2023-08-06 09:10:29',NULL),(8,'testg','2023-08-14 11:45:04','2023-08-14 11:45:15','2023-08-14 11:45:15');

--
-- Table structure for table `case_managements`
--

CREATE TABLE `case_managements` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `case_management_specialty` longtext COLLATE utf8mb4_unicode_ci,
  `nurse_speciality` longtext COLLATE utf8mb4_unicode_ci,
  `paramedic_specialty` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `physician_id` bigint unsigned DEFAULT NULL,
  `nurse_id` bigint unsigned DEFAULT NULL,
  `paramedic_id` bigint unsigned DEFAULT NULL,
  `rapid_risk_assessments_id` bigint unsigned DEFAULT NULL,
  `clinical_management_advice_and_recommendations_id` bigint unsigned DEFAULT NULL,
  `icp_in_the_care_facility_id` bigint unsigned DEFAULT NULL,
  `monitoring_system_id` bigint unsigned DEFAULT NULL,
  `epidemic_survey_id` bigint unsigned DEFAULT NULL,
  `determination_of_disease_status_id` bigint unsigned DEFAULT NULL,
  `epidemiological_studies_id` bigint unsigned DEFAULT NULL,
  `study_protocols_id` bigint unsigned DEFAULT NULL,
  `data_collection_tools_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `physician_fk_7664170` (`physician_id`),
  KEY `nurse_fk_7664172` (`nurse_id`),
  KEY `paramedic_fk_7664174` (`paramedic_id`),
  KEY `rapid_risk_assessments_fk_7664176` (`rapid_risk_assessments_id`),
  KEY `clinical_management_advice_and_recommendations_fk_7664177` (`clinical_management_advice_and_recommendations_id`),
  KEY `icp_in_the_care_facility_fk_7664178` (`icp_in_the_care_facility_id`),
  KEY `monitoring_system_fk_7664179` (`monitoring_system_id`),
  KEY `epidemic_survey_fk_7664180` (`epidemic_survey_id`),
  KEY `determination_of_disease_status_fk_7664181` (`determination_of_disease_status_id`),
  KEY `epidemiological_studies_fk_7664182` (`epidemiological_studies_id`),
  KEY `study_protocols_fk_7664183` (`study_protocols_id`),
  KEY `data_collection_tools_fk_7664184` (`data_collection_tools_id`),
  KEY `user_fk_7664211` (`user_id`),
  CONSTRAINT `clinical_management_advice_and_recommendations_fk_7664177` FOREIGN KEY (`clinical_management_advice_and_recommendations_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `data_collection_tools_fk_7664184` FOREIGN KEY (`data_collection_tools_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `determination_of_disease_status_fk_7664181` FOREIGN KEY (`determination_of_disease_status_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `epidemic_survey_fk_7664180` FOREIGN KEY (`epidemic_survey_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `epidemiological_studies_fk_7664182` FOREIGN KEY (`epidemiological_studies_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `icp_in_the_care_facility_fk_7664178` FOREIGN KEY (`icp_in_the_care_facility_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `monitoring_system_fk_7664179` FOREIGN KEY (`monitoring_system_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `nurse_fk_7664172` FOREIGN KEY (`nurse_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `paramedic_fk_7664174` FOREIGN KEY (`paramedic_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `physician_fk_7664170` FOREIGN KEY (`physician_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `rapid_risk_assessments_fk_7664176` FOREIGN KEY (`rapid_risk_assessments_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `study_protocols_fk_7664183` FOREIGN KEY (`study_protocols_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `user_fk_7664211` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `case_managements`
--

INSERT INTO `case_managements` VALUES (1,'<div style=\"margin: 0px 28.7917px 0px 14.3958px; padding: 0px; width: 436.792px; text-align: left; float: right; color: #000000; font-family: \'Open Sans\', Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: #ffffff; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\">&nbsp;</div>\n<div style=\"margin: 0px 14.3958px 0px 28.7917px; padding: 0px; width: 436.792px; text-align: left; float: left; color: #000000; font-family: \'Open Sans\', Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: #ffffff; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\">\n<p style=\"margin: 0px 0px 15px; padding: 0px; text-align: justify;\"><strong style=\"margin: 0px; padding: 0px;\">Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\n</div>','<div style=\"margin: 0px 28.7917px 0px 14.3958px; padding: 0px; width: 436.792px; text-align: left; float: right; color: #000000; font-family: \'Open Sans\', Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: #ffffff; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\">&nbsp;</div>\n<div style=\"margin: 0px 14.3958px 0px 28.7917px; padding: 0px; width: 436.792px; text-align: left; float: left; color: #000000; font-family: \'Open Sans\', Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: #ffffff; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\">\n<p style=\"margin: 0px 0px 15px; padding: 0px; text-align: justify;\"><strong style=\"margin: 0px; padding: 0px;\">Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\n</div>','<div style=\"margin: 0px 28.7917px 0px 14.3958px; padding: 0px; width: 436.792px; text-align: left; float: right; color: #000000; font-family: \'Open Sans\', Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: #ffffff; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\">&nbsp;</div>\n<div style=\"margin: 0px 14.3958px 0px 28.7917px; padding: 0px; width: 436.792px; text-align: left; float: left; color: #000000; font-family: \'Open Sans\', Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: #ffffff; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\">\n<p style=\"margin: 0px 0px 15px; padding: 0px; text-align: justify;\"><strong style=\"margin: 0px; padding: 0px;\">Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\n</div>','2023-08-07 16:43:56','2023-08-07 16:43:56',NULL,2,4,1,2,5,4,5,5,3,5,4,2,1);

--
-- Table structure for table `countries`
--

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

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES (1,'Democratic Republic of Congo','DRC','2023-08-08 05:40:00','2023-08-08 05:40:00',NULL),(2,'Congo Brazaville','COG','2023-08-08 05:41:02','2023-08-08 05:41:02',NULL),(3,'Cote d’Ivoire','CIV','2023-08-08 05:41:07','2023-08-08 05:42:53',NULL),(4,'Cameroon','CMR','2023-08-08 05:41:39','2023-08-08 05:41:39',NULL),(5,'Uganda','UG','2023-08-08 05:43:08','2023-08-08 05:43:08',NULL);

--
-- Table structure for table `crecs`
--

CREATE TABLE `crecs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `experience_in_health_id` bigint unsigned DEFAULT NULL,
  `Strategic_communications_planning_id` bigint unsigned DEFAULT NULL,
  `media_environments_id` bigint unsigned DEFAULT NULL,
  `media_comms_content_id` bigint unsigned DEFAULT NULL,
  `graphic_design_id` bigint unsigned DEFAULT NULL,
  `social_media_web_contnet_id` bigint unsigned DEFAULT NULL,
  `comms_field_deployment_id` bigint unsigned DEFAULT NULL,
  `adience_analysis_strategies_id` bigint unsigned DEFAULT NULL,
  `community_engagement_id` bigint unsigned DEFAULT NULL,
  `CHES_MCHES_id` bigint unsigned DEFAULT NULL,
  `health_education_comms_prog_id` bigint unsigned DEFAULT NULL,
  `CERC_participation_id` bigint unsigned DEFAULT NULL,
  `CERC_Trainer_id` bigint unsigned DEFAULT NULL,
  `political_Experience_id` bigint unsigned DEFAULT NULL,
  `intervener_content_hearing_id` bigint unsigned DEFAULT NULL,
  `stakeholder_organisation_id` bigint unsigned DEFAULT NULL,
  `response_risk_responsibility_id` bigint unsigned DEFAULT NULL,
  `decision_memos_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `experience_in_health_id_fk_7700718` (`experience_in_health_id`),
  KEY `Strategic_communications_planning_id_fk_7700719` (`Strategic_communications_planning_id`),
  KEY `media_environments_id_fk_7700720` (`media_environments_id`),
  KEY `media_comms_content_id_fk_7700721` (`media_comms_content_id`),
  KEY `graphic_design_id_fk_7700722` (`graphic_design_id`),
  KEY `social_media_web_contnet_id_fk_7700723` (`social_media_web_contnet_id`),
  KEY `comms_field_deployment_id_fk_7700724` (`comms_field_deployment_id`),
  KEY `adience_analysis_strategies_id_fk_7700725` (`adience_analysis_strategies_id`),
  KEY `community_engagement_id_fk_7700726` (`community_engagement_id`),
  KEY `CHES_MCHES_id_fk_7700727` (`CHES_MCHES_id`),
  KEY `health_education_comms_prog_id_fk_7700728` (`health_education_comms_prog_id`),
  KEY `CERC_participation_id_fk_7700729` (`CERC_participation_id`),
  KEY `CERC_Trainer_id_fk_7700730` (`CERC_Trainer_id`),
  KEY `political_Experience_id_fk_7700731` (`political_Experience_id`),
  KEY `intervener_content_hearing_id_fk_7700732` (`intervener_content_hearing_id`),
  KEY `stakeholder_organisation_id_fk_7700733` (`stakeholder_organisation_id`),
  KEY `response_risk_responsibility_id_fk_7700734` (`response_risk_responsibility_id`),
  KEY `decision_memos_id_fk_7700734` (`decision_memos_id`),
  KEY `user_fk_8664218` (`user_id`),
  CONSTRAINT `adience_analysis_strategies_id_fk_7700725` FOREIGN KEY (`adience_analysis_strategies_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `CERC_participation_id_fk_7700729` FOREIGN KEY (`CERC_participation_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `CERC_Trainer_id_fk_7700730` FOREIGN KEY (`CERC_Trainer_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `CHES_MCHES_id_fk_7700727` FOREIGN KEY (`CHES_MCHES_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `comms_field_deployment_id_fk_7700724` FOREIGN KEY (`comms_field_deployment_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `community_engagement_id_fk_7700726` FOREIGN KEY (`community_engagement_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `decision_memos_id_fk_7700734` FOREIGN KEY (`decision_memos_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `experience_in_health_id_fk_7700718` FOREIGN KEY (`experience_in_health_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `graphic_design_id_fk_7700722` FOREIGN KEY (`graphic_design_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `health_education_comms_prog_id_fk_7700728` FOREIGN KEY (`health_education_comms_prog_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `intervener_content_hearing_id_fk_7700732` FOREIGN KEY (`intervener_content_hearing_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `media_comms_content_id_fk_7700721` FOREIGN KEY (`media_comms_content_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `media_environments_id_fk_7700720` FOREIGN KEY (`media_environments_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `political_Experience_id_fk_7700731` FOREIGN KEY (`political_Experience_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `response_risk_responsibility_id_fk_7700734` FOREIGN KEY (`response_risk_responsibility_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `social_media_web_contnet_id_fk_7700723` FOREIGN KEY (`social_media_web_contnet_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `stakeholder_organisation_id_fk_7700733` FOREIGN KEY (`stakeholder_organisation_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `Strategic_communications_planning_id_fk_7700719` FOREIGN KEY (`Strategic_communications_planning_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `user_fk_8664218` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `crecs`
--

INSERT INTO `crecs` VALUES (1,'2023-08-07 07:57:34','2023-08-07 08:02:44',NULL,3,3,3,3,2,4,5,5,4,4,4,5,3,4,2,1,2,5,3),(2,'2023-08-07 09:14:54','2023-08-07 09:14:54',NULL,4,5,5,5,5,2,1,4,1,5,5,4,5,4,4,2,4,1,2);

--
-- Table structure for table `data_managements`
--

CREATE TABLE `data_managements` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `please_specify_other_software` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `quantitative_data_id` bigint unsigned DEFAULT NULL,
  `excel_id` bigint unsigned DEFAULT NULL,
  `access_id` bigint unsigned DEFAULT NULL,
  `sas_id` bigint unsigned DEFAULT NULL,
  `spss_id` bigint unsigned DEFAULT NULL,
  `status_id` bigint unsigned DEFAULT NULL,
  `r_id` bigint unsigned DEFAULT NULL,
  `epi_info_id` bigint unsigned DEFAULT NULL,
  `monitoring_database_id` bigint unsigned DEFAULT NULL,
  `qualitative_data_id` bigint unsigned DEFAULT NULL,
  `data_visualization_id` bigint unsigned DEFAULT NULL,
  `geographic_information_system_gis_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `quantitative_data_fk_7663174` (`quantitative_data_id`),
  KEY `excel_fk_7663175` (`excel_id`),
  KEY `access_fk_7663176` (`access_id`),
  KEY `sas_fk_7663177` (`sas_id`),
  KEY `spss_fk_7663178` (`spss_id`),
  KEY `status_fk_7663179` (`status_id`),
  KEY `r_fk_7663180` (`r_id`),
  KEY `epi_info_fk_7663181` (`epi_info_id`),
  KEY `monitoring_database_fk_7663182` (`monitoring_database_id`),
  KEY `qualitative_data_fk_7663183` (`qualitative_data_id`),
  KEY `data_visualization_fk_7663184` (`data_visualization_id`),
  KEY `geographic_information_system_gis_fk_7663185` (`geographic_information_system_gis_id`),
  KEY `user_fk_7664209` (`user_id`),
  CONSTRAINT `access_fk_7663176` FOREIGN KEY (`access_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `data_visualization_fk_7663184` FOREIGN KEY (`data_visualization_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `epi_info_fk_7663181` FOREIGN KEY (`epi_info_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `excel_fk_7663175` FOREIGN KEY (`excel_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `geographic_information_system_gis_fk_7663185` FOREIGN KEY (`geographic_information_system_gis_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `monitoring_database_fk_7663182` FOREIGN KEY (`monitoring_database_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `qualitative_data_fk_7663183` FOREIGN KEY (`qualitative_data_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `quantitative_data_fk_7663174` FOREIGN KEY (`quantitative_data_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `r_fk_7663180` FOREIGN KEY (`r_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `sas_fk_7663177` FOREIGN KEY (`sas_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `spss_fk_7663178` FOREIGN KEY (`spss_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `status_fk_7663179` FOREIGN KEY (`status_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `user_fk_7664209` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `data_managements`
--

INSERT INTO `data_managements` VALUES (1,'<p>test</p>','2023-08-08 02:51:42','2023-08-08 02:51:42',NULL,3,1,3,3,1,2,1,4,4,4,2,2,1);

--
-- Table structure for table `deployment_application_user`
--

CREATE TABLE `deployment_application_user` (
  `user_id` bigint unsigned NOT NULL,
  `deployment_application_id` bigint unsigned NOT NULL,
  KEY `user_id_fk_81520231` (`user_id`),
  KEY `deployment_application_id_fk_7617740` (`deployment_application_id`),
  CONSTRAINT `deployment_application_id_fk_7617740` FOREIGN KEY (`deployment_application_id`) REFERENCES `deployment_applications` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_id_fk_81520231` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `deployment_application_user`
--

INSERT INTO `deployment_application_user` VALUES (2,2),(2,1),(1,1),(1,2),(3,2),(1,4),(3,4);

--
-- Table structure for table `deployment_applications`
--

CREATE TABLE `deployment_applications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `deployment_opportunity_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `deployment_opp_fk_7800632` (`deployment_opportunity_id`),
  KEY `user_fk_67874659948826` (`user_id`),
  CONSTRAINT `deployment_opp_fk_7800632` FOREIGN KEY (`deployment_opportunity_id`) REFERENCES `deployment_opportunities` (`id`),
  CONSTRAINT `user_fk_67874659948826` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `deployment_applications`
--

INSERT INTO `deployment_applications` VALUES (1,'Approved',2,1,'2023-08-14 09:44:06','2023-08-15 05:12:14',NULL),(2,'Approved',1,2,'2023-08-15 05:04:42','2023-08-15 07:26:34',NULL),(3,'pending',2,3,'2023-08-15 07:24:34','2023-08-15 07:26:51',NULL),(4,'Pending',3,3,'2023-08-15 07:58:58','2023-08-15 07:58:58',NULL),(5,'pending',3,1,'2023-08-15 07:59:33','2023-08-15 07:59:33',NULL);

--
-- Table structure for table `deployment_opportunities`
--

CREATE TABLE `deployment_opportunities` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `posting_number` int DEFAULT NULL,
  `event_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deployer_position_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expected_deployment_start_date` date DEFAULT NULL,
  `actual_deployment_start_date` date DEFAULT NULL,
  `expected_deployment_end_date` date DEFAULT NULL,
  `actual_deployment_end_date` date DEFAULT NULL,
  `number_of_deployers` int DEFAULT NULL,
  `location_city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `language_required` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `region_id` bigint unsigned DEFAULT NULL,
  `logistics_administrator_id` bigint unsigned DEFAULT NULL,
  `location_province_region_id` bigint unsigned DEFAULT NULL,
  `request_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `region_fk_7665807` (`region_id`),
  KEY `logistics_administrator_fk_7665814` (`logistics_administrator_id`),
  KEY `location_province_region_fk_7665829` (`location_province_region_id`),
  KEY `request_fk_7700644` (`request_id`),
  CONSTRAINT `location_province_region_fk_7665829` FOREIGN KEY (`location_province_region_id`) REFERENCES `regions` (`id`),
  CONSTRAINT `logistics_administrator_fk_7665814` FOREIGN KEY (`logistics_administrator_id`) REFERENCES `users` (`id`),
  CONSTRAINT `region_fk_7665807` FOREIGN KEY (`region_id`) REFERENCES `regions` (`id`),
  CONSTRAINT `request_fk_7700644` FOREIGN KEY (`request_id`) REFERENCES `request_databases` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `deployment_opportunities`
--

INSERT INTO `deployment_opportunities` VALUES (1,486,'Griffin Coleman','Natus esse illo non necessitatibus eum neque autem omnis impedit nostrud laborum','1979-07-14','1984-06-26','1996-04-05','2001-01-24',749,'Non qui eveniet nemo mollitia atque qui omnis vel quo porro in dolorem nostrud deserunt inventore assumenda','Consequatur Distinc','2023-08-14 06:52:37','2023-08-14 06:52:44',NULL,NULL,1,4,1),(2,536,'Garrison Wolfe','Ex sunt aut non sed aut dolorum nostrum delectus Nam quaerat minim voluptas quia autem nesciunt quis ratione','2019-04-06','1978-01-03','1976-09-26','2015-05-16',840,'Numquam quia sequi iure nihil laboriosam quo in aut non voluptatibus dignissimos maxime consectetur doloremque necessitatibus dolores','Rem et lorem illo es','2023-08-14 06:53:07','2023-08-14 06:53:07',NULL,NULL,1,11,3),(3,775,'Arthur Booth 321','Quaerat qui doloribus velit et omnis eos sunt numquam sunt itaque','1994-01-30','2018-02-19','1999-08-19','1998-04-11',861,'Totam et elit aperiam quaerat hic facilis aute et anim in eligendi quidem impedit commodo anim','Sunt elit qui Nam l','2023-08-15 07:58:03','2023-08-15 07:58:03',NULL,NULL,3,16,1);

--
-- Table structure for table `disease_emergencies`
--

CREATE TABLE `disease_emergencies` (
  `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,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `disease_emergencies_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `disease_emergencies`
--

INSERT INTO `disease_emergencies` VALUES (1,'	Cholera','2023-08-06 09:12:11','2023-08-06 09:13:39','2023-08-06 09:13:39'),(2,'Yellow fever','2023-08-06 09:12:19','2023-08-06 09:13:39','2023-08-06 09:13:39'),(3,'	Rage','2023-08-06 09:12:24','2023-08-06 09:13:39','2023-08-06 09:13:39'),(4,'Ebola','2023-08-06 09:12:29','2023-08-06 09:13:39','2023-08-06 09:13:39'),(5,'Meningitis','2023-08-06 09:12:33','2023-08-06 09:13:39','2023-08-06 09:13:39'),(6,'Hepatitis B','2023-08-06 09:12:37','2023-08-06 09:13:39','2023-08-06 09:13:39'),(7,'	Hepatitis A','2023-08-06 09:12:42','2023-08-06 09:13:39','2023-08-06 09:13:39'),(8,'	Complex Emergency','2023-08-06 09:14:06','2023-08-06 09:14:06',NULL),(9,'Forest fire risk','2023-08-06 09:14:10','2023-08-06 09:14:10',NULL),(10,'	Volcanic activity','2023-08-06 09:14:14','2023-08-06 09:14:14',NULL),(11,'	Landslides','2023-08-06 09:14:18','2023-08-06 09:14:18',NULL),(12,'Flooding','2023-08-06 09:14:21','2023-08-06 09:14:21',NULL),(13,'Earthquake','2023-08-06 09:14:28','2023-08-06 09:14:28',NULL),(14,'Drought','2023-08-06 09:14:33','2023-08-06 09:14:33',NULL),(15,'Zika','2023-08-06 09:14:37','2023-08-06 09:14:37',NULL),(16,'	Rift Valley Fever','2023-08-06 09:14:48','2023-08-06 09:14:48',NULL),(17,'Monkeypox','2023-08-06 09:14:53','2023-08-06 09:14:53',NULL),(18,'Polio','2023-08-06 09:14:57','2023-08-06 09:14:57',NULL),(19,'	Fish','2023-08-06 09:15:00','2023-08-06 09:15:00',NULL),(20,'	Meningitis','2023-08-06 09:15:04','2023-08-06 09:15:04',NULL),(21,'	Measles','2023-08-06 09:15:07','2023-08-06 09:15:07',NULL),(22,'	Influenza','2023-08-06 09:15:14','2023-08-06 09:15:14',NULL),(23,'MV Ebola','2023-08-06 09:15:18','2023-08-06 09:15:18',NULL),(24,'Cholera','2023-08-06 09:15:21','2023-08-06 09:15:21',NULL),(25,'COVID-19','2023-08-06 09:15:26','2023-08-06 09:15:26',NULL);

--
-- Table structure for table `emergency_logistics`
--

CREATE TABLE `emergency_logistics` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `shipping_and_receiving_id` bigint unsigned DEFAULT NULL,
  `sample_packaging_id` bigint unsigned DEFAULT NULL,
  `inventory_management_id` bigint unsigned DEFAULT NULL,
  `travel_coordinator_id` bigint unsigned DEFAULT NULL,
  `fleet_management_id` bigint unsigned DEFAULT NULL,
  `moving_resources_to_the_field_id` bigint unsigned DEFAULT NULL,
  `deployer_training_resources_id` bigint unsigned DEFAULT NULL,
  `eoc_logistics_emergency_operations_center_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `shipping_and_receiving_fk_7662568` (`shipping_and_receiving_id`),
  KEY `sample_packaging_fk_7662569` (`sample_packaging_id`),
  KEY `inventory_management_fk_7662570` (`inventory_management_id`),
  KEY `travel_coordinator_fk_7662571` (`travel_coordinator_id`),
  KEY `fleet_management_fk_7662572` (`fleet_management_id`),
  KEY `moving_resources_to_the_field_fk_7662573` (`moving_resources_to_the_field_id`),
  KEY `deployer_training_resources_fk_7662574` (`deployer_training_resources_id`),
  KEY `eoc_logistics_emergency_operations_center_fk_7662575` (`eoc_logistics_emergency_operations_center_id`),
  KEY `user_fk_7664208` (`user_id`),
  CONSTRAINT `deployer_training_resources_fk_7662574` FOREIGN KEY (`deployer_training_resources_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `eoc_logistics_emergency_operations_center_fk_7662575` FOREIGN KEY (`eoc_logistics_emergency_operations_center_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `fleet_management_fk_7662572` FOREIGN KEY (`fleet_management_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `inventory_management_fk_7662570` FOREIGN KEY (`inventory_management_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `moving_resources_to_the_field_fk_7662573` FOREIGN KEY (`moving_resources_to_the_field_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `sample_packaging_fk_7662569` FOREIGN KEY (`sample_packaging_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `shipping_and_receiving_fk_7662568` FOREIGN KEY (`shipping_and_receiving_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `travel_coordinator_fk_7662571` FOREIGN KEY (`travel_coordinator_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `user_fk_7664208` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `emergency_logistics`
--

INSERT INTO `emergency_logistics` VALUES (3,'2023-08-07 13:18:23','2023-08-07 13:18:23',NULL,5,2,4,2,3,4,4,1,3),(4,'2023-08-07 13:19:41','2023-08-07 13:19:41',NULL,1,3,4,5,1,3,1,4,1);

--
-- Table structure for table `emergency_responses`
--

CREATE TABLE `emergency_responses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `domestic_emergency_response_id` bigint unsigned DEFAULT NULL,
  `cross_sectoral_id` bigint unsigned DEFAULT NULL,
  `response_to_international_emergencies_id` bigint unsigned DEFAULT NULL,
  `eoc_ims_id` bigint unsigned DEFAULT NULL,
  `vaccination_campaigns_id` bigint unsigned DEFAULT NULL,
  `emergency_leadership_role_id` bigint unsigned DEFAULT NULL,
  `multi_sectoral_emergency_response_plans_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `domestic_emergency_response_fk_7700217` (`domestic_emergency_response_id`),
  KEY `cross_sectoral_fk_7700218` (`cross_sectoral_id`),
  KEY `response_to_international_emergencies_fk_7700219` (`response_to_international_emergencies_id`),
  KEY `eoc_ims_fk_7700220` (`eoc_ims_id`),
  KEY `vaccination_campaigns_fk_7700221` (`vaccination_campaigns_id`),
  KEY `emergency_leadership_role_fk_7700222` (`emergency_leadership_role_id`),
  KEY `multi_sectoral_emergency_response_plans_fk_7700223` (`multi_sectoral_emergency_response_plans_id`),
  KEY `user_fk_79659948824` (`user_id`),
  CONSTRAINT `cross_sectoral_fk_7700218` FOREIGN KEY (`cross_sectoral_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `domestic_emergency_response_fk_7700217` FOREIGN KEY (`domestic_emergency_response_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `emergency_leadership_role_fk_7700222` FOREIGN KEY (`emergency_leadership_role_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `eoc_ims_fk_7700220` FOREIGN KEY (`eoc_ims_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `multi_sectoral_emergency_response_plans_fk_7700223` FOREIGN KEY (`multi_sectoral_emergency_response_plans_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `response_to_international_emergencies_fk_7700219` FOREIGN KEY (`response_to_international_emergencies_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `user_fk_79659948824` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `vaccination_campaigns_fk_7700221` FOREIGN KEY (`vaccination_campaigns_id`) REFERENCES `training_levels` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `emergency_responses`
--

INSERT INTO `emergency_responses` VALUES (1,'2023-08-08 03:27:36','2023-08-08 03:27:36',NULL,1,4,1,1,3,5,1,1);

--
-- Table structure for table `experience_in_epidemiologies`
--

CREATE TABLE `experience_in_epidemiologies` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `rapid_risk_assessments_id` bigint unsigned DEFAULT NULL,
  `monitoring_system_id` bigint unsigned DEFAULT NULL,
  `epidemic_survey_id` bigint unsigned DEFAULT NULL,
  `determination_of_disease_status_id` bigint unsigned DEFAULT NULL,
  `contact_tracing_id` bigint unsigned DEFAULT NULL,
  `case_management_id` bigint unsigned DEFAULT NULL,
  `epidemiological_studies_id` bigint unsigned DEFAULT NULL,
  `study_protocols_id` bigint unsigned DEFAULT NULL,
  `data_collection_tools_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `rapid_risk_assessments_fk_7663365` (`rapid_risk_assessments_id`),
  KEY `monitoring_system_fk_7663366` (`monitoring_system_id`),
  KEY `epidemic_survey_fk_7663367` (`epidemic_survey_id`),
  KEY `determination_of_disease_status_fk_7663368` (`determination_of_disease_status_id`),
  KEY `contact_tracing_fk_7663369` (`contact_tracing_id`),
  KEY `case_management_fk_7663370` (`case_management_id`),
  KEY `epidemiological_studies_fk_7663371` (`epidemiological_studies_id`),
  KEY `study_protocols_fk_7663372` (`study_protocols_id`),
  KEY `data_collection_tools_fk_7663373` (`data_collection_tools_id`),
  KEY `user_fk_7664210` (`user_id`),
  CONSTRAINT `case_management_fk_7663370` FOREIGN KEY (`case_management_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `contact_tracing_fk_7663369` FOREIGN KEY (`contact_tracing_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `data_collection_tools_fk_7663373` FOREIGN KEY (`data_collection_tools_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `determination_of_disease_status_fk_7663368` FOREIGN KEY (`determination_of_disease_status_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `epidemic_survey_fk_7663367` FOREIGN KEY (`epidemic_survey_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `epidemiological_studies_fk_7663371` FOREIGN KEY (`epidemiological_studies_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `monitoring_system_fk_7663366` FOREIGN KEY (`monitoring_system_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `rapid_risk_assessments_fk_7663365` FOREIGN KEY (`rapid_risk_assessments_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `study_protocols_fk_7663372` FOREIGN KEY (`study_protocols_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `user_fk_7664210` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `experience_in_epidemiologies`
--

INSERT INTO `experience_in_epidemiologies` VALUES (1,'2023-08-08 03:37:33','2023-08-08 03:37:33',NULL,1,1,5,3,2,1,3,2,2,1);

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `hazardous_materials_experiences`
--

CREATE TABLE `hazardous_materials_experiences` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `certified_hazardous_materials_manager_chmm_id` bigint unsigned DEFAULT NULL,
  `certified_industrial_hygienist_cih_id` bigint unsigned DEFAULT NULL,
  `hazmat_specialist_training_id` bigint unsigned DEFAULT NULL,
  `record_keeping_id` bigint unsigned DEFAULT NULL,
  `hazardous_materials_management_y_n_program_id` bigint unsigned DEFAULT NULL,
  `medical_waste_plans_id` bigint unsigned DEFAULT NULL,
  `spill_response_plans_id` bigint unsigned DEFAULT NULL,
  `hazardous_waste_reduction_plans_id` bigint unsigned DEFAULT NULL,
  `hazardous_waste_contingency_plans_id` bigint unsigned DEFAULT NULL,
  `stormwater_y_n_plans_id` bigint unsigned DEFAULT NULL,
  `occupational_health_and_safety_y_n_programs_id` bigint unsigned DEFAULT NULL,
  `radiation_protection_plan_id` bigint unsigned DEFAULT NULL,
  `collection_hazardous_waste_id` bigint unsigned DEFAULT NULL,
  `training_others_on_hazardous_waste_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `certified_hazardous_materials_manager_chmm_fk_7700486` (`certified_hazardous_materials_manager_chmm_id`),
  KEY `certified_industrial_hygienist_cih_fk_7700487` (`certified_industrial_hygienist_cih_id`),
  KEY `hazmat_specialist_training_fk_7700488` (`hazmat_specialist_training_id`),
  KEY `record_keeping_fk_7700489` (`record_keeping_id`),
  KEY `hazardous_materials_management_y_n_program_fk_7700490` (`hazardous_materials_management_y_n_program_id`),
  KEY `medical_waste_plans_fk_7700491` (`medical_waste_plans_id`),
  KEY `spill_response_plans_fk_7700492` (`spill_response_plans_id`),
  KEY `hazardous_waste_reduction_plans_fk_7700493` (`hazardous_waste_reduction_plans_id`),
  KEY `hazardous_waste_contingency_plans_fk_7700494` (`hazardous_waste_contingency_plans_id`),
  KEY `stormwater_y_n_plans_fk_7700495` (`stormwater_y_n_plans_id`),
  KEY `occupational_health_and_safety_y_n_programs_fk_7700496` (`occupational_health_and_safety_y_n_programs_id`),
  KEY `radiation_protection_plan_fk_7700497` (`radiation_protection_plan_id`),
  KEY `collection_hazardous_waste_fk_7700498` (`collection_hazardous_waste_id`),
  KEY `training_others_on_hazardous_waste_fk_7700499` (`training_others_on_hazardous_waste_id`),
  KEY `user_fk_74659948826` (`user_id`),
  CONSTRAINT `certified_hazardous_materials_manager_chmm_fk_7700486` FOREIGN KEY (`certified_hazardous_materials_manager_chmm_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `certified_industrial_hygienist_cih_fk_7700487` FOREIGN KEY (`certified_industrial_hygienist_cih_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `collection_hazardous_waste_fk_7700498` FOREIGN KEY (`collection_hazardous_waste_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `hazardous_materials_management_y_n_program_fk_7700490` FOREIGN KEY (`hazardous_materials_management_y_n_program_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `hazardous_waste_contingency_plans_fk_7700494` FOREIGN KEY (`hazardous_waste_contingency_plans_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `hazardous_waste_reduction_plans_fk_7700493` FOREIGN KEY (`hazardous_waste_reduction_plans_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `hazmat_specialist_training_fk_7700488` FOREIGN KEY (`hazmat_specialist_training_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `medical_waste_plans_fk_7700491` FOREIGN KEY (`medical_waste_plans_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `occupational_health_and_safety_y_n_programs_fk_7700496` FOREIGN KEY (`occupational_health_and_safety_y_n_programs_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `radiation_protection_plan_fk_7700497` FOREIGN KEY (`radiation_protection_plan_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `record_keeping_fk_7700489` FOREIGN KEY (`record_keeping_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `spill_response_plans_fk_7700492` FOREIGN KEY (`spill_response_plans_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `stormwater_y_n_plans_fk_7700495` FOREIGN KEY (`stormwater_y_n_plans_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `training_others_on_hazardous_waste_fk_7700499` FOREIGN KEY (`training_others_on_hazardous_waste_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `user_fk_74659948826` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hazardous_materials_experiences`
--

INSERT INTO `hazardous_materials_experiences` VALUES (1,'2023-08-08 03:44:20','2023-08-08 03:44:20',NULL,1,2,2,4,2,4,4,4,2,5,3,5,3,2,1),(2,'2023-08-08 03:45:34','2023-08-08 03:45:34',NULL,2,5,3,2,2,3,3,1,5,5,2,4,3,1,2);

--
-- Table structure for table `infection_prevent_controls`
--

CREATE TABLE `infection_prevent_controls` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `in_healthcare_settings_id` bigint unsigned DEFAULT NULL,
  `in_a_non_medical_id` bigint unsigned DEFAULT NULL,
  `outbreak_investigations_id` bigint unsigned DEFAULT NULL,
  `facility_assessments_id` bigint unsigned DEFAULT NULL,
  `developing_infection_prevention_id` bigint unsigned DEFAULT NULL,
  `infection_prevention_and_control_id` bigint unsigned DEFAULT NULL,
  `quality_improvement_id` bigint unsigned DEFAULT NULL,
  `ppe_id` bigint unsigned DEFAULT NULL,
  `point_of_entry_border_health_id` bigint unsigned DEFAULT NULL,
  `poc_non_border_id` bigint unsigned DEFAULT NULL,
  `rsi_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `in_healthcare_settings_fk_7700166` (`in_healthcare_settings_id`),
  KEY `in_a_non_medical_fk_7700167` (`in_a_non_medical_id`),
  KEY `outbreak_investigations_fk_7700168` (`outbreak_investigations_id`),
  KEY `facility_assessments_fk_7700169` (`facility_assessments_id`),
  KEY `developing_infection_prevention_fk_7700170` (`developing_infection_prevention_id`),
  KEY `infection_prevention_and_control_fk_7700171` (`infection_prevention_and_control_id`),
  KEY `quality_improvement_fk_7700172` (`quality_improvement_id`),
  KEY `ppe_fk_7700173` (`ppe_id`),
  KEY `point_of_entry_border_health_fk_7700174` (`point_of_entry_border_health_id`),
  KEY `poc_non_border_fk_7700175` (`poc_non_border_id`),
  KEY `rsi_fk_7700176` (`rsi_id`),
  KEY `user_fk_77659948823` (`user_id`),
  CONSTRAINT `developing_infection_prevention_fk_7700170` FOREIGN KEY (`developing_infection_prevention_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `facility_assessments_fk_7700169` FOREIGN KEY (`facility_assessments_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `in_a_non_medical_fk_7700167` FOREIGN KEY (`in_a_non_medical_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `in_healthcare_settings_fk_7700166` FOREIGN KEY (`in_healthcare_settings_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `infection_prevention_and_control_fk_7700171` FOREIGN KEY (`infection_prevention_and_control_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `outbreak_investigations_fk_7700168` FOREIGN KEY (`outbreak_investigations_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `poc_non_border_fk_7700175` FOREIGN KEY (`poc_non_border_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `point_of_entry_border_health_fk_7700174` FOREIGN KEY (`point_of_entry_border_health_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `ppe_fk_7700173` FOREIGN KEY (`ppe_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `quality_improvement_fk_7700172` FOREIGN KEY (`quality_improvement_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `rsi_fk_7700176` FOREIGN KEY (`rsi_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `user_fk_77659948823` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `infection_prevent_controls`
--

INSERT INTO `infection_prevent_controls` VALUES (1,'2023-08-08 03:48:07','2023-08-08 03:48:07',NULL,5,3,1,3,4,2,3,1,5,3,4,2);

--
-- Table structure for table `laboratory_experiences`
--

CREATE TABLE `laboratory_experiences` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `biosafety_experience_id` bigint unsigned DEFAULT NULL,
  `laboratory_quality_management_id` bigint unsigned DEFAULT NULL,
  `sample_reception_and_acquisition_id` bigint unsigned DEFAULT NULL,
  `sample_transport_id` bigint unsigned DEFAULT NULL,
  `antimicrobial_id` bigint unsigned DEFAULT NULL,
  `parasitology_id` bigint unsigned DEFAULT NULL,
  `mycology_id` bigint unsigned DEFAULT NULL,
  `clinical_chemistry_id` bigint unsigned DEFAULT NULL,
  `blood_bank_id` bigint unsigned DEFAULT NULL,
  `molecular_methods_id` bigint unsigned DEFAULT NULL,
  `advanced_molecular_detection_dma_id` bigint unsigned DEFAULT NULL,
  `viral_culture_id` bigint unsigned DEFAULT NULL,
  `serology_id` bigint unsigned DEFAULT NULL,
  `bsl_3_id` bigint unsigned DEFAULT NULL,
  `bacterial_culture_id` bigint unsigned DEFAULT NULL,
  `phlebotomy_venipuncture_id` bigint unsigned DEFAULT NULL,
  `laboratory_training_instructor_id` bigint unsigned DEFAULT NULL,
  `laboratory_supervisor_experience_id` bigint unsigned DEFAULT NULL,
  `laboratory_field_intervention_coordinator_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_fk_7665994` (`user_id`),
  KEY `biosafety_experience_fk_7665995` (`biosafety_experience_id`),
  KEY `laboratory_quality_management_fk_7665996` (`laboratory_quality_management_id`),
  KEY `sample_reception_and_acquisition_fk_7665997` (`sample_reception_and_acquisition_id`),
  KEY `sample_transport_fk_7665998` (`sample_transport_id`),
  KEY `antimicrobial_fk_7665999` (`antimicrobial_id`),
  KEY `parasitology_fk_7666000` (`parasitology_id`),
  KEY `mycology_fk_7666001` (`mycology_id`),
  KEY `clinical_chemistry_fk_7666002` (`clinical_chemistry_id`),
  KEY `blood_bank_fk_7666003` (`blood_bank_id`),
  KEY `molecular_methods_fk_7666004` (`molecular_methods_id`),
  KEY `advanced_molecular_detection_dma_fk_7666005` (`advanced_molecular_detection_dma_id`),
  KEY `viral_culture_fk_7666006` (`viral_culture_id`),
  KEY `serology_fk_7666007` (`serology_id`),
  KEY `bsl_3_fk_7666008` (`bsl_3_id`),
  KEY `bacterial_culture_fk_7666009` (`bacterial_culture_id`),
  KEY `phlebotomy_venipuncture_fk_7666010` (`phlebotomy_venipuncture_id`),
  KEY `laboratory_training_instructor_fk_7666011` (`laboratory_training_instructor_id`),
  KEY `laboratory_supervisor_experience_fk_7666012` (`laboratory_supervisor_experience_id`),
  KEY `laboratory_field_intervention_coordinator_fk_7666013` (`laboratory_field_intervention_coordinator_id`),
  CONSTRAINT `advanced_molecular_detection_dma_fk_7666005` FOREIGN KEY (`advanced_molecular_detection_dma_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `antimicrobial_fk_7665999` FOREIGN KEY (`antimicrobial_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `bacterial_culture_fk_7666009` FOREIGN KEY (`bacterial_culture_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `biosafety_experience_fk_7665995` FOREIGN KEY (`biosafety_experience_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `blood_bank_fk_7666003` FOREIGN KEY (`blood_bank_id`) REFERENCES `agency_roles` (`id`),
  CONSTRAINT `bsl_3_fk_7666008` FOREIGN KEY (`bsl_3_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `clinical_chemistry_fk_7666002` FOREIGN KEY (`clinical_chemistry_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `laboratory_field_intervention_coordinator_fk_7666013` FOREIGN KEY (`laboratory_field_intervention_coordinator_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `laboratory_quality_management_fk_7665996` FOREIGN KEY (`laboratory_quality_management_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `laboratory_supervisor_experience_fk_7666012` FOREIGN KEY (`laboratory_supervisor_experience_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `laboratory_training_instructor_fk_7666011` FOREIGN KEY (`laboratory_training_instructor_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `molecular_methods_fk_7666004` FOREIGN KEY (`molecular_methods_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `mycology_fk_7666001` FOREIGN KEY (`mycology_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `parasitology_fk_7666000` FOREIGN KEY (`parasitology_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `phlebotomy_venipuncture_fk_7666010` FOREIGN KEY (`phlebotomy_venipuncture_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `sample_reception_and_acquisition_fk_7665997` FOREIGN KEY (`sample_reception_and_acquisition_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `sample_transport_fk_7665998` FOREIGN KEY (`sample_transport_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `serology_fk_7666007` FOREIGN KEY (`serology_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `user_fk_7665994` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `viral_culture_fk_7666006` FOREIGN KEY (`viral_culture_id`) REFERENCES `training_levels` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `laboratory_experiences`
--

INSERT INTO `laboratory_experiences` VALUES (2,'2023-08-08 03:52:39','2023-08-08 03:52:39',NULL,2,4,1,3,2,3,4,1,4,7,1,3,3,1,1,5,4,4,2,1);

--
-- 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=76 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_reset_tokens_table',1),(3,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2019_12_14_000001_create_personal_access_tokens_table',1),(5,'2022_12_01_000007_create_agency_roles_table',1),(6,'2022_12_01_000009_create_training_levels_table',1),(7,'2022_12_01_000018_create_vaccinationations_table',1),(8,'2022_12_01_000019_create_rrt_trainings_table',1),(9,'2022_12_01_000021_create_regions_table',1),(10,'2022_12_01_000026_create_disease_emergencies_table',1),(11,'2022_12_01_000029_create_months_table',1),(12,'2022_12_01_000030_create_requesters_table',1),(13,'2022_12_01_000031_create_request_types_table',1),(14,'2022_12_01_000032_create_rrt_roles_table',1),(15,'2022_12_01_000018_create_vaccinations_table',2),(16,'2022_12_01_000011_create_psychosocial_experiences_table',3),(17,'2022_12_01_000044_add_relationship_fields_to_psychosocial_experiences_table',3),(18,'2023_08_07_081454_create_permission_tables',4),(19,'2023_08_07_090928_create_crecs_table',5),(20,'2023_08_07_090928_add_relationship_fields_to_crecs_table',6),(23,'2022_12_01_000013_create_data_managements_table',9),(24,'2022_12_01_000014_create_experience_in_epidemiologies_table',10),(25,'2022_12_01_000015_create_case_managements_table',11),(26,'2022_12_01_000016_create_nutrition_experiences_table',12),(27,'2022_12_01_000022_create_laboratory_experiences_table',13),(32,'2022_12_01_000046_add_relationship_fields_to_data_managements_table',18),(33,'2022_12_01_000047_add_relationship_fields_to_experience_in_epidemiologies_table',19),(34,'2022_12_01_000048_add_relationship_fields_to_case_managements_table',20),(35,'2022_12_01_000049_add_relationship_fields_to_nutrition_experiences_table',21),(36,'2022_12_01_000052_add_relationship_fields_to_laboratory_experiences_table',22),(43,'2022_12_01_000024_create_water_sanitation_hygiene_washes_table',27),(44,'2022_12_01_000025_create_emergency_responses_table',28),(45,'2022_12_01_000027_create_hazardous_materials_experiences_table',29),(46,'2022_12_01_000023_create_infection_prevent_controls_table',30),(48,'2022_12_01_000057_add_relationship_fields_to_security_manager_experiences_table',32),(49,'2022_12_01_000056_add_relationship_fields_to_hazardous_materials_experiences_table',33),(50,'2022_12_01_000054_add_relationship_fields_to_water_sanitation_hygiene_washes_table',34),(51,'2022_12_01_000053_add_relationship_fields_to_infection_prevent_controls_table',35),(52,'2022_12_01_000055_add_relationship_fields_to_emergency_responses_table',36),(53,'2022_12_01_000006_create_registers_table',37),(54,'2022_12_01_000005_create_countries_table',38),(55,'2022_12_01_000008_create_qualifications_table',39),(56,'2022_12_01_000049_add_relationship_fields_to_qualification_table',40),(59,'2022_12_01_000017_create_readiness_and_rt_members_table',43),(60,'2022_12_01_000050_add_relationship_fields_to_readiness_and_rt_members_table',44),(63,'2022_12_01_000033_create_request_databases_table',45),(64,'2022_12_01_000058_add_relationship_fields_to_request_databases_table',46),(68,'2022_12_01_000020_create_deployment_opportunities_table',47),(69,'2022_12_01_000051_add_relationship_fields_to_deployment_opportunities_table',48),(72,'2023_08_14_092326_create_deployment_applications',49),(74,'2023_08_15_100816_create_request_database_request_type',50),(75,'2023_08_15_102137_deployment_application_user',51);

--
-- 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',3);

--
-- Table structure for table `months`
--

CREATE TABLE `months` (
  `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,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `months_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `months`
--

INSERT INTO `months` VALUES (1,'January','2023-08-06 09:15:35','2023-08-06 09:15:35',NULL),(2,'February','2023-08-06 09:15:41','2023-08-06 09:15:41',NULL),(3,'March','2023-08-06 09:15:46','2023-08-06 09:15:46',NULL),(4,'April','2023-08-06 09:15:50','2023-08-06 09:15:50',NULL),(5,'May','2023-08-06 09:15:53','2023-08-06 09:15:53',NULL),(6,'June','2023-08-06 09:15:57','2023-08-06 09:15:57',NULL),(7,'July','2023-08-06 09:16:01','2023-08-06 09:16:01',NULL),(8,'August','2023-08-06 09:16:09','2023-08-06 09:16:09',NULL),(9,'September','2023-08-06 09:16:15','2023-08-06 09:16:15',NULL),(10,'October','2023-08-06 09:16:23','2023-08-06 09:16:23',NULL),(11,'November','2023-08-06 09:16:27','2023-08-06 09:16:27',NULL),(12,'December','2023-08-06 09:16:33','2023-08-06 09:16:33',NULL);

--
-- Table structure for table `nutrition_experiences`
--

CREATE TABLE `nutrition_experiences` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `certified` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `assessment_nutritional_status_of_population_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `assessment_nutritional_status_of_population_fk_7664190` (`assessment_nutritional_status_of_population_id`),
  KEY `user_fk_7664212` (`user_id`),
  CONSTRAINT `assessment_nutritional_status_of_population_fk_7664190` FOREIGN KEY (`assessment_nutritional_status_of_population_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `user_fk_7664212` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `nutrition_experiences`
--

INSERT INTO `nutrition_experiences` VALUES (3,'Yes','2023-08-08 04:08:37','2023-08-08 04:08:37',NULL,5,1),(4,'Yes','2023-08-08 09:06:08','2023-08-08 09:06:08',NULL,1,2);

--
-- 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `psychosocial_experiences`
--

CREATE TABLE `psychosocial_experiences` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `psychosocial_experience_id` bigint unsigned DEFAULT NULL,
  `licensee_id` bigint unsigned DEFAULT NULL,
  `psychiatrist_id` bigint unsigned DEFAULT NULL,
  `advisor_id` bigint unsigned DEFAULT NULL,
  `social_worker_id` bigint unsigned DEFAULT NULL,
  `trauma_based_therapy_id` bigint unsigned DEFAULT NULL,
  `cognitive_behavioural_therapy_id` bigint unsigned DEFAULT NULL,
  `psychodynamic_therapy_id` bigint unsigned DEFAULT NULL,
  `psychoanalytic_therapy_id` bigint unsigned DEFAULT NULL,
  `integrative_or_holistic_therapy_id` bigint unsigned DEFAULT NULL,
  `humanistic_therapy_id` bigint unsigned DEFAULT NULL,
  `pediatric_therapy_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `psychosocial_experience_fk_7662543` (`psychosocial_experience_id`),
  KEY `licensee_fk_7662544` (`licensee_id`),
  KEY `psychiatrist_fk_7662545` (`psychiatrist_id`),
  KEY `advisor_fk_7662546` (`advisor_id`),
  KEY `social_worker_fk_7662547` (`social_worker_id`),
  KEY `trauma_based_therapy_fk_7662548` (`trauma_based_therapy_id`),
  KEY `cognitive_behavioural_therapy_fk_7662549` (`cognitive_behavioural_therapy_id`),
  KEY `psychodynamic_therapy_fk_7662550` (`psychodynamic_therapy_id`),
  KEY `psychoanalytic_therapy_fk_7662551` (`psychoanalytic_therapy_id`),
  KEY `integrative_or_holistic_therapy_fk_7662552` (`integrative_or_holistic_therapy_id`),
  KEY `humanistic_therapy_fk_7662553` (`humanistic_therapy_id`),
  KEY `pediatric_therapy_fk_7662554` (`pediatric_therapy_id`),
  KEY `user_fk_7664207` (`user_id`),
  CONSTRAINT `advisor_fk_7662546` FOREIGN KEY (`advisor_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `cognitive_behavioural_therapy_fk_7662549` FOREIGN KEY (`cognitive_behavioural_therapy_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `humanistic_therapy_fk_7662553` FOREIGN KEY (`humanistic_therapy_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `integrative_or_holistic_therapy_fk_7662552` FOREIGN KEY (`integrative_or_holistic_therapy_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `licensee_fk_7662544` FOREIGN KEY (`licensee_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `pediatric_therapy_fk_7662554` FOREIGN KEY (`pediatric_therapy_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `psychiatrist_fk_7662545` FOREIGN KEY (`psychiatrist_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `psychoanalytic_therapy_fk_7662551` FOREIGN KEY (`psychoanalytic_therapy_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `psychodynamic_therapy_fk_7662550` FOREIGN KEY (`psychodynamic_therapy_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `psychosocial_experience_fk_7662543` FOREIGN KEY (`psychosocial_experience_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `social_worker_fk_7662547` FOREIGN KEY (`social_worker_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `trauma_based_therapy_fk_7662548` FOREIGN KEY (`trauma_based_therapy_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `user_fk_7664207` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `psychosocial_experiences`
--

INSERT INTO `psychosocial_experiences` VALUES (1,'2023-08-06 10:46:30','2023-08-06 10:46:30',NULL,NULL,1,4,3,4,3,2,1,4,4,4,3,1),(2,'2023-08-07 04:38:58','2023-08-07 04:38:58',NULL,NULL,1,1,2,1,1,3,2,2,1,1,1,1),(3,'2023-08-07 04:53:00','2023-08-07 04:53:00',NULL,NULL,4,4,2,3,4,1,1,1,3,1,1,2);

--
-- Table structure for table `qualifications`
--

CREATE TABLE `qualifications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `year_started` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year_completed` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `institute` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_fk_4567664212` (`user_id`),
  CONSTRAINT `user_fk_4567664212` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `qualifications`
--

INSERT INTO `qualifications` VALUES (2,'MSc. Medicine','2023-08-10','2023-08-18','Makerere Univ','2023-08-08 07:19:54','2023-08-08 07:19:54',NULL,1),(3,'BSc. Medicine','2023-08-01','2023-08-04','MAK','2023-08-08 07:25:45','2023-08-08 07:25:45',NULL,1);

--
-- Table structure for table `readiness_and_rt_member_vaccinationation`
--

CREATE TABLE `readiness_and_rt_member_vaccinationation` (
  `readiness_and_rt_member_id` bigint unsigned NOT NULL,
  `vaccinationation_id` bigint unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `readiness_and_rt_member_vaccinationation`
--


--
-- Table structure for table `readiness_and_rt_members`
--

CREATE TABLE `readiness_and_rt_members` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `training_1_date` date DEFAULT NULL,
  `training_1_expiration_date` date DEFAULT NULL,
  `training_2_date` date DEFAULT NULL,
  `training_2_expiration_date` date DEFAULT NULL,
  `training_3_date` date DEFAULT NULL,
  `training_3_expiration_date` date DEFAULT NULL,
  `training_4_date` date DEFAULT NULL,
  `training_4_expiration_date` date DEFAULT NULL,
  `upload_certified_rrt_training` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `upload_medical_certificate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `upload_certificate_of_physical_fitness` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_support_documents` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `training_1_id` bigint unsigned DEFAULT NULL,
  `training_2_id` bigint unsigned DEFAULT NULL,
  `trainings_3_id` bigint unsigned DEFAULT NULL,
  `training_4_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_fk_7664230` (`user_id`),
  KEY `training_1_fk_7664246` (`training_1_id`),
  KEY `training_2_fk_7664248` (`training_2_id`),
  KEY `trainings_3_fk_7664250` (`trainings_3_id`),
  KEY `training_4_fk_7664252` (`training_4_id`),
  CONSTRAINT `training_1_fk_7664246` FOREIGN KEY (`training_1_id`) REFERENCES `rrt_trainings` (`id`),
  CONSTRAINT `training_2_fk_7664248` FOREIGN KEY (`training_2_id`) REFERENCES `rrt_trainings` (`id`),
  CONSTRAINT `training_4_fk_7664252` FOREIGN KEY (`training_4_id`) REFERENCES `rrt_trainings` (`id`),
  CONSTRAINT `trainings_3_fk_7664250` FOREIGN KEY (`trainings_3_id`) REFERENCES `rrt_trainings` (`id`),
  CONSTRAINT `user_fk_7664230` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `readiness_and_rt_members`
--

INSERT INTO `readiness_and_rt_members` VALUES (1,'2004-08-01','1978-10-27','1980-04-16','1996-09-06','2013-01-02','1992-02-27','1998-10-07','1973-01-10',NULL,NULL,NULL,NULL,'2023-08-09 09:49:24','2023-08-09 09:49:24',NULL,NULL,2,6,7,7),(2,'2006-02-22','1992-01-23','1998-09-21','1979-01-03','2004-07-19','2003-02-20','1986-07-02','2009-10-07','NxQeZwm5X8O1uTptrRjHTdSnwZjqRZ-metaQ291bnRyeUNvZGVzLmRvYw==-.doc','wUFMJyIfCP05GfD9PQO2fCvy3q1ra3-metaQ291bnRyeUNvZGVzLmRvYw==-.doc','AOBzRdp7WdHvr2moMiNPy7iWH8UFIx-metaQ291bnRyeUNvZGVzLmRvYw==-.doc',NULL,'2023-08-09 09:57:14','2023-08-09 09:57:14',NULL,2,3,5,4,4),(3,'2012-05-30','1975-03-24','1984-12-07','2010-11-01','1981-12-08','1974-03-15','2012-04-22','1994-01-31','PLrHas8ZEWHVVf05nA7TmOaZYXg5G1-metaQ291bnRyeUNvZGVzLmRvYw==-.doc','M1KPcGyB1Fy7YeC1Q3VEq1XOUu5bYy-metaQ291bnRyeUNvZGVzLmRvYw==-.doc','xDMqJCcRhNiXrPDSeD0glxkrC1oH4F-metaQ291bnRyeUNvZGVzLmRvYw==-.doc','[\"1t3PKtVX2PCFIlOc2vaVTItDfCuPu8-metaQ291bnRyeUNvZGVzLmRvYw==-.doc\",\"vvVZG86s2fa3lgJv8x3vTmHgm3wyYF-metaQ291bnRyeUNvZGVzICgxKS5kb2M=-.doc\"]','2023-08-09 10:07:17','2023-08-09 10:07:17',NULL,2,5,6,1,6);

--
-- Table structure for table `regions`
--

CREATE TABLE `regions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `regions_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `regions`
--

INSERT INTO `regions` VALUES (1,'Haut-Katanga','HK','2023-08-06 09:20:03','2023-08-06 09:21:17',NULL),(2,'Kinshasa','KN','2023-08-06 09:21:29','2023-08-06 09:21:29',NULL),(3,'Kongo Central','BC','2023-08-06 09:21:37','2023-08-06 09:21:37',NULL),(4,'Kwango','KG','2023-08-06 09:21:48','2023-08-06 09:21:48',NULL),(5,'Kwilu','KL','2023-08-06 09:21:56','2023-08-06 09:21:56',NULL),(6,'Mai-Ndombe','MN','2023-08-06 09:22:05','2023-08-06 09:22:05',NULL),(7,'Kasaï','KS','2023-08-06 09:22:13','2023-08-06 09:22:13',NULL),(8,'Kasaï-Central','KC','2023-08-06 09:22:20','2023-08-06 09:22:20',NULL),(9,'Kasaï-Oriental','KE','2023-08-06 09:22:33','2023-08-06 09:22:33',NULL),(10,'Lomami','LO','2023-08-06 09:22:42','2023-08-06 09:22:42',NULL),(11,'Sankuru','SA','2023-08-06 09:22:49','2023-08-06 09:22:49',NULL),(12,'Maniema','MA','2023-08-06 09:22:58','2023-08-06 09:22:58',NULL),(13,'South Kivu','SK','2023-08-06 09:23:05','2023-08-06 09:23:05',NULL),(14,'	North Kivu','NK','2023-08-06 09:23:15','2023-08-06 09:23:15',NULL),(15,'Ituri','IT','2023-08-06 09:23:22','2023-08-06 09:23:22',NULL),(16,'Haut-Uele','HU','2023-08-06 09:23:29','2023-08-06 09:23:29',NULL),(17,'Tshopo','TO','2023-08-06 09:23:38','2023-08-06 09:23:38',NULL),(18,'Bas-Uele','BU','2023-08-06 09:23:48','2023-08-06 09:23:48',NULL),(19,'Nord-Ubangi','NU','2023-08-06 09:23:57','2023-08-06 09:23:57',NULL),(20,'Mongala','MO','2023-08-06 09:24:41','2023-08-06 09:24:41',NULL),(21,'Sud-Ubangi','SU','2023-08-06 09:24:47','2023-08-06 09:24:47',NULL),(22,'	Équateur','EQ','2023-08-06 09:24:55','2023-08-06 09:24:55',NULL),(23,'Tshuapa','TU','2023-08-06 09:25:04','2023-08-06 09:25:04',NULL),(24,'Tanganyika','TA','2023-08-06 09:25:17','2023-08-06 09:25:17',NULL),(25,'Haut-Lomami','HL','2023-08-06 09:25:28','2023-08-06 09:25:28',NULL),(26,'Lualaba','LU','2023-08-06 09:25:40','2023-08-06 09:25:40',NULL);

--
-- Table structure for table `registers`
--

CREATE TABLE `registers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `structure_of_agency` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `department` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_of_supervisory_line_manager` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `supervisorr_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fetp_mmber` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fetp_graduate` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `city_of_residence` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `workplace` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `national_agency_employee` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `other_qualifications` longtext COLLATE utf8mb4_unicode_ci,
  `public_health_experience_drc` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `if_yes_number` double(8,2) DEFAULT NULL,
  `eoc_experience` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eoc_if_yes_number_of_years` int DEFAULT NULL,
  `international_work_experience_no_study_abroad` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_international_deployments` int DEFAULT NULL,
  `experience_as_a_team_leader` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `if_yes_above_number_of_deployments_as_tl` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `country_residence_id` bigint unsigned DEFAULT NULL,
  `qualification_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `registers`
--

INSERT INTO `registers` VALUES (1,'Consequat Optio quis cillum laboris esse aspernatur sapiente non velit','Sed deserunt et temporibus cum repellendus Aliquip doloremque ex molestias non placeat culpa sunt dolor voluptas temporibus explicabo Ea et','Ulla Monroe','qikaz@mailinator.com','Velit placeat voluptatem est magnam doloribus explicabo Quia animi est animi aliquip sed qui enim amet iusto adipisci sunt optio','Quod deserunt necessitatibus totam reprehenderit veniam','Id et aliquip quo et','<p>asdadasd</p>','000 1705 396-9024','vodavoloxo@mailinator.com','Et et aut aut eos ut at in labore eveniet magna ipsum quasi id quasi','<p>asdadasda</p>','Eveniet in mollitia eius quos consequat Ea sit sint rem obcaecati et porro adipisicing eligendi',640.00,'In velit placeat nemo sit eos cupiditate id ducimus eum sunt impedit quis ipsum',728,'Consectetur et autem dignissimos aliquam voluptate veritatis quidem voluptates consectetur eum dolor ea quo aut cupiditate labore provident',322,'Occaecat cupidatat ut pariatur Dolore qui vitae veniam ipsum vel aliquid qui ut amet numquam facere',19,'2023-08-08 06:15:44','2023-08-08 06:15:44',NULL,2,NULL,NULL),(2,'Government Agency','Rapid Response','Mark Morgan','pasad@mailinator.com','Yes','Yes','Sit modi consequuntur voluptates qui eum ea perferendis cumque sint cum est provident cillum et voluptate facilis consequatur','<p>test</p>','1 618 698-7189','lutyxo@mailinator.com','Yes',NULL,'No',843.00,'No',163,'Yes',969,'Yes',219,'2023-08-08 08:34:42','2023-08-08 08:37:20',NULL,3,NULL,1);

--
-- Table structure for table `request_database_request_type`
--

CREATE TABLE `request_database_request_type` (
  `request_database_id` bigint unsigned NOT NULL,
  `request_type_id` bigint unsigned NOT NULL,
  KEY `request_database_id_fk_7617740` (`request_database_id`),
  KEY `request_type_id_fk_7617740` (`request_type_id`),
  CONSTRAINT `request_database_id_fk_7617740` FOREIGN KEY (`request_database_id`) REFERENCES `request_databases` (`id`) ON DELETE CASCADE,
  CONSTRAINT `request_type_id_fk_7617740` FOREIGN KEY (`request_type_id`) REFERENCES `request_types` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `request_database_request_type`
--

INSERT INTO `request_database_request_type` VALUES (7,1),(7,2),(8,2);

--
-- Table structure for table `request_databases`
--

CREATE TABLE `request_databases` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `request_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `request_date` date DEFAULT NULL,
  `request_approval` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_of_request_approval_denial` date DEFAULT NULL,
  `if_other_above_specify` longtext COLLATE utf8mb4_unicode_ci,
  `request_duration` int DEFAULT NULL,
  `duration_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `requester_id` bigint unsigned DEFAULT NULL,
  `request_id` bigint unsigned DEFAULT NULL,
  `request_location_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `requester_fk_7700632` (`requester_id`),
  KEY `request_fk_7700636` (`request_id`),
  KEY `request_location_fk_7700639` (`request_location_id`),
  CONSTRAINT `request_fk_7700636` FOREIGN KEY (`request_id`) REFERENCES `request_types` (`id`),
  CONSTRAINT `request_location_fk_7700639` FOREIGN KEY (`request_location_id`) REFERENCES `regions` (`id`),
  CONSTRAINT `requester_fk_7700632` FOREIGN KEY (`requester_id`) REFERENCES `requesters` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `request_databases`
--

INSERT INTO `request_databases` VALUES (1,'Martha Rowland request to stop malaria','1974-02-27','Approved','1972-08-02','<p>xcsdsdfgsdfgdfgdfg</p>',57,'Days','2023-08-10 13:14:11','2023-08-11 11:49:41',NULL,2,3,18),(2,'Michael Cantrell','2016-08-23','pending',NULL,'<p>ghgjhhgjghjfh</p>',15,'Weeks','2023-08-10 13:29:18','2023-08-11 04:09:48','2023-08-11 04:09:48',1,NULL,14),(3,'Michael Cantrell','2016-08-23','Approved',NULL,'<p>ghgjhhgjghjfh</p>',15,'Weeks','2023-08-10 13:30:12','2023-08-14 06:10:27',NULL,1,NULL,14),(4,'Debitis et quod veniam. Reiciendis atque repellendus illum nemo aut.','2023-03-01',NULL,NULL,'<p>Debitis et quod veniam. Reiciendis atque repellendus illum nemo aut. Numquam commodi sequi delectus ad nesciunt.Asperiores voluptatibus laudantium sequi autem in repellat praesentium accusamus. Perferendis minima cumque asperiores delectus reprehenderit. Unde mollitia aspernatur distinctio corrupti numquam delectus.Numquam adipisci fugiat sint ducimus odio sunt quae dolore. Possimus maxime quo aut veniam nam minima. Blanditiis id fugiat ipsum iure ea.Debitis et quod veniam. Reiciendis atque repellendus illum nemo aut. Numquam commodi sequi delectus ad nesciunt.Asperiores voluptatibus laudantium sequi autem in repellat praesentium accusamus. Perferendis minima cumque asperiores delectus reprehenderit. Unde mollitia aspernatur distinctio corrupti numquam delectus.Numquam adipisci fugiat sint ducimus odio sunt quae dolore. Possimus maxime quo aut veniam nam minima. Blanditiis id fugiat ipsum iure ea.</p>',12,'Days','2023-08-10 13:34:06','2023-08-11 04:09:48','2023-08-11 04:09:48',2,NULL,8),(5,'Debitis et quod veniam. Reiciendis atque repellendus illum nemo aut.','2023-03-01','denied',NULL,'<p>Debitis et quod veniam. Reiciendis atque repellendus illum nemo aut. Numquam commodi sequi delectus ad nesciunt.Asperiores voluptatibus laudantium sequi autem in repellat praesentium accusamus. Perferendis minima cumque asperiores delectus reprehenderit. Unde mollitia aspernatur distinctio corrupti numquam delectus.Numquam adipisci fugiat sint ducimus odio sunt quae dolore. Possimus maxime quo aut veniam nam minima. Blanditiis id fugiat ipsum iure ea.Debitis et quod veniam. Reiciendis atque repellendus illum nemo aut. Numquam commodi sequi delectus ad nesciunt.Asperiores voluptatibus laudantium sequi autem in repellat praesentium accusamus. Perferendis minima cumque asperiores delectus reprehenderit. Unde mollitia aspernatur distinctio corrupti numquam delectus.Numquam adipisci fugiat sint ducimus odio sunt quae dolore. Possimus maxime quo aut veniam nam minima. Blanditiis id fugiat ipsum iure ea.</p>',12,'Days','2023-08-10 13:36:30','2023-08-11 11:19:52',NULL,2,NULL,8),(6,'Cupiditate hic tempora. Iste quae repellendus amet perferendis autem perspiciatis.','2023-07-06','denied','2023-11-12','<p>&nbsp;Quisquam harum fugiat cupiditate at sapiente tempora tempora.Quidem occaecati fugiat. Suscipit dolores sed mollitia. Iure dolorem placeat fuga dolore unde assumenda commodi perspiciatis.Dignissimos velit qui harum ullam quis nihil temporibus. Minus quisquam alias debitis doloremque mollitia ratione. Tenetur atque similique unde iste tempora a quasi.</p>',378,'Years','2023-08-10 13:37:05','2023-08-11 04:09:48','2023-08-11 04:09:48',2,NULL,1),(7,'Philip Morgan','2007-12-12','Pending','2018-06-22','<p>ddfsdfsdfs</p>',86,'Years','2023-08-11 04:03:40','2023-08-14 06:18:11',NULL,3,NULL,24),(8,'Beatrice Cooper123','1995-07-20','pending','2001-06-12','<p>zczxcxczx</p>',44,'Months','2023-08-11 04:37:58','2023-08-11 04:51:47',NULL,1,NULL,22);

--
-- Table structure for table `request_types`
--

CREATE TABLE `request_types` (
  `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,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `request_types_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `request_types`
--

INSERT INTO `request_types` VALUES (1,'	Funding request','2023-08-06 09:30:46','2023-08-06 09:30:46',NULL),(2,'Resource request','2023-08-06 09:30:51','2023-08-06 09:30:51',NULL),(3,'Technical request','2023-08-06 09:30:55','2023-08-06 09:30:55',NULL);

--
-- Table structure for table `requesters`
--

CREATE TABLE `requesters` (
  `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,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `requesters_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `requesters`
--

INSERT INTO `requesters` VALUES (1,'Activated response','2023-08-06 09:31:21','2023-08-06 09:31:21',NULL),(2,'Provincial Departments of Health','2023-08-06 09:31:28','2023-08-06 09:31:28',NULL),(3,'Ministerial Agencies','2023-08-06 09:31:32','2023-08-06 09:31:32',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`
--


--
-- 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=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` VALUES (1,'Admin','web','2023-08-07 05:35:52','2023-08-07 05:35:52');

--
-- Table structure for table `rrt_roles`
--

CREATE TABLE `rrt_roles` (
  `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,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `rrt_roles_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rrt_roles`
--

INSERT INTO `rrt_roles` VALUES (1,'	Psychosocial Manager','2023-08-06 09:35:50','2023-08-06 09:35:50',NULL),(2,'Responsible for health, safety and well-being','2023-08-06 09:35:55','2023-08-06 09:35:55',NULL),(3,'Logistics expert','2023-08-06 09:36:00','2023-08-06 09:36:00',NULL),(4,'	Vaccine expert','2023-08-06 09:36:05','2023-08-06 09:36:05',NULL),(5,'Laboratory expert','2023-08-06 09:36:10','2023-08-06 09:36:10',NULL),(6,'	Expert in risk communication and community engagement','2023-08-06 09:36:15','2023-08-06 09:36:15',NULL),(7,'	WASH','2023-08-06 09:36:18','2023-08-06 09:36:18',NULL),(8,'	Expert in infection prevention and control','2023-08-06 09:36:22','2023-08-06 09:36:22',NULL),(9,'	Expert in case management','2023-08-06 09:36:26','2023-08-06 09:36:26',NULL),(10,'	Data Managers','2023-08-06 09:36:30','2023-08-06 09:36:30',NULL),(11,'	Epidemiologist','2023-08-06 09:36:33','2023-08-06 09:36:33',NULL),(12,'	Team Leader','2023-08-06 09:36:38','2023-08-06 09:36:38',NULL);

--
-- Table structure for table `rrt_trainings`
--

CREATE TABLE `rrt_trainings` (
  `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,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `rrt_trainings_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rrt_trainings`
--

INSERT INTO `rrt_trainings` VALUES (1,'Just-in-time training Monkeypox','2023-08-06 09:37:04','2023-08-06 09:37:04',NULL),(2,'	EVD Just-in-Time Training','2023-08-06 09:37:10','2023-08-06 09:37:10',NULL),(3,'	COVID-19 Just-in-Time Training','2023-08-06 09:37:16','2023-08-06 09:37:16',NULL),(4,'	All-hazard training for new RRT members','2023-08-06 09:37:20','2023-08-06 09:37:20',NULL),(5,'	GOARN BSAFE','2023-08-06 09:37:24','2023-08-06 09:37:24',NULL),(6,'	WHO Incident Management System (Level 2)','2023-08-06 09:37:27','2023-08-06 09:37:27',NULL),(7,'	WHO Incident Management System (Level 1)','2023-08-06 09:37:31','2023-08-06 09:37:31',NULL);

--
-- Table structure for table `security_manager_experiences`
--

CREATE TABLE `security_manager_experiences` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `do_you_have_a_service_passport` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `eir_volunteer` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `national_training_insert_name_and_date_of_just_in_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_of_just_in_time_training` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_of_just_in_time_training` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `occupational_health_and_safety_assessment_id` bigint unsigned DEFAULT NULL,
  `osh_y_n_facility_assessment_id` bigint unsigned DEFAULT NULL,
  `development_of_an_incident_action_id` bigint unsigned DEFAULT NULL,
  `other_training_on_osh_id` bigint unsigned DEFAULT NULL,
  `training_received_in_the_field_of_expertise_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `occupational_health_and_safety_assessment_fk_7700518` (`occupational_health_and_safety_assessment_id`),
  KEY `osh_y_n_facility_assessment_fk_7700519` (`osh_y_n_facility_assessment_id`),
  KEY `development_of_an_incident_action_fk_7700520` (`development_of_an_incident_action_id`),
  KEY `other_training_on_osh_fk_7700521` (`other_training_on_osh_id`),
  KEY `training_received_in_the_field_of_expertise_fk_7700522` (`training_received_in_the_field_of_expertise_id`),
  KEY `user_fk_77359948853` (`user_id`),
  CONSTRAINT `development_of_an_incident_action_fk_7700520` FOREIGN KEY (`development_of_an_incident_action_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `occupational_health_and_safety_assessment_fk_7700518` FOREIGN KEY (`occupational_health_and_safety_assessment_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `osh_y_n_facility_assessment_fk_7700519` FOREIGN KEY (`osh_y_n_facility_assessment_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `other_training_on_osh_fk_7700521` FOREIGN KEY (`other_training_on_osh_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `training_received_in_the_field_of_expertise_fk_7700522` FOREIGN KEY (`training_received_in_the_field_of_expertise_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `user_fk_77359948853` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `security_manager_experiences`
--


--
-- Table structure for table `training_levels`
--

CREATE TABLE `training_levels` (
  `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,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `training_levels_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `training_levels`
--

INSERT INTO `training_levels` VALUES (1,'	Expert','2023-08-06 09:11:05','2023-08-06 09:11:05',NULL),(2,'None','2023-08-06 09:11:13','2023-08-07 06:05:14',NULL),(3,'	Advanced','2023-08-06 09:37:56','2023-08-06 09:37:56',NULL),(4,'Intermediate','2023-08-06 09:38:04','2023-08-07 06:04:51',NULL),(5,'Basic','2023-08-07 06:04:32','2023-08-07 06:04:32',NULL);

--
-- Table structure for table `vaccinations`
--

CREATE TABLE `vaccinations` (
  `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,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vaccinations_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vaccinations`
--

INSERT INTO `vaccinations` VALUES (1,'	Cholera','2023-08-06 09:12:59','2023-08-06 09:12:59',NULL),(2,'	Yellow fever','2023-08-06 09:13:03','2023-08-06 09:13:03',NULL),(3,'	Rage','2023-08-06 09:13:08','2023-08-06 09:13:08',NULL),(4,'Ebola','2023-08-06 09:13:12','2023-08-06 09:13:12',NULL),(5,'Meningitis','2023-08-06 09:13:16','2023-08-06 09:13:16',NULL),(6,'	Hepatitis B','2023-08-06 09:13:21','2023-08-06 09:13:21',NULL),(7,'Hepatitis A','2023-08-06 09:13:25','2023-08-06 09:13:25',NULL),(8,'COVID-19','2023-08-06 09:13:29','2023-08-06 09:13:29',NULL);

--
-- Table structure for table `water_sanitation_hygiene_washes`
--

CREATE TABLE `water_sanitation_hygiene_washes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `in_healthcare_settings_id` bigint unsigned DEFAULT NULL,
  `in_a_non_medical_id` bigint unsigned DEFAULT NULL,
  `source_water_assessment_id` bigint unsigned DEFAULT NULL,
  `water_analysis_id` bigint unsigned DEFAULT NULL,
  `train_others_on_water_testing_and_aquatab_id` bigint unsigned DEFAULT NULL,
  `water_infrastructure_mapping_id` bigint unsigned DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `in_healthcare_settings_fk_7700188` (`in_healthcare_settings_id`),
  KEY `in_a_non_medical_fk_7700189` (`in_a_non_medical_id`),
  KEY `source_water_assessment_fk_7700190` (`source_water_assessment_id`),
  KEY `water_analysis_fk_7700191` (`water_analysis_id`),
  KEY `train_others_on_water_testing_and_aquatab_fk_7700192` (`train_others_on_water_testing_and_aquatab_id`),
  KEY `water_infrastructure_mapping_fk_7700193` (`water_infrastructure_mapping_id`),
  KEY `user_fk_78659948825` (`user_id`),
  CONSTRAINT `in_a_non_medical_fk_7700189` FOREIGN KEY (`in_a_non_medical_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `in_healthcare_settings_fk_7700188` FOREIGN KEY (`in_healthcare_settings_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `source_water_assessment_fk_7700190` FOREIGN KEY (`source_water_assessment_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `train_others_on_water_testing_and_aquatab_fk_7700192` FOREIGN KEY (`train_others_on_water_testing_and_aquatab_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `user_fk_78659948825` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `water_analysis_fk_7700191` FOREIGN KEY (`water_analysis_id`) REFERENCES `training_levels` (`id`),
  CONSTRAINT `water_infrastructure_mapping_fk_7700193` FOREIGN KEY (`water_infrastructure_mapping_id`) REFERENCES `training_levels` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `water_sanitation_hygiene_washes`
--

INSERT INTO `water_sanitation_hygiene_washes` VALUES (1,'2023-08-08 05:05:31','2023-08-08 05:05:31',NULL,1,3,4,2,4,5,1),(2,'2023-08-08 05:12:10','2023-08-15 05:56:55',NULL,3,3,3,3,2,4,2);


