24-05-25, 11:35 AM
Setinggi tinggi nya awan lebih tinggi omongan pahlawan
Dilingkungan yang munafik, orang jujur adalah penjahatnya
kalo ikut jangan takut, kalo takut jangan ikut!!
Beda teman beda proses, salah temen masuk polres
DATA
Code:
Cyber Sederhana Team Was Here Yaa..
-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 01, 2025 at 10:29 AM
-- Server version: 10.1.38-MariaDB
-- PHP Version: 7.3.2
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `db-desa`
--
-- --------------------------------------------------------
--
-- Table structure for table `conf_sistem`
--
CREATE TABLE `conf_sistem` (
`id` int(5) NOT NULL,
`desc` varchar(20) DEFAULT NULL,
`content` text,
`jenis` int(1) DEFAULT NULL COMMENT '1 profile, 2 sistem',
`gambar` int(1) DEFAULT NULL COMMENT '1 = YA'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `conf_sistem`
--
INSERT INTO `conf_sistem` (`id`, `desc`, `content`, `jenis`, `gambar`) VALUES
(1, 'Judul', 'Layanan Terpadu', 2, NULL),
(2, 'Sub Judul', 'Desa Digital', 2, NULL),
(5, 'logo', '171224-075056-579854382.png', 1, 1),
(6, 'Singkatan ', 'DESA DIGITAL', 2, NULL),
(7, 'Nama Desa', 'Desa Digital', 1, NULL),
(8, 'Kabupaten', 'Kabupaten Pekalongan', 1, NULL),
(9, 'kop_1', 'PEMERINTAH KABUPATEN PEKALONGAN', 3, NULL),
(10, 'kop_2', 'KECAMATAN KEDUNGWUNI', 3, NULL),
(11, 'kop_3', 'DESA ROWOCACING', 3, NULL),
(12, 'Alamat Desa', 'Jl. Raya Desa Rowocacing No 1 RT. 007 RW. 004', 1, NULL),
(14, 'Kode Desa', '2003', 1, NULL),
(15, 'Gambar Depan', '', 2, 1),
(16, 'Kecamatan', 'Kecamatan Kedungwuni', 1, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `tb_agama`
--
CREATE TABLE `tb_agama` (
`id` int(2) NOT NULL,
`nama` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_agama`
--
INSERT INTO `tb_agama` (`id`, `nama`) VALUES
(1, 'Islam'),
(2, 'Kristen'),
(3, 'Protestan'),
(4, 'Katolik'),
(5, 'Hindu'),
(6, 'Buddha'),
(7, 'Konghucu');
-- --------------------------------------------------------
--
-- Table structure for table `tb_arsip`
--
CREATE TABLE `tb_arsip` (
`id` int(4) NOT NULL,
`nomor_kk` varchar(25) NOT NULL,
`foto` text NOT NULL,
`upload` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_arsip`
--
INSERT INTO `tb_arsip` (`id`, `nomor_kk`, `foto`, `upload`) VALUES
(1, '3207225469860002', '291224-080709-111759487.pdf', '2024-12-29 01:07:09');
-- --------------------------------------------------------
--
-- Table structure for table `tb_darah`
--
CREATE TABLE `tb_darah` (
`id` int(11) NOT NULL,
`darah` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_darah`
--
INSERT INTO `tb_darah` (`id`, `darah`) VALUES
(1, 'Tidak Tahu'),
(2, 'A'),
(3, 'AB'),
(4, 'B'),
(5, 'O');
-- --------------------------------------------------------
--
-- Table structure for table `tb_data_penduduk`
--
CREATE TABLE `tb_data_penduduk` (
`id` int(11) NOT NULL,
`no_kk` varchar(25) DEFAULT NULL,
`no_nik` varchar(25) DEFAULT NULL,
`nama_lengkap` varchar(120) DEFAULT NULL,
`alamat_kampung` varchar(100) DEFAULT NULL,
`rt` varchar(5) DEFAULT NULL,
`rw` varchar(5) DEFAULT NULL,
`jenis_kelamin` varchar(1) DEFAULT NULL,
`tempat_lahir` varchar(100) DEFAULT NULL,
`tanggal_lahir` date DEFAULT NULL,
`agama` int(2) DEFAULT NULL,
`pendidikan` int(2) DEFAULT NULL,
`jenis_pekerjaan` int(2) DEFAULT NULL,
`status_perkawinan` int(2) DEFAULT NULL,
`tanggal_kawin` date NOT NULL,
`sdhk` int(1) NOT NULL,
`kewarganegaraan` varchar(3) DEFAULT NULL,
`no_paspor` varchar(20) NOT NULL,
`no_kitap` varchar(20) NOT NULL,
`nama_ayah` varchar(100) DEFAULT NULL,
`nama_ibu` varchar(100) DEFAULT NULL,
`gol_darah` varchar(15) NOT NULL,
`mutasi` varchar(20) NOT NULL,
`keterangan` varchar(100) DEFAULT NULL,
`createdby` varchar(20) DEFAULT NULL,
`createdon` timestamp NULL DEFAULT NULL,
`modifiedon` timestamp NULL DEFAULT NULL,
`rowstatus` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_data_penduduk`
--
INSERT INTO `tb_data_penduduk` (`id`, `no_kk`, `no_nik`, `nama_lengkap`, `alamat_kampung`, `rt`, `rw`, `jenis_kelamin`, `tempat_lahir`, `tanggal_lahir`, `agama`, `pendidikan`, `jenis_pekerjaan`, `status_perkawinan`, `tanggal_kawin`, `sdhk`, `kewarganegaraan`, `no_paspor`, `no_kitap`, `nama_ayah`, `nama_ibu`, `gol_darah`, `mutasi`, `keterangan`, `createdby`, `createdon`, `modifiedon`, `rowstatus`) VALUES
(15, '3207225469860002', '32072326799100204', 'Ujang Rismanto Jaya', 'Pajaten', '003', '007', 'L', 'Ciamis', '1945-06-01', 1, 13, 6, 2, '0000-00-00', 0, 'WNI', '', '', 'Suyamta', 'Nurjanah', '', '-', '-', 'Aldy Setiawan', '2020-10-23 16:33:50', '2024-12-20 06:41:11', 1),
(16, '3207225469860002', '36034569871010006', 'Pandi waluyo prasetyo', 'Kampung Talaga', '001', '002', 'L', 'Tangerang ', '1992-03-05', 1, 13, 6, 4, '0000-00-00', 0, 'WNI', '', '', 'Supriyanto', 'Sarmanah', '', '-', '-', 'Aldy Setiawan', '2020-10-23 16:33:50', '2024-12-18 09:12:28', 1),
(17, '3329185246160007', '33293154978600021', 'ADITYA YULI NUGRAHA', 'Cikakak', '013', '002', 'L', 'Cilacap', '1997-06-28', 1, 11, 6, 3, '0000-00-00', 0, 'WNI', '', '', 'Nopriansyah', 'Helena', '', '', '-', 'Aldy Setiawan', '2020-10-23 16:33:50', NULL, 1),
(18, '3329185246160007', '37895212708190013', 'Imas saribanon', 'kadongdong', '003', '003', 'P', 'Sukabumi ', '1985-09-17', 1, 13, 6, 2, '0000-00-00', 0, 'WNI', '', '', 'Moh hanafi', 'Handayani', '', '-', '-', 'Aldy Setiawan', '2020-10-23 16:33:50', '2024-12-17 13:17:47', 1),
(19, '9878140205950004', '36730127484160013', 'Muslih alqusairi', 'Nanggerang', '001', '006', 'L', 'Pandeglang', '2008-06-28', 2, 13, 6, 1, '0000-00-00', 0, 'WNA', '', '', 'HAKIKI', 'Rodiyah', '', '', '-', 'Aldy Setiawan', '2020-10-23 16:33:50', '2024-12-18 08:32:38', 1),
(20, '3207225469860002', '18011402059500014', 'Mas hadiyan', 'Kampung Cipeteuy', '06', '01', 'L', 'Pandeglang', '2015-08-14', 1, 13, 1, 2, '0000-00-00', 0, 'WNI', '', '', 'Sanjaya', 'Suba', '', 'Pisah KK', '', 'Aldy Setiawan', '2020-10-30 03:57:47', '2024-12-18 12:13:47', 0),
(21, '9878140205950004', '1234567891011', 'Adnan Mubarok', 'Ciujung', '001', '003', 'L', 'Serang', '2023-08-09', 1, 13, 3, 1, '0000-00-00', 0, 'WNI', '', '', 'Joko Kendil', 'Kendil Joko', '', 'Meninggal', 'tanggal 12 des 2024', 'Mumun Munjiah', '2022-10-23 06:50:48', '2024-12-18 12:28:01', 0),
(22, '3207225469860010', '18011402059500014', 'Mas hadiyan', 'proto', '003', '001', 'L', 'Pekalongan', '2000-03-14', 1, 6, 2, 2, '0000-00-00', 0, 'WNI', '', '', 'suketman', 'suketi', '', '', '', 'Santoso', '2024-12-20 08:46:39', NULL, 1),
(23, '216843168434684', '687632468435168', 'Azlan Zavier', 'Kampung Cipeteuy', '003', '001', 'L', 'Pekalongan', '2021-10-14', 1, 2, 1, 1, '0000-00-00', 4, 'WNI', '', '', 'Anton', 'Medan', '3', '', '', 'Santoso', '2024-12-25 03:37:34', '2024-12-29 03:17:34', 1),
(24, '57758778578', '76858758758', 'altaf', 'Kampung Cipeteuy', '06', '01', 'L', 'pekalongan', '2024-12-29', 1, 1, 1, 1, '0000-00-00', 4, 'WNI', '', '', 'asdasd', 'asdasda', '2', '', '', 'Santoso', '2024-12-29 02:56:29', '2024-12-29 03:17:45', 1);
-- --------------------------------------------------------
--
-- Table structure for table `tb_jabatan`
--
CREATE TABLE `tb_jabatan` (
`id_jabatan` int(3) NOT NULL,
`id_sub` int(2) DEFAULT NULL,
`nama` varchar(50) DEFAULT NULL,
`warna` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_jabatan`
--
INSERT INTO `tb_jabatan` (`id_jabatan`, `id_sub`, `nama`, `warna`) VALUES
(1, 0, 'Kepala Desa', 'oren'),
(3, 1, 'Sekretaris Desa', 'biru'),
(4, 3, 'Kaur TU & Umum', 'hijau'),
(5, 3, 'Kaur Keuangan', 'hijau'),
(6, 3, 'Kaur Perencanaan', 'hijau'),
(7, 1, 'Kasi Pemerintahan', 'biru'),
(8, 1, 'Kasi Kesejahteraan', 'biru'),
(9, 1, 'Kasi Pelayanan', 'biru'),
(10, 7, 'Staff Pemerintahan', 'magenta'),
(11, 8, 'Staff Kesejahteraan', 'magenta'),
(12, 9, 'Staff Pelayanan', 'magenta'),
(13, 4, 'Staff TU & Umum', 'magenta'),
(14, 5, 'Staff Keuangan', 'magenta'),
(15, 6, 'Staff Honorer', 'ungu');
-- --------------------------------------------------------
--
-- Table structure for table `tb_jenis_usaha`
--
CREATE TABLE `tb_jenis_usaha` (
`id` int(3) NOT NULL,
`nama` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_jenis_usaha`
--
INSERT INTO `tb_jenis_usaha` (`id`, `nama`) VALUES
(1, 'ATK dan Fotocopy'),
(2, 'Bengkel Mobil'),
(3, 'Bengkel Motor'),
(4, 'Bensin Eceran'),
(5, 'Kelontong'),
(6, 'Perdagangan'),
(7, 'Service Komputer'),
(8, 'Service TV'),
(9, 'Warung Sembako');
-- --------------------------------------------------------
--
-- Table structure for table `tb_kawin`
--
CREATE TABLE `tb_kawin` (
`id` int(2) NOT NULL,
`nama` varchar(30) DEFAULT NULL,
`singkat` varchar(2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_kawin`
--
INSERT INTO `tb_kawin` (`id`, `nama`, `singkat`) VALUES
(1, 'Tidak Kawin', 'TK'),
(2, 'Kawin', 'K'),
(3, 'Cerai Hidup', 'CH'),
(4, 'Cerai Mati', 'CM');
-- --------------------------------------------------------
--
-- Table structure for table `tb_menu_pkd`
--
CREATE TABLE `tb_menu_pkd` (
`id` int(2) NOT NULL,
`nama_pkd` varchar(50) NOT NULL,
`url` varchar(30) NOT NULL,
`icon` varchar(20) NOT NULL,
`code` varchar(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_menu_pkd`
--
INSERT INTO `tb_menu_pkd` (`id`, `nama_pkd`, `url`, `icon`, `code`) VALUES
(1, 'Posyandu 1', '?page=posyandu1', 'fas fa-hospital', '1'),
(2, 'Posyandu 2', '?page=posyandu2', 'fas fa-hospital', '1'),
(3, 'Posyandu 3', '?page=posyandu3', 'fas fa-hospital', '1');
-- --------------------------------------------------------
--
-- Table structure for table `tb_menu_surat`
--
CREATE TABLE `tb_menu_surat` (
`id` int(3) NOT NULL,
`nama_menu` varchar(50) DEFAULT NULL,
`url` varchar(30) DEFAULT NULL,
`icon` varchar(20) DEFAULT NULL,
`kode` varchar(5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_menu_surat`
--
INSERT INTO `tb_menu_surat` (`id`, `nama_menu`, `url`, `icon`, `kode`) VALUES
(1, 'Surat Keterangan Usaha', '?page=sku', 'fas fa-envelope', '503'),
(2, 'Surat Keterangan Domisili', '?page=domisili', 'fas fa-envelope', '470'),
(3, 'Surat Keterangan Domisili Usaha', '?page=domisili_usaha', 'fas fa-envelope', NULL),
(4, 'Surat Keterangan Domisili Yayasan', '?page=domisili_yayasan', 'fas fa-envelope', NULL),
(5, 'Surat Keterangan Tidak Mampu', '?page=tidak_mampu', 'fas fa-envelope', '460'),
(6, 'Surat Keterangan Emergency', '?page=emergency', 'fas fa-envelope', NULL),
(7, 'Surat Keterangan Pindah', '?page=pindah', 'fas fa-envelope', NULL),
(8, 'Surat Keterangan KTP Sementara', '?page=ktp_sementara', 'fas fa-envelope', NULL),
(9, 'Surat Keterangan Beda Nama KTP/KK', '?page=beda_nama', 'fas fa-envelope', NULL),
(10, 'Surat Keterangan Numpang Nikah', '?page=numpang_nikah', 'fas fa-envelope', NULL),
(11, 'Surat Keterangan Nikah Secara Agama', '?page=nikah_agama', 'fas fa-envelope', NULL),
(12, 'Surat Keterangan Menikah', '?page=menikah', 'fas fa-envelope', NULL),
(13, 'Surat Keterangan Belum Pernah Menikah', '?page=belum_menikah', 'fas fa-envelope', '474.2'),
(15, 'Surat Keterangan Kelahiran', '?page=kelahiran', 'fas fa-envelope', NULL),
(16, 'Surat Keterangan Akte Kelahiran Sementara', '?page=akte_kelahiran', 'fas fa-envelope', NULL),
(17, 'Surat Keterangan Kematian', '?page=kematian', 'fas fa-envelope', NULL),
(18, 'Surat Keterangan Ahli Waris', '?page=waris', 'fas fa-envelope', NULL),
(19, 'Surat Keterangan Pemakaman', '?page=pemakaman', 'fas fa-envelope', '474.3'),
(20, 'Surat Keterangan Duda/Janda', '?page=duda_janda', 'fas fa-envelope', NULL),
(21, 'Surat Keterangan Jual Sanda/Gadai', '?page=jual_gadai', 'fas fa-envelope', NULL),
(22, 'Surat Keterangan Belum Memiliki Rumah', '?page=belum_memiliki_rumah', 'fas fa-envelope', NULL),
(23, 'Surat Keterangan KWH Listrik An. Orang Lain', '?page=kwh_listrik', 'fas fa-envelope', NULL),
(24, 'Surat Keterangan Penghasilan Untuk Pend.', '?page=penghasilan_pendidikan', 'fas fa-envelope', NULL),
(25, 'Surat Keterangan Penghasilan', '?page=penghasilan', 'fas fa-envelope', NULL),
(26, 'Surat Keterangan Laporan Kehilangan', '?page=laporan_kehilangan', 'fas fa-envelope', NULL),
(27, 'Surat Pengantar SKCK', '?page=skck', 'fas fa-envelope', '331'),
(28, 'Surat Izin Keramaian', '?page=izin_keramaian', 'fas fa-envelope', '503');
-- --------------------------------------------------------
--
-- Table structure for table `tb_pegawai`
--
CREATE TABLE `tb_pegawai` (
`id_pegawai` int(5) NOT NULL,
`nip` varchar(20) DEFAULT NULL,
`jabatan` varchar(20) DEFAULT NULL,
`nama_pegawai` varchar(30) DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
`no_hp` varchar(20) DEFAULT NULL,
`alamat` varchar(30) DEFAULT NULL,
`tempat_lahir` varchar(30) DEFAULT NULL,
`tanggal_lahir` date DEFAULT NULL,
`jenkel` enum('Pria','Wanita','','') DEFAULT NULL,
`aktif` int(1) DEFAULT NULL,
`createdon` date DEFAULT NULL,
`createdby` varchar(20) DEFAULT NULL,
`rowstatus` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_pegawai`
--
INSERT INTO `tb_pegawai` (`id_pegawai`, `nip`, `jabatan`, `nama_pegawai`, `email`, `no_hp`, `alamat`, `tempat_lahir`, `tanggal_lahir`, `jenkel`, `aktif`, `createdon`, `createdby`, `rowstatus`) VALUES
(4, '5874369', '1', 'Santoso', 'aldysetiaa@gmail.com', '085216479907', 'Menes Pandeglang', 'Pandeglang', '1996-05-15', 'Pria', 1, NULL, NULL, 1),
(11, '8575126', '3', 'Tatang Sutardi', 'aldysetiaa@gmail.com', '085216479907', 'Menes Pandeglang', 'Pandeglang', '1996-11-06', 'Pria', 1, NULL, NULL, 1),
(14, '5959412', '4', 'Mumun Munjiah', 'mumun.mnj@gmail.com', '085151548623', 'Jakarta Barat', 'Jakarta', '1995-08-01', '', 1, '2022-10-22', 'Aldy Setiawan', 1),
(15, '2846548', '5', 'Siti Munjayanah', 'munjayanah@gmail.com', '081258415452', 'Pandeglang', 'Pandeglang', '1996-12-17', NULL, 1, NULL, NULL, 1),
(16, '5455157', '6', ' Ade lili Nuryani', 'lili.nuryani@gmail.com', '085715462323', 'Pandeglang', 'Pandeglang', '1996-08-22', NULL, 1, NULL, NULL, 1),
(17, '5445454', '7', 'Ratu Tatu Rodiyah', 'tatu.r@gmail.com', '083815451545', 'Pandeglang', 'Pandeglang', '1997-04-15', NULL, 1, NULL, NULL, 1),
(18, '4856184', '8', 'Yongki hartoni', 'yongki@gmail.com', '085854855215', 'Pandeglang', 'Pandeglang', '1996-09-11', NULL, 1, NULL, NULL, 1),
(19, '1587989', '9', 'Erdaleni', 'erd@gmail.com', '085218795665', 'Pandeglang', 'Pandeglang', '1997-06-28', NULL, 1, NULL, NULL, 1),
(20, '2187485', '10', 'Yuli Yana', 'yuli@gmail.com', '089258484652', 'Pandeglang', 'Pandeglang', '1996-09-12', NULL, 1, NULL, NULL, 1),
(21, '4854551', '11', 'Siti Nur Wakhidah', 'wakhidahlia@gmail.com', '085451548712', 'Pandeglang', 'Pandeglang', '1997-06-28', 'Wanita', 1, NULL, NULL, 1),
(22, '2184841', '12', ' Ade sopian', 'sopian.ade@yahoo.com', '083841515485', 'Pandeglang', 'Pandeglang', '1997-06-17', NULL, 1, NULL, NULL, 1),
(23, '8542369', '15', 'RISHA OKTAVIYANI', 'rishaoktaviyani@gmail.com', '085465874626', 'Serang', 'Serang', '0000-00-00', 'Wanita', 1, '2022-10-22', 'Aldy Setiawan', 1);
-- --------------------------------------------------------
--
-- Table structure for table `tb_pekerjaan`
--
CREATE TABLE `tb_pekerjaan` (
`id` int(2) NOT NULL,
`nama` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_pekerjaan`
--
INSERT INTO `tb_pekerjaan` (`id`, `nama`) VALUES
(1, 'Belum/Tidak Bekerja'),
(2, 'Buruh Tani'),
(3, 'Dagang'),
(4, 'Guru'),
(5, 'Guru Agama'),
(6, 'Karyawan Swasta'),
(7, 'Mengurus Rumah Tangga'),
(8, 'Paraji'),
(9, 'Pensiunan'),
(10, 'Petani/Peternak'),
(11, 'PNS/TNI/Polri'),
(12, 'Pegawai BUMN'),
(13, 'Honorer'),
(14, 'Sopir'),
(15, 'Tukang Kayu'),
(16, 'Wiraswasta'),
(17, 'Bidan'),
(18, 'Perawat/Dokter'),
(19, 'Buruh Bangunan');
-- --------------------------------------------------------
--
-- Table structure for table `tb_pendidikan`
--
CREATE TABLE `tb_pendidikan` (
`id` int(5) NOT NULL,
`nama` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_pendidikan`
--
INSERT INTO `tb_pendidikan` (`id`, `nama`) VALUES
(1, 'Belum/Tidak Sekolah'),
(2, 'PAUD'),
(3, 'TK'),
(4, 'MI/SD'),
(5, 'SMP/MTs/SLTP'),
(6, 'SMA/SMK/SLTA'),
(7, 'Diploma I (D1)'),
(8, 'Diploma II (D2)'),
(9, 'Diploma III (D3)'),
(10, 'Diploma IV (D4)'),
(11, 'Strata I (S1)'),
(12, 'Strata II (S2)'),
(13, 'Strata III (S3)');
-- --------------------------------------------------------
--
-- Table structure for table `tb_sdhk`
--
CREATE TABLE `tb_sdhk` (
`id` int(1) NOT NULL,
`nama` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_sdhk`
--
INSERT INTO `tb_sdhk` (`id`, `nama`) VALUES
(1, 'Kepala Keluarga'),
(2, 'Suami'),
(3, 'Istri'),
(4, 'Anak'),
(5, 'Menantu'),
(6, 'Orang Tua'),
(7, 'Mertua'),
(8, 'Mertua'),
(9, 'Pembantu'),
(10, 'Famili Lain');
-- --------------------------------------------------------
--
-- Table structure for table `tb_surat`
--
CREATE TABLE `tb_surat` (
`id_surat` int(8) NOT NULL,
`jenis_surat` varchar(20) NOT NULL,
`no_surat` varchar(50) NOT NULL,
`nama_surat` varchar(100) NOT NULL,
`tanggal` date DEFAULT NULL,
`isi_surat` text,
`tanda_tangan` text NOT NULL,
`id_warga` int(5) NOT NULL,
`jenis_warga` int(2) NOT NULL,
`arsip` int(1) DEFAULT NULL,
`createdon` datetime DEFAULT NULL,
`createdby` varchar(20) DEFAULT NULL,
`rowstatus` int(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_surat`
--
INSERT INTO `tb_surat` (`id_surat`, `jenis_surat`, `no_surat`, `nama_surat`, `tanggal`, `isi_surat`, `tanda_tangan`, `id_warga`, `jenis_warga`, `arsip`, `createdon`, `createdby`, `rowstatus`) VALUES
(1, 'SKU', '503/1/2003/SKU/XII/2024', 'Surat Keterangan Usaha', '2024-12-22', '{\"nik\":\"32072326799100204\",\"nama\":\"Ujang Rismanto Jaya\",\"tempat_lahir\":\"Ciamis\",\"tgl_lahir\":\"01/06/1945\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Kawin\",\"alamat\":\"Pajaten\",\"rt\":\"003\",\"rw\":\"007\",\"warga\":\"WNI\",\"pekerjaan\":null,\"jenis_usaha\":\"Service TV\",\"alamat_usaha\":\"Rowocacing\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 15, 1, NULL, '2024-12-22 19:34:02', 'Santoso', 1),
(12, 'SKD', '470/2/2003/SKD/XII/2024', 'Surat Keterangan Domisili', '2024-12-22', '{\"nik\":\"32072326799100204\",\"nama\":\"Ujang Rismanto Jaya\",\"tempat_lahir\":\"Ciamis\",\"tgl_lahir\":\"01/06/1945\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Kawin\",\"alamat\":\"Pajaten\",\"rt\":\"003\",\"rw\":\"007\",\"warga\":\"WNI\",\"pekerjaan\":\"Dagang\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 15, 0, NULL, '2024-12-22 19:55:32', 'Santoso', 1),
(10, 'SKU', '503/2/2003/SKU/XII/2024', 'Surat Keterangan Usaha', '2024-12-22', '{\"nik\":\"32072326799100204\",\"nama\":\"Ujang Rismanto Jaya\",\"tempat_lahir\":\"Ciamis\",\"tgl_lahir\":\"01/06/1945\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Kawin\",\"alamat\":\"Pajaten\",\"rt\":\"003\",\"rw\":\"007\",\"warga\":\"WNI\",\"pekerjaan\":null,\"jenis_usaha\":\"Service TV\",\"alamat_usaha\":\"ghfgh\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 15, 1, 1, '2024-12-22 19:48:16', '', 1),
(28, 'SKKB', '331/1/2003/SKKB/XII/2024', 'Surat Keterangan Kelakuan Baik', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Pandi waluyo prasetyo\",\"tempat_lahir\":\"Tangerang \",\"tgl_lahir\":\"05/03/1992\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Mati\",\"alamat\":\"Kampung Talaga\",\"rt\":\"001\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\",\"keperluan\":\"melamar kerja\",\"kelakuan\":\"1. Berkelakuan Baik \r\n2. Tidak termasuk pecandu narkotika dan minuman keras \r\n3. Tidak pernah terlibat dalam pidana maupun perdata \"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 16, 0, NULL, '2024-12-22 21:03:42', '', 1),
(5, 'SKTM', '460/1/2003/SKTM/XII/2024', 'Surat Keterangan Tidak Mampu', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Ujang Rismanto Jaya\",\"tempat_lahir\":\"Ciamis\",\"tgl_lahir\":\"01/06/1945\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Kawin\",\"alamat\":\"Pajaten\",\"rt\":\"003\",\"rw\":\"007\",\"warga\":\"WNI\",\"pekerjaan\":null,\"keperluan\":\"beasiswa sekolah\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 15, 0, NULL, '2024-12-22 19:38:33', 'Santoso', 1),
(6, 'SKBPM', '474.2/1/2003/SKBPM/XII/2024', 'Surat Keterangan Belum Pernah Menikah', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Ujang Rismanto Jaya\",\"tempat_lahir\":\"Ciamis\",\"tgl_lahir\":\"01/06/1945\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Kawin\",\"alamat\":\"Pajaten\",\"rt\":\"003\",\"rw\":\"007\",\"warga\":\"WNI\",\"pekerjaan\":null}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 15, 0, NULL, '2024-12-22 19:39:09', 'Santoso', 1),
(7, 'SKP', '474.3/1/2003/SKP/XII/2024', 'Surat Keterangan Pemakaman', '2024-12-22', '{\"nik\":\"32072326799100204\",\"nama\":\"Ujang Rismanto Jaya\",\"tempat_lahir\":\"Ciamis\",\"tgl_lahir\":\"01/06/1945\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Kawin\",\"alamat\":\"Pajaten\",\"rt\":\"003\",\"rw\":\"007\",\"warga\":\"WNI\",\"pekerjaan\":null,\"tgl_kematian\":\"22/12/2024\",\"tgl_pemakaman\":\"22/12/2024\",\"jam_pemakaman\":\"19:12\",\"tempat_pemakaman\":\"Proto\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 15, 0, NULL, '2024-12-22 19:39:51', 'Santoso', 1),
(8, 'SKTM', '460/2/2003/SKTM/XII/2024', 'Surat Keterangan Tidak Mampu', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Ujang Rismanto Jaya\",\"tempat_lahir\":\"Ciamis\",\"tgl_lahir\":\"01/06/1945\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Kawin\",\"alamat\":\"Pajaten\",\"rt\":\"003\",\"rw\":\"007\",\"warga\":\"WNI\",\"pekerjaan\":null,\"keperluan\":\"beasiswa\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 15, 0, NULL, '2024-12-22 19:43:32', '', 1),
(27, 'SKP', '474.3/2/2003/SKP/XII/2024', 'Surat Keterangan Pemakaman', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Pandi waluyo prasetyo\",\"tempat_lahir\":\"Tangerang \",\"tgl_lahir\":\"05/03/1992\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Mati\",\"alamat\":\"Kampung Talaga\",\"rt\":\"001\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\",\"tgl_kematian\":\"22/12/2024\",\"tgl_pemakaman\":\"22/12/2024\",\"jam_pemakaman\":\"20:12\",\"tempat_pemakaman\":\"ad\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 16, 0, NULL, '2024-12-22 20:58:22', '', 1),
(14, 'SKD', '470/3/2003/SKD/XII/2024', 'Surat Keterangan Domisili', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Ujang Rismanto Jaya\",\"tempat_lahir\":\"Ciamis\",\"tgl_lahir\":\"01/06/1945\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Kawin\",\"alamat\":\"Pajaten\",\"rt\":\"003\",\"rw\":\"007\",\"warga\":\"WNI\",\"pekerjaan\":null}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 15, 0, NULL, '2024-12-22 19:59:34', '', 1),
(15, 'SKD', '470/4/2003/SKD/XII/2024', 'Surat Keterangan Domisili', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Ujang Rismanto Jaya\",\"tempat_lahir\":\"Ciamis\",\"tgl_lahir\":\"01/06/1945\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Kawin\",\"alamat\":\"Pajaten\",\"rt\":\"003\",\"rw\":\"007\",\"warga\":\"WNI\",\"pekerjaan\":null}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 15, 0, NULL, '2024-12-22 20:01:27', '', 1),
(16, 'SKU', '503/3/2003/SKU/XII/2024', 'Surat Keterangan Usaha', '2024-12-22', '{\"nik\":\"32072326799100204\",\"nama\":\"Ujang Rismanto Jaya\",\"tempat_lahir\":\"Ciamis\",\"tgl_lahir\":\"01/06/1945\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Kawin\",\"alamat\":\"Pajaten\",\"rt\":\"003\",\"rw\":\"007\",\"warga\":\"WNI\",\"pekerjaan\":\"Pensiunan\",\"jenis_usaha\":\"Kelontong\",\"alamat_usaha\":\"rowocacing\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 15, 0, NULL, '2024-12-22 20:03:04', '', 1),
(17, 'SKD', '470/5/2003/SKD/XII/2024', 'Surat Keterangan Domisili', '2024-12-22', '{\"nik\":\"33293154978600021\",\"nama\":\"ADITYA YULI NUGRAHA\",\"tempat_lahir\":\"Cilacap\",\"tgl_lahir\":\"28/06/1997\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Hidup\",\"alamat\":\"Cikakak\",\"rt\":\"013\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 17, 0, NULL, '2024-12-22 20:04:29', 'Santoso', 1),
(18, 'SKD', '470/6/2003/SKD/XII/2024', 'Surat Keterangan Domisili', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Pandi waluyo prasetyo\",\"tempat_lahir\":\"Tangerang \",\"tgl_lahir\":\"05/03/1992\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Mati\",\"alamat\":\"Kampung Talaga\",\"rt\":\"001\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 16, 0, NULL, '2024-12-22 20:12:54', '', 1),
(19, 'SKU', '503/4/2003/SKU/XII/2024', 'Surat Keterangan Usaha', '2024-12-22', '{\"nik\":\"36034569871010006\",\"nama\":\"Pandi waluyo prasetyo\",\"tempat_lahir\":\"Tangerang \",\"tgl_lahir\":\"05/03/1992\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Mati\",\"alamat\":\"Kampung Talaga\",\"rt\":\"001\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\",\"jenis_usaha\":\"Bengkel Mobil\",\"alamat_usaha\":\"rowocacing\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 16, 0, NULL, '2024-12-22 20:17:17', '', 1),
(20, 'SKU', '503/5/2003/SKU/XII/2024', 'Surat Keterangan Usaha', '2024-12-22', '{\"nik\":\"36034569871010006\",\"nama\":\"Pandi waluyo prasetyo\",\"tempat_lahir\":\"Tangerang \",\"tgl_lahir\":\"05/03/1992\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Mati\",\"alamat\":\"Kampung Talaga\",\"rt\":\"001\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\",\"jenis_usaha\":\"Kelontong\",\"alamat_usaha\":\"ffg\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 16, 0, NULL, '2024-12-22 20:18:39', '', 1),
(21, 'SKU', '503/6/2003/SKU/XII/2024', 'Surat Keterangan Usaha', '2024-12-22', '{\"nik\":\"36034569871010006\",\"nama\":\"Pandi waluyo prasetyo\",\"tempat_lahir\":\"Tangerang \",\"tgl_lahir\":\"05/03/1992\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Mati\",\"alamat\":\"Kampung Talaga\",\"rt\":\"001\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\",\"jenis_usaha\":\"Kelontong\",\"alamat_usaha\":\"fgf\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 16, 0, NULL, '2024-12-22 20:20:13', '', 1),
(22, 'SKU', '503/7/2003/SKU/XII/2024', 'Surat Keterangan Usaha', '2024-12-22', '{\"nik\":\"36034569871010006\",\"nama\":\"Pandi waluyo prasetyo\",\"tempat_lahir\":\"Tangerang \",\"tgl_lahir\":\"05/03/1992\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Mati\",\"alamat\":\"Kampung Talaga\",\"rt\":\"001\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\",\"jenis_usaha\":\"Service Komputer\",\"alamat_usaha\":\"asdasd\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 16, 0, NULL, '2024-12-22 20:21:59', '', 1),
(23, 'SKD', '470/7/2003/SKD/XII/2024', 'Surat Keterangan Domisili', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Pandi waluyo prasetyo\",\"tempat_lahir\":\"Tangerang \",\"tgl_lahir\":\"05/03/1992\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Mati\",\"alamat\":\"Kampung Talaga\",\"rt\":\"001\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 16, 0, NULL, '2024-12-22 20:26:01', '', 1),
(24, 'SKTM', '460/3/2003/SKTM/XII/2024', 'Surat Keterangan Tidak Mampu', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Ujang Rismanto Jaya\",\"tempat_lahir\":\"Ciamis\",\"tgl_lahir\":\"01/06/1945\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Kawin\",\"alamat\":\"Pajaten\",\"rt\":\"003\",\"rw\":\"007\",\"warga\":\"WNI\",\"pekerjaan\":\"Perawat/Dokter\",\"keperluan\":\"beasiswa sekolah\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 15, 0, NULL, '2024-12-22 20:36:56', 'Santoso', 1),
(25, 'SKTM', '460/4/2003/SKTM/XII/2024', 'Surat Keterangan Tidak Mampu', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Pandi waluyo prasetyo\",\"tempat_lahir\":\"Tangerang \",\"tgl_lahir\":\"05/03/1992\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Mati\",\"alamat\":\"Kampung Talaga\",\"rt\":\"001\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\",\"keperluan\":\"beasiswa\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 16, 0, NULL, '2024-12-22 20:37:21', '', 1),
(26, 'SKBPM', '474.2/2/2003/SKBPM/XII/2024', 'Surat Keterangan Belum Pernah Menikah', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Pandi waluyo prasetyo\",\"tempat_lahir\":\"Tangerang \",\"tgl_lahir\":\"05/03/1992\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Mati\",\"alamat\":\"Kampung Talaga\",\"rt\":\"001\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 16, 0, NULL, '2024-12-22 20:42:35', '', 1),
(29, 'SIK', '503/1/2003/SIK/XII/2024', 'Surat Izin Keramaian', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Pandi waluyo prasetyo\",\"tempat_lahir\":\"Tangerang \",\"tgl_lahir\":\"05/03/1992\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Mati\",\"alamat\":\"Kampung Talaga\",\"rt\":\"001\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\",\"tgl_mulai\":\"22/12/2024\",\"tgl_selesai\":\"24/12/2024\",\"acara\":\"Nikahan\",\"tempat_acara\":\"Depan rumah\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 16, 0, 1, '2024-12-22 21:07:09', '', 1);
-- --------------------------------------------------------
--
-- Table structure for table `tb_user`
--
CREATE TABLE `tb_user` (
`id` int(5) NOT NULL,
`id_pegawai` int(5) DEFAULT NULL,
`username` varchar(20) DEFAULT NULL,
`password` varchar(10) DEFAULT NULL,
`status_user` int(5) DEFAULT NULL,
`foto` varchar(100) DEFAULT NULL,
`role` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_user`
--
INSERT INTO `tb_user` (`id`, `id_pegawai`, `username`, `password`, `status_user`, `foto`, `role`) VALUES
(2, 4, 'admin', 'd033e22ae3', 1, '0.jfif', 'Admin'),
(11, 11, 'tatang', '9610c2dc65', 1, NULL, 'KepDes'),
(12, 14, 'mumun', '7c4a8d09ca', 0, NULL, 'Staff');
-- --------------------------------------------------------
--
-- Stand-in structure for view `v_data_penduduk`
-- (See below for the actual view)
--
CREATE TABLE `v_data_penduduk` (
`id` int(11)
,`no_kk` varchar(25)
,`no_nik` varchar(25)
,`nama_lengkap` varchar(120)
,`alamat_kampung` varchar(100)
,`rt` varchar(5)
,`rw` varchar(5)
,`jenis_kelamin` varchar(1)
,`tempat_lahir` varchar(100)
,`tanggal_lahir` date
,`agama` int(2)
,`pendidikan` int(2)
,`jenis_pekerjaan` int(2)
,`status_perkawinan` int(2)
,`kewarganegaraan` varchar(3)
,`nama_ayah` varchar(100)
,`nama_ibu` varchar(100)
,`keterangan` varchar(100)
,`createdby` varchar(20)
,`createdon` timestamp
,`modifiedon` timestamp
,`rowstatus` int(1)
,`agama_text` varchar(10)
,`pendidikan_text` varchar(30)
,`kawin_text` varchar(30)
,`kawin_singkat` varchar(2)
,`pekerjaan_text` varchar(30)
,`umur` int(5)
);
-- --------------------------------------------------------
--
-- Stand-in structure for view `v_stat_jenkel`
-- (See below for the actual view)
--
CREATE TABLE `v_stat_jenkel` (
`perempuan` decimal(23,0)
,`laki` decimal(23,0)
);
-- --------------------------------------------------------
--
-- Stand-in structure for view `v_stat_perkawinan`
-- (See below for the actual view)
--
CREATE TABLE `v_stat_perkawinan` (
`kawin` decimal(23,0)
,`tidak_kawin` decimal(23,0)
,`janda` decimal(23,0)
,`duda` decimal(23,0)
);
-- --------------------------------------------------------
--
-- Stand-in structure for view `v_stat_usia`
-- (See below for the actual view)
--
CREATE TABLE `v_stat_usia` (
`balita` decimal(23,0)
,`anak` decimal(23,0)
,`remaja` decimal(23,0)
,`dewasa` decimal(23,0)
,`lansia` decimal(23,0)
);
-- --------------------------------------------------------
--
-- Structure for view `v_data_penduduk`
--
DROP TABLE IF EXISTS `v_data_penduduk`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_data_penduduk` AS (select `a`.`id` AS `id`,`a`.`no_kk` AS `no_kk`,`a`.`no_nik` AS `no_nik`,`a`.`nama_lengkap` AS `nama_lengkap`,`a`.`alamat_kampung` AS `alamat_kampung`,`a`.`rt` AS `rt`,`a`.`rw` AS `rw`,`a`.`jenis_kelamin` AS `jenis_kelamin`,`a`.`tempat_lahir` AS `tempat_lahir`,`a`.`tanggal_lahir` AS `tanggal_lahir`,`a`.`agama` AS `agama`,`a`.`pendidikan` AS `pendidikan`,`a`.`jenis_pekerjaan` AS `jenis_pekerjaan`,`a`.`status_perkawinan` AS `status_perkawinan`,`a`.`tanggal_kawin` AS `tanggal_kawin`,`a`.`sdhk` AS `sdhk`,`a`.`kewarganegaraan` AS `kewarganegaraan`,`a`.`nama_ayah` AS `nama_ayah`,`a`.`nama_ibu` AS `nama_ibu`,`a`.`keterangan` AS `keterangan`,`a`.`gol_darah` AS `gol_darah`,`a`.`createdby` AS `createdby`,`a`.`createdon` AS `createdon`,`a`.`modifiedon` AS `modifiedon`,`a`.`rowstatus` AS `rowstatus`,`b`.`nama` AS `agama_text`,`c`.`nama` AS `pendidikan_text`,`e`.`nama` AS `kawin_text`,`e`.`singkat` AS `kawin_singkat`,`d`.`nama` AS `pekerjaan_text`,(year(now()) - year(`a`.`tanggal_lahir`)) AS `umur` from ((((`tb_data_penduduk` `a` left join `tb_agama` `b` on((`a`.`agama` = `b`.`id`))) left join `tb_pendidikan` `c` on((`c`.`id` = `a`.`pendidikan`))) left join `tb_pekerjaan` `d` on((`a`.`jenis_pekerjaan` = `d`.`id`))) left join `tb_kawin` `e` on((`e`.`id` = `a`.`status_perkawinan`))) where (`a`.`rowstatus` = 1) order by `a`.`id` desc) ;
-- --------------------------------------------------------
--
-- Structure for view `v_stat_jenkel`
--
DROP TABLE IF EXISTS `v_stat_jenkel`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_stat_jenkel` AS (select sum(if((`tb_data_penduduk`.`jenis_kelamin` = 'P'),1,0)) AS `perempuan`,sum(if((`tb_data_penduduk`.`jenis_kelamin` = 'L'),1,0)) AS `laki` from `tb_data_penduduk` where (`tb_data_penduduk`.`rowstatus` = 1)) ;
-- --------------------------------------------------------
--
-- Structure for view `v_stat_perkawinan`
--
DROP TABLE IF EXISTS `v_stat_perkawinan`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_stat_perkawinan` AS (select sum(if((`v_data_penduduk`.`kawin_singkat` = 'K'),1,0)) AS `kawin`,sum(if((`v_data_penduduk`.`kawin_singkat` = 'TK'),1,0)) AS `tidak_kawin`,sum(if(((`v_data_penduduk`.`kawin_singkat` = 'CH') or (`v_data_penduduk`.`kawin_singkat` = 'CM')),1,0)) AS `janda`,sum(if(((`v_data_penduduk`.`kawin_singkat` = 'CH') or (`v_data_penduduk`.`kawin_singkat` = 'CM')),1,0)) AS `duda` from `v_data_penduduk` where (`v_data_penduduk`.`rowstatus` = 1)) ;
-- --------------------------------------------------------
--
-- Structure for view `v_stat_usia`
--
DROP TABLE IF EXISTS `v_stat_usia`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_stat_usia` AS (select sum(if(((year(now()) - year(`tb_data_penduduk`.`tanggal_lahir`)) <= '5'),1,0)) AS `balita`,sum(if((((year(now()) - year(`tb_data_penduduk`.`tanggal_lahir`)) <= '10') and ((year(now()) - year(`tb_data_penduduk`.`tanggal_lahir`)) > '5')),1,0)) AS `anak`,sum(if((((year(now()) - year(`tb_data_penduduk`.`tanggal_lahir`)) <= '18') and ((year(now()) - year(`tb_data_penduduk`.`tanggal_lahir`)) > '10')),1,0)) AS `remaja`,sum(if((((year(now()) - year(`tb_data_penduduk`.`tanggal_lahir`)) <= '59') and ((year(now()) - year(`tb_data_penduduk`.`tanggal_lahir`)) > '18')),1,0)) AS `dewasa`,sum(if(((year(now()) - year(`tb_data_penduduk`.`tanggal_lahir`)) >= '60'),1,0)) AS `lansia` from `tb_data_penduduk` where (`tb_data_penduduk`.`rowstatus` = 1)) ;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `conf_sistem`
--
ALTER TABLE `conf_sistem`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_agama`
--
ALTER TABLE `tb_agama`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_arsip`
--
ALTER TABLE `tb_arsip`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_darah`
--
ALTER TABLE `tb_darah`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_data_penduduk`
--
ALTER TABLE `tb_data_penduduk`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_jabatan`
--
ALTER TABLE `tb_jabatan`
ADD PRIMARY KEY (`id_jabatan`);
--
-- Indexes for table `tb_jenis_usaha`
--
ALTER TABLE `tb_jenis_usaha`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_kawin`
--
ALTER TABLE `tb_kawin`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_menu_pkd`
--
ALTER TABLE `tb_menu_pkd`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_menu_surat`
--
ALTER TABLE `tb_menu_surat`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_pegawai`
--
ALTER TABLE `tb_pegawai`
ADD PRIMARY KEY (`id_pegawai`);
--
-- Indexes for table `tb_pekerjaan`
--
ALTER TABLE `tb_pekerjaan`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_pendidikan`
--
ALTER TABLE `tb_pendidikan`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_sdhk`
--
ALTER TABLE `tb_sdhk`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_surat`
--
ALTER TABLE `tb_surat`
ADD PRIMARY KEY (`id_surat`);
--
-- Indexes for table `tb_user`
--
ALTER TABLE `tb_user`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `conf_sistem`
--
ALTER TABLE `conf_sistem`
MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `tb_agama`
--
ALTER TABLE `tb_agama`
MODIFY `id` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `tb_arsip`
--
ALTER TABLE `tb_arsip`
MODIFY `id` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `tb_darah`
--
ALTER TABLE `tb_darah`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `tb_data_penduduk`
--
ALTER TABLE `tb_data_penduduk`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
--
-- AUTO_INCREMENT for table `tb_jabatan`
--
ALTER TABLE `tb_jabatan`
MODIFY `id_jabatan` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `tb_jenis_usaha`
--
ALTER TABLE `tb_jenis_usaha`
MODIFY `id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `tb_kawin`
--
ALTER TABLE `tb_kawin`
MODIFY `id` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `tb_menu_pkd`
--
ALTER TABLE `tb_menu_pkd`
MODIFY `id` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `tb_menu_surat`
--
ALTER TABLE `tb_menu_surat`
MODIFY `id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;
--
-- AUTO_INCREMENT for table `tb_pegawai`
--
ALTER TABLE `tb_pegawai`
MODIFY `id_pegawai` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
--
-- AUTO_INCREMENT for table `tb_pekerjaan`
--
ALTER TABLE `tb_pekerjaan`
MODIFY `id` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT for table `tb_pendidikan`
--
ALTER TABLE `tb_pendidikan`
MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT for table `tb_sdhk`
--
ALTER TABLE `tb_sdhk`
MODIFY `id` int(1) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `tb_surat`
--
ALTER TABLE `tb_surat`
MODIFY `id_surat` int(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;
--
-- AUTO_INCREMENT for table `tb_user`
--
ALTER TABLE `tb_user`
MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 01, 2025 at 10:29 AM
-- Server version: 10.1.38-MariaDB
-- PHP Version: 7.3.2
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `db-desa`
--
-- --------------------------------------------------------
--
-- Table structure for table `conf_sistem`
--
CREATE TABLE `conf_sistem` (
`id` int(5) NOT NULL,
`desc` varchar(20) DEFAULT NULL,
`content` text,
`jenis` int(1) DEFAULT NULL COMMENT '1 profile, 2 sistem',
`gambar` int(1) DEFAULT NULL COMMENT '1 = YA'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `conf_sistem`
--
INSERT INTO `conf_sistem` (`id`, `desc`, `content`, `jenis`, `gambar`) VALUES
(1, 'Judul', 'Layanan Terpadu', 2, NULL),
(2, 'Sub Judul', 'Desa Digital', 2, NULL),
(5, 'logo', '171224-075056-579854382.png', 1, 1),
(6, 'Singkatan ', 'DESA DIGITAL', 2, NULL),
(7, 'Nama Desa', 'Desa Digital', 1, NULL),
(8, 'Kabupaten', 'Kabupaten Pekalongan', 1, NULL),
(9, 'kop_1', 'PEMERINTAH KABUPATEN PEKALONGAN', 3, NULL),
(10, 'kop_2', 'KECAMATAN KEDUNGWUNI', 3, NULL),
(11, 'kop_3', 'DESA ROWOCACING', 3, NULL),
(12, 'Alamat Desa', 'Jl. Raya Desa Rowocacing No 1 RT. 007 RW. 004', 1, NULL),
(14, 'Kode Desa', '2003', 1, NULL),
(15, 'Gambar Depan', '', 2, 1),
(16, 'Kecamatan', 'Kecamatan Kedungwuni', 1, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `tb_agama`
--
CREATE TABLE `tb_agama` (
`id` int(2) NOT NULL,
`nama` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_agama`
--
INSERT INTO `tb_agama` (`id`, `nama`) VALUES
(1, 'Islam'),
(2, 'Kristen'),
(3, 'Protestan'),
(4, 'Katolik'),
(5, 'Hindu'),
(6, 'Buddha'),
(7, 'Konghucu');
-- --------------------------------------------------------
--
-- Table structure for table `tb_arsip`
--
CREATE TABLE `tb_arsip` (
`id` int(4) NOT NULL,
`nomor_kk` varchar(25) NOT NULL,
`foto` text NOT NULL,
`upload` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_arsip`
--
INSERT INTO `tb_arsip` (`id`, `nomor_kk`, `foto`, `upload`) VALUES
(1, '3207225469860002', '291224-080709-111759487.pdf', '2024-12-29 01:07:09');
-- --------------------------------------------------------
--
-- Table structure for table `tb_darah`
--
CREATE TABLE `tb_darah` (
`id` int(11) NOT NULL,
`darah` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_darah`
--
INSERT INTO `tb_darah` (`id`, `darah`) VALUES
(1, 'Tidak Tahu'),
(2, 'A'),
(3, 'AB'),
(4, 'B'),
(5, 'O');
-- --------------------------------------------------------
--
-- Table structure for table `tb_data_penduduk`
--
CREATE TABLE `tb_data_penduduk` (
`id` int(11) NOT NULL,
`no_kk` varchar(25) DEFAULT NULL,
`no_nik` varchar(25) DEFAULT NULL,
`nama_lengkap` varchar(120) DEFAULT NULL,
`alamat_kampung` varchar(100) DEFAULT NULL,
`rt` varchar(5) DEFAULT NULL,
`rw` varchar(5) DEFAULT NULL,
`jenis_kelamin` varchar(1) DEFAULT NULL,
`tempat_lahir` varchar(100) DEFAULT NULL,
`tanggal_lahir` date DEFAULT NULL,
`agama` int(2) DEFAULT NULL,
`pendidikan` int(2) DEFAULT NULL,
`jenis_pekerjaan` int(2) DEFAULT NULL,
`status_perkawinan` int(2) DEFAULT NULL,
`tanggal_kawin` date NOT NULL,
`sdhk` int(1) NOT NULL,
`kewarganegaraan` varchar(3) DEFAULT NULL,
`no_paspor` varchar(20) NOT NULL,
`no_kitap` varchar(20) NOT NULL,
`nama_ayah` varchar(100) DEFAULT NULL,
`nama_ibu` varchar(100) DEFAULT NULL,
`gol_darah` varchar(15) NOT NULL,
`mutasi` varchar(20) NOT NULL,
`keterangan` varchar(100) DEFAULT NULL,
`createdby` varchar(20) DEFAULT NULL,
`createdon` timestamp NULL DEFAULT NULL,
`modifiedon` timestamp NULL DEFAULT NULL,
`rowstatus` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_data_penduduk`
--
INSERT INTO `tb_data_penduduk` (`id`, `no_kk`, `no_nik`, `nama_lengkap`, `alamat_kampung`, `rt`, `rw`, `jenis_kelamin`, `tempat_lahir`, `tanggal_lahir`, `agama`, `pendidikan`, `jenis_pekerjaan`, `status_perkawinan`, `tanggal_kawin`, `sdhk`, `kewarganegaraan`, `no_paspor`, `no_kitap`, `nama_ayah`, `nama_ibu`, `gol_darah`, `mutasi`, `keterangan`, `createdby`, `createdon`, `modifiedon`, `rowstatus`) VALUES
(15, '3207225469860002', '32072326799100204', 'Ujang Rismanto Jaya', 'Pajaten', '003', '007', 'L', 'Ciamis', '1945-06-01', 1, 13, 6, 2, '0000-00-00', 0, 'WNI', '', '', 'Suyamta', 'Nurjanah', '', '-', '-', 'Aldy Setiawan', '2020-10-23 16:33:50', '2024-12-20 06:41:11', 1),
(16, '3207225469860002', '36034569871010006', 'Pandi waluyo prasetyo', 'Kampung Talaga', '001', '002', 'L', 'Tangerang ', '1992-03-05', 1, 13, 6, 4, '0000-00-00', 0, 'WNI', '', '', 'Supriyanto', 'Sarmanah', '', '-', '-', 'Aldy Setiawan', '2020-10-23 16:33:50', '2024-12-18 09:12:28', 1),
(17, '3329185246160007', '33293154978600021', 'ADITYA YULI NUGRAHA', 'Cikakak', '013', '002', 'L', 'Cilacap', '1997-06-28', 1, 11, 6, 3, '0000-00-00', 0, 'WNI', '', '', 'Nopriansyah', 'Helena', '', '', '-', 'Aldy Setiawan', '2020-10-23 16:33:50', NULL, 1),
(18, '3329185246160007', '37895212708190013', 'Imas saribanon', 'kadongdong', '003', '003', 'P', 'Sukabumi ', '1985-09-17', 1, 13, 6, 2, '0000-00-00', 0, 'WNI', '', '', 'Moh hanafi', 'Handayani', '', '-', '-', 'Aldy Setiawan', '2020-10-23 16:33:50', '2024-12-17 13:17:47', 1),
(19, '9878140205950004', '36730127484160013', 'Muslih alqusairi', 'Nanggerang', '001', '006', 'L', 'Pandeglang', '2008-06-28', 2, 13, 6, 1, '0000-00-00', 0, 'WNA', '', '', 'HAKIKI', 'Rodiyah', '', '', '-', 'Aldy Setiawan', '2020-10-23 16:33:50', '2024-12-18 08:32:38', 1),
(20, '3207225469860002', '18011402059500014', 'Mas hadiyan', 'Kampung Cipeteuy', '06', '01', 'L', 'Pandeglang', '2015-08-14', 1, 13, 1, 2, '0000-00-00', 0, 'WNI', '', '', 'Sanjaya', 'Suba', '', 'Pisah KK', '', 'Aldy Setiawan', '2020-10-30 03:57:47', '2024-12-18 12:13:47', 0),
(21, '9878140205950004', '1234567891011', 'Adnan Mubarok', 'Ciujung', '001', '003', 'L', 'Serang', '2023-08-09', 1, 13, 3, 1, '0000-00-00', 0, 'WNI', '', '', 'Joko Kendil', 'Kendil Joko', '', 'Meninggal', 'tanggal 12 des 2024', 'Mumun Munjiah', '2022-10-23 06:50:48', '2024-12-18 12:28:01', 0),
(22, '3207225469860010', '18011402059500014', 'Mas hadiyan', 'proto', '003', '001', 'L', 'Pekalongan', '2000-03-14', 1, 6, 2, 2, '0000-00-00', 0, 'WNI', '', '', 'suketman', 'suketi', '', '', '', 'Santoso', '2024-12-20 08:46:39', NULL, 1),
(23, '216843168434684', '687632468435168', 'Azlan Zavier', 'Kampung Cipeteuy', '003', '001', 'L', 'Pekalongan', '2021-10-14', 1, 2, 1, 1, '0000-00-00', 4, 'WNI', '', '', 'Anton', 'Medan', '3', '', '', 'Santoso', '2024-12-25 03:37:34', '2024-12-29 03:17:34', 1),
(24, '57758778578', '76858758758', 'altaf', 'Kampung Cipeteuy', '06', '01', 'L', 'pekalongan', '2024-12-29', 1, 1, 1, 1, '0000-00-00', 4, 'WNI', '', '', 'asdasd', 'asdasda', '2', '', '', 'Santoso', '2024-12-29 02:56:29', '2024-12-29 03:17:45', 1);
-- --------------------------------------------------------
--
-- Table structure for table `tb_jabatan`
--
CREATE TABLE `tb_jabatan` (
`id_jabatan` int(3) NOT NULL,
`id_sub` int(2) DEFAULT NULL,
`nama` varchar(50) DEFAULT NULL,
`warna` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_jabatan`
--
INSERT INTO `tb_jabatan` (`id_jabatan`, `id_sub`, `nama`, `warna`) VALUES
(1, 0, 'Kepala Desa', 'oren'),
(3, 1, 'Sekretaris Desa', 'biru'),
(4, 3, 'Kaur TU & Umum', 'hijau'),
(5, 3, 'Kaur Keuangan', 'hijau'),
(6, 3, 'Kaur Perencanaan', 'hijau'),
(7, 1, 'Kasi Pemerintahan', 'biru'),
(8, 1, 'Kasi Kesejahteraan', 'biru'),
(9, 1, 'Kasi Pelayanan', 'biru'),
(10, 7, 'Staff Pemerintahan', 'magenta'),
(11, 8, 'Staff Kesejahteraan', 'magenta'),
(12, 9, 'Staff Pelayanan', 'magenta'),
(13, 4, 'Staff TU & Umum', 'magenta'),
(14, 5, 'Staff Keuangan', 'magenta'),
(15, 6, 'Staff Honorer', 'ungu');
-- --------------------------------------------------------
--
-- Table structure for table `tb_jenis_usaha`
--
CREATE TABLE `tb_jenis_usaha` (
`id` int(3) NOT NULL,
`nama` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_jenis_usaha`
--
INSERT INTO `tb_jenis_usaha` (`id`, `nama`) VALUES
(1, 'ATK dan Fotocopy'),
(2, 'Bengkel Mobil'),
(3, 'Bengkel Motor'),
(4, 'Bensin Eceran'),
(5, 'Kelontong'),
(6, 'Perdagangan'),
(7, 'Service Komputer'),
(8, 'Service TV'),
(9, 'Warung Sembako');
-- --------------------------------------------------------
--
-- Table structure for table `tb_kawin`
--
CREATE TABLE `tb_kawin` (
`id` int(2) NOT NULL,
`nama` varchar(30) DEFAULT NULL,
`singkat` varchar(2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_kawin`
--
INSERT INTO `tb_kawin` (`id`, `nama`, `singkat`) VALUES
(1, 'Tidak Kawin', 'TK'),
(2, 'Kawin', 'K'),
(3, 'Cerai Hidup', 'CH'),
(4, 'Cerai Mati', 'CM');
-- --------------------------------------------------------
--
-- Table structure for table `tb_menu_pkd`
--
CREATE TABLE `tb_menu_pkd` (
`id` int(2) NOT NULL,
`nama_pkd` varchar(50) NOT NULL,
`url` varchar(30) NOT NULL,
`icon` varchar(20) NOT NULL,
`code` varchar(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_menu_pkd`
--
INSERT INTO `tb_menu_pkd` (`id`, `nama_pkd`, `url`, `icon`, `code`) VALUES
(1, 'Posyandu 1', '?page=posyandu1', 'fas fa-hospital', '1'),
(2, 'Posyandu 2', '?page=posyandu2', 'fas fa-hospital', '1'),
(3, 'Posyandu 3', '?page=posyandu3', 'fas fa-hospital', '1');
-- --------------------------------------------------------
--
-- Table structure for table `tb_menu_surat`
--
CREATE TABLE `tb_menu_surat` (
`id` int(3) NOT NULL,
`nama_menu` varchar(50) DEFAULT NULL,
`url` varchar(30) DEFAULT NULL,
`icon` varchar(20) DEFAULT NULL,
`kode` varchar(5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_menu_surat`
--
INSERT INTO `tb_menu_surat` (`id`, `nama_menu`, `url`, `icon`, `kode`) VALUES
(1, 'Surat Keterangan Usaha', '?page=sku', 'fas fa-envelope', '503'),
(2, 'Surat Keterangan Domisili', '?page=domisili', 'fas fa-envelope', '470'),
(3, 'Surat Keterangan Domisili Usaha', '?page=domisili_usaha', 'fas fa-envelope', NULL),
(4, 'Surat Keterangan Domisili Yayasan', '?page=domisili_yayasan', 'fas fa-envelope', NULL),
(5, 'Surat Keterangan Tidak Mampu', '?page=tidak_mampu', 'fas fa-envelope', '460'),
(6, 'Surat Keterangan Emergency', '?page=emergency', 'fas fa-envelope', NULL),
(7, 'Surat Keterangan Pindah', '?page=pindah', 'fas fa-envelope', NULL),
(8, 'Surat Keterangan KTP Sementara', '?page=ktp_sementara', 'fas fa-envelope', NULL),
(9, 'Surat Keterangan Beda Nama KTP/KK', '?page=beda_nama', 'fas fa-envelope', NULL),
(10, 'Surat Keterangan Numpang Nikah', '?page=numpang_nikah', 'fas fa-envelope', NULL),
(11, 'Surat Keterangan Nikah Secara Agama', '?page=nikah_agama', 'fas fa-envelope', NULL),
(12, 'Surat Keterangan Menikah', '?page=menikah', 'fas fa-envelope', NULL),
(13, 'Surat Keterangan Belum Pernah Menikah', '?page=belum_menikah', 'fas fa-envelope', '474.2'),
(15, 'Surat Keterangan Kelahiran', '?page=kelahiran', 'fas fa-envelope', NULL),
(16, 'Surat Keterangan Akte Kelahiran Sementara', '?page=akte_kelahiran', 'fas fa-envelope', NULL),
(17, 'Surat Keterangan Kematian', '?page=kematian', 'fas fa-envelope', NULL),
(18, 'Surat Keterangan Ahli Waris', '?page=waris', 'fas fa-envelope', NULL),
(19, 'Surat Keterangan Pemakaman', '?page=pemakaman', 'fas fa-envelope', '474.3'),
(20, 'Surat Keterangan Duda/Janda', '?page=duda_janda', 'fas fa-envelope', NULL),
(21, 'Surat Keterangan Jual Sanda/Gadai', '?page=jual_gadai', 'fas fa-envelope', NULL),
(22, 'Surat Keterangan Belum Memiliki Rumah', '?page=belum_memiliki_rumah', 'fas fa-envelope', NULL),
(23, 'Surat Keterangan KWH Listrik An. Orang Lain', '?page=kwh_listrik', 'fas fa-envelope', NULL),
(24, 'Surat Keterangan Penghasilan Untuk Pend.', '?page=penghasilan_pendidikan', 'fas fa-envelope', NULL),
(25, 'Surat Keterangan Penghasilan', '?page=penghasilan', 'fas fa-envelope', NULL),
(26, 'Surat Keterangan Laporan Kehilangan', '?page=laporan_kehilangan', 'fas fa-envelope', NULL),
(27, 'Surat Pengantar SKCK', '?page=skck', 'fas fa-envelope', '331'),
(28, 'Surat Izin Keramaian', '?page=izin_keramaian', 'fas fa-envelope', '503');
-- --------------------------------------------------------
--
-- Table structure for table `tb_pegawai`
--
CREATE TABLE `tb_pegawai` (
`id_pegawai` int(5) NOT NULL,
`nip` varchar(20) DEFAULT NULL,
`jabatan` varchar(20) DEFAULT NULL,
`nama_pegawai` varchar(30) DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
`no_hp` varchar(20) DEFAULT NULL,
`alamat` varchar(30) DEFAULT NULL,
`tempat_lahir` varchar(30) DEFAULT NULL,
`tanggal_lahir` date DEFAULT NULL,
`jenkel` enum('Pria','Wanita','','') DEFAULT NULL,
`aktif` int(1) DEFAULT NULL,
`createdon` date DEFAULT NULL,
`createdby` varchar(20) DEFAULT NULL,
`rowstatus` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_pegawai`
--
INSERT INTO `tb_pegawai` (`id_pegawai`, `nip`, `jabatan`, `nama_pegawai`, `email`, `no_hp`, `alamat`, `tempat_lahir`, `tanggal_lahir`, `jenkel`, `aktif`, `createdon`, `createdby`, `rowstatus`) VALUES
(4, '5874369', '1', 'Santoso', 'aldysetiaa@gmail.com', '085216479907', 'Menes Pandeglang', 'Pandeglang', '1996-05-15', 'Pria', 1, NULL, NULL, 1),
(11, '8575126', '3', 'Tatang Sutardi', 'aldysetiaa@gmail.com', '085216479907', 'Menes Pandeglang', 'Pandeglang', '1996-11-06', 'Pria', 1, NULL, NULL, 1),
(14, '5959412', '4', 'Mumun Munjiah', 'mumun.mnj@gmail.com', '085151548623', 'Jakarta Barat', 'Jakarta', '1995-08-01', '', 1, '2022-10-22', 'Aldy Setiawan', 1),
(15, '2846548', '5', 'Siti Munjayanah', 'munjayanah@gmail.com', '081258415452', 'Pandeglang', 'Pandeglang', '1996-12-17', NULL, 1, NULL, NULL, 1),
(16, '5455157', '6', ' Ade lili Nuryani', 'lili.nuryani@gmail.com', '085715462323', 'Pandeglang', 'Pandeglang', '1996-08-22', NULL, 1, NULL, NULL, 1),
(17, '5445454', '7', 'Ratu Tatu Rodiyah', 'tatu.r@gmail.com', '083815451545', 'Pandeglang', 'Pandeglang', '1997-04-15', NULL, 1, NULL, NULL, 1),
(18, '4856184', '8', 'Yongki hartoni', 'yongki@gmail.com', '085854855215', 'Pandeglang', 'Pandeglang', '1996-09-11', NULL, 1, NULL, NULL, 1),
(19, '1587989', '9', 'Erdaleni', 'erd@gmail.com', '085218795665', 'Pandeglang', 'Pandeglang', '1997-06-28', NULL, 1, NULL, NULL, 1),
(20, '2187485', '10', 'Yuli Yana', 'yuli@gmail.com', '089258484652', 'Pandeglang', 'Pandeglang', '1996-09-12', NULL, 1, NULL, NULL, 1),
(21, '4854551', '11', 'Siti Nur Wakhidah', 'wakhidahlia@gmail.com', '085451548712', 'Pandeglang', 'Pandeglang', '1997-06-28', 'Wanita', 1, NULL, NULL, 1),
(22, '2184841', '12', ' Ade sopian', 'sopian.ade@yahoo.com', '083841515485', 'Pandeglang', 'Pandeglang', '1997-06-17', NULL, 1, NULL, NULL, 1),
(23, '8542369', '15', 'RISHA OKTAVIYANI', 'rishaoktaviyani@gmail.com', '085465874626', 'Serang', 'Serang', '0000-00-00', 'Wanita', 1, '2022-10-22', 'Aldy Setiawan', 1);
-- --------------------------------------------------------
--
-- Table structure for table `tb_pekerjaan`
--
CREATE TABLE `tb_pekerjaan` (
`id` int(2) NOT NULL,
`nama` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_pekerjaan`
--
INSERT INTO `tb_pekerjaan` (`id`, `nama`) VALUES
(1, 'Belum/Tidak Bekerja'),
(2, 'Buruh Tani'),
(3, 'Dagang'),
(4, 'Guru'),
(5, 'Guru Agama'),
(6, 'Karyawan Swasta'),
(7, 'Mengurus Rumah Tangga'),
(8, 'Paraji'),
(9, 'Pensiunan'),
(10, 'Petani/Peternak'),
(11, 'PNS/TNI/Polri'),
(12, 'Pegawai BUMN'),
(13, 'Honorer'),
(14, 'Sopir'),
(15, 'Tukang Kayu'),
(16, 'Wiraswasta'),
(17, 'Bidan'),
(18, 'Perawat/Dokter'),
(19, 'Buruh Bangunan');
-- --------------------------------------------------------
--
-- Table structure for table `tb_pendidikan`
--
CREATE TABLE `tb_pendidikan` (
`id` int(5) NOT NULL,
`nama` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_pendidikan`
--
INSERT INTO `tb_pendidikan` (`id`, `nama`) VALUES
(1, 'Belum/Tidak Sekolah'),
(2, 'PAUD'),
(3, 'TK'),
(4, 'MI/SD'),
(5, 'SMP/MTs/SLTP'),
(6, 'SMA/SMK/SLTA'),
(7, 'Diploma I (D1)'),
(8, 'Diploma II (D2)'),
(9, 'Diploma III (D3)'),
(10, 'Diploma IV (D4)'),
(11, 'Strata I (S1)'),
(12, 'Strata II (S2)'),
(13, 'Strata III (S3)');
-- --------------------------------------------------------
--
-- Table structure for table `tb_sdhk`
--
CREATE TABLE `tb_sdhk` (
`id` int(1) NOT NULL,
`nama` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_sdhk`
--
INSERT INTO `tb_sdhk` (`id`, `nama`) VALUES
(1, 'Kepala Keluarga'),
(2, 'Suami'),
(3, 'Istri'),
(4, 'Anak'),
(5, 'Menantu'),
(6, 'Orang Tua'),
(7, 'Mertua'),
(8, 'Mertua'),
(9, 'Pembantu'),
(10, 'Famili Lain');
-- --------------------------------------------------------
--
-- Table structure for table `tb_surat`
--
CREATE TABLE `tb_surat` (
`id_surat` int(8) NOT NULL,
`jenis_surat` varchar(20) NOT NULL,
`no_surat` varchar(50) NOT NULL,
`nama_surat` varchar(100) NOT NULL,
`tanggal` date DEFAULT NULL,
`isi_surat` text,
`tanda_tangan` text NOT NULL,
`id_warga` int(5) NOT NULL,
`jenis_warga` int(2) NOT NULL,
`arsip` int(1) DEFAULT NULL,
`createdon` datetime DEFAULT NULL,
`createdby` varchar(20) DEFAULT NULL,
`rowstatus` int(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_surat`
--
INSERT INTO `tb_surat` (`id_surat`, `jenis_surat`, `no_surat`, `nama_surat`, `tanggal`, `isi_surat`, `tanda_tangan`, `id_warga`, `jenis_warga`, `arsip`, `createdon`, `createdby`, `rowstatus`) VALUES
(1, 'SKU', '503/1/2003/SKU/XII/2024', 'Surat Keterangan Usaha', '2024-12-22', '{\"nik\":\"32072326799100204\",\"nama\":\"Ujang Rismanto Jaya\",\"tempat_lahir\":\"Ciamis\",\"tgl_lahir\":\"01/06/1945\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Kawin\",\"alamat\":\"Pajaten\",\"rt\":\"003\",\"rw\":\"007\",\"warga\":\"WNI\",\"pekerjaan\":null,\"jenis_usaha\":\"Service TV\",\"alamat_usaha\":\"Rowocacing\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 15, 1, NULL, '2024-12-22 19:34:02', 'Santoso', 1),
(12, 'SKD', '470/2/2003/SKD/XII/2024', 'Surat Keterangan Domisili', '2024-12-22', '{\"nik\":\"32072326799100204\",\"nama\":\"Ujang Rismanto Jaya\",\"tempat_lahir\":\"Ciamis\",\"tgl_lahir\":\"01/06/1945\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Kawin\",\"alamat\":\"Pajaten\",\"rt\":\"003\",\"rw\":\"007\",\"warga\":\"WNI\",\"pekerjaan\":\"Dagang\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 15, 0, NULL, '2024-12-22 19:55:32', 'Santoso', 1),
(10, 'SKU', '503/2/2003/SKU/XII/2024', 'Surat Keterangan Usaha', '2024-12-22', '{\"nik\":\"32072326799100204\",\"nama\":\"Ujang Rismanto Jaya\",\"tempat_lahir\":\"Ciamis\",\"tgl_lahir\":\"01/06/1945\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Kawin\",\"alamat\":\"Pajaten\",\"rt\":\"003\",\"rw\":\"007\",\"warga\":\"WNI\",\"pekerjaan\":null,\"jenis_usaha\":\"Service TV\",\"alamat_usaha\":\"ghfgh\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 15, 1, 1, '2024-12-22 19:48:16', '', 1),
(28, 'SKKB', '331/1/2003/SKKB/XII/2024', 'Surat Keterangan Kelakuan Baik', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Pandi waluyo prasetyo\",\"tempat_lahir\":\"Tangerang \",\"tgl_lahir\":\"05/03/1992\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Mati\",\"alamat\":\"Kampung Talaga\",\"rt\":\"001\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\",\"keperluan\":\"melamar kerja\",\"kelakuan\":\"1. Berkelakuan Baik \r\n2. Tidak termasuk pecandu narkotika dan minuman keras \r\n3. Tidak pernah terlibat dalam pidana maupun perdata \"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 16, 0, NULL, '2024-12-22 21:03:42', '', 1),
(5, 'SKTM', '460/1/2003/SKTM/XII/2024', 'Surat Keterangan Tidak Mampu', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Ujang Rismanto Jaya\",\"tempat_lahir\":\"Ciamis\",\"tgl_lahir\":\"01/06/1945\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Kawin\",\"alamat\":\"Pajaten\",\"rt\":\"003\",\"rw\":\"007\",\"warga\":\"WNI\",\"pekerjaan\":null,\"keperluan\":\"beasiswa sekolah\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 15, 0, NULL, '2024-12-22 19:38:33', 'Santoso', 1),
(6, 'SKBPM', '474.2/1/2003/SKBPM/XII/2024', 'Surat Keterangan Belum Pernah Menikah', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Ujang Rismanto Jaya\",\"tempat_lahir\":\"Ciamis\",\"tgl_lahir\":\"01/06/1945\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Kawin\",\"alamat\":\"Pajaten\",\"rt\":\"003\",\"rw\":\"007\",\"warga\":\"WNI\",\"pekerjaan\":null}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 15, 0, NULL, '2024-12-22 19:39:09', 'Santoso', 1),
(7, 'SKP', '474.3/1/2003/SKP/XII/2024', 'Surat Keterangan Pemakaman', '2024-12-22', '{\"nik\":\"32072326799100204\",\"nama\":\"Ujang Rismanto Jaya\",\"tempat_lahir\":\"Ciamis\",\"tgl_lahir\":\"01/06/1945\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Kawin\",\"alamat\":\"Pajaten\",\"rt\":\"003\",\"rw\":\"007\",\"warga\":\"WNI\",\"pekerjaan\":null,\"tgl_kematian\":\"22/12/2024\",\"tgl_pemakaman\":\"22/12/2024\",\"jam_pemakaman\":\"19:12\",\"tempat_pemakaman\":\"Proto\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 15, 0, NULL, '2024-12-22 19:39:51', 'Santoso', 1),
(8, 'SKTM', '460/2/2003/SKTM/XII/2024', 'Surat Keterangan Tidak Mampu', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Ujang Rismanto Jaya\",\"tempat_lahir\":\"Ciamis\",\"tgl_lahir\":\"01/06/1945\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Kawin\",\"alamat\":\"Pajaten\",\"rt\":\"003\",\"rw\":\"007\",\"warga\":\"WNI\",\"pekerjaan\":null,\"keperluan\":\"beasiswa\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 15, 0, NULL, '2024-12-22 19:43:32', '', 1),
(27, 'SKP', '474.3/2/2003/SKP/XII/2024', 'Surat Keterangan Pemakaman', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Pandi waluyo prasetyo\",\"tempat_lahir\":\"Tangerang \",\"tgl_lahir\":\"05/03/1992\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Mati\",\"alamat\":\"Kampung Talaga\",\"rt\":\"001\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\",\"tgl_kematian\":\"22/12/2024\",\"tgl_pemakaman\":\"22/12/2024\",\"jam_pemakaman\":\"20:12\",\"tempat_pemakaman\":\"ad\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 16, 0, NULL, '2024-12-22 20:58:22', '', 1),
(14, 'SKD', '470/3/2003/SKD/XII/2024', 'Surat Keterangan Domisili', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Ujang Rismanto Jaya\",\"tempat_lahir\":\"Ciamis\",\"tgl_lahir\":\"01/06/1945\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Kawin\",\"alamat\":\"Pajaten\",\"rt\":\"003\",\"rw\":\"007\",\"warga\":\"WNI\",\"pekerjaan\":null}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 15, 0, NULL, '2024-12-22 19:59:34', '', 1),
(15, 'SKD', '470/4/2003/SKD/XII/2024', 'Surat Keterangan Domisili', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Ujang Rismanto Jaya\",\"tempat_lahir\":\"Ciamis\",\"tgl_lahir\":\"01/06/1945\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Kawin\",\"alamat\":\"Pajaten\",\"rt\":\"003\",\"rw\":\"007\",\"warga\":\"WNI\",\"pekerjaan\":null}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 15, 0, NULL, '2024-12-22 20:01:27', '', 1),
(16, 'SKU', '503/3/2003/SKU/XII/2024', 'Surat Keterangan Usaha', '2024-12-22', '{\"nik\":\"32072326799100204\",\"nama\":\"Ujang Rismanto Jaya\",\"tempat_lahir\":\"Ciamis\",\"tgl_lahir\":\"01/06/1945\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Kawin\",\"alamat\":\"Pajaten\",\"rt\":\"003\",\"rw\":\"007\",\"warga\":\"WNI\",\"pekerjaan\":\"Pensiunan\",\"jenis_usaha\":\"Kelontong\",\"alamat_usaha\":\"rowocacing\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 15, 0, NULL, '2024-12-22 20:03:04', '', 1),
(17, 'SKD', '470/5/2003/SKD/XII/2024', 'Surat Keterangan Domisili', '2024-12-22', '{\"nik\":\"33293154978600021\",\"nama\":\"ADITYA YULI NUGRAHA\",\"tempat_lahir\":\"Cilacap\",\"tgl_lahir\":\"28/06/1997\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Hidup\",\"alamat\":\"Cikakak\",\"rt\":\"013\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 17, 0, NULL, '2024-12-22 20:04:29', 'Santoso', 1),
(18, 'SKD', '470/6/2003/SKD/XII/2024', 'Surat Keterangan Domisili', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Pandi waluyo prasetyo\",\"tempat_lahir\":\"Tangerang \",\"tgl_lahir\":\"05/03/1992\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Mati\",\"alamat\":\"Kampung Talaga\",\"rt\":\"001\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 16, 0, NULL, '2024-12-22 20:12:54', '', 1),
(19, 'SKU', '503/4/2003/SKU/XII/2024', 'Surat Keterangan Usaha', '2024-12-22', '{\"nik\":\"36034569871010006\",\"nama\":\"Pandi waluyo prasetyo\",\"tempat_lahir\":\"Tangerang \",\"tgl_lahir\":\"05/03/1992\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Mati\",\"alamat\":\"Kampung Talaga\",\"rt\":\"001\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\",\"jenis_usaha\":\"Bengkel Mobil\",\"alamat_usaha\":\"rowocacing\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 16, 0, NULL, '2024-12-22 20:17:17', '', 1),
(20, 'SKU', '503/5/2003/SKU/XII/2024', 'Surat Keterangan Usaha', '2024-12-22', '{\"nik\":\"36034569871010006\",\"nama\":\"Pandi waluyo prasetyo\",\"tempat_lahir\":\"Tangerang \",\"tgl_lahir\":\"05/03/1992\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Mati\",\"alamat\":\"Kampung Talaga\",\"rt\":\"001\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\",\"jenis_usaha\":\"Kelontong\",\"alamat_usaha\":\"ffg\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 16, 0, NULL, '2024-12-22 20:18:39', '', 1),
(21, 'SKU', '503/6/2003/SKU/XII/2024', 'Surat Keterangan Usaha', '2024-12-22', '{\"nik\":\"36034569871010006\",\"nama\":\"Pandi waluyo prasetyo\",\"tempat_lahir\":\"Tangerang \",\"tgl_lahir\":\"05/03/1992\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Mati\",\"alamat\":\"Kampung Talaga\",\"rt\":\"001\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\",\"jenis_usaha\":\"Kelontong\",\"alamat_usaha\":\"fgf\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 16, 0, NULL, '2024-12-22 20:20:13', '', 1),
(22, 'SKU', '503/7/2003/SKU/XII/2024', 'Surat Keterangan Usaha', '2024-12-22', '{\"nik\":\"36034569871010006\",\"nama\":\"Pandi waluyo prasetyo\",\"tempat_lahir\":\"Tangerang \",\"tgl_lahir\":\"05/03/1992\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Mati\",\"alamat\":\"Kampung Talaga\",\"rt\":\"001\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\",\"jenis_usaha\":\"Service Komputer\",\"alamat_usaha\":\"asdasd\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 16, 0, NULL, '2024-12-22 20:21:59', '', 1),
(23, 'SKD', '470/7/2003/SKD/XII/2024', 'Surat Keterangan Domisili', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Pandi waluyo prasetyo\",\"tempat_lahir\":\"Tangerang \",\"tgl_lahir\":\"05/03/1992\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Mati\",\"alamat\":\"Kampung Talaga\",\"rt\":\"001\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 16, 0, NULL, '2024-12-22 20:26:01', '', 1),
(24, 'SKTM', '460/3/2003/SKTM/XII/2024', 'Surat Keterangan Tidak Mampu', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Ujang Rismanto Jaya\",\"tempat_lahir\":\"Ciamis\",\"tgl_lahir\":\"01/06/1945\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Kawin\",\"alamat\":\"Pajaten\",\"rt\":\"003\",\"rw\":\"007\",\"warga\":\"WNI\",\"pekerjaan\":\"Perawat/Dokter\",\"keperluan\":\"beasiswa sekolah\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 15, 0, NULL, '2024-12-22 20:36:56', 'Santoso', 1),
(25, 'SKTM', '460/4/2003/SKTM/XII/2024', 'Surat Keterangan Tidak Mampu', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Pandi waluyo prasetyo\",\"tempat_lahir\":\"Tangerang \",\"tgl_lahir\":\"05/03/1992\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Mati\",\"alamat\":\"Kampung Talaga\",\"rt\":\"001\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\",\"keperluan\":\"beasiswa\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 16, 0, NULL, '2024-12-22 20:37:21', '', 1),
(26, 'SKBPM', '474.2/2/2003/SKBPM/XII/2024', 'Surat Keterangan Belum Pernah Menikah', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Pandi waluyo prasetyo\",\"tempat_lahir\":\"Tangerang \",\"tgl_lahir\":\"05/03/1992\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Mati\",\"alamat\":\"Kampung Talaga\",\"rt\":\"001\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 16, 0, NULL, '2024-12-22 20:42:35', '', 1),
(29, 'SIK', '503/1/2003/SIK/XII/2024', 'Surat Izin Keramaian', '2024-12-22', '{\"nik\":\"3207225469860002\",\"nama\":\"Pandi waluyo prasetyo\",\"tempat_lahir\":\"Tangerang \",\"tgl_lahir\":\"05/03/1992\",\"jenis_kelamin\":\"Laki-laki\",\"agama\":\"Islam\",\"perkawinan\":\"Cerai Mati\",\"alamat\":\"Kampung Talaga\",\"rt\":\"001\",\"rw\":\"002\",\"warga\":\"WNI\",\"pekerjaan\":\"Karyawan Swasta\",\"tgl_mulai\":\"22/12/2024\",\"tgl_selesai\":\"24/12/2024\",\"acara\":\"Nikahan\",\"tempat_acara\":\"Depan rumah\"}', '{\"nama\":\"Santoso\",\"nip\":\"5874369\",\"jabatan\":\"KEPALA DESA\",\"wakilkan\":0,\"head\":\"KEPALA DESA ROWOCACING\",\"id_jabatan\":\"1\"}', 16, 0, 1, '2024-12-22 21:07:09', '', 1);
-- --------------------------------------------------------
--
-- Table structure for table `tb_user`
--
CREATE TABLE `tb_user` (
`id` int(5) NOT NULL,
`id_pegawai` int(5) DEFAULT NULL,
`username` varchar(20) DEFAULT NULL,
`password` varchar(10) DEFAULT NULL,
`status_user` int(5) DEFAULT NULL,
`foto` varchar(100) DEFAULT NULL,
`role` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tb_user`
--
INSERT INTO `tb_user` (`id`, `id_pegawai`, `username`, `password`, `status_user`, `foto`, `role`) VALUES
(2, 4, 'admin', 'd033e22ae3', 1, '0.jfif', 'Admin'),
(11, 11, 'tatang', '9610c2dc65', 1, NULL, 'KepDes'),
(12, 14, 'mumun', '7c4a8d09ca', 0, NULL, 'Staff');
-- --------------------------------------------------------
--
-- Stand-in structure for view `v_data_penduduk`
-- (See below for the actual view)
--
CREATE TABLE `v_data_penduduk` (
`id` int(11)
,`no_kk` varchar(25)
,`no_nik` varchar(25)
,`nama_lengkap` varchar(120)
,`alamat_kampung` varchar(100)
,`rt` varchar(5)
,`rw` varchar(5)
,`jenis_kelamin` varchar(1)
,`tempat_lahir` varchar(100)
,`tanggal_lahir` date
,`agama` int(2)
,`pendidikan` int(2)
,`jenis_pekerjaan` int(2)
,`status_perkawinan` int(2)
,`kewarganegaraan` varchar(3)
,`nama_ayah` varchar(100)
,`nama_ibu` varchar(100)
,`keterangan` varchar(100)
,`createdby` varchar(20)
,`createdon` timestamp
,`modifiedon` timestamp
,`rowstatus` int(1)
,`agama_text` varchar(10)
,`pendidikan_text` varchar(30)
,`kawin_text` varchar(30)
,`kawin_singkat` varchar(2)
,`pekerjaan_text` varchar(30)
,`umur` int(5)
);
-- --------------------------------------------------------
--
-- Stand-in structure for view `v_stat_jenkel`
-- (See below for the actual view)
--
CREATE TABLE `v_stat_jenkel` (
`perempuan` decimal(23,0)
,`laki` decimal(23,0)
);
-- --------------------------------------------------------
--
-- Stand-in structure for view `v_stat_perkawinan`
-- (See below for the actual view)
--
CREATE TABLE `v_stat_perkawinan` (
`kawin` decimal(23,0)
,`tidak_kawin` decimal(23,0)
,`janda` decimal(23,0)
,`duda` decimal(23,0)
);
-- --------------------------------------------------------
--
-- Stand-in structure for view `v_stat_usia`
-- (See below for the actual view)
--
CREATE TABLE `v_stat_usia` (
`balita` decimal(23,0)
,`anak` decimal(23,0)
,`remaja` decimal(23,0)
,`dewasa` decimal(23,0)
,`lansia` decimal(23,0)
);
-- --------------------------------------------------------
--
-- Structure for view `v_data_penduduk`
--
DROP TABLE IF EXISTS `v_data_penduduk`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_data_penduduk` AS (select `a`.`id` AS `id`,`a`.`no_kk` AS `no_kk`,`a`.`no_nik` AS `no_nik`,`a`.`nama_lengkap` AS `nama_lengkap`,`a`.`alamat_kampung` AS `alamat_kampung`,`a`.`rt` AS `rt`,`a`.`rw` AS `rw`,`a`.`jenis_kelamin` AS `jenis_kelamin`,`a`.`tempat_lahir` AS `tempat_lahir`,`a`.`tanggal_lahir` AS `tanggal_lahir`,`a`.`agama` AS `agama`,`a`.`pendidikan` AS `pendidikan`,`a`.`jenis_pekerjaan` AS `jenis_pekerjaan`,`a`.`status_perkawinan` AS `status_perkawinan`,`a`.`tanggal_kawin` AS `tanggal_kawin`,`a`.`sdhk` AS `sdhk`,`a`.`kewarganegaraan` AS `kewarganegaraan`,`a`.`nama_ayah` AS `nama_ayah`,`a`.`nama_ibu` AS `nama_ibu`,`a`.`keterangan` AS `keterangan`,`a`.`gol_darah` AS `gol_darah`,`a`.`createdby` AS `createdby`,`a`.`createdon` AS `createdon`,`a`.`modifiedon` AS `modifiedon`,`a`.`rowstatus` AS `rowstatus`,`b`.`nama` AS `agama_text`,`c`.`nama` AS `pendidikan_text`,`e`.`nama` AS `kawin_text`,`e`.`singkat` AS `kawin_singkat`,`d`.`nama` AS `pekerjaan_text`,(year(now()) - year(`a`.`tanggal_lahir`)) AS `umur` from ((((`tb_data_penduduk` `a` left join `tb_agama` `b` on((`a`.`agama` = `b`.`id`))) left join `tb_pendidikan` `c` on((`c`.`id` = `a`.`pendidikan`))) left join `tb_pekerjaan` `d` on((`a`.`jenis_pekerjaan` = `d`.`id`))) left join `tb_kawin` `e` on((`e`.`id` = `a`.`status_perkawinan`))) where (`a`.`rowstatus` = 1) order by `a`.`id` desc) ;
-- --------------------------------------------------------
--
-- Structure for view `v_stat_jenkel`
--
DROP TABLE IF EXISTS `v_stat_jenkel`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_stat_jenkel` AS (select sum(if((`tb_data_penduduk`.`jenis_kelamin` = 'P'),1,0)) AS `perempuan`,sum(if((`tb_data_penduduk`.`jenis_kelamin` = 'L'),1,0)) AS `laki` from `tb_data_penduduk` where (`tb_data_penduduk`.`rowstatus` = 1)) ;
-- --------------------------------------------------------
--
-- Structure for view `v_stat_perkawinan`
--
DROP TABLE IF EXISTS `v_stat_perkawinan`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_stat_perkawinan` AS (select sum(if((`v_data_penduduk`.`kawin_singkat` = 'K'),1,0)) AS `kawin`,sum(if((`v_data_penduduk`.`kawin_singkat` = 'TK'),1,0)) AS `tidak_kawin`,sum(if(((`v_data_penduduk`.`kawin_singkat` = 'CH') or (`v_data_penduduk`.`kawin_singkat` = 'CM')),1,0)) AS `janda`,sum(if(((`v_data_penduduk`.`kawin_singkat` = 'CH') or (`v_data_penduduk`.`kawin_singkat` = 'CM')),1,0)) AS `duda` from `v_data_penduduk` where (`v_data_penduduk`.`rowstatus` = 1)) ;
-- --------------------------------------------------------
--
-- Structure for view `v_stat_usia`
--
DROP TABLE IF EXISTS `v_stat_usia`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_stat_usia` AS (select sum(if(((year(now()) - year(`tb_data_penduduk`.`tanggal_lahir`)) <= '5'),1,0)) AS `balita`,sum(if((((year(now()) - year(`tb_data_penduduk`.`tanggal_lahir`)) <= '10') and ((year(now()) - year(`tb_data_penduduk`.`tanggal_lahir`)) > '5')),1,0)) AS `anak`,sum(if((((year(now()) - year(`tb_data_penduduk`.`tanggal_lahir`)) <= '18') and ((year(now()) - year(`tb_data_penduduk`.`tanggal_lahir`)) > '10')),1,0)) AS `remaja`,sum(if((((year(now()) - year(`tb_data_penduduk`.`tanggal_lahir`)) <= '59') and ((year(now()) - year(`tb_data_penduduk`.`tanggal_lahir`)) > '18')),1,0)) AS `dewasa`,sum(if(((year(now()) - year(`tb_data_penduduk`.`tanggal_lahir`)) >= '60'),1,0)) AS `lansia` from `tb_data_penduduk` where (`tb_data_penduduk`.`rowstatus` = 1)) ;
--
-- Indexes for dumped tables
--
--
-- Indexes for table `conf_sistem`
--
ALTER TABLE `conf_sistem`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_agama`
--
ALTER TABLE `tb_agama`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_arsip`
--
ALTER TABLE `tb_arsip`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_darah`
--
ALTER TABLE `tb_darah`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_data_penduduk`
--
ALTER TABLE `tb_data_penduduk`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_jabatan`
--
ALTER TABLE `tb_jabatan`
ADD PRIMARY KEY (`id_jabatan`);
--
-- Indexes for table `tb_jenis_usaha`
--
ALTER TABLE `tb_jenis_usaha`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_kawin`
--
ALTER TABLE `tb_kawin`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_menu_pkd`
--
ALTER TABLE `tb_menu_pkd`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_menu_surat`
--
ALTER TABLE `tb_menu_surat`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_pegawai`
--
ALTER TABLE `tb_pegawai`
ADD PRIMARY KEY (`id_pegawai`);
--
-- Indexes for table `tb_pekerjaan`
--
ALTER TABLE `tb_pekerjaan`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_pendidikan`
--
ALTER TABLE `tb_pendidikan`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_sdhk`
--
ALTER TABLE `tb_sdhk`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `tb_surat`
--
ALTER TABLE `tb_surat`
ADD PRIMARY KEY (`id_surat`);
--
-- Indexes for table `tb_user`
--
ALTER TABLE `tb_user`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `conf_sistem`
--
ALTER TABLE `conf_sistem`
MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `tb_agama`
--
ALTER TABLE `tb_agama`
MODIFY `id` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `tb_arsip`
--
ALTER TABLE `tb_arsip`
MODIFY `id` int(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `tb_darah`
--
ALTER TABLE `tb_darah`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `tb_data_penduduk`
--
ALTER TABLE `tb_data_penduduk`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
--
-- AUTO_INCREMENT for table `tb_jabatan`
--
ALTER TABLE `tb_jabatan`
MODIFY `id_jabatan` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT for table `tb_jenis_usaha`
--
ALTER TABLE `tb_jenis_usaha`
MODIFY `id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `tb_kawin`
--
ALTER TABLE `tb_kawin`
MODIFY `id` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `tb_menu_pkd`
--
ALTER TABLE `tb_menu_pkd`
MODIFY `id` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `tb_menu_surat`
--
ALTER TABLE `tb_menu_surat`
MODIFY `id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;
--
-- AUTO_INCREMENT for table `tb_pegawai`
--
ALTER TABLE `tb_pegawai`
MODIFY `id_pegawai` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;
--
-- AUTO_INCREMENT for table `tb_pekerjaan`
--
ALTER TABLE `tb_pekerjaan`
MODIFY `id` int(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT for table `tb_pendidikan`
--
ALTER TABLE `tb_pendidikan`
MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
--
-- AUTO_INCREMENT for table `tb_sdhk`
--
ALTER TABLE `tb_sdhk`
MODIFY `id` int(1) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `tb_surat`
--
ALTER TABLE `tb_surat`
MODIFY `id_surat` int(8) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;
--
-- AUTO_INCREMENT for table `tb_user`
--
ALTER TABLE `tb_user`
MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Thank for coming