Untitled

CREATE TABLE `custom_publications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `personal_id` int(10) UNSIGNED NOT NULL,
  `description` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `custom_prometric_informations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `personal_id` int(10) UNSIGNED NOT NULL,
  `prometrics_exam` varchar(255) NOT NULL,
  `date_of_exam` date NOT NULL,
  `date_of_expiry` date NOT NULL,
  `exam_results` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


CREATE TABLE `custom_primary_source_verifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `personal_id` int(10) UNSIGNED NOT NULL,
  `dataflow_case_no` varchar(255) NOT NULL,
  `date_of_issuance` date NOT NULL,
  `dataflow_status` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `custom_internships` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `personal_id` int(10) UNSIGNED NOT NULL,
  `type` int(10) UNSIGNED NOT NULL,
  `institution_name` varchar(255) NOT NULL,
  `job_title` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `country_id` int(10) UNSIGNED NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `hospital_level` varchar(255) NOT NULL,
  `total_bed_capacity` varchar(255) NOT NULL,
  `unit_department` varchar(255) NOT NULL,
  `no_of_bed_in_unit_department` varchar(255) NOT NULL,
  `nurse_patient_ratio` varchar(255) NOT NULL,
  `job_description` text NOT NULL,
  `cases_handled` text NOT NULL,
  `equipments_operated` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;