arifal/sibedas
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
feat/upload-pbg-task
sibedas/sibedas.sql
arifal 7b70591be5 add readme and backup schema local
2025-03-27 15:28:21 +07:00

1165 lines
48 KiB
SQL
Raw Permalink Blame History

/*!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
Reference in New Issue View Git Blame Copy Permalink