wartana
74b8f572a2
- Report: Added printable reports for all categories. - Dashboard: Fixed broken links and implemented gender balance filtering. - Logic: Auto-integration of Arrivals and Births into Resident/KK data. - Fix: Solved deletion popup bug in Birth Data. - Feature: Added Full KK History view. - Feature: Implemented Dynamic Village Profile for letter templates.
13 lines
513 B
SQL
13 lines
513 B
SQL
CREATE TABLE `tb_profil` (
|
|
`id_profil` int(11) NOT NULL PRIMARY KEY,
|
|
`nama_desa` varchar(50) NOT NULL,
|
|
`alamat` text NOT NULL,
|
|
`kecamatan` varchar(50) NOT NULL,
|
|
`kabupaten` varchar(50) NOT NULL,
|
|
`provinsi` varchar(50) NOT NULL,
|
|
`kepala_desa` varchar(50) NOT NULL,
|
|
`nip_kades` varchar(30) NOT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
INSERT INTO `tb_profil` VALUES (1, 'Desa Percontohan', 'Jl. Contoh No. 1', 'Kecamatan Contoh', 'Kabupaten Contoh', 'Jawa Barat', 'Budi Santoso', '123456789');
|