-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Dec 07, 2025 at 10:37 AM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `mamikos`
--

-- --------------------------------------------------------

--
-- Table structure for table `aktivitas_kerja`
--

CREATE TABLE `aktivitas_kerja` (
  `id` int(11) NOT NULL,
  `mitra_id` int(11) NOT NULL,
  `tahun_aktif_id` int(11) NOT NULL,
  `nama_aktivitas_id` int(11) NOT NULL,
  `beban_kerja` decimal(10,2) NOT NULL DEFAULT 0.00,
  `jumlah_honor` decimal(15,2) NOT NULL,
  `wilayah_tugas_id` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `aktivitas_kerja`
--

INSERT INTO `aktivitas_kerja` (`id`, `mitra_id`, `tahun_aktif_id`, `nama_aktivitas_id`, `beban_kerja`, `jumlah_honor`, `wilayah_tugas_id`) VALUES
(1, 1, 1, 1, 0.00, 1200000.00, NULL),
(5, 3, 1, 1, 0.00, 8000000.00, NULL),
(6, 1, 1, 1, 0.00, 500000.00, NULL),
(16, 1, 1, 4, 1.00, 10000.00, NULL),
(19, 2, 1, 4, 2.00, 20000.00, NULL),
(21, 1, 1, 3, 1.00, 10000.00, NULL),
(22, 49, 1, 5, 1.00, 17500.00, NULL),
(23, 4, 1, 5, 1.00, 17500.00, NULL),
(24, 1, 1, 3, 1.00, 10000.00, NULL),
(25, 4, 1, 3, 1.00, 10000.00, 8102012008),
(26, 47, 3, 16, 1.00, 20000.00, 8102015004),
(27, 1047, 4, 17, 12.00, 180000.00, 8102016002),
(28, 1013, 4, 17, 10.00, 150000.00, 8102016003),
(30, 973, 4, 17, 20.00, 300000.00, 8102015005),
(31, 978, 4, 17, 8.00, 120000.00, 8102013018),
(32, 1003, 4, 17, 6.00, 90000.00, 8102016002),
(33, 1043, 4, 17, 3.00, 45000.00, 8102016008),
(34, 2, 1, 18, 5.00, 75000.00, NULL),
(35, 2, 1, 19, 1.00, 15000.00, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `detail_kegiatan`
--

CREATE TABLE `detail_kegiatan` (
  `id` int(11) NOT NULL,
  `subkomponen_id` int(11) NOT NULL,
  `tahun_aktif_id` int(11) NOT NULL,
  `kode` varchar(50) DEFAULT NULL,
  `nama_detail` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `detail_kegiatan`
--

INSERT INTO `detail_kegiatan` (`id`, `subkomponen_id`, `tahun_aktif_id`, `kode`, `nama_detail`) VALUES
(1, 2, 1, NULL, 'Honor Peserta Pelatihan Listing 10 Hari'),
(2, 3, 1, NULL, 'Honor Pengawas Lapangan Listing'),
(3, 4, 1, NULL, 'Honor Pencacah Harga Bulanan'),
(4, 4, 1, NULL, 'Honor Pengolahan Dokumen'),
(14, 11, 3, NULL, 'fwef'),
(15, 12, 4, '15.13.10.K11.SK12.D15', '000518. Transport lokal kegiatan pengembangan dan analisis statistik'),
(16, 12, 4, '15.13.10.K11.SK12.D16', '000714. Perjalanan dinas pengumpulan kegiatan pengembangan dan analisis ke kecamatan'),
(17, 13, 4, '16.14.11.K12.SK13.D17', '000006. Transport Lokal Pelaksanaan SKD 2025 di Kabkot'),
(18, 14, 4, '16.15.12.K13.SK14.D18', '000804. Konsumsi dalam rangka Pembinaan Statistik Sektoral'),
(19, 15, 4, '16.15.12.K13.SK15.D19', '000755. Perjalanan konsultasi PSS di BPS Provinsi'),
(20, 16, 4, '17.16.13.K14.SK16.D20', '000018. Honor petugas pendataan lapangan survei SKLNPT'),
(21, 16, 4, '17.16.13.K14.SK16.D21', '000020. Honor petugas pendataan lapangan survei SKSPPI'),
(22, 17, 4, '17.16.13.K14.SK17.D22', '000026.Transport lokal petugas pengumpulan data pendukung perubahan inventori di Kab/Kota'),
(23, 17, 4, '17.16.13.K14.SK17.D23', '000027. Transport lokal petugas pengumpulan data penyusunan PDRB Kab/Kota Tahunan dan indikator PDRB Kab/Kota Triwulanan'),
(24, 17, 4, '17.16.13.K14.SK17.D24', '000031. Transport lokal petugas pemeriksaan lapangan survei SKLNPT'),
(25, 17, 4, '17.16.13.K14.SK17.D25', '000036. Transport lokal pengumpulan data sekunder untuk penyusunan PDB komponen rumah tangga dan indikator LNPRT di Kab/Kota'),
(26, 18, 4, '17.16.14.K15.SK18.D26', '000038. Konsumsi Fullday di kantor pelatihan petugas SKLNPT, SKLNP, Wellbeing, Updating Direktori, dan SKSPPI'),
(27, 19, 4, '17.16.14.K15.SK19.D27', '000042. Pengadaan ATK, kertas, dan bahan cetak di Kab/Kota'),
(28, 20, 4, '17.16.14.K15.SK20.D28', '000045. Perjalanan Fullday di kantor pelatihan petugas SKLNPT, SKLNP, Wellbeing, dan Updating Direktori'),
(29, 21, 4, '17.16.15.K16.SK21.D29', '000488. Honor pengajar petugas pelatihan SKLNP, SKLNPT, Updating Direktori, Wellbeing, dan SKSPPI'),
(30, 22, 4, '18.17.16.K17.SK22.D30', '000050. Honor petugas pendataan lapangan survei khusus Neraca Produksi'),
(31, 22, 4, '18.17.16.K17.SK22.D31', '000051. Honor petugas pendataan lapangan survei SKTNP'),
(32, 23, 4, '18.17.16.K17.SK23.D32', '000058. Transport lokal inventarisasi data sekunder penyusunan PDRB Tahunan di Kab/Kota'),
(33, 23, 4, '18.17.16.K17.SK23.D33', '000059. Transport lokal inventarisasi data sekunder penyusunan PDRB Triwulanan di Kab/Kota'),
(34, 23, 4, '18.17.16.K17.SK23.D34', '000716. Transport lokal petugas pemeriksaan lapangan survei SKTNP'),
(35, 23, 4, '18.17.16.K17.SK23.D35', '000803. Transport lokal petugas pemeriksaan lapangan survei khusus Neraca Produksi'),
(36, 24, 4, '18.17.17.K18.SK24.D36', '000717. Konsumsi Fullday di kantor pelatihan petugas SKTNP'),
(37, 25, 4, '18.17.17.K18.SK25.D37', '000064. Belanja ATK, kertas, dan bahan cetak Kab/Kota'),
(38, 25, 4, '18.17.17.K18.SK25.D38', '000065. Pengadaan Computer Supplies Kab/Kota'),
(39, 26, 4, '18.17.18.K19.SK26.D39', '000643. Honor pengajar petugas pelatihan SKNP, SKTNP'),
(40, 27, 4, '18.17.18.K19.SK27.D40', '000067. Perjalanan dinas pengawasan pengumpulan data survei khusus Neraca Produksi ke kecamatan'),
(41, 28, 4, '19.18.19.K20.SK28.D41', '000070. Translok Supervisi Groundcheck Penyusunan Klasifikasi Desa Perkotaan dan Pedesaan Tahun 2025 di Kabupaten'),
(42, 29, 4, '20.19.20.K21.SK29.D42', '000699. Pengadaan Camera'),
(43, 29, 4, '20.19.20.K21.SK29.D43', '000700. Pengadaan Televisi'),
(44, 30, 4, '21.20.21.K22.SK30.D44', '000109. Honor petugas pendataan lapangan Survei Perdagangan Barang Domestik'),
(45, 30, 4, '21.20.21.K22.SK30.D45', '000524. Honor petugas pendataan lapangan Survei Pola Distribusi Barang'),
(46, 31, 4, '21.20.21.K22.SK31.D46', '000118. Transport lokal petugas pendataan lapangan dokumen udara III/1'),
(47, 32, 4, '21.20.22.K23.SK32.D47', '000718. Transport lokal petugas pendataan lapangan Survei Perdagangan Barang Domestik'),
(48, 32, 4, '21.20.22.K23.SK32.D48', '000719. Transport lokal petugas pendataan lapangan Survei Pola Distribusi Barang'),
(49, 33, 4, '21.21.23.K24.SK33.D49', '000075. Honor petugas pendataan lapangan (Pemetaan)'),
(50, 33, 4, '21.21.23.K24.SK33.D50', '000076. Honor petugas pemeriksa lapangan (Organik)'),
(51, 33, 4, '21.21.23.K24.SK33.D51', '000077. Honor petugas pengolahan peta dan muatan'),
(52, 34, 4, '21.21.24.K25.SK34.D52', '000082. Biaya paket data petugas pendataan Wilkerstat'),
(53, 34, 4, '21.21.24.K25.SK34.D53', '000618. Pengadaan perlengkapan pelatihan petugas pemetaan lapangan'),
(54, 34, 4, '21.21.24.K25.SK34.D54', '000720. Konsumsi pelatihan petugas pengolahan'),
(55, 34, 4, '21.21.24.K25.SK34.D55', '000721. Spanduk pelatihan petugas pemetaan'),
(56, 34, 4, '21.21.24.K25.SK34.D56', '000722. Spanduk pelatihan petugas pengolahan'),
(57, 35, 4, '21.21.24.K25.SK35.D57', '000083. Honor pengajar petugas pemetaan'),
(58, 35, 4, '21.21.24.K25.SK35.D58', '000084. Honor pengajar petugas pengolahan'),
(59, 36, 4, '21.21.24.K25.SK36.D59', '000085. Asuransi petugas Wilkerstat'),
(60, 37, 4, '21.21.24.K25.SK37.D60', '000086. Pengadaan ATK'),
(61, 37, 4, '21.21.24.K25.SK37.D61', '000087. Pengadaan Computer Supplies'),
(62, 38, 4, '21.21.24.K25.SK38.D62', '000088. Pengawasan Lapangan Kab/Kota'),
(63, 38, 4, '21.21.24.K25.SK38.D63', '000615. Transport Daerah Sulit'),
(64, 39, 4, '21.21.24.K25.SK39.D64', '000089. Pelatihan petugas pemetaan lapangan'),
(65, 39, 4, '21.21.24.K25.SK39.D65', '000090. Perjalanan pelatihan petugas pemetaan lapangan'),
(66, 40, 4, '21.21.25.K26.SK40.D66', '000766. Transport lokal pengawas Updating Direktori Usaha/Perusahaan Ekonomi Lanjutan'),
(67, 41, 4, '21.21.26.K27.SK41.D67', '000107. Baliho dan pemasangan bahan sosialisasi pelaksanaan SE2026'),
(68, 41, 4, '21.21.26.K27.SK41.D68', '000792. Konsumsi dalam rangka Sosialisasi Sensus Ekonomi'),
(69, 41, 4, '21.21.26.K27.SK41.D69', '000801. Alat dan bahan dalam rangka Sosialisasi SE'),
(70, 42, 4, '21.21.26.K27.SK42.D70', '000767. Perjalanan dalam rangka Sosialisasi SE2026'),
(71, 43, 4, '21.21.26.K27.SK43.D71', '000800. Perjalanan dinas dalam rangka mengikuti Rakorda Sensus Ekonomi 2026');

-- --------------------------------------------------------

--
-- Table structure for table `kegiatan`
--

CREATE TABLE `kegiatan` (
  `id` int(11) NOT NULL,
  `program_id` int(11) NOT NULL,
  `tahun_aktif_id` int(11) NOT NULL,
  `kode` varchar(50) DEFAULT NULL,
  `nama_kegiatan` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `kegiatan`
--

INSERT INTO `kegiatan` (`id`, `program_id`, `tahun_aktif_id`, `kode`, `nama_kegiatan`) VALUES
(1, 1, 1, NULL, 'Kegiatan Sensus Ekonomi'),
(2, 1, 1, NULL, 'Kegiatan Survei Harga Konsumen'),
(12, 14, 3, NULL, 'a'),
(13, 15, 4, '15.13', 'BMA.004 Publikasi/Laporan Analisis dan Pengembangan Statistik'),
(14, 16, 4, '16.14', 'BMA.004 Laporan Diseminasi dan Metadata Statistik'),
(15, 16, 4, '16.15', 'QDB.003 Penguatan Penyelenggaraan Pembinaan Statistik Sektoral'),
(16, 17, 4, '17.16', 'BMA.007 Publikasi/Laporan Statistik Neraca Pengeluaran'),
(17, 18, 4, '18.17', 'BMA.006 Publikasi/Laporan Neraca Produksi'),
(18, 19, 4, '19.18', 'BMA.005 Dokumen/Laporan Pengembangan Metodologi Kegiatan Statistik'),
(19, 20, 4, '20.19', 'CAN.004 Pengembangan Infrastruktur dan Layanan Teknologi Informasi dan Komunikasi'),
(20, 21, 4, '21.20', 'BMA.004 Publikasi/Laporan Statistik Distribusi'),
(21, 21, 4, '21.21', 'BMA.006 Publikasi/Laporan Sensus Ekonomi');

-- --------------------------------------------------------

--
-- Table structure for table `komponen`
--

CREATE TABLE `komponen` (
  `id` int(11) NOT NULL,
  `subkegiatan_id` int(11) NOT NULL,
  `tahun_aktif_id` int(11) NOT NULL,
  `kode` varchar(50) DEFAULT NULL,
  `nama_komponen` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `komponen`
--

INSERT INTO `komponen` (`id`, `subkegiatan_id`, `tahun_aktif_id`, `kode`, `nama_komponen`) VALUES
(1, 1, 1, NULL, 'Komponen Pelatihan Listing'),
(2, 1, 1, NULL, 'Komponen Lapangan Listing'),
(3, 2, 1, NULL, 'Komponen Pengumpulan Data Harga'),
(10, 9, 3, NULL, 'aaaa'),
(11, 10, 4, '15.13.10.K11', '052.0A Tanpa Sub Komponen'),
(12, 11, 4, '16.14.11.K12', '052.0A Tanpa Sub Komponen'),
(13, 12, 4, '16.15.12.K13', '052.0A Tanpa Sub Komponen'),
(14, 13, 4, '17.16.13.K14', '005.0A Tanpa Sub Komponen'),
(15, 14, 4, '17.16.14.K15', '051.0A Tanpa Sub Komponen'),
(16, 15, 4, '17.16.15.K16', '052.0A Tanpa Sub Komponen'),
(17, 16, 4, '18.17.16.K17', '005.0A Tanpa Sub Komponen'),
(18, 17, 4, '18.17.17.K18', '051.0A Tanpa Sub Komponen'),
(19, 18, 4, '18.17.18.K19', '052.0A Tanpa Sub Komponen'),
(20, 19, 4, '19.18.19.K20', '005.0A Tanpa Sub Komponen'),
(21, 20, 4, '20.19.20.K21', '056.0A Tanpa Sub Komponen'),
(22, 21, 4, '21.20.21.K22', '005.0A Tanpa Sub Komponen'),
(23, 22, 4, '21.20.22.K23', '052.0A Tanpa Sub Komponen'),
(24, 23, 4, '21.21.23.K24', '005.0A Tanpa Sub Komponen'),
(25, 24, 4, '21.21.24.K25', '506.0A Tanpa Sub Komponen'),
(26, 25, 4, '21.21.25.K26', '516.0A Tanpa Sub Komponen'),
(27, 26, 4, '21.21.26.K27', '519.0A Tanpa Sub Komponen');

-- --------------------------------------------------------

--
-- Table structure for table `mitra`
--

CREATE TABLE `mitra` (
  `id` int(11) NOT NULL,
  `tahun_aktif_id` int(11) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `nik` varchar(20) DEFAULT NULL,
  `alamat` text DEFAULT NULL,
  `no_hp` varchar(15) DEFAULT NULL,
  `domisili_wilayah_id` bigint(20) DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mitra`
--

INSERT INTO `mitra` (`id`, `tahun_aktif_id`, `nama`, `nik`, `alamat`, `no_hp`, `domisili_wilayah_id`, `latitude`, `longitude`) VALUES
(1, 1, 'Andi Susanto', '3201011001950001', 'abc@gmail.com', '0812345678907', NULL, NULL, NULL),
(2, 1, 'Budi Cahyono', '3201011002900002', 'abdsjo@gmail.com', '085678901234', 8102020046, NULL, NULL),
(3, 1, 'Citra Dewi', '3201011003980003', 'ads2@gmail.com', '087890123456', NULL, NULL, NULL),
(4, 1, 'Dina Amelia', '3201011004930004', '', '081345678901', NULL, NULL, NULL),
(8, 1, 'Ruth', '28034', 'jwfowk', '3023', NULL, NULL, NULL),
(10, 2, 'Ruth Madeline', '2171035705009004', 'rutekms@gmail.com', '0851612451705', NULL, NULL, NULL),
(14, 1, 'Ruth Madeline', '3434343', 'rutekms@gmail.com', '0851612451705', NULL, NULL, NULL),
(15, 1, 'Ruth Madeline', '3434343e333', 'rutekms@gmail.com', '0851612451705', NULL, NULL, NULL),
(16, 1, 'Ruth Madeline', '3434343e3333', 'rutekms@gmail.com', '0851612451705', 8102013011, NULL, NULL),
(17, 1, 'Ruth Madeline', '3434343333', 'rutekms@gmail.com', '0851612451705', NULL, NULL, NULL),
(21, 1, 'adi', '111111111111', '67u@rg.comd', '456456', 8102022014, NULL, NULL),
(23, 1, 'Iqbal', '883939', 'adakah@gmail.com', '2389432', NULL, NULL, NULL),
(24, 1, 'Iqbal', '143235436', 'adakah@gmail.com', '2389432', NULL, NULL, NULL),
(25, 1, 'Ruth Madeline', '34343433333', 'rutekms@gmail.com', '0851612451705', NULL, NULL, NULL),
(26, 1, 'Malo', '252535', 'adakah@gmail.com', '2389432', 8102010043, NULL, NULL),
(31, 1, 'Damar Sulis', '8102035705009004', '67u@rg.comd', '085161456667', 8102010025, NULL, NULL),
(34, 1, 'Ruth Madeline', '546456562424', 'rutekms@gmail.com', '0851612451705', 8102014006, NULL, NULL),
(35, 1, 'Andi Burhan', '8172035705009004', 'adakah@gmail.com', '087865432190', 8102010025, NULL, NULL),
(36, 1, 'Benjamin', '3u489374234', 'rutekms@gmail.com', '0851612451705', 8102020044, NULL, NULL),
(42, 3, 'Damar Sulis', '8102035705009004', '67u@rg.comd', '085161456667', 8102012007, NULL, NULL),
(44, 3, 'Benjamin', '5366822222', 'rutekms@gmail.com', '0851612451705', 8102020028, NULL, NULL),
(45, 3, 'Noname', '2u428783490349', 'rutekms@gmail.com', '0851612451705', 8102020025, NULL, NULL),
(46, 3, 'Damar Sulis', '8102035705009005', '67u@rg.comd', '085161456667', 8102010025, NULL, NULL),
(47, 3, 'Andi Burhan', '8172035705009005', 'adakah@gmail.com', '087865432190', 8102022013, NULL, NULL),
(48, 1, 'Damar Sulis', '8102035705009005', '67u@rg.comd', '085161456667', 8102010025, NULL, NULL),
(49, 1, 'Andi Burhan', '8172035705009005', 'adakah@gmail.com', '087865432190', 8102010035, NULL, NULL),
(50, 1, 'Indah', '8759u94u3252', 'bambangsutris@gmail.com', '085161451705', 8102020025, NULL, NULL),
(51, 1, 'Damar Sulis', '8102035705009010', '67u@rg.comd', '085161456667', 8102010025, NULL, NULL),
(52, 1, 'Andi Burhan', '8172035705009010', 'adakah@gmail.com', '087865432190', 8102010025, NULL, NULL),
(53, 1, 'Indah', '8759u94u325224342', 'bambangsutris@gmail.com', '085161451705', 8102020059, NULL, NULL),
(54, 3, 'Bernal', '74092352', 'qrqwr', 'qrwqw', 8102013010, NULL, NULL),
(55, 3, 'Damar Sulis', '8102035705009010', '67u@rg.comd', '085161456667', 8102010025, NULL, NULL),
(56, 3, 'Andi Burhan', '8172035705009010', 'adakah@gmail.com', '087865432190', 8102010025, NULL, NULL),
(326, 3, 'Adrian', 'u23r923ur90', 'rutekms@gmail.com', '0851612451705', 8102022014, NULL, NULL),
(327, 3, 'Arhan', '810209890078', 'adnan@gmail.com', '089766789876', 8102012003, NULL, NULL),
(328, 1, 'Arhan', '810209890078', 'adnan@gmail.com', '089766789876', 8102012003, NULL, NULL),
(948, 4, 'Pratiwi kusumaningtyas', '3306065110900001', 'tanlaintiwi1@gmail.com', '081366803061', 8102000000, NULL, NULL),
(949, 4, 'Yeska Triseptiani', '3403124209860001', 'yeskatya@gmail.com', '082325675613', 8102000000, NULL, NULL),
(950, 4, 'MARIA PETRONELA KEIN', '5306065909950002', 'mariapetronelakein13@gmail.com', '081214250362', 8102000000, NULL, NULL),
(951, 4, 'ARDIYANTHO BENIHELDUS F .ANITU', '8102010107980122', 'beniheldus@gmail.com', '081261278496', 8102000000, NULL, NULL),
(952, 4, 'Fredrik Batilmurik', '8102010205000009', 'pendribatilmurik@gmail.com', '081233408491', 8102000000, -5.908590902804312, NULL),
(953, 4, 'Yulians melky frando Tharob', '8102010309950009', 'Yuliansfrando@gmail.com', '082239108975', 8102000000, NULL, NULL),
(954, 4, 'Musli bugis', '8102010402950006', 'muslybugis@gmail.com', '082248677572', 8102000000, NULL, NULL),
(955, 4, 'Luciano Raymond Panvord Rumangun', '8102010701940005', 'iyanoroemangoen@gmail.com', '052438400852', 8102000000, NULL, NULL),
(956, 4, 'Agust W Rahakbauw', '8102010808820008', 'agustrahakbauw82@gmail.com', '082248006600', 8102000000, NULL, NULL),
(957, 4, 'GERARDUS RAHAIL', '8102010808920006', 'rahailgerry320@gmail.com', '082160328502', 8102000000, NULL, NULL),
(958, 4, 'Victor C.W Mayabubun', '8102011204930003', 'clinton12mayab@gmail.com', '082264482412', 8102000000, NULL, NULL),
(959, 4, 'Vandy Randi notanubun', '8102011205930005', 'vandiohoiwait@gmail.com', '008259646144', 8102000000, NULL, NULL),
(960, 4, 'Eka Saputra', '8102011302950001', 'saputraeka2024@gmail.com', '082310170040', 8102000000, NULL, NULL),
(961, 4, 'Carlos Lekatompessy', '8102011505010004', 'lecka7640@gmail.com', '082238299078', 8102000000, NULL, NULL),
(962, 4, 'Rabani Letsoin', '8102011607880004', 'rabaniletsoinsa@gmail.com', '085343506123', 8102000000, NULL, NULL),
(963, 4, 'Yehuda Lynery Tarantein', '8102011801030005', 'teinyehuda018@gmail.com', '085825374504', 8102000000, NULL, NULL),
(964, 4, 'Khairul Yamlean', '8102011812030001', 'yamleankhairul@gmail.com', '081245549102', 8102000000, NULL, NULL),
(965, 4, 'Rickhart rettob', '8102011902940003', 'Richo.rettob@gmail.com', '082293041809', 8102000000, NULL, NULL),
(966, 4, 'Fernando ngamelubun', '8102012101000006', 'nandongamelubun@gmail.com', '082131132244', 8102000000, NULL, NULL),
(967, 4, 'Indra Eleuwarin', '8102012211950003', 'indraeleuwarin00@gmail.com', '081352267216', 8102000000, NULL, NULL),
(968, 4, 'Corneles Jusuf Woersok', '8102012610980004', 'woersokcorneles@gmail.com', '081147707141', 8102000000, NULL, NULL),
(969, 4, 'Marthen Delwiana Reiwuty', '8102012801930004', 'tenggoreiwuty93@gmail.com', '082293913991', 8102000000, NULL, NULL),
(970, 4, 'George Yab Ngamelubun', '8102012806940003', 'georgengamelubun@gmail.com', '082233845554', 8102000000, NULL, NULL),
(971, 4, 'MOH AKBAR DIFINUBUN', '8102012910990004', 'akbartamher71@gmail.com', '082396185077', 8102000000, NULL, NULL),
(972, 4, 'Sarni Letsoin', '8102014101990001', 'letsoinsarni@gmail.com', '082198315806', 8102000000, NULL, NULL),
(973, 4, 'Alfonsina renwer', '8102014208830001', 'hanubunrenwer@gmail.com', '081325478453', 8102000000, NULL, NULL),
(974, 4, 'Krisye yohana tety', '8102014401860001', 'Christantomaherlefitar21@gmail.com', '081248162330', 8102000000, NULL, NULL),
(975, 4, 'Warda burungasi', '8102014412910001', 'wardaburungai04@gmail.com', '082148922792', 8102000000, NULL, NULL),
(976, 4, 'Yosefa maharani rumangun', '8102014503960003', 'Rumangunmaharani@gmail.com', '081247047049', 8102000000, NULL, NULL),
(977, 4, 'MUSRIFA AINI KERUBUN', '8102014610940002', 'musfirakarubun@gmail.com', '081246802881', 8102000000, NULL, NULL),
(978, 4, 'Cellyn tomasoa', '8102014703960008', 'cellyn.tomasoa07@gmail.com', '081340059193', 8102000000, NULL, NULL),
(979, 4, 'Irene Ross Hanoatubun', '8102014708860008', 'Irenehanoatubun@gmail.com', '082128456955', 8102000000, NULL, NULL),
(980, 4, 'Elisabeth Dumatubun', '8102014808960004', 'elisabethdumwell88@gmail.com', '081288790983', 8102000000, NULL, NULL),
(981, 4, 'Maria Vitalia Mayabubun', '8102014809980004', 'mariavitaliamayabubun@gmail.com', '081344282774', 8102000000, NULL, NULL),
(982, 4, 'MERLINA ELTINA WOERSOK', '8102015005940005', 'eltin.woersok@yahoo.com', '085216290655', 8102000000, NULL, NULL),
(983, 4, 'Ama Tasya', '8102015104010007', 'ama2002tasya@gmail.com', '082245408097', 8102000000, NULL, NULL),
(984, 4, 'LISYE DIANA DOKAINUBUN', '8102015404830006', 'dokainubunlisyediana@gmail.com', '082398936590', 8102000000, NULL, NULL),
(985, 4, 'Salbia Yamlean', '8102015504930002', 'yamleanshal@gmail.com', '082143650553', 8102000000, NULL, NULL),
(986, 4, 'Talha Gulam', '8102015604890002', 'assylamuhriz@gmail.com', '082197961115', 8102000000, NULL, NULL),
(987, 4, 'Jeannet Rettobyaan', '8102015612900005', 'jrettobyaan@gmail.com', '081227677272', 8102000000, NULL, NULL),
(988, 4, 'Beata Rettob', '8102015803980003', 'beatarettob@gmail.com', '008134323139', 8102000000, NULL, NULL),
(989, 4, 'Kassiana Elmas', '8102015804990004', 'yanaelmas@gmail.com', '082239044387', 8102000000, NULL, NULL),
(990, 4, 'Lenora Batilmurik', '8102015909970009', 'ennovip19@gmail.com', '082251358553', 8102000000, NULL, NULL),
(991, 4, 'Maria M Efruan', '8102016005980003', 'mariaefruan@gmail.com', '085197205494', 8102000000, NULL, NULL),
(992, 4, 'Rizkiyah Aristya Kilmurin', '8102016006030006', 'rizkiyaharistya@gmail.com', '081354004426', 8102000000, NULL, NULL),
(993, 4, 'Prilly Lidya Frans', '8102016104030005', 'prillylidya003@gmail.com', '081240767084', 8102000000, NULL, NULL),
(994, 4, 'Hasnah wati Tamher', '8102016108990003', 'Hasnawatitamher@gmail.com', '082196575152', 8102000000, NULL, NULL),
(995, 4, 'Trivosa Lidya Ade', '8102016111990004', 'lidyatrivosa21@gmail.com', '082399334504', 8102000000, NULL, NULL),
(996, 4, 'Rosnata Hendrika Wellikin', '8102016201880005', 'welikkinrosa@gmail.com', '082248136276', 8102000000, NULL, NULL),
(997, 4, 'YUDIT DOKAINUBUN', '8102016210900003', 'dokainubunyudith@gmail.com', '082197615508', 8102000000, NULL, NULL),
(998, 4, 'Vera Viescarlia Ohoira', '8102016302960004', 'veraohoira@gmail.com', '082333141515', 8102000000, NULL, NULL),
(999, 4, 'Grace Marthin Koanyanan', '8102016511940004', 'gracemarthinkoanyanan@gmail.com', '085200052112', 8102000000, NULL, NULL),
(1000, 4, 'Wasani Tamher', '8102016703010002', 'Sanytamher1@gmail.com', '081340436871', 8102000000, NULL, NULL),
(1001, 4, 'Juliana renjaan', '8102016807850001', 'Ulenpoenk@gmail.com', '085243668855', 8102000000, NULL, NULL),
(1002, 4, 'Syenthia Claudya Kassir', '8102016809990005', 'syenthiackassir@gmail.com', '082238987799', 8102000000, NULL, NULL),
(1003, 4, 'ANNA MARIA SIRWUTUBUN', '8102017010890007', 'annasirwut89@gmail.com', '081343002220', 8102000000, NULL, NULL),
(1004, 4, 'Julius Notanubun', '8102031109750001', 'juliusnotanubun@gmail.com', '082198562690', 8102000000, NULL, NULL),
(1005, 4, 'ARIEL JEHESKEL RENUW', '8102032710000004', 'renuwariel@gmail.com', '081248629094', 8102000000, NULL, NULL),
(1006, 4, 'AMARENCI ELISABET RAHJAAN', '8102034104980007', 'amarencielisabetrahjaan@gmail.com', '082248557345', 8102000000, NULL, NULL),
(1007, 4, 'Meyrelin Rahakbauw', '8102034105970002', 'meyrahakbauw01@gmail.com', '081326616172', 8102000000, NULL, NULL),
(1008, 4, 'Rani indriani pratiwi Suatrean', '8102034108010002', 'raniindrianipratiwi01@gmail.com', '081240474575', 8102000000, NULL, NULL),
(1009, 4, 'Regina Redemta Ohoiwai', '8102034606990002', 'reginaohoiwai06@gmail.com', '082193833363', 8102000000, NULL, NULL),
(1010, 4, 'Mursal rahaleb', '8102034608860003', 'mursalrahaleb@gmail.com', '082238936577', 8102000000, NULL, NULL),
(1011, 4, 'Mayang Sari Suat', '8102035102920002', 'mayangsarisuat616@gmail.com', '081343482558', 8102000000, NULL, NULL),
(1012, 4, 'Nandini Suat', '8102035108020006', 'nandinisuat53@gmail.com', '082346989703', 8102000000, NULL, NULL),
(1013, 4, 'AMINA BARANYANAN', '8102035301870003', 'aminabaranyanan01@gmail.com', '081344445116', 8102000000, NULL, NULL),
(1014, 4, 'Kaliba Suat', '8102035302800002', 'suatkaliba@gmail.com', '081240900079', 8102000000, NULL, NULL),
(1015, 4, 'Santi sahid suatrean', '8102035412840001', 'santisuatrean9936@Gmail.com', '082199622924', 8102000000, NULL, NULL),
(1016, 4, 'Anisa Saima Kelmurin', '8102035907990001', 'anisakelmurin@gmail.com', '082248070239', 8102000000, NULL, NULL),
(1017, 4, 'Febiola Notanubun', '8102036002780003', 'febiolaveerman@gmail.com', '081240689501', 8102000000, NULL, NULL),
(1018, 4, 'Frentin Fernatyanan', '8102036208000003', 'frentinf@gmail.com', '081240968601', 8102000000, NULL, NULL),
(1019, 4, 'Yayu Mirna Wenehenubun', '8102046409920002', 'yayumirna@gmail.com', '082143651075', 8102000000, NULL, NULL),
(1020, 4, 'Moh. Syahab Salamun', '8102050101940001', 'syahab.salamun.92@gmail.com', '085336420189', 8102000000, NULL, NULL),
(1021, 4, 'ESAU FEKI NOFI LARUBUN', '8102072311730001', 'nofilarubun@gmail.com', '085243092198', 8102000000, NULL, NULL),
(1022, 4, 'SWINE ENGGELINA LARUBUN', '8102075307030001', 'swinelarubun13@gmail.com', '081241523690', 8102000000, NULL, NULL),
(1023, 4, 'FRIDA JOHANA LARUBUN', '8102076702800001', 'fridajohanalarubun@gmail.com', '082397887475', 8102000000, NULL, NULL),
(1024, 4, 'Maria Meirina Jalmav', '8102085105940001', 'jalmavamey@gmail.com', '085243576977', 8102000000, NULL, NULL),
(1025, 4, 'YULITA PETRA NARAHA, SH', '8102096011940003', 'yulitapetranaraha@gmail.com', '082238834394', 8102000000, NULL, NULL),
(1026, 4, 'Suaza Milarati kudubun', '8102096710910002', 'suazamilaratikudubun@gmail.com', '082239305890', 8102000000, NULL, NULL),
(1027, 4, 'Dwi Endang Mahani Rahayaan', '8102096803000002', 'endangrahayaan28@gmail.com', '082183262946', 8102000000, NULL, NULL),
(1028, 4, 'Ikbal Muhammad Rahaningmas', '8102100201930003', 'ikhirahaningmas@gmail.com', '081247277473', 8102000000, NULL, NULL),
(1029, 4, 'Denist Miraldo Oraplean', '8102100803980001', 'Denistmiraldotjp@gmail.com', '085298209368', 8102000000, NULL, NULL),
(1030, 4, 'FRANS RENJAAN', '8102101102770001', 'fransrenjaan11@gmail.com', '082227123239', 8102000000, NULL, NULL),
(1031, 4, 'Julius amram jamlaay', '8102101707690001', 'Jullesh69@gmail.com', '082239795118', 8102000000, NULL, NULL),
(1032, 4, 'MAHARANI PUTRI RAMADHANI RENUR', '8102104212000002', 'putrirenur@gmail.com', '082122242414', 8102000000, NULL, NULL),
(1033, 4, 'Marlina Juliana Renwer', '8102106703850001', 'Merlinrenwerrettobjaan85@gmail.com', '082398350327', 8102000000, NULL, NULL),
(1034, 4, 'SUGIYANTI OHOIULUN', '8102106711860004', 'sugiohoiulunhorokubun@gmail.com', '082198497122', 8102000000, NULL, NULL),
(1035, 4, 'Lenny Cornela Ubwarin', '8102106902800003', 'lennyubwarin@gmail.com', '081344691828', 8102000000, NULL, NULL),
(1036, 4, 'Moh Fijay Permana Madubun', '8102131005990001', 'mohfijaymadubun@gmail.com', '082199381701', 8102000000, NULL, NULL),
(1037, 4, 'JOHANIS E. THAROB', '8102133110820001', 'Ebettharob@gmail.com', '082232381627', 8102000000, NULL, NULL),
(1038, 4, 'Henrika Ngoranubun', '8102160605210001', 'basarlamhani@gmail.com', '081248644507', 8102000000, NULL, NULL),
(1039, 4, 'Roke gaitian', '8107013012950001', 'berjuang2021baru@gmail.com', '081242900696', 8102000000, NULL, NULL),
(1040, 4, 'Wulan Silvana Erubun', '8107016505020004', 'erubunjamlean25@gmail.com', '082313063434', 8102000000, NULL, NULL),
(1041, 4, 'Christo Wattimena', '8171011810890001', 'christowattimena.acm@gmail.com', '085243275121', 8102000000, NULL, NULL),
(1042, 4, 'Dellon Rupilu', '8171022112980002', 'dellonrupilu@gmail.com', '082248018397', 8102000000, -5.908249403890496, 132.7790599312176),
(1043, 4, 'Fauziah Idris', '8171025105020011', 'ifauziah498@gmail.com', '082335428853', 8102000000, -5.908249403890496, 132.7790599312176),
(1044, 4, 'Meinaldo anggriawan renhoart', '8171032305890002', 'Meinaldorenhoart@gmail.com', '082198446161', 8102000000, NULL, NULL),
(1045, 4, 'Yance Karel Sutiray', '8172021001910001', 'Yancesutiray@gmail.com', '008331269203', 8102000000, NULL, NULL),
(1046, 4, 'Agustinus George Peilouw', '8172021003810002', 'peilouwacho@gmail.com', '081247579994', 8102000000, NULL, NULL),
(1047, 4, 'Abraham Ryzchkov Serang', '8172021205000002', 'abrahamryzchkov@gmail.com', '08124827362', 8102020026, NULL, NULL),
(1048, 4, 'RONALD R JAMBORMIAS', '8172021603860002', 'pujapuji_g@gmail.com', '085354023389', 8102000000, NULL, NULL),
(1049, 4, 'Fauzan salim', '8172022804960002', 'Ojhanalkatiri@gmail.com', '082333720729', 8102000000, NULL, NULL),
(1050, 4, 'Alda Said Tamher', '8172026805990001', 'aldasaid2820@gmail.com', '081354022813', 8102010037, NULL, NULL);

--
-- Triggers `mitra`
--
DELIMITER $$
CREATE TRIGGER `before_mitra_insert` BEFORE INSERT ON `mitra` FOR EACH ROW BEGIN
    IF NEW.domisili_wilayah_id IS NOT NULL THEN
        SELECT latitude, longitude INTO @lat, @lon 
        FROM wilayahtugas 
        WHERE id = NEW.domisili_wilayah_id;
        SET NEW.latitude = @lat;
        SET NEW.longitude = @lon;
    END IF;
END
$$
DELIMITER ;
DELIMITER $$
CREATE TRIGGER `before_mitra_update` BEFORE UPDATE ON `mitra` FOR EACH ROW BEGIN
    IF NEW.domisili_wilayah_id <> OLD.domisili_wilayah_id THEN
        SELECT latitude, longitude INTO @lat, @lon 
        FROM wilayahtugas 
        WHERE id = NEW.domisili_wilayah_id;
        SET NEW.latitude = @lat;
        SET NEW.longitude = @lon;
    END IF;
END
$$
DELIMITER ;

-- --------------------------------------------------------

--
-- Table structure for table `nama_aktivitas_master`
--

CREATE TABLE `nama_aktivitas_master` (
  `id` int(11) NOT NULL,
  `detail_kegiatan_id` int(11) NOT NULL,
  `jenis_kegiatan` enum('Pendataan','Pengolahan') NOT NULL DEFAULT 'Pendataan',
  `nama_aktivitas` varchar(255) NOT NULL,
  `satuan_bayar` varchar(50) NOT NULL,
  `harga_satuan` int(11) DEFAULT 0,
  `tgl_mulai` date NOT NULL DEFAULT curdate(),
  `tgl_selesai` date NOT NULL DEFAULT curdate()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `nama_aktivitas_master`
--

INSERT INTO `nama_aktivitas_master` (`id`, `detail_kegiatan_id`, `jenis_kegiatan`, `nama_aktivitas`, `satuan_bayar`, `harga_satuan`, `tgl_mulai`, `tgl_selesai`) VALUES
(3, 1, 'Pendataan', 'SUSENAS November 2025', 'Dokumen', 10000, '0000-00-00', '2025-12-18'),
(4, 1, 'Pengolahan', 'SUSENAS November 2025', 'Dokumen', 10000, '2025-12-25', '0000-00-00'),
(5, 1, 'Pendataan', 'SUSENAS Oktober 2025', 'Dokumen', 17500, '2025-10-09', '2025-10-31'),
(7, 1, 'Pengolahan', 'COba aja', 'Dokumen', 100000, '2025-12-17', '2025-12-31'),
(8, 1, 'Pengolahan', 'COba aja', 'Dokumen', 100000, '2025-12-17', '2025-12-31'),
(9, 1, 'Pendataan', 'COba aja', 'Dokumen', 20000, '2025-12-16', '2025-12-31'),
(10, 1, 'Pendataan', 'COba aja', 'Dokumen', 20000, '2025-12-16', '2025-12-31'),
(11, 1, 'Pendataan', 'COba aja', 'Dokumen', 20000, '2025-12-16', '2025-12-31'),
(12, 3, 'Pengolahan', 'Bukan', 'Dokumen', 17000, '2025-12-22', '2025-12-31'),
(13, 3, 'Pengolahan', 'Bukan', 'Dokumen', 17000, '2025-12-22', '2025-12-31'),
(14, 3, 'Pengolahan', 'Bukan', 'Dokumen', 17000, '2025-12-22', '2025-12-31'),
(15, 3, 'Pengolahan', 'Bukan', 'Dokumen', 17000, '2025-12-22', '2025-12-31'),
(16, 14, 'Pendataan', 'aaaaa', 'Dokumen', 20000, '2021-02-06', '2021-03-18'),
(17, 21, 'Pendataan', 'Survei Khusus Studi Penyusunan Perubahan Inventori', 'Dokumen', 15000, '2020-12-04', '2020-12-30'),
(18, 3, 'Pendataan', 'Percobaan lagi', 'Dokumen', 15000, '2025-06-04', '2025-10-30'),
(19, 2, 'Pendataan', 'Percobaan lagi 2', 'Dokumen', 15000, '2025-07-04', '2025-10-30');

-- --------------------------------------------------------

--
-- Table structure for table `program`
--

CREATE TABLE `program` (
  `id` int(11) NOT NULL,
  `tahun_aktif_id` int(11) NOT NULL,
  `kode` varchar(50) DEFAULT NULL,
  `nama_program` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `program`
--

INSERT INTO `program` (`id`, `tahun_aktif_id`, `kode`, `nama_program`) VALUES
(1, 1, NULL, 'Program Penyediaan Data Strategiss'),
(14, 3, NULL, 'a'),
(15, 4, '15', 'GG.2896 Pengembangan dan Analisis Statistik'),
(16, 4, '16', 'GG.2897 Pelayanan dan Pengembangan Diseminasi Informasi Statistik'),
(17, 4, '17', 'GG.2898 Penyediaan dan Pengembangan Statistik Neraca Pengeluaran'),
(18, 4, '18', 'GG.2899 Penyediaan dan Pengembangan Statistik Neraca Produksi'),
(19, 4, '19', 'GG.2900 Pengembangan Metodologi Sensus dan Survei'),
(20, 4, '20', 'GG.2901 Pengembangan Sistem Informasi Statistik'),
(21, 4, '21', 'GG.2902 Penyediaan dan Pengembangan Statistik Distribusi');

-- --------------------------------------------------------

--
-- Table structure for table `subkegiatan`
--

CREATE TABLE `subkegiatan` (
  `id` int(11) NOT NULL,
  `kegiatan_id` int(11) NOT NULL,
  `tahun_aktif_id` int(11) NOT NULL,
  `kode` varchar(50) DEFAULT NULL,
  `nama_subkegiatan` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `subkegiatan`
--

INSERT INTO `subkegiatan` (`id`, `kegiatan_id`, `tahun_aktif_id`, `kode`, `nama_subkegiatan`) VALUES
(1, 1, 1, NULL, 'Subkegiatan Listing Wilayah SE'),
(2, 2, 1, NULL, 'Subkegiatan Pencacahan Data Harga'),
(9, 12, 3, NULL, 'aaa'),
(10, 13, 4, '15.13.10', '052 Pengumpulan Data'),
(11, 14, 4, '16.14.11', '052 Pengumpulan Data'),
(12, 15, 4, '16.15.12', '052 Pengumpulan Data'),
(13, 16, 4, '17.16.13', '005 Dukungan Penyelenggaraan Tugas dan Fungsi Unit'),
(14, 16, 4, '17.16.14', '051 Persiapan'),
(15, 16, 4, '17.16.15', '052 Pengumpulan Data'),
(16, 17, 4, '18.17.16', '005 Dukungan Penyelenggaraan Tugas dan Fungsi Unit'),
(17, 17, 4, '18.17.17', '051 Persiapan'),
(18, 17, 4, '18.17.18', '052 Pengumpulan Data'),
(19, 18, 4, '19.18.19', '005 Dukungan Penyelenggaraan Tugas dan Fungsi Unit'),
(20, 19, 4, '20.19.20', '056 Pengembangan Infrastruktur dan Layanan Teknologi Informasi dan Komunikasi'),
(21, 20, 4, '21.20.21', '005 Dukungan Penyelenggaraan Tugas dan Fungsi Unit'),
(22, 20, 4, '21.20.22', '052 Pengumpulan Data'),
(23, 21, 4, '21.21.23', '005 Dukungan Penyelenggaraan Tugas dan Fungsi Unit'),
(24, 21, 4, '21.21.24', '506 Pemutakhiran Kerangka Geospasial dan Muatan Wilkerstat'),
(25, 21, 4, '21.21.25', '516 Updating Direktori Usaha/Perusahaan Ekonomi Lanjutan'),
(26, 21, 4, '21.21.26', '519 Penyusunan Bahan Publisitas');

-- --------------------------------------------------------

--
-- Table structure for table `subkomponen`
--

CREATE TABLE `subkomponen` (
  `id` int(11) NOT NULL,
  `komponen_id` int(11) NOT NULL,
  `tahun_aktif_id` int(11) NOT NULL,
  `kode` varchar(50) DEFAULT NULL,
  `nama_subkomponen` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `subkomponen`
--

INSERT INTO `subkomponen` (`id`, `komponen_id`, `tahun_aktif_id`, `kode`, `nama_subkomponen`) VALUES
(1, 1, 1, NULL, 'Subkomponen Honor Instruktur'),
(2, 1, 1, NULL, 'Subkomponen Honor Peserta'),
(3, 2, 1, NULL, 'Subkomponen Honor Pengawas'),
(4, 3, 1, NULL, 'Subkomponen Honor Pencacah'),
(11, 10, 3, NULL, 'qr3r'),
(12, 11, 4, '15.13.10.K11.SK12', '524113 Belanja Perjalanan Dinas Dalam Kota'),
(13, 12, 4, '16.14.11.K12.SK13', '524113 Belanja Perjalanan Dinas Dalam Kota'),
(14, 13, 4, '16.15.12.K13.SK14', '521211 Belanja Bahan'),
(15, 13, 4, '16.15.12.K13.SK15', '524111 Belanja Perjalanan Dinas Biasa'),
(16, 14, 4, '17.16.13.K14.SK16', '521213 Belanja Honor Output Kegiatan'),
(17, 14, 4, '17.16.13.K14.SK17', '524113 Belanja Perjalanan Dinas Dalam Kota'),
(18, 15, 4, '17.16.14.K15.SK18', '521211 Belanja Bahan'),
(19, 15, 4, '17.16.14.K15.SK19', '521811 Belanja Barang Persediaan Barang Konsumsi'),
(20, 15, 4, '17.16.14.K15.SK20', '524113 Belanja Perjalanan Dinas Dalam Kota'),
(21, 16, 4, '17.16.15.K16.SK21', '521213 Belanja Honor Output Kegiatan'),
(22, 17, 4, '18.17.16.K17.SK22', '521213 Belanja Honor Output Kegiatan'),
(23, 17, 4, '18.17.16.K17.SK23', '524113 Belanja Perjalanan Dinas Dalam Kota'),
(24, 18, 4, '18.17.17.K18.SK24', '521211 Belanja Bahan'),
(25, 18, 4, '18.17.17.K18.SK25', '521811 Belanja Barang Persediaan Barang Konsumsi'),
(26, 19, 4, '18.17.18.K19.SK26', '521213 Belanja Honor Output Kegiatan'),
(27, 19, 4, '18.17.18.K19.SK27', '524113 Belanja Perjalanan Dinas Dalam Kota'),
(28, 20, 4, '19.18.19.K20.SK28', '524113 Belanja Perjalanan Dinas Dalam Kota'),
(29, 21, 4, '20.19.20.K21.SK29', '532111 Belanja Modal Peralatan dan Mesin'),
(30, 22, 4, '21.20.21.K22.SK30', '521213 Belanja Honor Output Kegiatan'),
(31, 22, 4, '21.20.21.K22.SK31', '524113 Belanja Perjalanan Dinas Dalam Kota'),
(32, 23, 4, '21.20.22.K23.SK32', '524113 Belanja Perjalanan Dinas Dalam Kota'),
(33, 24, 4, '21.21.23.K24.SK33', '521213 Belanja Honor Output Kegiatan'),
(34, 25, 4, '21.21.24.K25.SK34', '521211 Belanja Bahan'),
(35, 25, 4, '21.21.24.K25.SK35', '521213 Belanja Honor Output Kegiatan'),
(36, 25, 4, '21.21.24.K25.SK36', '521219 Belanja Barang Non Operasional Lainnya'),
(37, 25, 4, '21.21.24.K25.SK37', '521811 Belanja Barang Persediaan Barang Konsumsi'),
(38, 25, 4, '21.21.24.K25.SK38', '524113 Belanja Perjalanan Dinas Dalam Kota'),
(39, 25, 4, '21.21.24.K25.SK39', '524114 Belanja Perjalanan Dinas Paket Meeting Dalam Kota'),
(40, 26, 4, '21.21.25.K26.SK40', '524113 Belanja Perjalanan Dinas Dalam Kota'),
(41, 27, 4, '21.21.26.K27.SK41', '521211 Belanja Bahan'),
(42, 27, 4, '21.21.26.K27.SK42', '524111 Belanja Perjalanan Dinas Biasa'),
(43, 27, 4, '21.21.26.K27.SK43', '524114 Belanja Perjalanan Dinas Paket Meeting Dalam Kota');

-- --------------------------------------------------------

--
-- Table structure for table `tahun_aktif`
--

CREATE TABLE `tahun_aktif` (
  `id` int(11) NOT NULL,
  `tahun` year(4) NOT NULL,
  `is_aktif` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tahun_aktif`
--

INSERT INTO `tahun_aktif` (`id`, `tahun`, `is_aktif`) VALUES
(1, '2025', 0),
(2, '2024', 0),
(3, '2021', 0),
(4, '2020', 1);

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  `is_admin` tinyint(1) DEFAULT 0,
  `nama_lengkap` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `password`, `is_admin`, `nama_lengkap`) VALUES
(1, 'adminbps', '$2y$10$0b13/nv1fStvMVhYfeSoiOZCucuEC2vrfyuGP9TQv.vdAdyCKgvPi', 1, 'Admin Utama'),
(2, 'admin', '$2y$10$y6AsUj/OzGgVasSQIqeioelmo.T6mC6Teuc.4m6HB.G5uIrnwe2pC', 1, 'Admin 81026'),
(3, 'ruth', '$2y$10$6IdLEONOhFVkpJeqwxgV2O8MA5G65ul8wBd3UYeldWLeh24qnlyb6', 0, 'Ruth Madeline');

-- --------------------------------------------------------

--
-- Table structure for table `wilayahtugas`
--

CREATE TABLE `wilayahtugas` (
  `id` bigint(20) NOT NULL,
  `kecamatan` varchar(100) NOT NULL,
  `kelurahan` varchar(100) NOT NULL,
  `kode_kec` varchar(3) DEFAULT NULL,
  `kode_kel` varchar(3) DEFAULT NULL,
  `kode_lengkap_wilayah` varchar(10) DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `wilayahtugas`
--

INSERT INTO `wilayahtugas` (`id`, `kecamatan`, `kelurahan`, `kode_kec`, `kode_kel`, `kode_lengkap_wilayah`, `latitude`, `longitude`) VALUES
(8102000000, 'Tual/Lainnya', 'Tual/Lainnya', NULL, NULL, NULL, NULL, NULL),
(8102010025, 'Kei Kecil', 'Ngabub', NULL, NULL, NULL, NULL, NULL),
(8102010026, 'Kei Kecil', 'Ibra', '010', '026', '8102010026', NULL, NULL),
(8102010030, 'Kei Kecil', 'Sathean', NULL, NULL, NULL, NULL, NULL),
(8102010035, 'Kei Kecil', 'Faan', NULL, NULL, NULL, NULL, NULL),
(8102010036, 'Kei Kecil', 'Ohoingur', NULL, NULL, NULL, NULL, NULL),
(8102010037, 'Kei Kecil', 'Kel. Ohoijang Watdek', NULL, NULL, NULL, NULL, NULL),
(8102010038, 'Kei Kecil', 'Kolser', NULL, NULL, NULL, NULL, NULL),
(8102010039, 'Kei Kecil', 'Kelanit', NULL, NULL, NULL, NULL, NULL),
(8102010042, 'Kei Kecil', 'Ohoidertawun', NULL, NULL, NULL, NULL, NULL),
(8102010043, 'Kei Kecil', 'Letman', '010', '043', '8102010043', NULL, NULL),
(8102010044, 'Kei Kecil', 'Wearlilir', NULL, NULL, NULL, NULL, NULL),
(8102010045, 'Kei Kecil', 'Loon', NULL, NULL, NULL, NULL, NULL),
(8102010046, 'Kei Kecil', 'Dudunwahan', NULL, NULL, NULL, NULL, NULL),
(8102010047, 'Kei Kecil', 'Ohoider Atas', NULL, NULL, NULL, NULL, NULL),
(8102010048, 'Kei Kecil', 'Sitniohoi', NULL, NULL, NULL, NULL, NULL),
(8102010049, 'Kei Kecil', 'Watdek', NULL, NULL, NULL, NULL, NULL),
(8102010050, 'Kei Kecil', 'Ohoijang', NULL, NULL, NULL, NULL, NULL),
(8102012001, 'Kei Kecil Barat', 'Ohoidertutu', NULL, NULL, NULL, NULL, NULL),
(8102012002, 'Kei Kecil Barat', 'Madwaer', NULL, NULL, NULL, NULL, NULL),
(8102012003, 'Kei Kecil Barat', 'Somlain', NULL, NULL, NULL, NULL, NULL),
(8102012004, 'Kei Kecil Barat', 'Ohoiren', NULL, NULL, NULL, NULL, NULL),
(8102012005, 'Kei Kecil Barat', 'Ohoira', NULL, NULL, NULL, NULL, NULL),
(8102012006, 'Kei Kecil Barat', 'Ur Pulau', NULL, NULL, NULL, NULL, NULL),
(8102012007, 'Kei Kecil Barat', 'Tanimbar Kei', NULL, NULL, NULL, NULL, NULL),
(8102012008, 'Kei Kecil Barat', 'Warbal', NULL, NULL, NULL, NULL, NULL),
(8102012009, 'Kei Kecil Barat', 'Ohoidertom', NULL, NULL, NULL, NULL, NULL),
(8102012010, 'Kei Kecil Barat', 'Yatwav', NULL, NULL, NULL, NULL, NULL),
(8102013007, 'Kei Kecil Timur', 'Mastur', NULL, NULL, NULL, NULL, NULL),
(8102013008, 'Kei Kecil Timur', 'Ohoinol', NULL, NULL, NULL, NULL, NULL),
(8102013009, 'Kei Kecil Timur', 'Wain', NULL, NULL, NULL, NULL, NULL),
(8102013010, 'Kei Kecil Timur', 'Abean', NULL, NULL, NULL, NULL, NULL),
(8102013011, 'Kei Kecil Timur', 'Raat', NULL, NULL, NULL, NULL, NULL),
(8102013012, 'Kei Kecil Timur', 'Rumat', NULL, NULL, NULL, NULL, NULL),
(8102013013, 'Kei Kecil Timur', 'Rewav', NULL, NULL, NULL, NULL, NULL),
(8102013014, 'Kei Kecil Timur', 'Mastur Baru', NULL, NULL, NULL, NULL, NULL),
(8102013015, 'Kei Kecil Timur', 'Ohoilus', NULL, NULL, NULL, NULL, NULL),
(8102013016, 'Kei Kecil Timur', 'Tenbuk', NULL, NULL, NULL, NULL, NULL),
(8102013017, 'Kei Kecil Timur', 'Denwet', NULL, NULL, NULL, NULL, NULL),
(8102013018, 'Kei Kecil Timur', 'Semawi', NULL, NULL, NULL, NULL, NULL),
(8102013019, 'Kei Kecil Timur', 'Iso', NULL, NULL, NULL, NULL, NULL),
(8102013020, 'Kei Kecil Timur', 'Wain Baru', NULL, NULL, NULL, NULL, NULL),
(8102013021, 'Kei Kecil Timur', 'Disuk', NULL, NULL, NULL, NULL, NULL),
(8102013022, 'Kei Kecil Timur', 'Marfun', NULL, NULL, NULL, NULL, NULL),
(8102013023, 'Kei Kecil Timur', 'Yafawun', NULL, NULL, NULL, NULL, NULL),
(8102013024, 'Kei Kecil Timur', 'Watngon', NULL, NULL, NULL, NULL, NULL),
(8102014001, 'Hoat Sorbay', 'Warwut', NULL, NULL, NULL, NULL, NULL),
(8102014002, 'Hoat Sorbay', 'Wab', NULL, NULL, NULL, NULL, NULL),
(8102014003, 'Hoat Sorbay', 'Arso', NULL, NULL, NULL, NULL, NULL),
(8102014004, 'Hoat Sorbay', 'Watngil', NULL, NULL, NULL, NULL, NULL),
(8102014005, 'Hoat Sorbay', 'Ohoibadar', NULL, NULL, NULL, NULL, NULL),
(8102014006, 'Hoat Sorbay', 'Evu', NULL, NULL, NULL, NULL, NULL),
(8102014007, 'Hoat Sorbay', 'Letvuan', NULL, NULL, NULL, NULL, NULL),
(8102014008, 'Hoat Sorbay', 'Tetoat', NULL, NULL, NULL, NULL, NULL),
(8102014009, 'Hoat Sorbay', 'Ngursit', NULL, NULL, NULL, NULL, NULL),
(8102014010, 'Hoat Sorbay', 'Madwat', NULL, NULL, NULL, NULL, NULL),
(8102014011, 'Hoat Sorbay', 'Wirin', NULL, NULL, NULL, NULL, NULL),
(8102014012, 'Hoat Sorbay', 'Dian Pulau', NULL, NULL, NULL, NULL, NULL),
(8102014013, 'Hoat Sorbay', 'Dian Darat', NULL, NULL, NULL, NULL, NULL),
(8102015001, 'Manyeuw', 'Rumadian', NULL, NULL, NULL, NULL, NULL),
(8102015002, 'Manyeuw', 'Debut', NULL, NULL, NULL, NULL, NULL),
(8102015003, 'Manyeuw', 'Namar', NULL, NULL, NULL, NULL, NULL),
(8102015004, 'Manyeuw', 'Lairngangas', NULL, NULL, NULL, NULL, NULL),
(8102015005, 'Manyeuw', 'Selayar', NULL, NULL, NULL, NULL, NULL),
(8102015006, 'Manyeuw', 'Ngayub', NULL, NULL, NULL, NULL, NULL),
(8102015007, 'Manyeuw', 'Ohoiluk', NULL, NULL, NULL, NULL, NULL),
(8102015008, 'Manyeuw', 'Ngilngof', NULL, NULL, NULL, NULL, NULL),
(8102015009, 'Manyeuw', 'Ohoililir', NULL, NULL, NULL, NULL, NULL),
(8102016001, 'Kei Kecil Timur Selatan', 'Ohoiseb', NULL, NULL, NULL, NULL, NULL),
(8102016002, 'Kei Kecil Timur Selatan', 'Sare', NULL, NULL, NULL, NULL, NULL),
(8102016003, 'Kei Kecil Timur Selatan', 'Uf', NULL, NULL, NULL, NULL, NULL),
(8102016004, 'Kei Kecil Timur Selatan', 'Mar', NULL, NULL, NULL, NULL, NULL),
(8102016005, 'Kei Kecil Timur Selatan', 'Danar Ternate', NULL, NULL, NULL, NULL, NULL),
(8102016006, 'Kei Kecil Timur Selatan', 'Lumefar', NULL, NULL, NULL, NULL, NULL),
(8102016007, 'Kei Kecil Timur Selatan', 'Ngursoin', NULL, NULL, NULL, NULL, NULL),
(8102016008, 'Kei Kecil Timur Selatan', 'Elaar Lamagorang', NULL, NULL, NULL, -5.908505528095615, 132.77927450793686),
(8102016009, 'Kei Kecil Timur Selatan', 'Elaar Let', NULL, NULL, NULL, NULL, NULL),
(8102016010, 'Kei Kecil Timur Selatan', 'Ngurwul', NULL, NULL, NULL, NULL, NULL),
(8102016011, 'Kei Kecil Timur Selatan', 'Garara', NULL, NULL, NULL, NULL, NULL),
(8102020015, 'Kei Besar', 'Ohoiwait', NULL, NULL, NULL, NULL, NULL),
(8102020016, 'Kei Besar', 'Ohoiel', NULL, NULL, NULL, NULL, NULL),
(8102020017, 'Kei Besar', 'Werka', NULL, NULL, NULL, NULL, NULL),
(8102020018, 'Kei Besar', 'Ler Ohoilim', NULL, NULL, NULL, NULL, NULL),
(8102020019, 'Kei Besar', 'Rahareng', NULL, NULL, NULL, NULL, NULL),
(8102020020, 'Kei Besar', 'Waur', NULL, NULL, NULL, NULL, NULL),
(8102020021, 'Kei Besar', 'Ngefuit', NULL, NULL, NULL, NULL, NULL),
(8102020022, 'Kei Besar', 'Waurtahait', NULL, NULL, NULL, NULL, NULL),
(8102020023, 'Kei Besar', 'Yamtel', NULL, NULL, NULL, NULL, NULL),
(8102020024, 'Kei Besar', 'Ohoinangan', NULL, NULL, NULL, NULL, NULL),
(8102020025, 'Kei Besar', 'Elat', NULL, NULL, NULL, NULL, NULL),
(8102020026, 'Kei Besar', 'Depur', NULL, NULL, NULL, NULL, NULL),
(8102020027, 'Kei Besar', 'Ohoilim', NULL, NULL, NULL, NULL, NULL),
(8102020028, 'Kei Besar', 'Fako', NULL, NULL, NULL, NULL, NULL),
(8102020029, 'Kei Besar', 'Reyamru', NULL, NULL, NULL, NULL, NULL),
(8102020030, 'Kei Besar', 'Elralang', NULL, NULL, NULL, NULL, NULL),
(8102020042, 'Kei Besar', 'Watuar', NULL, NULL, NULL, NULL, NULL),
(8102020043, 'Kei Besar', 'Mataholat', NULL, NULL, NULL, NULL, NULL),
(8102020044, 'Kei Besar', 'Harangur', NULL, NULL, NULL, NULL, NULL),
(8102020045, 'Kei Besar', 'Udar', NULL, NULL, NULL, NULL, NULL),
(8102020046, 'Kei Besar', 'Daftel', NULL, NULL, NULL, NULL, NULL),
(8102020047, 'Kei Besar', 'Karkarit', NULL, NULL, NULL, NULL, NULL),
(8102020048, 'Kei Besar', 'Rahareng Atas', NULL, NULL, NULL, NULL, NULL),
(8102020049, 'Kei Besar', 'Wulurat', NULL, NULL, NULL, NULL, NULL),
(8102020050, 'Kei Besar', 'Ngefuit Atas', NULL, NULL, NULL, NULL, NULL),
(8102020051, 'Kei Besar', 'Nabaheng', NULL, NULL, NULL, NULL, NULL),
(8102020052, 'Kei Besar', 'Ohoiwang', NULL, NULL, NULL, NULL, NULL),
(8102020053, 'Kei Besar', 'Fangamas', NULL, NULL, NULL, NULL, NULL),
(8102020054, 'Kei Besar', 'Ohoinangan Atas', NULL, NULL, NULL, NULL, NULL),
(8102020055, 'Kei Besar', 'Wakol', NULL, NULL, NULL, NULL, NULL),
(8102020056, 'Kei Besar', 'Ngurdu', NULL, NULL, NULL, NULL, NULL),
(8102020057, 'Kei Besar', 'Soinrat', NULL, NULL, NULL, NULL, NULL),
(8102020058, 'Kei Besar', 'Wermaf', NULL, NULL, NULL, NULL, NULL),
(8102020059, 'Kei Besar', 'Bombay', NULL, NULL, NULL, NULL, NULL),
(8102020060, 'Kei Besar', 'Watsin', NULL, NULL, NULL, NULL, NULL),
(8102020061, 'Kei Besar', 'Sirbante', NULL, NULL, NULL, NULL, NULL),
(8102020062, 'Kei Besar', 'Ngat', NULL, NULL, NULL, NULL, NULL),
(8102021001, 'Kei Besar Utara Timur', 'Kilwair', NULL, NULL, NULL, NULL, NULL),
(8102021002, 'Kei Besar Utara Timur', 'Hollat', NULL, NULL, NULL, NULL, NULL),
(8102021003, 'Kei Besar Utara Timur', 'Ohoifau', NULL, NULL, NULL, NULL, NULL),
(8102021004, 'Kei Besar Utara Timur', 'Kilwair', NULL, NULL, NULL, NULL, NULL),
(8102021005, 'Kei Besar Utara Timur', 'Banda Eli', NULL, NULL, NULL, NULL, NULL),
(8102021006, 'Kei Besar Utara Timur', 'Renfaan', NULL, NULL, NULL, NULL, NULL),
(8102021007, 'Kei Besar Utara Timur', 'Langgiar Haar', NULL, NULL, NULL, NULL, NULL),
(8102021008, 'Kei Besar Utara Timur', 'Haar Ohoimel', NULL, NULL, NULL, NULL, NULL),
(8102021009, 'Kei Besar Utara Timur', 'Ohoiraut', NULL, NULL, NULL, NULL, NULL),
(8102021010, 'Kei Besar Utara Timur', 'Ohoiwirin', NULL, NULL, NULL, NULL, NULL),
(8102021011, 'Kei Besar Utara Timur', 'Tuburngil', NULL, NULL, NULL, NULL, NULL),
(8102021012, 'Kei Besar Utara Timur', 'Yamtimur', NULL, NULL, NULL, NULL, NULL),
(8102021013, 'Kei Besar Utara Timur', 'Hollat Solair', NULL, NULL, NULL, NULL, NULL),
(8102021014, 'Kei Besar Utara Timur', 'Hoko', NULL, NULL, NULL, NULL, NULL),
(8102021015, 'Kei Besar Utara Timur', 'Hollay', NULL, NULL, NULL, NULL, NULL),
(8102021016, 'Kei Besar Utara Timur', 'Ohoifaruan', NULL, NULL, NULL, NULL, NULL),
(8102021017, 'Kei Besar Utara Timur', 'Banda Efruan', NULL, NULL, NULL, NULL, NULL),
(8102021018, 'Kei Besar Utara Timur', 'Banda Suku Tiga Puluh', NULL, NULL, NULL, NULL, NULL),
(8102021019, 'Kei Besar Utara Timur', 'Tuburlay', NULL, NULL, NULL, NULL, NULL),
(8102021020, 'Kei Besar Utara Timur', 'Renfaan Islam', NULL, NULL, NULL, NULL, NULL),
(8102021021, 'Kei Besar Utara Timur', 'Renfaan GPM', NULL, NULL, NULL, NULL, NULL),
(8102021022, 'Kei Besar Utara Timur', 'Fanwav', NULL, NULL, NULL, NULL, NULL),
(8102021023, 'Kei Besar Utara Timur', 'Ur', NULL, NULL, NULL, NULL, NULL),
(8102021024, 'Kei Besar Utara Timur', 'Ohoimajang', NULL, NULL, NULL, NULL, NULL),
(8102021025, 'Kei Besar Utara Timur', 'Haar Renrahantel', NULL, NULL, NULL, NULL, NULL),
(8102021026, 'Kei Besar Utara Timur', 'Haar Ohoimur GPM', NULL, NULL, NULL, NULL, NULL),
(8102021027, 'Kei Besar Utara Timur', 'Haar Ohoimur RK', NULL, NULL, NULL, NULL, NULL),
(8102021028, 'Kei Besar Utara Timur', 'Haar Ohoiwait', NULL, NULL, NULL, NULL, NULL),
(8102021029, 'Kei Besar Utara Timur', 'Haar Wassar', NULL, NULL, NULL, NULL, NULL),
(8102021030, 'Kei Besar Utara Timur', 'Soin', NULL, NULL, NULL, NULL, NULL),
(8102022004, 'Kei Besar Selatan', 'Kilwat', NULL, NULL, NULL, NULL, NULL),
(8102022007, 'Kei Besar Selatan', 'Tamangil Nuhuyanat', NULL, NULL, NULL, NULL, NULL),
(8102022008, 'Kei Besar Selatan', 'Sather', NULL, NULL, NULL, NULL, NULL),
(8102022009, 'Kei Besar Selatan', 'Tutrean', NULL, NULL, NULL, NULL, NULL),
(8102022010, 'Kei Besar Selatan', 'Weduar', NULL, NULL, NULL, NULL, NULL),
(8102022011, 'Kei Besar Selatan', 'Tamangil Nuhuten', NULL, NULL, NULL, NULL, NULL),
(8102022012, 'Kei Besar Selatan', 'Larat', NULL, NULL, NULL, NULL, NULL),
(8102022013, 'Kei Besar Selatan', 'Nerong', NULL, NULL, NULL, NULL, NULL),
(8102022014, 'Kei Besar Selatan', 'Ohoirenan', NULL, NULL, NULL, NULL, NULL),
(8102022015, 'Kei Besar Selatan', 'Soindat', NULL, NULL, NULL, NULL, NULL),
(8102023001, 'Kei Besar Utara Barat', 'Weer Ohoinam', NULL, NULL, NULL, NULL, NULL),
(8102023002, 'Kei Besar Utara Barat', 'Weer Ohoiker', NULL, NULL, NULL, NULL, NULL),
(8102023003, 'Kei Besar Utara Barat', 'Weer Frawav', NULL, NULL, NULL, NULL, NULL),
(8102023004, 'Kei Besar Utara Barat', 'Faa', NULL, NULL, NULL, NULL, NULL),
(8102023005, 'Kei Besar Utara Barat', 'Dangarat', NULL, NULL, NULL, NULL, NULL),
(8102023006, 'Kei Besar Utara Barat', 'Ohoituf', NULL, NULL, NULL, NULL, NULL),
(8102023007, 'Kei Besar Utara Barat', 'Hangur', NULL, NULL, NULL, NULL, NULL),
(8102023008, 'Kei Besar Utara Barat', 'Ngurwalek', NULL, NULL, NULL, NULL, NULL),
(8102023009, 'Kei Besar Utara Barat', 'Uwat', NULL, NULL, NULL, NULL, NULL),
(8102023010, 'Kei Besar Utara Barat', 'Uwat Wear', NULL, NULL, NULL, NULL, NULL),
(8102023011, 'Kei Besar Utara Barat', 'Uwat Reyaan', NULL, NULL, NULL, NULL, NULL),
(8102023012, 'Kei Besar Utara Barat', 'Mun Ohoitadium', NULL, NULL, NULL, NULL, NULL),
(8102023013, 'Kei Besar Utara Barat', 'Mun Werfan', NULL, NULL, NULL, NULL, NULL),
(8102023014, 'Kei Besar Utara Barat', 'Mun Ohoiir', NULL, NULL, NULL, NULL, NULL),
(8102023015, 'Kei Besar Utara Barat', 'Mun Esoy', NULL, NULL, NULL, NULL, NULL),
(8102023016, 'Kei Besar Utara Barat', 'Mun Kahar', NULL, NULL, NULL, NULL, NULL),
(8102023017, 'Kei Besar Utara Barat', 'Mun Ngurditwain', NULL, NULL, NULL, NULL, NULL),
(8102023018, 'Kei Besar Utara Barat', 'Ad Wearaur', NULL, NULL, NULL, NULL, NULL),
(8102023019, 'Kei Besar Utara Barat', 'Ad Ngurwul', NULL, NULL, NULL, NULL, NULL),
(8102023020, 'Kei Besar Utara Barat', 'Ad Ohoiwaf', NULL, NULL, NULL, NULL, NULL),
(8102023021, 'Kei Besar Utara Barat', 'Lar', NULL, NULL, NULL, NULL, NULL),
(8102023022, 'Kei Besar Utara Barat', 'Hoor Islam', NULL, NULL, NULL, NULL, NULL),
(8102023023, 'Kei Besar Utara Barat', 'Hoor Kristen', NULL, NULL, NULL, NULL, NULL),
(8102023024, 'Kei Besar Utara Barat', 'Waer', NULL, NULL, NULL, NULL, NULL),
(8102023025, 'Kei Besar Utara Barat', 'Waerat', NULL, NULL, NULL, NULL, NULL),
(8102024001, 'Kei Besar Selatan Barat', 'Weduar Feer', NULL, NULL, NULL, NULL, NULL),
(8102024002, 'Kei Besar Selatan Barat', 'Rahangiar', NULL, NULL, NULL, NULL, NULL),
(8102024003, 'Kei Besar Selatan Barat', 'Uat', NULL, NULL, NULL, NULL, NULL),
(8102024004, 'Kei Besar Selatan Barat', 'Ngan', NULL, NULL, NULL, NULL, NULL),
(8102024005, 'Kei Besar Selatan Barat', 'Ohoilean', NULL, NULL, NULL, NULL, NULL),
(8102024006, 'Kei Besar Selatan Barat', 'Wafol', NULL, NULL, NULL, NULL, NULL),
(8102024007, 'Kei Besar Selatan Barat', 'Watkidat', NULL, NULL, NULL, NULL, NULL),
(8102024008, 'Kei Besar Selatan Barat', 'Feer', NULL, NULL, NULL, NULL, NULL),
(8102024009, 'Kei Besar Selatan Barat', 'Rerean', NULL, NULL, NULL, NULL, NULL),
(8102024010, 'Kei Besar Selatan Barat', 'Ngurko', NULL, NULL, NULL, NULL, NULL),
(8102024011, 'Kei Besar Selatan Barat', 'Hako', NULL, NULL, NULL, NULL, NULL),
(8102024012, 'Kei Besar Selatan Barat', 'Ngafan', NULL, NULL, NULL, NULL, NULL),
(8102024013, 'Kei Besar Selatan Barat', 'Hoat', NULL, NULL, NULL, NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `aktivitas_kerja`
--
ALTER TABLE `aktivitas_kerja`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mitra_id` (`mitra_id`),
  ADD KEY `detail_kegiatan_id` (`nama_aktivitas_id`),
  ADD KEY `fk_aktivitas_tahun` (`tahun_aktif_id`),
  ADD KEY `fk_ak_wilayah_tugas` (`wilayah_tugas_id`);

--
-- Indexes for table `detail_kegiatan`
--
ALTER TABLE `detail_kegiatan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tahun_aktif_id` (`tahun_aktif_id`),
  ADD KEY `fk_detail_kegiatan_subkomponen` (`subkomponen_id`);

--
-- Indexes for table `kegiatan`
--
ALTER TABLE `kegiatan`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_kegiatan_tahun` (`tahun_aktif_id`,`kode`),
  ADD KEY `fk_kegiatan_program` (`program_id`);

--
-- Indexes for table `komponen`
--
ALTER TABLE `komponen`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tahun_aktif_id` (`tahun_aktif_id`),
  ADD KEY `fk_komponen_subkegiatan` (`subkegiatan_id`);

--
-- Indexes for table `mitra`
--
ALTER TABLE `mitra`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_nik_tahun` (`nik`,`tahun_aktif_id`),
  ADD KEY `tahun_aktif_id` (`tahun_aktif_id`),
  ADD KEY `fk_mitra_domisili_wilayah` (`domisili_wilayah_id`);

--
-- Indexes for table `nama_aktivitas_master`
--
ALTER TABLE `nama_aktivitas_master`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_nama_aktivitas_master_detail` (`detail_kegiatan_id`);

--
-- Indexes for table `program`
--
ALTER TABLE `program`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uk_program_tahun` (`tahun_aktif_id`,`kode`);

--
-- Indexes for table `subkegiatan`
--
ALTER TABLE `subkegiatan`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tahun_aktif_id` (`tahun_aktif_id`),
  ADD KEY `fk_subkegiatan_kegiatan` (`kegiatan_id`);

--
-- Indexes for table `subkomponen`
--
ALTER TABLE `subkomponen`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tahun_aktif_id` (`tahun_aktif_id`),
  ADD KEY `fk_subkomponen_komponen` (`komponen_id`);

--
-- Indexes for table `tahun_aktif`
--
ALTER TABLE `tahun_aktif`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tahun` (`tahun`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`);

--
-- Indexes for table `wilayahtugas`
--
ALTER TABLE `wilayahtugas`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `aktivitas_kerja`
--
ALTER TABLE `aktivitas_kerja`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `detail_kegiatan`
--
ALTER TABLE `detail_kegiatan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=72;

--
-- AUTO_INCREMENT for table `kegiatan`
--
ALTER TABLE `kegiatan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `komponen`
--
ALTER TABLE `komponen`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `mitra`
--
ALTER TABLE `mitra`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1051;

--
-- AUTO_INCREMENT for table `nama_aktivitas_master`
--
ALTER TABLE `nama_aktivitas_master`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `program`
--
ALTER TABLE `program`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `subkegiatan`
--
ALTER TABLE `subkegiatan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `subkomponen`
--
ALTER TABLE `subkomponen`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `tahun_aktif`
--
ALTER TABLE `tahun_aktif`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `aktivitas_kerja`
--
ALTER TABLE `aktivitas_kerja`
  ADD CONSTRAINT `aktivitas_kerja_ibfk_1` FOREIGN KEY (`mitra_id`) REFERENCES `mitra` (`id`),
  ADD CONSTRAINT `fk_ak_wilayah_tugas` FOREIGN KEY (`wilayah_tugas_id`) REFERENCES `wilayahtugas` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_aktivitas_tahun` FOREIGN KEY (`tahun_aktif_id`) REFERENCES `tahun_aktif` (`id`);

--
-- Constraints for table `detail_kegiatan`
--
ALTER TABLE `detail_kegiatan`
  ADD CONSTRAINT `detail_kegiatan_ibfk_2` FOREIGN KEY (`tahun_aktif_id`) REFERENCES `tahun_aktif` (`id`),
  ADD CONSTRAINT `fk_detail_kegiatan_subkomponen` FOREIGN KEY (`subkomponen_id`) REFERENCES `subkomponen` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `kegiatan`
--
ALTER TABLE `kegiatan`
  ADD CONSTRAINT `fk_kegiatan_program` FOREIGN KEY (`program_id`) REFERENCES `program` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `kegiatan_ibfk_2` FOREIGN KEY (`tahun_aktif_id`) REFERENCES `tahun_aktif` (`id`);

--
-- Constraints for table `komponen`
--
ALTER TABLE `komponen`
  ADD CONSTRAINT `fk_komponen_subkegiatan` FOREIGN KEY (`subkegiatan_id`) REFERENCES `subkegiatan` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `komponen_ibfk_2` FOREIGN KEY (`tahun_aktif_id`) REFERENCES `tahun_aktif` (`id`);

--
-- Constraints for table `mitra`
--
ALTER TABLE `mitra`
  ADD CONSTRAINT `fk_mitra_domisili_wilayah` FOREIGN KEY (`domisili_wilayah_id`) REFERENCES `wilayahtugas` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `mitra_ibfk_1` FOREIGN KEY (`tahun_aktif_id`) REFERENCES `tahun_aktif` (`id`);

--
-- Constraints for table `nama_aktivitas_master`
--
ALTER TABLE `nama_aktivitas_master`
  ADD CONSTRAINT `fk_nama_aktivitas_master_detail` FOREIGN KEY (`detail_kegiatan_id`) REFERENCES `detail_kegiatan` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `program`
--
ALTER TABLE `program`
  ADD CONSTRAINT `program_ibfk_1` FOREIGN KEY (`tahun_aktif_id`) REFERENCES `tahun_aktif` (`id`);

--
-- Constraints for table `subkegiatan`
--
ALTER TABLE `subkegiatan`
  ADD CONSTRAINT `fk_subkegiatan_kegiatan` FOREIGN KEY (`kegiatan_id`) REFERENCES `kegiatan` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `subkomponen`
--
ALTER TABLE `subkomponen`
  ADD CONSTRAINT `fk_subkomponen_komponen` FOREIGN KEY (`komponen_id`) REFERENCES `komponen` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `subkomponen_ibfk_2` FOREIGN KEY (`tahun_aktif_id`) REFERENCES `tahun_aktif` (`id`);
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 */;
