mci.sql

CREATE TABLE `patient` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `national_id` varchar(17) DEFAULT NULL,
  `uid` varchar(11) DEFAULT NULL,
  `bin_brn` varchar(19) 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(2) DEFAULT NULL,
  `district_id` varchar(2) DEFAULT NULL,
  `upazila_id` varchar(2) DEFAULT NULL,
  `city_corporation_id` varchar(2) DEFAULT NULL,
  `union_or_urban_ward_id` varchar(2) DEFAULT NULL,
  `rural_ward_id` varchar(2) DEFAULT NULL,
  `area_mouja` varchar(255) DEFAULT NULL,
  `street` varchar(255) DEFAULT NULL,
  `village` varchar(255) DEFAULT NULL,
  `post_code` varchar(4) DEFAULT NULL,
  `post_office` varchar(255) DEFAULT NULL,
  `holding_number` varchar(255) DEFAULT NULL,
  `country_code` varchar(3) DEFAULT NULL,
  `permanent_address_line` varchar(255) DEFAULT NULL,
  `permanent_division_id` varchar(2) DEFAULT NULL,
  `permanent_district_id` varchar(2) DEFAULT NULL,
  `permanent_upazila_id` varchar(2) DEFAULT NULL,
  `permanent_city_corporation_id` varchar(2) DEFAULT NULL,
  `permanent_union_or_urban_ward_id` varchar(2) DEFAULT NULL,
  `permanent_rural_ward_id` varchar(2) DEFAULT NULL,
  `permanent_area_mouja` varchar(255) DEFAULT NULL,
  `permanent_country_code` varchar(3) 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,
  `marital_status` varchar(255) DEFAULT NULL,
  `blood_group` varchar(255) DEFAULT NULL,
  `date_of_birth` date 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,
  `religion` varchar(255) DEFAULT NULL,
  `is_alive` tinyint(1) 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,
  PRIMARY KEY (`id`)
)

/*Table structure for table `relations` */

CREATE TABLE `relations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `patient_id` bigint(20) unsigned NOT NULL,
  `type` varchar(100) DEFAULT NULL,
  `name_bangla` varchar(256) DEFAULT NULL,
  `given_name` varchar(256) DEFAULT NULL,
  `sur_name` varchar(256) DEFAULT NULL,
  `nid` varchar(17) DEFAULT NULL,
  `uid` varchar(20) DEFAULT NULL,
  `bin_brn` varchar(20) DEFAULT NULL,
  `hid` varchar(20) DEFAULT NULL,
  `marriage_id` varchar(20) DEFAULT NULL,
  `relational_status` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `patient_id` (`patient_id`),
  CONSTRAINT `relations_ibfk_1` FOREIGN KEY (`patient_id`) REFERENCES `patient` (`id`)
)