INSERT INTO `tweb_aset` (`id_aset`, `golongan`, `bidang`, `kelompok`, `sub_kelompok`, `sub_sub_kelompok`, `nama`) VALUES
(3914, '4', '03', '05', '99', '999', 'INSTALASI PEMBANGKIT LISTRIK LAINNYA'),
(3915, '4', '03', '06', '00', '000', 'INSTALASI GARDU LISTRIK'),
(3916, '4', '03', '06', '01', '000', 'INSTALASI GARDU LISTRIK INDUK'),
(3917, '4', '03', '06', '01', '001', 'INSTALASI GARDU LISTRIK INDUK KAPASITAS KECIL'),
(3918, '4', '03', '06', '01', '002', 'INSTALASI GARDU LISTRIK INDUK KAPASITAS SEDANG'),
(3919, '4', '03', '06', '01', '003', 'INSTALASI GARDU LISTRIK INDUK KAPASITAS BESAR'),
(3920, '4', '03', '06', '01', '999', 'INSTALASI GARDU LISTRIK INDUK LAINNYA'),
(3921, '4', '03', '06', '02', '000', 'INSTALASI GARDU LISTRIK DISTRIBUSI'),
(3922, '4', '03', '06', '02', '001', 'INSTALASI GARDU LISTRIK DISTRIBUSI KAPASITAS KECIL'),
(3923, '4', '03', '06', '02', '002', 'INSTALASI GARDU LISTRIK DISTRIBUSI KAPASITAS SEDANG'),
(3924, '4', '03', '06', '02', '003', 'INSTALASI GARDU LISTRIK DISTRIBUSI KAPASITAS BESAR'),
(3925, '4', '03', '06', '02', '999', 'INSTALASI GARDU LISTRIK DISTRIBUSI LAINNYA'),
(3926, '4', '03', '06', '03', '000', 'INSTALASI PUSAT PENGATUR LISTRIK'),
(3927, '4', '03', '06', '03', '001', 'INSTALASI PUSAT PENGATUR LISTRIK KAPASITAS KECIL'),
(3928, '4', '03', '06', '03', '002', 'INSTALASI PUSAT PENGATUR LISTRIK KAPASITAS SEDANG'),
(3929, '4', '03', '06', '03', '003', 'INSTALASI PUSAT PENGATUR LISTRIK KAPASITAS BESAR'),
(3930, '4', '03', '06', '03', '999', 'INSTALASI PUSAT PENGATUR LISTRIK LAINNYA'),
(3931, '4', '03', '06', '99', '000', 'INSTALASI GARDU LISTRIK LAINNYA'),
(3932, '4', '03', '06', '99', '999', 'INSTALASI GARDU LISTRIK LAINNYA'),
(3933, '4', '03', '07', '00', '000', 'INSTALASI LAIN'),
(3934, '4', '03', '07', '01', '000', 'INSTALASI LAIN'),
(3935, '4', '03', '07', '01', '001', 'INSTALASI GENERATING SET'),
(3936, '4', '03', '07', '01', '002', 'INSTALASI AC'),
(3937, '4', '03', '07', '01', '003', 'INSTALASI BUILDING AUTOMATION SYSTEM (BAS)'),
(3938, '4', '03', '07', '01', '004', 'INSTALASI KOMPUTER'),
(3939, '4', '03', '07', '01', '999', 'INSTALASI LAIN-LAIN'),
(3940, '4', '04', '00', '00', '000', 'JARINGAN'),
(3941, '4', '04', '01', '00', '000', 'JARINGAN AIR MINUM'),
(3942, '4', '04', '01', '01', '000', 'JARINGAN PEMBAWA'),
(3943, '4', '04', '01', '01', '001', 'JARINGAN PEMBAWA KAPASITAS KECIL'),
(3944, '4', '04', '01', '01', '002', 'JARINGAN PEMBAWA KAPASITAS SEDANG'),
(3945, '4', '04', '01', '01', '003', 'JARINGAN PEMBAWA KAPASITAS BESAR'),
(3946, '4', '04', '01', '01', '999', 'JARINGAN PEMBAWA LAINNYA'),
(3947, '4', '04', '01', '02', '000', 'JARINGAN INDUK DISTRIBUSI'),
(3948, '4', '04', '01', '02', '001', 'JARINGAN INDUK DISTRIBUSI KAPASITAS KECIL'),
(3949, '4', '04', '01', '02', '002', 'JARINGAN INDUK DISTRIBUSI KAPASITAS SEDANG'),
(3950, '4', '04', '01', '02', '003', 'JARINGAN INDUK DISTRIBUSI KAPASITAS BESAR'),
(3951, '4', '04', '01', '02', '999', 'JARINGAN INDUK DISTRIBUSI LAINNYA'),
(3952, '4', '04', '01', '03', '000', 'JARINGAN CABANG DISTRIBUSI'),
(3953, '4', '04', '01', '03', '001', 'JARINGAN CABANG DISTRIBUSI KAPASITAS KECIL'),
(3954, '4', '04', '01', '03', '002', 'JARINGAN CABANG DISTRIBUSI KAPASITAS SEDANG'),
(3955, '4', '04', '01', '03', '003', 'JARINGAN CABANG DISTRIBUSI KAPASITAS BESAR'),
(3956, '4', '04', '01', '03', '999', 'JARINGAN CABANG DISTRIBUSI LAINNYA'),
(3957, '4', '04', '01', '04', '000', 'JARINGAN SAMBUNGAN KE RUMAH'),
(3958, '4', '04', '01', '04', '001', 'JARINGAN SAMBUNGAN KE RUMAH KAPASITAS KECIL'),
(3959, '4', '04', '01', '04', '002', 'JARINGAN SAMBUNGAN KE RUMAH KAPASITAS SEDANG'),
(3960, '4', '04', '01', '04', '003', 'JARINGAN SAMBUNGAN KE RUMAH KAPASITAS BESAR'),
(3961, '4', '04', '01', '04', '999', 'JARINGAN SAMBUNGAN KE RUMAH LAINNYA'),
(3962, '4', '04', '01', '99', '000', 'JARINGAN AIR MINUM LAINNYA'),
(3963, '4', '04', '01', '99', '999', 'JARINGAN AIR MINUM LAINNYA'),
(3964, '4', '04', '02', '00', '000', 'JARINGAN LISTRIK'),
(3965, '4', '04', '02', '01', '000', 'JARINGAN TRANSMISI'),
(3966, '4', '04', '02', '01', '001', 'JARINGAN TRANSMISI TEGANGAN DIATAS 300 KVA'),
(3967, '4', '04', '02', '01', '002', 'JARINGAN TRANSMISI TEGANGAN 100 S/D 300 KVA'),
(3968, '4', '04', '02', '01', '003', 'JARINGAN TRANSMISI TEGANGAN DIBAWAH 100 KVA'),
(3969, '4', '04', '02', '01', '999', 'JARINGAN TRANSMISI LAINNYA'),
(3970, '4', '04', '02', '02', '000', 'JARINGAN DISTRIBUSI'),
(3971, '4', '04', '02', '02', '001', 'JARINGAN DISTRIBUSI TEGANGAN DIATAS 20 KVA'),
(3972, '4', '04', '02', '02', '002', 'JARINGAN DISTRIBUSI TEGANGAN 1 S/D 20 KVA'),
(3973, '4', '04', '02', '02', '003', 'JARINGAN DISTRIBUSI TEGANGAN DIBAWAH 1 KVA'),
(3974, '4', '04', '02', '02', '999', 'JARINGAN DISTRIBUSI LAINNYA'),
(3975, '4', '04', '02', '99', '000', 'JARINGAN LISTRIK LAINNYA'),
(3976, '4', '04', '02', '99', '999', 'JARINGAN LISTRIK LAINNYA'),
(3977, '4', '04', '03', '00', '000', 'JARINGAN TELEPON'),
(3978, '4', '04', '03', '01', '000', 'JARINGAN TELEPON DIATAS TANAH'),
(3979, '4', '04', '03', '01', '001', 'JARINGAN TELEPON DIATAS TANAH KAPASITAS KECIL'),
(3980, '4', '04', '03', '01', '002', 'JARINGAN TELEPON DIATAS TANAH KAPASITAS SEDANG'),
(3981, '4', '04', '03', '01', '003', 'JARINGAN TELEPON DIATAS TANAH KAPASITAS BESAR'),
(3982, '4', '04', '03', '01', '999', 'JARINGAN TELEPON DIATAS TANAH LAINNYA'),
(3983, '4', '04', '03', '02', '000', 'JARINGAN TELEPON DIBAWAH TANAH'),
(3984, '4', '04', '03', '02', '001', 'JARINGAN TELEPON DIBAWAH TANAH KAPASITAS KECIL'),
(3985, '4', '04', '03', '02', '002', 'JARINGAN TELEPON DIBAWAH TANAH KAPASITAS SEDANG'),
(3986, '4', '04', '03', '02', '003', 'JARINGAN TELEPON DIBAWAH TANAH KAPASITAS BESAR'),
(3987, '4', '04', '03', '02', '999', 'JARINGAN TELEPON DIBAWAH TANAH LAINNYA'),
(3988, '4', '04', '03', '03', '000', 'JARINGAN TELEPON DIDALAM AIR'),
(3989, '4', '04', '03', '03', '001', 'JARINGAN TELEPON DIDALAM AIR KAPASITAS KECIL'),
(3990, '4', '04', '03', '03', '002', 'JARINGAN TELEPON DIDALAM AIR KAPASITAS SEDANG'),
(3991, '4', '04', '03', '03', '003', 'JARINGAN TELEPON DIDALAM AIR KAPASITAS BESAR'),
(3992, '4', '04', '03', '03', '999', 'JARINGAN TELEPON DIDALAM AIR LAINNYA'),
(3993, '4', '04', '03', '04', '000', 'JARINGAN DENGAN MEDIA UDARA'),
(3994, '4', '04', '03', '04', '001', 'JARINGAN SATELIT'),
(3995, '4', '04', '03', '04', '002', 'JARINGAN RADIO'),
(3996, '4', '04', '03', '04', '999', 'JARINGAN DENGAN MEDIA UDARA LAINNYA'),
(3997, '4', '04', '03', '99', '000', 'JARINGAN TELEPON LAINNYA'),
(3998, '4', '04', '03', '99', '999', 'JARINGAN TELEPON LAINNYA'),
(3999, '4', '04', '04', '00', '000', 'JARINGAN GAS'),
(4000, '4', '04', '04', '01', '000', 'JARINGAN PIPA GAS TRANSMISI'),
(4001, '4', '04', '04', '01', '001', 'JARINGAN PIPA BAJA'),
(4002, '4', '04', '04', '01', '999', 'JARINGAN PIPA GAS TRANSMISI LAINNYA'),
(4003, '4', '04', '04', '02', '000', 'JARINGAN PIPA DISTRIBUSI'),
(4004, '4', '04', '04', '02', '001', 'JARINGAN PIPA DISTRIBUSI TEKANAN TINGGI'),
(4005, '4', '04', '04', '02', '002', 'JARINGAN PIPA DISTRIBUSI TEKANAN MENENGAH PIPA BAJA'),
(4006, '4', '04', '04', '02', '003', 'JARINGAN PIPA DISTRIBUSI TEKANAN MENENGAH PIPA PE'),
(4007, '4', '04', '04', '02', '004', 'JARINGAN PIPA DISTRIBUSI TEKANAN RENDAH PIPA BAJA'),
(4008, '4', '04', '04', '02', '005', 'JARINGAN PIPA DISTRIBUSI TEKANAN RENDAH PIPA PC'),
(4009, '4', '04', '04', '02', '999', 'JARINGAN PIPA DISTRIBUSI LAINNYA'),
(4010, '4', '04', '04', '03', '000', 'JARINGAN PIPA DINAS'),
(4011, '4', '04', '04', '03', '001', 'JARINGAN PIPA DINAS PIPA BAJA'),
(4012, '4', '04', '04', '03', '002', 'JARINGAN PIPA DINAS PIPA PE'),
(4013, '4', '04', '04', '03', '999', 'JARINGAN PIPA DINAS LAINNYA'),
(4014, '4', '04', '04', '04', '000', 'JARINGAN BBM'),
(4015, '4', '04', '04', '04', '001', 'JARINGAN BBM BENSIN'),
(4016, '4', '04', '04', '04', '002', 'JARINGAN BBM SOLAR'),
(4017, '4', '04', '04', '04', '003', 'JARINGAN BBM MINYAK TANAH'),
(4018, '4', '04', '04', '04', '999', 'JARINGAN BBM LAINNYA'),
(4019, '4', '04', '04', '99', '000', 'JARINGAN GAS LAINNYA'),
(4020, '4', '04', '04', '99', '999', 'JARINGAN GAS LAINNYA'),
(4021, '5', '00', '00', '00', '000', 'ASET TETAP LAINNYA'),
(4022, '5', '01', '00', '00', '000', 'BAHAN PERPUSTAKAAN'),
(4023, '5', '01', '01', '00', '000', 'BAHAN PERPUSTAKAAN TERCETAK'),
(4024, '5', '01', '01', '01', '000', 'BUKU'),
(4025, '5', '01', '01', '01', '001', 'MONOGRAF'),
(4026, '5', '01', '01', '01', '002', 'REFERENSI'),
(4027, '5', '01', '01', '01', '999', 'BUKU LAINNYA'),
(4028, '5', '01', '01', '02', '000', 'SERIAL'),
(4029, '5', '01', '01', '02', '001', 'SURAT KABAR'),
(4030, '5', '01', '01', '02', '002', 'MAJALAH'),
(4031, '5', '01', '01', '02', '003', 'BULETIN'),
(4032, '5', '01', '01', '02', '004', 'LAPORAN'),
(4033, '5', '01', '01', '02', '999', 'SERIAL LAINNYA'),
(4034, '5', '01', '01', '99', '000', 'TERCETAK LAINNYA'),
(4035, '5', '01', '01', '99', '999', 'BAHAN PERPUSTAKAAN TERCETAK LAINNYA'),
(4036, '5', '01', '02', '00', '000', 'BAHAN PERPUSTAKAAN TEREKAM DAN BENTUK MIKRO'),
(4037, '5', '01', '02', '01', '000', 'AUDIO VISUAL'),
(4038, '5', '01', '02', '01', '001', 'KASET'),
(4039, '5', '01', '02', '01', '002', 'VIDEO'),
(4040, '5', '01', '02', '01', '003', 'CD/VCD/DVD/LD'),
(4041, '5', '01', '02', '01', '004', 'PITA FILM'),
(4042, '5', '01', '02', '01', '005', 'PITA SUARA'),
(4043, '5', '01', '02', '01', '006', 'PIRINGAN HITAM'),
(4044, '5', '01', '02', '01', '028', 'PETA DIGITAL'),
(4045, '5', '01', '02', '01', '999', 'AUDIO VISUAL LAINNYA'),
(4046, '5', '01', '02', '02', '000', 'BENTUK MIKRO (MICROFORM)'),
(4047, '5', '01', '02', '02', '001', 'MIKROFILM'),
(4048, '5', '01', '02', '02', '002', 'MIKROFISCH'),
(4049, '5', '01', '02', '02', '003', 'SLIDE'),
(4050, '5', '01', '02', '02', '999', 'BENTUK MIKRO/MIKROFORM LAINNYA'),
(4051, '5', '01', '02', '99', '000', 'TEREKAM DAN BENTUK MIKRO LAINNYA'),
(4052, '5', '01', '02', '99', '999', 'BAHAN PERPUSTAKAAN TEREKAM DAN BENTUK MIKRO LAINNYA'),
(4053, '5', '01', '03', '00', '000', '\"KARTOGRAFI'),
(4054, '5', '01', '03', '01', '000', 'BAHAN KARTOGRAFI'),
(4055, '5', '01', '03', '01', '001', 'PETA (MAP)'),
(4056, '5', '01', '03', '01', '002', 'ATLAS'),
(4057, '5', '01', '03', '01', '003', 'BLUE PRINT'),
(4058, '5', '01', '03', '01', '004', 'BOLA DUNIA (GLOBE)'),
(4059, '5', '01', '03', '01', '999', 'BAHAN KARTOGRAFI LAINNYA'),
(4060, '5', '01', '03', '02', '000', 'NASKAH (MANUSKRIP) / ASLI'),
(4061, '5', '01', '03', '02', '001', 'NASKAH/MANUSKRIP BERBAHAN KERTAS'),
(4062, '5', '01', '03', '02', '002', 'NASKAH/MANUSKRIP BERBAHAN DAUN'),
(4063, '5', '01', '03', '02', '003', 'NASKAH/MANUSKRIP BERBAHAN KAYU'),
(4064, '5', '01', '03', '02', '004', 'NASKAH/MANUSKRIP BERBAHAN BAMBU'),
(4065, '5', '01', '03', '02', '005', 'NASKAH/MANUSKRIP BERBAHAN KULIT KAYU'),
(4066, '5', '01', '03', '02', '006', 'NASKAH/MANUSKRIP BERBAHAN KULIT BINATANG'),
(4067, '5', '01', '03', '02', '007', 'NASKAH/MANUSKRIP BERBAHAN TULANG/TANDUK'),
(4068, '5', '01', '03', '02', '008', 'NASKAH/MANUSKRIP BERBAHAN TEMPURUNG'),
(4069, '5', '01', '03', '02', '999', 'NASKAH/MANUSKRIP BERBAHAN LAINNYA'),
(4070, '5', '01', '03', '03', '000', 'LUKISAN DAN UKIRAN'),
(4071, '5', '01', '03', '03', '001', 'LUKISAN KANVAS'),
(4072, '5', '01', '03', '03', '002', '\"LUKISAN BATU'),
(4073, '5', '01', '03', '03', '003', 'UKIRAN KAYU DAN SEJENISNYA'),
(4074, '5', '01', '03', '03', '004', 'UKIRAN LOGAM DAN SEJENISNYA'),
(4075, '5', '01', '03', '03', '005', 'UKIRAN BATU DAN SEJENISNYA'),
(4076, '5', '01', '03', '03', '999', 'UKIRAN DAN LUKISAN LAINNYA'),
(4077, '5', '01', '03', '99', '000', '\"KARTOGRAFI'),
(4078, '5', '01', '03', '99', '999', '\"KARTOGRAFI'),
(4079, '5', '02', '00', '00', '000', 'BARANG BERCORAK KESENIAN/KEBUDAYAAN/OLAHRAGA'),
(4080, '5', '02', '01', '00', '000', 'BARANG BERCORAK KESENIAN'),
(4081, '5', '02', '01', '01', '000', 'ALAT MUSIK'),
(4082, '5', '02', '01', '01', '001', 'ALAT MUSIK TRADISIONAL/DAERAH'),
(4083, '5', '02', '01', '01', '002', 'ALAT MUSIK MODERN/BAND'),
(4084, '5', '02', '01', '01', '999', 'ALAT MUSIK LAINNYA'),
(4085, '5', '02', '01', '02', '000', 'LUKISAN'),
(4086, '5', '02', '01', '02', '001', 'LUKISAN CAT AIR'),
(4087, '5', '02', '01', '02', '002', 'SULAMAN / TEMPELAN'),
(4088, '5', '02', '01', '02', '003', 'LUKISAN CAT MINYAK'),
(4089, '5', '02', '01', '02', '004', 'LUKISAN BULU'),
(4090, '5', '02', '01', '02', '005', 'SENI RELIEF'),
(4091, '5', '02', '01', '02', '999', 'LUKISAN LAINNYA'),
(4092, '5', '02', '01', '03', '000', 'ALAT PERAGA KESENIAN'),
(4093, '5', '02', '01', '03', '001', 'WAYANG GOLEK'),
(4094, '5', '02', '01', '03', '002', 'WAYANG KULIT'),
(4095, '5', '02', '01', '03', '999', 'ALAT PERAGA KESENIAN LAINNYA'),
(4096, '5', '02', '01', '99', '000', 'BARANG BERCORAK KESENIAN LAINNYA'),
(4097, '5', '02', '01', '99', '999', 'BARANG BERCORAK KESENIAN LAINNYA'),
(4098, '5', '02', '02', '00', '000', 'ALAT BERCORAK KEBUDAYAAN'),
(4099, '5', '02', '02', '01', '000', 'PAHATAN'),
(4100, '5', '02', '02', '01', '001', 'PAHATAN BATU'),
(4101, '5', '02', '02', '01', '002', 'PAHATAN KAYU'),
(4102, '5', '02', '02', '01', '003', 'PAHATAN LOGAM'),
(4103, '5', '02', '02', '01', '999', 'PAHATAN LAINNYA'),
(4104, '5', '02', '02', '02', '000', '\"MAKET'),
(4105, '5', '02', '02', '02', '001', 'MAKET/MINIATUR/REPLIKA'),
(4106, '5', '02', '02', '02', '002', 'FOTO DOKUMEN'),
(4107, '5', '02', '02', '02', '003', 'NASKAH KUNO'),
(4108, '5', '02', '02', '02', '004', 'MATA UANG/ NUMISMATIK'),
(4109, '5', '02', '02', '02', '005', 'PERHIASAN'),
(4110, '5', '02', '02', '02', '006', 'BARANG KERAMIK/ GERABAH'),
(4111, '5', '02', '02', '02', '007', 'ARCA/ PATUNG'),
(4112, '5', '02', '02', '02', '008', 'BENDA KUNO/ UNIK'),
(4113, '5', '02', '02', '02', '009', 'FOSIL'),
(4114, '5', '02', '02', '02', '010', 'MUMY'),
(4115, '5', '02', '02', '02', '999', 'MAKET DAN FOTO DOKUMEN LAINNYA'),
(4116, '5', '02', '02', '99', '000', 'ALAT BERCORAK KEBUDAYAAN LAINNYA'),
(4117, '5', '02', '02', '99', '999', 'ALAT BERCORAK KEBUDAYAAN LAINNYA'),
(4118, '5', '02', '03', '00', '000', 'TANDA PENGHARGAAN BIDANG OLAH RAGA'),
(4119, '5', '02', '03', '01', '000', 'TANDA PENGHARGAAN'),
(4120, '5', '02', '03', '01', '001', 'PIALA'),
(4121, '5', '02', '03', '01', '002', 'MEDALI'),
(4122, '5', '02', '03', '01', '003', 'PIAGAM'),
(4123, '5', '02', '03', '01', '999', 'TANDA PENGHARGAAN LAINNYA'),
(4124, '5', '02', '03', '99', '000', 'TANDA PENGHARGAAN BIDANG OLAH RAGA LAINNYA'),
(4125, '5', '02', '03', '99', '999', 'TANDA PENGHARGAAN BIDANG OLAH RAGA LAINNYA'),
(4126, '5', '03', '00', '00', '000', 'HEWAN'),
(4127, '5', '03', '01', '00', '000', 'HEWAN PIARAAN'),
(4128, '5', '03', '01', '01', '000', 'HEWAN PENGAMAN'),
(4129, '5', '03', '01', '01', '001', 'ANJING PELACAK'),
(4130, '5', '03', '01', '01', '002', 'ANJING PENJAGA'),
(4131, '5', '03', '01', '01', '999', 'HEWAN PENGAMAN LAINNYA'),
(4132, '5', '03', '01', '02', '000', 'HEWAN PENGANGKUT'),
(4133, '5', '03', '01', '02', '001', 'GAJAH'),
(4134, '5', '03', '01', '02', '002', 'KUDA (HEWAN PENGANGKUT)'),
(4135, '5', '03', '01', '02', '999', 'HEWAN PENGANGKUT LAINNYA'),
(4136, '5', '03', '01', '99', '000', 'HEWAN PIARAAN LAINNYA'),
(4137, '5', '03', '01', '99', '999', 'HEWAN PIARAAN LAINNYA'),
(4138, '5', '03', '02', '00', '000', 'TERNAK'),
(4139, '5', '03', '02', '01', '000', 'TERNAK POTONG'),
(4140, '5', '03', '02', '01', '001', 'BABI'),
(4141, '5', '03', '02', '01', '002', 'DOMBA'),
(4142, '5', '03', '02', '01', '003', 'KAMBING'),
(4143, '5', '03', '02', '01', '004', 'KERBAU'),
(4144, '5', '03', '02', '01', '005', 'SAPI POTONG'),
(4145, '5', '03', '02', '01', '999', 'TERNAK POTONG LAINNYA'),
(4146, '5', '03', '02', '02', '000', 'TERNAK PERAH'),
(4147, '5', '03', '02', '02', '001', 'SAPI PERAH'),
(4148, '5', '03', '02', '02', '002', 'DOMBA PERAH'),
(4149, '5', '03', '02', '02', '003', 'KAMBING PERAH'),
(4150, '5', '03', '02', '02', '999', 'TERNAK PERAH LAINNYA'),
(4151, '5', '03', '02', '03', '000', 'TERNAK UNGGAS'),
(4152, '5', '03', '02', '03', '001', 'AYAM'),
(4153, '5', '03', '02', '03', '002', 'BURUNG'),
(4154, '5', '03', '02', '03', '003', 'ITIK'),
(4155, '5', '03', '02', '03', '999', 'TERNAK UNGGAS LAINNYA'),
(4156, '5', '03', '02', '99', '000', 'TERNAK LAINNYA'),
(4157, '5', '03', '02', '99', '999', 'TERNAK LAINNYA'),
(4158, '5', '03', '03', '00', '000', 'HEWAN LAINNYA'),
(4159, '5', '03', '03', '01', '000', 'HEWAN LAINNYA'),
(4160, '5', '03', '03', '01', '001', 'HEWAN LAINNYA'),
(4161, '5', '04', '00', '00', '000', 'IKAN'),
(4162, '5', '04', '01', '00', '000', 'IKAN BERSIRIP (PISCES/IKAN BERSIRIP)'),
(4163, '5', '04', '01', '01', '000', 'IKAN BUDIDAYA'),
(4164, '5', '04', '01', '01', '001', 'IKAN AIR TAWAR BUDIDAYA'),
(4165, '5', '04', '01', '01', '002', 'IKAN AIR LAUT BUDIDAYA'),
(4166, '5', '04', '01', '01', '003', 'IKAN AIR PAYAU BUDIDAYA'),
(4167, '5', '04', '01', '01', '004', 'IKAN HIAS AIR TAWAR BUDIDAYA'),
(4168, '5', '04', '01', '01', '005', 'IKAN HIAS AIR PAYAU/LAUT BUDIDAYA'),
(4169, '5', '04', '01', '01', '999', 'IKAN BUDIDAYA LAINNYA'),
(4170, '5', '04', '02', '00', '000', '\"CRUSTEA (UDANG'),
(4171, '5', '04', '02', '01', '000', '\"CRUSTEA BUDIDAYA (UDANG'),
(4172, '5', '04', '02', '01', '001', 'UDANG'),
(4173, '5', '04', '02', '01', '002', 'RAJUNGAN'),
(4174, '5', '04', '02', '01', '003', 'KEPITING'),
(4175, '5', '04', '02', '01', '999', '\"CRUSTEA (UDANG'),
(4176, '5', '04', '03', '00', '000', '\"MOLLUSCA (KERANG'),
(4177, '5', '04', '03', '01', '000', '\"MOLLUSCA BUDIDAYA (KERANG'),
(4178, '5', '04', '03', '01', '001', 'KERANG'),
(4179, '5', '04', '03', '01', '002', 'TIRAM'),
(4180, '5', '04', '03', '01', '003', 'CUMI-CUMI'),
(4181, '5', '04', '03', '01', '004', 'GURITA'),
(4182, '5', '04', '03', '01', '005', 'SIPUT'),
(4183, '5', '04', '03', '01', '999', '\"MOLLUSCA (KERANG'),
(4184, '5', '04', '04', '00', '000', 'COELENTERATA (UBUR-UBUR DAN SEBANGSANYA)'),
(4185, '5', '04', '04', '01', '000', 'COELENTERATA BUDIDAYA (UBUR-UBUR DAN SEBANGSANYA)'),
(4186, '5', '04', '04', '01', '001', 'UBUR-UBUR BUDIDAYA'),
(4187, '5', '04', '04', '01', '999', 'COELENTERATA (UBUR-UBUR DAN SEBANGSANYA) LAINNYA'),
(4188, '5', '04', '05', '00', '000', '\"ECHINODERMATA (TRIPANG'),
(4189, '5', '04', '05', '01', '000', '\"ECHINODERMATA BUDIDAYA (TRIPANG'),
(4190, '5', '04', '05', '01', '001', 'TERIPANG'),
(4191, '5', '04', '05', '01', '002', 'BULU BABI'),
(4192, '5', '04', '05', '01', '999', '\"ECHINODERMATA (TRIPANG'),
(4193, '5', '04', '06', '00', '000', 'AMPHIBIA (KODOK DAN SEBANGSANYA)'),
(4194, '5', '04', '06', '01', '000', 'AMPHIBIA BUDIDAYA (KODOK DAN SEBANGSANYA)'),
(4195, '5', '04', '06', '01', '001', 'KODOK'),
(4196, '5', '04', '06', '01', '002', 'SEBANGSA KODOK'),
(4197, '5', '04', '06', '01', '999', 'AMPHIBIA (KODOK DAN SEBANGSANYA) LAINNYA'),
(4198, '5', '04', '07', '00', '000', '\"REPTILIA (BUAYA'),
(4199, '5', '04', '07', '01', '000', '\"REPTILIA BUDIDAYA (BUAYA'),
(4200, '5', '04', '07', '01', '001', 'PENYU'),
(4201, '5', '04', '07', '01', '002', 'KURA-KURA'),
(4202, '5', '04', '07', '01', '003', 'BIAWAK'),
(4203, '5', '04', '07', '01', '004', 'ULAR AIR'),
(4204, '5', '04', '07', '01', '999', '\"REPTILIA (BUAYA'),
(4205, '5', '04', '08', '00', '000', '\"MAMMALIA (PAUS'),
(4206, '5', '04', '08', '01', '000', '\"MAMMALIA BUDIDAYA (PAUS'),
(4207, '5', '04', '08', '01', '001', 'PAUS'),
(4208, '5', '04', '08', '01', '002', 'LUMBA-LUMBA'),
(4209, '5', '04', '08', '01', '003', 'PESUT'),
(4210, '5', '04', '08', '01', '004', 'DUYUNG'),
(4211, '5', '04', '08', '01', '999', '\"MAMMALIA (PAUS'),
(4212, '5', '04', '09', '00', '000', 'ALGAE (RUMPUT LAUT DAN TUMBUH-TUMBUHAN LAIN YANG HIDUP DI DALAM AIR)'),
(4213, '5', '04', '09', '01', '000', 'ALGAE BUDIDAYA (RUMPUT LAUT DAN TUMBUH-TUMBUHAN LAIN YANG HIDUP DI DALAM AIR)'),
(4214, '5', '04', '09', '01', '001', 'RUMPUT LAUT'),
(4215, '5', '04', '09', '01', '002', 'TUMBUH-TUMBUHAN LAIN YANG HIDUP DI DALAM AIR'),
(4216, '5', '04', '09', '01', '999', 'ALGAE (RUMPUT LAUT DAN TUMBUH-TUMBUHAN LAIN YANG HIDUP DI DALAM AIR) LAINNYA'),
(4217, '5', '04', '10', '00', '000', 'BIOTA PERAIRAN LAINNYA'),
(4218, '5', '04', '10', '01', '000', 'BUDIDAYA BIOTA PERAIRAN LAINNYA'),
(4219, '5', '04', '10', '01', '001', 'BIOTA PERAIRAN LAINNYA'),
(4220, '5', '05', '00', '00', '000', 'TANAMAN'),
(4221, '5', '05', '01', '00', '000', 'TANAMAN'),
(4222, '5', '05', '01', '01', '000', 'TANAMAN'),
(4223, '5', '05', '01', '01', '001', 'TANAMAN KERAS'),
(4224, '5', '05', '01', '01', '002', 'TANAMAN INDUSTRI'),
(4225, '5', '05', '01', '01', '003', 'TANAMAN PERKEBUNAN'),
(4226, '5', '05', '01', '01', '004', 'TANAMAN HORTIKULTURA'),
(4227, '5', '05', '01', '01', '005', 'TANAMAN PANGAN'),
(4228, '5', '05', '01', '01', '006', 'TANAMAN HIAS'),
(4229, '5', '05', '01', '01', '007', 'TANAMAN OBAT'),
(4230, '5', '05', '01', '01', '008', 'TANAMAN PLASMA'),
(4231, '5', '05', '01', '01', '999', 'TANAMAN LAINNYA'),
(4232, '5', '06', '00', '00', '000', 'ASET TETAP DALAM RENOVASI'),
(4233, '5', '06', '01', '00', '000', 'ASET TETAP DALAM RENOVASI'),
(4234, '5', '06', '01', '01', '000', 'ASET TETAP DALAM RENOVASI'),
(4235, '5', '06', '01', '01', '001', 'TANAH DALAM RENOVASI'),
(4236, '5', '06', '01', '01', '002', 'PERALATAN DAN MESIN DALAM RENOVASI'),
(4237, '5', '06', '01', '01', '003', 'GEDUNG DAN BANGUNAN DALAM RENOVASI'),
(4238, '5', '06', '01', '01', '004', '\"JALAN'),
(4239, '5', '06', '01', '01', '005', 'ASET TETAP LAINNYA DALAM RENOVASI'),
(4240, '5', '06', '01', '01', '999', 'ASET TETAP DALAM RENOVASI LAINNYA'),
(4241, '6', '00', '00', '00', '000', 'KONSTRUKSI DALAM PENGERJAAN'),
(4242, '6', '01', '00', '00', '000', 'KONSTRUKSI DALAM PENGERJAAN'),
(4243, '6', '01', '01', '00', '000', 'KONSTRUKSI DALAM PENGERJAAN'),
(4244, '6', '01', '01', '01', '000', 'KONSTRUKSI DALAM PENGERJAAN'),
(4245, '6', '01', '01', '01', '001', 'TANAH DALAM PENGERJAAN'),
(4246, '6', '01', '01', '01', '002', 'PERALATAN DAN MESIN DALAM PENGERJAAN'),
(4247, '6', '01', '01', '01', '003', 'GEDUNG DAN BANGUNAN DALAM PENGERJAAN'),
(4248, '6', '01', '01', '01', '004', '\"JALAN'),
(4249, '6', '01', '01', '01', '005', 'ASET TETAP LAINNYA DALAM PENGERJAAN'),
(4250, '6', '01', '01', '01', '999', 'KONSTRUKSI DALAM PENGERJAAN LAINNYA');

-- --------------------------------------------------------

--
-- Table structure for table `tweb_cacat`
--

CREATE TABLE `tweb_cacat` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tweb_cacat`
--

INSERT INTO `tweb_cacat` (`id`, `nama`) VALUES
(1, 'CACAT FISIK'),
(2, 'CACAT NETRA/BUTA'),
(3, 'CACAT RUNGU/WICARA'),
(4, 'CACAT MENTAL/JIWA'),
(5, 'CACAT FISIK DAN MENTAL'),
(6, 'CACAT LAINNYA'),
(7, 'TIDAK CACAT');

-- --------------------------------------------------------

--
-- Table structure for table `tweb_cara_kb`
--

CREATE TABLE `tweb_cara_kb` (
  `id` tinyint(5) NOT NULL,
  `nama` varchar(50) NOT NULL,
  `sex` tinyint(2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `tweb_cara_kb`
--

INSERT INTO `tweb_cara_kb` (`id`, `nama`, `sex`) VALUES
(1, 'Pil', 2),
(2, 'IUD', 2),
(3, 'Suntik', 2),
(4, 'Kondom', 1),
(5, 'Susuk KB', 2),
(6, 'Sterilisasi Wanita', 2),
(7, 'Sterilisasi Pria', 1),
(99, 'Lainnya', 3);

-- --------------------------------------------------------

--
-- Table structure for table `tweb_desa_pamong`
--

CREATE TABLE `tweb_desa_pamong` (
  `pamong_id` int(5) NOT NULL,
  `pamong_nama` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pamong_nip` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pamong_nik` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `jabatan` varchar(50) COLLATE utf8_unicode_ci DEFAULT '0',
  `tupoksi` text COLLATE utf8_unicode_ci NOT NULL,
  `pamong_status` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pamong_tgl_terdaftar` date DEFAULT NULL,
  `pamong_ttd` tinyint(1) DEFAULT NULL,
  `foto` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `id_pend` int(11) DEFAULT NULL,
  `pamong_tempatlahir` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pamong_tanggallahir` date DEFAULT NULL,
  `pamong_sex` tinyint(4) DEFAULT NULL,
  `pamong_pendidikan` int(10) DEFAULT NULL,
  `pamong_agama` int(10) DEFAULT NULL,
  `pamong_nosk` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pamong_tglsk` date DEFAULT NULL,
  `pamong_masajab` varchar(120) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pamong_niap` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pamong_pangkat` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pamong_nohenti` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pamong_tglhenti` date DEFAULT NULL,
  `urut` int(5) DEFAULT NULL,
  `pamong_ub` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tweb_desa_pamong`
--

INSERT INTO `tweb_desa_pamong` (`pamong_id`, `pamong_nama`, `pamong_nip`, `pamong_nik`, `jabatan`, `tupoksi`, `pamong_status`, `pamong_tgl_terdaftar`, `pamong_ttd`, `foto`, `id_pend`, `pamong_tempatlahir`, `pamong_tanggallahir`, `pamong_sex`, `pamong_pendidikan`, `pamong_agama`, `pamong_nosk`, `pamong_tglsk`, `pamong_masajab`, `pamong_niap`, `pamong_pangkat`, `pamong_nohenti`, `pamong_tglhenti`, `urut`, `pamong_ub`) VALUES
(57, 'Brama', '', '', 'Kepala Desa', '<p>Tupoksi Kepala Desa</p>', '1', '2020-11-13', 1, '5fb9d35dbbdcc.png', 1, 'MATARAM', '2003-05-19', 2, 4, 4, '', '2020-11-14', '2016 / 2022', '1234567890', '', NULL, NULL, 1, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `tweb_golongan_darah`
--

CREATE TABLE `tweb_golongan_darah` (
  `id` int(11) NOT NULL,
  `nama` varchar(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tweb_golongan_darah`
--

INSERT INTO `tweb_golongan_darah` (`id`, `nama`) VALUES
(1, 'A'),
(2, 'B'),
(3, 'AB'),
(4, 'O'),
(5, 'A+'),
(6, 'A-'),
(7, 'B+'),
(8, 'B-'),
(9, 'AB+'),
(10, 'AB-'),
(11, 'O+'),
(12, 'O-'),
(13, 'TIDAK TAHU');

-- --------------------------------------------------------

--
-- Table structure for table `tweb_keluarga`
--

CREATE TABLE `tweb_keluarga` (
  `id` int(10) NOT NULL,
  `no_kk` varchar(160) DEFAULT NULL,
  `nik_kepala` varchar(200) DEFAULT NULL,
  `tgl_daftar` timestamp NULL DEFAULT current_timestamp(),
  `kelas_sosial` int(4) DEFAULT NULL,
  `tgl_cetak_kk` datetime DEFAULT NULL,
  `alamat` varchar(200) DEFAULT NULL,
  `id_cluster` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `tweb_keluarga`
--

INSERT INTO `tweb_keluarga` (`id`, `no_kk`, `nik_kepala`, `tgl_daftar`, `kelas_sosial`, `tgl_cetak_kk`, `alamat`, `id_cluster`) VALUES
(1, '5201140104126994', '1', '2016-09-14 04:28:03', NULL, NULL, 'Jalan Arya Banjar Getas, Gang Kerapu No.2', 34),
(2, '5201140104126995', '5', '2016-09-14 04:28:03', NULL, NULL, NULL, 8),
(3, '5201140104166999', '9', '2016-09-14 04:28:03', NULL, NULL, NULL, 12),
(4, '5201140105136997', '12', '2016-09-14 04:28:03', NULL, NULL, NULL, 16),
(5, '5201140106166996', '16', '2016-09-14 04:28:03', NULL, NULL, NULL, 8),
(6, '5201140106167002', '17', '2016-09-14 04:28:03', NULL, NULL, NULL, 17),
(7, '5201140106167003', '19', '2016-09-14 04:28:03', NULL, NULL, NULL, 16),
(8, '5201140107126996', '21', '2016-09-14 04:28:03', NULL, NULL, NULL, 18),
(9, '5201140108146995', '25', '2016-09-14 04:28:03', NULL, NULL, NULL, 18),
(10, '5201140109126996', '26', '2016-09-14 04:28:03', NULL, NULL, NULL, 19),
(11, '5201140109156994', '30', '2016-09-14 04:28:03', NULL, NULL, NULL, 19),
(12, '5201140110137011', '32', '2016-09-14 04:28:03', NULL, NULL, NULL, 20),
(13, '5201140110137038', '35', '2016-09-14 04:28:03', NULL, NULL, NULL, 18),
(14, '5201140110156997', '37', '2016-09-14 04:28:03', NULL, NULL, NULL, 18),
(15, '5201140111126997', '38', '2016-09-14 04:28:03', NULL, NULL, NULL, 17),
(16, '5201140111126999', '39', '2016-09-14 04:28:03', NULL, NULL, NULL, 21),
(17, '5201140112107003', '42', '2016-09-14 04:28:03', NULL, NULL, NULL, 12),
(18, '5201140112126998', '45', '2016-09-14 04:28:03', NULL, NULL, NULL, 22),
(19, '5201140202167000', '51', '2016-09-14 04:28:03', NULL, NULL, NULL, 23),
(20, '5201140202167002', '52', '2016-09-14 04:28:03', NULL, NULL, NULL, 24),
(21, '5201140203136994', '55', '2016-09-14 04:28:03', NULL, NULL, NULL, 8),
(22, '5201140203136995', '56', '2016-09-14 04:28:03', NULL, NULL, NULL, 16),
(23, '5201140203167003', '59', '2016-09-14 04:28:03', NULL, NULL, NULL, 23),
(24, '5201140204166994', '61', '2016-09-14 04:28:03', NULL, NULL, NULL, 25),
(25, '5201140205156994', '62', '2016-09-14 04:28:03', NULL, NULL, NULL, 26),
(26, '5201140205156995', '65', '2016-09-14 04:28:03', NULL, NULL, NULL, 26),
(27, '5201140205156996', '68', '2016-09-14 04:28:03', NULL, NULL, NULL, 25),
(28, '5201140205156997', '71', '2016-09-14 04:28:03', NULL, NULL, NULL, 25),
(29, '5201140206157000', '74', '2016-09-14 04:28:03', NULL, NULL, NULL, 17),
(30, '5201140206157004', '76', '2016-09-14 04:28:03', NULL, NULL, NULL, 27),
(31, '5201140207156998', '77', '2016-09-14 04:28:03', NULL, NULL, NULL, 28),
(32, '5201140207157000', '80', '2016-09-14 04:28:03', NULL, NULL, NULL, 29),
(33, '5201140209156996', '83', '2016-09-14 04:28:03', NULL, NULL, NULL, 30),
(34, '5201140210137022', '84', '2016-09-14 04:28:03', NULL, NULL, NULL, 29),
(35, '5201140211117001', '88', '2016-09-14 04:28:03', NULL, NULL, NULL, 31),
(36, '5201140211117002', '91', '2016-09-14 04:28:03', NULL, NULL, NULL, 31),
(37, '5201140211117003', '95', '2016-09-14 04:28:03', NULL, NULL, NULL, 31),
(38, '1234447890123487', '100', '2020-01-31 09:33:09', NULL, NULL, '', 40);

-- --------------------------------------------------------

--
-- Table structure for table `tweb_keluarga_sejahtera`
--

CREATE TABLE `tweb_keluarga_sejahtera` (
  `id` int(10) NOT NULL DEFAULT 0,
  `nama` varchar(100) DEFAULT NULL,
  `nama_analisis` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tweb_keluarga_sejahtera`
--

INSERT INTO `tweb_keluarga_sejahtera` (`id`, `nama`, `nama_analisis`) VALUES
(1, 'Keluarga Pra Sejahtera', NULL),
(2, 'Keluarga Sejahtera I', NULL),
(3, 'Keluarga Sejahtera II', NULL),
(4, 'Keluarga Sejahtera III', NULL),
(5, 'Keluarga Sejahtera III Plus', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `tweb_kontak`
--

CREATE TABLE `tweb_kontak` (
  `id` int(11) NOT NULL,
  `parent` int(11) DEFAULT NULL,
  `nama` varchar(60) NOT NULL,
  `email` varchar(62) DEFAULT NULL,
  `no_hp` varchar(16) DEFAULT NULL,
  `hal` tinyint(4) DEFAULT NULL,
  `isi` text NOT NULL,
  `waktu` timestamp NOT NULL DEFAULT current_timestamp(),
  `baca` timestamp NULL DEFAULT NULL,
  `judul` varchar(256) DEFAULT NULL,
  `admin` tinyint(4) DEFAULT NULL,
  `ip4` varchar(16) NOT NULL,
  `ua` varchar(128) NOT NULL,
  `token` varchar(13) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tweb_penduduk`
--

CREATE TABLE `tweb_penduduk` (
  `id` int(11) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `nik` decimal(16,0) NOT NULL,
  `id_kk` int(11) DEFAULT 0,
  `kk_level` tinyint(2) NOT NULL DEFAULT 0,
  `id_rtm` int(11) NOT NULL,
  `rtm_level` int(11) NOT NULL,
  `sex` tinyint(4) UNSIGNED DEFAULT NULL,
  `tempatlahir` varchar(100) NOT NULL,
  `tanggallahir` date DEFAULT NULL,
  `agama_id` int(10) UNSIGNED NOT NULL,
  `pendidikan_kk_id` int(10) UNSIGNED NOT NULL,
  `pendidikan_sedang_id` int(10) UNSIGNED NOT NULL,
  `pekerjaan_id` int(10) UNSIGNED NOT NULL,
  `status_kawin` tinyint(4) UNSIGNED NOT NULL,
  `warganegara_id` int(10) UNSIGNED NOT NULL,
  `dokumen_pasport` varchar(45) DEFAULT NULL,
  `dokumen_kitas` int(10) DEFAULT NULL,
  `ayah_nik` varchar(16) NOT NULL,
  `ibu_nik` varchar(16) NOT NULL,
  `nama_ayah` varchar(100) NOT NULL,
  `nama_ibu` varchar(100) NOT NULL,
  `foto` varchar(100) NOT NULL,
  `golongan_darah_id` int(11) NOT NULL,
  `id_cluster` int(11) NOT NULL,
  `status` int(10) UNSIGNED DEFAULT NULL,
  `alamat_sebelumnya` varchar(200) NOT NULL,
  `alamat_sekarang` varchar(200) NOT NULL,
  `status_dasar` tinyint(4) NOT NULL DEFAULT 1,
  `hamil` int(1) DEFAULT NULL,
  `cacat_id` int(11) DEFAULT NULL,
  `sakit_menahun_id` int(11) NOT NULL,
  `akta_lahir` varchar(40) NOT NULL,
  `akta_perkawinan` varchar(40) NOT NULL,
  `tanggalperkawinan` date DEFAULT NULL,
  `akta_perceraian` varchar(40) NOT NULL,
  `tanggalperceraian` date DEFAULT NULL,
  `cara_kb_id` tinyint(2) DEFAULT NULL,
  `telepon` varchar(20) DEFAULT NULL,
  `tanggal_akhir_paspor` date DEFAULT NULL,
  `no_kk_sebelumnya` varchar(30) DEFAULT NULL,
  `ktp_el` tinyint(4) NOT NULL,
  `status_rekam` tinyint(4) NOT NULL DEFAULT 0,
  `waktu_lahir` varchar(5) NOT NULL,
  `tempat_dilahirkan` tinyint(2) NOT NULL,
  `jenis_kelahiran` tinyint(2) NOT NULL,
  `kelahiran_anak_ke` tinyint(2) DEFAULT NULL,
  `penolong_kelahiran` tinyint(2) NOT NULL,
  `berat_lahir` varchar(10) NOT NULL,
  `panjang_lahir` varchar(10) NOT NULL,
  `tag_id_card` varchar(15) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `created_by` int(11) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_by` int(11) DEFAULT NULL,
  `tabel4_length` varchar(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `tweb_penduduk`
--

INSERT INTO `tweb_penduduk` (`id`, `nama`, `nik`, `id_kk`, `kk_level`, `id_rtm`, `rtm_level`, `sex`, `tempatlahir`, `tanggallahir`, `agama_id`, `pendidikan_kk_id`, `pendidikan_sedang_id`, `pekerjaan_id`, `status_kawin`, `warganegara_id`, `dokumen_pasport`, `dokumen_kitas`, `ayah_nik`, `ibu_nik`, `nama_ayah`, `nama_ibu`, `foto`, `golongan_darah_id`, `id_cluster`, `status`, `alamat_sebelumnya`, `alamat_sekarang`, `status_dasar`, `hamil`, `cacat_id`, `sakit_menahun_id`, `akta_lahir`, `akta_perkawinan`, `tanggalperkawinan`, `akta_perceraian`, `tanggalperceraian`, `cara_kb_id`, `telepon`, `tanggal_akhir_paspor`, `no_kk_sebelumnya`, `ktp_el`, `status_rekam`, `waktu_lahir`, `tempat_dilahirkan`, `jenis_kelahiran`, `kelahiran_anak_ke`, `penolong_kelahiran`, `berat_lahir`, `panjang_lahir`, `tag_id_card`, `created_at`, `created_by`, `updated_at`, `updated_by`, `tabel4_length`) VALUES
(1, 'AHLUL', '1973639162710367', 1, 1, 1, 1, 1, 'MANGSIT', '1971-05-20', 1, 3, 18, 26, 2, 1, '', 0, '', '', 'ARFAH', 'RAISAH', '5f75cacca5863.png', 13, 34, 1, '', 'JALAN  KI HAJAR SALOKA NO 86. KECAMATAN SELO', 1, 0, 7, 14, '', '', '1998-06-05', '', NULL, 99, '085239168707', NULL, '', 2, 3, '', 1, 1, 1, 1, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(2, 'AHMAD ALLIF RIZKI', '5201140706966997', 1, 4, 1, 2, 1, 'MANGSIT', '1995-06-07', 1, 1, 18, 1, 1, 1, '', 0, '', '', 'AHLUL', 'RUSDAH', '5e5dd97bb02d8.png', 13, 34, 1, '', '', 1, 0, 7, 14, '', '', NULL, '', NULL, NULL, '081917778707', NULL, '', 1, 1, '', 2, 1, 1, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(3, 'AHMAD HABIB', '5201140301916995', 1, 4, 0, 0, 1, 'MANGSIT', '1990-01-03', 1, 3, 18, 1, 1, 1, NULL, NULL, '', '', 'AHLUL', 'RUSDAH', '', 13, 34, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(4, 'ADINI SEPTIA LISTA', '5201145003976995', 1, 4, 0, 0, 2, 'MANGSIT', '1996-03-10', 1, 4, 18, 2, 2, 1, '', 0, '', '', 'AHLUL', 'RUSDAH', '', 13, 34, 1, '', '', 1, 0, 7, 13, '', '', '2020-10-01', '', NULL, 99, '085239168707', NULL, '', 2, 4, '', 1, 1, 1, 1, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(5, 'AHYAR', '5201141003666996', 2, 1, 3, 1, 1, 'JAKARTA', '1965-03-10', 1, 5, 18, 88, 2, 1, '', 0, '', '', 'PAIMUN', 'SUPINAH', '5e404a345a60f.png', 13, 8, 1, '', '', 1, 0, 0, 0, '', '', '0000-00-00', '', NULL, 0, '', NULL, '', 2, 3, '', 1, 1, 1, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(6, 'APTA MADA RIZKY ALAMSYAH', '1263483590390001', 2, 4, 0, 0, 1, 'DEPOK', '2002-12-14', 1, 2, 18, 3, 1, 1, '', 0, '', '', 'AHYAR', 'ALIYAH', '', 13, 8, 1, '', '', 1, 0, 7, 14, '', '', NULL, '', NULL, NULL, '', NULL, '', 2, 3, '', 1, 1, 1, 1, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(7, 'ALIYAH', '5201144609786995', 2, 3, 0, 0, 2, 'BEKASI', '1977-09-06', 1, 5, 18, 2, 2, 1, NULL, NULL, '', '', 'TAGOR SIPAHUTAR', 'AMAHWATI', '', 13, 8, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(8, 'ALPIANI', '5201144301171725', 2, 4, 0, 0, 2, 'BOGOR', '2007-01-03', 1, 1, 18, 1, 1, 1, NULL, NULL, '', '', 'AHYAR', 'ALIYAH', '', 13, 8, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(9, 'ASHARI', '5201140107867064', 3, 1, 0, 0, 1, 'KERANDANGAN', '1985-12-30', 1, 5, 18, 88, 2, 1, NULL, NULL, '', '', 'H. ABDUL KARIM', 'RADIAH', '', 13, 12, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(10, 'BACHTIAR HADI', '5201142210181724', 3, 4, 0, 0, 1, 'MATARAM', '2008-10-22', 1, 1, 18, 1, 1, 1, NULL, NULL, '', '', 'ASHARI', 'ANGGUN LESTARI PRATAMA', '', 13, 12, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '18:09', 2, 1, 1, 2, '300', '30', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(11, 'ANGGUN LESTARI PRATAMA', '5201146510916995', 3, 3, 0, 0, 2, 'SENGGIGI', '1990-10-25', 1, 4, 18, 88, 2, 1, NULL, NULL, '', '', 'SADIRAH', 'HJ. ROHANI', '', 13, 12, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(12, 'DAHRI', '5201143112797117', 4, 1, 0, 0, 1, 'MASBAGIK', '1978-12-31', 1, 3, 18, 88, 2, 1, NULL, NULL, '', '', 'AMAQ SAHMINI', 'INAQ SAHMINI', '', 13, 16, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(13, 'ERLANGGA DWIKO SAPUTRO', '5201140705156994', 4, 4, 0, 0, 1, 'MENINTING', '2014-05-07', 1, 1, 18, 1, 1, 1, '', 0, '', '', 'DAHRI', 'ASMIATUN', '', 13, 16, 1, '', '', 1, 0, 0, 0, '', '', NULL, '', NULL, NULL, '085239168707', NULL, '', 2, 3, '', 1, 1, 1, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(14, 'FARIDAH', '5201141107101724', 4, 4, 0, 0, 1, 'MASBAGIK', '2000-07-11', 1, 3, 18, 3, 1, 1, NULL, NULL, '', '', 'DAHRI', 'ASMIATUN', '', 13, 16, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(15, 'ASMIATUN', '5201147112817188', 4, 3, 0, 0, 2, 'MASBAGIK', '1980-12-31', 1, 4, 18, 2, 2, 1, NULL, NULL, '', '', 'AMAQ MUJAENI', 'INAQ SAHMINI', '', 13, 16, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(16, 'BAIQ OLIVIA APRILLIANI', '5201145211486994', 5, 1, 0, 0, 2, 'SENGGIGI', '1947-11-12', 1, 1, 18, 1, 4, 1, '', 0, '', '', 'AMAQ SINAREP', 'INAQ SINAREP', '25108087062Nana.jpg', 13, 8, 1, '', '', 1, 0, 0, 0, '', '', NULL, '', NULL, NULL, '', NULL, '', 0, 0, '', 0, 0, NULL, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(17, 'FAUZI', '5201141210906998', 6, 1, 0, 0, 1, 'KERANDANGAN', '1989-10-12', 1, 5, 18, 3, 1, 1, NULL, NULL, '', '', 'SABLI', 'RAOHUN', '', 13, 17, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(18, 'DELLA MAHARANI NINGSIH', '5201147112947048', 6, 9, 0, 0, 2, 'KERANDANGAN', '1993-12-31', 1, 4, 18, 1, 1, 1, NULL, NULL, '', '', 'SABLI', 'RAOHUN', '', 13, 17, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(19, 'HAERUL FATONI', '5201142911936995', 7, 1, 0, 0, 1, 'SENGGIGI', '1992-11-29', 1, 5, 18, 15, 2, 1, NULL, NULL, '', '', 'ANGKASAH', 'MARJANAH', '', 13, 16, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(20, 'DENATUL SUARTINI', '3275014601977005', 7, 3, 0, 0, 2, 'JAKARTA', '1996-01-06', 1, 5, 18, 2, 2, 1, NULL, NULL, '', '', 'G. AMIN. P', 'NGATI', '', 13, 16, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(21, 'HERI IRAWAN', '5201140607636994', 8, 1, 0, 0, 1, 'TELOKE', '1962-07-06', 1, 3, 18, 9, 2, 1, NULL, NULL, '', '', 'AMAK MAJUMI', 'INAK MIDAH', '', 13, 18, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(22, 'HERMAN', '5201140305936994', 8, 4, 0, 0, 1, 'SENGGIGI', '1992-05-03', 1, 4, 18, 1, 1, 1, '', 0, '', '', 'HERI IRAWAN', 'DEWI SAULINA', '', 13, 18, 1, '', '', 1, 0, 0, 0, '', '', NULL, '', NULL, NULL, '', NULL, '', 0, 0, '', 0, 0, NULL, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(23, 'DEWI SAULINA', '5201144808686994', 8, 3, 0, 0, 2, 'KEKERAN', '1967-08-08', 1, 1, 18, 2, 2, 1, NULL, NULL, '', '', 'H. ZAENUDIN', 'INAK NAH', '', 13, 18, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(24, 'ELOK KHALISA SABRINA', '5201144408886994', 8, 4, 0, 0, 2, 'SENGGIGI', '1987-08-04', 1, 4, 18, 88, 1, 1, NULL, NULL, '', '', 'SERIMAN', 'DEWI SAULINA', '', 13, 18, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(25, 'I KETUT PAHING', '5201142210806997', 9, 1, 0, 0, 1, 'MATARAM', '1979-10-22', 1, 5, 18, 88, 2, 1, NULL, NULL, '', '', '-', '-', '', 2, 18, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(26, 'IDA BAGUS MAS BUJANA', '5201143112707040', 10, 1, 0, 0, 1, 'APIT AIK', '1969-12-31', 1, 5, 18, 88, 2, 1, NULL, NULL, '', '', 'SAHMIN', 'MAOSIN', '', 13, 19, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(27, 'JOKO PATMOTO', '5201141009146994', 10, 4, 0, 0, 1, 'MANGSIT', '2013-09-10', 1, 1, 18, 1, 1, 1, NULL, NULL, '', '', 'IDA BAGUS MAS BUJANA', 'FITRIANI', '', 13, 19, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(28, 'KOMANG SALUN', '5201143105121724', 10, 4, 0, 0, 1, 'KAYANGAN', '2002-05-31', 1, 2, 18, 3, 1, 1, NULL, NULL, '', '', 'AMILUDIN', 'FITRIANI', '', 13, 19, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(29, 'FITRIANI', '5201145107836994', 10, 3, 0, 0, 2, 'KAYANGAN', '1982-07-11', 1, 4, 18, 2, 2, 1, NULL, NULL, '', '', 'REMBUK', 'SITIAH', '', 13, 19, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(30, 'LALU WAWAN DININGRAT', '5201141206886994', 11, 1, 0, 0, 1, 'MANGSIT', '1987-06-12', 1, 5, 18, 88, 2, 1, NULL, NULL, '', '', 'MAHSUN SUBUH', 'SARDIAH', '', 13, 19, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(31, 'FITRIANI', '5271016801926995', 11, 3, 0, 0, 2, 'MATARAM', '1991-01-28', 1, 5, 18, 15, 2, 1, NULL, NULL, '', '', 'UMAR', 'RUMINSIH', '', 13, 19, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(32, 'M. FA\'IZ AZAMI', '5201143112897123', 12, 1, 0, 0, 1, 'GEGELANG', '1988-12-31', 1, 5, 18, 88, 2, 1, NULL, NULL, '', '', 'SAREH', 'SUTIMAH', '', 13, 20, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(33, 'HILMIATI', '5201146402906994', 12, 3, 0, 0, 2, 'LOCO', '1989-02-24', 1, 4, 18, 88, 2, 1, NULL, NULL, '', '', 'H. MANSYUR', 'HJ. SA\'ADAH', '', 13, 20, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(34, 'HJ. PARIDAH', '5201144912146994', 12, 4, 0, 0, 2, 'MENINTING', '2013-12-09', 1, 1, 18, 1, 1, 1, NULL, NULL, '', '', 'M. FA\'IZ AZAMI', 'HILMIATI', '', 13, 20, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(35, 'HJ. SAMIRAH', '5201147112767266', 13, 1, 0, 0, 2, 'SENGGIGI', '1975-12-31', 1, 3, 18, 15, 3, 1, NULL, NULL, '', '', 'DAMSYAH', 'MARWIYAH', '', 13, 18, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(36, 'HUR MINAH', '5201144504131726', 13, 4, 0, 0, 2, 'SENGGIGI', '2003-04-05', 1, 3, 18, 3, 1, 1, '', 0, '', '', 'MARSINI', 'KHODIJAH', '', 13, 18, 1, '', '', 1, 0, 7, 13, '', '', NULL, '', NULL, NULL, '08988002020', NULL, '', 2, 8, '', 1, 1, 1, 1, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(37, 'HUSNAH', '5201145905936994', 14, 1, 0, 0, 2, 'LOTIM', '1992-05-19', 1, 4, 18, 88, 1, 1, NULL, NULL, '', '', '-', '-', '', 13, 18, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(38, 'IDA AYU OKA SUKERTI', '5201147112587053', 15, 1, 0, 0, 2, 'KERANDANGAN', '1957-12-31', 1, 3, 18, 88, 4, 1, NULL, NULL, '', '', 'ANGGRAH', 'HABIBAH', '', 13, 17, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(39, 'M. JAYADI', '5201143112837098', 16, 1, 0, 0, 1, 'SENGGIGI', '1982-12-31', 1, 5, 18, 88, 2, 1, NULL, NULL, '', '', 'IKHSAN', 'SAIDAH', '', 13, 21, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(40, 'JARIYAH', '5201145406916994', 16, 3, 0, 0, 2, 'SENGGIGI', '1990-06-14', 1, 4, 18, 2, 2, 1, NULL, NULL, '', '', 'SEGEP', 'HURNIWATI', '', 13, 21, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(41, 'LIHAM SATUN', '5201147112116995', 16, 4, 0, 0, 2, 'MATARAM', '2010-12-31', 1, 1, 18, 1, 1, 1, NULL, NULL, '', '', 'M. JAYADI', 'JARIYAH', '', 13, 21, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(42, 'M. NUR SAHID', '5201140507916996', 17, 1, 0, 0, 1, 'KERANDANGAN', '1990-07-05', 1, 4, 18, 88, 2, 1, NULL, NULL, '', '', '-', '-', '', 13, 12, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(43, 'MADE ASTAWE', '5201142503181724', 17, 4, 0, 0, 1, 'KERANDANGAN', '2008-03-25', 1, 1, 18, 1, 1, 1, NULL, NULL, '', '', 'M. NUR SAHID', 'MAISAH', '', 13, 12, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(44, 'MAISAH', '5201144605936994', 17, 3, 0, 0, 2, 'KERANDANGAN', '1992-05-06', 4, 1, 18, 88, 2, 1, NULL, NULL, '', '', '-', '-', '', 13, 12, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(45, 'MARSUNIN YOGA PRATAMA', '5201143112677056', 18, 1, 0, 0, 1, 'PEJARAKAN', '1966-12-31', 1, 3, 18, 9, 2, 1, NULL, NULL, '', '', 'MISRAH', 'INAQ MISDAH', '', 13, 22, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(46, 'MARZUKI', '5201141003966996', 18, 4, 0, 0, 1, 'LOCO', '1995-03-10', 1, 5, 18, 3, 1, 1, NULL, NULL, '', '', 'MARSUNIN YOGA PRATAMA', 'MARLIA SAJIDA', '', 13, 22, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(47, 'MUHAMAD HAMDI', '5201141706986996', 18, 4, 0, 0, 1, 'LOCO', '1997-06-17', 1, 4, 18, 3, 1, 1, NULL, NULL, '', '', 'MARSUNIN YOGA PRATAMA', 'MARLIA SAJIDA', '', 13, 22, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(48, 'MARLIA SAJIDA', '5201147112707088', 18, 3, 0, 0, 2, 'PEJARAKAN', '1969-12-31', 1, 3, 18, 2, 2, 1, NULL, NULL, '', '', 'H. ZAINUDIN', 'INAQ NAH', '', 13, 22, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(49, 'MIRA FANDA', '5201146704906995', 18, 4, 0, 0, 2, 'LOCO', '1989-04-27', 1, 5, 18, 88, 4, 1, NULL, NULL, '', '', 'MARSUNIN YOGA PRATAMA', 'MARLIA SAJIDA', '', 13, 22, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(50, 'MUNAAH', '5201146304171724', 18, 4, 0, 0, 2, 'LOCO', '2007-04-23', 1, 1, 18, 1, 1, 1, NULL, NULL, '', '', 'MARSUNIN YOGA PRATAMA', 'MARLIA SAJIDA', '', 13, 22, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(51, 'MUHAMAD KABIR', '5201140107917031', 19, 1, 0, 0, 1, 'SENGGIGI', '1985-12-31', 1, 3, 18, 88, 2, 1, NULL, NULL, '', '', 'MUNIAH', 'SALIKIN', '', 13, 23, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(52, 'MUHAMAD SUHAD', '5201141704876995', 20, 1, 0, 0, 1, 'SENGGIGI', '1982-12-10', 1, 5, 18, 15, 2, 1, NULL, NULL, '', '', 'MUNIAH', 'HAJRIAH', '', 13, 24, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(53, 'MUHAMMAD HAIKAL FIRMANSYAH', '5201140308151724', 20, 4, 0, 0, 1, 'LOCO', '2005-08-03', 1, 2, 18, 1, 1, 1, NULL, NULL, '', '', 'MUHAMAD SUHAD', 'KHADIJAH', '', 13, 24, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(54, 'MURNIAH', '5201145904846994', 20, 3, 0, 0, 2, 'SETANGI', '1991-03-04', 1, 4, 18, 2, 2, 1, NULL, NULL, '', '', 'SAHABUDIN', 'SAKMAH', '', 13, 24, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(55, 'MURNIATI SAGITA', '5201144112726996', 21, 1, 0, 0, 2, 'YOGYAKARTA', '1971-12-01', 1, 5, 18, 88, 2, 1, NULL, NULL, '', '', 'UMAR SANTOSA', 'MIRANTI', '', 1, 8, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(56, 'MUHAMMAD RIFAI', '5201143105926995', 22, 1, 0, 0, 1, 'LOCO', '1991-05-31', 4, 4, 18, 88, 2, 1, NULL, NULL, '', '', 'I WAYAN MERTI', 'NI NYOMAN RENI', '', 13, 16, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(57, 'NADIA ROSDIANA', '5201144305936996', 22, 3, 0, 0, 2, 'MATARAM', '1992-05-03', 4, 4, 18, 2, 2, 1, NULL, NULL, '', '', 'I WAYAN PARTA', 'NI NENGAH SUDINI', '', 13, 16, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(58, 'NI KOMANG PONIASIH', '5201146206126994', 22, 4, 0, 0, 2, 'MATARAM', '2011-06-22', 4, 1, 18, 1, 1, 1, NULL, NULL, '', '', 'MURNIATI SAGITA', 'NADIA ROSDIANA', '', 13, 16, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(59, 'MUHAMMAD WIRDA MAULANA IBRAHIM', '5201143112417056', 23, 1, 0, 0, 1, 'SENGGIGI', '1940-12-31', 1, 1, 18, 9, 2, 1, NULL, NULL, '', '', 'AMAQ SUN -ALM-', 'INAQ SUN -ALM-', '', 13, 23, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(60, 'NI LUH NITA SARI', '5201147112466997', 23, 3, 0, 0, 2, 'SENTELUK', '1945-12-31', 1, 1, 18, 2, 2, 1, NULL, NULL, '', '', 'AMAQ IRAH', 'INAQ IRAH', '', 13, 23, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(61, 'NI NENGAH AYU KARSINI', '5201145505946996', 24, 1, 0, 0, 2, 'SENGGIGI', '1993-05-15', 1, 2, 18, 15, 1, 1, NULL, NULL, '', '', 'H HAMDANI', 'SANERIAH', '', 13, 25, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(62, 'MUKSAN', '5201143112957094', 25, 1, 0, 0, 1, 'MANGSIT', '1994-12-31', 1, 4, 18, 88, 2, 1, NULL, NULL, '', '', 'MISDAH', 'RABIAH', '', 13, 26, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(63, 'NURHAYATI', '5201145509146994', 25, 4, 0, 0, 2, 'MENINTING', '2013-09-15', 1, 1, 18, 1, 1, 1, NULL, NULL, '', '', 'MUKSAN', 'NUR\'AINI', '', 13, 26, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(64, 'MURSIDIN', '5201142204966994', 26, 4, 0, 0, 1, 'MANGSIT', '1995-04-22', 1, 3, 18, 11, 1, 1, NULL, NULL, '', '', 'RUSNAH (ALM)', 'NURHIDAYAH', '', 13, 26, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(65, 'NURHIDAYAH', '5201144209766995', 26, 1, 0, 0, 2, 'MANGSIT', '1975-09-02', 1, 3, 18, 2, 4, 1, NULL, NULL, '', '', 'ISMAIL', 'JUMINAH', '', 13, 26, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(66, 'NURJANAH', '5201145005101724', 26, 4, 0, 0, 2, 'MONTONG', '2000-05-10', 1, 4, 18, 3, 1, 1, NULL, NULL, '', '', 'RUSNAH (ALM)', 'NURHIDAYAH', '', 13, 26, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(67, 'NURUL AINUN', '5201144108121724', 26, 4, 0, 0, 2, 'MANGSIT', '2002-08-01', 1, 2, 18, 3, 1, 1, NULL, NULL, '', '', 'RUSNAH', 'NURHIDAYAH', '', 13, 26, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(68, 'MUSAHAB', '5201141607936996', 27, 1, 0, 0, 1, 'LOTENG', '1992-07-16', 1, 6, 18, 88, 2, 1, NULL, NULL, '', '', 'LALU ROSIDI', 'BQ. ALISA', '', 13, 25, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(69, 'NURUL FAIZAH', '5201145003936994', 27, 3, 0, 0, 2, 'SENGGIGI', '1992-03-10', 1, 5, 18, 88, 2, 1, NULL, NULL, '', '', 'SAHUR', 'SARE\'AH', '', 13, 25, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(70, 'NURUL HIDAYATI', '5201147004136996', 27, 4, 0, 0, 2, 'MATARAM', '2012-04-30', 1, 1, 18, 1, 1, 1, NULL, NULL, '', '', 'MUSAHAB', 'NURUL FAIZAH', '', 13, 25, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(71, 'NAPIAH', '5201141303906995', 28, 1, 0, 0, 1, 'SENGGIGI', '1989-03-13', 1, 4, 18, 11, 2, 1, NULL, NULL, '', '', 'MUNIAH', 'HAJARIAH', '', 13, 25, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(72, 'RACHEL YULIANTI', '5201146507966995', 28, 3, 0, 0, 2, 'MELASE', '1995-07-25', 1, 4, 18, 2, 2, 1, NULL, NULL, '', '', 'LUKMAN', 'MUSNAH', '', 13, 25, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(73, 'RAISHA MAULIDYA', '5201144701156995', 28, 4, 0, 0, 2, 'MENINTING', '2014-01-07', 1, 1, 18, 1, 1, 1, NULL, NULL, '', '', 'NAPIAH', 'RACHEL YULIANTI', '', 13, 25, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(74, 'PATANUL HUSNUL', '5201143112667000', 29, 1, 0, 0, 1, 'JAWA TIMUR', '1965-12-31', 1, 5, 18, 88, 2, 1, NULL, NULL, '', '', 'AHMAD', 'ASIH', '', 13, 17, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(75, 'RATNAWATY', '5201145512796995', 29, 3, 0, 0, 2, 'KERANDANGAN', '1978-12-15', 1, 5, 18, 84, 2, 1, NULL, NULL, '', '', 'JUM', 'REMAH', '', 13, 17, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(76, 'RABITAH', '5201140312896994', 30, 1, 0, 0, 1, 'KERANDANGAN', '1988-12-03', 4, 4, 18, 88, 1, 1, NULL, NULL, '', '', '-', '-', '', 13, 27, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(77, 'ROMI FAISAL', '5201141506856997', 31, 1, 0, 0, 1, 'MANGSIT', '1984-06-15', 1, 3, 18, 15, 2, 1, NULL, NULL, '', '', 'MUNTAHAR', 'MAKNAH', '', 13, 28, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(78, 'RAUDATUL ILMI', '5201145808816994', 31, 3, 0, 0, 2, 'IRENG DAYE', '1980-08-18', 1, 4, 18, 2, 2, 1, NULL, NULL, '', '', 'MUDAHIR', 'RUMISAH', '', 13, 28, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(79, 'ROHANI', '5201144306116994', 31, 4, 0, 0, 2, 'MANGSIT', '2010-06-03', 1, 1, 18, 1, 1, 1, NULL, NULL, '', '', 'ROMI FAISAL', 'RAUDATUL ILMI', '', 13, 28, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(80, 'RUKIAH', '5201145909946994', 32, 1, 0, 0, 2, 'SERANG', '1993-09-19', 1, 4, 18, 88, 3, 1, NULL, NULL, '', '', '-', '-', '', 13, 29, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(81, 'RUMALI', '5201144507886994', 32, 9, 0, 0, 2, 'JAKARTA', '1987-07-05', 1, 4, 18, 88, 1, 1, NULL, NULL, '', '', '-', '-', '', 13, 29, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(82, 'RONI', '5201140301836997', 33, 4, 0, 0, 1, 'DENPASAR', '1982-01-03', 4, 5, 18, 15, 1, 1, NULL, NULL, '', '', 'IDA BAGUS PUTU WIADNYA', 'RUSMAYANTI', '', 13, 30, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(83, 'RUSMAYANTI', '5201145003546994', 33, 1, 0, 0, 2, 'DENPASAR', '1953-03-10', 4, 5, 18, 88, 2, 1, NULL, NULL, '', '', 'IDA BAGUS MAS', 'IDA AYU RAKA', '', 13, 30, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(84, 'RUSNI', '5201143112707180', 34, 1, 0, 0, 1, 'KEKERAN', '1969-12-31', 1, 3, 18, 9, 2, 1, NULL, NULL, '', '', '-', '-', '', 13, 29, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(85, 'SAPIAH', '5201147011726994', 34, 3, 0, 0, 2, 'KEKERAN', '1971-11-30', 1, 3, 18, 2, 2, 1, NULL, NULL, '', '', '-', '-', '', 13, 29, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(86, 'SAPINAH', '5201145701966994', 34, 4, 0, 0, 2, 'SENGGIGI', '1995-01-17', 1, 5, 18, 3, 1, 1, NULL, NULL, '', '', 'RUSNI', 'SAPIAH', '', 13, 29, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(87, 'SARRA LANGELAND', '5201145111946996', 34, 4, 0, 0, 2, 'SENGGIGI', '1993-11-11', 1, 5, 18, 3, 1, 1, NULL, NULL, '', '', 'RUSNI', 'SAPIAH', '', 13, 29, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(88, 'SAHRONI', '5201143112617096', 35, 1, 0, 0, 1, 'MEDAS', '1960-12-31', 1, 4, 18, 88, 2, 1, NULL, NULL, '', '', 'SADIYAH', 'INAQ SADIAH', '', 13, 31, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(89, 'SERIMAN', '5201141012846995', 35, 4, 0, 0, 1, 'SENGGIGI', '1983-12-10', 1, 5, 18, 15, 1, 1, NULL, NULL, '', '', 'SAHRONI', 'NURLAELA', '', 13, 31, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(90, 'SUNYOTOH', '5201143112817139', 35, 4, 0, 0, 1, 'MEDAS', '1980-12-31', 1, 5, 18, 15, 1, 1, NULL, NULL, '', '', 'SAHRONI', 'NURLAELA', '', 13, 31, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(91, 'SYARIFUL KALAM', '5201141707776994', 36, 1, 0, 0, 1, 'SENGGIGI', '1976-07-17', 1, 5, 18, 88, 2, 1, NULL, NULL, '', '', 'H. ABDURAHMAN', 'NAFISAH', '', 1, 31, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(92, 'SITI AISYAH', '5201146210776994', 36, 3, 0, 0, 2, 'SUKARAJA', '1976-10-22', 1, 4, 18, 2, 2, 1, NULL, NULL, '', '', 'AMINALLOH', 'RAEHAN', '', 2, 31, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(93, 'SITI PAOZIAH', '5201146312161724', 36, 4, 0, 0, 2, 'SENGGIGI', '2006-12-23', 1, 1, 18, 1, 1, 1, NULL, NULL, '', '', 'SYARIFUL KALAM', 'SITI AISYAH', '', 13, 31, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(94, 'SUKMA UTAMI', '5201144607996998', 36, 4, 0, 0, 2, 'SENGGIGI', '1998-07-06', 1, 4, 18, 3, 1, 1, NULL, NULL, '', '', 'SYARIFUL KALAM', 'SITI AISYAH', '', 5, 31, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(95, 'WAHID ALIAS H. MAHSUN', '5201141212816996', 37, 1, 0, 0, 1, 'SENGGIGI', '1980-12-12', 1, 5, 18, 88, 2, 1, NULL, NULL, '', '', 'H. ABDURRAHMAN', 'NAFISAH', '', 13, 31, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(96, 'WAYAN EKA PRAWATA', '5201142003136994', 37, 4, 0, 0, 1, 'GUNUNG SARI', '2012-03-20', 1, 1, 18, 1, 1, 1, '', 0, '', '', 'WAHID ALIAS H. MAHSUN', 'ULFA WIDIAWATI', 'IMG_20171103_073801.jpg', 13, 31, 1, '', '', 1, 0, 0, 0, '', '', NULL, '', NULL, NULL, '', NULL, '', 1, 2, '', 0, 0, NULL, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(97, 'ULFA WIDIAWATI', '5201145203896994', 37, 3, 0, 0, 2, 'JOHAR PELITA', '1988-03-12', 1, 5, 18, 88, 2, 1, NULL, NULL, '', '', 'ZAMHARIN', 'SITIYAH', '', 13, 31, 1, '', '', 1, NULL, NULL, 0, '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, 0, 0, '', 0, 0, 0, 0, '0', '', NULL, '2019-05-28 13:45:28', 0, '2019-05-28 13:45:28', 0, NULL),
(98, 'Dadan Ramdani', '1234567890123456', 0, 1, 0, 0, 1, '', NULL, 1, 8, 12, 15, 2, 1, '', 0, '', '', '', '', '5e188cfd100a1.png', 1, 11, 1, '', 'Jalan Arya Banjar Getas, Gg. Kerapu No.3', 1, 0, 7, 14, '', '', NULL, '', NULL, 99, '+6285239168707', NULL, '1234567890987654', 1, 1, '', 1, 1, NULL, 1, '0', '', NULL, '2020-01-10 13:41:01', 0, '2020-01-10 13:41:01', NULL, NULL),
(99, 'Sutono Rejosari', '1234567890123455', 0, 1, 0, 0, 1, '', NULL, 1, 5, 11, 16, 1, 1, '', 0, '', '', '', '', '5e188de8f396c.png', 1, 11, 3, '', 'Jalan Arya Banjar Getas, Gg. Kakap No.7', 1, 0, 7, 14, '', '', NULL, '', NULL, NULL, '+6281917778707', NULL, '1234567890987655', 2, 4, '', 1, 1, NULL, 1, '0', '', NULL, '2020-01-10 13:44:57', 0, '2020-01-10 13:44:57', NULL, NULL),
(100, 'SUPARDIN WAKWAW', '1234567890123487', 38, 1, 0, 0, 1, 'AMPENAN', '1986-06-13', 1, 9, 18, 5, 2, 1, '', 0, '', '', '', '', '', 13, 40, 1, '', '', 1, 0, 7, 14, '', '1234567890987654', '2007-12-26', '', NULL, 99, '', NULL, '1234567890673487', 2, 4, '', 1, 1, 1, 4, '0', '', NULL, '2020-01-31 09:33:09', 0, '2020-01-31 09:33:09', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `tweb_penduduk_agama`
--

CREATE TABLE `tweb_penduduk_agama` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `tweb_penduduk_agama`
--

INSERT INTO `tweb_penduduk_agama` (`id`, `nama`) VALUES
(1, 'Islam'),
(2, 'Kristen'),
(3, 'Katholik'),
(4, 'Hindu'),
(5, 'Budha'),
(6, 'Khonghucu'),
(7, 'Kepercayaan Terhadap Tuhan YME / Lainnya');

-- --------------------------------------------------------

--
-- Table structure for table `tweb_penduduk_hubungan`
--

CREATE TABLE `tweb_penduduk_hubungan` (
  `id` int(10) NOT NULL,
  `nama` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `tweb_penduduk_hubungan`
--

INSERT INTO `tweb_penduduk_hubungan` (`id`, `nama`) VALUES
(1, 'Kepala Keluarga'),
(2, 'Suami'),
(3, 'Istri'),
(4, 'Anak'),
(5, 'Menantu'),
(6, 'Cucu'),
(7, 'Orang Tua'),
(8, 'Mertua'),
(9, 'Famili'),
(10, 'Pembantu'),
(11, 'Lainnya');

-- --------------------------------------------------------

--
-- Table structure for table `tweb_penduduk_kawin`
--

CREATE TABLE `tweb_penduduk_kawin` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `tweb_penduduk_kawin`
--

INSERT INTO `tweb_penduduk_kawin` (`id`, `nama`) VALUES
(1, 'BELUM KAWIN'),
(2, 'KAWIN'),
(3, 'CERAI HIDUP'),
(4, 'CERAI MATI');

-- --------------------------------------------------------

--
-- Table structure for table `tweb_penduduk_mandiri`
--

CREATE TABLE `tweb_penduduk_mandiri` (
  `pin` char(32) NOT NULL,
  `last_login` datetime DEFAULT NULL,
  `tanggal_buat` datetime DEFAULT NULL,
  `id_pend` int(9) NOT NULL,
  `kode` varchar(8) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tweb_penduduk_mandiri`
--

INSERT INTO `tweb_penduduk_mandiri` (`pin`, `last_login`, `tanggal_buat`, `id_pend`, `kode`) VALUES
('3645e735f033e8482be0c7993fcba946', '2020-11-11 13:24:12', '2020-09-10 16:42:34', 1, '147764'),
('3645e735f033e8482be0c7993fcba946', '2020-10-05 19:18:13', '2020-09-21 10:18:25', 6, NULL),
('3645e735f033e8482be0c7993fcba946', '2020-09-21 11:34:13', '2020-09-21 10:30:39', 11, NULL),
('3645e735f033e8482be0c7993fcba946', '2020-09-21 11:37:34', '2020-09-21 10:34:01', 16, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `tweb_penduduk_map`
--

CREATE TABLE `tweb_penduduk_map` (
  `id` int(11) NOT NULL,
  `lat` varchar(24) NOT NULL,
  `lng` varchar(24) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tweb_penduduk_pekerjaan`
--

CREATE TABLE `tweb_penduduk_pekerjaan` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `tweb_penduduk_pekerjaan`
--

INSERT INTO `tweb_penduduk_pekerjaan` (`id`, `nama`) VALUES
(1, 'BELUM/TIDAK BEKERJA'),
(2, 'MENGURUS RUMAH TANGGA'),
(3, 'PELAJAR/MAHASISWA'),
(4, 'PENSIUNAN'),
(5, 'PEGAWAI NEGERI SIPIL (PNS)'),
(6, 'TENTARA NASIONAL INDONESIA (TNI)'),
(7, 'KEPOLISIAN RI (POLRI)'),
(8, 'PERDAGANGAN'),
(9, 'PETANI/PEKEBUN'),
(10, 'PETERNAK'),
(11, 'NELAYAN/PERIKANAN'),
(12, 'INDUSTRI'),
(13, 'KONSTRUKSI'),
(14, 'TRANSPORTASI'),
(15, 'KARYAWAN SWASTA'),
(16, 'KARYAWAN BUMN'),
(17, 'KARYAWAN BUMD'),
(18, 'KARYAWAN HONORER'),
(19, 'BURUH HARIAN LEPAS'),
(20, 'BURUH TANI/PERKEBUNAN'),
(21, 'BURUH NELAYAN/PERIKANAN'),
(22, 'BURUH PETERNAKAN'),
(23, 'PEMBANTU RUMAH TANGGA'),
(24, 'TUKANG CUKUR'),
(25, 'TUKANG LISTRIK'),
(26, 'TUKANG BATU'),
(27, 'TUKANG KAYU'),
(28, 'TUKANG SOL SEPATU'),
(29, 'TUKANG LAS/PANDAI BESI'),
(30, 'TUKANG JAHIT'),
(31, 'TUKANG GIGI'),
(32, 'PENATA RIAS'),
(33, 'PENATA BUSANA'),
(34, 'PENATA RAMBUT'),
(35, 'MEKANIK'),
(36, 'SENIMAN'),
(37, 'TABIB'),
(38, 'PARAJI'),
(39, 'PERANCANG BUSANA'),
(40, 'PENTERJEMAH'),
(41, 'IMAM MASJID'),
(42, 'PENDETA'),
(43, 'PASTOR'),
(44, 'WARTAWAN'),
(45, 'USTADZ/MUBALIGH'),
(46, 'JURU MASAK'),
(47, 'PROMOTOR ACARA'),
(48, 'ANGGOTA DPR-RI'),
(49, 'ANGGOTA DPD'),
(50, 'ANGGOTA BPK'),
(51, 'PRESIDEN'),
(52, 'WAKIL PRESIDEN'),
(53, 'ANGGOTA MAHKAMAH KONSTITUSI'),
(54, 'ANGGOTA KABINET KEMENTERIAN'),
(55, 'DUTA BESAR'),
(56, 'GUBERNUR'),
(57, 'WAKIL GUBERNUR'),
(58, 'BUPATI'),
(59, 'WAKIL BUPATI'),
(60, 'WALIKOTA'),
(61, 'WAKIL WALIKOTA'),
(62, 'ANGGOTA DPRD PROVINSI'),
(63, 'ANGGOTA DPRD KABUPATEN/KOTA'),
(64, 'DOSEN'),
(65, 'GURU'),
(66, 'PILOT'),
(67, 'PENGACARA'),
(68, 'NOTARIS'),
(69, 'ARSITEK'),
(70, 'AKUNTAN'),
(71, 'KONSULTAN'),
(72, 'DOKTER'),
(73, 'BIDAN'),
(74, 'PERAWAT'),
(75, 'APOTEKER'),
(76, 'PSIKIATER/PSIKOLOG'),
(77, 'PENYIAR TELEVISI'),
(78, 'PENYIAR RADIO'),
(79, 'PELAUT'),
(80, 'PENELITI'),
(81, 'SOPIR'),
(82, 'PIALANG'),
(83, 'PARANORMAL'),
(84, 'PEDAGANG'),
(85, 'PERANGKAT DESA'),
(86, 'KEPALA DESA'),
(87, 'BIARAWATI'),
(88, 'WIRASWASTA'),
(89, 'LAINNYA');

-- --------------------------------------------------------

--
-- Table structure for table `tweb_penduduk_pendidikan`
--

CREATE TABLE `tweb_penduduk_pendidikan` (
  `id` tinyint(3) NOT NULL,
  `nama` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `tweb_penduduk_pendidikan`
--

INSERT INTO `tweb_penduduk_pendidikan` (`id`, `nama`) VALUES
(1, 'BELUM MASUK TK/KELOMPOK BERMAIN'),
(2, 'SEDANG TK/KELOMPOK BERMAIN'),
(3, 'TIDAK PERNAH SEKOLAH'),
(4, 'SEDANG SD/SEDERAJAT'),
(5, 'TIDAK TAMAT SD/SEDERAJAT'),
(6, 'SEDANG SLTP/SEDERAJAT'),
(7, 'SEDANG SLTA/SEDERAJAT'),
(8, 'SEDANG  D-1/SEDERAJAT'),
(9, 'SEDANG D-2/SEDERAJAT'),
(10, 'SEDANG D-3/SEDERAJAT'),
(11, 'SEDANG  S-1/SEDERAJAT'),
(12, 'SEDANG S-2/SEDERAJAT'),
(13, 'SEDANG S-3/SEDERAJAT'),
(14, 'SEDANG SLB A/SEDERAJAT'),
(15, 'SEDANG SLB B/SEDERAJAT'),
(16, 'SEDANG SLB C/SEDERAJAT'),
(17, 'TIDAK DAPAT MEMBACA DAN MENULIS HURUF LATIN/ARAB'),
(18, 'TIDAK SEDANG SEKOLAH');

-- --------------------------------------------------------

--
-- Table structure for table `tweb_penduduk_pendidikan_kk`
--

CREATE TABLE `tweb_penduduk_pendidikan_kk` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `tweb_penduduk_pendidikan_kk`
--

INSERT INTO `tweb_penduduk_pendidikan_kk` (`id`, `nama`) VALUES
(1, 'TIDAK / BELUM SEKOLAH'),
(2, 'BELUM TAMAT SD/SEDERAJAT'),
(3, 'TAMAT SD / SEDERAJAT'),
(4, 'SLTP/SEDERAJAT'),
(5, 'SLTA / SEDERAJAT'),
(6, 'DIPLOMA I / II'),
(7, 'AKADEMI/ DIPLOMA III/S. MUDA'),
(8, 'DIPLOMA IV/ STRATA I'),
(9, 'STRATA II'),
(10, 'STRATA III');

-- --------------------------------------------------------

--
-- Table structure for table `tweb_penduduk_sex`
--

CREATE TABLE `tweb_penduduk_sex` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(15) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `tweb_penduduk_sex`
--

INSERT INTO `tweb_penduduk_sex` (`id`, `nama`) VALUES
(1, 'Laki-laki'),
(2, 'Perempuan');

-- --------------------------------------------------------

--
-- Table structure for table `tweb_penduduk_status`
--

CREATE TABLE `tweb_penduduk_status` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tweb_penduduk_status`
--

INSERT INTO `tweb_penduduk_status` (`id`, `nama`) VALUES
(1, 'Tetap'),
(2, 'Tidak Aktif'),
(3, 'Pendatang');

-- --------------------------------------------------------

--
-- Table structure for table `tweb_penduduk_umur`
--

CREATE TABLE `tweb_penduduk_umur` (
  `id` int(11) NOT NULL,
  `nama` varchar(25) DEFAULT NULL,
  `dari` int(11) DEFAULT NULL,
  `sampai` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tweb_penduduk_umur`
--

INSERT INTO `tweb_penduduk_umur` (`id`, `nama`, `dari`, `sampai`, `status`) VALUES
(1, 'BALITA', 0, 5, 0),
(2, 'ANAK-ANAK', 6, 17, 0),
(3, 'DEWASA', 18, 30, 0),
(4, 'TUA', 31, 70, 0),
(5, 'MANULA', 71, 120, 0),
(6, 'Di bawah 1 Tahun', 0, 1, 1),
(9, '2 s/d 4 Tahun', 2, 4, 1),
(12, '5 s/d 9 Tahun', 5, 9, 1),
(13, '10 s/d 14 Tahun', 10, 14, 1),
(14, '15 s/d 19 Tahun', 15, 19, 1),
(15, '20 s/d 24 Tahun', 20, 24, 1),
(16, '25 s/d 29 Tahun', 25, 29, 1),
(17, '30 s/d 34 Tahun', 30, 34, 1),
(18, '35 s/d 39 Tahun ', 35, 39, 1),
(19, '40 s/d 44 Tahun', 40, 44, 1),
(20, '45 s/d 49 Tahun', 45, 49, 1),
(21, '50 s/d 54 Tahun', 50, 54, 1),
(22, '55 s/d 59 Tahun', 55, 59, 1),
(23, '60 s/d 64 Tahun', 60, 64, 1),
(24, '65 s/d 69 Tahun', 65, 69, 1),
(25, '70 s/d 74 Tahun', 70, 74, 1),
(26, 'Di atas 75 Tahun', 75, 99999, 1);

-- --------------------------------------------------------

--
-- Table structure for table `tweb_penduduk_warganegara`
--

CREATE TABLE `tweb_penduduk_warganegara` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(25) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tweb_penduduk_warganegara`
--

INSERT INTO `tweb_penduduk_warganegara` (`id`, `nama`) VALUES
(1, 'WNI'),
(2, 'WNA'),
(3, 'DUA KEWARGANEGARAAN');

-- --------------------------------------------------------

--
-- Table structure for table `tweb_rtm`
--

CREATE TABLE `tweb_rtm` (
  `id` int(11) NOT NULL,
  `nik_kepala` int(11) NOT NULL,
  `no_kk` varchar(20) NOT NULL,
  `tgl_daftar` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `kelas_sosial` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tweb_rtm`
--

INSERT INTO `tweb_rtm` (`id`, `nik_kepala`, `no_kk`, `tgl_daftar`, `kelas_sosial`) VALUES
(3, 5, '04020700003', '2020-09-30 09:46:46', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `tweb_rtm_hubungan`
--

CREATE TABLE `tweb_rtm_hubungan` (
  `id` tinyint(4) NOT NULL,
  `nama` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tweb_rtm_hubungan`
--

INSERT INTO `tweb_rtm_hubungan` (`id`, `nama`) VALUES
(1, 'Kepala Rumah Tangga'),
(2, 'Anggota');

-- --------------------------------------------------------

--
-- Table structure for table `tweb_sakit_menahun`
--

CREATE TABLE `tweb_sakit_menahun` (
  `id` int(11) NOT NULL,
  `nama` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tweb_sakit_menahun`
--

INSERT INTO `tweb_sakit_menahun` (`id`, `nama`) VALUES
(1, 'JANTUNG'),
(2, 'LEVER'),
(3, 'PARU-PARU'),
(4, 'KANKER'),
(5, 'STROKE'),
(6, 'DIABETES MELITUS'),
(7, 'GINJAL'),
(8, 'MALARIA'),
(9, 'LEPRA/KUSTA'),
(10, 'HIV/AIDS'),
(11, 'GILA/STRESS'),
(12, 'TBC'),
(13, 'ASTHMA'),
(14, 'TIDAK ADA/TIDAK SAKIT');

-- --------------------------------------------------------

--
-- Table structure for table `tweb_status_dasar`
--

CREATE TABLE `tweb_status_dasar` (
  `id` int(10) UNSIGNED NOT NULL,
  `nama` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tweb_status_dasar`
--

INSERT INTO `tweb_status_dasar` (`id`, `nama`) VALUES
(1, 'HIDUP'),
(2, 'MATI'),
(3, 'PINDAH'),
(4, 'HILANG'),
(9, 'TIDAK VALID');

-- --------------------------------------------------------

--
-- Table structure for table `tweb_status_ktp`
--

CREATE TABLE `tweb_status_ktp` (
  `id` tinyint(5) NOT NULL,
  `nama` varchar(50) NOT NULL,
  `ktp_el` tinyint(4) NOT NULL,
  `status_rekam` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `tweb_status_ktp`
--

INSERT INTO `tweb_status_ktp` (`id`, `nama`, `ktp_el`, `status_rekam`) VALUES
(1, 'Belum Rekam', 1, '2'),
(2, 'Sudah Rekam', 2, '3'),
(3, 'Card Printed', 2, '4'),
(4, 'Print Ready Record', 2, '5'),
(5, 'Card Shipped', 2, '6'),
(6, 'Send For Card Printing', 2, '7'),
(7, 'Card Issued', 2, '8');

-- --------------------------------------------------------

--
-- Table structure for table `tweb_surat_atribut`
--

CREATE TABLE `tweb_surat_atribut` (
  `id` int(11) NOT NULL,
  `id_surat` int(11) NOT NULL,
  `id_tipe` tinyint(4) NOT NULL,
  `nama` varchar(40) NOT NULL,
  `long` tinyint(4) NOT NULL,
  `kode` tinyint(4) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tweb_surat_format`
--

CREATE TABLE `tweb_surat_format` (
  `id` int(11) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `url_surat` varchar(100) NOT NULL,
  `kode_surat` varchar(10) NOT NULL,
  `lampiran` varchar(100) DEFAULT NULL,
  `kunci` tinyint(1) NOT NULL DEFAULT 0,
  `favorit` tinyint(1) NOT NULL DEFAULT 0,
  `jenis` tinyint(2) NOT NULL DEFAULT 2
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `tweb_surat_format`
--

INSERT INTO `tweb_surat_format` (`id`, `nama`, `url_surat`, `kode_surat`, `lampiran`, `kunci`, `favorit`, `jenis`) VALUES
(1, 'Keterangan Pengantar', 'surat_ket_pengantar', 'S-01', NULL, 0, 1, 1),
(2, 'Keterangan Penduduk', 'surat_ket_penduduk', 'S-02', NULL, 0, 0, 1),
(3, 'Biodata Penduduk', 'surat_bio_penduduk', 'S-03', 'f-1.01.php', 0, 0, 1),
(5, 'Keterangan Pindah Penduduk', 'surat_ket_pindah_penduduk', 'S-04', 'f-1.08.php,f-1.25.php', 0, 0, 1),
(6, 'Keterangan Jual Beli', 'surat_ket_jual_beli', 'S-05', NULL, 0, 0, 1),
(8, 'Pengantar SKCK', 'surat_ket_catatan_kriminal', 'S-07', NULL, 0, 0, 1),
(9, 'Keterangan KTP dalam Proses', 'surat_ket_ktp_dalam_proses', 'S-08', NULL, 0, 0, 1),
(10, 'Keterangan Beda Identitas', 'surat_ket_beda_nama', 'S-09', NULL, 0, 0, 1),
(11, 'Keterangan Bepergian / Jalan', 'surat_jalan', 'S-10', NULL, 0, 0, 1),
(12, 'Keterangan Kurang Mampu', 'surat_ket_kurang_mampu', 'S-11', NULL, 1, 0, 1),
(13, 'Pengantar Izin Keramaian', 'surat_izin_keramaian', 'S-12', NULL, 0, 0, 1),
(14, 'Pengantar Laporan Kehilangan', 'surat_ket_kehilangan', 'S-13', NULL, 0, 0, 1),
(15, 'Keterangan Usaha', 'surat_ket_usaha', 'S-14', NULL, 1, 0, 1),
(16, 'Keterangan JAMKESOS', 'surat_ket_jamkesos', 'S-15', NULL, 0, 0, 1),
(17, 'Keterangan Domisili Usaha', 'surat_ket_domisili_usaha', 'S-16', NULL, 0, 0, 1),
(18, 'Keterangan Kelahiran', 'surat_ket_kelahiran', 'S-17', 'f-2.01.php', 0, 0, 1),
(20, 'Permohonan Akta Lahir', 'surat_permohonan_akta', 'S-18', NULL, 0, 0, 1),
(21, 'Pernyataan Belum Memiliki Akta Lahir', 'surat_pernyataan_akta', 'S-19', NULL, 0, 0, 1),
(22, 'Permohonan Duplikat Kelahiran', 'surat_permohonan_duplikat_kelahiran', 'S-20', NULL, 0, 0, 1),
(24, 'Keterangan Kematian', 'surat_ket_kematian', 'S-21', 'f-2.29.php', 0, 0, 1),
(25, 'Keterangan Lahir Mati', 'surat_ket_lahir_mati', 'S-22', NULL, 0, 0, 1),
(26, 'Keterangan Untuk Nikah (N-1 s/d N-7)', 'surat_ket_nikah', 'S-23', NULL, 0, 0, 1),
(33, 'Keterangan Pergi Kawin', 'surat_ket_pergi_kawin', 'S-30', NULL, 0, 0, 1),
(35, 'Keterangan Wali Hakim', 'surat_ket_wali_hakim', 'S-32', NULL, 0, 0, 1),
(36, 'Permohonan Duplikat Surat Nikah', 'surat_permohonan_duplikat_surat_nikah', 'S-33', NULL, 0, 0, 1),
(37, 'Permohonan Cerai', 'surat_permohonan_cerai', 'S-34', NULL, 0, 0, 1),
(38, 'Keterangan Pengantar Rujuk/Cerai', 'surat_ket_rujuk_cerai', 'S-35', NULL, 0, 0, 1),
(45, 'Permohonan Kartu Keluarga', 'surat_permohonan_kartu_keluarga', 'S-36', 'f-1.15.php,f-1.01.php', 0, 0, 1),
(51, 'Domisili Usaha Non-Warga', 'surat_domisili_usaha_non_warga', 'S-37', NULL, 0, 0, 1),
(76, 'Keterangan Beda Identitas KIS', 'surat_ket_beda_identitas_kis', 'S-38', NULL, 0, 0, 1),
(85, 'Keterangan Izin Orang Tua/Suami/Istri', 'surat_izin_orangtua_suami_istri', 'S-39', NULL, 0, 0, 1),
(86, 'Pernyataan Penguasaan Fisik Bidang Tanah (SPORADIK)', 'surat_sporadik', 'S-40', NULL, 0, 0, 1),
(89, 'Permohonan Perubahan Kartu Keluarga', 'surat_permohonan_perubahan_kartu_keluarga', 'S-41', 'f-1.16.php,f-1.01.php', 0, 0, 1),
(90, 'Izin Mengambil Kayu', 'surat_izin_mengambil_kayu', '', NULL, 0, 0, 2),
(91, 'Keterangan Tidak Mampu', 'surat_keterangan_tidak_mampu', 'S-42', NULL, 0, 0, 2),
(92, 'Keterangan Pembelian Solar', 'surat_keterangan_pembelian_solar', 'S-43', NULL, 0, 0, 2),
(93, 'Keterangan Usaha', 'surat_keterangan_usaha', 'S-44', NULL, 0, 0, 2),
(94, 'Permohonan KTP', 'surat_permohonan_ktp', 'S-45', 'f-1.21.php', 0, 0, 1),
(95, 'Keterangan Domisili', 'surat_ket_domisili', 'S-41', NULL, 0, 0, 1),
(96, 'Non Warga', 'surat_non_warga', '', NULL, 0, 0, 2),
(97, 'Kk', 'kk', '', NULL, 0, 0, 2),
(98, 'Raw', 'raw', '', NULL, 0, 0, 2),
(99, 'Ket Penghasilan Ayah', 'surat_ket_penghasilan_ayah', '', NULL, 0, 0, 2),
(100, 'Ket Penghasilan Ibu', 'surat_ket_penghasilan_ibu', '', NULL, 0, 0, 2),
(101, 'Ket Penghasilan Orangtua', 'surat_ket_penghasilan_orangtua', '', NULL, 0, 0, 2),
(102, 'Keterangan Penghasilan', 'surat_keterangan_penghasilan', '', NULL, 0, 0, 2),
(103, 'Keterangan Wali Nasab', 'surat_keterangan_wali_nasab', '', NULL, 0, 0, 2),
(104, 'Kuasa', 'surat_kuasa', '', NULL, 0, 0, 2),
(105, 'Pelaporan Kelahiran', 'surat_pelaporan_kelahiran', '', NULL, 0, 0, 2),
(106, 'Perintah Perjalanan Dinas', 'surat_perintah_perjalanan_dinas', '', NULL, 0, 0, 2),
(107, 'Permohonan Penerbitan Buku Pas Lintas', 'surat_permohonan_penerbitan_buku_pas_lintas', '', NULL, 0, 0, 2),
(108, 'Pernyataan Belum Pernah Buat Akta', 'surat_pernyataan_belum_pernah_buat_akta', '', NULL, 0, 0, 2),
(109, 'Pernyataan Belum Pernah Membuat Akta', 'surat_pernyataan_belum_pernah_membuat_akta', '', NULL, 0, 0, 2);

-- --------------------------------------------------------

--
-- Table structure for table `tweb_wil_clusterdesa`
--

CREATE TABLE `tweb_wil_clusterdesa` (
  `id` int(11) NOT NULL,
  `rt` varchar(10) NOT NULL DEFAULT '0',
  `rw` varchar(10) NOT NULL DEFAULT '0',
  `dusun` varchar(50) NOT NULL DEFAULT '0',
  `id_kepala` int(11) NOT NULL,
  `lat` varchar(20) NOT NULL,
  `lng` varchar(20) NOT NULL,
  `zoom` int(5) NOT NULL,
  `path` text NOT NULL,
  `map_tipe` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tweb_wil_clusterdesa`
--

INSERT INTO `tweb_wil_clusterdesa` (`id`, `rt`, `rw`, `dusun`, `id_kepala`, `lat`, `lng`, `zoom`, `path`, `map_tipe`) VALUES
(1, '0', '0', 'MANGSIT', 0, '', '', 0, '', ''),
(2, '0', '-', 'MANGSIT', 0, '', '', 0, '', ''),
(3, '-', '-', 'MANGSIT', 0, '', '', 0, '', ''),
(4, '004', '-', 'MANGSIT', 0, '', '', 0, '', ''),
(5, '0', '0', 'SENGGIGI', 0, '', '', 0, '', ''),
(6, '0', '-', 'SENGGIGI', 0, '', '', 0, '', ''),
(7, '-', '-', 'SENGGIGI', 0, '', '', 0, '', ''),
(8, '001', '-', 'SENGGIGI', 0, '', '', 0, '', ''),
(9, '0', '0', 'Melayu Bangsal', 1, '', '', 0, '', ''),
(10, '0', '-', 'Melayu Bangsal', 0, '', '', 0, '', ''),
(11, '-', '-', 'Melayu Bangsal', 0, '', '', 0, '', ''),
(12, '002', '-', 'Melayu Bangsal', 0, '', '', 0, '', ''),
(13, '0', '0', 'Melayu Tengah', 2, '', '', 0, '', ''),
(14, '0', '-', 'Melayu Tengah', 0, '', '', 0, '', ''),
(15, '-', '-', 'Melayu Tengah', 0, '', '', 0, '', ''),
(16, '003', '-', 'Melayu Tengah', 0, '', '', 0, '', ''),
(17, '001', '-', 'Melayu Bangsal', 0, '', '', 0, '', ''),
(18, '005', '-', 'SENGGIGI', 0, '', '', 0, '', ''),
(19, '005', '-', 'MANGSIT', 0, '', '', 0, '', ''),
(20, '005', '-', 'Melayu Tengah', 0, '', '', 0, '', ''),
(21, '003', '-', 'SENGGIGI', 0, '', '', 0, '', ''),
(22, '002', '-', 'Melayu Tengah', 0, '', '', 0, '', ''),
(23, '004', '-', 'SENGGIGI', 0, '', '', 0, '', ''),
(24, '004', '-', 'Melayu Tengah', 0, '', '', 0, '', ''),
(25, '001', '-', 'Melayu Tengah', 0, '', '', 0, '', ''),
(26, '002', '-', 'MANGSIT', 0, '', '', 0, '', ''),
(27, '004', '-', 'Melayu Bangsal', 0, '', '', 0, '', ''),
(28, '003', '-', 'MANGSIT', 0, '', '', 0, '', ''),
(29, '006', '-', 'SENGGIGI', 0, '', '', 0, '', ''),
(30, '006', '-', 'Melayu Bangsal', 0, '', '', 0, '', ''),
(31, '002', '-', 'SENGGIGI', 0, '', '', 0, '', ''),
(32, '0', '001', 'Melayu Bangsal', 0, '', '', 0, '', ''),
(33, '-', '001', 'Melayu Bangsal', 0, '', '', 0, '', ''),
(34, '001', '001', 'Melayu Bangsal', 4, '', '', 0, '', ''),
(35, '0', '0', 'Melayu Timur', 0, '', '', 0, '', ''),
(36, '0', '-', 'Melayu Timur', 0, '', '', 0, '', ''),
(37, '-', '-', 'Melayu Timur', 0, '', '', 0, '', ''),
(38, '0', '001', 'Melayu Timur', 0, '', '', 0, '', ''),
(39, '-', '001', 'Melayu Timur', 0, '', '', 0, '', ''),
(40, '005', '001', 'Melayu Timur', 0, '', '', 0, '', ''),
(41, '0', '0', 'KRAJAN', 0, '', '', 0, '', ''),
(42, '0', '-', 'KRAJAN', 0, '', '', 0, '', ''),
(43, '-', '-', 'KRAJAN', 0, '', '', 0, '', ''),
(44, '004', '-', 'KRAJAN', 0, '', '', 0, '', '');

-- --------------------------------------------------------

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` mediumint(8) UNSIGNED NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `id_grup` int(5) NOT NULL,
  `email` varchar(100) NOT NULL,
  `last_login` datetime NOT NULL,
  `active` tinyint(1) UNSIGNED DEFAULT 0,
  `nama` varchar(50) DEFAULT NULL,
  `company` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `foto` varchar(100) NOT NULL,
  `session` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `username`, `password`, `id_grup`, `email`, `last_login`, `active`, `nama`, `company`, `phone`, `foto`, `session`) VALUES
(1, 'admin', '$2y$10$15QBwjc.mQ/JYWK0mBsQAeLmZgSBa/TzaAXHOHxzHNsjF.Jd4e56C', 1, 'admin@combine.or.id', '2020-11-26 03:22:44', 1, 'Admin', 'ADMIN', '321', 'kuser__sid__BIYV85D.png', '86ac1db4d625bab6b8722a802805162d'),
(2, 'admin1', '$2y$10$NIJ6/q9Zv7mz3Yy2I./AZu5qpLckEm6Gw1eWmzqLJz/ost01bofOG', 1, 'admin@combine.or.id', '2020-10-07 20:02:03', 1, 'Happy Agung', 'Portal Desa Digital', '321', 'aparatur__sid__9RHvudD.png', 'a8d4080245664ed2049c1b2ded7cac30'),
(3, 'testing', '$2y$10$3rM8lUQTTr92hCi8KHf/q.vkhLg9KiQZAxEKQ6g9Xp4imnWzWXc.K', 2, 'metalabmetadata@gmail.com', '2020-08-18 23:53:38', 1, 'Testing Operator', NULL, '085239168707', 'kuser.png', '5dd42d7ff64fb6fbf8c14dd9d7266d63');

-- --------------------------------------------------------

--
-- Table structure for table `user_grup`
--

CREATE TABLE `user_grup` (
  `id` tinyint(4) NOT NULL,
  `nama` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_grup`
--

INSERT INTO `user_grup` (`id`, `nama`) VALUES
(1, 'Administrator'),
(2, 'Operator'),
(3, 'Redaksi'),
(4, 'Kontributor'),
(22, 'PKK'),
(33, 'BPD'),
(44, 'LPMD');

-- --------------------------------------------------------

--
-- Table structure for table `widget`
--

CREATE TABLE `widget` (
  `id` int(11) NOT NULL,
  `isi` text DEFAULT NULL,
  `enabled` int(2) DEFAULT NULL,
  `judul` varchar(100) DEFAULT NULL,
  `jenis_widget` tinyint(2) NOT NULL DEFAULT 3,
  `urut` int(5) DEFAULT NULL,
  `form_admin` varchar(100) NOT NULL,
  `setting` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `widget`
--

INSERT INTO `widget` (`id`, `isi`, `enabled`, `judul`, `jenis_widget`, `urut`, `form_admin`, `setting`) VALUES
(2, 'layanan_mandiri.php', 2, 'Layanan Mandiri', 1, 5, 'mandiri', ''),
(3, 'agenda.php', 1, 'Agenda', 1, 7, 'web/index/1000', ''),
(4, 'galeri.php', 1, 'Galeri', 1, 8, 'gallery', ''),
(5, 'statistik.php', 1, 'Statistik', 1, 9, '', ''),
(6, 'komentar.php', 1, 'Komentar', 1, 10, 'komentar', ''),
(7, 'media_sosial.php', 2, 'Media Sosial', 1, 11, 'sosmed', ''),
(8, 'peta_lokasi_kantor.php', 2, 'Peta Lokasi Kantor', 1, 12, 'hom_desa', ''),
(9, 'statistik_pengunjung.php', 1, 'Statistik Pengunjung', 1, 14, '', ''),
(10, 'arsip_artikel.php', 1, 'Arsip Artikel', 1, 13, '', ''),
(11, 'aparatur_desa.php', 1, 'Aparatur Desa', 1, 4, 'pengurus', ''),
(12, 'sinergi_program.php', 1, 'Sinergi Program', 1, 6, 'web_widget/admin/sinergi_program', '[{\"baris\":\"1\",\"kolom\":\"1\",\"judul\":\"\",\"tautan\":\"\",\"gambar\":\"1593537087_WhatsApp-Image-2020-06-29-at-13.22.06.jpeg\"},{\"baris\":\"2\",\"kolom\":\"1\",\"judul\":\"\",\"tautan\":\"\",\"gambar\":\"1593537087_WhatsApp-Image-2020-06-29-at-13.22.00.jpeg\"},{\"baris\":\"3\",\"kolom\":\"1\",\"judul\":\"\",\"tautan\":\"\",\"gambar\":\"1593537087_WhatsApp-Image-2020-06-29-at-13.21.55.jpeg\"},{\"baris\":\"4\",\"kolom\":\"1\",\"judul\":\"\",\"tautan\":\"\",\"gambar\":\"1593537087_WhatsApp-Image-2020-06-29-at-13.21.49.jpeg\"},{\"baris\":\"5\",\"kolom\":\"1\",\"judul\":\"\",\"tautan\":\"\",\"gambar\":\"1593537087_WhatsApp-Image-2020-06-29-at-13.21.44.jpeg\"},{\"baris\":\"6\",\"kolom\":\"1\",\"judul\":\"\",\"tautan\":\"\",\"gambar\":\"1593537087_WhatsApp-Image-2020-06-29-at-13.21.40.jpeg\"}]'),
(13, 'menu_kategori.php', 1, 'Menu Kategori', 1, 3, '', ''),
(14, 'peta_wilayah_desa.php', 1, 'Peta Wilayah Desa', 1, 1, 'hom_desa/konfigurasi', ''),
(15, 'polling.php', 1, 'Jajak Pendapat', 2, 3, '', ''),
(20, 'popular_artikel.php', 1, 'Populer Artikel', 1, 5, '', ''),
(21, 'download.php', 1, 'Dokumen Publik', 1, 5, '', ''),
(22, 'idm.php', 1, 'Indeks Desa Membangun', 1, 1, '', '');

-- --------------------------------------------------------

--
-- Structure for view `daftar_anggota_grup`
--

CREATE ALGORITHM=UNDEFINED  SQL SECURITY DEFINER VIEW `daftar_anggota_grup`  AS  select `a`.`id_grup_kontak` AS `id_grup_kontak`,`a`.`id_grup` AS `id_grup`,`c`.`nama_grup` AS `nama_grup`,`b`.`id_kontak` AS `id_kontak`,`b`.`nama` AS `nama`,`b`.`no_hp` AS `no_hp`,`b`.`sex` AS `sex`,`b`.`alamat_sekarang` AS `alamat_sekarang` from ((`anggota_grup_kontak` `a` left join `daftar_kontak` `b` on(`a`.`id_kontak` = `b`.`id_kontak`)) left join `kontak_grup` `c` on(`a`.`id_grup` = `c`.`id_grup`)) ;

-- --------------------------------------------------------

--
-- Structure for view `daftar_grup`
--

CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `daftar_grup`  AS  select `a`.`id_grup` AS `id_grup`,`a`.`nama_grup` AS `nama_grup`,(select count(`anggota_grup_kontak`.`id_kontak`) from `anggota_grup_kontak` where `a`.`id_grup` = `anggota_grup_kontak`.`id_grup`) AS `jumlah_anggota` from `kontak_grup` `a` ;

-- --------------------------------------------------------

--
-- Structure for view `daftar_kontak`
--

CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `daftar_kontak`  AS  select `a`.`id_kontak` AS `id_kontak`,`a`.`id_pend` AS `id_pend`,`b`.`nama` AS `nama`,`a`.`no_hp` AS `no_hp`,case when `b`.`sex` = '1' then 'Laki-laki' else 'Perempuan' end AS `sex`,`b`.`alamat_sekarang` AS `alamat_sekarang` from (`kontak` `a` left join `tweb_penduduk` `b` on(`a`.`id_pend` = `b`.`id`)) ;

-- --------------------------------------------------------

--
-- Structure for view `penduduk_hidup`
--

CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `penduduk_hidup`  AS  select `tweb_penduduk`.`id` AS `id`,`tweb_penduduk`.`nama` AS `nama`,`tweb_penduduk`.`nik` AS `nik`,`tweb_penduduk`.`id_kk` AS `id_kk`,`tweb_penduduk`.`kk_level` AS `kk_level`,`tweb_penduduk`.`id_rtm` AS `id_rtm`,`tweb_penduduk`.`rtm_level` AS `rtm_level`,`tweb_penduduk`.`sex` AS `sex`,`tweb_penduduk`.`tempatlahir` AS `tempatlahir`,`tweb_penduduk`.`tanggallahir` AS `tanggallahir`,`tweb_penduduk`.`agama_id` AS `agama_id`,`tweb_penduduk`.`pendidikan_kk_id` AS `pendidikan_kk_id`,`tweb_penduduk`.`pendidikan_sedang_id` AS `pendidikan_sedang_id`,`tweb_penduduk`.`pekerjaan_id` AS `pekerjaan_id`,`tweb_penduduk`.`status_kawin` AS `status_kawin`,`tweb_penduduk`.`warganegara_id` AS `warganegara_id`,`tweb_penduduk`.`dokumen_pasport` AS `dokumen_pasport`,`tweb_penduduk`.`dokumen_kitas` AS `dokumen_kitas`,`tweb_penduduk`.`ayah_nik` AS `ayah_nik`,`tweb_penduduk`.`ibu_nik` AS `ibu_nik`,`tweb_penduduk`.`nama_ayah` AS `nama_ayah`,`tweb_penduduk`.`nama_ibu` AS `nama_ibu`,`tweb_penduduk`.`foto` AS `foto`,`tweb_penduduk`.`golongan_darah_id` AS `golongan_darah_id`,`tweb_penduduk`.`id_cluster` AS `id_cluster`,`tweb_penduduk`.`status` AS `status`,`tweb_penduduk`.`alamat_sebelumnya` AS `alamat_sebelumnya`,`tweb_penduduk`.`alamat_sekarang` AS `alamat_sekarang`,`tweb_penduduk`.`status_dasar` AS `status_dasar`,`tweb_penduduk`.`hamil` AS `hamil`,`tweb_penduduk`.`cacat_id` AS `cacat_id`,`tweb_penduduk`.`sakit_menahun_id` AS `sakit_menahun_id`,`tweb_penduduk`.`akta_lahir` AS `akta_lahir`,`tweb_penduduk`.`akta_perkawinan` AS `akta_perkawinan`,`tweb_penduduk`.`tanggalperkawinan` AS `tanggalperkawinan`,`tweb_penduduk`.`akta_perceraian` AS `akta_perceraian`,`tweb_penduduk`.`tanggalperceraian` AS `tanggalperceraian`,`tweb_penduduk`.`cara_kb_id` AS `cara_kb_id`,`tweb_penduduk`.`telepon` AS `telepon`,`tweb_penduduk`.`tanggal_akhir_paspor` AS `tanggal_akhir_paspor`,`tweb_penduduk`.`no_kk_sebelumnya` AS `no_kk_sebelumnya`,`tweb_penduduk`.`ktp_el` AS `ktp_el`,`tweb_penduduk`.`status_rekam` AS `status_rekam`,`tweb_penduduk`.`waktu_lahir` AS `waktu_lahir`,`tweb_penduduk`.`tempat_dilahirkan` AS `tempat_dilahirkan`,`tweb_penduduk`.`jenis_kelahiran` AS `jenis_kelahiran`,`tweb_penduduk`.`kelahiran_anak_ke` AS `kelahiran_anak_ke`,`tweb_penduduk`.`penolong_kelahiran` AS `penolong_kelahiran`,`tweb_penduduk`.`berat_lahir` AS `berat_lahir`,`tweb_penduduk`.`panjang_lahir` AS `panjang_lahir` from `tweb_penduduk` where `tweb_penduduk`.`status_dasar` = 1 ;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `agenda`
--
ALTER TABLE `agenda`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_artikel` (`id_artikel`);

--
-- Indexes for table `analisis_indikator`
--
ALTER TABLE `analisis_indikator`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_master` (`id_master`,`id_tipe`),
  ADD KEY `id_tipe` (`id_tipe`),
  ADD KEY `id_kategori` (`id_kategori`);

--
-- Indexes for table `analisis_kategori_indikator`
--
ALTER TABLE `analisis_kategori_indikator`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_master` (`id_master`);

--
-- Indexes for table `analisis_klasifikasi`
--
ALTER TABLE `analisis_klasifikasi`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_master` (`id_master`);

--
-- Indexes for table `analisis_master`
--
ALTER TABLE `analisis_master`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `analisis_parameter`
--
ALTER TABLE `analisis_parameter`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_indikator` (`id_indikator`);

--
-- Indexes for table `analisis_partisipasi`
--
ALTER TABLE `analisis_partisipasi`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_subjek` (`id_subjek`,`id_master`,`id_periode`,`id_klassifikasi`),
  ADD KEY `id_master` (`id_master`),
  ADD KEY `id_periode` (`id_periode`),
  ADD KEY `id_klassifikasi` (`id_klassifikasi`);

--
-- Indexes for table `analisis_periode`
--
ALTER TABLE `analisis_periode`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_master` (`id_master`),
  ADD KEY `id_state` (`id_state`);

--
-- Indexes for table `analisis_ref_state`
--
ALTER TABLE `analisis_ref_state`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `analisis_ref_subjek`
--
ALTER TABLE `analisis_ref_subjek`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `analisis_respon`
--
ALTER TABLE `analisis_respon`
  ADD KEY `id_parameter` (`id_parameter`,`id_subjek`),
  ADD KEY `id_periode` (`id_periode`),
  ADD KEY `id_indikator` (`id_indikator`);

--
-- Indexes for table `analisis_respon_hasil`
--
ALTER TABLE `analisis_respon_hasil`
  ADD UNIQUE KEY `id_master` (`id_master`,`id_periode`,`id_subjek`);

--
-- Indexes for table `analisis_tipe_indikator`
--
ALTER TABLE `analisis_tipe_indikator`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `anggota_grup_kontak`
--
ALTER TABLE `anggota_grup_kontak`
  ADD PRIMARY KEY (`id_grup_kontak`),
  ADD KEY `anggota_grup_kontak_ke_kontak` (`id_kontak`),
  ADD KEY `anggota_grup_kontak_ke_kontak_grup` (`id_grup`);

--
-- Indexes for table `apbdes`
--
ALTER TABLE `apbdes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_kategori` (`id_kategori`),
  ADD KEY `id_artikel` (`id_artikel`);

--
-- Indexes for table `apbdes_kategori`
--
ALTER TABLE `apbdes_kategori`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `area`
--
ALTER TABLE `area`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `artikel`
--
ALTER TABLE `artikel`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `captcha_codes`
--
ALTER TABLE `captcha_codes`
  ADD PRIMARY KEY (`id`,`namespace`),
  ADD KEY `created` (`created`);

--
-- Indexes for table `config`
--
ALTER TABLE `config`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `data_persil`
--
ALTER TABLE `data_persil`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_pend` (`id_pend`);

--
-- Indexes for table `data_persil_jenis`
--
ALTER TABLE `data_persil_jenis`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `data_persil_peruntukan`
--
ALTER TABLE `data_persil_peruntukan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `disposisi_surat_masuk`
--
ALTER TABLE `disposisi_surat_masuk`
  ADD PRIMARY KEY (`id_disposisi`),
  ADD KEY `id_surat_fk` (`id_surat_masuk`),
  ADD KEY `desa_pamong_fk` (`id_desa_pamong`);

--
-- Indexes for table `dokumen`
--
ALTER TABLE `dokumen`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `gambar_gallery`
--
ALTER TABLE `gambar_gallery`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parrent` (`parrent`);

--
-- Indexes for table `garis`
--
ALTER TABLE `garis`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `idm`
--
ALTER TABLE `idm`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `inbox`
--
ALTER TABLE `inbox`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `inventaris_asset`
--
ALTER TABLE `inventaris_asset`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `inventaris_elektronik`
--
ALTER TABLE `inventaris_elektronik`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `inventaris_gedung`
--
ALTER TABLE `inventaris_gedung`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `inventaris_jalan`
--
ALTER TABLE `inventaris_jalan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `inventaris_kontruksi`
--
ALTER TABLE `inventaris_kontruksi`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `inventaris_mesin`
--
ALTER TABLE `inventaris_mesin`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `inventaris_tanah`
--
ALTER TABLE `inventaris_tanah`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `kategori`
--
ALTER TABLE `kategori`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `kelompok`
--
ALTER TABLE `kelompok`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_ketua` (`id_ketua`),
  ADD KEY `id_master` (`id_master`);

--
-- Indexes for table `kelompok_anggota`
--
ALTER TABLE `kelompok_anggota`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_kelompok` (`id_kelompok`,`id_penduduk`);

--
-- Indexes for table `kelompok_master`
--
ALTER TABLE `kelompok_master`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `klasifikasi_analisis_keluarga`
--
ALTER TABLE `klasifikasi_analisis_keluarga`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `klasifikasi_surat`
--
ALTER TABLE `klasifikasi_surat`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `komentar`
--
ALTER TABLE `komentar`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `komentar_reply`
--
ALTER TABLE `komentar_reply`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `kontak`
--
ALTER TABLE `kontak`
  ADD PRIMARY KEY (`id_kontak`),
  ADD KEY `kontak_ke_tweb_penduduk` (`id_pend`);

--
-- Indexes for table `kontak_grup`
--
ALTER TABLE `kontak_grup`
  ADD PRIMARY KEY (`id_grup`);

--
-- Indexes for table `lapak_barang`
--
ALTER TABLE `lapak_barang`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lapak_gallery`
--
ALTER TABLE `lapak_gallery`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lapak_toko`
--
ALTER TABLE `lapak_toko`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `line`
--
ALTER TABLE `line`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parrent` (`parrent`);

--
-- Indexes for table `log_bulanan`
--
ALTER TABLE `log_bulanan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `log_keluarga`
--
ALTER TABLE `log_keluarga`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_kk` (`id_kk`,`id_peristiwa`,`tgl_peristiwa`);

--
-- Indexes for table `log_penduduk`
--
ALTER TABLE `log_penduduk`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id_pend` (`id_pend`,`id_detail`,`tgl_peristiwa`),
  ADD KEY `id_ref_pindah` (`ref_pindah`);

--
-- Indexes for table `log_perubahan_penduduk`
--
ALTER TABLE `log_perubahan_penduduk`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `log_surat`
--
ALTER TABLE `log_surat`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lokasi`
--
ALTER TABLE `lokasi`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ref_point` (`ref_point`);

--
-- Indexes for table `media_sosial`
--
ALTER TABLE `media_sosial`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `menu`
--
ALTER TABLE `menu`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mutasi_inventaris_asset`
--
ALTER TABLE `mutasi_inventaris_asset`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_mutasi_inventaris_asset` (`id_inventaris_asset`);

--
-- Indexes for table `mutasi_inventaris_elektronik`
--
ALTER TABLE `mutasi_inventaris_elektronik`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_inventaris_elektronik` (`id_inventaris_elektronik`);

--
-- Indexes for table `mutasi_inventaris_gedung`
--
ALTER TABLE `mutasi_inventaris_gedung`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_mutasi_inventaris_gedung` (`id_inventaris_gedung`);

--
-- Indexes for table `mutasi_inventaris_jalan`
--
ALTER TABLE `mutasi_inventaris_jalan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_mutasi_inventaris_jalan` (`id_inventaris_jalan`);

--
-- Indexes for table `mutasi_inventaris_mesin`
--
ALTER TABLE `mutasi_inventaris_mesin`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_mutasi_inventaris_peralatan` (`id_inventaris_peralatan`);

--
-- Indexes for table `mutasi_inventaris_tanah`
--
ALTER TABLE `mutasi_inventaris_tanah`
  ADD PRIMARY KEY (`id`),
  ADD KEY `FK_mutasi_inventaris_tanah` (`id_inventaris_tanah`);

--
-- Indexes for table `outbox`
--
ALTER TABLE `outbox`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `outbox_date` (`SendingDateTime`,`SendingTimeOut`),
  ADD KEY `outbox_sender` (`SenderID`);

--
-- Indexes for table `pembangunan`
--
ALTER TABLE `pembangunan`
  ADD PRIMARY KEY (`id_pembangunan`),
  ADD KEY `id_artikel` (`id_artikel`);

--
-- Indexes for table `point`
--
ALTER TABLE `point`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parrent` (`parrent`);

--
-- Indexes for table `polling`
--
ALTER TABLE `polling`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `poll_pilihan`
--
ALTER TABLE `poll_pilihan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_poll` (`id_poll`);

--
-- Indexes for table `poll_vote`
--
ALTER TABLE `poll_vote`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_poll` (`id_poll`),
  ADD KEY `id_pil` (`id_pil`);

--
-- Indexes for table `polygon`
--
ALTER TABLE `polygon`
  ADD PRIMARY KEY (`id`),
  ADD KEY `parrent` (`parrent`);

--
-- Indexes for table `potensi`
--
ALTER TABLE `potensi`
  ADD PRIMARY KEY (`id_potensi`),
  ADD KEY `id_artikel` (`id_artikel`);

--
-- Indexes for table `program`
--
ALTER TABLE `program`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `program_peserta`
--
ALTER TABLE `program_peserta`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `provinsi`
--
ALTER TABLE `provinsi`
  ADD PRIMARY KEY (`kode`);

--
-- Indexes for table `ref_pindah`
--
ALTER TABLE `ref_pindah`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sambutan`
--
ALTER TABLE `sambutan`
  ADD PRIMARY KEY (`id_sambutan`),
  ADD KEY `id_artikel` (`id_artikel`);

--
-- Indexes for table `sentitems`
--
ALTER TABLE `sentitems`
  ADD PRIMARY KEY (`ID`,`SequencePosition`),
  ADD KEY `sentitems_date` (`DeliveryDateTime`),
  ADD KEY `sentitems_tpmr` (`TPMR`),
  ADD KEY `sentitems_dest` (`DestinationNumber`),
  ADD KEY `sentitems_sender` (`SenderID`);

--
-- Indexes for table `setting_aplikasi`
--
ALTER TABLE `setting_aplikasi`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `setting_aplikasi_options`
--
ALTER TABLE `setting_aplikasi_options`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_setting_fk` (`id_setting`);

--
-- Indexes for table `setting_modul`
--
ALTER TABLE `setting_modul`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `suplemen`
--
ALTER TABLE `suplemen`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `suplemen_terdata`
--
ALTER TABLE `suplemen_terdata`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_suplemen` (`id_suplemen`);

--
-- Indexes for table `surat_keluar`
--
ALTER TABLE `surat_keluar`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `surat_masuk`
--
ALTER TABLE `surat_masuk`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sys_traffic`
--
ALTER TABLE `sys_traffic`
  ADD PRIMARY KEY (`Tanggal`);

--
-- Indexes for table `tweb_aset`
--
ALTER TABLE `tweb_aset`
  ADD PRIMARY KEY (`id_aset`);

--
-- Indexes for table `tweb_cacat`
--
ALTER TABLE `tweb_cacat`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_cara_kb`
--
ALTER TABLE `tweb_cara_kb`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_desa_pamong`
--
ALTER TABLE `tweb_desa_pamong`
  ADD PRIMARY KEY (`pamong_id`);

--
-- Indexes for table `tweb_golongan_darah`
--
ALTER TABLE `tweb_golongan_darah`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_keluarga`
--
ALTER TABLE `tweb_keluarga`
  ADD PRIMARY KEY (`id`),
  ADD KEY `nik_kepala` (`nik_kepala`);

--
-- Indexes for table `tweb_keluarga_sejahtera`
--
ALTER TABLE `tweb_keluarga_sejahtera`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_penduduk`
--
ALTER TABLE `tweb_penduduk`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_penduduk_agama`
--
ALTER TABLE `tweb_penduduk_agama`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_penduduk_hubungan`
--
ALTER TABLE `tweb_penduduk_hubungan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_penduduk_kawin`
--
ALTER TABLE `tweb_penduduk_kawin`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_penduduk_mandiri`
--
ALTER TABLE `tweb_penduduk_mandiri`
  ADD PRIMARY KEY (`id_pend`);

--
-- Indexes for table `tweb_penduduk_pekerjaan`
--
ALTER TABLE `tweb_penduduk_pekerjaan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_penduduk_pendidikan`
--
ALTER TABLE `tweb_penduduk_pendidikan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_penduduk_pendidikan_kk`
--
ALTER TABLE `tweb_penduduk_pendidikan_kk`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_penduduk_sex`
--
ALTER TABLE `tweb_penduduk_sex`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_penduduk_status`
--
ALTER TABLE `tweb_penduduk_status`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_penduduk_umur`
--
ALTER TABLE `tweb_penduduk_umur`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_penduduk_warganegara`
--
ALTER TABLE `tweb_penduduk_warganegara`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_rtm`
--
ALTER TABLE `tweb_rtm`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_rtm_hubungan`
--
ALTER TABLE `tweb_rtm_hubungan`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_sakit_menahun`
--
ALTER TABLE `tweb_sakit_menahun`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_status_dasar`
--
ALTER TABLE `tweb_status_dasar`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_status_ktp`
--
ALTER TABLE `tweb_status_ktp`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_surat_atribut`
--
ALTER TABLE `tweb_surat_atribut`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tweb_surat_format`
--
ALTER TABLE `tweb_surat_format`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `url_surat` (`url_surat`);

--
-- Indexes for table `tweb_wil_clusterdesa`
--
ALTER TABLE `tweb_wil_clusterdesa`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `rt` (`rt`,`rw`,`dusun`),
  ADD KEY `id_kepala` (`id_kepala`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user_grup`
--
ALTER TABLE `user_grup`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `widget`
--
ALTER TABLE `widget`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `agenda`
--
ALTER TABLE `agenda`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `analisis_indikator`
--
ALTER TABLE `analisis_indikator`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=245;

--
-- AUTO_INCREMENT for table `analisis_kategori_indikator`
--
ALTER TABLE `analisis_kategori_indikator`
  MODIFY `id` tinyint(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `analisis_klasifikasi`
--
ALTER TABLE `analisis_klasifikasi`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `analisis_master`
--
ALTER TABLE `analisis_master`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `analisis_parameter`
--
ALTER TABLE `analisis_parameter`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2150;

--
-- AUTO_INCREMENT for table `analisis_partisipasi`
--
ALTER TABLE `analisis_partisipasi`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `analisis_periode`
--
ALTER TABLE `analisis_periode`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `analisis_ref_state`
--
ALTER TABLE `analisis_ref_state`
  MODIFY `id` tinyint(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `analisis_ref_subjek`
--
ALTER TABLE `analisis_ref_subjek`
  MODIFY `id` tinyint(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `analisis_tipe_indikator`
--
ALTER TABLE `analisis_tipe_indikator`
  MODIFY `id` tinyint(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `anggota_grup_kontak`
--
ALTER TABLE `anggota_grup_kontak`
  MODIFY `id_grup_kontak` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `apbdes`
--
ALTER TABLE `apbdes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `apbdes_kategori`
--
ALTER TABLE `apbdes_kategori`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `area`
--
ALTER TABLE `area`
  MODIFY `id` int(4) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `artikel`
--
ALTER TABLE `artikel`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=151;

--
-- AUTO_INCREMENT for table `config`
--
ALTER TABLE `config`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `data_persil`
--
ALTER TABLE `data_persil`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `data_persil_jenis`
--
ALTER TABLE `data_persil_jenis`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `data_persil_peruntukan`
--
ALTER TABLE `data_persil_peruntukan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `disposisi_surat_masuk`
--
ALTER TABLE `disposisi_surat_masuk`
  MODIFY `id_disposisi` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dokumen`
--
ALTER TABLE `dokumen`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `gambar_gallery`
--
ALTER TABLE `gambar_gallery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `garis`
--
ALTER TABLE `garis`
  MODIFY `id` int(4) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `idm`
--
ALTER TABLE `idm`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `inbox`
--
ALTER TABLE `inbox`
  MODIFY `ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `inventaris_asset`
--
ALTER TABLE `inventaris_asset`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `inventaris_elektronik`
--
ALTER TABLE `inventaris_elektronik`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `inventaris_gedung`
--
ALTER TABLE `inventaris_gedung`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `inventaris_jalan`
--
ALTER TABLE `inventaris_jalan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `inventaris_kontruksi`
--
ALTER TABLE `inventaris_kontruksi`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `inventaris_mesin`
--
ALTER TABLE `inventaris_mesin`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `inventaris_tanah`
--
ALTER TABLE `inventaris_tanah`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `kategori`
--
ALTER TABLE `kategori`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1008;

--
-- AUTO_INCREMENT for table `kelompok`
--
ALTER TABLE `kelompok`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `kelompok_anggota`
--
ALTER TABLE `kelompok_anggota`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `kelompok_master`
--
ALTER TABLE `kelompok_master`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `klasifikasi_analisis_keluarga`
--
ALTER TABLE `klasifikasi_analisis_keluarga`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `klasifikasi_surat`
--
ALTER TABLE `klasifikasi_surat`
  MODIFY `id` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2335;

--
-- AUTO_INCREMENT for table `komentar`
--
ALTER TABLE `komentar`
  MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `komentar_reply`
--
ALTER TABLE `komentar_reply`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `kontak`
--
ALTER TABLE `kontak`
  MODIFY `id_kontak` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `kontak_grup`
--
ALTER TABLE `kontak_grup`
  MODIFY `id_grup` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lapak_barang`
--
ALTER TABLE `lapak_barang`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `lapak_gallery`
--
ALTER TABLE `lapak_gallery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `lapak_toko`
--
ALTER TABLE `lapak_toko`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `line`
--
ALTER TABLE `line`
  MODIFY `id` int(4) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `log_bulanan`
--
ALTER TABLE `log_bulanan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `log_keluarga`
--
ALTER TABLE `log_keluarga`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `log_penduduk`
--
ALTER TABLE `log_penduduk`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `log_perubahan_penduduk`
--
ALTER TABLE `log_perubahan_penduduk`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `log_surat`
--
ALTER TABLE `log_surat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `lokasi`
--
ALTER TABLE `lokasi`
  MODIFY `id` int(4) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `media_sosial`
--
ALTER TABLE `media_sosial`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `menu`
--
ALTER TABLE `menu`
  MODIFY `id` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=144;

--
-- AUTO_INCREMENT for table `mutasi_inventaris_asset`
--
ALTER TABLE `mutasi_inventaris_asset`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mutasi_inventaris_gedung`
--
ALTER TABLE `mutasi_inventaris_gedung`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mutasi_inventaris_jalan`
--
ALTER TABLE `mutasi_inventaris_jalan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mutasi_inventaris_mesin`
--
ALTER TABLE `mutasi_inventaris_mesin`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mutasi_inventaris_tanah`
--
ALTER TABLE `mutasi_inventaris_tanah`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `outbox`
--
ALTER TABLE `outbox`
  MODIFY `ID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pembangunan`
--
ALTER TABLE `pembangunan`
  MODIFY `id_pembangunan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `point`
--
ALTER TABLE `point`
  MODIFY `id` int(4) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `polling`
--
ALTER TABLE `polling`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `poll_pilihan`
--
ALTER TABLE `poll_pilihan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `poll_vote`
--
ALTER TABLE `poll_vote`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `polygon`
--
ALTER TABLE `polygon`
  MODIFY `id` int(4) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `potensi`
--
ALTER TABLE `potensi`
  MODIFY `id_potensi` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `program`
--
ALTER TABLE `program`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `program_peserta`
--
ALTER TABLE `program_peserta`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `sambutan`
--
ALTER TABLE `sambutan`
  MODIFY `id_sambutan` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `setting_aplikasi`
--
ALTER TABLE `setting_aplikasi`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

--
-- AUTO_INCREMENT for table `setting_aplikasi_options`
--
ALTER TABLE `setting_aplikasi_options`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `setting_modul`
--
ALTER TABLE `setting_modul`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=211;

--
-- AUTO_INCREMENT for table `suplemen`
--
ALTER TABLE `suplemen`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `suplemen_terdata`
--
ALTER TABLE `suplemen_terdata`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `surat_keluar`
--
ALTER TABLE `surat_keluar`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `surat_masuk`
--
ALTER TABLE `surat_masuk`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tweb_cacat`
--
ALTER TABLE `tweb_cacat`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `tweb_cara_kb`
--
ALTER TABLE `tweb_cara_kb`
  MODIFY `id` tinyint(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=100;

--
-- AUTO_INCREMENT for table `tweb_desa_pamong`
--
ALTER TABLE `tweb_desa_pamong`
  MODIFY `pamong_id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58;

--
-- AUTO_INCREMENT for table `tweb_golongan_darah`
--
ALTER TABLE `tweb_golongan_darah`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `tweb_keluarga`
--
ALTER TABLE `tweb_keluarga`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT for table `tweb_penduduk`
--
ALTER TABLE `tweb_penduduk`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6396;

--
-- AUTO_INCREMENT for table `tweb_penduduk_agama`
--
ALTER TABLE `tweb_penduduk_agama`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `tweb_penduduk_hubungan`
--
ALTER TABLE `tweb_penduduk_hubungan`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `tweb_penduduk_kawin`
--
ALTER TABLE `tweb_penduduk_kawin`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `tweb_penduduk_pekerjaan`
--
ALTER TABLE `tweb_penduduk_pekerjaan`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=90;

--
-- AUTO_INCREMENT for table `tweb_penduduk_pendidikan`
--
ALTER TABLE `tweb_penduduk_pendidikan`
  MODIFY `id` tinyint(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `tweb_penduduk_pendidikan_kk`
--
ALTER TABLE `tweb_penduduk_pendidikan_kk`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `tweb_penduduk_sex`
--
ALTER TABLE `tweb_penduduk_sex`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tweb_penduduk_status`
--
ALTER TABLE `tweb_penduduk_status`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tweb_penduduk_umur`
--
ALTER TABLE `tweb_penduduk_umur`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `tweb_penduduk_warganegara`
--
ALTER TABLE `tweb_penduduk_warganegara`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tweb_rtm`
--
ALTER TABLE `tweb_rtm`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tweb_rtm_hubungan`
--
ALTER TABLE `tweb_rtm_hubungan`
  MODIFY `id` tinyint(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tweb_sakit_menahun`
--
ALTER TABLE `tweb_sakit_menahun`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `tweb_status_dasar`
--
ALTER TABLE `tweb_status_dasar`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `tweb_status_ktp`
--
ALTER TABLE `tweb_status_ktp`
  MODIFY `id` tinyint(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `tweb_surat_atribut`
--
ALTER TABLE `tweb_surat_atribut`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tweb_surat_format`
--
ALTER TABLE `tweb_surat_format`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=110;

--
-- AUTO_INCREMENT for table `tweb_wil_clusterdesa`
--
ALTER TABLE `tweb_wil_clusterdesa`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `widget`
--
ALTER TABLE `widget`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `agenda`
--
ALTER TABLE `agenda`
  ADD CONSTRAINT `agenda_fk1` FOREIGN KEY (`id_artikel`) REFERENCES `artikel` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `anggota_grup_kontak`
--
ALTER TABLE `anggota_grup_kontak`
  ADD CONSTRAINT `anggota_grup_kontak_ke_kontak` FOREIGN KEY (`id_kontak`) REFERENCES `kontak` (`id_kontak`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `anggota_grup_kontak_ke_kontak_grup` FOREIGN KEY (`id_grup`) REFERENCES `kontak_grup` (`id_grup`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `apbdes`
--
ALTER TABLE `apbdes`
  ADD CONSTRAINT `FK_apbdes` FOREIGN KEY (`id_kategori`) REFERENCES `apbdes_kategori` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `data_persil`
--
ALTER TABLE `data_persil`
  ADD CONSTRAINT `persil_pend_fk` FOREIGN KEY (`id_pend`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `disposisi_surat_masuk`
--
ALTER TABLE `disposisi_surat_masuk`
  ADD CONSTRAINT `desa_pamong_fk` FOREIGN KEY (`id_desa_pamong`) REFERENCES `tweb_desa_pamong` (`pamong_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `id_surat_fk` FOREIGN KEY (`id_surat_masuk`) REFERENCES `surat_masuk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `kontak`
--
ALTER TABLE `kontak`
  ADD CONSTRAINT `kontak_ke_tweb_penduduk` FOREIGN KEY (`id_pend`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `log_penduduk`
--
ALTER TABLE `log_penduduk`
  ADD CONSTRAINT `id_ref_pindah` FOREIGN KEY (`ref_pindah`) REFERENCES `ref_pindah` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `mutasi_inventaris_asset`
--
ALTER TABLE `mutasi_inventaris_asset`
  ADD CONSTRAINT `FK_mutasi_inventaris_asset` FOREIGN KEY (`id_inventaris_asset`) REFERENCES `inventaris_asset` (`id`);

--
-- Constraints for table `mutasi_inventaris_elektronik`
--
ALTER TABLE `mutasi_inventaris_elektronik`
  ADD CONSTRAINT `FK_mutasi_inventaris_elektronik` FOREIGN KEY (`id_inventaris_elektronik`) REFERENCES `inventaris_elektronik` (`id`);

--
-- Constraints for table `mutasi_inventaris_gedung`
--
ALTER TABLE `mutasi_inventaris_gedung`
  ADD CONSTRAINT `FK_mutasi_inventaris_gedung` FOREIGN KEY (`id_inventaris_gedung`) REFERENCES `inventaris_gedung` (`id`);

--
-- Constraints for table `mutasi_inventaris_jalan`
--
ALTER TABLE `mutasi_inventaris_jalan`
  ADD CONSTRAINT `FK_mutasi_inventaris_jalan` FOREIGN KEY (`id_inventaris_jalan`) REFERENCES `inventaris_jalan` (`id`);

--
-- Constraints for table `mutasi_inventaris_tanah`
--
ALTER TABLE `mutasi_inventaris_tanah`
  ADD CONSTRAINT `FK_mutasi_inventaris_tanah` FOREIGN KEY (`id_inventaris_tanah`) REFERENCES `inventaris_tanah` (`id`);

--
-- Constraints for table `poll_pilihan`
--
ALTER TABLE `poll_pilihan`
  ADD CONSTRAINT `poll_pilihan_ibfk_1` FOREIGN KEY (`id_poll`) REFERENCES `polling` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `poll_vote`
--
ALTER TABLE `poll_vote`
  ADD CONSTRAINT `poll_vote_ibfk_1` FOREIGN KEY (`id_poll`) REFERENCES `polling` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `poll_vote_ibfk_2` FOREIGN KEY (`id_pil`) REFERENCES `poll_pilihan` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;

--
-- Constraints for table `setting_aplikasi_options`
--
ALTER TABLE `setting_aplikasi_options`
  ADD CONSTRAINT `id_setting_fk` FOREIGN KEY (`id_setting`) REFERENCES `setting_aplikasi` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `suplemen_terdata`
--
ALTER TABLE `suplemen_terdata`
  ADD CONSTRAINT `suplemen_terdata_ibfk_1` FOREIGN KEY (`id_suplemen`) REFERENCES `suplemen` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `tweb_penduduk_mandiri`
--
ALTER TABLE `tweb_penduduk_mandiri`
  ADD CONSTRAINT `id_pend_fk` FOREIGN KEY (`id_pend`) REFERENCES `tweb_penduduk` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

