-- Table structure for table `m_pemeriksaan_fisik`
--

CREATE TABLE `m_pemeriksaan_fisik` (
  `id_pf` int NOT NULL AUTO_INCREMENT COMMENT 'Pemeriksaan Fisik',
  `tipe_pf` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `value_pf` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `nama_pf` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `is_active` int DEFAULT '1',
  `category` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  PRIMARY KEY (`id_pf`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `m_pemeriksaan_fisik`
--

INSERT INTO `m_pemeriksaan_fisik` VALUES (1,'mata','Conjunctiva Anemis','Conjunctiva Anemis',1,'kespro'),(2,'mata','Sclera Ikertik','Sclera Ikertik',1,'kespro'),(3,'mata','Kelopak mata oedema','Kelopak mata oedema',1,'kespro'),(4,'mata','Fungsi penglihatan visus','Fungsi penglihatan visus',0,'kespro'),(5,'telinga','Cairan bening','Cairan bening',1,'kespro'),(6,'telinga','Serumen','Serumen',1,'kespro'),(7,'hidung','Polip','Polip',1,'kespro'),(8,'mata','Mata Minus','Mata Minus',1,'kespro'),(9,'mata','Mata Plus','Mata Plus',1,'kespro'),(10,'hidung','Disfungsi penciuman','Disfungsi penciuman',1,'kespro'),(11,'hidung','Septum Deviasi','Septum Deviasi',1,'kespro'),(12,'mulut','Bibir sianosis','Bibir sianosis',1,'kespro'),(13,'mulut','Pucat','Pucat',1,'kespro'),(14,'mulut','Kering','Kering',1,'kespro'),(15,'gigi','Karies','Karies',1,'kespro'),(16,'gigi','Pembengkakan gusi','Pembengkakan gusi',1,'kespro'),(17,'gigi','Bercak putih/ berjamur','Bercak putih/ berjamur',1,'kespro'),(18,'leher','Pembesaran kelenjar tyroid','Pembesaran kelenjar tyroid',1,'kespro'),(19,'leher','Pembersaran kelenjar limfe','Pembersaran kelenjar limfe',1,'kespro'),(20,'thoraks','Kelaninan bentuk dada','Kelaninan bentuk dada',1,'kespro'),(21,'thoraks','Kelainan tulang belakang','Kelainan tulang belakang',1,'kespro'),(22,'thoraks','Sikatriks','Sikatriks',1,'kespro'),(23,'thoraks','Masa/ benjolan payudara','Masa/ benjolan payudara',1,'kespro'),(24,'abdomen','Nyeri tekan abdominal','Nyeri tekan abdominal',1,'kespro'),(25,'abdomen','Bising usus','Bising usus',1,'kespro'),(26,'abdomen','Pembesaran hepar','Pembesaran hepar',1,'kespro'),(27,'abdomen','Pembesaran limpa','Pembesaran limpa',1,'kespro'),(28,'abdomen','Bekas operasi','Bekas operasi',1,'kespro'),(29,'genitalia','Keputihan abnormal','Keputihan abnormal',1,'kespro'),(30,'genitalia','Luka/ lecet','Luka/ lecet',1,'kespro'),(31,'genitalia','Bengkak pada pangkal paha','Bengkak pada pangkal paha',1,'kespro'),(32,'genitalia','Vegetasi/ Kondiloma/ Jengger ayam','Vegetasi/ Kondiloma/ Jengger ayam',1,'kespro'),(33,'genitalia','Gatal','Gatal',1,'kespro'),(34,'muskuloskelatal','Deformitas/ kelainan bentuk','Deformitas/ kelainan bentuk',1,'kespro'),(35,'muskuloskelatal','Keterbatasan gerak','Keterbatasan gerak',1,'kespro'),(36,'muskuloskelatal','Nyeri tekan','Nyeri tekan',1,'kespro'),(37,'integumentum','Ruam','Ruam',1,'kespro'),(38,'integumentum','Benjolan','Benjolan',1,'kespro'),(39,'integumentum','Rasa sakit','Rasa sakit',1,'kespro'),(40,'integumentum','Gatal-gatal','Gatal-gatal',1,'kespro'),(41,'integumentum','Kering','Kering',1,'kespro'),(42,'integumentum','Perubahan warna','Perubahan warna',1,'kespro'),(43,'integumentum','Perubahan warna kuku','Perubahan warna kuku',1,'kespro'),(44,'integumentum','Perubahan warna rambut','Perubahan warna rambut',1,'kespro'),(45,'integumentum','Bekas luka saytan dilengan','Bekas luka saytan dilengan',1,'kespro'),(46,'anus','Luka','Luka',1,'kespro'),(47,'anus','Hemoroid','Hemoroid',1,'kespro'),(48,'all','Tidak diperiksa','Tidak diperiksa',1,'kespro'),(49,'all','Dalam batas normal','Dalam batas normal',1,'kespro'),(50,'mata','Bola mata menonjol','Bola mata menonjol',1,'kespro'),(51,'mata','Gangguan refraksi','Gangguan refraksi',1,'kespro'),(52,'mata','Katarak','Katarak',1,'kespro'),(53,'mata','Glukoma','Glukoma',1,'kespro'),(54,'telinga','Cairan Keruh','Cairan Keruh',1,'kespro'),(55,'telinga','Membrana timpani buram','Membrana timpani buram',1,'kespro'),(57,'mulut','Sariawan','Sariawan',1,'kespro'),(58,'tenggorokan','Pembesaran tonsil','Pembesaran tonsil',1,'kespro'),(59,'tenggorokan','Granulasi','Granulasi',1,'kespro'),(60,'abdomen','Nyeri ketok dipinggang','Nyeri ketok dipinggang',1,'kespro'),(61,'abdomen','Asites','Asites',1,'kespro'),(62,'paru','Ronchi','Ronchi',1,'kespro'),(63,'paru','Wheezing','Wheezing',1,'kespro'),(64,'payudara','Benjolan','Benjolan',1,'kespro'),(65,'jantung','Murmur','Murmur',1,'kespro'),(66,'integumentum','Perubahan warna tahi lalat','Perubahan warna tahi lalat',1,'kespro'),(67,'integumentum','Ruam','Ruam',1,'kespro'),(68,'integumentum','Benjolan','Benjolan',1,'kespro'),(69,'integumentum','Rasa sakit','Rasa sakit',1,'kespro'),(70,'integumentum','Gatal-gatal','Gatal-gatal',1,'kespro'),(71,'genitalia','Rasa terbakar','Rasa terbakar',1,'kespro'),(72,'genitalia','Nyeri','Nyeri',1,'kespro'),(73,'abdomen','Teraba Masa','Teraba Masa',1,'kespro'),(74,'mata','Katarak','Katarak',1,'lansia'),(75,'mata','Myopia','Myopia',1,'lansia'),(76,'mata','Hipermetropia','Hipermetropia',1,'lansia'),(77,'mata','Presbiop','Presbiop',1,'lansia'),(78,'mata','Radang','Radang',1,'lansia'),(79,'mata','Infeksi','Infeksi',1,'lansia'),(80,'tenggorokan','Faringitis/radang tenggorokan','Faringitis/radang tenggorokan',1,'lansia'),(81,'tenggorokan','Tonsilitis','Tonsilitis',1,'lansia'),(82,'tenggorokan','Laringitis','Laringitis',1,'lansia'),(83,'hidung','Polip','Polip',1,'lansia'),(84,'hidung','Sinusitis','Sinusitis',1,'lansia'),(85,'hidung','Benda Asing','Benda Asing',1,'lansia'),(86,'telinga','Infeksi telinga luar(otitis eksterna)','Infeksi telinga luar(otitis eksterna)',1,'lansia'),(87,'telinga','Infeksi telinga(otitis media)','Infeksi telinga(otitis media)',1,'lansia'),(88,'telinga','Serumen prop','Serumen prop',1,'lansia'),(89,'gigi','Periodontal disease','Periodontal disease',1,'lansia'),(90,'gigi','Xerostomia','Xerostomia',1,'lansia'),(91,'gigi','Gigi berlubang/ompong','Gigi berlubang/ompong',1,'lansia'),(92,'gigi','Nyeri','Nyeri',1,'lansia'),(93,'gigi','Karies gigi','Karies gigi',1,'lansia'),(94,'lidah','Sariawan','Sariawan',1,'lansia'),(95,'lidah','Kandidiasis','Kandidiasis',1,'lansia'),(96,'lidah','Lichen planus','Lichen planus',1,'lansia'),(97,'lidah','Lidah pecah-pecah','Lidah pecah-pecah',1,'lansia'),(98,'lidah','Glossitis','Glossitis',1,'lansia'),(99,'lidah','Leukoplakia','Leukoplakia',1,'lansia'),(100,'lidah','Kanker','Kanker',1,'lansia'),(101,'gusi','Baik','Baik',1,'lansia'),(102,'gusi','Ada Gangguan','Ada Gangguan',1,'lansia'),(103,'gigi palsu','Ada','Ada',1,'lansia'),(104,'gigi palsu','Tidak Ada','Tidak Ada',1,'lansia'),(105,'tyhroid','Hipertiroid','Hipertiroid',1,'lansia'),(106,'tyhroid','Hipotiroid','Hipotiroid',1,'lansia'),(107,'getah bening','Limfoma','Limfoma',1,'lansia'),(108,'getah bening','Limfadenopati','Limfadenopati',1,'lansia'),(109,'getah bening','Limfadema','Limfadema',1,'lansia'),(110,'Jantung','PJK','PJK',1,'lansia'),(111,'Jantung','Arterosklerosis','Arterosklerosis',1,'lansia'),(112,'Jantung','Aritmia','Aritmia',1,'lansia'),(113,'Jantung','Endokarditis','Endokarditis',1,'lansia'),(114,'Jantung','Kelainan katup jangtung','Kelainan katup jangtung',1,'lansia'),(115,'Jantung','Gagal jantung','Gagal jantung',1,'lansia'),(116,'paru-paru','Pneumonia','Pneumonia',1,'lansia'),(117,'paru-paru','PPOK','PPOK',1,'lansia'),(118,'paru-paru','TB','TB',1,'lansia'),(119,'paru-paru','Asma','Asma',1,'lansia'),(120,'paru-paru','Bronkitis','Bronkitis',1,'lansia'),(121,'payudara','Kanker','Kanker',1,'lansia'),(122,'payudara','Tumor jinak','Tumor jinak',1,'lansia'),(123,'payudara','nyeri','nyeri',1,'lansia'),(124,'tulang punggung','Bungkuk','Bungkuk',1,'lansia'),(125,'tulang punggung','Bengkok','Bengkok',1,'lansia'),(126,'tulang punggung','Benjolan','Benjolan',1,'lansia'),(127,'tulang punggung','Osteoporosis','Osteoporosis',1,'lansia'),(128,'tulang punggung','Arthritis','Arthritis',1,'lansia'),(129,'tulang punggung','Patah tulang','Patah tulang',1,'lansia'),(130,'genitalia','Herpes genital','Herpes genital',1,'lansia'),(131,'genitalia','Klamidia','Klamidia',1,'lansia'),(132,'genitalia','Gonore','Gonore',1,'lansia'),(133,'genitalia','Sifilis','Sifilis',1,'lansia'),(134,'genitalia','BPH','BPH',1,'lansia'),(135,'genitalia','Prolaps uteri','Prolaps uteri',1,'lansia'),(136,'anus','Ambeien','Ambeien',1,'lansia'),(137,'anus','Gatal','Gatal',1,'lansia'),(138,'anggota gerak atas(Kanan-Kiri)','Paraplegia','Paraplegia',1,'lansia'),(139,'anggota gerak atas(Kanan-Kiri)','Patah tulang','Patah tulang',1,'lansia'),(140,'anggota gerak atas(Kanan-Kiri)','Tremor','Tremor',1,'lansia'),(141,'anggota gerak atas(Kanan-Kiri)','Osteoporosis','Osteoporosis',1,'lansia'),(142,'anggota gerak bawah(Kanan-Kiri)','Paraplegia','Paraplegia',1,'lansia'),(143,'anggota gerak bawah(Kanan-Kiri)','Patah tulang','Patah tulang',1,'lansia'),(144,'anggota gerak bawah(Kanan-Kiri)','Osteoporosis','Osteoporosis',1,'lansia');

--
-- Table structure for table `m_pemeriksaan_kespro`
--

CREATE TABLE `m_pemeriksaan_kespro` (
  `id_pemeriksaan_kespro` int NOT NULL AUTO_INCREMENT,
  `id_penduduk` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `nik` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tgl_kunjungan` date DEFAULT NULL,
  `tgl_konsul_lanjutan` date DEFAULT NULL,
  `anamnesis_penyakit_sekarang` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `anamnesis_riwayat_penyakit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `anamnesis_riwayat_penyakit_keluarga` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `anamnesis_status_imunisasi` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'Perempuan',
  `anamnesis_faktor_resiko_reproduksi` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `anamnesis_obstetri` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `anamnesis_gaya_hidup` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `is_pf` int DEFAULT NULL COMMENT 'PF = Pemeriksaan Fisik',
  `pf_sistole` int DEFAULT NULL,
  `pf_diastole` int DEFAULT NULL,
  `pf_denyut_jantung` int DEFAULT NULL,
  `pf_frekuensi_nafas` int DEFAULT NULL,
  `pf_bb` float(5,1) DEFAULT NULL,
  `pf_tb` float(5,1) DEFAULT NULL,
  `pf_imt` float(5,1) DEFAULT NULL,
  `pf_status_imt` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_lila` float(5,1) DEFAULT NULL,
  `pf_status_lila` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_mata` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_hidung` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_telinga` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_mulut` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_gigi` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_leher` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_thoraks` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_abdomen` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_genitalia` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_muskuloskeletal` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_integumentum` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_anus` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_pemeriksaan_lain` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `is_quisioner` int DEFAULT NULL,
  `quisioner` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `is_pp` int DEFAULT NULL COMMENT 'PP = Pemeriksaan Penunjang',
  `pp_haemoglobin` int DEFAULT NULL,
  `pp_gol_darah` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_resus` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_warna` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_volume` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_beratjenis` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_epitel` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_protein` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_glukosa` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_bau` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_ph` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_sendimen` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_eritrosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_lekosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_silinder` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_bilirubin` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_urobilinogen` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_benda_kenton` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_kristal` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_laju_darah` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_leukosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_eritrosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_hematokrit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_trombosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_eosinofil` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_basophil` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_netrofil` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_limfosil` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_monosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_mcv` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_mch` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_mchc` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_sadanis` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_iva_test` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_papsmear` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_gd_acak` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_gd_puasa` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_gd_pp` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_gd_hba1c` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_kol_total` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_kol_hdl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_kol_ldl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_kol_trigliserid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_kol_asamurat` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_rapid_malaria` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_hiv` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_tb` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_sifilis` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_gonore` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_klamedia` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_hbsag` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_torch` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_talasemia` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lain` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `is_tl` int DEFAULT NULL COMMENT 'TL = Tata Laksana',
  `tl_kie` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `tl_konseling` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tl_diagnosa` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `tl_imunisasi_tt` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tl_pelayanan_gizi` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tl_pengobatan` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tl_tablet_tambah_darah` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_is_kb_rekomendasi` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_kb_rekomendasi` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_kb_rencana_pelaksanaan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_is_rekomendasi` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_rekomendasi_rencana_kehamilan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_rekomendasi_lain` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_is_rujuk` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_tujuan_rujukan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_perujuk` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_perujuk_lembaga` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `is_kekerasan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `kasus` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `kategori_kekerasan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `jenis_kekerasan` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `kode_icd_x` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `pelayanan_kekerasan_diberikan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `dampak_kesehatan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `rujukan_kekerasan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `id_lab_master` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `resep` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `icd` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `created_date` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `created_by` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `update_date` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `update_by` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_hematokrit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_trombosit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `hasil_hematokrit` int DEFAULT NULL,
  `hasil_trombosit` int DEFAULT NULL,
  `hasil_leukosit` int DEFAULT NULL,
  `hematokrit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `trombosit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `leukosit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_hiv` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_sifilis` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_hepb` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_thalasemia` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_hb` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_urin` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_reduksi` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_hematokrit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_trombosit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_leukosit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_hiv` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_sifilis` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_hbsag` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_thalasemia` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_leukosit` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tv_tensi_duduk_siastole` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tv_tensi_duduk_diastole` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tv_tensi_tidur_sistole` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tv_tensi_tidur_diastole` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `hipertensi_duduk` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `hipertensi_tidur` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `icpc` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `kode_nakes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `tindakan` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `keterangan_tindakan` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `created_at` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `updated_at` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `u` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `id_radiologi_master` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `no_rekam_medis` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `data_barang` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `is_operasi` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tanggal_operasi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `no_rawat` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  PRIMARY KEY (`id_pemeriksaan_kespro`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `m_pemeriksaan_kespro`
--


--
-- Table structure for table `m_pemeriksaan_kespro_awal`
--

CREATE TABLE `m_pemeriksaan_kespro_awal` (
  `id_pemeriksaan_catin` int NOT NULL AUTO_INCREMENT,
  `id_penduduk` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `nik` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tgl_kunjungan` date DEFAULT NULL,
  `tgl_konsul_lanjutan` date DEFAULT NULL,
  `anamnesis_penyakit_sekarang` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `anamnesis_riwayat_penyakit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `anamnesis_riwayat_penyakit_keluarga` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `anamnesis_status_imunisasi` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'Perempuan',
  `anamnesis_faktor_resiko_reproduksi` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `anamnesis_obstetri` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `anamnesis_gaya_hidup` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `is_pf` int DEFAULT NULL COMMENT 'PF = Pemeriksaan Fisik',
  `pf_sistole` int DEFAULT NULL,
  `pf_diastole` int DEFAULT NULL,
  `pf_denyut_jantung` int DEFAULT NULL,
  `pf_frekuensi_nafas` int DEFAULT NULL,
  `pf_bb` float(5,1) DEFAULT NULL,
  `pf_tb` float(5,1) DEFAULT NULL,
  `pf_imt` float(5,1) DEFAULT NULL,
  `pf_status_imt` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_lila` float(5,1) DEFAULT NULL,
  `pf_status_lila` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_mata` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_hidung` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_telinga` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_mulut` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_gigi` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_leher` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_thoraks` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_abdomen` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_genitalia` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_muskuloskeletal` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_integumentum` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_anus` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_pemeriksaan_lain` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `is_quisioner` int DEFAULT NULL,
  `quisioner` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `is_pp` int DEFAULT NULL COMMENT 'PP = Pemeriksaan Penunjang',
  `pp_haemoglobin` int DEFAULT NULL,
  `pp_gol_darah` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_resus` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_warna` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_volume` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_beratjenis` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_epitel` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_protein` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_glukosa` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_bau` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_ph` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_sendimen` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_eritrosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_lekosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_silinder` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_bilirubin` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_urobilinogen` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_benda_kenton` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_kristal` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_laju_darah` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_leukosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_eritrosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_hematokrit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_trombosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_eosinofil` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_basophil` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_netrofil` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_limfosil` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_monosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_mcv` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_mch` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_mchc` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_sadanis` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_iva_test` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_papsmear` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_gd_acak` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_gd_puasa` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_gd_pp` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_gd_hba1c` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_kol_total` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_kol_hdl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_kol_ldl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_kol_trigliserid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_kol_asamurat` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_rapid_malaria` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_hiv` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_tb` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_sifilis` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_gonore` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_klamedia` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_hbsag` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_torch` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_talasemia` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lain` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `is_tl` int DEFAULT NULL COMMENT 'TL = Tata Laksana',
  `tl_kie` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `tl_konseling` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tl_diagnosa` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `tl_imunisasi_tt` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tl_pelayanan_gizi` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tl_pengobatan` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tl_tablet_tambah_darah` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_is_kb_rekomendasi` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_kb_rekomendasi` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_kb_rencana_pelaksanaan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_is_rekomendasi` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_rekomendasi_rencana_kehamilan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_rekomendasi_lain` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_is_rujuk` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_tujuan_rujukan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_perujuk` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_perujuk_lembaga` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `is_kekerasan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `kasus` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `kategori_kekerasan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `jenis_kekerasan` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `kode_icd_x` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `pelayanan_kekerasan_diberikan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `dampak_kesehatan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `rujukan_kekerasan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `id_lab_master` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `resep` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `icd` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `periksa_hematokrit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_trombosit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `hasil_hematokrit` int DEFAULT NULL,
  `hasil_trombosit` int DEFAULT NULL,
  `hasil_leukosit` int DEFAULT NULL,
  `hematokrit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `trombosit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `leukosit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_hiv` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_sifilis` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_hepb` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_thalasemia` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_hb` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_urin` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_reduksi` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_hematokrit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_trombosit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_leukosit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_hiv` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_sifilis` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_hbsag` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_thalasemia` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_leukosit` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tv_tensi_duduk_siastole` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tv_tensi_duduk_diastole` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tv_tensi_tidur_sistole` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tv_tensi_tidur_diastole` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `hipertensi_duduk` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `hipertensi_tidur` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `icpc` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `no_rawat` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `no_rm` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `kode_nakes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `tindakan` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `keterangan_tindakan` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `created_at` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `updated_at` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `u` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `status_periksa` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT '0',
  PRIMARY KEY (`id_pemeriksaan_catin`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `m_pemeriksaan_kespro_awal`
--


--
-- Table structure for table `m_pemeriksaan_usipro`
--

CREATE TABLE `m_pemeriksaan_usipro` (
  `id_pemeriksaan_usipro` int NOT NULL AUTO_INCREMENT,
  `id_penduduk` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `nik` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tgl_kunjungan` date DEFAULT NULL,
  `tgl_konsul_lanjutan` date DEFAULT NULL,
  `anamnesis_penyakit_sekarang` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `anamnesis_riwayat_penyakit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `anamnesis_riwayat_penyakit_keluarga` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `anamnesis_status_imunisasi` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'Perempuan',
  `anamnesis_faktor_resiko_reproduksi` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `anamnesis_obstetri` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `anamnesis_gaya_hidup` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `is_pf` int DEFAULT NULL COMMENT 'PF = Pemeriksaan Fisik',
  `pf_sistole` int DEFAULT NULL,
  `pf_diastole` int DEFAULT NULL,
  `pf_denyut_jantung` int DEFAULT NULL,
  `pf_frekuensi_nafas` int DEFAULT NULL,
  `pf_bb` float(5,1) DEFAULT NULL,
  `pf_tb` float(5,1) DEFAULT NULL,
  `pf_imt` float(5,1) DEFAULT NULL,
  `pf_status_imt` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_lila` float(5,1) DEFAULT NULL,
  `pf_status_lila` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_mata` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_hidung` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_telinga` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_mulut` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_gigi` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_leher` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_thoraks` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_abdomen` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_genitalia` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_muskuloskeletal` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_integumentum` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_anus` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_pemeriksaan_lain` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `is_quisioner` int DEFAULT NULL,
  `quisioner` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `is_pp` int DEFAULT NULL COMMENT 'PP = Pemeriksaan Penunjang',
  `pp_haemoglobin` int DEFAULT NULL,
  `pp_gol_darah` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_resus` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_warna` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_volume` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_beratjenis` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_epitel` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_protein` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_glukosa` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_bau` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_ph` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_sendimen` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_eritrosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_lekosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_silinder` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_bilirubin` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_urobilinogen` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_benda_kenton` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_kristal` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_laju_darah` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_leukosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_eritrosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_hematokrit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_trombosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_eosinofil` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_basophil` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_netrofil` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_limfosil` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_monosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_mcv` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_mch` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_mchc` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_sadanis` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_iva_test` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_papsmear` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_gd_acak` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_gd_puasa` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_gd_pp` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_gd_hba1c` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_kol_total` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_kol_hdl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_kol_ldl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_kol_trigliserid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_kol_asamurat` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_rapid_malaria` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_hiv` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_tb` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_sifilis` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_gonore` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_klamedia` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_hbsag` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_torch` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_talasemia` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lain` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `is_tl` int DEFAULT NULL COMMENT 'TL = Tata Laksana',
  `tl_kie` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `tl_konseling` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tl_diagnosa` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `tl_imunisasi_tt` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tl_pelayanan_gizi` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tl_pengobatan` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tl_tablet_tambah_darah` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_is_kb_rekomendasi` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_kb_rekomendasi` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_kb_rencana_pelaksanaan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_is_rekomendasi` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_rekomendasi_rencana_kehamilan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_rekomendasi_lain` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_is_rujuk` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_tujuan_rujukan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_perujuk` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_perujuk_lembaga` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `is_kekerasan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `kasus` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `kategori_kekerasan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `jenis_kekerasan` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `kode_icd_x` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `pelayanan_kekerasan_diberikan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `dampak_kesehatan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `rujukan_kekerasan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `id_lab_master` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `resep` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `icd` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `created_date` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `created_by` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `update_date` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `update_by` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_hematokrit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_trombosit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `hasil_hematokrit` int DEFAULT NULL,
  `hasil_trombosit` int DEFAULT NULL,
  `hasil_leukosit` int DEFAULT NULL,
  `hematokrit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `trombosit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `leukosit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_hiv` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_sifilis` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_hepb` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_thalasemia` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_hb` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_urin` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_reduksi` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_hematokrit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_trombosit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_leukosit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_hiv` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_sifilis` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_hbsag` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_thalasemia` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_leukosit` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tv_tensi_duduk_siastole` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tv_tensi_duduk_diastole` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tv_tensi_tidur_sistole` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tv_tensi_tidur_diastole` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `hipertensi_duduk` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `hipertensi_tidur` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `icpc` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `kode_nakes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `tindakan` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `keterangan_tindakan` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `created_at` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `updated_at` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `u` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `id_radiologi_master` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `no_rekam_medis` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `data_barang` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `is_operasi` varchar(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tanggal_operasi` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `no_rawat` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  PRIMARY KEY (`id_pemeriksaan_usipro`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `m_pemeriksaan_usipro`
--


--
-- Table structure for table `m_pemeriksaan_usipro_awal`
--

CREATE TABLE `m_pemeriksaan_usipro_awal` (
  `id_pemeriksaan_catin` int NOT NULL AUTO_INCREMENT,
  `id_penduduk` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `nik` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tgl_kunjungan` date DEFAULT NULL,
  `tgl_konsul_lanjutan` date DEFAULT NULL,
  `anamnesis_penyakit_sekarang` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `anamnesis_riwayat_penyakit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `anamnesis_riwayat_penyakit_keluarga` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `anamnesis_status_imunisasi` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'Perempuan',
  `anamnesis_faktor_resiko_reproduksi` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `anamnesis_obstetri` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `anamnesis_gaya_hidup` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `is_pf` int DEFAULT NULL COMMENT 'PF = Pemeriksaan Fisik',
  `pf_sistole` int DEFAULT NULL,
  `pf_diastole` int DEFAULT NULL,
  `pf_denyut_jantung` int DEFAULT NULL,
  `pf_frekuensi_nafas` int DEFAULT NULL,
  `pf_bb` float(5,1) DEFAULT NULL,
  `pf_tb` float(5,1) DEFAULT NULL,
  `pf_imt` float(5,1) DEFAULT NULL,
  `pf_status_imt` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_lila` float(5,1) DEFAULT NULL,
  `pf_status_lila` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_mata` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_hidung` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_telinga` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_mulut` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_gigi` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_leher` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_thoraks` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_abdomen` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_genitalia` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_muskuloskeletal` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_integumentum` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_anus` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pf_pemeriksaan_lain` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `is_quisioner` int DEFAULT NULL,
  `quisioner` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `is_pp` int DEFAULT NULL COMMENT 'PP = Pemeriksaan Penunjang',
  `pp_haemoglobin` int DEFAULT NULL,
  `pp_gol_darah` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_resus` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_warna` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_volume` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_beratjenis` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_epitel` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_protein` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_glukosa` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_bau` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_ph` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_sendimen` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_eritrosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_lekosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_silinder` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_bilirubin` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_urobilinogen` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_benda_kenton` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin_kristal` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_laju_darah` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_leukosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_eritrosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_hematokrit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_trombosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_eosinofil` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_basophil` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_netrofil` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_limfosil` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_monosit` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_mcv` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_mch` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_dt_mchc` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_urin` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_sadanis` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_iva_test` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_papsmear` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_gd_acak` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_gd_puasa` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_gd_pp` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_gd_hba1c` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_kol_total` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_kol_hdl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_kol_ldl` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_kol_trigliserid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_kol_asamurat` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_rapid_malaria` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_hiv` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_tb` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_sifilis` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_gonore` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_klamedia` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_hbsag` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_torch` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lab_talasemia` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pp_lain` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `is_tl` int DEFAULT NULL COMMENT 'TL = Tata Laksana',
  `tl_kie` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `tl_konseling` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tl_diagnosa` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `tl_imunisasi_tt` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tl_pelayanan_gizi` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tl_pengobatan` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tl_tablet_tambah_darah` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_is_kb_rekomendasi` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_kb_rekomendasi` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_kb_rencana_pelaksanaan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_is_rekomendasi` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_rekomendasi_rencana_kehamilan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_rekomendasi_lain` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_is_rujuk` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_tujuan_rujukan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_perujuk` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tl_perujuk_lembaga` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `is_kekerasan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `kasus` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `kategori_kekerasan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `jenis_kekerasan` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `kode_icd_x` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `pelayanan_kekerasan_diberikan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `dampak_kesehatan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `rujukan_kekerasan` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `id_lab_master` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `resep` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `icd` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `periksa_hematokrit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_trombosit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `hasil_hematokrit` int DEFAULT NULL,
  `hasil_trombosit` int DEFAULT NULL,
  `hasil_leukosit` int DEFAULT NULL,
  `hematokrit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `trombosit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `leukosit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_hiv` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_sifilis` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_hepb` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_thalasemia` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_hb` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_urin` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_reduksi` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_hematokrit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_trombosit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_leukosit` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_hiv` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_sifilis` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_hbsag` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lab_thalasemia` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `periksa_leukosit` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tv_tensi_duduk_siastole` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tv_tensi_duduk_diastole` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tv_tensi_tidur_sistole` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tv_tensi_tidur_diastole` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `hipertensi_duduk` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `hipertensi_tidur` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `icpc` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `no_rawat` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `no_rm` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `kode_nakes` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `tindakan` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `keterangan_tindakan` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `created_at` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `updated_at` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `u` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `status_periksa` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT '0',
  PRIMARY KEY (`id_pemeriksaan_catin`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `m_pemeriksaan_usipro_awal`
--


--
-- Table structure for table `m_pendidikan`
--

CREATE TABLE `m_pendidikan` (
  `id_pendidikan` int NOT NULL AUTO_INCREMENT,
  `nama_pendidikan` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id_pendidikan`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `m_pendidikan`
--

INSERT INTO `m_pendidikan` VALUES (1,'Tidak/Belum Sekolah'),(2,'Belum Tamat SD/Sederajat'),(3,'SD/Sederajat'),(4,'SLTP/Sederajat'),(5,'SLTA/Sederajat'),(6,'Diploma I/II'),(7,'Akademi/Diploma III'),(8,'Diploma IV/Strata I'),(9,'Strata II'),(10,'Strata III');

--
-- Table structure for table `m_pendonor`
--

CREATE TABLE `m_pendonor` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nik` varchar(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `nama` varchar(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `kelamin` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `pekerjaan` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `tgl_lahir` date DEFAULT NULL,
  `jenis_donor` varchar(11) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL COMMENT 'sukarela / pengganti',
  `telp` varchar(20) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `gol_darah` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `rhesus` varchar(11) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `kecamatan` varchar(11) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `desa` varchar(11) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT '',
  `alamat` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `lat` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `long` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `d` date DEFAULT NULL,
  `t` time DEFAULT NULL,
  `u` varchar(25) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `provinsi` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `kabupaten` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `m_pendonor`
--


--
-- Table structure for table `m_penduduk`
--

CREATE TABLE `m_penduduk` (
  `id_penduduk` int NOT NULL AUTO_INCREMENT,
  `kdp` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `no_ktp` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `no_kk` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `nama_depan` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `tgl_lahir` date DEFAULT NULL,
  `id_tempat_lahir` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `nama_tempat_lahir` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `nama_belakang` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `jenis_kelamin` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `gol_darah` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `resus` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `alamat_ktp` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `id_prov_ktp` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `nama_prov_ktp` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `id_kab_ktp` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `nama_kab_ktp` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `id_kec_ktp` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `nama_kec_ktp` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `id_desa_ktp` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `nama_desa_ktp` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `rt_ktp` varchar(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `rw_ktp` varchar(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `is_domisili` int DEFAULT NULL,
  `id_prov_domisili` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `nama_prov_domisili` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `id_kab_domisili` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `nama_kab_domisili` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `id_kec_domisili` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `nama_kec_domisili` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `id_desa_domisili` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `nama_desa_domisili` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `alamat_domisili` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin,
  `rt_domisili` varchar(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `rw_domisili` varchar(5) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `no_hp` varchar(15) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `asuransi` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `no_asuransi` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `status_pekerjaan` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `status_pernikahan` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `status_hidup` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `status_kesehatan_pasangan_sebelumnya` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `riwayat_perilaku_berisiko` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `riwayat_kb_sebelumnya` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `riwayat_obstetri_sebelumnya` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `is_disabilitas` int DEFAULT NULL,
  `jenis_disabilitas` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `nama_disabilitas` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `is_active` int DEFAULT '1',
  `created_date` datetime DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `update_by` int DEFAULT NULL,
  `siklus_hidup` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `pendidikan_terakhir` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `no_rekam_medis` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `kode_lembaga` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `ibu_kandung` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  `no_rekam_medis_lama` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL,
  PRIMARY KEY (`id_penduduk`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=71600 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `m_penduduk`
--



