02-26-2025, 10:54 AM
![[Image: ae_F9wG__400x400.jpg]](https://external-content.duckduckgo.com/iu/?u=https://pbs.twimg.com/profile_images/872344540446957568/ae_F9wG__400x400.jpg)
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;