Untitled
unknown
plain_text
a month ago
2.0 kB
2
Indexable
Never
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;
Leave a Comment