MCI Patient Table

mci.sql

CREATE TABLE `patient` (
  `health_id` varchar(255) NOT NULL DEFAULT '',
  `national_id` varchar(255) DEFAULT NULL,
  `uid` varchar(255) DEFAULT NULL,
  `bin_brn` varchar(255) DEFAULT NULL,
  `given_name` varchar(255) DEFAULT NULL,
  `sur_name` varchar(255) DEFAULT NULL,
  `full_name_bangla` varchar(255) DEFAULT NULL,
  `address_line` varchar(255) DEFAULT NULL,
  `division_id` varchar(255) DEFAULT NULL,
  `district_id` varchar(255) DEFAULT NULL,
  `upazila_id` varchar(255) DEFAULT NULL,
  `city_corporation_id` varchar(255) DEFAULT NULL,
  `union_or_urban_ward_id` varchar(255) DEFAULT NULL,
  `rural_ward_id` varchar(255) DEFAULT NULL,
  `area_mouja` varchar(255) DEFAULT NULL,
  `street` varchar(255) DEFAULT NULL,
  `village` varchar(255) DEFAULT NULL,
  `post_code` varchar(255) DEFAULT NULL,
  `post_office` varchar(255) DEFAULT NULL,
  `holding_number` varchar(255) DEFAULT NULL,
  `country_code` varchar(255) DEFAULT NULL,
  `permanent_address_line` varchar(255) DEFAULT NULL,
  `permanent_division_id` varchar(255) DEFAULT NULL,
  `permanent_district_id` varchar(255) DEFAULT NULL,
  `permanent_upazila_id` varchar(255) DEFAULT NULL,
  `permanent_city_corporation_id` varchar(255) DEFAULT NULL,
  `permanent_union_or_urban_ward_id` varchar(255) DEFAULT NULL,
  `permanent_rural_ward_id` varchar(255) DEFAULT NULL,
  `permanent_area_mouja` varchar(255) DEFAULT NULL,
  `permanent_country_code` varchar(255) DEFAULT NULL,
  `permanent_holding_number` varchar(255) DEFAULT NULL,
  `permanent_post_code` varchar(255) DEFAULT NULL,
  `permanent_post_office` varchar(255) DEFAULT NULL,
  `permanent_street` varchar(255) DEFAULT NULL,
  `permanent_village` varchar(255) DEFAULT NULL,
  `fathers_nid` varchar(255) DEFAULT NULL,
  `fathers_uid` varchar(255) DEFAULT NULL,
  `fathers_brn` varchar(255) DEFAULT NULL,
  `fathers_given_name` varchar(255) DEFAULT NULL,
  `fathers_sur_name` varchar(255) DEFAULT NULL,
  `fathers_name_bangla` varchar(255) DEFAULT NULL,
  `mothers_nid` varchar(255) DEFAULT NULL,
  `mothers_uid` varchar(255) DEFAULT NULL,
  `mothers_brn` varchar(255) DEFAULT NULL,
  `mothers_given_name` varchar(255) DEFAULT NULL,
  `mothers_sur_name` varchar(255) DEFAULT NULL,
  `mothers_name_bangla` varchar(255) DEFAULT NULL,
  `marriage_id` varchar(255) DEFAULT NULL,
  `marital_relations` varchar(255) DEFAULT NULL,
  `marital_status` varchar(255) DEFAULT NULL,
  `blood_group` varchar(255) DEFAULT NULL,
  `date_of_birth` timestamp NULL DEFAULT NULL,
  `disability` varchar(255) DEFAULT NULL,
  `ethnicity` varchar(255) DEFAULT NULL,
  `edu_level` varchar(255) DEFAULT NULL,
  `gender` varchar(255) DEFAULT NULL,
  `nationality` varchar(255) DEFAULT NULL,
  `occupation` varchar(255) DEFAULT NULL,
  `place_of_birth` varchar(255) DEFAULT NULL,
  `relations` text DEFAULT NULL,
  `religion` varchar(255) DEFAULT NULL,
  `is_alive` varchar(255) DEFAULT NULL,
  `primary_contact` varchar(255) DEFAULT NULL,
  `phone_no` varchar(255) DEFAULT NULL,
  `phone_number_area_code` varchar(255) DEFAULT NULL,
  `phone_number_country_code` varchar(255) DEFAULT NULL,
  `phone_number_extension` varchar(255) DEFAULT NULL,
  `primary_contact_no` varchar(255) DEFAULT NULL,
  `primary_contact_number_area_code` varchar(255) DEFAULT NULL,
  `primary_contact_number_country_code` varchar(255) DEFAULT NULL,
  `primary_contact_number_extension` varchar(255) DEFAULT NULL,
  `location_level1` varchar(255) DEFAULT NULL,
  `location_level2` varchar(255) DEFAULT NULL,
  `location_level3` varchar(255) DEFAULT NULL,
  `location_level4` varchar(255) DEFAULT NULL,
  `location_level5` varchar(255) DEFAULT NULL,
  `location_level6` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by` varchar(255) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `full_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`health_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

updated schema https://gist.github.com/roniemicro/2884edc55b47ce651abf