30 lines
2.9 KiB
SQL
Executable File
30 lines
2.9 KiB
SQL
Executable File
-- Add dummy population data for donut chart testing
|
|
-- Balita (0-5 years) - 5 records
|
|
INSERT INTO tb_pdd (id_pend, nik, nama, tempat_lh, tgl_lh, jekel, desa, rt, rw, agama, kawin, pekerjaan, status) VALUES
|
|
(16, '3201010101001001', 'Balita 1', 'Bogor', '2023-01-15', 'LK', 'Sukamaju', '01', '02', 'Islam', 'Belum', 'Balita', 'Ada'),
|
|
(17, '3201010101001002', 'Balita 2', 'Bogor', '2022-06-30', 'PR', 'Sukamaju', '01', '02', 'Islam', 'Belum', 'Balita', 'Ada'),
|
|
(18, '3201010101001003', 'Balita 3', 'Bogor', '2021-03-20', 'LK', 'Sukamaju', '01', '02', 'Islam', 'Belum', 'Balita', 'Ada'),
|
|
(19, '3201010101001004', 'Balita 4', 'Bogor', '2020-11-10', 'PR', 'Sukamaju', '02', '03', 'Islam', 'Belum', 'Balita', 'Ada'),
|
|
(20, '3201010101001005', 'Balita 5', 'Bogor', '2024-02-28', 'LK', 'Sukamaju', '02', '03', 'Islam', 'Belum', 'Balita', 'Ada');
|
|
|
|
-- Anak-anak (6-12 years) - 5 records
|
|
INSERT INTO tb_pdd (id_pend, nik, nama, tempat_lh, tgl_lh, jekel, desa, rt, rw, agama, kawin, pekerjaan, status) VALUES
|
|
(21, '3201010101001006', 'Anak 1', 'Bogor', '2018-05-15', 'LK', 'Sukamaju', '01', '02', 'Islam', 'Belum', 'Pelajar', 'Ada'),
|
|
(22, '3201010101001007', 'Anak 2', 'Bogor', '2017-08-20', 'PR', 'Sukamaju', '01', '02', 'Islam', 'Belum', 'Pelajar', 'Ada'),
|
|
(23, '3201010101001008', 'Anak 3', 'Bogor', '2016-12-10', 'LK', 'Sukamaju', '02', '03', 'Islam', 'Belum', 'Pelajar', 'Ada'),
|
|
(24, '3201010101001009', 'Anak 4', 'Bogor', '2015-04-25', 'PR', 'Sukamaju', '02', '03', 'Islam', 'Belum', 'Pelajar', 'Ada'),
|
|
(25, '3201010101001010', 'Anak 5', 'Bogor', '2014-09-05', 'LK', 'Sukamaju', '03', '04', 'Islam', 'Belum', 'Pelajar', 'Ada');
|
|
|
|
-- Remaja (13-17 years) - 5 records
|
|
INSERT INTO tb_pdd (id_pend, nik, nama, tempat_lh, tgl_lh, jekel, desa, rt, rw, agama, kawin, pekerjaan, status) VALUES
|
|
(26, '3201010101001011', 'Remaja 1', 'Bogor', '2011-07-15', 'LK', 'Sukamaju', '01', '02', 'Islam', 'Belum', 'Pelajar', 'Ada'),
|
|
(27, '3201010101001012', 'Remaja 2', 'Bogor', '2010-03-20', 'PR', 'Sukamaju', '01', '02', 'Islam', 'Belum', 'Pelajar', 'Ada'),
|
|
(28, '3201010101001013', 'Remaja 3', 'Bogor', '2009-11-30', 'LK', 'Sukamaju', '02', '03', 'Islam', 'Belum', 'Pelajar', 'Ada'),
|
|
(29, '3201010101001014', 'Remaja 4', 'Bogor', '2008-06-10', 'PR', 'Sukamaju', '02', '03', 'Islam', 'Belum', 'Pelajar', 'Ada'),
|
|
(30, '3201010101001015', 'Remaja 5', 'Bogor', '2007-01-25', 'LK', 'Sukamaju', '03', '04', 'Islam', 'Belum', 'Pelajar', 'Ada');
|
|
|
|
-- Lansia (60+ years) - 3 records
|
|
INSERT INTO tb_pdd (id_pend, nik, nama, tempat_lh, tgl_lh, jekel, desa, rt, rw, agama, kawin, pekerjaan, status) VALUES
|
|
(31, '3201010101001016', 'Lansia 1', 'Bogor', '1960-05-15', 'LK', 'Sukamaju', '01', '02', 'Islam', 'Kawin', 'Pensiunan', 'Ada'),
|
|
(32, '3201010101001017', 'Lansia 2', 'Bogor', '1958-08-20', 'PR', 'Sukamaju', '01', '02', 'Islam', 'Cerai Mati', 'Pensiunan', 'Ada'),
|
|
(33, '3201010101001018', 'Lansia 3', 'Bogor', '1955-12-10', 'LK', 'Sukamaju', '02', '03', 'Islam', 'Kawin', 'Pensiunan', 'Ada'); |