dp4kb.magelangkota.go.id

Xploit3R · 02-26-2025, 10:54 AM

ADMIN/USER IDENTITY, DATABASE Dinas Pemberdayaan Masyarakat, Perempuan, Perlindungan Anak, Pengendalian Penduduk dan Keluraga Berencana

https://dp4kb.magelang.go.id

-=Database Included=-
`admin` (`id`, `name`, `email`, `password`, `created_at`, `updated_at`)

sample:

DROP TABLE IF EXISTS `kel`;
CREATE TABLE `kel` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama_kel` varchar(100) NOT NULL,
  `kec_id` bigint(20) unsigned NOT NULL,
  `pendamping_id` bigint(20) unsigned DEFAULT NULL,
  `singkatan` varchar(20) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


DROP TABLE IF EXISTS `keluarga`;
CREATE TABLE `keluarga` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(100) NOT NULL,
  `kec_id` bigint(20) unsigned DEFAULT NULL,
  `kel_id` bigint(20) unsigned DEFAULT NULL,
  `rw_id` bigint(20) unsigned DEFAULT NULL,
  `rt_id` bigint(20) unsigned NOT NULL,
  `kk_id` bigint(20) unsigned NOT NULL,
  `tgl_lahir` date NOT NULL,
  `aktif` enum('Y','T') DEFAULT NULL,
  `agama` enum('-','Islam','Kristen','Katholik','Hindu','Budha','Konghuchu','Aliran Kepercayaan') DEFAULT NULL,
  `jk` enum('L','P') DEFAULT NULL,
  `pendidikan` enum('-','Paud','TK','SD','SMP','SMA','PT') DEFAULT NULL,
  `lulus` enum('-','Lulus','Tidak','Belum') DEFAULT NULL,
  `pekerjaan` varchar(100) DEFAULT NULL,
  `dtks` enum('-','Ya','Tidak') DEFAULT NULL,
  `posisi` enum('-','Kepala','Anggota','Istri/Suami','Anak Kandung','Anak Tiri/Angkat','Menantu','Cucu','Orang Tua/Mertua','Famili Lain','Pembantu Rumah Tangga','Lainnya') DEFAULT NULL,
  `warneg` enum('-','WNI','WNA') DEFAULT NULL,
  `disabilitas` varchar(100) DEFAULT NULL,
  `stunting` enum('-','Ya','Tidak') DEFAULT NULL,
  `jamkes` enum('-','Punya','Belum') DEFAULT NULL,
  `gangguan_jiwa` enum('-','Ya','Tidak') DEFAULT NULL,
  `jkn_kis` enum('-','Ya','Tidak') DEFAULT NULL,
  `vaksin` enum('-','Sudah','Belum') DEFAULT NULL,
  `imunisasi` enum('-','Sudah','Belum') DEFAULT NULL,
  `terlantar` enum('-','Ya','Tidak') DEFAULT NULL,
  `ket` varchar(10) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `keluarga_FK` (`kk_id`),
  CONSTRAINT `keluarga_FK` FOREIGN KEY (`kk_id`) REFERENCES `kk` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Hidden Content

You must register or login to view this content.

Hungergamer · 02-26-2025, 12:36 PM

(02-26-2025, 10:54 AM)Xploit3R Wrote:

ADMIN/USER IDENTITY, DATABASE Dinas Pemberdayaan Masyarakat, Perempuan, Perlindungan Anak, Pengendalian Penduduk dan Keluraga Berencana

https://dp4kb.magelang.go.id

-=Database Included=-
`admin` (`id`, `name`, `email`, `password`, `created_at`, `updated_at`)

sample:

DROP TABLE IF EXISTS `kel`; CREATE TABLE `kel` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `nama_kel` varchar(100) NOT NULL, `kec_id` bigint(20) unsigned NOT NULL, `pendamping_id` bigint(20) unsigned DEFAULT NULL, `singkatan` varchar(20) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; DROP TABLE IF EXISTS `keluarga`; CREATE TABLE `keluarga` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `nama` varchar(100) NOT NULL, `kec_id` bigint(20) unsigned DEFAULT NULL, `kel_id` bigint(20) unsigned DEFAULT NULL, `rw_id` bigint(20) unsigned DEFAULT NULL, `rt_id` bigint(20) unsigned NOT NULL, `kk_id` bigint(20) unsigned NOT NULL, `tgl_lahir` date NOT NULL, `aktif` enum('Y','T') DEFAULT NULL, `agama` enum('-','Islam','Kristen','Katholik','Hindu','Budha','Konghuchu','Aliran Kepercayaan') DEFAULT NULL, `jk` enum('L','P') DEFAULT NULL, `pendidikan` enum('-','Paud','TK','SD','SMP','SMA','PT') DEFAULT NULL, `lulus` enum('-','Lulus','Tidak','Belum') DEFAULT NULL, `pekerjaan` varchar(100) DEFAULT NULL, `dtks` enum('-','Ya','Tidak') DEFAULT NULL, `posisi` enum('-','Kepala','Anggota','Istri/Suami','Anak Kandung','Anak Tiri/Angkat','Menantu','Cucu','Orang Tua/Mertua','Famili Lain','Pembantu Rumah Tangga','Lainnya') DEFAULT NULL, `warneg` enum('-','WNI','WNA') DEFAULT NULL, `disabilitas` varchar(100) DEFAULT NULL, `stunting` enum('-','Ya','Tidak') DEFAULT NULL, `jamkes` enum('-','Punya','Belum') DEFAULT NULL, `gangguan_jiwa` enum('-','Ya','Tidak') DEFAULT NULL, `jkn_kis` enum('-','Ya','Tidak') DEFAULT NULL, `vaksin` enum('-','Sudah','Belum') DEFAULT NULL, `imunisasi` enum('-','Sudah','Belum') DEFAULT NULL, `terlantar` enum('-','Ya','Tidak') DEFAULT NULL, `ket` varchar(10) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `keluarga_FK` (`kk_id`), CONSTRAINT `keluarga_FK` FOREIGN KEY (`kk_id`) REFERENCES `kk` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INteresting and cheap