-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Sep 09, 2026 at 07:35 AM
-- Server version: 8.4.3
-- PHP Version: 8.3.26

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: `log-marketing`
--

-- --------------------------------------------------------

--
-- Table structure for table `event`
--

CREATE TABLE `event` (
  `id_event` int NOT NULL,
  `id_user` int DEFAULT NULL,
  `id_provinsi` int DEFAULT NULL,
  `id_kabupaten` int DEFAULT NULL,
  `id_kecamatan` int DEFAULT NULL,
  `nama_event` varchar(200) NOT NULL,
  `jenis_event` varchar(100) DEFAULT NULL,
  `status_event` enum('Akan Datang','Berlangsung','Selesai') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `target` varchar(150) DEFAULT NULL,
  `tempat_event` varchar(255) DEFAULT NULL,
  `tanggal_event` date DEFAULT NULL,
  `waktu_event` time DEFAULT NULL,
  `latitude` decimal(10,8) DEFAULT NULL,
  `longitude` decimal(11,8) DEFAULT NULL,
  `deskripsi` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `event`
--

INSERT INTO `event` (`id_event`, `id_user`, `id_provinsi`, `id_kabupaten`, `id_kecamatan`, `nama_event`, `jenis_event`, `status_event`, `target`, `tempat_event`, `tanggal_event`, `waktu_event`, `latitude`, `longitude`, `deskripsi`, `created_at`, `updated_at`) VALUES
(1, 2, 1, 1, 155, 'Seminar Umrah Jawa Barat', 'Seminar', 'Akan Datang', 'Calon Jamaah', 'Gedung Serbaguna Bandung', '2026-09-10', '09:00:00', NULL, NULL, 'Seminar pengenalan program umrah untuk calon jamaah.', '2026-08-26 07:32:43', '2026-08-26 07:32:43'),
(2, 2, 1, 1, 155, 'Manasik Umrah Perdana', 'Manasik', 'Akan Datang', 'Jamaah Umrah', 'Masjid Al-Ikhlas Bandung', '2026-09-15', '08:00:00', NULL, NULL, 'Kegiatan manasik untuk persiapan keberangkatan jamaah.', '2026-08-26 07:32:43', '2026-08-26 07:32:43'),
(3, 2, 1, 6, 1, 'Sosialisasi Program Umrah', 'Sosialisasi', 'Berlangsung', 'Masyarakat Umum', 'Gedung Dakwah Cianjur', '2026-08-30', '10:00:00', NULL, NULL, 'Sosialisasi program perjalanan umrah dan wisata religi.', '2026-08-26 07:32:43', '2026-08-26 07:32:43'),
(4, 2, 1, 8, 1, 'Gathering Jamaah Umrah', 'Gathering', 'Selesai', 'Jamaah Umrah', 'Aula Al-Hikmah Garut', '2026-08-20', '13:00:00', NULL, NULL, 'Gathering dan silaturahmi bersama jamaah umrah.', '2026-08-26 07:32:43', '2026-08-26 07:32:43'),
(5, 2, 1, 16, 1, 'Kajian Persiapan Umrah', 'Kajian', 'Akan Datang', 'Calon Jamaah', 'Masjid Raya Sukabumi', '2026-09-20', '09:30:00', NULL, NULL, 'Kajian mengenai persiapan ibadah dan perjalanan umrah.', '2026-08-26 07:32:43', '2026-08-26 07:32:43'),
(6, 2, 1, 24, 1, 'Open Table Rizma Tour', 'Open Table', 'Akan Datang', 'Masyarakat Umum', 'Mall Kota Cirebon', '2026-09-25', '10:00:00', NULL, NULL, 'Konsultasi langsung mengenai paket perjalanan umrah.', '2026-08-26 07:32:43', '2026-08-26 07:32:43'),
(7, 2, 1, 21, 1, 'Promosi Paket Umrah 2026', 'Promosi', 'Berlangsung', 'Calon Jamaah', 'Mall Kota Bekasi', '2026-08-28', '11:00:00', NULL, NULL, 'Promosi paket perjalanan umrah tahun 2026.', '2026-08-26 07:32:43', '2026-08-26 07:32:43'),
(8, 2, 1, 19, 1, 'Pameran Travel dan Umrah', 'Pameran', 'Akan Datang', 'Calon Jamaah', 'Convention Hall Bandung', '2026-10-05', '09:00:00', NULL, NULL, 'Pameran paket perjalanan umrah dan wisata religi.', '2026-08-26 07:32:43', '2026-08-26 07:32:43'),
(9, 2, 1, 27, 1, 'Temu Jamaah dan Evaluasi', 'Pertemuan', 'Selesai', 'Jamaah Umrah', 'Aula Masjid Tasikmalaya', '2026-08-18', '15:00:00', NULL, NULL, 'Pertemuan dan evaluasi pelayanan bersama jamaah.', '2026-08-26 07:32:43', '2026-08-26 07:32:43'),
(10, 2, 1, 2, 1, 'Workshop Pelayanan Jamaah', 'Workshop', 'Akan Datang', 'Tim Marketing', 'Hotel Bandung Barat', '2026-10-12', '08:30:00', NULL, NULL, 'Workshop peningkatan kualitas pelayanan dan komunikasi dengan calon jamaah.', '2026-08-26 07:32:43', '2026-08-26 07:32:43');

-- --------------------------------------------------------

--
-- Table structure for table `event_jamaah`
--

CREATE TABLE `event_jamaah` (
  `id_event_jamaah` int NOT NULL,
  `id_event` int NOT NULL,
  `nama_jamaah` varchar(255) NOT NULL,
  `no_hp_jamaah` varchar(255) NOT NULL,
  `email_jamaah` varchar(255) DEFAULT NULL,
  `alamat_jamaah` varchar(255) DEFAULT NULL,
  `status_jamaah` enum('prospek','minat','closing') DEFAULT NULL,
  `metode_pembayaran` enum('transfer','cash') DEFAULT NULL,
  `nominal_pembayaran` int DEFAULT NULL,
  `bukti_pembayaran` varchar(255) DEFAULT NULL,
  `foto_ktp_jamaah` varchar(255) DEFAULT NULL,
  `foto_kk_jamaah` varchar(255) DEFAULT NULL,
  `dokumen_tambahan` varchar(255) DEFAULT NULL,
  `status_kehadiran` enum('hadir','tidak hadir') DEFAULT 'tidak hadir',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `event_jamaah`
--

INSERT INTO `event_jamaah` (`id_event_jamaah`, `id_event`, `nama_jamaah`, `no_hp_jamaah`, `email_jamaah`, `alamat_jamaah`, `status_jamaah`, `metode_pembayaran`, `nominal_pembayaran`, `bukti_pembayaran`, `foto_ktp_jamaah`, `foto_kk_jamaah`, `dokumen_tambahan`, `status_kehadiran`, `created_at`, `updated_at`) VALUES
(1, 4, 'Ahmad Fauzi', '081234567901', 'ahmad.fauzi@mail.com', 'Jl. Merdeka No. 10, Garut', 'closing', 'transfer', 12500000, 'buktitf_ahmad.jpg', 'ktp_ahmad.jpg', 'kk_ahmad.jpg', 'paspor_ahmad.pdf', 'hadir', '2026-08-20 05:30:00', '2026-08-20 08:00:00'),
(2, 4, 'Dewi Sartika', '081234567902', 'dewi.sartika@mail.com', 'Jl. Pahlawan No. 5, Garut', 'minat', 'cash', 5000000, 'cash_dewi.jpg', 'ktp_dewi.jpg', 'kk_dewi.jpg', NULL, 'hadir', '2026-08-20 05:45:00', '2026-08-20 07:30:00'),
(3, 4, 'Rahmat Hidayat', '081234567903', 'rahmat@mail.com', 'Jl. Siliwangi No. 23, Cianjur', 'prospek', NULL, NULL, NULL, 'ktp_rahmat.jpg', 'kk_rahmat.jpg', NULL, 'tidak hadir', '2026-08-20 04:00:00', '2026-08-20 06:00:00'),
(4, 9, 'Siti Aminah', '081234567904', 'siti.aminah@mail.com', 'Jl. Diponegoro No. 8, Tasikmalaya', 'closing', 'transfer', 15000000, 'buktitf_siti.jpg', 'ktp_siti.jpg', 'kk_siti.jpg', 'visa_siti.pdf', 'hadir', '2026-08-18 07:30:00', '2026-08-18 11:00:00'),
(5, 9, 'Agus Salim', '081234567905', 'agus.salim@mail.com', 'Jl. Sudirman No. 45, Cirebon', 'minat', 'cash', 7500000, 'cash_agus.jpg', 'ktp_agus.jpg', 'kk_agus.jpg', NULL, 'hadir', '2026-08-18 07:45:00', '2026-08-18 10:30:00'),
(6, 9, 'Rina Marlina', '081234567906', 'rina@mail.com', 'Jl. Veteran No. 12, Sukabumi', 'prospek', NULL, NULL, NULL, 'ktp_rina.jpg', 'kk_rina.jpg', NULL, 'tidak hadir', '2026-08-18 06:30:00', '2026-08-18 09:00:00'),
(7, 3, 'Hasan Basri', '081234567907', 'hasan@mail.com', 'Jl. Ahmad Yani No. 99, Cianjur', 'minat', 'transfer', 3000000, 'buktitf_hasan.jpg', 'ktp_hasan.jpg', 'kk_hasan.jpg', NULL, 'hadir', '2026-08-30 02:30:00', '2026-08-30 05:00:00'),
(8, 3, 'Lilis Suryani', '081234567908', 'lilis@mail.com', 'Jl. Gajah Mada No. 77, Bogor', 'prospek', NULL, NULL, NULL, 'ktp_lilis.jpg', 'kk_lilis.jpg', NULL, 'hadir', '2026-08-30 02:45:00', '2026-08-30 04:30:00'),
(9, 7, 'Muhammad Iqbal', '081234567909', 'iqbal@mail.com', 'Jl. Raya Bekasi No. 15, Bekasi', 'closing', 'transfer', 20000000, 'buktitf_iqbal.jpg', 'ktp_iqbal.jpg', 'kk_iqbal.jpg', 'surat_pernyataan.pdf', 'hadir', '2026-08-28 03:15:00', '2026-08-28 07:00:00'),
(10, 7, 'Diana Putri', '081234567910', 'diana@mail.com', 'Jl. Kemang Raya No. 3, Jakarta', 'minat', 'cash', 5000000, 'cash_diana.jpg', 'ktp_diana.jpg', 'kk_diana.jpg', NULL, 'hadir', '2026-08-28 03:30:00', '2026-08-28 06:00:00'),
(11, 7, 'Bambang Suprapto', '081234567911', 'bambang@mail.com', 'Jl. Karang Anyar No. 20, Bekasi', 'prospek', NULL, NULL, NULL, 'ktp_bambang.jpg', 'kk_bambang.jpg', NULL, 'tidak hadir', '2026-08-28 02:45:00', '2026-08-28 04:00:00'),
(12, 1, 'Faisal Rahman', '081234567912', 'faisal@mail.com', 'Jl. Cihampelas No. 33, Bandung', 'prospek', NULL, NULL, NULL, 'ktp_faisal.jpg', 'kk_faisal.jpg', NULL, 'tidak hadir', '2026-09-10 01:30:00', '2026-09-10 01:30:00'),
(13, 1, 'Nurul Hikmah', '081234567913', 'nurul@mail.com', 'Jl. Setiabudi No. 21, Bandung', 'minat', 'transfer', 1000000, 'buktitf_nurul.jpg', 'ktp_nurul.jpg', 'kk_nurul.jpg', NULL, 'tidak hadir', '2026-09-10 01:45:00', '2026-09-10 01:45:00'),
(14, 5, 'Rudi Hartono', '081234567914', 'rudi@mail.com', 'Jl. Pelita No. 9, Sukabumi', 'prospek', NULL, NULL, NULL, 'ktp_rudi.jpg', 'kk_rudi.jpg', NULL, 'tidak hadir', '2026-09-20 02:00:00', '2026-09-20 02:00:00'),
(15, 6, 'Eka Susanti', '081234567915', 'eka@mail.com', 'Jl. K.H. Hasyim Ashari No. 44, Cirebon', 'minat', 'cash', 2500000, 'cash_eka.jpg', 'ktp_eka.jpg', 'kk_eka.jpg', NULL, 'tidak hadir', '2026-09-25 02:30:00', '2026-09-25 02:30:00');

-- --------------------------------------------------------

--
-- Table structure for table `event_user`
--

CREATE TABLE `event_user` (
  `id_event_user` int NOT NULL,
  `id_event` int NOT NULL,
  `id_user` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `event_user`
--

INSERT INTO `event_user` (`id_event_user`, `id_event`, `id_user`) VALUES
(1, 1, 2),
(3, 2, 2),
(4, 3, 2),
(6, 4, 2),
(8, 6, 2),
(9, 7, 2),
(12, 9, 2),
(13, 10, 2);

-- --------------------------------------------------------

--
-- Table structure for table `hasil_event`
--

CREATE TABLE `hasil_event` (
  `id_hasil_event` int NOT NULL,
  `id_event` int NOT NULL,
  `jumlah_kehadiran` int DEFAULT '0',
  `catatan` text,
  `dokumentasi` varchar(255) DEFAULT NULL,
  `tanggal_input` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `hasil_event`
--

INSERT INTO `hasil_event` (`id_hasil_event`, `id_event`, `jumlah_kehadiran`, `catatan`, `dokumentasi`, `tanggal_input`, `created_at`, `updated_at`) VALUES
(1, 4, 42, 'Gathering berjalan lancar, antusiasme tinggi. 2 jamaah closing, beberapa minat.', 'dokumentasi_gathering_garut.jpg', '2026-08-21', '2026-08-21 01:00:00', '2026-08-21 01:00:00'),
(2, 9, 28, 'Evaluasi pelayanan: saran perbaikan fasilitas dan pendampingan. Banyak masukan positif.', 'dokumentasi_evaluasi_tasik.jpg', '2026-08-19', '2026-08-19 03:00:00', '2026-08-19 03:00:00'),
(3, 3, 55, 'Sosialisasi program umrah dihadiri masyarakat umum, antusiasme tinggi terutama paket umrah plus wisata.', 'dokumentasi_sosialisasi_cianjur.jpg', '2026-08-31', '2026-08-31 02:00:00', '2026-08-31 02:00:00'),
(4, 7, 38, 'Promosi di Mall Bekasi, pengunjung ramai. Banyak yang minta konsultasi lanjutan.', 'dokumentasi_promosi_bekasi.jpg', '2026-08-29', '2026-08-29 04:00:00', '2026-08-29 04:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `hasil_kegiatan`
--

CREATE TABLE `hasil_kegiatan` (
  `id_hasil_kegiatan` int NOT NULL,
  `id_kegiatan` int NOT NULL,
  `nama_jamaah` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `no_hp_jamaah` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `email_jamaah` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `status_jamaah` enum('Prospek','Minat','Closing') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `metode_pembayaran` enum('Transfer','Cash') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `nominal_pembayaran` int DEFAULT NULL,
  `bukti_pembayaran` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `kendala` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `lat_jamaah` decimal(10,8) DEFAULT NULL,
  `lng_jamaah` decimal(11,8) DEFAULT NULL,
  `bukti_kegiatan` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `foto_kk_jamaah` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `foto_ktp_jamaah` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `dokumen_tambahan` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `hasil_kegiatan`
--

INSERT INTO `hasil_kegiatan` (`id_hasil_kegiatan`, `id_kegiatan`, `nama_jamaah`, `no_hp_jamaah`, `email_jamaah`, `status_jamaah`, `metode_pembayaran`, `nominal_pembayaran`, `bukti_pembayaran`, `kendala`, `lat_jamaah`, `lng_jamaah`, `bukti_kegiatan`, `foto_kk_jamaah`, `foto_ktp_jamaah`, `dokumen_tambahan`) VALUES
(1, 1, 'Budi Santoso', '081234567893', 'budi@mail.com', 'Minat', 'Transfer', 5000000, 'buktitf_budi.jpg', 'Tidak ada kendala', -6.97000000, 107.63000000, 'dokumentasi_umrah1.jpg', 'kk_budi.jpg', 'ktp_budi.jpg', 'paspor_budi.pdf'),
(2, 2, 'Siti Fatimah', '081234567894', 'siti@mail.com', 'Closing', 'Cash', 15000000, 'cash_siti.jpg', '-', -6.20000000, 106.80000000, 'dokumentasi_haji1.jpg', 'kk_siti.jpg', 'ktp_siti.jpg', 'visa_haji_siti.pdf'),
(3, 3, 'Andi Wijaya', '081234567895', 'andi@mail.com', 'Prospek', 'Transfer', 2500000, 'buktitf_andi.jpg', 'Masih menunggu persetujuan istri', -6.97000000, 107.63000000, 'dokumentasi_wisata1.jpg', 'kk_andi.jpg', 'ktp_andi.jpg', 'paspor_andi.jpdf');

-- --------------------------------------------------------

--
-- Table structure for table `kabupaten`
--

CREATE TABLE `kabupaten` (
  `id_kabupaten` int NOT NULL,
  `id_provinsi` int NOT NULL,
  `nama_kabupaten` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kabupaten`
--

INSERT INTO `kabupaten` (`id_kabupaten`, `id_provinsi`, `nama_kabupaten`) VALUES
(1, 1, 'Kabupaten Bandung'),
(2, 1, 'Kabupaten Bandung Barat'),
(3, 1, 'Kabupaten Bekasi'),
(4, 1, 'Kabupaten Bogor'),
(5, 1, 'Kabupaten Ciamis'),
(6, 1, 'Kabupaten Cianjur'),
(7, 1, 'Kabupaten Cirebon'),
(8, 1, 'Kabupaten Garut'),
(9, 1, 'Kabupaten Indramayu'),
(10, 1, 'Kabupaten Karawang'),
(11, 1, 'Kabupaten Kuningan'),
(12, 1, 'Kabupaten Majalengka'),
(13, 1, 'Kabupaten Pangandaran'),
(14, 1, 'Kabupaten Purwakarta'),
(15, 1, 'Kabupaten Subang'),
(16, 1, 'Kabupaten Sukabumi'),
(17, 1, 'Kabupaten Sumedang'),
(18, 1, 'Kabupaten Tasikmalaya'),
(19, 1, 'Kota Bandung'),
(20, 1, 'Kota Banjar'),
(21, 1, 'Kota Bekasi'),
(22, 1, 'Kota Bogor'),
(23, 1, 'Kota Cimahi'),
(24, 1, 'Kota Cirebon'),
(25, 1, 'Kota Depok'),
(26, 1, 'Kota Sukabumi'),
(27, 1, 'Kota Tasikmalaya');

-- --------------------------------------------------------

--
-- Table structure for table `kecamatan`
--

CREATE TABLE `kecamatan` (
  `id_kecamatan` int NOT NULL,
  `id_provinsi` int NOT NULL,
  `id_kabupaten` int NOT NULL,
  `nama_kecamatan` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kecamatan`
--

INSERT INTO `kecamatan` (`id_kecamatan`, `id_provinsi`, `id_kabupaten`, `nama_kecamatan`) VALUES
(1, 1, 1, 'Arjasari'),
(2, 1, 1, 'Baleendah'),
(3, 1, 1, 'Banjaran'),
(4, 1, 1, 'Bojongsoang'),
(5, 1, 1, 'Cangkuang'),
(6, 1, 1, 'Cicalengka'),
(7, 1, 1, 'Cikancung'),
(8, 1, 1, 'Cilengkrang'),
(9, 1, 1, 'Cileunyi'),
(10, 1, 1, 'Cimaung'),
(11, 1, 1, 'Cimenyan'),
(12, 1, 1, 'Ciparay'),
(13, 1, 1, 'Ciwidey'),
(14, 1, 1, 'Dayeuhkolot'),
(15, 1, 1, 'Ibun'),
(16, 1, 1, 'Katapang'),
(17, 1, 1, 'Kertasari'),
(18, 1, 1, 'Kutawaringin'),
(19, 1, 1, 'Majalaya'),
(20, 1, 1, 'Margaasih'),
(21, 1, 1, 'Margahayu'),
(22, 1, 1, 'Nagreg'),
(23, 1, 1, 'Pacet'),
(24, 1, 1, 'Pameungpeuk'),
(25, 1, 1, 'Pangalengan'),
(26, 1, 1, 'Paseh'),
(27, 1, 1, 'Pasirjambu'),
(28, 1, 1, 'Rancaekek'),
(29, 1, 1, 'Rancabali'),
(30, 1, 1, 'Solokanjeruk'),
(31, 1, 1, 'Soreang'),
(32, 1, 2, 'Batujajar'),
(33, 1, 2, 'Cihampelas'),
(34, 1, 2, 'Cikalongwetan'),
(35, 1, 2, 'Cililin'),
(36, 1, 2, 'Cipatat'),
(37, 1, 2, 'Cipeundeuy'),
(38, 1, 2, 'Cipongkor'),
(39, 1, 2, 'Cisarua'),
(40, 1, 2, 'Gununghalu'),
(41, 1, 2, 'Lembang'),
(42, 1, 2, 'Ngamprah'),
(43, 1, 2, 'Padalarang'),
(44, 1, 2, 'Parongpong'),
(45, 1, 2, 'Rongga'),
(46, 1, 2, 'Sindangkerta'),
(47, 1, 2, 'Saguling'),
(48, 1, 3, 'Babelan'),
(49, 1, 3, 'Bojongmangu'),
(50, 1, 3, 'Cabangbungin'),
(51, 1, 3, 'Cibarusah'),
(52, 1, 3, 'Cibitung'),
(53, 1, 3, 'Cikarang Barat'),
(54, 1, 3, 'Cikarang Pusat'),
(55, 1, 3, 'Cikarang Selatan'),
(56, 1, 3, 'Cikarang Timur'),
(57, 1, 3, 'Cikarang Utara'),
(58, 1, 3, 'Karangbahagia'),
(59, 1, 3, 'Kedungwaringin'),
(60, 1, 3, 'Muaragembong'),
(61, 1, 3, 'Pebayuran'),
(62, 1, 3, 'Serang Baru'),
(63, 1, 3, 'Setu'),
(64, 1, 3, 'Sukakarya'),
(65, 1, 3, 'Sukatani'),
(66, 1, 3, 'Sukawangi'),
(67, 1, 3, 'Tambelang'),
(68, 1, 3, 'Tambun Selatan'),
(69, 1, 3, 'Tambun Utara'),
(70, 1, 3, 'Tarumajaya'),
(71, 1, 4, 'Babakan Madang'),
(72, 1, 4, 'Bojonggede'),
(73, 1, 4, 'Caringin'),
(74, 1, 4, 'Cariu'),
(75, 1, 4, 'Ciampea'),
(76, 1, 4, 'Ciawi'),
(77, 1, 4, 'Cibinong'),
(78, 1, 4, 'Cibungbulang'),
(79, 1, 4, 'Cijeruk'),
(80, 1, 4, 'Cileungsi'),
(81, 1, 4, 'Ciomas'),
(82, 1, 4, 'Cisarua'),
(83, 1, 4, 'Ciseeng'),
(84, 1, 4, 'Citeureup'),
(85, 1, 4, 'Dramaga'),
(86, 1, 4, 'Gunung Putri'),
(87, 1, 4, 'Gunung Sindur'),
(88, 1, 4, 'Jasinga'),
(89, 1, 4, 'Jonggol'),
(90, 1, 4, 'Kemang'),
(91, 1, 4, 'Klapanunggal'),
(92, 1, 4, 'Leuwiliang'),
(93, 1, 4, 'Leuwisadeng'),
(94, 1, 4, 'Megamendung'),
(95, 1, 4, 'Nanggung'),
(96, 1, 4, 'Pamijahan'),
(97, 1, 4, 'Parung'),
(98, 1, 4, 'Parung Panjang'),
(99, 1, 4, 'Ranca Bungur'),
(100, 1, 4, 'Rumpin'),
(101, 1, 4, 'Sukajaya'),
(102, 1, 4, 'Sukamakmur'),
(103, 1, 4, 'Sukaraja'),
(104, 1, 4, 'Tajurhalang'),
(105, 1, 4, 'Tamansari'),
(106, 1, 4, 'Tanjungsari'),
(107, 1, 4, 'Tenjo'),
(108, 1, 4, 'Tenjolaya'),
(109, 1, 4, 'Cigombong'),
(110, 1, 4, 'Cikaret'),
(111, 1, 5, 'Banjarsari'),
(112, 1, 5, 'Baregbeg'),
(113, 1, 5, 'Ciamis'),
(114, 1, 5, 'Cidolog'),
(115, 1, 5, 'Cihaurbeuti'),
(116, 1, 5, 'Cijeungjing'),
(117, 1, 5, 'Cikoneng'),
(118, 1, 5, 'Cimaragas'),
(119, 1, 5, 'Cipaku'),
(120, 1, 5, 'Cisaga'),
(121, 1, 5, 'Jatinagara'),
(122, 1, 5, 'Kawali'),
(123, 1, 5, 'Lakbok'),
(124, 1, 5, 'Lumbung'),
(125, 1, 5, 'Manonjaya'),
(126, 1, 5, 'Panawangan'),
(127, 1, 5, 'Panjalu'),
(128, 1, 5, 'Panumbangan'),
(129, 1, 5, 'Purwadadi'),
(130, 1, 5, 'Rajadesa'),
(131, 1, 5, 'Rancah'),
(132, 1, 5, 'Sadananya'),
(133, 1, 5, 'Sindangkasih'),
(134, 1, 5, 'Sukadana'),
(135, 1, 5, 'Sukamantri'),
(136, 1, 5, 'Tambaksari'),
(137, 1, 5, 'Padaherang'),
(138, 1, 6, 'Agrabinta'),
(139, 1, 6, 'Bojongpicung'),
(140, 1, 6, 'Cianjur'),
(141, 1, 6, 'Cibeber'),
(142, 1, 6, 'Cibinong'),
(143, 1, 6, 'Cidaun'),
(144, 1, 6, 'Cijati'),
(145, 1, 6, 'Cikadu'),
(146, 1, 6, 'Cikalongkulon'),
(147, 1, 6, 'Cilaku'),
(148, 1, 6, 'Cipanas'),
(149, 1, 6, 'Ciranjang'),
(150, 1, 6, 'Cugenang'),
(151, 1, 6, 'Gekbrong'),
(152, 1, 6, 'Haurwangi'),
(153, 1, 6, 'Kadupandak'),
(154, 1, 6, 'Karangtengah'),
(155, 1, 6, 'Leles'),
(156, 1, 6, 'Mande'),
(157, 1, 6, 'Naringgul'),
(158, 1, 6, 'Pacet'),
(159, 1, 6, 'Pagelaran'),
(160, 1, 6, 'Pasirkuda'),
(161, 1, 6, 'Sindangbarang'),
(162, 1, 6, 'Sukaluyu'),
(163, 1, 6, 'Sukanagara'),
(164, 1, 6, 'Sukaresmi'),
(165, 1, 6, 'Takokak'),
(166, 1, 6, 'Tanggeung'),
(167, 1, 6, 'Warungkondang'),
(168, 1, 6, 'Cibodas'),
(169, 1, 6, 'Cijagang'),
(170, 1, 7, 'Arjawinangun'),
(171, 1, 7, 'Astanajapura'),
(172, 1, 7, 'Babakan'),
(173, 1, 7, 'Beber'),
(174, 1, 7, 'Ciledug'),
(175, 1, 7, 'Ciwaringin'),
(176, 1, 7, 'Depok'),
(177, 1, 7, 'Dukupuntang'),
(178, 1, 7, 'Gebang'),
(179, 1, 7, 'Gegesik'),
(180, 1, 7, 'Gempol'),
(181, 1, 7, 'Gunungjati'),
(182, 1, 7, 'Jamblang'),
(183, 1, 7, 'Kaliwedi'),
(184, 1, 7, 'Kapetakan'),
(185, 1, 7, 'Karangsembung'),
(186, 1, 7, 'Karangwareng'),
(187, 1, 7, 'Kedawung'),
(188, 1, 7, 'Klangenan'),
(189, 1, 7, 'Lemahabang'),
(190, 1, 7, 'Losari'),
(191, 1, 7, 'Mundu'),
(192, 1, 7, 'Pabedilan'),
(193, 1, 7, 'Pabuaran'),
(194, 1, 7, 'Palimanan'),
(195, 1, 7, 'Pangenan'),
(196, 1, 7, 'Panguragan'),
(197, 1, 7, 'Pasaleman'),
(198, 1, 7, 'Plered'),
(199, 1, 7, 'Plumbon'),
(200, 1, 7, 'Sedong'),
(201, 1, 7, 'Sumber'),
(202, 1, 7, 'Suranenggala'),
(203, 1, 7, 'Susukan'),
(204, 1, 7, 'Susukanlebak'),
(205, 1, 7, 'Talun'),
(206, 1, 7, 'Tengahtani'),
(207, 1, 7, 'Waled'),
(208, 1, 7, 'Weru'),
(209, 1, 7, 'Sindang'),
(210, 1, 8, 'Banjarwangi'),
(211, 1, 8, 'Banyuresmi'),
(212, 1, 8, 'Bayongbong'),
(213, 1, 8, 'Blubur Limbangan'),
(214, 1, 8, 'Bungbulang'),
(215, 1, 8, 'Caringin'),
(216, 1, 8, 'Cibalong'),
(217, 1, 8, 'Cibatu'),
(218, 1, 8, 'Cibiuk'),
(219, 1, 8, 'Cigedug'),
(220, 1, 8, 'Cihurip'),
(221, 1, 8, 'Cikajang'),
(222, 1, 8, 'Cikelet'),
(223, 1, 8, 'Cilawu'),
(224, 1, 8, 'Cisewu'),
(225, 1, 8, 'Cisompet'),
(226, 1, 8, 'Cisurupan'),
(227, 1, 8, 'Garut Kota'),
(228, 1, 8, 'Kadungora'),
(229, 1, 8, 'Karangpawitan'),
(230, 1, 8, 'Karangtengah'),
(231, 1, 8, 'Kersamanah'),
(232, 1, 8, 'Leles'),
(233, 1, 8, 'Leuwigoong'),
(234, 1, 8, 'Malangbong'),
(235, 1, 8, 'Mekarmukti'),
(236, 1, 8, 'Pakenjeng'),
(237, 1, 8, 'Pameungpeuk'),
(238, 1, 8, 'Pamulihan'),
(239, 1, 8, 'Pangatikan'),
(240, 1, 8, 'Pasirwangi'),
(241, 1, 8, 'Peundeuy'),
(242, 1, 8, 'Samarang'),
(243, 1, 8, 'Selaawi'),
(244, 1, 8, 'Singajaya'),
(245, 1, 8, 'Sucinaraja'),
(246, 1, 8, 'Sukaresmi'),
(247, 1, 8, 'Sukawening'),
(248, 1, 8, 'Talegong'),
(249, 1, 8, 'Tarogong Kaler'),
(250, 1, 8, 'Tarogong Kidul'),
(251, 1, 8, 'Wanaraja'),
(252, 1, 9, 'Anjatan'),
(253, 1, 9, 'Arahan'),
(254, 1, 9, 'Balongan'),
(255, 1, 9, 'Bangodua'),
(256, 1, 9, 'Bongas'),
(257, 1, 9, 'Cantigi'),
(258, 1, 9, 'Cikedung'),
(259, 1, 9, 'Gabuswetan'),
(260, 1, 9, 'Gantar'),
(261, 1, 9, 'Haurgeulis'),
(262, 1, 9, 'Indramayu'),
(263, 1, 9, 'Jatibarang'),
(264, 1, 9, 'Juntinyuat'),
(265, 1, 9, 'Kandanghaur'),
(266, 1, 9, 'Karangampel'),
(267, 1, 9, 'Kedokan Bunder'),
(268, 1, 9, 'Kertasemaya'),
(269, 1, 9, 'Krangkeng'),
(270, 1, 9, 'Kroya'),
(271, 1, 9, 'Lelea'),
(272, 1, 9, 'Lohbener'),
(273, 1, 9, 'Losarang'),
(274, 1, 9, 'Pasekan'),
(275, 1, 9, 'Patrol'),
(276, 1, 9, 'Sindang'),
(277, 1, 9, 'Sliyeg'),
(278, 1, 9, 'Sukagumiwang'),
(279, 1, 9, 'Sukra'),
(280, 1, 9, 'Tukdana'),
(281, 1, 9, 'Terisi'),
(282, 1, 9, 'Widasari'),
(283, 1, 10, 'Banyusari'),
(284, 1, 10, 'Batujaya'),
(285, 1, 10, 'Ciampel'),
(286, 1, 10, 'Cibuaya'),
(287, 1, 10, 'Cikampek'),
(288, 1, 10, 'Cilamaya Kulon'),
(289, 1, 10, 'Cilamaya Wetan'),
(290, 1, 10, 'Cilebar'),
(291, 1, 10, 'Jatisari'),
(292, 1, 10, 'Jayakerta'),
(293, 1, 10, 'Karawang Barat'),
(294, 1, 10, 'Karawang Timur'),
(295, 1, 10, 'Klari'),
(296, 1, 10, 'Kotabaru'),
(297, 1, 10, 'Kutawaluya'),
(298, 1, 10, 'Lemahabang'),
(299, 1, 10, 'Majalaya'),
(300, 1, 10, 'Pakisjaya'),
(301, 1, 10, 'Pangkalan'),
(302, 1, 10, 'Pedes'),
(303, 1, 10, 'Purwasari'),
(304, 1, 10, 'Rawamerta'),
(305, 1, 10, 'Rengasdengklok'),
(306, 1, 10, 'Talagasari'),
(307, 1, 10, 'Tegalwaru'),
(308, 1, 10, 'Telukjambe Barat'),
(309, 1, 10, 'Telukjambe Timur'),
(310, 1, 10, 'Tempuran'),
(311, 1, 10, 'Tirtajaya'),
(312, 1, 10, 'Tirtamulya'),
(313, 1, 11, 'Ciawigebang'),
(314, 1, 11, 'Cibeureum'),
(315, 1, 11, 'Cibingbin'),
(316, 1, 11, 'Cidahu'),
(317, 1, 11, 'Cigandamekar'),
(318, 1, 11, 'Cigugur'),
(319, 1, 11, 'Cilebak'),
(320, 1, 11, 'Cilimus'),
(321, 1, 11, 'Cimahi'),
(322, 1, 11, 'Ciniru'),
(323, 1, 11, 'Cipicung'),
(324, 1, 11, 'Ciwaru'),
(325, 1, 11, 'Darma'),
(326, 1, 11, 'Garawangi'),
(327, 1, 11, 'Hantara'),
(328, 1, 11, 'Jalaksana'),
(329, 1, 11, 'Japara'),
(330, 1, 11, 'Kadugede'),
(331, 1, 11, 'Kalimanggis'),
(332, 1, 11, 'Karangkancana'),
(333, 1, 11, 'Kramatmulya'),
(334, 1, 11, 'Kuningan'),
(335, 1, 11, 'Lebakwangi'),
(336, 1, 11, 'Luragung'),
(337, 1, 11, 'Maleber'),
(338, 1, 11, 'Mandirancan'),
(339, 1, 11, 'Nusaherang'),
(340, 1, 11, 'Pancalang'),
(341, 1, 11, 'Pasawahan'),
(342, 1, 11, 'Selajambe'),
(343, 1, 11, 'Sindangagung'),
(344, 1, 11, 'Subang'),
(345, 1, 12, 'Argapura'),
(346, 1, 12, 'Bantarujeg'),
(347, 1, 12, 'Cigasong'),
(348, 1, 12, 'Cikijing'),
(349, 1, 12, 'Cingambul'),
(350, 1, 12, 'Dawuan'),
(351, 1, 12, 'Jatiwangi'),
(352, 1, 12, 'Kadipaten'),
(353, 1, 12, 'Kasokandel'),
(354, 1, 12, 'Kertajati'),
(355, 1, 12, 'Lemahsugih'),
(356, 1, 12, 'Leuwimunding'),
(357, 1, 12, 'Ligung'),
(358, 1, 12, 'Maja'),
(359, 1, 12, 'Majalengka'),
(360, 1, 12, 'Malausma'),
(361, 1, 12, 'Palasah'),
(362, 1, 12, 'Panyingkiran'),
(363, 1, 12, 'Rajagaluh'),
(364, 1, 12, 'Sindang'),
(365, 1, 12, 'Sindangwangi'),
(366, 1, 12, 'Sukahaji'),
(367, 1, 12, 'Sumberjaya'),
(368, 1, 12, 'Talaga'),
(369, 1, 12, 'Cikarang'),
(370, 1, 12, 'Cipaku'),
(371, 1, 12, 'Jatitujuh'),
(372, 1, 12, 'Sumberjaya'),
(373, 1, 13, 'Cigugur'),
(374, 1, 13, 'Cijulang'),
(375, 1, 13, 'Cimerak'),
(376, 1, 13, 'Kalipucang'),
(377, 1, 13, 'Langkaplancar'),
(378, 1, 13, 'Mangunjaya'),
(379, 1, 13, 'Padaherang'),
(380, 1, 13, 'Pangandaran'),
(381, 1, 13, 'Parigi'),
(382, 1, 13, 'Sidamulih'),
(383, 1, 14, 'Babakancikao'),
(384, 1, 14, 'Bojong'),
(385, 1, 14, 'Bungursari'),
(386, 1, 14, 'Campaka'),
(387, 1, 14, 'Cibatu'),
(388, 1, 14, 'Darangdan'),
(389, 1, 14, 'Jatiluhur'),
(390, 1, 14, 'Kiarapedes'),
(391, 1, 14, 'Maniis'),
(392, 1, 14, 'Pasawahan'),
(393, 1, 14, 'Plered'),
(394, 1, 14, 'Pondoksalam'),
(395, 1, 14, 'Purwakarta'),
(396, 1, 14, 'Sukasari'),
(397, 1, 14, 'Sukatani'),
(398, 1, 14, 'Tegalwaru'),
(399, 1, 14, 'Wanayasa'),
(400, 1, 15, 'Binong'),
(401, 1, 15, 'Blanakan'),
(402, 1, 15, 'Cibogo'),
(403, 1, 15, 'Cijambe'),
(404, 1, 15, 'Cipunagara'),
(405, 1, 15, 'Cisalak'),
(406, 1, 15, 'Compreng'),
(407, 1, 15, 'Dawuan'),
(408, 1, 15, 'Jalancagak'),
(409, 1, 15, 'Kalijati'),
(410, 1, 15, 'Kasomalang'),
(411, 1, 15, 'Legonkulon'),
(412, 1, 15, 'Pagaden'),
(413, 1, 15, 'Pagaden Barat'),
(414, 1, 15, 'Pamanukan'),
(415, 1, 15, 'Patokbeusi'),
(416, 1, 15, 'Purwadadi'),
(417, 1, 15, 'Pusakajaya'),
(418, 1, 15, 'Pusakanagara'),
(419, 1, 15, 'Sagalaherang'),
(420, 1, 15, 'Serangpanjang'),
(421, 1, 15, 'Subang'),
(422, 1, 15, 'Sukasari'),
(423, 1, 15, 'Tambakdahan'),
(424, 1, 15, 'Tanjungsiang'),
(425, 1, 15, 'Cikaum'),
(426, 1, 15, 'Cipeundeuy'),
(427, 1, 15, 'Cipeueuy'),
(428, 1, 15, 'Pabuaran'),
(429, 1, 15, 'Sindang'),
(430, 1, 16, 'Bantargadung'),
(431, 1, 16, 'Bojonggenteng'),
(432, 1, 16, 'Caringin'),
(433, 1, 16, 'Cibadak'),
(434, 1, 16, 'Cibitung'),
(435, 1, 16, 'Cicantayan'),
(436, 1, 16, 'Cicurug'),
(437, 1, 16, 'Cidadap'),
(438, 1, 16, 'Cidahu'),
(439, 1, 16, 'Cidolog'),
(440, 1, 16, 'Ciemas'),
(441, 1, 16, 'Cikakak'),
(442, 1, 16, 'Cikidang'),
(443, 1, 16, 'Cimanggu'),
(444, 1, 16, 'Ciracap'),
(445, 1, 16, 'Cireunghas'),
(446, 1, 16, 'Cisaat'),
(447, 1, 16, 'Cisolok'),
(448, 1, 16, 'Curugkembar'),
(449, 1, 16, 'Gegerbitung'),
(450, 1, 16, 'Gunungguruh'),
(451, 1, 16, 'Jampang Kulon'),
(452, 1, 16, 'Jampang Tengah'),
(453, 1, 16, 'Kabandungan'),
(454, 1, 16, 'Kadudampit'),
(455, 1, 16, 'Kalapanunggal'),
(456, 1, 16, 'Kalibunder'),
(457, 1, 16, 'Kebonpedes'),
(458, 1, 16, 'Lengkong'),
(459, 1, 16, 'Nagrak'),
(460, 1, 16, 'Nyalindung'),
(461, 1, 16, 'Pabuaran'),
(462, 1, 16, 'Parakan Salak'),
(463, 1, 16, 'Parung Kuda'),
(464, 1, 16, 'Pelabuhan Ratu'),
(465, 1, 16, 'Purabaya'),
(466, 1, 16, 'Sagaranten'),
(467, 1, 16, 'Simpenan'),
(468, 1, 16, 'Sukabumi'),
(469, 1, 16, 'Sukalarang'),
(470, 1, 16, 'Sukaraja'),
(471, 1, 16, 'Surade'),
(472, 1, 16, 'Tegal Buleud'),
(473, 1, 16, 'Waluran'),
(474, 1, 16, 'Warung Kiara'),
(475, 1, 16, 'Cikembar'),
(476, 1, 16, 'Cikidang'),
(477, 1, 17, 'Buahdua'),
(478, 1, 17, 'Cibugel'),
(479, 1, 17, 'Cimalaka'),
(480, 1, 17, 'Cimanggung'),
(481, 1, 17, 'Cisarua'),
(482, 1, 17, 'Cisitu'),
(483, 1, 17, 'Conggeang'),
(484, 1, 17, 'Darmaraja'),
(485, 1, 17, 'Ganeas'),
(486, 1, 17, 'Jatigede'),
(487, 1, 17, 'Jatinangor'),
(488, 1, 17, 'Jatinunggal'),
(489, 1, 17, 'Pamulihan'),
(490, 1, 17, 'Paseh'),
(491, 1, 17, 'Rancakalong'),
(492, 1, 17, 'Situraja'),
(493, 1, 17, 'Sukasari'),
(494, 1, 17, 'Sumedang Selatan'),
(495, 1, 17, 'Sumedang Utara'),
(496, 1, 17, 'Surian'),
(497, 1, 17, 'Tanjungkerta'),
(498, 1, 17, 'Tanjungmedar'),
(499, 1, 17, 'Tanjungsari'),
(500, 1, 17, 'Tomo'),
(501, 1, 17, 'Ujungjaya'),
(502, 1, 17, 'Wado'),
(503, 1, 17, 'Cikembar'),
(504, 1, 18, 'Bantarkalong'),
(505, 1, 18, 'Bojongasih'),
(506, 1, 18, 'Bojonggambir'),
(507, 1, 18, 'Ciawi'),
(508, 1, 18, 'Cibalong'),
(509, 1, 18, 'Cigalontang'),
(510, 1, 18, 'Cikalong'),
(511, 1, 18, 'Cikatomas'),
(512, 1, 18, 'Cineam'),
(513, 1, 18, 'Cipatujah'),
(514, 1, 18, 'Cisayong'),
(515, 1, 18, 'Culamega'),
(516, 1, 18, 'Gunungtanjung'),
(517, 1, 18, 'Jamanis'),
(518, 1, 18, 'Jatiwaras'),
(519, 1, 18, 'Kadipaten'),
(520, 1, 18, 'Karangjaya'),
(521, 1, 18, 'Karangnunggal'),
(522, 1, 18, 'Leuwisari'),
(523, 1, 18, 'Mangunreja'),
(524, 1, 18, 'Manonjaya'),
(525, 1, 18, 'Padakembang'),
(526, 1, 18, 'Pagerageung'),
(527, 1, 18, 'Pancatengah'),
(528, 1, 18, 'Parungponteng'),
(529, 1, 18, 'Puspahiang'),
(530, 1, 18, 'Rajapolah'),
(531, 1, 18, 'Salawu'),
(532, 1, 18, 'Salopa'),
(533, 1, 18, 'Sariwangi'),
(534, 1, 18, 'Singaparna'),
(535, 1, 18, 'Sodonghilir'),
(536, 1, 18, 'Sukahening'),
(537, 1, 18, 'Sukaraja'),
(538, 1, 18, 'Sukarame'),
(539, 1, 18, 'Tanjungjaya'),
(540, 1, 18, 'Taraju'),
(541, 1, 18, 'Cikalong'),
(542, 1, 18, 'Cineam'),
(543, 1, 19, 'Andir'),
(544, 1, 19, 'Antapani'),
(545, 1, 19, 'Arcamanik'),
(546, 1, 19, 'Astana Anyar'),
(547, 1, 19, 'Babakan Ciparay'),
(548, 1, 19, 'Bandung Kidul'),
(549, 1, 19, 'Bandung Kulon'),
(550, 1, 19, 'Bandung Wetan'),
(551, 1, 19, 'Batununggal'),
(552, 1, 19, 'Bojongloa Kaler'),
(553, 1, 19, 'Bojongloa Kidul'),
(554, 1, 19, 'Buahbatu'),
(555, 1, 19, 'Cibeunying Kaler'),
(556, 1, 19, 'Cibeunying Kidul'),
(557, 1, 19, 'Cibiru'),
(558, 1, 19, 'Cicendo'),
(559, 1, 19, 'Cidadap'),
(560, 1, 19, 'Cinambo'),
(561, 1, 19, 'Coblong'),
(562, 1, 19, 'Gedebage'),
(563, 1, 19, 'Kiaracondong'),
(564, 1, 19, 'Lengkong'),
(565, 1, 19, 'Mandalajati'),
(566, 1, 19, 'Panyileukan'),
(567, 1, 19, 'Rancasari'),
(568, 1, 19, 'Regol'),
(569, 1, 19, 'Sukajadi'),
(570, 1, 19, 'Sukasari'),
(571, 1, 19, 'Sumur Bandung'),
(572, 1, 19, 'Ujungberung'),
(573, 1, 20, 'Banjar'),
(574, 1, 20, 'Langensari'),
(575, 1, 20, 'Pataruman'),
(576, 1, 20, 'Purwaharja'),
(577, 1, 21, 'Bekasi Barat'),
(578, 1, 21, 'Bekasi Selatan'),
(579, 1, 21, 'Bekasi Timur'),
(580, 1, 21, 'Bekasi Utara'),
(581, 1, 21, 'Jatiasih'),
(582, 1, 21, 'Jatisampurna'),
(583, 1, 21, 'Medansatria'),
(584, 1, 21, 'Mustikajaya'),
(585, 1, 21, 'Pondok Gede'),
(586, 1, 21, 'Pondok Melati'),
(587, 1, 21, 'Rawalumbu'),
(588, 1, 21, 'Bantar Gebang'),
(589, 1, 22, 'Bogor Barat'),
(590, 1, 22, 'Bogor Selatan'),
(591, 1, 22, 'Bogor Tengah'),
(592, 1, 22, 'Bogor Timur'),
(593, 1, 22, 'Bogor Utara'),
(594, 1, 22, 'Tanah Sereal'),
(595, 1, 23, 'Cimahi Selatan'),
(596, 1, 23, 'Cimahi Tengah'),
(597, 1, 23, 'Cimahi Utara'),
(598, 1, 24, 'Harjamukti'),
(599, 1, 24, 'Kejaksan'),
(600, 1, 24, 'Kesambi'),
(601, 1, 24, 'Lemahwungkuk'),
(602, 1, 24, 'Pekalipan'),
(603, 1, 25, 'Beji'),
(604, 1, 25, 'Cilodong'),
(605, 1, 25, 'Cimanggis'),
(606, 1, 25, 'Cinere'),
(607, 1, 25, 'Cipayung'),
(608, 1, 25, 'Limo'),
(609, 1, 25, 'Pancoran Mas'),
(610, 1, 25, 'Sawangan'),
(611, 1, 25, 'Sukmajaya'),
(612, 1, 25, 'Tapos'),
(613, 1, 25, 'Bojongsari'),
(614, 1, 26, 'Baros'),
(615, 1, 26, 'Cibeureum'),
(616, 1, 26, 'Cikole'),
(617, 1, 26, 'Citamiang'),
(618, 1, 26, 'Gunungpuyuh'),
(619, 1, 26, 'Lembursitu'),
(620, 1, 26, 'Warudoyong'),
(621, 1, 27, 'Bungursari'),
(622, 1, 27, 'Cibeureum'),
(623, 1, 27, 'Cihideung'),
(624, 1, 27, 'Cipedes'),
(625, 1, 27, 'Indihiang'),
(626, 1, 27, 'Kawalu'),
(627, 1, 27, 'Mangkubumi'),
(628, 1, 27, 'Purbaratu'),
(629, 1, 27, 'Tamansari'),
(630, 1, 27, 'Tawang');

-- --------------------------------------------------------

--
-- Table structure for table `kegiatan`
--

CREATE TABLE `kegiatan` (
  `id_kegiatan` int NOT NULL,
  `id_user` int NOT NULL,
  `id_provinsi` int NOT NULL,
  `id_kabupaten` int NOT NULL,
  `id_kecamatan` int NOT NULL,
  `jenis_kegiatan` enum('Haji','Umrah','Wisata') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `status_kegiatan` enum('Akan Datang','Berlangsung','Selesai') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `target` varchar(150) DEFAULT NULL,
  `tempat_kegiatan` varchar(255) NOT NULL,
  `tanggal_kegiatan` date NOT NULL,
  `waktu_kegiatan` time NOT NULL,
  `catatan` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kegiatan`
--

INSERT INTO `kegiatan` (`id_kegiatan`, `id_user`, `id_provinsi`, `id_kabupaten`, `id_kecamatan`, `jenis_kegiatan`, `status_kegiatan`, `target`, `tempat_kegiatan`, `tanggal_kegiatan`, `waktu_kegiatan`, `catatan`, `created_at`, `updated_at`) VALUES
(1, 2, 1, 1, 31, 'Umrah', 'Akan Datang', 'Calon Jamaah', 'Gedung Serbaguna Soreang', '2026-09-15', '09:00:00', 'Sosialisasi paket umrah terbaru', '2026-09-09 06:24:23', '2026-09-09 06:24:23'),
(2, 2, 1, 19, 543, 'Haji', 'Berlangsung', 'Jamaah Haji', 'Masjid Al-Ikhlas Bandung', '2026-09-07', '10:00:00', 'Manasik haji perdana', '2026-09-09 06:24:23', '2026-09-09 06:24:23'),
(3, 2, 1, 21, 578, 'Haji', 'Selesai', 'Masyarakat Umum', 'Mall Bekasi', '2026-08-25', '13:00:00', 'Promosi paket haji 2026', '2026-09-09 06:24:23', '2026-09-09 06:24:23'),
(4, 8, 1, 6, 141, 'Wisata', 'Selesai', 'Jamaah Umrah', 'Aula Hotel Cianjur', '2026-08-30', '08:30:00', 'Gathering wisata religi', '2026-09-09 06:24:23', '2026-09-09 06:24:23'),
(5, 2, 1, 1, 9, 'Umrah', 'Akan Datang', 'Calon Jamaah', 'Pesantren Cileunyi', '2026-09-20', '09:30:00', 'Kajian persiapan umrah', '2026-09-09 06:24:23', '2026-09-09 06:24:23'),
(6, 2, 1, 3, 54, 'Wisata', 'Berlangsung', 'Umum', 'Wisata Bahari Cikarang', '2026-09-07', '14:00:00', 'Open trip wisata bahari', '2026-09-09 06:24:23', '2026-09-09 06:24:23');

-- --------------------------------------------------------

--
-- Table structure for table `kegiatan_user`
--

CREATE TABLE `kegiatan_user` (
  `id_kegiatan_user` int NOT NULL,
  `id_kegiatan` int NOT NULL,
  `id_user` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kegiatan_user`
--

INSERT INTO `kegiatan_user` (`id_kegiatan_user`, `id_kegiatan`, `id_user`) VALUES
(6, 1, 2),
(7, 2, 2),
(8, 3, 2),
(10, 5, 2),
(11, 6, 2);

-- --------------------------------------------------------

--
-- Table structure for table `provinsi`
--

CREATE TABLE `provinsi` (
  `id_provinsi` int NOT NULL,
  `nama_provinsi` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `provinsi`
--

INSERT INTO `provinsi` (`id_provinsi`, `nama_provinsi`) VALUES
(1, 'Jawa Barat');

-- --------------------------------------------------------

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id_user` int NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `no_hp` varchar(13) NOT NULL,
  `nama_lengkap` varchar(255) NOT NULL,
  `divisi` enum('Kepala Marketing','Tim Marketing') NOT NULL,
  `role` enum('admin','marketing') NOT NULL,
  `status` enum('aktif','nonaktif','pending') NOT NULL,
  `last_seen` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `periode` year NOT NULL,
  `foto_profil` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL,
  `updated_at` timestamp NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id_user`, `username`, `password`, `email`, `no_hp`, `nama_lengkap`, `divisi`, `role`, `status`, `last_seen`, `periode`, `foto_profil`, `created_at`, `updated_at`) VALUES
(1, 'Dziky Husni Zain', '$2y$12$xYhK82SDlkEEVWkc4C/KL.yttcSvY82nZ2ZR0lAER5zgmG/bso0iq', 'acetsavisenna@gmail.com', '082130284300', 'Dziky Husni Zain', 'Kepala Marketing', 'admin', 'aktif', '2026-08-30 22:17:23', '2026', '1788493036_6a9a3cec02e64.jpg', '2026-08-11 08:16:15', '2026-09-03 20:37:16'),
(2, 'marketing1', '$2y$12$3dJVErI6mUWLc1Y49emwtOwOkSAWlVPAjbbSSH5ld3mLRaxMV/OrO', 'mkt1@rizmatour.com', '081234567891', 'Dede Iskandar', 'Tim Marketing', 'marketing', 'aktif', '2026-08-29 02:04:05', '2026', '1788493057_6a9a3d0143d14.jpeg', '2026-08-11 08:17:17', '2026-09-03 20:37:37');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `event`
--
ALTER TABLE `event`
  ADD PRIMARY KEY (`id_event`),
  ADD KEY `fk_event_user` (`id_user`),
  ADD KEY `fk_event_provinsi` (`id_provinsi`),
  ADD KEY `fk_event_kabupaten` (`id_kabupaten`),
  ADD KEY `fk_event_kecamatan` (`id_kecamatan`);

--
-- Indexes for table `event_jamaah`
--
ALTER TABLE `event_jamaah`
  ADD PRIMARY KEY (`id_event_jamaah`),
  ADD KEY `fk_event_jamaah` (`id_event`);

--
-- Indexes for table `event_user`
--
ALTER TABLE `event_user`
  ADD PRIMARY KEY (`id_event_user`),
  ADD UNIQUE KEY `unique_event_user` (`id_event`,`id_user`),
  ADD KEY `fk_event_user_user` (`id_user`);

--
-- Indexes for table `hasil_event`
--
ALTER TABLE `hasil_event`
  ADD PRIMARY KEY (`id_hasil_event`),
  ADD KEY `fk_hasil_event` (`id_event`);

--
-- Indexes for table `hasil_kegiatan`
--
ALTER TABLE `hasil_kegiatan`
  ADD PRIMARY KEY (`id_hasil_kegiatan`);

--
-- Indexes for table `kabupaten`
--
ALTER TABLE `kabupaten`
  ADD PRIMARY KEY (`id_kabupaten`),
  ADD KEY `id_provinsi` (`id_provinsi`);

--
-- Indexes for table `kecamatan`
--
ALTER TABLE `kecamatan`
  ADD PRIMARY KEY (`id_kecamatan`),
  ADD KEY `id_provinsi` (`id_provinsi`,`id_kabupaten`);

--
-- Indexes for table `kegiatan`
--
ALTER TABLE `kegiatan`
  ADD PRIMARY KEY (`id_kegiatan`),
  ADD KEY `id_user` (`id_user`,`id_provinsi`,`id_kabupaten`,`id_kecamatan`);

--
-- Indexes for table `kegiatan_user`
--
ALTER TABLE `kegiatan_user`
  ADD PRIMARY KEY (`id_kegiatan_user`),
  ADD UNIQUE KEY `unique_kegiatan_user` (`id_kegiatan`,`id_user`),
  ADD KEY `fk_kegiatan_user_user` (`id_user`);

--
-- Indexes for table `provinsi`
--
ALTER TABLE `provinsi`
  ADD PRIMARY KEY (`id_provinsi`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`id_user`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `event`
--
ALTER TABLE `event`
  MODIFY `id_event` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `event_jamaah`
--
ALTER TABLE `event_jamaah`
  MODIFY `id_event_jamaah` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `event_user`
--
ALTER TABLE `event_user`
  MODIFY `id_event_user` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `hasil_event`
--
ALTER TABLE `hasil_event`
  MODIFY `id_hasil_event` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `hasil_kegiatan`
--
ALTER TABLE `hasil_kegiatan`
  MODIFY `id_hasil_kegiatan` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `kabupaten`
--
ALTER TABLE `kabupaten`
  MODIFY `id_kabupaten` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `kecamatan`
--
ALTER TABLE `kecamatan`
  MODIFY `id_kecamatan` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=631;

--
-- AUTO_INCREMENT for table `kegiatan`
--
ALTER TABLE `kegiatan`
  MODIFY `id_kegiatan` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `kegiatan_user`
--
ALTER TABLE `kegiatan_user`
  MODIFY `id_kegiatan_user` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `provinsi`
--
ALTER TABLE `provinsi`
  MODIFY `id_provinsi` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `id_user` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `event`
--
ALTER TABLE `event`
  ADD CONSTRAINT `fk_event_kabupaten` FOREIGN KEY (`id_kabupaten`) REFERENCES `kabupaten` (`id_kabupaten`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_event_kecamatan` FOREIGN KEY (`id_kecamatan`) REFERENCES `kecamatan` (`id_kecamatan`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_event_provinsi` FOREIGN KEY (`id_provinsi`) REFERENCES `provinsi` (`id_provinsi`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_event_user` FOREIGN KEY (`id_user`) REFERENCES `user` (`id_user`) ON DELETE SET NULL ON UPDATE CASCADE;

--
-- Constraints for table `event_jamaah`
--
ALTER TABLE `event_jamaah`
  ADD CONSTRAINT `fk_event_jamaah` FOREIGN KEY (`id_event`) REFERENCES `event` (`id_event`) ON DELETE CASCADE;

--
-- Constraints for table `event_user`
--
ALTER TABLE `event_user`
  ADD CONSTRAINT `fk_event_user_event` FOREIGN KEY (`id_event`) REFERENCES `event` (`id_event`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_event_user_user` FOREIGN KEY (`id_user`) REFERENCES `user` (`id_user`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `hasil_event`
--
ALTER TABLE `hasil_event`
  ADD CONSTRAINT `fk_hasil_event` FOREIGN KEY (`id_event`) REFERENCES `event` (`id_event`) ON DELETE CASCADE;

--
-- Constraints for table `kegiatan_user`
--
ALTER TABLE `kegiatan_user`
  ADD CONSTRAINT `fk_kegiatan_user_kegiatan` FOREIGN KEY (`id_kegiatan`) REFERENCES `kegiatan` (`id_kegiatan`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_kegiatan_user_user` FOREIGN KEY (`id_user`) REFERENCES `user` (`id_user`) ON DELETE CASCADE ON UPDATE CASCADE;
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 */;
