/*!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.6.18-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: sibedas
-- ------------------------------------------------------
-- Server version	10.6.18-MariaDB-0ubuntu0.22.04.1

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `advertisements`
--

DROP TABLE IF EXISTS `advertisements`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `advertisements` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `no` int(11) NOT NULL,
  `business_name` varchar(255) NOT NULL,
  `npwpd` varchar(255) NOT NULL,
  `advertisement_type` varchar(255) NOT NULL,
  `advertisement_content` varchar(255) NOT NULL,
  `business_address` varchar(255) NOT NULL,
  `advertisement_location` varchar(255) NOT NULL,
  `village_code` varchar(255) NOT NULL,
  `district_code` int(11) NOT NULL,
  `length` double NOT NULL,
  `width` double NOT NULL,
  `viewing_angle` varchar(255) NOT NULL,
  `face` varchar(255) NOT NULL,
  `area` varchar(255) NOT NULL,
  `angle` varchar(255) NOT NULL,
  `contact` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=184 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `bigdata_resumes`
--

DROP TABLE IF EXISTS `bigdata_resumes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bigdata_resumes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `import_datasource_id` bigint(20) unsigned NOT NULL,
  `potention_count` int(11) NOT NULL DEFAULT 0,
  `potention_sum` decimal(20,2) NOT NULL DEFAULT 0.00,
  `non_verified_count` int(11) NOT NULL DEFAULT 0,
  `non_verified_sum` decimal(20,2) NOT NULL DEFAULT 0.00,
  `verified_count` int(11) NOT NULL DEFAULT 0,
  `verified_sum` decimal(20,2) NOT NULL DEFAULT 0.00,
  `business_count` int(11) NOT NULL DEFAULT 0,
  `business_sum` decimal(20,2) NOT NULL DEFAULT 0.00,
  `non_business_count` int(11) NOT NULL DEFAULT 0,
  `non_business_sum` decimal(20,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `spatial_count` int(11) NOT NULL DEFAULT 0,
  `spatial_sum` decimal(20,2) NOT NULL DEFAULT 0.00,
  `year` varchar(255) NOT NULL,
  `waiting_click_dpmptsp_count` int(11) NOT NULL DEFAULT 0,
  `waiting_click_dpmptsp_sum` decimal(20,2) NOT NULL DEFAULT 0.00,
  `issuance_realization_pbg_count` int(11) NOT NULL DEFAULT 0,
  `issuance_realization_pbg_sum` decimal(20,2) NOT NULL DEFAULT 0.00,
  `process_in_technical_office_count` int(11) NOT NULL DEFAULT 0,
  `process_in_technical_office_sum` decimal(20,2) NOT NULL DEFAULT 0.00,
  PRIMARY KEY (`id`),
  KEY `bigdata_resumes_import_datasource_id_foreign` (`import_datasource_id`),
  CONSTRAINT `bigdata_resumes_import_datasource_id_foreign` FOREIGN KEY (`import_datasource_id`) REFERENCES `import_datasources` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `business_form`
--

DROP TABLE IF EXISTS `business_form`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `business_form` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `business_form` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `business_or_industries`
--

DROP TABLE IF EXISTS `business_or_industries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `business_or_industries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama_kecamatan` varchar(255) NOT NULL,
  `nama_kelurahan` varchar(255) NOT NULL,
  `nop` varchar(255) NOT NULL,
  `nama_wajib_pajak` varchar(255) NOT NULL,
  `alamat_wajib_pajak` text DEFAULT NULL,
  `alamat_objek_pajak` text NOT NULL,
  `luas_bumi` decimal(20,2) NOT NULL DEFAULT 0.00,
  `luas_bangunan` decimal(20,2) NOT NULL DEFAULT 0.00,
  `njop_bumi` decimal(20,2) NOT NULL DEFAULT 0.00,
  `njop_bangunan` decimal(20,2) NOT NULL DEFAULT 0.00,
  `ketetapan` decimal(20,2) NOT NULL DEFAULT 0.00,
  `tahun_pajak` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `business_or_industries_nop_unique` (`nop`)
) ENGINE=InnoDB AUTO_INCREMENT=120926 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `business_scale`
--

DROP TABLE IF EXISTS `business_scale`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `business_scale` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `business_scale` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `business_type`
--

DROP TABLE IF EXISTS `business_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `business_type` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `business_type` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cache`
--

DROP TABLE IF EXISTS `cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cache_locks`
--

DROP TABLE IF EXISTS `cache_locks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `customers`
--

DROP TABLE IF EXISTS `customers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nomor_pelanggan` varchar(255) NOT NULL,
  `kota_pelayanan` varchar(255) NOT NULL,
  `nama` varchar(255) NOT NULL,
  `alamat` text NOT NULL,
  `latitude` decimal(22,18) NOT NULL,
  `longitude` decimal(22,18) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `customers_nomor_pelanggan_unique` (`nomor_pelanggan`)
) ENGINE=InnoDB AUTO_INCREMENT=197374 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `data_settings`
--

DROP TABLE IF EXISTS `data_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `data_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL,
  `type` varchar(255) DEFAULT 'integer',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `data_settings_key_unique` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `districts`
--

DROP TABLE IF EXISTS `districts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `districts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `regency_code` int(11) NOT NULL,
  `district_code` int(11) NOT NULL,
  `district_name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7332 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `failed_jobs`
--

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `global_settings`
--

DROP TABLE IF EXISTS `global_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `global_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) NOT NULL,
  `value` text NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `global_settings_key_unique` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `import_datasources`
--

DROP TABLE IF EXISTS `import_datasources`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `import_datasources` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `message` varchar(255) DEFAULT NULL,
  `response_body` text DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'processing',
  `failed_uuid` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `start_time` timestamp NULL DEFAULT NULL,
  `finish_time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `job_batches`
--

DROP TABLE IF EXISTS `job_batches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `jobs`
--

DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB AUTO_INCREMENT=1189 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `menus`
--

DROP TABLE IF EXISTS `menus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `menus` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `parent_id` bigint(20) unsigned DEFAULT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `menus_parent_id_foreign` (`parent_id`),
  CONSTRAINT `menus_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `menus` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `password_reset_tokens`
--

DROP TABLE IF EXISTS `password_reset_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pbg_task`
--

DROP TABLE IF EXISTS `pbg_task`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pbg_task` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `owner_name` varchar(255) DEFAULT NULL,
  `application_type` varchar(255) DEFAULT NULL,
  `application_type_name` varchar(255) DEFAULT NULL,
  `condition` varchar(255) DEFAULT NULL,
  `registration_number` varchar(255) DEFAULT NULL,
  `document_number` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `status_name` varchar(255) DEFAULT NULL,
  `slf_status` varchar(255) DEFAULT NULL,
  `slf_status_name` varchar(255) DEFAULT NULL,
  `function_type` varchar(255) DEFAULT NULL,
  `consultation_type` varchar(255) DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `land_certificate_phase` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `task_created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pbg_task_uuid_unique` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=380902 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pbg_task_google_sheet`
--

DROP TABLE IF EXISTS `pbg_task_google_sheet`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pbg_task_google_sheet` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `jenis_konsultasi` varchar(255) DEFAULT NULL,
  `no_registrasi` varchar(255) DEFAULT NULL,
  `formatted_registration_number` varchar(255) DEFAULT NULL,
  `nama_pemilik` varchar(255) DEFAULT NULL,
  `lokasi_bg` text DEFAULT NULL,
  `fungsi_bg` varchar(255) DEFAULT NULL,
  `nama_bangunan` varchar(255) DEFAULT NULL,
  `tgl_permohonan` date DEFAULT NULL,
  `status_verifikasi` varchar(255) DEFAULT NULL,
  `status_permohonan` varchar(255) DEFAULT NULL,
  `alamat_pemilik` text DEFAULT NULL,
  `no_hp` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `tanggal_catatan` date DEFAULT NULL,
  `catatan_kekurangan_dokumen` text DEFAULT NULL,
  `gambar` varchar(255) DEFAULT NULL,
  `krk_kkpr` varchar(255) DEFAULT NULL,
  `no_krk` varchar(255) DEFAULT NULL,
  `lh` varchar(255) DEFAULT NULL,
  `ska` varchar(255) DEFAULT NULL,
  `keterangan` text DEFAULT NULL,
  `helpdesk` varchar(255) DEFAULT NULL,
  `pj` varchar(255) DEFAULT NULL,
  `kepemilikan` varchar(255) DEFAULT NULL,
  `potensi_taru` varchar(255) DEFAULT NULL,
  `validasi_dinas` varchar(255) DEFAULT NULL,
  `kategori_retribusi` varchar(255) DEFAULT NULL,
  `no_urut_ba_tpt` varchar(255) DEFAULT NULL,
  `tanggal_ba_tpt` date DEFAULT NULL,
  `no_urut_ba_tpa` varchar(255) DEFAULT NULL,
  `tanggal_ba_tpa` date DEFAULT NULL,
  `no_urut_skrd` varchar(255) DEFAULT NULL,
  `tanggal_skrd` date DEFAULT NULL,
  `ptsp` varchar(255) DEFAULT NULL,
  `selesai_terbit` varchar(255) DEFAULT NULL,
  `tanggal_pembayaran` date DEFAULT NULL,
  `format_sts` varchar(255) DEFAULT NULL,
  `tahun_terbit` int(11) DEFAULT NULL,
  `tahun_berjalan` int(11) DEFAULT NULL,
  `kelurahan` varchar(255) DEFAULT NULL,
  `kecamatan` varchar(255) DEFAULT NULL,
  `lb` decimal(20,2) DEFAULT NULL,
  `tb` decimal(20,2) DEFAULT NULL,
  `jlb` int(11) DEFAULT NULL,
  `unit` int(11) DEFAULT NULL,
  `usulan_retribusi` int(11) DEFAULT NULL,
  `nilai_retribusi_keseluruhan_simbg` decimal(20,2) DEFAULT NULL,
  `nilai_retribusi_keseluruhan_pad` decimal(20,2) DEFAULT NULL,
  `denda` decimal(20,2) DEFAULT NULL,
  `latitude` varchar(255) DEFAULT NULL,
  `longitude` varchar(255) DEFAULT NULL,
  `nik_nib` varchar(255) DEFAULT NULL,
  `dok_tanah` varchar(255) DEFAULT NULL,
  `temuan` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pbg_task_google_sheet_no_registrasi_unique` (`no_registrasi`)
) ENGINE=InnoDB AUTO_INCREMENT=244256 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pbg_task_index_integrations`
--

DROP TABLE IF EXISTS `pbg_task_index_integrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pbg_task_index_integrations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `pbg_task_uid` varchar(255) NOT NULL,
  `indeks_fungsi_bangunan` varchar(255) DEFAULT NULL,
  `indeks_parameter_kompleksitas` varchar(255) DEFAULT NULL,
  `indeks_parameter_permanensi` varchar(255) DEFAULT NULL,
  `indeks_parameter_ketinggian` varchar(255) DEFAULT NULL,
  `faktor_kepemilikan` varchar(255) DEFAULT NULL,
  `indeks_terintegrasi` varchar(255) DEFAULT NULL,
  `total` decimal(8,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pbg_task_index_integrations_pbg_task_uid_unique` (`pbg_task_uid`)
) ENGINE=InnoDB AUTO_INCREMENT=50759 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pbg_task_prasarana`
--

DROP TABLE IF EXISTS `pbg_task_prasarana`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pbg_task_prasarana` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `pbg_task_uid` varchar(255) DEFAULT NULL,
  `prasarana_id` int(11) DEFAULT NULL,
  `prasarana_type` varchar(255) DEFAULT NULL,
  `building_type` varchar(255) DEFAULT NULL,
  `total` decimal(20,2) DEFAULT NULL,
  `quantity` decimal(8,2) DEFAULT NULL,
  `unit` varchar(255) DEFAULT NULL,
  `index_prasarana` decimal(8,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `pbg_task_retribution_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pbg_task_prasarana_prasarana_id_unique` (`prasarana_id`),
  KEY `pbg_task_prasarana_pbg_task_retribution_id_foreign` (`pbg_task_retribution_id`),
  CONSTRAINT `pbg_task_prasarana_pbg_task_retribution_id_foreign` FOREIGN KEY (`pbg_task_retribution_id`) REFERENCES `pbg_task_retributions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=81114 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `pbg_task_retributions`
--

DROP TABLE IF EXISTS `pbg_task_retributions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pbg_task_retributions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `detail_id` varchar(255) NOT NULL,
  `detail_created_at` timestamp NULL DEFAULT NULL,
  `detail_updated_at` timestamp NULL DEFAULT NULL,
  `detail_uid` varchar(255) DEFAULT NULL,
  `luas_bangunan` decimal(8,2) DEFAULT NULL,
  `indeks_lokalitas` decimal(10,4) DEFAULT NULL,
  `wilayah_shst` varchar(255) DEFAULT NULL,
  `kegiatan_id` int(11) DEFAULT NULL,
  `kegiatan_name` varchar(255) DEFAULT NULL,
  `nilai_shst` decimal(20,2) DEFAULT NULL,
  `indeks_terintegrasi` decimal(20,15) DEFAULT NULL,
  `indeks_bg_terbangun` decimal(8,2) DEFAULT NULL,
  `nilai_retribusi_bangunan` decimal(20,2) DEFAULT NULL,
  `nilai_prasarana` decimal(8,2) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `pbg_document` int(11) DEFAULT NULL,
  `underpayment` int(11) DEFAULT NULL,
  `skrd_amount` decimal(20,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `pbg_task_uid` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pbg_task_retributions_detail_id_unique` (`detail_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4376 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `permit_status`
--

DROP TABLE IF EXISTS `permit_status`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `permit_status` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `permit_status` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `personal_access_tokens`
--

DROP TABLE IF EXISTS `personal_access_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `provincies`
--

DROP TABLE IF EXISTS `provincies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `provincies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `province_code` int(11) NOT NULL,
  `province_name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `regencies`
--

DROP TABLE IF EXISTS `regencies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `regencies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `province_code` int(11) NOT NULL,
  `regency_code` int(11) NOT NULL,
  `regency_name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=515 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `role_menu`
--

DROP TABLE IF EXISTS `role_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role_menu` (
  `role_id` bigint(20) unsigned NOT NULL,
  `menu_id` bigint(20) unsigned NOT NULL,
  `allow_show` tinyint(1) NOT NULL DEFAULT 1,
  `allow_create` tinyint(1) NOT NULL DEFAULT 1,
  `allow_update` tinyint(1) NOT NULL DEFAULT 1,
  `allow_destroy` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`role_id`,`menu_id`),
  KEY `role_menu_menu_id_foreign` (`menu_id`),
  CONSTRAINT `role_menu_menu_id_foreign` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_menu_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `roles`
--

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `sessions`
--

DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `spatial_plannings`
--

DROP TABLE IF EXISTS `spatial_plannings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `spatial_plannings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `name` varchar(255) DEFAULT NULL,
  `kbli` varchar(255) DEFAULT NULL,
  `activities` varchar(255) DEFAULT NULL,
  `area` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `number` varchar(255) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `task_assignments`
--

DROP TABLE IF EXISTS `task_assignments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `task_assignments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ta_id` bigint(20) DEFAULT NULL,
  `pbg_task_uid` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `username` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone_number` varchar(255) DEFAULT NULL,
  `role` varchar(255) NOT NULL,
  `role_name` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `file` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`file`)),
  `expertise` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`expertise`)),
  `experience` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`experience`)),
  `is_verif` tinyint(1) NOT NULL DEFAULT 0,
  `uid` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `status_name` varchar(255) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `task_assignments_uid_unique` (`uid`),
  KEY `task_assignments_pbg_task_uid_foreign` (`pbg_task_uid`),
  CONSTRAINT `task_assignments_pbg_task_uid_foreign` FOREIGN KEY (`pbg_task_uid`) REFERENCES `pbg_task` (`uuid`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8492 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tourisms`
--

DROP TABLE IF EXISTS `tourisms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tourisms` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `project_id` varchar(255) NOT NULL,
  `project_type_id` varchar(255) NOT NULL,
  `nib` varchar(255) NOT NULL,
  `business_name` varchar(255) NOT NULL,
  `oss_publication_date` datetime NOT NULL,
  `investment_status_description` varchar(255) NOT NULL,
  `business_form` varchar(255) NOT NULL,
  `project_risk` varchar(255) NOT NULL,
  `project_name` varchar(255) NOT NULL,
  `business_scale` varchar(255) NOT NULL,
  `business_address` varchar(255) NOT NULL,
  `district_code` int(11) NOT NULL,
  `village_code` varchar(255) NOT NULL,
  `longitude` varchar(255) NOT NULL,
  `latitude` varchar(255) NOT NULL,
  `project_submission_date` datetime NOT NULL,
  `kbli` varchar(255) NOT NULL,
  `kbli_title` varchar(255) NOT NULL,
  `supervisory_sector` varchar(255) NOT NULL,
  `user_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `contact` varchar(255) NOT NULL,
  `land_area_in_m2` varchar(255) NOT NULL,
  `investment_amount` varchar(255) NOT NULL,
  `tki` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=249 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `umkms`
--

DROP TABLE IF EXISTS `umkms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `umkms` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `business_name` varchar(255) NOT NULL,
  `business_address` varchar(255) NOT NULL,
  `business_desc` varchar(255) NOT NULL,
  `business_contact` varchar(255) NOT NULL,
  `business_id_number` varchar(255) DEFAULT NULL,
  `business_scale_id` int(11) NOT NULL,
  `owner_id` varchar(255) NOT NULL,
  `owner_name` varchar(255) NOT NULL,
  `owner_address` varchar(255) NOT NULL,
  `owner_contact` varchar(255) NOT NULL,
  `business_type` varchar(255) NOT NULL,
  `revenue` decimal(20,2) NOT NULL,
  `village_code` varchar(255) NOT NULL,
  `district_code` int(11) NOT NULL,
  `number_of_employee` int(11) NOT NULL,
  `land_area` int(11) DEFAULT NULL,
  `permit_status_id` int(11) NOT NULL,
  `business_form_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `user_role`
--

DROP TABLE IF EXISTS `user_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_role` (
  `user_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`user_id`,`role_id`),
  KEY `user_role_role_id_foreign` (`role_id`),
  CONSTRAINT `user_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_role_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `firstname` varchar(255) NOT NULL,
  `lastname` varchar(255) NOT NULL,
  `position` varchar(255) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Temporary table structure for view `v_advertisements`
--

DROP TABLE IF EXISTS `v_advertisements`;
/*!50001 DROP VIEW IF EXISTS `v_advertisements`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `v_advertisements` AS SELECT
 1 AS `no`,
  1 AS `business_name`,
  1 AS `npwpd`,
  1 AS `advertisement_type`,
  1 AS `advertisement_content`,
  1 AS `business_address`,
  1 AS `advertisement_location`,
  1 AS `village_name`,
  1 AS `district_name`,
  1 AS `length`,
  1 AS `width`,
  1 AS `viewing_angle`,
  1 AS `face`,
  1 AS `area`,
  1 AS `angle`,
  1 AS `contact` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `v_pbg_task_with_retributions`
--

DROP TABLE IF EXISTS `v_pbg_task_with_retributions`;
/*!50001 DROP VIEW IF EXISTS `v_pbg_task_with_retributions`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `v_pbg_task_with_retributions` AS SELECT
 1 AS `id`,
  1 AS `uuid`,
  1 AS `name`,
  1 AS `owner_name`,
  1 AS `application_type`,
  1 AS `application_type_name`,
  1 AS `condition`,
  1 AS `registration_number`,
  1 AS `document_number`,
  1 AS `address`,
  1 AS `status`,
  1 AS `status_name`,
  1 AS `slf_status`,
  1 AS `slf_status_name`,
  1 AS `function_type`,
  1 AS `consultation_type`,
  1 AS `due_date`,
  1 AS `land_certificate_phase`,
  1 AS `created_at`,
  1 AS `updated_at`,
  1 AS `task_created_at`,
  1 AS `nilai_retribusi_bangunan` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `v_tourisms`
--

DROP TABLE IF EXISTS `v_tourisms`;
/*!50001 DROP VIEW IF EXISTS `v_tourisms`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `v_tourisms` AS SELECT
 1 AS `project_id`,
  1 AS `project_type_id`,
  1 AS `nib`,
  1 AS `business_name`,
  1 AS `oss_publication_date`,
  1 AS `investment_status_description`,
  1 AS `business_form`,
  1 AS `project_risk`,
  1 AS `project_name`,
  1 AS `business_scale`,
  1 AS `business_address`,
  1 AS `village_name`,
  1 AS `district_name`,
  1 AS `longitude`,
  1 AS `latitude`,
  1 AS `project_submission_date`,
  1 AS `kbli_title`,
  1 AS `supervisory_sector`,
  1 AS `user_name`,
  1 AS `email`,
  1 AS `contact`,
  1 AS `land_area_in_m2`,
  1 AS `investment_amount`,
  1 AS `tki` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `v_tourisms_based_kbli`
--

DROP TABLE IF EXISTS `v_tourisms_based_kbli`;
/*!50001 DROP VIEW IF EXISTS `v_tourisms_based_kbli`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `v_tourisms_based_kbli` AS SELECT
 1 AS `kbli_title`,
  1 AS `total_records` */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `v_umkms`
--

DROP TABLE IF EXISTS `v_umkms`;
/*!50001 DROP VIEW IF EXISTS `v_umkms`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `v_umkms` AS SELECT
 1 AS `business_address`,
  1 AS `business_contact`,
  1 AS `business_desc`,
  1 AS `business_form`,
  1 AS `business_id_number`,
  1 AS `business_name`,
  1 AS `business_scale`,
  1 AS `business_type`,
  1 AS `created_at`,
  1 AS `district_name`,
  1 AS `land_area`,
  1 AS `number_of_employee`,
  1 AS `owner_address`,
  1 AS `owner_contact`,
  1 AS `owner_id`,
  1 AS `owner_name`,
  1 AS `permit_status`,
  1 AS `revenue`,
  1 AS `updated_at`,
  1 AS `village_name` */;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `villages`
--

DROP TABLE IF EXISTS `villages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `villages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `district_code` int(11) NOT NULL,
  `village_code` varchar(255) NOT NULL,
  `village_name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=83762 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Final view structure for view `v_advertisements`
--

/*!50001 DROP VIEW IF EXISTS `v_advertisements`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8mb4 */;
/*!50001 SET character_set_results     = utf8mb4 */;
/*!50001 SET collation_connection      = utf8mb4_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`admin`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_advertisements` AS select `a`.`no` AS `no`,`a`.`business_name` AS `business_name`,`a`.`npwpd` AS `npwpd`,`a`.`advertisement_type` AS `advertisement_type`,`a`.`advertisement_content` AS `advertisement_content`,`a`.`business_address` AS `business_address`,`a`.`advertisement_location` AS `advertisement_location`,`v`.`village_name` AS `village_name`,`d`.`district_name` AS `district_name`,`a`.`length` AS `length`,`a`.`width` AS `width`,`a`.`viewing_angle` AS `viewing_angle`,`a`.`face` AS `face`,`a`.`area` AS `area`,`a`.`angle` AS `angle`,`a`.`contact` AS `contact` from ((`advertisements` `a` join `villages` `v` on(`a`.`village_code` = `v`.`village_code`)) join `districts` `d` on(`a`.`district_code` = `d`.`district_code`)) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `v_pbg_task_with_retributions`
--

/*!50001 DROP VIEW IF EXISTS `v_pbg_task_with_retributions`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8mb4 */;
/*!50001 SET character_set_results     = utf8mb4 */;
/*!50001 SET collation_connection      = utf8mb4_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`admin`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_pbg_task_with_retributions` AS select `pt`.`id` AS `id`,`pt`.`uuid` AS `uuid`,`pt`.`name` AS `name`,`pt`.`owner_name` AS `owner_name`,`pt`.`application_type` AS `application_type`,`pt`.`application_type_name` AS `application_type_name`,`pt`.`condition` AS `condition`,`pt`.`registration_number` AS `registration_number`,`pt`.`document_number` AS `document_number`,`pt`.`address` AS `address`,`pt`.`status` AS `status`,`pt`.`status_name` AS `status_name`,`pt`.`slf_status` AS `slf_status`,`pt`.`slf_status_name` AS `slf_status_name`,`pt`.`function_type` AS `function_type`,`pt`.`consultation_type` AS `consultation_type`,`pt`.`due_date` AS `due_date`,`pt`.`land_certificate_phase` AS `land_certificate_phase`,`pt`.`created_at` AS `created_at`,`pt`.`updated_at` AS `updated_at`,`pt`.`task_created_at` AS `task_created_at`,`ptr`.`nilai_retribusi_bangunan` AS `nilai_retribusi_bangunan` from (`pbg_task` `pt` join `pbg_task_retributions` `ptr` on(`pt`.`uuid` = `ptr`.`pbg_task_uid`)) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `v_tourisms`
--

/*!50001 DROP VIEW IF EXISTS `v_tourisms`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8mb4 */;
/*!50001 SET character_set_results     = utf8mb4 */;
/*!50001 SET collation_connection      = utf8mb4_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`admin`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_tourisms` AS select `t`.`project_id` AS `project_id`,`t`.`project_type_id` AS `project_type_id`,`t`.`nib` AS `nib`,`t`.`business_name` AS `business_name`,`t`.`oss_publication_date` AS `oss_publication_date`,`t`.`investment_status_description` AS `investment_status_description`,`t`.`business_form` AS `business_form`,`t`.`project_risk` AS `project_risk`,`t`.`project_name` AS `project_name`,`t`.`business_scale` AS `business_scale`,`t`.`business_address` AS `business_address`,`v`.`village_name` AS `village_name`,`d`.`district_name` AS `district_name`,`t`.`longitude` AS `longitude`,`t`.`latitude` AS `latitude`,`t`.`project_submission_date` AS `project_submission_date`,`t`.`kbli_title` AS `kbli_title`,`t`.`supervisory_sector` AS `supervisory_sector`,`t`.`user_name` AS `user_name`,`t`.`email` AS `email`,`t`.`contact` AS `contact`,`t`.`land_area_in_m2` AS `land_area_in_m2`,`t`.`investment_amount` AS `investment_amount`,`t`.`tki` AS `tki` from ((`tourisms` `t` join `villages` `v` on(`t`.`village_code` = `v`.`village_code`)) join `districts` `d` on(`t`.`district_code` = `d`.`district_code`)) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `v_tourisms_based_kbli`
--

/*!50001 DROP VIEW IF EXISTS `v_tourisms_based_kbli`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8mb4 */;
/*!50001 SET character_set_results     = utf8mb4 */;
/*!50001 SET collation_connection      = utf8mb4_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`admin`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_tourisms_based_kbli` AS select `subquery`.`kbli_title` AS `kbli_title`,`subquery`.`total_records` AS `total_records` from (select `tourisms`.`kbli` AS `kbli`,`tourisms`.`kbli_title` AS `kbli_title`,count(0) AS `total_records` from `tourisms` group by `tourisms`.`kbli`,`tourisms`.`kbli_title`) `subquery` order by `subquery`.`total_records` desc */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `v_umkms`
--

/*!50001 DROP VIEW IF EXISTS `v_umkms`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8mb4 */;
/*!50001 SET character_set_results     = utf8mb4 */;
/*!50001 SET collation_connection      = utf8mb4_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`admin`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_umkms` AS select `u`.`business_address` AS `business_address`,`u`.`business_contact` AS `business_contact`,`u`.`business_desc` AS `business_desc`,`bf`.`business_form` AS `business_form`,`u`.`business_id_number` AS `business_id_number`,`u`.`business_name` AS `business_name`,`bs`.`business_scale` AS `business_scale`,`u`.`business_type` AS `business_type`,`u`.`created_at` AS `created_at`,`d`.`district_name` AS `district_name`,`u`.`land_area` AS `land_area`,`u`.`number_of_employee` AS `number_of_employee`,`u`.`owner_address` AS `owner_address`,`u`.`owner_contact` AS `owner_contact`,`u`.`owner_id` AS `owner_id`,`u`.`owner_name` AS `owner_name`,`ps`.`permit_status` AS `permit_status`,`u`.`revenue` AS `revenue`,`u`.`updated_at` AS `updated_at`,`v`.`village_name` AS `village_name` from (((((`umkms` `u` join `business_form` `bf` on(`u`.`business_form_id` = `bf`.`id`)) join `permit_status` `ps` on(`u`.`permit_status_id` = `ps`.`id`)) join `business_scale` `bs` on(`u`.`business_scale_id` = `bs`.`id`)) join `villages` `v` on(`u`.`village_code` = `v`.`village_code`)) join `districts` `d` on(`u`.`district_code` = `v`.`district_code`)) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-03-27 15:26:56
