CREATE TABLE `data_catatan_rfk_unit` (
  `id` int(11) NOT NULL auto_increment,
  `bulan` tinyint(2) NOT NULL,
  `catatan_ka_adbang` text NOT NULL,
  `id_skpd` int(11) NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `created_by` text NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` text NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rekanan_sipd`(
  `id` int not null auto_increment,
  `id_daerah` int,
  `id_skpd` int(11) NOT NULL,
  `nomor_rekening` varchar(80) DEFAULT 0,
  `nama_rekening` text,
  `id_bank` int DEFAULT NULL,
  `nama_bank` varchar(255) DEFAULT NULL,
  `cabang_bank` varchar(255) DEFAULT NULL,
  `nama_tujuan` text DEFAULT NULL,
  `nama_perusahaan` text DEFAULT NULL,
  `alamat_perusahaan` text DEFAULT NULL,
  `telepon_perusahaan` varchar(255) DEFAULT NULL,
  `npwp` varchar(255) DEFAULT NULL,
  `nik` varchar(255) DEFAULT NULL,
  `jenis_rekanan` varchar(255) DEFAULT NULL,
  `kategori_rekanan` varchar(255) DEFAULT NULL,
  `is_valid` bit(1) DEFAULT NULL,
  `is_locked` bit(1) DEFAULT NULL,
  `active` tinyint,
  `created_at` datetime,
  `created_by` int DEFAULT NULL,
  `updated_at` datetime,
  `tahun_anggaran` year,
  PRIMARY KEY (id)
);

CREATE TABLE `data_spd_sipd`(
  `id` int not null auto_increment,
  `idSpd` int,
  `nomorSpd` varchar(80),
  `keteranganSpd` varchar(80),
  `ketentuanLainnya` varchar(500),
  `id_skpd` int,
  `totalSpd` double,
  `active` tinyint,
  `created_at` datetime,
  `tahun_anggaran` year,
  PRIMARY KEY (id)
);

CREATE TABLE `data_npd_sipd`(
  `id` bigint not null auto_increment,
  `id_npd` int,
  `nomor_npd` text DEFAULT NULL, 
  `id_daerah` int,
  `id_unit` int,
  `id_skpd` int,
  `id_sub_skpd` int,
  `nilai_npd` double,
  `nilai_npd_disetujui` double,
  `tanggal_npd` date DEFAULT NULL,
  `tanggal_npd_selesai` date DEFAULT NULL,
  `keterangan_npd` text DEFAULT NULL, 
  `is_verifikasi_npd` bit(1) DEFAULT NULL, 
  `verifikasi_npd_at` date DEFAULT NULL,
  `verifikasi_npd_by` int DEFAULT 0,
  `nomor_verifikasi` text DEFAULT NULL,
  `is_npd_panjar` bit(1) DEFAULT NULL, 
  `kondisi_selesai` int DEFAULT 0,
  `selesai_at` date DEFAULT NULL,
  `selesai_by` int DEFAULT 0,
  `nomor_selesai` text DEFAULT NULL,
  `nilai_pengembalian` double,
  `nilai_kurang_bayar` double,
  `nomor_kurang_lebih` text DEFAULT NULL,
  `kurang_lebih_at` date DEFAULT NULL,
  `kurang_lebih_by` int DEFAULT 0,
  `is_validasi_npd` bit(1) DEFAULT NULL, 
  `validasi_npd_at` date DEFAULT NULL,
  `validasi_npd_by` int DEFAULT 0,
  `is_tbp` bit(1) DEFAULT NULL, 
  `tbp_at` date DEFAULT NULL,
  `tbp_by` int DEFAULT 0,
  `id_jadwal` int DEFAULT 0,
  `id_tahap` int DEFAULT 0,
  `status_tahap` text DEFAULT NULL,
  `kode_tahap` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `kode_sub_skpd` text DEFAULT NULL,
  `nama_sub_skpd` text DEFAULT NULL,
  `total_pertanggungjawaban` double,
  `active` tinyint,
  `created_by` int DEFAULT NULL,
  `created_at` datetime,
  `update_at` datetime,
  `tahun_anggaran` year,
  PRIMARY KEY (id)
);

CREATE TABLE `data_lpj_bpp_sipd`(
  `id` bigint not null auto_increment,
  `id_lpj_bpp` int,
  `nomor_lpj_bpp` text DEFAULT NULL, 
  `id_daerah` int,
  `id_unit` int,
  `id_skpd` int,
  `id_sub_skpd` int,
  `nilai_lpj_bpp` double,  
  `tanggal_lpj_bpp` date DEFAULT NULL,  
  `jenis_lpj_bpp` text DEFAULT NULL, 
  `id_pegawai_pa_kpa` int DEFAULT NULL, 
  `is_verifikasi_lpj_bpp` bit(1) DEFAULT NULL, 
  `verifikasi_lpj_bpp_at` date DEFAULT NULL,
  `verifikasi_lpj_bpp_by` int DEFAULT 0,  
  `is_val_i_dasi_lpj_bpp` bit(1) DEFAULT NULL,   
  `val_i_dasi_lpj_bpp_at` date DEFAULT NULL,
  `val_i_dasi_lpj_bpp_by` int DEFAULT 0,  
  `is_spp_gu` bit(1) DEFAULT NULL, 
  `spp_gu_at` date DEFAULT NULL,
  `spp_gu_by` int DEFAULT 0,  
  `id_jadwal` int DEFAULT 0,
  `id_tahap` int DEFAULT 0,
  `status_tahap` text DEFAULT NULL,
  `kode_tahap` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `kode_sub_skpd` text DEFAULT NULL,
  `nama_sub_skpd` text DEFAULT NULL,
  `total_pertanggungjawaban` double,
  `active` tinyint,
  `created_by` int DEFAULT NULL,
  `created_at` datetime,
  `update_at` datetime,
  `tahun_anggaran` year,
  PRIMARY KEY (id)
);

CREATE TABLE `data_lpj_sipd_detail` (
  `id` bigint NOT NULL auto_increment,
  `id_skpd` int,
  `id_lpj` int(11) DEFAULT NULL,  
  `tipe` text DEFAULT NULL,
  `nama_daerah` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `nama_sub_skpd` text DEFAULT NULL,
  `nomor_lpj` varchar(255) DEFAULT NULL,
  `tanggal_lpj` datetime DEFAULT NULL,
  `up_awal` double DEFAULT 0,
  `penggunaan_up` double DEFAULT 0,
  `up_akhir` double DEFAULT 0,
  `nama_bp_bpp` text DEFAULT NULL,
  `nip_bp_bpp` text DEFAULT NULL,
  `jabatan_bp_bpp` text DEFAULT NULL,
  `active` tinyint,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_lpj_sipd_detail_rekening` (
  `id` int(11) NOT NULL auto_increment,
  `id_lpj` int(11) DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `kode_rekening` text DEFAULT NULL,
  `uraian` text DEFAULT NULL,
  `jumlah_anggaran` double(20,2) DEFAULT NULL,
  `belanja_periode_ini` double(20,2) DEFAULT NULL,
  `akumulasi_belanja` double(20,2) DEFAULT NULL,
  `sisa_anggaran` double(20,2) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_buku_jurnal_sipd` (
  `id` bigint NOT NULL auto_increment,
  `id_skpd` int DEFAULT NULL,
  `id_jurnal` int(11) DEFAULT NULL,  
  `nama_skpd` text DEFAULT NULL,
  `nomor_jurnal` varchar(255) DEFAULT NULL,
  `tanggal_jurnal` date DEFAULT NULL,  
  `dokumen_sumber` text DEFAULT NULL,
  `active` tinyint,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_buku_jurnal_sipd_detail` (
  `id` int(11) NOT NULL auto_increment,
  `id_jurnal` int(11) DEFAULT NULL,
  `id_detail` int(11) DEFAULT NULL,
  `account_id` int(11) DEFAULT NULL,  
  `amount` double(20,2) DEFAULT NULL,
  `kode_rekening` text DEFAULT NULL,
  `nama_rekening` text DEFAULT NULL,
  `position` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `aklap_lra_sipd` (
  `id` int(11) NOT NULL auto_increment,
  `id_daerah` int,
  `id_skpd` int(11) DEFAULT NULL,
  `kode_rekening` text DEFAULT NULL,
  `level` text DEFAULT NULL,
  `nama_rekening` text DEFAULT NULL,  
  `nominal` double(20,2) DEFAULT NULL,
  `presentase` double(20,10) DEFAULT NULL,
  `previous_realisasi` double(20,2) DEFAULT NULL,
  `realisasi` double(20,2) DEFAULT NULL,  
  `mulai_tgl` date NOT NULL,
  `sampai_tgl` date NOT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_npd_sipd_detail` (
  `id` bigint NOT NULL auto_increment,
  `id_skpd` int,
  `id_npd` int(11) DEFAULT NULL,
  `id_daerah` int,
  `nama_daerah` text DEFAULT NULL,
  `nomor_npd` varchar(255) DEFAULT NULL,
  `tanggal_npd` datetime DEFAULT NULL,
  `kondisi_panjar` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `nama_sub_skpd` text DEFAULT NULL,
  `nama_pptk` text DEFAULT NULL,
  `nip_pptk` text DEFAULT NULL,
  `jabatan_pptk` text DEFAULT NULL,
  `nama_pa_kpa` text DEFAULT NULL,
  `nip_pa_kpa` varchar(30) DEFAULT NULL,
  `jabatan_pa_kpa` text DEFAULT NULL,
  `nomor_dpa` varchar(255) DEFAULT NULL,
  `id_program` int,
  `kode_program` varchar(255) DEFAULT NULL,
  `nama_program` varchar(255) DEFAULT NULL,
  `id_giat` int,
  `kode_giat` text DEFAULT NULL,
  `nama_giat` text DEFAULT NULL,
  `id_sub_giat` int,
  `kode_sub_giat` text DEFAULT NULL,
  `nama_sub_giat` text DEFAULT NULL,
  `keterangan_npd` text DEFAULT NULL,
  `active` tinyint,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_npd_sipd_detail_rekening` (
  `id` int(11) NOT NULL auto_increment,
  `id_npd` int(11) DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `kode_rekening` text DEFAULT NULL,
  `uraian` text DEFAULT NULL,
  `anggaran` double(20,2) DEFAULT NULL,
  `sisa_anggaran` double(20,2) DEFAULT NULL,
  `rencana_penarikan` double(20,2) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_tbp_sipd`(
  `id` bigint not null auto_increment,
  `id_tbp` int,
  `id_sp2d_distribusi` int,
  `id_sp2d` int,
  `nomor_tbp` varchar(255),
  `id_daerah` int,
  `id_unit` int,
  `id_skpd` int,
  `id_sub_skpd` int,
  `nilai_tbp` double,
  `tanggal_tbp` date DEFAULT NULL,  
  `keterangan_tbp` text, 
  `nilai_materai_tbp` double,
  `nomor_kwitansi` varchar(255),
  `id_pegawai_pa_kpa` int,
  `jenis_tbp` varchar(80),
  `jenis_ls_tbp` varchar(80),
  `is_kunci_rekening_tbp` bit(1) DEFAULT NULL,  
  `is_panjar` bit(1) DEFAULT NULL,  
  `is_lpj` bit(1) DEFAULT NULL,  
  `id_lpj` bit(1) DEFAULT NULL,  
  `id_npd` bit(1) DEFAULT NULL,
  `is_rekanan_upload` bit(1) DEFAULT NULL,  
  `status_aklap` bit(1) DEFAULT NULL,  
  `nomor_jurnal` varchar(255),
  `jurnal_id` int,
  `metode` varchar(255),
  `id_jadwal` int,
  `id_tahap` int,
  `status_tahap` varchar(255),
  `kode_tahap` varchar(255),
  `kode_skpd` varchar(255),
  `nama_skpd` varchar(255),
  `kode_sub_skpd` varchar(255),
  `nama_sub_skpd` varchar(255),  
  `total_pertanggungjawaban` double,
  `active` tinyint,
  `created_by` int DEFAULT NULL,
  `created_at` datetime,
  `update_at` datetime,
  `tahun_anggaran` year,
  PRIMARY KEY (id)
);

CREATE TABLE `data_tbp_sipd_detail` (
  `id` bigint NOT NULL auto_increment,
  `id_skpd` int,
  `id_tbp` int(11) DEFAULT NULL,
  `jenis` text DEFAULT NULL,
  `nama_daerah` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `nomor_tbp` varchar(255) DEFAULT NULL,
  `nilai_tbp` double,
  `nama_tujuan` text DEFAULT NULL,
  `alamat_perusahaan` text DEFAULT NULL,  
  `npwp` varchar(255) DEFAULT NULL,  
  `nomor_rekening` varchar(255) DEFAULT NULL,
  `nama_rekening` text DEFAULT NULL,
  `nama_bank` text DEFAULT NULL,
  `keterangan_tbp` text DEFAULT NULL,
  `jenis_transaksi` text DEFAULT NULL,  
  `nomor_npd` varchar(255) DEFAULT NULL,
  `jenis_panjar` text DEFAULT NULL,
  `tanggal_tbp` datetime DEFAULT NULL,
  `nama_pa_kpa` text DEFAULT NULL,
  `nip_pa_kpa` varchar(30) DEFAULT NULL,
  `jabatan_pa_kpa` text DEFAULT NULL,
  `nama_bp_bpp` text DEFAULT NULL,
  `nip_bp_bpp` varchar(30) DEFAULT NULL,
  `jabatan_bp_bpp` text DEFAULT NULL,  
  `pajak_potongan` text DEFAULT NULL,
  `jenis_tbp` varchar(80),   
  `active` tinyint,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_tbp_sipd_detail_rekening` (
  `id` int(11) NOT NULL auto_increment,
  `id_tbp` int(11) DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `kode_rekening` text DEFAULT NULL,
  `uraian` text DEFAULT NULL,
  `jumlah` double(20,2) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_stbp_sipd`(
  `id` int not null auto_increment,
  `id_stbp` int,
  `nomor_stbp` varchar(255),
  `no_rekening` varchar(80),
  `metode_penyetoran` varchar(80),
  `nilai_stbp` double,
  `keterangan_stbp` varchar(500),
  `is_verifikasi_stbp` bit(1) DEFAULT NULL,  
  `is_otorisasi_stbp` bit(1) DEFAULT NULL,
  `is_validasi_stbp` bit(1) DEFAULT NULL,
  `tanggal_stbp` date DEFAULT NULL,
  `id_daerah` int,
  `id_unit` int,
  `id_skpd` int,
  `id_sub_skpd` int,
  `is_sts` bit(1) DEFAULT NULL,
  `status` text DEFAULT NULL,
  `active` tinyint,
  `created_at` datetime,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year,
  PRIMARY KEY (id)
);

CREATE TABLE `data_stbp_sipd_detail` (
  `id` int(11) NOT NULL auto_increment,  
  `id_stbp` int(11) DEFAULT NULL,
  `nama_penyetor` text DEFAULT NULL,
  `metode_input` text DEFAULT NULL,
  `nomor_stbp` text DEFAULT NULL,
  `tanggal_stbp` datetime DEFAULT NULL,
  `id_bank` int,
  `nama_bank` text DEFAULT NULL,
  `no_rekening` text DEFAULT NULL,
  `nilai_stbp` double(20,2) DEFAULT NULL,
  `keterangan_stbp` text DEFAULT NULL,
  `created_by` int,
  `bendahara_penerimaan_nama` text DEFAULT NULL,
  `bendahara_penerimaan_nip` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `id_unit` int,
  `id_skpd` int,
  `id_sub_skpd` int,
  `nama_daerah` text DEFAULT NULL,
  `id_rekening` int,
  `kode_rekening` text DEFAULT NULL,    
  `uraian` text DEFAULT NULL,
  `nilai` double(20,2) DEFAULT NULL,
  `active` tinyint,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_spd_sipd_detail`(
  `id` int(11) NOT NULL auto_increment,
  `idDetailSpd` int,
  `idSpd` int,
  `id_skpd` int,
  `id_sub_skpd` int,
  `id_program` int,
  `id_giat` int,
  `id_sub_giat` int,
  `id_akun` int,
  `kode_standar_harga` text DEFAULT NULL,
  `nama_standar_harga` text DEFAULT NULL,
  `koefisien` text DEFAULT NULL,
  `harga_satuan` double DEFAULT NULL,
  `pajak` text DEFAULT NULL,  
  `nilai` double,
  `active` tinyint,
  `created_at` datetime,
  `tahun_anggaran` year,
  PRIMARY KEY (id)
);

CREATE TABLE `data_up_sipd` (
  `id` int(11) NOT NULL auto_increment,
  `id_besaran_up` int(11) NOT NULL,
  `id_skpd` int(11) NOT NULL,
  `id_sub_skpd` int(11) NOT NULL,
  `pagu` double NOT NULL,
  `besaran_up` double NOT NULL,
  `besaran_up_kkpd` double NOT NULL,
  `active` tinyint(4) NOT NULL,
  `create_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_unit` (
  `id` int(11) NOT NULL auto_increment,
  `id_setup_unit` int(11) DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `is_skpd` tinyint(4) DEFAULT NULL,
  `kode_skpd` varchar(50) DEFAULT NULL,
  `kunci_skpd` int(11) DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `posisi` varchar(30) DEFAULT NULL,
  `status` varchar(30) DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `bidur_1` smallint(6) DEFAULT NULL,
  `bidur_2` smallint(6) DEFAULT NULL,
  `bidur_3` smallint(6) DEFAULT NULL,
  `idinduk` int(11) DEFAULT NULL,
  `ispendapatan` tinyint(4) DEFAULT NULL,
  `isskpd` tinyint(4) DEFAULT NULL,
  `kode_skpd_1` varchar(10) DEFAULT NULL,
  `kode_skpd_2` varchar(10) DEFAULT NULL,
  `kodeunit` varchar(30) DEFAULT NULL,
  `komisi` int(11) DEFAULT NULL,
  `namabendahara` text,
  `namakepala` text DEFAULT NULL,
  `namaunit` text DEFAULT NULL,
  `nipbendahara` varchar(30) DEFAULT NULL,
  `nipkepala` varchar(30) DEFAULT NULL,
  `pangkatkepala` varchar(50) DEFAULT NULL,
  `setupunit` int(11) DEFAULT NULL,
  `statuskepala` varchar(20) DEFAULT NULL,
  `mapping` varchar(10) DEFAULT NULL,
  `id_kecamatan` int(11) DEFAULT NULL,
  `id_strategi` int(11) DEFAULT NULL,
  `is_dpa_khusus` tinyint(4) DEFAULT NULL,
  `is_ppkd` tinyint(4) DEFAULT NULL,
  `set_input` tinyint(4) DEFAULT NULL,
  `update_at` datetime DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL DEFAULT '2021',
  `active` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (id)
);

CREATE TABLE `data_akun` (
  `id` int(11) NOT NULL auto_increment,
  `belanja` varchar(10) DEFAULT NULL,
  `id_akun` int(11) DEFAULT NULL,
  `is_bagi_hasil` tinyint(4) DEFAULT NULL,
  `is_bankeu_khusus` tinyint(4) DEFAULT NULL,
  `is_bankeu_umum` tinyint(4) DEFAULT NULL,
  `is_barjas` tinyint(4) DEFAULT NULL,
  `is_bl` tinyint(4) DEFAULT NULL,
  `is_bos` tinyint(4) DEFAULT NULL,
  `is_btt` tinyint(4) DEFAULT NULL,
  `is_bunga` tinyint(4) DEFAULT NULL,
  `is_gaji_asn` tinyint(4) DEFAULT NULL,
  `is_hibah_brg` tinyint(4) DEFAULT NULL,
  `is_hibah_uang` tinyint(4) DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_modal_tanah` tinyint(4) DEFAULT NULL,
  `is_pembiayaan` tinyint(4) DEFAULT NULL,
  `is_pendapatan` tinyint(4) DEFAULT NULL,
  `is_sosial_brg` tinyint(4) DEFAULT NULL,
  `is_sosial_uang` tinyint(4) DEFAULT NULL,
  `is_subsidi` tinyint(4) DEFAULT NULL,
  `kode_akun` varchar(50) DEFAULT NULL,
  `nama_akun` text DEFAULT NULL,
  `set_input` tinyint(4) DEFAULT NULL,
  `set_lokus` tinyint(4) DEFAULT NULL,
  `ket_akun` varchar(255) DEFAULT NULL,
  `kode_akun_lama` varchar(50) DEFAULT NULL,
  `kode_akun_revisi` varchar(50) DEFAULT NULL,
  `kunci_tahun` tinyint(4) DEFAULT NULL,
  `level` tinyint(4) DEFAULT NULL,
  `mulai_tahun` text DEFAULT NULL,
  `pembiayaan` varchar(50) DEFAULT NULL,
  `pendapatan` varchar(50) DEFAULT NULL,
  `set_kab_kota` tinyint(4) DEFAULT NULL,
  `set_prov` tinyint(4) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `active` tinyint(4) DEFAULT 1 COMMENT '0=hapus, 1=aktif',
  `update_at` datetime DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL DEFAULT '2021',
  PRIMARY KEY (id)
);

CREATE TABLE `data_rka` (
  `id` int(11) NOT NULL auto_increment,
  `created_user` int(11) DEFAULT NULL,
  `createddate` varchar(10) DEFAULT NULL,
  `createdtime` varchar(10) DEFAULT NULL,
  `harga_satuan` double(20,2) DEFAULT NULL,
  `harga_satuan_murni` double(20,2) DEFAULT NULL,
  `id_daerah` int(11) DEFAULT NULL,
  `id_rinci_sub_bl` int(11) DEFAULT NULL,
  `id_standar_nfs` tinyint(4) DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `jenis_bl` varchar(50) DEFAULT NULL,
  `ket_bl_teks` text DEFAULT NULL,
  `substeks` TEXT DEFAULT NULL,
  `id_dana` int(11) DEFAULT NULL,
  `nama_dana` TEXT DEFAULT NULL,
  `is_paket` tinyint(4) DEFAULT NULL,
  `kode_dana` varchar(30) DEFAULT NULL,
  `subtitle_teks` TEXT DEFAULT NULL,
  `kode_akun` varchar(50) DEFAULT NULL,
  `koefisien` text DEFAULT NULL,
  `koefisien_murni` text DEFAULT NULL,
  `lokus_akun_teks` text DEFAULT NULL,
  `nama_akun` text DEFAULT NULL,
  `nama_komponen` text DEFAULT NULL,
  `spek_komponen` text DEFAULT NULL,
  `satuan` varchar(150) DEFAULT NULL,
  `spek` text DEFAULT NULL,
  `sat1` text DEFAULT NULL,
  `sat2` text DEFAULT NULL,
  `sat3` text DEFAULT NULL,
  `sat4` text DEFAULT NULL,
  `volum1` text DEFAULT NULL,
  `volum2` text DEFAULT NULL,
  `volum3` text DEFAULT NULL,
  `volum4` text DEFAULT NULL,
  `volume` text DEFAULT NULL,
  `volume_murni` text DEFAULT NULL,
  `subs_bl_teks` text DEFAULT NULL,
  `total_harga` double(20,2) DEFAULT NULL,
  `rincian` double(20,2) DEFAULT NULL,
  `rincian_murni` double(20,2) DEFAULT NULL,
  `totalpajak` double(20,2) DEFAULT NULL,
  `pajak` double(20,2) DEFAULT NULL,
  `pajak_murni` double(20,2) DEFAULT NULL,
  `updated_user` int(11) DEFAULT NULL,
  `updateddate` varchar(20) DEFAULT NULL,
  `updatedtime` varchar(20) DEFAULT NULL,
  `user1` text DEFAULT NULL,
  `user2` text DEFAULT NULL,
  `active` tinyint(4) DEFAULT 1,
  `akun_locked` tinyint(4) DEFAULT NULL,
  `ssh_locked` tinyint(4) DEFAULT NULL,
  `update_at` datetime DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL DEFAULT '2021',
  `idbl` int(11) DEFAULT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `kode_bl` varchar(50) NOT NULL,
  `kode_sbl` varchar(50) NOT NULL,
  `id_prop_penerima` int(11) DEFAULT NULL,
  `id_camat_penerima` int(11) DEFAULT NULL,
  `id_kokab_penerima` int(11) DEFAULT NULL,
  `id_lurah_penerima` int(11) DEFAULT NULL,
  `id_penerima` int(11) DEFAULT NULL,
  `idkomponen` double(20,2) DEFAULT NULL,
  `idketerangan` int(11) DEFAULT NULL,
  `idsubtitle` int(11) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_capaian_prog_sub_keg` (
  `id` int(11) NOT NULL auto_increment,
  `satuancapaian` varchar(50) DEFAULT NULL,
  `targetcapaianteks` varchar(50) DEFAULT NULL,
  `capaianteks` text,
  `targetcapaian` int(11) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `bobot_kinerja` varchar(50) DEFAULT 1,
  `active` tinyint(4) DEFAULT '1',
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_capaian_prog_sub_keg_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `satuancapaian` varchar(50) DEFAULT NULL,
  `targetcapaianteks` varchar(50) DEFAULT NULL,
  `capaianteks` text,
  `targetcapaian` int(11) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `bobot_kinerja` varchar(50) DEFAULT 1,
  `active` tinyint(4) DEFAULT '1',
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `satuancapaian_usulan` varchar(50) DEFAULT NULL,
  `targetcapaianteks_usulan` varchar(50) DEFAULT NULL,
  `capaianteks_usulan` text DEFAULT NULL,
  `targetcapaian_usulan` int(11) DEFAULT NULL,
  `catatan` text DEFAULT NULL,
  `catatan_usulan` text DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_dana_sub_keg` (
  `id` int(11) NOT NULL auto_increment,
  `namadana` text DEFAULT NULL,
  `kodedana` varchar(50) DEFAULT NULL,
  `iddana` int(11) DEFAULT NULL,
  `iddanasubbl` int(11) DEFAULT NULL,
  `pagudana` double(20,2) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `active` tinyint(4) DEFAULT 1,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);


CREATE TABLE `data_output_giat_sub_keg` (
  `id` int(11) NOT NULL auto_increment,
  `outputteks` text,
  `satuanoutput` varchar(50) DEFAULT NULL,
  `targetoutput` varchar(50) DEFAULT NULL,
  `targetoutputteks` varchar(50) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `bobot_kinerja` varchar(50) DEFAULT 1,
  `active` tinyint(4) DEFAULT '1',
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_output_giat_sub_keg_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `outputteks` text,
  `satuanoutput` varchar(50) DEFAULT NULL,
  `targetoutput` varchar(50) DEFAULT NULL,
  `targetoutputteks` varchar(50) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `bobot_kinerja` varchar(50) DEFAULT 1,
  `active` tinyint(4) DEFAULT '1',
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `outputteks_usulan` text DEFAULT NULL,
  `satuanoutput_usulan` varchar(50) DEFAULT NULL,
  `targetoutput_usulan` varchar(50) DEFAULT NULL,
  `targetoutputteks_usulan` varchar(50) DEFAULT NULL,
  `catatan` text DEFAULT NULL,
  `catatan_usulan` text DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_keg_indikator_hasil` (
  `id` int(11) NOT NULL auto_increment,
  `hasilteks` text,
  `satuanhasil` varchar(50) DEFAULT NULL,
  `targethasil` varchar(50) DEFAULT NULL,
  `targethasilteks` varchar(50) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `idsubbl` varchar(50) DEFAULT NULL,
  `active` tinyint(4) DEFAULT 1,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_ssh` (
  `id` int(11) NOT NULL auto_increment,
  `id_standar_harga` int(11) DEFAULT NULL,
  `kode_standar_harga` varchar(30) DEFAULT NULL,
  `nama_standar_harga` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `spek` text DEFAULT NULL,
  `ket_teks` text DEFAULT NULL,
  `created_at` VARCHAR(225) DEFAULT NULL,
  `created_user` int(11) DEFAULT NULL,
  `updated_user` int(11) DEFAULT NULL,
  `is_deleted` tinyint(4) DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `kelompok` tinyint(4) DEFAULT NULL,
  `harga` double(20,2) DEFAULT NULL,
  `harga_2` double(20,2) DEFAULT NULL,
  `harga_3` double(20,2) DEFAULT NULL,
  `kode_kel_standar_harga` varchar(30) DEFAULT NULL,
  `nama_kel_standar_harga` text DEFAULT NULL,
  `update_at` datetime DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL DEFAULT '2020',
  `jenis_produk` varchar(32) DEFAULT NULL,
  `active` tinyint(4) DEFAULT 1,
  `tkdn` double(20,2) DEFAULT NULL,
  PRIMARY KEY (id),
  KEY `id_standar_harga` (`id_standar_harga`)
);

CREATE TABLE `data_ssh_rek_belanja` (
  `id` int(11) NOT NULL auto_increment,
  `id_akun` int(11) NOT NULL,
  `kode_akun` varchar(50) NOT NULL,
  `nama_akun` text NOT NULL,
  `id_standar_harga` int(11) NOT NULL,
  `active` tinyint(4) DEFAULT 1,
  `update_at` datetime DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL DEFAULT '2021',
  PRIMARY KEY (id),
  KEY `id_standar_harga` (`id_standar_harga`),
  CONSTRAINT `data_ssh_rek_belanja_ibfk_1` FOREIGN KEY (`id_standar_harga`) REFERENCES `data_ssh` (`id_standar_harga`)
);

CREATE TABLE `data_sub_keg_indikator` (
  `id` int(11) NOT NULL auto_increment,
  `outputteks` text NOT NULL,
  `targetoutput` varchar(50) NOT NULL,
  `satuanoutput` text NOT NULL,
  `idoutputbl` int(11) NOT NULL,
  `targetoutputteks` text NOT NULL,
  `kode_sbl` varchar(50) NOT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `bobot_kinerja` varchar(50) DEFAULT 1,
  `active` tinyint(4) DEFAULT '1',
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_sub_keg_indikator_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `outputteks` text NOT NULL,
  `targetoutput` varchar(50) NOT NULL,
  `satuanoutput` text NOT NULL,
  `idoutputbl` int(11) NOT NULL,
  `targetoutputteks` text NOT NULL,
  `kode_sbl` varchar(50) NOT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `bobot_kinerja` varchar(50) DEFAULT 1,
  `active` tinyint(4) DEFAULT '1',
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `outputteks_usulan` text DEFAULT NULL,
  `targetoutput_usulan` varchar(50) DEFAULT NULL,
  `satuanoutput_usulan` text DEFAULT NULL,
  `targetoutputteks_usulan` text DEFAULT NULL,
  `id_indikator_sub_giat` int(11) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_unit_pagu` (
  `id` int(11) NOT NULL auto_increment,
  `batasanpagu` double(20,2) DEFAULT NULL,
  `id_daerah` int(11) DEFAULT NULL,
  `id_level` int(11) DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `id_user` int(11) DEFAULT NULL,
  `is_anggaran` tinyint(4) DEFAULT NULL,
  `is_deleted` tinyint(4) DEFAULT NULL,
  `is_komponen` tinyint(4) DEFAULT NULL,
  `is_locked` smallint(6) DEFAULT NULL,
  `is_skpd` tinyint(4) DEFAULT NULL,
  `kode_skpd` varchar(50) DEFAULT NULL,
  `kunci_bl` tinyint(4) DEFAULT NULL,
  `kunci_bl_rinci` tinyint(4) DEFAULT NULL,
  `kuncibl` tinyint(4) DEFAULT NULL,
  `kunciblrinci` tinyint(4) DEFAULT NULL,
  `nilaipagu` double(20,2) DEFAULT NULL,
  `nilaipagumurni` double(20,2) DEFAULT NULL,
  `nilairincian` double(20,2) DEFAULT NULL,
  `pagu_giat` double(20,2) DEFAULT NULL,
  `realisasi` double(20,2) DEFAULT NULL,
  `rinci_giat` double(20,2) DEFAULT NULL,
  `set_pagu_giat` double(20,2) DEFAULT NULL,
  `set_pagu_skpd` double(20,2) DEFAULT NULL,
  `tahun` year(4) DEFAULT NULL,
  `total_giat` double(20,2) DEFAULT NULL,
  `totalgiat` double(20,2) DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_prog_keg` (
  `id` int(11) NOT NULL auto_increment,
  `id_bidang_urusan` int(11) NOT NULL,
  `id_program` int(11) NOT NULL,
  `id_giat` int(11) NOT NULL,
  `id_sub_giat` int(11) NOT NULL,
  `id_urusan` int(11) NOT NULL,
  `is_locked` int(11) NOT NULL,
  `kode_bidang_urusan` varchar(50) NOT NULL,
  `kode_giat` varchar(50) NOT NULL,
  `kode_program` varchar(50) NOT NULL,
  `kode_sub_giat` varchar(50) NOT NULL,
  `kode_urusan` varchar(50) NOT NULL,
  `nama_bidang_urusan` text NOT NULL,
  `nama_giat` text NOT NULL,
  `nama_program` text NOT NULL,
  `nama_sub_giat` text NOT NULL,
  `nama_urusan` text NOT NULL,
  `status` varchar(20) DEFAULT NULL,
  `aceh` int(11) DEFAULT NULL,
  `bali` int(11) DEFAULT NULL,
  `papua` int(11) DEFAULT NULL,
  `papua_barat` int(11) DEFAULT NULL,
  `yogyakarta` int(11) DEFAULT NULL,
  `jakarta` int(11) DEFAULT NULL,
  `id_daerah` int(11) DEFAULT NULL,
  `id_daerah_khusus` int(11) DEFAULT NULL,
  `is_setda` int(11) DEFAULT NULL,
  `is_setwan` int(11) DEFAULT NULL,
  `kunci_tahun` int(11) DEFAULT NULL,
  `mulai_tahun` int(11) DEFAULT NULL,
  `set_kab_kota` int(11) DEFAULT NULL,
  `set_prov` int(11) DEFAULT NULL,
  `active` tinyint(4) DEFAULT 1 COMMENT '0=hapus, 1=aktif',
  `update_at` datetime DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL DEFAULT '2021',
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjmd` (
  `id` int(11) NOT NULL auto_increment,
  `id_bidang_urusan` int(11) NOT NULL,
  `id_program` int(11) NOT NULL,
  `id_rpjmd` int(11) NOT NULL,
  `indikator` text NOT NULL,
  `kebijakan_teks` text NOT NULL,
  `kode_bidang_urusan` varchar(50) NOT NULL,
  `kode_program` varchar(50) NOT NULL,
  `kode_skpd` varchar(50),
  `misi_teks` text NOT NULL,
  `nama_bidang_urusan` varchar(100) NOT NULL,
  `nama_program` text NOT NULL,
  `nama_skpd` text NOT NULL,
  `pagu_1` varchar(50) NOT NULL,
  `pagu_2` varchar(50) NOT NULL,
  `pagu_3` varchar(50) NOT NULL,
  `pagu_4` varchar(50) NOT NULL,
  `pagu_5` varchar(50) NOT NULL,
  `sasaran_teks` text NOT NULL,
  `satuan` varchar(150) NOT NULL,
  `strategi_teks` text NOT NULL,
  `target_1` varchar(50) NOT NULL,
  `target_2` varchar(50) NOT NULL,
  `target_3` varchar(50) NOT NULL,
  `target_4` varchar(50) NOT NULL,
  `target_5` varchar(50) NOT NULL,
  `tujuan_teks` text NOT NULL,
  `visi_teks` text NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL DEFAULT '2021',
  PRIMARY KEY (id)
);

CREATE TABLE `data_alamat` (
  `id` int(11) NOT NULL auto_increment,
  `id_alamat` int(11) NOT NULL,
  `nama` text NOT NULL,
  `id_prov` int(11) NOT NULL,
  `id_kab` int(11) NOT NULL,
  `id_kec` int(11) NOT NULL,
  `is_prov` tinyint(4) NOT NULL,
  `is_kab` tinyint(4) NOT NULL,
  `is_kec` tinyint(4) NOT NULL,
  `is_kel` tinyint(4) NOT NULL,
  `updated_at` datetime NOT NULL,
  `tahun` year(4) NOT NULL,
  PRIMARY KEY (id),
  KEY `id_alamat` (`id_alamat`),
  KEY `id_prov` (`id_prov`),
  KEY `id_kab` (`id_kab`),
  KEY `id_kec` (`id_kec`),
  KEY `is_prov` (`is_prov`),
  KEY `is_kab` (`is_kab`),
  KEY `is_kec` (`is_kec`),
  KEY `is_kel` (`is_kel`),
  KEY `tahun` (`tahun`)
);

CREATE TABLE `data_profile_penerima_bantuan` (
  `id` int(11) NOT NULL auto_increment,
  `id_profil` int(11) NOT NULL,
  `nama_teks` text NOT NULL,
  `alamat_teks` text NOT NULL,
  `jenis_penerima` text NOT NULL,
  `updated_at` datetime NOT NULL,
  `tahun` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_desa_kelurahan` (
  `id` int(11) NOT NULL auto_increment,
  `camat_teks` varchar(50) DEFAULT NULL,
  `id_camat` int(11) DEFAULT NULL,
  `id_daerah` int(11) DEFAULT NULL,
  `id_level` varchar(50) DEFAULT NULL,
  `id_lurah` int(11) DEFAULT NULL,
  `id_profil` int(11) DEFAULT NULL,
  `id_user` int(11) DEFAULT NULL,
  `is_desa` tinyint(4) DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `jabatan` varchar(50) DEFAULT NULL,
  `jenis` int(11) DEFAULT NULL,
  `kab_kota` varchar(50) DEFAULT NULL,
  `kode_lurah` varchar(50) DEFAULT NULL,
  `login_name` varchar(50) DEFAULT NULL,
  `lurah_teks` varchar(50) DEFAULT NULL,
  `nama_daerah` varchar(50) DEFAULT NULL,
  `nama_user` varchar(50) DEFAULT NULL,
  `accasmas` tinyint(4) DEFAULT NULL,
  `accbankeu` tinyint(4) DEFAULT NULL,
  `accdisposisi` tinyint(4) DEFAULT NULL,
  `accgiat` tinyint(4) DEFAULT NULL,
  `acchibah` tinyint(4) DEFAULT NULL,
  `accinput` tinyint(4) DEFAULT NULL,
  `accjadwal` tinyint(4) DEFAULT NULL,
  `acckunci` tinyint(4) DEFAULT NULL,
  `accmaster` tinyint(4) DEFAULT NULL,
  `accspv` tinyint(4) DEFAULT NULL,
  `accunit` tinyint(4) DEFAULT NULL,
  `accusulan` tinyint(4) DEFAULT NULL,
  `alamatteks` text,
  `camatteks` varchar(50) DEFAULT NULL,
  `daerahpengusul` varchar(50) DEFAULT NULL,
  `dapil` varchar(50) DEFAULT NULL,
  `emailteks` varchar(50) DEFAULT NULL,
  `fraksi` varchar(50) DEFAULT NULL,
  `idcamat` int(11) DEFAULT NULL,
  `iddaerahpengusul` int(11) DEFAULT NULL,
  `idkabkota` int(11) DEFAULT NULL,
  `idlevel` int(11) DEFAULT NULL,
  `idlokasidesa` int(11) DEFAULT NULL,
  `idlurah` int(11) DEFAULT NULL,
  `idlurahpengusul` int(11) DEFAULT NULL,
  `idprofil` int(11) DEFAULT NULL,
  `iduser` int(11) DEFAULT NULL,
  `loginname` varchar(50) DEFAULT NULL,
  `lokasidesateks` varchar(50) DEFAULT NULL,
  `lurahteks` varchar(50) DEFAULT NULL,
  `nama` varchar(50) DEFAULT NULL,
  `namapengusul` varchar(50) DEFAULT NULL,
  `nik` varchar(50) DEFAULT NULL,
  `nip` varchar(50) DEFAULT NULL,
  `notelp` varchar(50) DEFAULT NULL,
  `npwp` varchar(50) DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_dewan` (
  `id` int(11) NOT NULL auto_increment,
  `jabatan` varchar(50) DEFAULT NULL,
  `accasmas` tinyint(4) DEFAULT NULL,
  `accbankeu` tinyint(4) DEFAULT NULL,
  `accdisposisi` tinyint(4) DEFAULT NULL,
  `accgiat` tinyint(4) DEFAULT NULL,
  `acchibah` tinyint(4) DEFAULT NULL,
  `accinput` tinyint(4) DEFAULT NULL,
  `accjadwal` tinyint(4) DEFAULT NULL,
  `acckunci` tinyint(4) DEFAULT NULL,
  `accmaster` tinyint(4) DEFAULT NULL,
  `accspv` tinyint(4) DEFAULT NULL,
  `accunit` tinyint(4) DEFAULT NULL,
  `accusulan` tinyint(4) DEFAULT NULL,
  `alamatteks` text,
  `camatteks` varchar(50) DEFAULT NULL,
  `daerahpengusul` varchar(50) DEFAULT NULL,
  `dapil` varchar(50) DEFAULT NULL,
  `emailteks` varchar(50) DEFAULT NULL,
  `fraksi` varchar(50) DEFAULT NULL,
  `idcamat` int(11) DEFAULT NULL,
  `iddaerahpengusul` int(11) DEFAULT NULL,
  `idkabkota` int(11) DEFAULT NULL,
  `idlevel` int(11) DEFAULT NULL,
  `idlokasidesa` int(11) DEFAULT NULL,
  `idlurah` int(11) DEFAULT NULL,
  `idlurahpengusul` int(11) DEFAULT NULL,
  `idprofil` int(11) DEFAULT NULL,
  `iduser` int(11) DEFAULT NULL,
  `loginname` varchar(50) DEFAULT NULL,
  `lokasidesateks` varchar(50) DEFAULT NULL,
  `lurahteks` varchar(50) DEFAULT NULL,
  `nama` varchar(50) DEFAULT NULL,
  `namapengusul` varchar(50) DEFAULT NULL,
  `nik` varchar(50) DEFAULT NULL,
  `nip` varchar(50) DEFAULT NULL,
  `notelp` varchar(50) DEFAULT NULL,
  `npwp` varchar(50) DEFAULT NULL,
  `id_sub_skpd` int(11) DEFAULT NULL,
  `active` tinyint(4) DEFAULT '1',
  `is_locked` tinyint(4) DEFAULT NULL,
  `accmonitor` tinyint(4) DEFAULT NULL,
  `akses_user` varchar(50) DEFAULT NULL,
  `akta_kumham` varchar(255) DEFAULT NULL,
  `ijin_op` varchar(255) DEFAULT NULL,
  `is_profil_ok` tinyint(4) DEFAULT NULL,
  `is_vertikal` tinyint(4) DEFAULT NULL,
  `map_lat_lokasi` text DEFAULT NULL,
  `map_lng_lokasi` text DEFAULT NULL,
  `no_sertifikat` text DEFAULT NULL,
  `path_foto` text DEFAULT NULL,
  `surat_dom` varchar(255) DEFAULT NULL,
  `kode_camat` text DEFAULT NULL,
  `kode_lurah` text DEFAULT NULL,  
  `kode_ddn_2` varchar(50) DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `status` varchar(50) DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_tag_sub_keg` (
  `id` int(11) NOT NULL auto_increment,
  `idlabelgiat` int(11) DEFAULT NULL,
  `namalabel` varchar(50) DEFAULT NULL,
  `idtagbl` int(11) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `active` tinyint(4) DEFAULT '1',
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_pengaturan_sipd` (
  `id` int(11) NOT NULL auto_increment,
  `id_daerah` int(11) DEFAULT NULL,
  `daerah` text DEFAULT NULL,
  `kepala_daerah` text DEFAULT NULL,
  `wakil_kepala_daerah` text DEFAULT NULL,
  `awal_rpjmd` year(4) DEFAULT NULL,
  `akhir_rpjmd` year(4) DEFAULT NULL,
  `pelaksana_rkpd` tinyint(4) DEFAULT NULL,
  `pelaksana_kua` tinyint(4) DEFAULT NULL,
  `pelaksana_apbd` tinyint(4) DEFAULT NULL,
  `set_kpa_sekda` tinyint(4) DEFAULT NULL,
  `set_kpa_sub_sekda` int(11) DEFAULT NULL,
  `id_setup_anggaran` int(11) DEFAULT NULL,
  `set_rkpd` int(11) DEFAULT NULL,
  `set_kua` int(11) DEFAULT NULL,
  `ref_program` int(11) DEFAULT NULL,
  `ref_giat` int(11) DEFAULT NULL,
  `ref_akun` int(11) DEFAULT NULL,
  `ref_skpd` int(11) DEFAULT NULL,
  `ref_sumber_dana` int(11) DEFAULT NULL,
  `ref_lokasi` int(11) DEFAULT NULL,
  `ref_standar_harga` int(11) DEFAULT NULL,
  `is_locked` int(11) DEFAULT NULL,
  `jenis_set_pagu` int(11) DEFAULT NULL,
  `tahun_aksi` int(11) DEFAULT NULL,
  `status_kd` int(11) DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_sumber_dana` (
  `id` int(11) NOT NULL auto_increment,
  `created_at` datetime DEFAULT NULL,
  `created_user` int(11) DEFAULT NULL,
  `id_daerah` int(11) DEFAULT NULL,
  `id_dana` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `is_locked` int(11) DEFAULT NULL,
  `kode_dana` varchar(50) NOT NULL,
  `nama_dana` text NOT NULL,
  `sumber_dana` text DEFAULT NULL,
  `set_input` varchar(50) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `tahun` year(4) DEFAULT NULL DEFAULT '2021',
  `updated_at` datetime DEFAULT NULL,
  `active` tinyint(4) DEFAULT 1 COMMENT '0=hapus, 1=aktif',
  `updated_user` int(11) DEFAULT NULL DEFAULT '0',
  `tahun_anggaran` year(4) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_user_penatausahaan` (
  `id` int(11) NOT NULL auto_increment,
  `idSkpd` int(11) DEFAULT NULL,
  `namaSkpd` text DEFAULT NULL,
  `kodeSkpd` int(50) DEFAULT NULL,
  `idDaerah` int(11) DEFAULT NULL,
  `userName` text DEFAULT NULL,
  `nip` varchar(50) DEFAULT NULL,
  `nik` varchar(50) DEFAULT NULL,
  `fullName` text DEFAULT NULL,
  `lahir_user` datetime DEFAULT NULL,
  `nomorHp` text DEFAULT NULL,
  `IsRank` varchar(50) DEFAULT NULL,
  `npwp` varchar(50) DEFAULT NULL,
  `idJabatan` int(11) DEFAULT NULL,
  `namaJabatan` varchar(50) DEFAULT NULL,
  `idRole` int(11) DEFAULT NULL,
  `_order` int(11) DEFAULT NULL,
  `kpa` varchar(50) DEFAULT NULL,
  `bank` text DEFAULT NULL,
  `_group` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `konfirmasiPassword` varchar(50) DEFAULT NULL,
  `kodeBank` text DEFAULT NULL,
  `nama_rekening` text DEFAULT NULL,
  `nomorRekening` text DEFAULT NULL,
  `pangkatGolongan` text DEFAULT NULL,
  `tahunPegawai` year(4) DEFAULT NULL,
  `kodeDaerah` int(11) DEFAULT NULL,
  `is_from_sipd` int(11) DEFAULT NULL,
  `is_from_generate` int(11) DEFAULT NULL,
  `is_from_external` int(11) DEFAULT NULL,
  `idSubUnit` int(11) DEFAULT NULL,
  `idUser` int(11) DEFAULT NULL,
  `idPegawai` int(11) DEFAULT NULL,
  `alamat` text DEFAULT NULL,
  `updated_at` datetime NOT NULL,
  `active` tinyint(4) DEFAULT 1 COMMENT '0=hapus, 1=aktif',
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_renstra` (
  `id` int(11) NOT NULL auto_increment,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_giat` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_renstra` int(11) DEFAULT NULL,
  `id_rpjmd` int(11) DEFAULT NULL,
  `id_sub_giat` int(11) DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `indikator` text,
  `indikator_sub` text,
  `is_locked` tinyint(4) DEFAULT NULL,
  `kebijakan_teks` text,
  `kode_bidang_urusan` varchar(50) DEFAULT NULL,
  `kode_giat` varchar(50) DEFAULT NULL,
  `kode_program` varchar(50) DEFAULT NULL,
  `kode_skpd` varchar(50) DEFAULT NULL,
  `kode_sub_giat` varchar(50) DEFAULT NULL,
  `misi_teks` text,
  `nama_bidang_urusan` text,
  `nama_giat` text,
  `nama_program` text,
  `nama_skpd` text,
  `nama_sub_giat` text,
  `outcome` text,
  `pagu_1` double DEFAULT NULL,
  `pagu_2` double DEFAULT NULL,
  `pagu_3` double DEFAULT NULL,
  `pagu_4` double DEFAULT NULL,
  `pagu_5` double DEFAULT NULL,
  `pagu_sub_1` double DEFAULT NULL,
  `pagu_sub_2` double DEFAULT NULL,
  `pagu_sub_3` double DEFAULT NULL,
  `pagu_sub_4` double DEFAULT NULL,
  `pagu_sub_5` double DEFAULT NULL,
  `sasaran_teks` text,
  `satuan` varchar(150) DEFAULT NULL,
  `satuan_sub` varchar(50) DEFAULT NULL,
  `strategi_teks` text,
  `target_1` text,
  `target_2` text,
  `target_3` text,
  `target_4` text,
  `target_5` text,
  `target_sub_1` text,
  `target_sub_2` text,
  `target_sub_3` text,
  `target_sub_4` text,
  `target_sub_5` text,
  `tujuan_teks` text,
  `visi_teks` text,
  `active` tinyint(4) NOT NULL DEFAULT '1',
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_lokasi_sub_keg` (
  `id` int(11) NOT NULL auto_increment,
  `camatteks` text,
  `daerahteks` text,
  `idcamat` int(11) DEFAULT NULL,
  `iddetillokasi` double DEFAULT NULL,
  `idkabkota` int(11) DEFAULT NULL,
  `idlurah` int(11) DEFAULT NULL,
  `lurahteks` text,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `active` tinyint(4) DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_lokasi_sub_keg_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `camatteks` text,
  `daerahteks` text,
  `idcamat` int(11) DEFAULT NULL,
  `iddetillokasi` double DEFAULT NULL,
  `idkabkota` int(11) DEFAULT NULL,
  `idlurah` int(11) DEFAULT NULL,
  `lurahteks` text,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `active` tinyint(4) DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `camatteks_usulan` text DEFAULT NULL,
  `daerahteks_usulan` text DEFAULT NULL,
  `idcamat_usulan` int(11) DEFAULT NULL,
  `iddetillokasi_usulan` double DEFAULT NULL,
  `idkabkota_usulan` int(11) DEFAULT NULL,
  `idlurah_usulan` int(11) DEFAULT NULL,
  `lurahteks_usulan` text DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_anggaran_kas` (
  `id` int(11) NOT NULL auto_increment,
  `bulan_1` double DEFAULT NULL,
  `bulan_2` double DEFAULT NULL,
  `bulan_3` double DEFAULT NULL,
  `bulan_4` double DEFAULT NULL,
  `bulan_5` double DEFAULT NULL,
  `bulan_6` double DEFAULT NULL,
  `bulan_7` double DEFAULT NULL,
  `bulan_8` double DEFAULT NULL,
  `bulan_9` double DEFAULT NULL,
  `bulan_10` double DEFAULT NULL,
  `bulan_11` double DEFAULT NULL,
  `bulan_12` double DEFAULT NULL,
  `id_akun` int(11) DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_daerah` int(11) DEFAULT NULL,
  `id_giat` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `id_sub_giat` int(11) DEFAULT NULL,
  `id_sub_skpd` int(11) DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `kode_akun` varchar(50) DEFAULT NULL,
  `nama_akun` text,
  `selisih` double DEFAULT NULL,
  `tahun` year(4) DEFAULT NULL,
  `total_akb` double DEFAULT NULL,
  `total_rincian` double DEFAULT NULL,
  `active` tinyint(4) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `kode_sbl_sub_keg` varchar(50) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_pembiayaan` (
  `id` int(11) NOT NULL auto_increment,
  `created_user` int(11) DEFAULT NULL,
  `createddate` varchar(50) DEFAULT NULL,
  `createdtime` varchar(50) DEFAULT NULL,
  `id_pembiayaan` int(11) DEFAULT NULL,
  `keterangan` text DEFAULT NULL,
  `kode_akun` varchar(50) DEFAULT NULL,
  `nama_akun` text,
  `nilaimurni` double DEFAULT NULL,
  `program_koordinator` int(11) DEFAULT NULL,
  `rekening` text,
  `skpd_koordinator` int(11) DEFAULT NULL,
  `total` double DEFAULT NULL,
  `pagu_fmis` double(20,2) DEFAULT NULL,
  `updated_user` int(11) DEFAULT NULL,
  `updateddate` varchar(50) DEFAULT NULL,
  `updatedtime` varchar(50) DEFAULT NULL,
  `uraian` text,
  `urusan_koordinator` int(11) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `user1`text DEFAULT NULL,
  `user2`text DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `id_akun` int(11) DEFAULT NULL,
  `id_jadwal_murni` int(11) DEFAULT NULL,
  `koefisien` varchar(50) DEFAULT NULL,
  `kua_murni` varchar(50) DEFAULT NULL,
  `kua_pak` varchar(50) DEFAULT NULL,
  `rkpd_murni` varchar(50) DEFAULT NULL,
  `rkpd_pak` varchar(50) DEFAULT NULL,
  `satuan` varchar(50) DEFAULT NULL,
  `volume` varchar(50) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_pendapatan` (
  `id` int(11) NOT NULL auto_increment,
  `created_user` int(11) DEFAULT NULL,
  `createddate` varchar(50) DEFAULT NULL,
  `createdtime` varchar(50) DEFAULT NULL,
  `id_pendapatan` int(11) DEFAULT NULL,
  `keterangan` text,
  `kode_akun` varchar(50) DEFAULT NULL,
  `nama_akun` text,
  `nilaimurni` double DEFAULT NULL,
  `program_koordinator` int(11) DEFAULT NULL,
  `rekening` text,
  `skpd_koordinator` int(11) DEFAULT NULL,
  `total` double DEFAULT NULL,
  `pagu_fmis` double(20,2) DEFAULT NULL,
  `updated_user` int(11) DEFAULT NULL,
  `updateddate` varchar(50) DEFAULT NULL,
  `updatedtime` varchar(50) DEFAULT NULL,
  `uraian` text,
  `urusan_koordinator` int(11) DEFAULT NULL,
  `user1` text DEFAULT NULL,
  `user2` text DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `id_akun` int(11) DEFAULT NULL,
  `id_jadwal_murni` int(11) DEFAULT NULL,
  `koefisien` varchar(50) DEFAULT NULL,
  `kua_murni` varchar(50) DEFAULT NULL,
  `kua_pak` varchar(50) DEFAULT NULL,
  `rkpd_murni` varchar(50) DEFAULT NULL,
  `rkpd_pak` varchar(50) DEFAULT NULL,
  `satuan` varchar(50) DEFAULT NULL,
  `volume` varchar(50) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_asmas` (
  `id` int(11) NOT NULL auto_increment,
  `alamat_teks` text DEFAULT NULL,
  `anggaran` double DEFAULT NULL,
  `batal_teks` text DEFAULT NULL,
  `bidang_urusan` text DEFAULT NULL,
  `created_date` varchar(50) DEFAULT NULL,
  `created_user` int(11) DEFAULT NULL,
  `file_foto` text DEFAULT NULL,
  `file_pengantar` text DEFAULT NULL,
  `file_proposal` text DEFAULT NULL,
  `file_rab` text DEFAULT NULL,
  `giat_teks` text DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_daerah` int(11) DEFAULT NULL,
  `id_jenis_profil` int(11) DEFAULT NULL,
  `id_jenis_usul` int(11) DEFAULT NULL,
  `id_kab_kota` int(11) DEFAULT NULL,
  `id_kecamatan` int(11) DEFAULT NULL,
  `id_kelurahan` int(11) DEFAULT NULL,
  `id_pengusul` int(11) DEFAULT NULL,
  `id_profil` int(11) DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `id_usulan` int(11) DEFAULT NULL,
  `is_batal` int(11) DEFAULT NULL,
  `is_tolak` int(11) DEFAULT NULL,
  `jenis_belanja` varchar(50) DEFAULT NULL,
  `jenis_profil` text DEFAULT NULL,
  `jenis_usul_teks` text DEFAULT NULL,
  `kelompok` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `koefisien` text DEFAULT NULL,
  `level_pengusul` int(11) DEFAULT NULL,
  `lokus_usulan` text DEFAULT NULL,
  `masalah` text DEFAULT NULL,
  `nama_daerah` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `nama_user` text DEFAULT NULL,
  `nip` int(11) DEFAULT NULL,
  `pengusul` text DEFAULT NULL,
  `rekom_camat_anggaran` double DEFAULT NULL,
  `rekom_camat_koefisien` text DEFAULT NULL,
  `rekom_camat_rekomendasi` text DEFAULT NULL,
  `rekom_lurah_anggaran` double DEFAULT NULL,
  `rekom_lurah_koefisien` text DEFAULT NULL,
  `rekom_lurah_rekomendasi` text DEFAULT NULL,
  `rekom_mitra_anggaran` double DEFAULT NULL,
  `rekom_mitra_koefisien` text DEFAULT NULL,
  `rekom_mitra_rekomendasi` text DEFAULT NULL,
  `rekom_skpd_anggaran` double DEFAULT NULL,
  `rekom_skpd_koefisien` text DEFAULT NULL,
  `rekom_skpd_rekomendasi` text DEFAULT NULL,
  `rekom_tapd_anggaran` double DEFAULT NULL,
  `rekom_tapd_koefisien` text DEFAULT NULL,
  `rekom_tapd_rekomendasi` text DEFAULT NULL,
  `rev_skpd` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status_usul` int(11) DEFAULT NULL,
  `status_usul_teks` text DEFAULT NULL,
  `tolak_teks` int(11) DEFAULT NULL,
  `tujuan_usul` text DEFAULT NULL,
  `detail_alamatteks` text DEFAULT NULL,
  `detail_anggaran` double DEFAULT NULL,
  `detail_bidangurusan` text DEFAULT NULL,
  `detail_camatteks` text DEFAULT NULL,
  `detail_filefoto` text DEFAULT NULL,
  `detail_filefoto2` text DEFAULT NULL,
  `detail_filefoto3` text DEFAULT NULL,
  `detail_filepengantar` text DEFAULT NULL,
  `detail_fileproposal` text DEFAULT NULL,
  `detail_filerab` text DEFAULT NULL,
  `detail_gagasan` text DEFAULT NULL,
  `detail_idcamat` int(11) DEFAULT NULL,
  `detail_idkabkota` int(11) DEFAULT NULL,
  `detail_idkamus` int(11) DEFAULT NULL,
  `detail_idlurah` int(11) DEFAULT NULL,
  `detail_idskpd` int(11) DEFAULT NULL,
  `detail_jenisbelanja` text DEFAULT NULL,
  `detail_kodeskpd` text DEFAULT NULL,
  `detail_langpeta` text DEFAULT NULL,
  `detail_latpeta` text DEFAULT NULL,
  `detail_lurahteks` text DEFAULT NULL,
  `detail_masalah` text DEFAULT NULL,
  `detail_namakabkota` text DEFAULT NULL,
  `detail_namaskpd` text DEFAULT NULL,
  `detail_rekomteks` text DEFAULT NULL,
  `detail_satuan` text DEFAULT NULL,
  `detail_setStatusUsul` text DEFAULT NULL,
  `detail_subgiat` int(11) DEFAULT NULL,
  `detail_tujuanusul` text DEFAULT NULL,
  `detail_usulanggaran` double DEFAULT NULL,
  `detail_usulvolume` int(11) DEFAULT NULL,
  `detail_volume` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `is_verif` int(11) DEFAULT NULL,
  `nama_skpd_awal` text DEFAULT NULL,
  `is_kembalikan` int(11) DEFAULT NULL,
  `rekom_teks` text DEFAULT NULL,
  `kembalikan` int(11) DEFAULT NULL,
  `id_isu` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `detail_koefisien` text DEFAULT NULL,
  `is_stat_lahan` int(11) DEFAULT NULL,
  `is_sertifikat_lahan` int(11) DEFAULT NULL,
  `is_rincian_teknis` int(11) DEFAULT NULL,
  `latbel_teks` text DEFAULT NULL,
  `dashuk_teks` text DEFAULT NULL,
  `maksud_teks` text DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `id_akun` int(11) DEFAULT NULL,
  `id_prop` int(11) DEFAULT NULL,
  `id_bl` int(11) DEFAULT NULL,
  `id_sub_bl` int(11) DEFAULT NULL,
  `sub_giat_baru` int(11) DEFAULT NULL,
  `detail_id_skpd_awal` int(11) DEFAULT NULL,
  `id_skpd_bl` int(11) DEFAULT NULL,
  `id_sub_skpd_bl` int(11) DEFAULT NULL,
  `id_program_bl` int(11) DEFAULT NULL,
  `id_giat_bl` int(11) DEFAULT NULL,
  `id_sub_giat_bl` int(11) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_pokir` (
  `id` int(11) NOT NULL auto_increment,
  `alamat_teks` text DEFAULT NULL,
  `anggaran` double DEFAULT NULL,
  `batal_teks` text DEFAULT NULL,
  `bidang_urusan` text DEFAULT NULL,
  `created_date` varchar(50) DEFAULT NULL,
  `created_user` int(11) DEFAULT NULL,
  `file_foto` text DEFAULT NULL,
  `file_pengantar` text DEFAULT NULL,
  `file_proposal` text DEFAULT NULL,
  `file_rab` text DEFAULT NULL,
  `fraksi_dewan` text DEFAULT NULL,
  `giat_teks` text DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_jenis_usul` int(11) DEFAULT NULL,
  `id_kab_kota` int(11) DEFAULT NULL,
  `id_kecamatan` int(11) DEFAULT NULL,
  `id_kelurahan` int(11) DEFAULT NULL,
  `id_pengusul` int(11) DEFAULT NULL,
  `id_reses` int(11) DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `id_usulan` int(11) DEFAULT NULL,
  `is_batal` int(11) DEFAULT NULL,
  `is_tolak` int(11) DEFAULT NULL,
  `jenis_belanja` varchar(50) DEFAULT NULL,
  `jenis_usul_teks` text DEFAULT NULL,
  `kelompok` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `koefisien` text DEFAULT NULL,
  `lokus_usulan` text DEFAULT NULL,
  `masalah` text DEFAULT NULL,
  `nama_daerah` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `nama_user` text DEFAULT NULL,
  `pengusul` text DEFAULT NULL,
  `rekom_mitra_anggaran` double DEFAULT NULL,
  `rekom_mitra_koefisien` text DEFAULT NULL,
  `rekom_mitra_rekomendasi` text DEFAULT NULL,
  `rekom_setwan_anggaran` double DEFAULT NULL,
  `rekom_setwan_koefisien` text DEFAULT NULL,
  `rekom_setwan_rekomendasi` text DEFAULT NULL,
  `rekom_skpd_anggaran` double DEFAULT NULL,
  `rekom_skpd_koefisien` text DEFAULT NULL,
  `rekom_skpd_rekomendasi` text DEFAULT NULL,
  `rekom_tapd_anggaran` double DEFAULT NULL,
  `rekom_tapd_koefisien` text DEFAULT NULL,
  `rekom_tapd_rekomendasi` text DEFAULT NULL,
  `rev_skpd` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status_usul` int(11) DEFAULT NULL,
  `status_usul_teks` text DEFAULT NULL,
  `tolak_teks` int(11) DEFAULT NULL,
  `tujuan_usul` text DEFAULT NULL,
  `detail_alamatteks` text DEFAULT NULL,
  `detail_anggaran` double DEFAULT NULL,
  `detail_bidangurusan` text DEFAULT NULL,
  `detail_camatteks` text DEFAULT NULL,
  `detail_filefoto` text DEFAULT NULL,
  `detail_filefoto2` text DEFAULT NULL,
  `detail_filefoto3` text DEFAULT NULL,
  `detail_filepengantar` text DEFAULT NULL,
  `detail_fileproposal` text DEFAULT NULL,
  `detail_filerab` text DEFAULT NULL,
  `detail_gagasan` text DEFAULT NULL,
  `detail_idcamat` int(11) DEFAULT NULL,
  `detail_idkabkota` int(11) DEFAULT NULL,
  `detail_idkamus` int(11) DEFAULT NULL,
  `detail_idlurah` int(11) DEFAULT NULL,
  `detail_idskpd` int(11) DEFAULT NULL,
  `detail_jenisbelanja` text DEFAULT NULL,
  `detail_kodeskpd` text DEFAULT NULL,
  `detail_langpeta` text DEFAULT NULL,
  `detail_latpeta` text DEFAULT NULL,
  `detail_lurahteks` text DEFAULT NULL,
  `detail_masalah` text DEFAULT NULL,
  `detail_namakabkota` text DEFAULT NULL,
  `detail_namaskpd` text DEFAULT NULL,
  `detail_rekomteks` text DEFAULT NULL,
  `detail_satuan` text DEFAULT NULL,
  `detail_setStatusUsul` text DEFAULT NULL,
  `detail_subgiat` int(11) DEFAULT NULL,
  `detail_usulanggaran` double DEFAULT NULL,
  `detail_usulvolume` int(11) DEFAULT NULL,
  `detail_volume` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `is_verif` int(11) DEFAULT NULL,
  `nama_skpd_awal` text DEFAULT NULL,
  `is_kembalikan` int(11) DEFAULT NULL,
  `rekom_teks` text DEFAULT NULL,
  `kembalikan` int(11) DEFAULT NULL,
  `id_isu` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `detail_koefisien` text DEFAULT NULL,
  `is_stat_lahan` int(11) DEFAULT NULL,
  `is_sertifikat_lahan` int(11) DEFAULT NULL,
  `is_rincian_teknis` int(11) DEFAULT NULL,
  `latbel_teks` text DEFAULT NULL,
  `dashuk_teks` text DEFAULT NULL,
  `maksud_teks` text DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `id_akun` int(11) DEFAULT NULL,
  `id_prop` int(11) DEFAULT NULL,
  `id_bl` int(11) DEFAULT NULL,
  `id_sub_bl` int(11) DEFAULT NULL,
  `sub_giat_baru` int(11) DEFAULT NULL,
  `detail_id_skpd_awal` int(11) DEFAULT NULL,
  `id_skpd_bl` int(11) DEFAULT NULL,
  `id_sub_skpd_bl` int(11) DEFAULT NULL,
  `id_program_bl` int(11) DEFAULT NULL,
  `id_giat_bl` int(11) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_user_tapd_sekda` (
  `id` int(11) NOT NULL auto_increment,
  `created_at` datetime NOT NULL,
  `created_user` int(11) DEFAULT NULL,
  `id_daerah` int(11) DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `jabatan` text DEFAULT NULL,
  `nama` text NOT NULL,
  `nip` double(20,2) NOT NULL,
  `no_urut` int(11) DEFAULT NULL,
  `tahun` year(4) NOT NULL,
  `updated_at` datetime NOT NULL,
  `type` varchar(20) NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `singkron_at` datetime NOT NULL,
  `active` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (id)
);

CREATE TABLE `data_pangkat_golongan` (
  `id` int(11) NOT NULL auto_increment,
  `id_pangkat` int(11) DEFAULT NULL,
  `nama_pangkat` text DEFAULT NULL,
  `nama_golongan` text DEFAULT NULL,  
  `tahun_anggaran` year(4) NOT NULL,
  `singkron_at` datetime NOT NULL,
  `active` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (id)
);


CREATE TABLE `data_rfk` (
  `id` int(11) NOT NULL auto_increment,
  `bulan` tinyint(2) NOT NULL,
  `kode_sbl` text NOT NULL,
  `rak` double(20,2) DEFAULT NULL,
  `realisasi_anggaran` double(20,2) DEFAULT NULL,
  `realisasi_fisik` double(5,2) DEFAULT NULL,
  `permasalahan` text DEFAULT NULL,
  `catatan_verifikator` text DEFAULT NULL,
  `user_edit` text DEFAULT NULL,
  `user_verifikator` text DEFAULT NULL,
  `update_verifikator_at` datetime DEFAULT NULL,
  `update_fisik_at` datetime DEFAULT NULL,
  `id_skpd` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjmd_program` (
  `id` int(11) NOT NULL auto_increment,
  `id_misi` int(11) DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` varchar(20) DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_sasaran` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `nama_program` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `pagu_1` double(20,2) DEFAULT NULL,
  `pagu_2` double(20,2) DEFAULT NULL,
  `pagu_3` double(20,2) DEFAULT NULL,
  `pagu_4` double(20,2) DEFAULT NULL,
  `pagu_5` double(20,2) DEFAULT NULL,
  `program_lock` tinyint(4) DEFAULT NULL,
  `sasaran_lock` tinyint(4) DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` int(11) DEFAULT NULL,
  `urut_sasaran` int(11) DEFAULT NULL,
  `urut_tujuan` int(11) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `id_rpjmd` int(11) DEFAULT NULL,
  `pagu_awal` double(20,2) DEFAULT NULL,
  `pagu_akhir` double(20,2) DEFAULT NULL,
  `id_sasaran_indikator` text DEFAULT NULL,
  `id_tahap` int(11) DEFAULT NULL,
  `tahun_awal` year(4) DEFAULT NULL,
  `tahun_akhir` year(4) DEFAULT NULL,
  `id_tujuan_old` int(11) DEFAULT NULL,
  `id_sasaran_old` int(11) DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjmd_sasaran` (
  `id` int(11) NOT NULL auto_increment,
  `id_misi` int(11) DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_sasaran` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` int(11) DEFAULT NULL,
  `urut_sasaran` int(11) DEFAULT NULL,
  `urut_tujuan` int(11) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `id_tahap` int(11) DEFAULT NULL,
  `tahun_awal` year(4) DEFAULT NULL,
  `tahun_akhir` year(4) DEFAULT NULL,
  `id_tujuan_old` int(11) DEFAULT NULL,
  `id_sasaran_old` int(11) DEFAULT NULL,
  `id_tujuan_indikator` int(11) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjmd_tujuan` (
  `id` int(11) NOT NULL auto_increment,
  `id_misi` int(11) DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_tujuan` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `misi_lock` tinyint(4) DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` int(11) DEFAULT NULL,
  `urut_tujuan` int(11) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,  
  `id_tahap` int(11) DEFAULT NULL,
  `id_tujuan_old` int(11) DEFAULT NULL,
  `tahun_awal` year(4) DEFAULT NULL,
  `tahun_akhir` year(4) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_sub_keg_bl` (
  `id` int(11) NOT NULL auto_increment,
  `id_sub_skpd` int(11) NOT NULL,
  `id_lokasi` int(11) DEFAULT NULL,
  `id_label_kokab` int(11) NOT NULL,
  `nama_dana` text,
  `no_sub_giat` varchar(20) NOT NULL,
  `kode_giat` varchar(50) NOT NULL,
  `id_program` int(11) NOT NULL,
  `nama_lokasi` text DEFAULT NULL,
  `waktu_akhir` int(11) NOT NULL,
  `pagu_n_lalu` double(20,2) DEFAULT NULL,
  `id_urusan` int(11) NOT NULL,
  `id_unik_sub_bl` text NOT NULL,
  `id_sub_giat` int(11) NOT NULL,
  `label_prov` text,
  `kode_program` varchar(50) NOT NULL,
  `kode_sub_giat` varchar(50) NOT NULL,
  `no_program` varchar(20) NOT NULL,
  `kode_urusan` varchar(20) NOT NULL,
  `kode_bidang_urusan` varchar(20) NOT NULL,
  `nama_program` text NOT NULL,
  `target_4` text,
  `target_5` text,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `nama_bidang_urusan` text,
  `target_3` text,
  `no_giat` varchar(50) NOT NULL,
  `id_label_prov` int(11) NOT NULL,
  `waktu_awal` int(11) NOT NULL,
  `pagumurni` double(20, 2) DEFAULT NULL,
  `pagu` double(20, 2) NOT NULL,
  `pagu_simda` double(20, 2) DEFAULT NULL,
  `output_sub_giat` text,
  `sasaran` text,
  `indikator` text,
  `id_dana` int(11) DEFAULT NULL,
  `nama_sub_giat` text NOT NULL,
  `pagu_n_depan` double(20, 2) NOT NULL,
  `satuan` text,
  `id_rpjmd` int(11) NOT NULL,
  `id_giat` int(11) NOT NULL,
  `id_label_pusat` int(11) NOT NULL,
  `nama_giat` text NOT NULL,
  `kode_skpd` varchar(50) NOT NULL,
  `nama_skpd` text NOT NULL,
  `kode_sub_skpd` varchar(50) NOT NULL,
  `id_skpd` int(11) NOT NULL,
  `id_sub_bl` int(11) DEFAULT NULL,
  `nama_sub_skpd` text NOT NULL,
  `target_1` text,
  `nama_urusan` text NOT NULL,
  `target_2` text,
  `label_kokab` text,
  `label_pusat` text,
  `pagu_keg` double(20, 2) NOT NULL,
  `pagu_fmis` double(20, 2) DEFAULT NULL,
  `id_bl` int(11) DEFAULT NULL,
  `kode_bl` varchar(50) NOT NULL,
  `kode_sbl` varchar(50) NOT NULL,
  `active` tinyint(4) DEFAULT '1',
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL DEFAULT '2021',
  PRIMARY KEY (id)
);

CREATE TABLE `data_sub_keg_bl_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `id_sub_skpd` int(11) NOT NULL,
  `id_lokasi` int(11) DEFAULT NULL,
  `id_label_kokab` int(11) NOT NULL,
  `nama_dana` text,
  `no_sub_giat` varchar(20) NOT NULL,
  `kode_giat` varchar(50) NOT NULL,
  `id_program` int(11) NOT NULL,
  `nama_lokasi` text DEFAULT NULL,
  `waktu_akhir` int(11) NOT NULL,
  `pagu_n_lalu` double(20, 2) DEFAULT NULL,
  `id_urusan` int(11) NOT NULL,
  `id_unik_sub_bl` text NOT NULL,
  `id_sub_giat` int(11) NOT NULL,
  `label_prov` text,
  `kode_program` varchar(50) NOT NULL,
  `kode_sub_giat` varchar(50) NOT NULL,
  `no_program` varchar(20) NOT NULL,
  `kode_urusan` varchar(20) NOT NULL,
  `kode_bidang_urusan` varchar(20) NOT NULL,
  `nama_program` text NOT NULL,
  `target_4` text,
  `target_5` text,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `nama_bidang_urusan` text,
  `target_3` text,
  `no_giat` varchar(50) NOT NULL,
  `id_label_prov` int(11) NOT NULL,
  `waktu_awal` int(11) NOT NULL,
  `pagumurni` double(20, 2) DEFAULT NULL,
  `pagu` double(20, 2) NOT NULL,
  `pagu_simda` double(20, 2) DEFAULT NULL,
  `output_sub_giat` text,
  `sasaran` text,
  `indikator` text,
  `id_dana` int(11) DEFAULT NULL,
  `nama_sub_giat` text NOT NULL,
  `pagu_n_depan` double(20, 2) NOT NULL,
  `satuan` text,
  `id_rpjmd` int(11) NOT NULL,
  `id_giat` int(11) NOT NULL,
  `id_label_pusat` int(11) NOT NULL,
  `nama_giat` text NOT NULL,
  `kode_skpd` varchar(50) NOT NULL,
  `nama_skpd` text NOT NULL,
  `kode_sub_skpd` varchar(50) NOT NULL,
  `id_skpd` int(11) NOT NULL,
  `id_sub_bl` int(11) DEFAULT NULL,
  `nama_sub_skpd` text NOT NULL,
  `target_1` text,
  `nama_urusan` text NOT NULL,
  `target_2` text,
  `label_kokab` text,
  `label_pusat` text,
  `pagu_keg` double(20, 2) NOT NULL,
  `pagu_fmis` double(20, 2) DEFAULT NULL,
  `id_bl` int(11) DEFAULT NULL,
  `kode_bl` varchar(50) NOT NULL,
  `kode_sbl` varchar(50) NOT NULL,
  `kode_sbl_lama` varchar(50) DEFAULT NULL,
  `active` tinyint(4) DEFAULT '1',
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL DEFAULT '2021',
  `catatan` text DEFAULT NULL,
  `catatan_usulan` text DEFAULT NULL,
  `pagu_usulan` double(20, 2) DEFAULT NULL,
  `pagu_n_depan_usulan` double(20, 2) DEFAULT NULL,
  `waktu_awal_usulan` int(11) DEFAULT NULL,
  `waktu_akhir_usulan` int(11) DEFAULT NULL,
  `sasaran_usulan` text DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_mapping_sumberdana` (
  `id` int(11) NOT NULL auto_increment,
  `id_rinci_sub_bl` int(11) NOT NULL,
  `id_sumber_dana` int(11) NOT NULL,
  `user` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_label_komponen` (
  `id` int(11) NOT NULL auto_increment,
  `nama` text DEFAULT NULL,
  `keterangan` text DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `user` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_mapping_label` (
  `id` int(11) NOT NULL auto_increment,
  `id_rinci_sub_bl` int(11) NOT NULL,
  `id_label_komponen` int(11) NOT NULL,
  `user` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_label_spm` (
  `id` int(11) NOT NULL auto_increment,
  `id_spm` int(11) NOT NULL,
  `abjad_spm` text DEFAULT NULL,
  `nama` text DEFAULT NULL,
  `kode_layanan` text DEFAULT NULL,
  `layanan_teks` text DEFAULT NULL,
  `spm_teks` text DEFAULT NULL,
  `dashuk_teks` text DEFAULT NULL,
  `set_prov` tinyint(4) NOT NULL,
  `set_kab_kota` tinyint(4) NOT NULL,  
  `user` text DEFAULT NULL,
  `is_locked` tinyint(4) NOT NULL,
  `active` tinyint(4) NOT NULL, 
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_mapping_spm_subgiat` (
  `id` int(11) NOT NULL auto_increment,
  `id_spm_giat` int(11) NOT NULL,
  `id_spm` int(11) NOT NULL,
  `id_bidang_urusan` int(11) NOT NULL,
  `id_program` int(11) NOT NULL,
  `id_giat` int(11) NOT NULL,
  `id_sub_giat` int(11) NOT NULL,
  `set_prov` int(11) NOT NULL,
  `set_kab_kota` int(11) NOT NULL,
  `user` text DEFAULT NULL,
  `is_locked` tinyint(4) NOT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_label_kemiskinan` (
  `id` int(11) NOT NULL auto_increment,  
  `kelompok_teks` text DEFAULT NULL,
  `strategi_teks` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL, 
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_mapping_kemiskinan_subgiat` (
  `id` int(11) NOT NULL auto_increment,
  `id_label_miskin` int(11) NOT NULL,
  `kelompok_teks` text DEFAULT NULL,
  `strategi_teks` text DEFAULT NULL,
  `id_urusan` int(11) NOT NULL,
  `id_bidang_urusan` int(11) NOT NULL,
  `id_program` int(11) NOT NULL,
  `id_giat` int(11) NOT NULL,
  `id_sub_giat` int(11) NOT NULL,
  `kode_sub_giat` text DEFAULT NULL,
  `nama_sub_giat` text DEFAULT NULL,
  `user` text DEFAULT NULL,
  `is_locked` tinyint(4) NOT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_renstra_tujuan` (
  `id` int(11) NOT NULL auto_increment,
  `id_jadwal` int(11) NOT NULL,
  `bidur_lock` int(11) DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_bidang_urusan` text DEFAULT NULL,
  `kode_sasaran_rpjm` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `nama_bidang_urusan` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `realisasi_target_1` text DEFAULT NULL,
  `realisasi_target_2` text DEFAULT NULL,
  `realisasi_target_3` text DEFAULT NULL,
  `realisasi_target_4` text DEFAULT NULL,
  `realisasi_target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_tujuan` int(11) DEFAULT NULL, 
  `id_tahap` int(11) DEFAULT NULL,
  `id_tujuan` int(11) DEFAULT NULL,
  `perlu_mutakhirkan` text DEFAULT NULL,    
  `id_visi` int(11) DEFAULT NULL,
  `id_misi` int(11) DEFAULT NULL,
  `tahun_awal` year(4) DEFAULT NULL,
  `tahun_akhir` year(4) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `keterangan_1` text DEFAULT NULL,
  `keterangan_2` text DEFAULT NULL,
  `keterangan_3` text DEFAULT NULL,
  `keterangan_4` text DEFAULT NULL,
  `keterangan_5` text DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_renstra_sasaran` (
  `id` int(11) NOT NULL auto_increment,
  `id_jadwal` int(11) NOT NULL,
  `bidur_lock` int(11) DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_misi` int(11) DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `is_locked` int(11) DEFAULT NULL,
  `is_locked_indikator` int(11) DEFAULT NULL,
  `kode_bidang_urusan` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `nama_bidang_urusan` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `realisasi_target_1` text DEFAULT NULL,
  `realisasi_target_2` text DEFAULT NULL,
  `realisasi_target_3` text DEFAULT NULL,
  `realisasi_target_4` text DEFAULT NULL,
  `realisasi_target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_sasaran` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `id_tahap` int(11) DEFAULT NULL,
  `id_sasaran` int(11) DEFAULT NULL,
  `id_tujuan_indikator` int(11) DEFAULT NULL,  
  `kode_sasaran_rpjm` text DEFAULT NULL,
  `tahun_awal` year(4) DEFAULT NULL,
  `tahun_akhir` year(4) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `keterangan_1` text DEFAULT NULL,
  `keterangan_2` text DEFAULT NULL,
  `keterangan_3` text DEFAULT NULL,
  `keterangan_4` text DEFAULT NULL,
  `keterangan_5` text DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_renstra_program` (
  `id` int(11) NOT NULL auto_increment,
  `id_jadwal` int(11) NOT NULL,
  `bidur_lock` int(11) DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_misi` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_bidang_urusan` text DEFAULT NULL,
  `kode_program` text DEFAULT NULL,
  `kode_sasaran` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `nama_bidang_urusan` text DEFAULT NULL,
  `nama_program` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `pagu_1` double(20,2) DEFAULT NULL,
  `pagu_2` double(20,2) DEFAULT NULL,
  `pagu_3` double(20,2) DEFAULT NULL,
  `pagu_4` double(20,2) DEFAULT NULL,
  `pagu_5` double(20,2) DEFAULT NULL,
  `realisasi_pagu_1` double(20,2) DEFAULT NULL,
  `realisasi_pagu_2` double(20,2) DEFAULT NULL,
  `realisasi_pagu_3` double(20,2) DEFAULT NULL,
  `realisasi_pagu_4` double(20,2) DEFAULT NULL,
  `realisasi_pagu_5` double(20,2) DEFAULT NULL,
  `program_lock` tinyint(4) DEFAULT NULL,
  `sasaran_lock` tinyint(4) DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `realisasi_target_1` text DEFAULT NULL,
  `realisasi_target_2` text DEFAULT NULL,
  `realisasi_target_3` text DEFAULT NULL,
  `realisasi_target_4` text DEFAULT NULL,
  `realisasi_target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_lock` int(11) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_sasaran` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `pagu_awal` double(20,2) DEFAULT NULL,
  `pagu_akhir` double(20,2) DEFAULT NULL,
  `id_tahap` int(11) DEFAULT NULL,
  `id_sasaran_indikator` int(11) DEFAULT NULL,
  `id_renstra_program` int(11) DEFAULT NULL,  
  `kode_sasaran_rpjm` text DEFAULT NULL,
  `tahun_awal` year(4) DEFAULT NULL,
  `tahun_akhir` year(4) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `keterangan_1` text DEFAULT NULL,
  `keterangan_2` text DEFAULT NULL,
  `keterangan_3` text DEFAULT NULL,
  `keterangan_4` text DEFAULT NULL,
  `keterangan_5` text DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_renstra_kegiatan` (
  `id` int(11) NOT NULL auto_increment,
  `id_jadwal` int(11) NOT NULL,
  `bidur_lock` tinyint(4) DEFAULT NULL,
  `giat_lock` tinyint(4) DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_giat` int(11) DEFAULT NULL,
  `id_misi` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_bidang_urusan` text DEFAULT NULL,
  `kode_giat` text DEFAULT NULL,
  `kode_program` text DEFAULT NULL,
  `kode_sasaran` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `kode_unik_program` text DEFAULT NULL,
  `nama_bidang_urusan` text DEFAULT NULL,
  `nama_giat` text DEFAULT NULL,
  `nama_program` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `pagu_1` double(20,2) DEFAULT NULL,
  `pagu_2` double(20,2) DEFAULT NULL,
  `pagu_3` double(20,2) DEFAULT NULL,
  `pagu_4` double(20,2) DEFAULT NULL,
  `pagu_5` double(20,2) DEFAULT NULL,
  `realisasi_pagu_1` double(20,2) DEFAULT NULL,
  `realisasi_pagu_2` double(20,2) DEFAULT NULL,
  `realisasi_pagu_3` double(20,2) DEFAULT NULL,
  `realisasi_pagu_4` double(20,2) DEFAULT NULL,
  `realisasi_pagu_5` double(20,2) DEFAULT NULL,
  `program_lock` tinyint(4) DEFAULT NULL,
  `renstra_prog_lock` tinyint(4) DEFAULT NULL,
  `sasaran_lock` tinyint(4) DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `realisasi_target_1` text DEFAULT NULL,
  `realisasi_target_2` text DEFAULT NULL,
  `realisasi_target_3` text DEFAULT NULL,
  `realisasi_target_4` text DEFAULT NULL,
  `realisasi_target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_sasaran` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `pagu_awal` double(20,2) DEFAULT NULL,
  `pagu_akhir` double(20,2) DEFAULT NULL,
  `id_rpjm_indikator` int(11) DEFAULT NULL,
  `id_tahap` int(11) DEFAULT NULL,
  `kode_sasaran_rpjm` text DEFAULT NULL,
  `tahun_awal` year(4) DEFAULT NULL,
  `tahun_akhir` year(4) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `keterangan_1` text DEFAULT NULL,
  `keterangan_2` text DEFAULT NULL,
  `keterangan_3` text DEFAULT NULL,
  `keterangan_4` text DEFAULT NULL,
  `keterangan_5` text DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_realisasi_akun` (
  `id` int(11) NOT NULL auto_increment,
  `realisasi` double(20, 2) DEFAULT NULL,
  `rak` double(20,2) DEFAULT NULL,
  `kode_akun` text DEFAULT NULL,
  `kode_sbl` text DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `user` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_realisasi_rincian` (
  `id` int(11) NOT NULL auto_increment,
  `id_rinci_sub_bl` int(11) NOT NULL,
  `realisasi` double(20,2) DEFAULT NULL,
  `user` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_realisasi_renja` (
  `id` int(11) NOT NULL auto_increment,
  `id_indikator` int(11) DEFAULT NULL,
  `id_unik_indikator_renstra` text DEFAULT NULL,
  `tipe_indikator` tinyint(4) DEFAULT NULL,
  `id_rumus_indikator` int(11) DEFAULT NULL,
  `kode_sbl` text DEFAULT NULL,
  `realisasi_bulan_1` double(20,2) DEFAULT NULL,
  `realisasi_bulan_2` double(20,2) DEFAULT NULL,
  `realisasi_bulan_3` double(20,2) DEFAULT NULL,
  `realisasi_bulan_4` double(20,2) DEFAULT NULL,
  `realisasi_bulan_5` double(20,2) DEFAULT NULL,
  `realisasi_bulan_6` double(20,2) DEFAULT NULL,
  `realisasi_bulan_7` double(20,2) DEFAULT NULL,
  `realisasi_bulan_8` double(20,2) DEFAULT NULL,
  `realisasi_bulan_9` double(20,2) DEFAULT NULL,
  `realisasi_bulan_10` double(20,2) DEFAULT NULL,
  `realisasi_bulan_11` double(20,2) DEFAULT NULL,
  `realisasi_bulan_12` double(20,2) DEFAULT NULL,
  `[REDACTED]` text DEFAULT NULL,
  `[REDACTED]` text DEFAULT NULL,
  `[REDACTED]` text DEFAULT NULL,
  `[REDACTED]` text DEFAULT NULL,
  `[REDACTED]` text DEFAULT NULL,
  `[REDACTED]` text DEFAULT NULL,
  `[REDACTED]` text DEFAULT NULL,
  `[REDACTED]` text DEFAULT NULL,
  `[REDACTED]` text DEFAULT NULL,
  `[REDACTED]` text DEFAULT NULL,
  `[REDACTED]` text DEFAULT NULL,
  `[REDACTED]` text DEFAULT NULL,
  `user` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rumus_indikator` (
  `id_asli` int(11) NOT NULL auto_increment,
  `id` int(11) NOT NULL,
  `rumus` text DEFAULT NULL,
  `keterangan` text DEFAULT NULL,
  `user` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY  (id_asli)
);

CREATE TABLE `data_monev_renja_triwulan` (
  `id` int(11) NOT NULL auto_increment,
  `triwulan` tinyint(1) NOT NULL,
  `keterangan_skpd` text DEFAULT NULL,
  `id_skpd` int(11) NOT NULL,
  `user_skpd` text DEFAULT NULL,
  `catatan_verifikator` text DEFAULT NULL,
  `user_verifikator` text DEFAULT NULL,
  `file_monev` text DEFAULT NULL,
  `update_skpd_at` datetime NOT NULL,
  `update_verifikator_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_skpd_mitra_bappeda` (
  `id` int(11) NOT NULL auto_increment,
  `akses_user` text DEFAULT NULL,
  `id_level` int(11) DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `id_user` int(11) DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `login_name` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `nama_user` text DEFAULT NULL,
  `nip` text DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `active` tinyint(4) DEFAULT '1',
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjmd_visi` (
  `id` int(11) NOT NULL auto_increment,
  `id_visi` int(11) DEFAULT NULL,
  `is_locked` tinyint(2) DEFAULT NULL,
  `status` text DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_tahap` int(11) DEFAULT NULL,
  `tahun_awal` year(4) DEFAULT NULL,
  `tahun_akhir` year(4) DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `active` tinyint(4) NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjmd_misi` (
  `id` int(11) NOT NULL auto_increment,
  `id_misi` int(11) DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `is_locked` tinyint(2) DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `urut_misi` tinyint(2) DEFAULT NULL,
  `visi_lock` tinyint(2) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_tahap` int(11) DEFAULT NULL,
  `tahun_awal` year(4) DEFAULT NULL,
  `tahun_akhir` year(4) DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `active` tinyint(4) NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_realisasi_renstra` (
  `id` int(11) NOT NULL auto_increment,
  `id_indikator` int(11) NOT NULL,
  `type_indikator` int(11) NOT NULL,
  `id_rumus_indikator` int(11) NOT NULL,
  `hitung_indikator` smallint(6) NOT NULL COMMENT '1 = auto, 0 = manual',
  `realisasi_bulan_1` text NOT NULL,
  `realisasi_bulan_2` text NOT NULL,
  `realisasi_bulan_3` text NOT NULL,
  `realisasi_bulan_4` text NOT NULL,
  `realisasi_bulan_5` text NOT NULL,
  `realisasi_bulan_6` text NOT NULL,
  `realisasi_bulan_7` text NOT NULL,
  `realisasi_bulan_8` text NOT NULL,
  `realisasi_bulan_9` text NOT NULL,
  `realisasi_bulan_10` text NOT NULL,
  `realisasi_bulan_11` text NOT NULL,
  `realisasi_bulan_12` text NOT NULL,
  `capaian_bulan_1` text NOT NULL,
  `capaian_bulan_2` text NOT NULL,
  `capaian_bulan_3` text NOT NULL,
  `capaian_bulan_4` text NOT NULL,
  `capaian_bulan_5` text NOT NULL,
  `capaian_bulan_6` text NOT NULL,
  `capaian_bulan_7` text NOT NULL,
  `capaian_bulan_8` text NOT NULL,
  `capaian_bulan_9` text NOT NULL,
  `capaian_bulan_10` text NOT NULL,
  `capaian_bulan_11` text NOT NULL,
  `capaian_bulan_12` text NOT NULL,
  `realisasi_anggaran_bulan_1` double(20,2) NOT NULL,
  `realisasi_anggaran_bulan_2` double(20,2) NOT NULL,
  `realisasi_anggaran_bulan_3` double(20,2) NOT NULL,
  `realisasi_anggaran_bulan_4` double(20,2) NOT NULL,
  `realisasi_anggaran_bulan_5` double(20,2) NOT NULL,
  `realisasi_anggaran_bulan_6` double(20,2) NOT NULL,
  `realisasi_anggaran_bulan_7` double(20,2) NOT NULL,
  `realisasi_anggaran_bulan_8` double(20,2) NOT NULL,
  `realisasi_anggaran_bulan_9` double(20,2) NOT NULL,
  `realisasi_anggaran_bulan_10` double(20,2) NOT NULL,
  `realisasi_anggaran_bulan_11` double(20,2) NOT NULL,
  `realisasi_anggaran_bulan_12` double(20,2) NOT NULL,
  `keterangan_bulan_1` text NOT NULL,
  `keterangan_bulan_2` text NOT NULL,
  `keterangan_bulan_3` text NOT NULL,
  `keterangan_bulan_4` text NOT NULL,
  `keterangan_bulan_5` text NOT NULL,
  `keterangan_bulan_6` text NOT NULL,
  `keterangan_bulan_7` text NOT NULL,
  `keterangan_bulan_8` text NOT NULL,
  `keterangan_bulan_9` text NOT NULL,
  `keterangan_bulan_10` text NOT NULL,
  `keterangan_bulan_11` text NOT NULL,
  `keterangan_bulan_12` text NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `created_by` text NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_by` text NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_aktivitas_fmis` (
    `id` int(11) NOT NULL auto_increment,
    `id_mapping` text DEFAULT NULL,
    `id_sub_skpd` int(11) DEFAULT NULL,
    `aktivitas` text DEFAULT NULL,
    `idaktivitas` int(11) DEFAULT NULL,
    `dt_rowid` text DEFAULT NULL,
    `dt_rowindex` int(11) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `created_id` int(11) DEFAULT NULL,
    `idasb` int(11) DEFAULT NULL,
    `idpptk` int(11) DEFAULT NULL,
    `idrkpdrenjaaktivitas` text DEFAULT NULL,
    `idsatuan1` int(11) DEFAULT NULL,
    `idsatuan2` int(11) DEFAULT NULL,
    `idsatuan_publik` int(11) DEFAULT NULL,
    `idsubunit` int(11) DEFAULT NULL,
    `idsumberdana1` int(11) DEFAULT NULL,
    `idsumberdana2` int(11) DEFAULT NULL,
    `jn_asb` int(11) DEFAULT NULL,
    `kdurut` int(11) DEFAULT NULL,
    `kode_kegiatan` text DEFAULT NULL,
    `kode_program` text DEFAULT NULL,
    `kode_subkegiatan` text DEFAULT NULL,
    `nmkegiatan` text DEFAULT NULL,
    `nmprogram` text DEFAULT NULL,
    `nmsubkegiatan` text DEFAULT NULL,
    `nmsubunit` text DEFAULT NULL,
    `pagu` double(20,2) DEFAULT NULL,
    `pagu_renja` double(20,2) DEFAULT NULL,
    `satuan_display` text DEFAULT NULL,
    `singkat_sat1` text DEFAULT NULL,
    `singkat_sat2` text DEFAULT NULL,
    `status_dokumen` text DEFAULT NULL,
    `status_pelaksanaan` text DEFAULT NULL,
    `updated_at` text DEFAULT NULL,
    `uraian` text DEFAULT NULL,
    `uraian_sat1` text DEFAULT NULL,
    `uraian_sat2` text DEFAULT NULL,
    `volume1` text DEFAULT NULL,
    `volume2` text DEFAULT NULL,
    `volume_renja1` text DEFAULT NULL,
    `volume_renja2` text DEFAULT NULL,
    `tahun_anggaran` year(4) NOT NULL,
    `active` tinyint(4) NOT NULL DEFAULT '1',
    PRIMARY KEY (id)
);

CREATE TABLE `data_rincian_fmis` (
    `id` int(11) NOT NULL auto_increment,
    `id_mapping` text DEFAULT NULL,
    `id_sub_skpd` int(11) DEFAULT NULL,
    `nama_sub_giat` text DEFAULT NULL,
    `nama_giat` text DEFAULT NULL,
    `nama_program` text DEFAULT NULL,
    `idaktivitas` int(11) DEFAULT NULL,
    `aktivitas` text DEFAULT NULL,
    `dt_rowid` text DEFAULT NULL,
    `dt_rowindex` int(11) DEFAULT NULL,
    `created_at` datetime DEFAULT NULL,
    `created_id` int(11) DEFAULT NULL,
    `harga` double(20,2) DEFAULT NULL,
    `idrkpdrenjabelanja` int(11) DEFAULT NULL,
    `idsatuan1` int(11) DEFAULT NULL,
    `idsatuan2` int(11) DEFAULT NULL,
    `idsatuan3` int(11) DEFAULT NULL,
    `idssh_4` int(11) DEFAULT NULL,
    `idsumberdana` int(11) DEFAULT NULL,
    `jml_volume` TEXT DEFAULT NULL,
    `jml_volume_renja` TEXT DEFAULT NULL,
    `jumlah` double(20,2) DEFAULT NULL,
    `jumlah_renja` TEXT DEFAULT NULL,
    `kdrek1` tinyint(4) DEFAULT NULL,
    `kdrek2` tinyint(4) DEFAULT NULL,
    `kdrek3` tinyint(4) DEFAULT NULL,
    `kdrek4` tinyint(4) DEFAULT NULL,
    `kdrek5` tinyint(4) DEFAULT NULL,
    `kdrek6` tinyint(4) DEFAULT NULL,
    `kdurut` tinyint(4) DEFAULT NULL,
    `kode_rekening` TEXT DEFAULT NULL,
    `nmrek6` TEXT DEFAULT NULL,
    `rekening_display` TEXT DEFAULT NULL,
    `satuan123` TEXT DEFAULT NULL,
    `singkat_sat1` TEXT DEFAULT NULL,
    `singkat_sat2` TEXT DEFAULT NULL,
    `singkat_sat3` TEXT DEFAULT NULL,
    `status_data` TEXT DEFAULT NULL,
    `status_dokumen` TEXT DEFAULT NULL,
    `status_pelaksanaan` TEXT DEFAULT NULL,
    `tahun` TEXT DEFAULT NULL,
    `uraian_belanja` TEXT DEFAULT NULL,
    `uraian_ssh` TEXT DEFAULT NULL,
    `uraian_sumberdana` TEXT DEFAULT NULL,
    `volume_1` TEXT DEFAULT NULL,
    `volume_2` TEXT DEFAULT NULL,
    `volume_3` TEXT DEFAULT NULL,
    `volume_renja1` TEXT DEFAULT NULL,
    `volume_renja2` TEXT DEFAULT NULL,
    `volume_renja3` TEXT DEFAULT NULL,
    `tahun_anggaran` year(4) NOT NULL,
    `active` tinyint(4) NOT NULL DEFAULT '1',
    PRIMARY KEY (id)
);

CREATE TABLE `data_ssh_usulan` (
  `id` int(11) NOT NULL auto_increment,
  `id_standar_harga` int(11) DEFAULT NULL,
  `kode_standar_harga` varchar(30) DEFAULT NULL,
  `nama_standar_harga` text,
  `satuan` text,
  `spek` text,
  `ket_teks` text,
  `created_at` varchar(25) DEFAULT NULL,
  `created_user` int(11) DEFAULT NULL,
  `updated_user` int(11) DEFAULT NULL,
  `is_deleted` tinyint(4) DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `kelompok` tinyint(4) DEFAULT NULL,
  `harga` double(20,2) DEFAULT NULL,
  `harga_2` double(20,2) DEFAULT NULL,
  `harga_3` double(20,2) DEFAULT NULL,
  `kode_kel_standar_harga` varchar(30) DEFAULT NULL,
  `nama_kel_standar_harga` text,
  `update_at` datetime DEFAULT NULL,
  `update_at_admin` datetime DEFAULT NULL,
  `update_at_tapdkeu` datetime DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL DEFAULT '2022',
  `status` varchar(20) DEFAULT NULL COMMENT 'draft, waiting, approved, rejected',
  `status_by_admin` varchar(20) DEFAULT NULL COMMENT 'approved, rejected',
  `status_by_tapdkeu` varchar(20) DEFAULT NULL COMMENT 'approved, rejected',
  `keterangan_status` text,
  `keterangan_status_admin` text,
  `keterangan_status_tapdkeu` text,
  `status_upload_sipd` varchar(20) DEFAULT NULL COMMENT 'null atau 0 = belum diupload ke sipd, 1 = sudah diupload sipd',
  `keterangan_lampiran` text,
  `kode_standar_harga_sipd` varchar(30) DEFAULT NULL,
  `status_jenis_usulan` varchar(30) DEFAULT NULL,
  `jenis_produk` tinyint(4) DEFAULT NULL,
  `tkdn` int(11) DEFAULT NULL,
  `lampiran_1` varchar(255) DEFAULT NULL,
  `lampiran_2` varchar(255) DEFAULT NULL,
  `lampiran_3` varchar(255) DEFAULT NULL,
  `verified_by_admin` int(11) DEFAULT NULL,
  `verified_by_tapdkeu` int(11) DEFAULT NULL,
  `no_surat_usulan` text DEFAULT NULL,
  `no_nota_dinas` text DEFAULT NULL,
  `id_sub_skpd` int(11) DEFAULT NULL,
  `url_lampiran_foto_1` text DEFAULT NULL,
  `url_lampiran_foto_2` text DEFAULT NULL,
  `url_lampiran_foto_3` text DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_ssh_rek_belanja_usulan` (
  `id` int(11) NOT NULL auto_increment,
  `id_akun` int(11) DEFAULT NULL,
  `kode_akun` varchar(50) DEFAULT NULL,
  `nama_akun` text,
  `id_standar_harga` int(11) DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL DEFAULT '2022',
  PRIMARY KEY (id)
);

CREATE TABLE `data_satuan` (
  `id` int(11) NOT NULL auto_increment,
  `id_satuan` int(11) DEFAULT NULL,
  `nama_satuan` varchar(32) DEFAULT NULL,
  `tahun_anggaran` year(4) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_kelompok_satuan_harga` (
  `id` int(11) NOT NULL auto_increment,
  `id_kategori` int(11) DEFAULT NULL,
  `kode_kategori` varchar(64) DEFAULT NULL,
  `uraian_kategori` text,
  `tipe_kelompok` varchar(20) DEFAULT NULL,
  `active` tinyint(2) NOT NULL DEFAULT '1',
  `tahun_anggaran` year(4) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_spd` (
  `id` int(11) NOT NULL auto_increment,
  `no_spd` text NOT NULL,
  `uraian` varchar(64) DEFAULT NULL,
  `id_skpd_sipd` int(11) DEFAULT NULL,
  `kode_skpd_simda` varchar(50) DEFAULT NULL,
  `id_skpd_fmis` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `active` tinyint(2) NOT NULL DEFAULT '1',
  `tahun_anggaran` year(4) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_spd_rinci` (
  `id` int(11) NOT NULL auto_increment,
  `kdurut` int(11) DEFAULT NULL,
  `no_spd` text NOT NULL,
  `idrefaktivitas` int(11) DEFAULT NULL,
  `idsubunit` int(11) DEFAULT NULL,
  `kdrek1` int(5) DEFAULT NULL,
  `kdrek2` int(5) DEFAULT NULL,
  `kdrek3` int(5) DEFAULT NULL,
  `kdrek4` int(5) DEFAULT NULL,
  `kdrek5` int(5) DEFAULT NULL,
  `kdrek6` int(5) DEFAULT NULL,
  `nilai` double (20, 0) DEFAULT NULL,
  `rekening` text DEFAULT NULL,
  `aktivitas_uraian` text DEFAULT NULL,
  `subkegiatan` text DEFAULT NULL,
  `kode_akun` text DEFAULT NULL,
  `nama_sub_giat` text DEFAULT NULL,
  `nama_giat` text DEFAULT NULL,
  `nama_program` text DEFAULT NULL,
  `kd_urusan` int(5) DEFAULT NULL,
  `kd_unit` int(5) DEFAULT NULL,
  `kd_bidang` int(5) DEFAULT NULL,
  `kd_prog` int(5) DEFAULT NULL,
  `kd_keg` int(5) DEFAULT NULL,
  `id_prog` int(5) DEFAULT NULL,
  `active` tinyint(2) NOT NULL DEFAULT '1',
  `tahun_anggaran` year(4) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_jadwal_lokal` (
  `id_jadwal_lokal` int(11) NOT NULL auto_increment,
  `nama` varchar(64) DEFAULT NULL,
  `waktu_awal` datetime DEFAULT NULL,
  `waktu_akhir` datetime DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `tahun_anggaran` year(4) NOT NULL DEFAULT '2022',
  `tahun_akhir_anggaran` year(4) DEFAULT NULL,
  `lama_pelaksanaan` int(2) NOT NULL DEFAULT '1',
  `id_tipe` int(11) NOT NULL,
  `relasi_perencanaan` int(11) DEFAULT NULL,
  `jenis_jadwal` varchar(20) NOT NULL DEFAULT 'usulan',
  `id_jadwal_pergeseran` int(11) DEFAULT NULL,
  `status_jadwal_pergeseran` varchar(64) DEFAULT NULL,
  PRIMARY KEY  (id_jadwal_lokal)
);

CREATE TABLE `data_rka_history` (
  `id` int(11) NOT NULL auto_increment,
  `created_user` int(11) DEFAULT NULL,
  `createddate` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `createdtime` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `harga_satuan` double(20,2) DEFAULT NULL,
  `harga_satuan_murni` double(20,2) DEFAULT NULL,
  `id_daerah` int(11) DEFAULT NULL,
  `id_rinci_sub_bl` int(11) DEFAULT NULL,
  `id_standar_nfs` tinyint(4) DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `jenis_bl` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `ket_bl_teks` text CHARACTER SET latin1,
  `kode_akun` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `koefisien` text CHARACTER SET latin1,
  `koefisien_murni` text CHARACTER SET latin1,
  `lokus_akun_teks` text CHARACTER SET latin1,
  `nama_akun` text CHARACTER SET latin1,
  `nama_komponen` text CHARACTER SET latin1,
  `spek_komponen` text CHARACTER SET latin1,
  `satuan` varchar(150) CHARACTER SET latin1 DEFAULT NULL,
  `spek` text CHARACTER SET latin1 DEFAULT NULL,
  `sat1` text CHARACTER SET latin1,
  `sat2` text CHARACTER SET latin1,
  `sat3` text CHARACTER SET latin1,
  `sat4` text CHARACTER SET latin1,
  `volum1` text CHARACTER SET latin1,
  `volum2` text CHARACTER SET latin1,
  `volum3` text CHARACTER SET latin1,
  `volum4` text CHARACTER SET latin1,
  `volume` text CHARACTER SET latin1,
  `volume_murni` text CHARACTER SET latin1,
  `subs_bl_teks` text CHARACTER SET latin1,
  `subtitle_teks` text CHARACTER SET latin1,
  `kode_dana` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `is_paket` tinyint(4) DEFAULT NULL,
  `nama_dana` text CHARACTER SET latin1,
  `id_dana` int(11) DEFAULT NULL,
  `substeks` text CHARACTER SET latin1,
  `total_harga` double(20,2) DEFAULT NULL,
  `rincian` double(20,2) DEFAULT NULL,
  `rincian_murni` double(20,2) DEFAULT NULL,
  `totalpajak` double(20,2) DEFAULT NULL,
  `pajak` double(20,2) DEFAULT NULL,
  `pajak_murni` double(20,2) DEFAULT NULL,
  `updated_user` int(11) DEFAULT NULL,
  `updateddate` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
  `updatedtime` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
  `user1` text CHARACTER SET latin1,
  `user2` text CHARACTER SET latin1,
  `active` tinyint(4) DEFAULT '1',
  `ssh_locked` tinyint(4) DEFAULT NULL,
  `akun_locked` tinyint(4) DEFAULT NULL,
  `update_at` datetime DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL DEFAULT '2021',
  `idbl` int(11) DEFAULT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `kode_bl` varchar(50) CHARACTER SET latin1 NOT NULL,
  `kode_sbl` varchar(50) CHARACTER SET latin1 NOT NULL,
  `id_prop_penerima` int(11) DEFAULT NULL,
  `id_camat_penerima` int(11) DEFAULT NULL,
  `id_kokab_penerima` int(11) DEFAULT NULL,
  `id_lurah_penerima` int(11) DEFAULT NULL,
  `id_penerima` int(11) DEFAULT NULL,
  `idkomponen` double(20,2) DEFAULT NULL,
  `idketerangan` int(11) DEFAULT NULL,
  `idsubtitle` int(11) DEFAULT NULL,
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_sub_keg_bl_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_sub_skpd` int(11) NOT NULL,
  `id_lokasi` int(11) DEFAULT NULL,
  `id_label_kokab` int(11) NOT NULL,
  `nama_dana` text CHARACTER SET latin1,
  `no_sub_giat` varchar(20) CHARACTER SET latin1 NOT NULL,
  `kode_giat` varchar(50) CHARACTER SET latin1 NOT NULL,
  `id_program` int(11) NOT NULL,
  `nama_lokasi` text CHARACTER SET latin1,
  `waktu_akhir` int(11) NOT NULL,
  `pagu_n_lalu` double(20,2) DEFAULT NULL,
  `id_urusan` int(11) NOT NULL,
  `id_unik_sub_bl` text CHARACTER SET latin1 NOT NULL,
  `id_sub_giat` int(11) NOT NULL,
  `label_prov` text CHARACTER SET latin1,
  `kode_program` varchar(50) CHARACTER SET latin1 NOT NULL,
  `kode_sub_giat` varchar(50) CHARACTER SET latin1 NOT NULL,
  `no_program` varchar(20) CHARACTER SET latin1 NOT NULL,
  `kode_urusan` varchar(20) CHARACTER SET latin1 NOT NULL,
  `kode_bidang_urusan` varchar(20) CHARACTER SET latin1 NOT NULL,
  `nama_program` text CHARACTER SET latin1 NOT NULL,
  `target_4` text CHARACTER SET latin1,
  `target_5` text CHARACTER SET latin1,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `nama_bidang_urusan` text CHARACTER SET latin1,
  `target_3` text CHARACTER SET latin1,
  `no_giat` varchar(50) CHARACTER SET latin1 NOT NULL,
  `id_label_prov` int(11) NOT NULL,
  `waktu_awal` int(11) NOT NULL,
  `pagumurni` double(20,2) DEFAULT NULL,
  `pagu` double(20,2) NOT NULL,
  `pagu_simda` double(20,2) DEFAULT NULL,
  `output_sub_giat` text CHARACTER SET latin1,
  `sasaran` text CHARACTER SET latin1,
  `indikator` text CHARACTER SET latin1,
  `id_dana` int(11) DEFAULT NULL,
  `nama_sub_giat` text CHARACTER SET latin1 NOT NULL,
  `pagu_n_depan` double(20,2) NOT NULL,
  `satuan` text CHARACTER SET latin1,
  `id_rpjmd` int(11) NOT NULL,
  `id_giat` int(11) NOT NULL,
  `id_label_pusat` int(11) NOT NULL,
  `nama_giat` text CHARACTER SET latin1 NOT NULL,
  `kode_skpd` varchar(50) CHARACTER SET latin1 NOT NULL,
  `nama_skpd` text CHARACTER SET latin1 NOT NULL,
  `kode_sub_skpd` varchar(50) CHARACTER SET latin1 NOT NULL,
  `id_skpd` int(11) NOT NULL,
  `id_sub_bl` int(11) DEFAULT NULL,
  `nama_sub_skpd` text CHARACTER SET latin1 NOT NULL,
  `target_1` text CHARACTER SET latin1,
  `nama_urusan` text CHARACTER SET latin1 NOT NULL,
  `target_2` text CHARACTER SET latin1,
  `label_kokab` text CHARACTER SET latin1,
  `label_pusat` text CHARACTER SET latin1,
  `pagu_keg` double(20,2) NOT NULL,
  `pagu_fmis` double(20,2) DEFAULT NULL,
  `id_bl` int(11) DEFAULT NULL,
  `kode_bl` varchar(50) CHARACTER SET latin1 NOT NULL,
  `kode_sbl` varchar(50) CHARACTER SET latin1 NOT NULL,
  `active` tinyint(4) DEFAULT '1',
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL DEFAULT '2021',
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_sub_keg_bl_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_sub_skpd` int(11) NOT NULL,
  `id_lokasi` int(11) DEFAULT NULL,
  `id_label_kokab` int(11) NOT NULL,
  `nama_dana` text CHARACTER SET latin1,
  `no_sub_giat` varchar(20) CHARACTER SET latin1 NOT NULL,
  `kode_giat` varchar(50) CHARACTER SET latin1 NOT NULL,
  `id_program` int(11) NOT NULL,
  `nama_lokasi` text CHARACTER SET latin1,
  `waktu_akhir` int(11) NOT NULL,
  `pagu_n_lalu` double(20,2) DEFAULT NULL,
  `id_urusan` int(11) NOT NULL,
  `id_unik_sub_bl` text CHARACTER SET latin1 NOT NULL,
  `id_sub_giat` int(11) NOT NULL,
  `label_prov` text CHARACTER SET latin1,
  `kode_program` varchar(50) CHARACTER SET latin1 NOT NULL,
  `kode_sub_giat` varchar(50) CHARACTER SET latin1 NOT NULL,
  `no_program` varchar(20) CHARACTER SET latin1 NOT NULL,
  `kode_urusan` varchar(20) CHARACTER SET latin1 NOT NULL,
  `kode_bidang_urusan` varchar(20) CHARACTER SET latin1 NOT NULL,
  `nama_program` text CHARACTER SET latin1 NOT NULL,
  `target_4` text CHARACTER SET latin1,
  `target_5` text CHARACTER SET latin1,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `nama_bidang_urusan` text CHARACTER SET latin1,
  `target_3` text CHARACTER SET latin1,
  `no_giat` varchar(50) CHARACTER SET latin1 NOT NULL,
  `id_label_prov` int(11) NOT NULL,
  `waktu_awal` int(11) NOT NULL,
  `pagumurni` double(20,2) DEFAULT NULL,
  `pagu` double(20,2) NOT NULL,
  `pagu_simda` double(20,2) DEFAULT NULL,
  `output_sub_giat` text CHARACTER SET latin1,
  `sasaran` text CHARACTER SET latin1,
  `indikator` text CHARACTER SET latin1,
  `id_dana` int(11) DEFAULT NULL,
  `nama_sub_giat` text CHARACTER SET latin1 NOT NULL,
  `pagu_n_depan` double(20,2) NOT NULL,
  `satuan` text CHARACTER SET latin1,
  `id_rpjmd` int(11) NOT NULL,
  `id_giat` int(11) NOT NULL,
  `id_label_pusat` int(11) NOT NULL,
  `nama_giat` text CHARACTER SET latin1 NOT NULL,
  `kode_skpd` varchar(50) CHARACTER SET latin1 NOT NULL,
  `nama_skpd` text CHARACTER SET latin1 NOT NULL,
  `kode_sub_skpd` varchar(50) CHARACTER SET latin1 NOT NULL,
  `id_skpd` int(11) NOT NULL,
  `id_sub_bl` int(11) DEFAULT NULL,
  `nama_sub_skpd` text CHARACTER SET latin1 NOT NULL,
  `target_1` text CHARACTER SET latin1,
  `nama_urusan` text CHARACTER SET latin1 NOT NULL,
  `target_2` text CHARACTER SET latin1,
  `label_kokab` text CHARACTER SET latin1,
  `label_pusat` text CHARACTER SET latin1,
  `pagu_keg` double(20,2) NOT NULL,
  `pagu_fmis` double(20,2) DEFAULT NULL,
  `id_bl` int(11) DEFAULT NULL,
  `kode_bl` varchar(50) CHARACTER SET latin1 NOT NULL,
  `kode_sbl` varchar(50) CHARACTER SET latin1 NOT NULL,
  `active` tinyint(4) DEFAULT '1',
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL DEFAULT '2021',
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `catatan` text DEFAULT NULL,
  `catatan_usulan` text DEFAULT NULL,
  `pagu_usulan` double(20,2) DEFAULT NULL,
  `pagu_n_depan_usulan` double(20,2) DEFAULT NULL,
  `waktu_awal_usulan` int(11) DEFAULT NULL,
  `waktu_akhir_usulan` int(11) DEFAULT NULL,
  `sasaran_usulan` text DEFAULT NULL,
  `kode_sbl_lama` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_sub_keg_indikator_history` (
  `id` int(11) NOT NULL auto_increment,
  `outputteks` text NOT NULL,
  `targetoutput` varchar(50) NOT NULL,
  `satuanoutput` text NOT NULL,
  `idoutputbl` int(11) NOT NULL,
  `targetoutputteks` text NOT NULL,
  `kode_sbl` varchar(50) NOT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `bobot_kinerja` varchar(50) DEFAULT 1,
  `active` tinyint(4) DEFAULT '1',
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_sub_keg_indikator_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `outputteks` text NOT NULL,
  `targetoutput` varchar(50) NOT NULL,
  `satuanoutput` text NOT NULL,
  `idoutputbl` int(11) NOT NULL,
  `targetoutputteks` text NOT NULL,
  `kode_sbl` varchar(50) NOT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `bobot_kinerja` varchar(50) DEFAULT 1,
  `active` tinyint(4) DEFAULT '1',
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `outputteks_usulan` text DEFAULT NULL,
  `targetoutput_usulan` varchar(50) DEFAULT NULL,
  `satuanoutput_usulan` text DEFAULT NULL,
  `targetoutputteks_usulan` text DEFAULT NULL,
  `id_indikator_sub_giat` int(11) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_keg_indikator_hasil_history` (
  `id` int(11) NOT NULL auto_increment,
  `hasilteks` text,
  `satuanhasil` varchar(50) DEFAULT NULL,
  `targethasil` varchar(50) DEFAULT NULL,
  `targethasilteks` varchar(50) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `idsubbl` varchar(50) DEFAULT NULL,
  `active` tinyint(4) DEFAULT '1',
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_tag_sub_keg_history` (
  `id` int(11) NOT NULL auto_increment,
  `idlabelgiat` int(11) DEFAULT NULL,
  `namalabel` varchar(50) DEFAULT NULL,
  `idtagbl` int(11) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `active` tinyint(4) DEFAULT '1',
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_capaian_prog_sub_keg_history` (
  `id` int(11) NOT NULL auto_increment,
  `satuancapaian` varchar(50) DEFAULT NULL,
  `targetcapaianteks` varchar(50) DEFAULT NULL,
  `capaianteks` text,
  `targetcapaian` int(11) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `bobot_kinerja` varchar(50) DEFAULT 1,
  `active` tinyint(4) DEFAULT '1',
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_capaian_prog_sub_keg_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `satuancapaian` varchar(50) DEFAULT NULL,
  `targetcapaianteks` varchar(50) DEFAULT NULL,
  `capaianteks` text,
  `targetcapaian` int(11) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `bobot_kinerja` varchar(50) DEFAULT 1,
  `active` tinyint(4) DEFAULT '1',
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `satuancapaian_usulan` varchar(50) DEFAULT NULL,
  `targetcapaianteks_usulan` varchar(50) DEFAULT NULL,
  `capaianteks_usulan` text DEFAULT NULL,
  `targetcapaian_usulan` int(11) DEFAULT NULL,
  `catatan` text DEFAULT NULL,
  `catatan_usulan` text DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_output_giat_sub_keg_history` (
  `id` int(11) NOT NULL auto_increment,
  `outputteks` text,
  `satuanoutput` varchar(50) DEFAULT NULL,
  `targetoutput` varchar(50) DEFAULT NULL,
  `targetoutputteks` varchar(50) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `bobot_kinerja` varchar(50) DEFAULT 1,
  `active` tinyint(4) DEFAULT '1',
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_output_giat_sub_keg_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `outputteks` text,
  `satuanoutput` varchar(50) DEFAULT NULL,
  `targetoutput` varchar(50) DEFAULT NULL,
  `targetoutputteks` varchar(50) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `bobot_kinerja` varchar(50) DEFAULT 1,
  `active` tinyint(4) DEFAULT '1',
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `outputteks_usulan` text DEFAULT NULL,
  `satuanoutput_usulan` varchar(50) DEFAULT NULL,
  `targetoutput_usulan` varchar(50) DEFAULT NULL,
  `targetoutputteks_usulan` varchar(50) DEFAULT NULL,
  `catatan` text DEFAULT NULL,
  `catatan_usulan` text DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_dana_sub_keg_history` (
  `id` int(11) NOT NULL auto_increment,
  `namadana` text,
  `kodedana` varchar(50) DEFAULT NULL,
  `iddana` int(11) DEFAULT NULL,
  `iddanasubbl` int(11) DEFAULT NULL,
  `pagudana` double(20,2) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `active` tinyint(4) DEFAULT '1',
  `is_locked` tinyint(4) DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_lokasi_sub_keg_history` (
  `id` int(11) NOT NULL auto_increment,
  `camatteks` text,
  `daerahteks` text,
  `idcamat` int(11) DEFAULT NULL,
  `iddetillokasi` double DEFAULT NULL,
  `idkabkota` int(11) DEFAULT NULL,
  `idlurah` int(11) DEFAULT NULL,
  `lurahteks` text,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `active` tinyint(4) DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_lokasi_sub_keg_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `camatteks` text,
  `daerahteks` text,
  `idcamat` int(11) DEFAULT NULL,
  `iddetillokasi` double DEFAULT NULL,
  `idkabkota` int(11) DEFAULT NULL,
  `idlurah` int(11) DEFAULT NULL,
  `lurahteks` text,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `active` tinyint(4) DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `camatteks_usulan` text DEFAULT NULL,
  `daerahteks_usulan` text DEFAULT NULL,
  `idcamat_usulan` int(11) DEFAULT NULL,
  `iddetillokasi_usulan` double DEFAULT NULL,
  `idkabkota_usulan` int(11) DEFAULT NULL,
  `idlurah_usulan` int(11) DEFAULT NULL,
  `lurahteks_usulan` text DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_mapping_sumberdana_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_rinci_sub_bl` int(11) NOT NULL,
  `id_sumber_dana` int(11) NOT NULL,
  `user` text,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_tipe_perencanaan` (
  `id` int(11) NOT NULL auto_increment,
  `nama_tipe` varchar(64) NOT NULL,
  `keterangan_tipe` text NOT NULL,
  `lama_pelaksanaan` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjmd_visi_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `id_visi` int(11) DEFAULT NULL,
  `is_locked` tinyint(2) DEFAULT NULL,
  `status` text DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `active` tinyint(4) NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjmd_misi_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `id_misi` int(11) DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `is_locked` tinyint(2) DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `urut_misi` tinyint(2) DEFAULT NULL,
  `visi_lock` tinyint(2) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `active` tinyint(4) NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjmd_tujuan_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `id_misi` int(11) DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_tujuan` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `misi_lock` tinyint(4) DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` int(11) DEFAULT NULL,
  `urut_tujuan` int(11) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjmd_sasaran_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `id_misi` int(11) DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_sasaran` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` int(11) DEFAULT NULL,
  `urut_sasaran` int(11) DEFAULT NULL,
  `urut_tujuan` int(11) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjmd_program_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `id_misi` int(11) DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` varchar(20) DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_sasaran` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `nama_program` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `pagu_1` double(20,2) DEFAULT NULL,
  `pagu_2` double(20,2) DEFAULT NULL,
  `pagu_3` double(20,2) DEFAULT NULL,
  `pagu_4` double(20,2) DEFAULT NULL,
  `pagu_5` double(20,2) DEFAULT NULL,
  `program_lock` tinyint(4) DEFAULT NULL,
  `sasaran_lock` tinyint(4) DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` int(11) DEFAULT NULL,
  `urut_sasaran` int(11) DEFAULT NULL,
  `urut_tujuan` int(11) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_program_lama` int(11) DEFAULT NULL
  PRIMARY KEY (id)
);

CREATE TABLE `data_renstra_tujuan_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `bidur_lock` int(11) DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `indikator_teks_usulan` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_bidang_urusan` text DEFAULT NULL,
  `kode_sasaran_rpjm` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `nama_bidang_urusan` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `satuan_usulan` text DEFAULT NULL,
  `target_1_usulan` text DEFAULT NULL,
  `target_2_usulan` text DEFAULT NULL,
  `target_3_usulan` text DEFAULT NULL,
  `target_4_usulan` text DEFAULT NULL,
  `target_5_usulan` text DEFAULT NULL,
  `target_akhir_usulan` text DEFAULT NULL,
  `target_awal_usulan` text DEFAULT NULL,
  `catatan_usulan` text DEFAULT NULL,
  `catatan` text DEFAULT NULL,
  `catatan_tujuan` text DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_tujuan` int(11) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_renstra_sasaran_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `bidur_lock` int(11) DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_misi` int(11) DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `indikator_teks_usulan` text DEFAULT NULL,
  `is_locked` int(11) DEFAULT NULL,
  `is_locked_indikator` int(11) DEFAULT NULL,
  `kode_bidang_urusan` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `nama_bidang_urusan` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,  
  `satuan_usulan` text DEFAULT NULL,
  `target_1_usulan` text DEFAULT NULL,
  `target_2_usulan` text DEFAULT NULL,
  `target_3_usulan` text DEFAULT NULL,
  `target_4_usulan` text DEFAULT NULL,
  `target_5_usulan` text DEFAULT NULL,
  `target_akhir_usulan` text DEFAULT NULL,
  `target_awal_usulan` text DEFAULT NULL,
  `catatan_usulan` text DEFAULT NULL,
  `catatan` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_sasaran` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_renstra_program_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `bidur_lock` int(11) DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_misi` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator` text DEFAULT NULL,
  `indikator_usulan` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_bidang_urusan` text DEFAULT NULL,
  `kode_program` text DEFAULT NULL,
  `kode_sasaran` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `nama_bidang_urusan` text DEFAULT NULL,
  `nama_program` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `pagu_1` double(20,2) DEFAULT NULL,
  `pagu_2` double(20,2) DEFAULT NULL,
  `pagu_3` double(20,2) DEFAULT NULL,
  `pagu_4` double(20,2) DEFAULT NULL,
  `pagu_5` double(20,2) DEFAULT NULL,
  `pagu_1_usulan` double(20,2) DEFAULT NULL,
  `pagu_2_usulan` double(20,2) DEFAULT NULL,
  `pagu_3_usulan` double(20,2) DEFAULT NULL,
  `pagu_4_usulan` double(20,2) DEFAULT NULL,
  `pagu_5_usulan` double(20,2) DEFAULT NULL,
  `program_lock` tinyint(4) DEFAULT NULL,
  `sasaran_lock` tinyint(4) DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `satuan_usulan` text DEFAULT NULL,
  `target_1_usulan` text DEFAULT NULL,
  `target_2_usulan` text DEFAULT NULL,
  `target_3_usulan` text DEFAULT NULL,
  `target_4_usulan` text DEFAULT NULL,
  `target_5_usulan` text DEFAULT NULL,
  `target_akhir_usulan` text DEFAULT NULL,
  `target_awal_usulan` text DEFAULT NULL,
  `catatan_usulan` text DEFAULT NULL,
  `catatan` text DEFAULT NULL,
  `tujuan_lock` int(11) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_sasaran` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_program_lama` int(11) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_renstra_kegiatan_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `bidur_lock` tinyint(4) DEFAULT NULL,
  `giat_lock` tinyint(4) DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_giat` int(11) DEFAULT NULL,
  `id_misi` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator` text DEFAULT NULL,
  `indikator_usulan` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_bidang_urusan` text DEFAULT NULL,
  `kode_giat` text DEFAULT NULL,
  `kode_program` text DEFAULT NULL,
  `kode_sasaran` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `kode_unik_program` text DEFAULT NULL,
  `nama_bidang_urusan` text DEFAULT NULL,
  `nama_giat` text DEFAULT NULL,
  `nama_program` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `pagu_1` double(20,2) DEFAULT NULL,
  `pagu_2` double(20,2) DEFAULT NULL,
  `pagu_3` double(20,2) DEFAULT NULL,
  `pagu_4` double(20,2) DEFAULT NULL,
  `pagu_5` double(20,2) DEFAULT NULL,
  `pagu_1_usulan` double(20,2) DEFAULT NULL,
  `pagu_2_usulan` double(20,2) DEFAULT NULL,
  `pagu_3_usulan` double(20,2) DEFAULT NULL,
  `pagu_4_usulan` double(20,2) DEFAULT NULL,
  `pagu_5_usulan` double(20,2) DEFAULT NULL,
  `program_lock` tinyint(4) DEFAULT NULL,
  `renstra_prog_lock` tinyint(4) DEFAULT NULL,
  `sasaran_lock` tinyint(4) DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `satuan_usulan` text DEFAULT NULL,
  `target_1_usulan` text DEFAULT NULL,
  `target_2_usulan` text DEFAULT NULL,
  `target_3_usulan` text DEFAULT NULL,
  `target_4_usulan` text DEFAULT NULL,
  `target_5_usulan` text DEFAULT NULL,
  `target_akhir_usulan` text DEFAULT NULL,
  `target_awal_usulan` text DEFAULT NULL,
  `catatan_usulan` text DEFAULT NULL,
  `catatan` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_sasaran` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_giat_lama` int(11) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjmd_visi_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_visi` int(11) DEFAULT NULL,
  `is_locked` tinyint(2) DEFAULT NULL,
  `status` text DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `active` tinyint(4) NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjmd_misi_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_misi` int(11) DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `is_locked` tinyint(2) DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `urut_misi` tinyint(2) DEFAULT NULL,
  `visi_lock` tinyint(2) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `active` tinyint(4) NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjmd_tujuan_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_misi` int(11) DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_tujuan` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `misi_lock` tinyint(4) DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` int(11) DEFAULT NULL,
  `urut_tujuan` int(11) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjmd_sasaran_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_misi` int(11) DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_sasaran` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` int(11) DEFAULT NULL,
  `urut_sasaran` int(11) DEFAULT NULL,
  `urut_tujuan` int(11) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `id_program_lama` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjmd_program_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_misi` int(11) DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` varchar(20) DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_sasaran` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `nama_program` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `pagu_1` double(20,2) DEFAULT NULL,
  `pagu_2` double(20,2) DEFAULT NULL,
  `pagu_3` double(20,2) DEFAULT NULL,
  `pagu_4` double(20,2) DEFAULT NULL,
  `pagu_5` double(20,2) DEFAULT NULL,
  `program_lock` tinyint(4) DEFAULT NULL,
  `sasaran_lock` tinyint(4) DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` int(11) DEFAULT NULL,
  `urut_sasaran` int(11) DEFAULT NULL,
  `urut_tujuan` int(11) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `id_program_lama` int(11) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_renstra_tujuan_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `bidur_lock` int(11) DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `indikator_teks_usulan` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_bidang_urusan` text DEFAULT NULL,
  `kode_sasaran_rpjm` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `nama_bidang_urusan` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `satuan_usulan` text DEFAULT NULL,
  `target_1_usulan` text DEFAULT NULL,
  `target_2_usulan` text DEFAULT NULL,
  `target_3_usulan` text DEFAULT NULL,
  `target_4_usulan` text DEFAULT NULL,
  `target_5_usulan` text DEFAULT NULL,
  `target_akhir_usulan` text DEFAULT NULL,
  `target_awal_usulan` text DEFAULT NULL,
  `catatan_usulan` text DEFAULT NULL,
  `catatan` text DEFAULT NULL,
  `catatan_tujuan` text DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_tujuan` int(11) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_renstra_sasaran_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `bidur_lock` int(11) DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_misi` int(11) DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `indikator_teks_usulan` text DEFAULT NULL,
  `is_locked` int(11) DEFAULT NULL,
  `is_locked_indikator` int(11) DEFAULT NULL,
  `kode_bidang_urusan` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `nama_bidang_urusan` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `satuan_usulan` text DEFAULT NULL,
  `target_1_usulan` text DEFAULT NULL,
  `target_2_usulan` text DEFAULT NULL,
  `target_3_usulan` text DEFAULT NULL,
  `target_4_usulan` text DEFAULT NULL,
  `target_5_usulan` text DEFAULT NULL,
  `target_akhir_usulan` text DEFAULT NULL,
  `target_awal_usulan` text DEFAULT NULL,
  `catatan_usulan` text DEFAULT NULL,
  `catatan` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_sasaran` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_renstra_program_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `bidur_lock` int(11) DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_misi` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator` text DEFAULT NULL,
  `indikator_usulan` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_bidang_urusan` text DEFAULT NULL,
  `kode_program` text DEFAULT NULL,
  `kode_sasaran` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `nama_bidang_urusan` text DEFAULT NULL,
  `nama_program` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `pagu_1` double(20,2) DEFAULT NULL,
  `pagu_2` double(20,2) DEFAULT NULL,
  `pagu_3` double(20,2) DEFAULT NULL,
  `pagu_4` double(20,2) DEFAULT NULL,
  `pagu_5` double(20,2) DEFAULT NULL,
  `pagu_1_usulan` double(20,2) DEFAULT NULL,
  `pagu_2_usulan` double(20,2) DEFAULT NULL,
  `pagu_3_usulan` double(20,2) DEFAULT NULL,
  `pagu_4_usulan` double(20,2) DEFAULT NULL,
  `pagu_5_usulan` double(20,2) DEFAULT NULL,
  `program_lock` tinyint(4) DEFAULT NULL,
  `sasaran_lock` tinyint(4) DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `satuan_usulan` text DEFAULT NULL,
  `target_1_usulan` text DEFAULT NULL,
  `target_2_usulan` text DEFAULT NULL,
  `target_3_usulan` text DEFAULT NULL,
  `target_4_usulan` text DEFAULT NULL,
  `target_5_usulan` text DEFAULT NULL,
  `target_akhir_usulan` text DEFAULT NULL,
  `target_awal_usulan` text DEFAULT NULL,
  `catatan_usulan` text DEFAULT NULL,
  `catatan` text DEFAULT NULL,
  `tujuan_lock` int(11) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_sasaran` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `id_program_lama` int(11) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_renstra_kegiatan_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `bidur_lock` tinyint(4) DEFAULT NULL,
  `giat_lock` tinyint(4) DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_giat` int(11) DEFAULT NULL,
  `id_misi` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator` text DEFAULT NULL,
  `indikator_usulan` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_bidang_urusan` text DEFAULT NULL,
  `kode_giat` text DEFAULT NULL,
  `kode_program` text DEFAULT NULL,
  `kode_sasaran` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `kode_unik_program` text DEFAULT NULL,
  `nama_bidang_urusan` text DEFAULT NULL,
  `nama_giat` text DEFAULT NULL,
  `nama_program` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `pagu_1` double(20,2) DEFAULT NULL,
  `pagu_2` double(20,2) DEFAULT NULL,
  `pagu_3` double(20,2) DEFAULT NULL,
  `pagu_4` double(20,2) DEFAULT NULL,
  `pagu_5` double(20,2) DEFAULT NULL,
  `pagu_1_usulan` double(20,2) DEFAULT NULL,
  `pagu_2_usulan` double(20,2) DEFAULT NULL,
  `pagu_3_usulan` double(20,2) DEFAULT NULL,
  `pagu_4_usulan` double(20,2) DEFAULT NULL,
  `pagu_5_usulan` double(20,2) DEFAULT NULL,
  `program_lock` tinyint(4) DEFAULT NULL,
  `renstra_prog_lock` tinyint(4) DEFAULT NULL,
  `sasaran_lock` tinyint(4) DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `satuan_usulan` text DEFAULT NULL,
  `target_1_usulan` text DEFAULT NULL,
  `target_2_usulan` text DEFAULT NULL,
  `target_3_usulan` text DEFAULT NULL,
  `target_4_usulan` text DEFAULT NULL,
  `target_5_usulan` text DEFAULT NULL,
  `target_akhir_usulan` text DEFAULT NULL,
  `target_awal_usulan` text DEFAULT NULL,
  `catatan_usulan` text DEFAULT NULL,
  `catatan` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_sasaran` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `id_giat_lama` int(11) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjmd_visi_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_visi` int(11) DEFAULT NULL,
  `is_locked` tinyint(2) DEFAULT NULL,
  `status` text DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `active` tinyint(4) NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjmd_misi_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_misi` int(11) DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `is_locked` tinyint(2) DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `urut_misi` tinyint(2) DEFAULT NULL,
  `visi_lock` tinyint(2) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `active` tinyint(4) NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjmd_tujuan_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_misi` int(11) DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_tujuan` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `misi_lock` tinyint(4) DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` int(11) DEFAULT NULL,
  `urut_tujuan` int(11) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjmd_sasaran_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_misi` int(11) DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_sasaran` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` int(11) DEFAULT NULL,
  `urut_sasaran` int(11) DEFAULT NULL,
  `urut_tujuan` int(11) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjmd_program_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_misi` int(11) DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` varchar(20) DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_sasaran` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `nama_program` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `pagu_1` double(20,2) DEFAULT NULL,
  `pagu_2` double(20,2) DEFAULT NULL,
  `pagu_3` double(20,2) DEFAULT NULL,
  `pagu_4` double(20,2) DEFAULT NULL,
  `pagu_5` double(20,2) DEFAULT NULL,
  `program_lock` tinyint(4) DEFAULT NULL,
  `sasaran_lock` tinyint(4) DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` int(11) DEFAULT NULL,
  `urut_sasaran` int(11) DEFAULT NULL,
  `urut_tujuan` int(11) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_renstra_tujuan_history` (
  `id` int(11) NOT NULL auto_increment,
  `bidur_lock` int(11) DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_bidang_urusan` text DEFAULT NULL,
  `kode_sasaran_rpjm` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `nama_bidang_urusan` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_tujuan` int(11) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `keterangan_1` text DEFAULT NULL,
  `keterangan_2` text DEFAULT NULL,
  `keterangan_3` text DEFAULT NULL,
  `keterangan_4` text DEFAULT NULL,
  `keterangan_5` text DEFAULT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_renstra_sasaran_history` (
  `id` int(11) NOT NULL auto_increment,
  `bidur_lock` int(11) DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_misi` int(11) DEFAULT NULL,
  `id_unik` int(11) DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` text DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `is_locked` int(11) DEFAULT NULL,
  `is_locked_indikator` int(11) DEFAULT NULL,
  `kode_bidang_urusan` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `nama_bidang_urusan` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_sasaran` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `keterangan_1` text DEFAULT NULL,
  `keterangan_2` text DEFAULT NULL,
  `keterangan_3` text DEFAULT NULL,
  `keterangan_4` text DEFAULT NULL,
  `keterangan_5` text DEFAULT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_renstra_program_history` (
  `id` int(11) NOT NULL auto_increment,
  `bidur_lock` int(11) DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_misi` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_bidang_urusan` text DEFAULT NULL,
  `kode_program` text DEFAULT NULL,
  `kode_sasaran` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `nama_bidang_urusan` text DEFAULT NULL,
  `nama_program` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `pagu_1` double(20,2) DEFAULT NULL,
  `pagu_2` double(20,2) DEFAULT NULL,
  `pagu_3` double(20,2) DEFAULT NULL,
  `pagu_4` double(20,2) DEFAULT NULL,
  `pagu_5` double(20,2) DEFAULT NULL,
  `program_lock` tinyint(4) DEFAULT NULL,
  `sasaran_lock` tinyint(4) DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_lock` int(11) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_sasaran` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `keterangan_1` text DEFAULT NULL,
  `keterangan_2` text DEFAULT NULL,
  `keterangan_3` text DEFAULT NULL,
  `keterangan_4` text DEFAULT NULL,
  `keterangan_5` text DEFAULT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_renstra_kegiatan_history` (
  `id` int(11) NOT NULL auto_increment,
  `bidur_lock` tinyint(4) DEFAULT NULL,
  `giat_lock` tinyint(4) DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_giat` int(11) DEFAULT NULL,
  `id_misi` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `indikator` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_bidang_urusan` text DEFAULT NULL,
  `kode_giat` text DEFAULT NULL,
  `kode_program` text DEFAULT NULL,
  `kode_sasaran` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `kode_unik_program` text DEFAULT NULL,
  `nama_bidang_urusan` text DEFAULT NULL,
  `nama_giat` text DEFAULT NULL,
  `nama_program` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `pagu_1` double(20,2) DEFAULT NULL,
  `pagu_2` double(20,2) DEFAULT NULL,
  `pagu_3` double(20,2) DEFAULT NULL,
  `pagu_4` double(20,2) DEFAULT NULL,
  `pagu_5` double(20,2) DEFAULT NULL,
  `program_lock` tinyint(4) DEFAULT NULL,
  `renstra_prog_lock` tinyint(4) DEFAULT NULL,
  `sasaran_lock` tinyint(4) DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_sasaran` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `keterangan_1` text DEFAULT NULL,
  `keterangan_2` text DEFAULT NULL,
  `keterangan_3` text DEFAULT NULL,
  `keterangan_4` text DEFAULT NULL,
  `keterangan_5` text DEFAULT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpd_tujuan` (
  `id` int(11) NOT NULL auto_increment,
  `head_teks` text DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_tujuan` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `isu_teks` text DEFAULT NULL,
  `kebijakan_teks` text DEFAULT NULL,
  `misi_lock` tinyint(4) DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `saspok_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` tinyint(4) DEFAULT NULL,
  `urut_saspok` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpd_sasaran` (
  `id` int(11) NOT NULL auto_increment,
  `head_teks` text DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_sasaran` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `isu_teks` text DEFAULT NULL,
  `kebijakan_teks` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `misi_lock` tinyint(4) DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `saspok_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` text DEFAULT NULL,
  `urut_sasaran` text DEFAULT NULL,
  `urut_saspok` text DEFAULT NULL,
  `urut_tujuan` text DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpd_program` (
  `id` int(11) NOT NULL auto_increment,
  `head_teks` text DEFAULT NULL,
  `id_bidur_mth` int(11) DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_program_mth` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` varchar(20) DEFAULT NULL,
  `indikator` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `isu_teks` text DEFAULT NULL,
  `kebijakan_teks` text DEFAULT NULL,
  `kode_sasaran` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `misi_lock` text DEFAULT NULL,
  `misi_teks` tinyint(4) DEFAULT NULL,
  `nama_program` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `pagu_1` double(20,2) DEFAULT NULL,
  `pagu_2` double(20,2) DEFAULT NULL,
  `pagu_3` double(20,2) DEFAULT NULL,
  `pagu_4` double(20,2) DEFAULT NULL,
  `pagu_5` double(20,2) DEFAULT NULL,
  `program_lock` tinyint(4) DEFAULT NULL,
  `sasaran_lock` tinyint(4) DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `saspok_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` tinyint(4) DEFAULT NULL,
  `urut_sasaran` tinyint(4) DEFAULT NULL,
  `urut_saspok` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpd_tujuan_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `head_teks` text DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_tujuan` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `isu_teks` text DEFAULT NULL,
  `kebijakan_teks` text DEFAULT NULL,
  `misi_lock` tinyint(4) DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `saspok_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` tinyint(4) DEFAULT NULL,
  `urut_saspok` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `id_isu` int(11) DEFAULT NULL,
  `no_urut` int(11) NOT NULL,
  `catatan_teks_tujuan` text NOT NULL,
  `indikator_catatan_teks` text NOT NULL,
  `update_at` datetime NOT NULL,
  `active` tinyint(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpd_sasaran_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `head_teks` text DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_sasaran` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `isu_teks` text DEFAULT NULL,
  `kebijakan_teks` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `misi_lock` tinyint(4) DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `saspok_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` text DEFAULT NULL,
  `urut_sasaran` text DEFAULT NULL,
  `urut_saspok` text DEFAULT NULL,
  `urut_tujuan` text DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `sasaran_no_urut` int(11) NOT NULL,
  `sasaran_catatan` text NOT NULL,
  `indikator_catatan_teks` text NOT NULL,
  `update_at` datetime NOT NULL,
  `active` tinyint(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpd_program_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `head_teks` text DEFAULT NULL,
  `id_bidur_mth` int(11) DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_program_mth` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` varchar(20) DEFAULT NULL,
  `indikator` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `isu_teks` text DEFAULT NULL,
  `kebijakan_teks` text DEFAULT NULL,
  `kode_sasaran` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `misi_lock` text DEFAULT NULL,
  `misi_teks` tinyint(4) DEFAULT NULL,
  `nama_program` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `pagu_1` double(20,2) DEFAULT NULL,
  `pagu_2` double(20,2) DEFAULT NULL,
  `pagu_3` double(20,2) DEFAULT NULL,
  `pagu_4` double(20,2) DEFAULT NULL,
  `pagu_5` double(20,2) DEFAULT NULL,
  `program_lock` tinyint(4) DEFAULT NULL,
  `sasaran_lock` tinyint(4) DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `saspok_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` tinyint(4) DEFAULT NULL,
  `urut_sasaran` tinyint(4) DEFAULT NULL,
  `urut_saspok` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `catatan` text DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `active` tinyint(4) NOT NULL,
  `id_program_lama` int(11) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpd_tujuan_history` (
  `id` int(11) NOT NULL auto_increment,
  `head_teks` text DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_tujuan` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `isu_teks` text DEFAULT NULL,
  `kebijakan_teks` text DEFAULT NULL,
  `misi_lock` tinyint(4) DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `saspok_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` tinyint(4) DEFAULT NULL,
  `urut_saspok` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpd_sasaran_history` (
  `id` int(11) NOT NULL auto_increment,
  `head_teks` text DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_sasaran` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `isu_teks` text DEFAULT NULL,
  `kebijakan_teks` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `misi_lock` tinyint(4) DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `saspok_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` text DEFAULT NULL,
  `urut_sasaran` text DEFAULT NULL,
  `urut_saspok` text DEFAULT NULL,
  `urut_tujuan` text DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpd_program_history` (
  `id` int(11) NOT NULL auto_increment,
  `head_teks` text DEFAULT NULL,
  `id_bidur_mth` int(11) DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_program_mth` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` varchar(20) DEFAULT NULL,
  `indikator` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `isu_teks` text DEFAULT NULL,
  `kebijakan_teks` text DEFAULT NULL,
  `kode_sasaran` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `misi_lock` text DEFAULT NULL,
  `misi_teks` tinyint(4) DEFAULT NULL,
  `nama_program` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `pagu_1` double(20,2) DEFAULT NULL,
  `pagu_2` double(20,2) DEFAULT NULL,
  `pagu_3` double(20,2) DEFAULT NULL,
  `pagu_4` double(20,2) DEFAULT NULL,
  `pagu_5` double(20,2) DEFAULT NULL,
  `program_lock` tinyint(4) DEFAULT NULL,
  `sasaran_lock` tinyint(4) DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `saspok_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` tinyint(4) DEFAULT NULL,
  `urut_sasaran` tinyint(4) DEFAULT NULL,
  `urut_saspok` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpd_tujuan_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `head_teks` text DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_tujuan` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `isu_teks` text DEFAULT NULL,
  `kebijakan_teks` text DEFAULT NULL,
  `misi_lock` tinyint(4) DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `saspok_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` tinyint(4) DEFAULT NULL,
  `urut_saspok` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `id_isu` int(11) DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `no_urut` int(11) NOT NULL,
  `catatan_teks_tujuan` text NOT NULL,
  `indikator_catatan_teks` text NOT NULL,
  `active` tinyint(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpd_sasaran_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `head_teks` text DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_sasaran` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `indikator_teks` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `isu_teks` text DEFAULT NULL,
  `kebijakan_teks` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `misi_lock` tinyint(4) DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `saspok_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` text DEFAULT NULL,
  `urut_sasaran` text DEFAULT NULL,
  `urut_saspok` text DEFAULT NULL,
  `urut_tujuan` text DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `sasaran_no_urut` int(11) NOT NULL,
  `sasaran_catatan` text NOT NULL,
  `indikator_catatan_teks` text NOT NULL,
  `active` tinyint(4) NOT NULL,
  `id_program_lama` int(11) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpd_program_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `head_teks` text DEFAULT NULL,
  `id_bidur_mth` int(11) DEFAULT NULL,
  `id_misi_old` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_program_mth` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` varchar(20) DEFAULT NULL,
  `indikator` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `isu_teks` text DEFAULT NULL,
  `kebijakan_teks` text DEFAULT NULL,
  `kode_sasaran` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `misi_lock` text DEFAULT NULL,
  `misi_teks` tinyint(4) DEFAULT NULL,
  `nama_program` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `pagu_1` double(20,2) DEFAULT NULL,
  `pagu_2` double(20,2) DEFAULT NULL,
  `pagu_3` double(20,2) DEFAULT NULL,
  `pagu_4` double(20,2) DEFAULT NULL,
  `pagu_5` double(20,2) DEFAULT NULL,
  `program_lock` tinyint(4) DEFAULT NULL,
  `sasaran_lock` tinyint(4) DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `saspok_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_misi` tinyint(4) DEFAULT NULL,
  `urut_sasaran` tinyint(4) DEFAULT NULL,
  `urut_saspok` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `visi_teks` text DEFAULT NULL,
  `catatan` text DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `active` tinyint(4) NOT NULL,
  `id_program_lama` int(11) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjpd_visi` (
  `id` int(11) NOT NULL auto_increment,
  `visi_teks` text DEFAULT NULL,
  `update_at` datetime NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjpd_misi` (
  `id` int(11) NOT NULL auto_increment,
  `id_visi` int(11) DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `urut_misi` tinyint(4) DEFAULT NULL,
  `update_at` datetime NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjpd_sasaran` (
  `id` int(11) NOT NULL auto_increment,
  `id_misi` int(11) DEFAULT NULL,
  `saspok_teks` text DEFAULT NULL,
  `urut_saspok` tinyint(4) DEFAULT NULL,
  `update_at` datetime NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjpd_kebijakan` (
  `id` int(11) NOT NULL auto_increment,
  `id_saspok` int(11) DEFAULT NULL,
  `kebijakan_teks` text DEFAULT NULL,
  `urut_kebijakan` tinyint(4) DEFAULT NULL,
  `update_at` datetime NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjpd_isu` (
  `id` int(11) NOT NULL auto_increment,
  `id_kebijakan` int(11) DEFAULT NULL,
  `isu_teks` text DEFAULT NULL,
  `urut_isu` tinyint(4) DEFAULT NULL,
  `update_at` datetime NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjpd_visi_history` (
  `id` int(11) NOT NULL auto_increment,
  `visi_teks` text DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjpd_misi_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_visi` int(11) DEFAULT NULL,
  `misi_teks` text DEFAULT NULL,
  `urut_misi` tinyint(4) DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjpd_sasaran_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_misi` int(11) DEFAULT NULL,
  `saspok_teks` text DEFAULT NULL,
  `urut_saspok` tinyint(4) DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjpd_kebijakan_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_saspok` int(11) DEFAULT NULL,
  `kebijakan_teks` text DEFAULT NULL,
  `urut_kebijakan` tinyint(4) DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rpjpd_isu_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_kebijakan` int(11) DEFAULT NULL,
  `isu_teks` text DEFAULT NULL,
  `urut_isu` tinyint(4) DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_pendapatan_history` (
  `id` int(11) NOT NULL auto_increment,
  `created_user` int(11) DEFAULT NULL,
  `createddate` varchar(50) DEFAULT NULL,
  `createdtime` varchar(50) DEFAULT NULL,
  `id_pendapatan` int(11) DEFAULT NULL,
  `keterangan` text,
  `kode_akun` varchar(50) DEFAULT NULL,
  `nama_akun` text,
  `nilaimurni` double DEFAULT NULL,
  `program_koordinator` int(11) DEFAULT NULL,
  `rekening` text,
  `skpd_koordinator` int(11) DEFAULT NULL,
  `total` double DEFAULT NULL,
  `pagu_fmis` double(20,2) DEFAULT NULL,
  `updated_user` int(11) DEFAULT NULL,
  `updateddate` varchar(50) DEFAULT NULL,
  `updatedtime` varchar(50) DEFAULT NULL,
  `uraian` text,
  `urusan_koordinator` int(11) DEFAULT NULL,
  `user1` text DEFAULT NULL,
  `user2` text DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_pembiayaan_history` (
  `id` int(11) NOT NULL auto_increment,
  `created_user` int(11) DEFAULT NULL,
  `createddate` varchar(50) DEFAULT NULL,
  `createdtime` varchar(50) DEFAULT NULL,
  `id_pembiayaan` int(11) DEFAULT NULL,
  `keterangan` text DEFAULT NULL,
  `kode_akun` varchar(50) DEFAULT NULL,
  `nama_akun` text,
  `nilaimurni` double DEFAULT NULL,
  `program_koordinator` int(11) DEFAULT NULL,
  `rekening` text,
  `skpd_koordinator` int(11) DEFAULT NULL,
  `total` double DEFAULT NULL,
  `pagu_fmis` double(20,2) DEFAULT NULL,
  `updated_user` int(11) DEFAULT NULL,
  `updateddate` varchar(50) DEFAULT NULL,
  `updatedtime` varchar(50) DEFAULT NULL,
  `uraian` text,
  `urusan_koordinator` int(11) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `user1`text DEFAULT NULL,
  `user2`text DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);
CREATE TABLE `data_realisasi_akun_sipd` (
  `id` int(11) NOT NULL auto_increment,
  `id_unit` int(11) DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `id_sub_skpd` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_giat` int(11) DEFAULT NULL,
  `id_sub_giat` int(11) DEFAULT NULL,
  `id_daerah` int(11) DEFAULT NULL,
  `lokus_akun_teks` text DEFAULT NULL,
  `id_akun` int(11) DEFAULT NULL,
  `kode_akun` text DEFAULT NULL,
  `nama_akun` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `nilai` double(20,2) DEFAULT NULL,
  `action` int(11) DEFAULT NULL,
  `realisasi` double(20,2) DEFAULT NULL,
  `kode_sbl` varchar(50) NOT NULL,
  `tahun` year(4) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `type` varchar(50) NOT NULL,
  `updated_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_sirup_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `idSirup` int(11) NOT NULL,
  `idBulan` int(11) NOT NULL,
  `idJenisPengadaan` int(11) NOT NULL,
  `idKldi` tinytext NOT NULL,
  `idMetode` int(11) NOT NULL,
  `id_referensi` int(11) NOT NULL,
  `idlokasi` int(11) NOT NULL,
  `isPDN` tinytext NOT NULL,
  `isUMK` tinytext NOT NULL,
  `jenisPengadaan` varchar(250) NOT NULL,
  `kldi` varchar(250) NOT NULL,
  `lokasi` varchar(250) NOT NULL,
  `metode` varchar(250) NOT NULL,
  `pagu` double(20,2) NOT NULL,
  `paket` text NOT NULL,
  `pemilihan` varchar(250) NOT NULL,
  `satuanKerja` varchar(250) NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `active` tinyint(4) DEFAULT NULL,
  `update_at` datetime DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_skpd_sirup` (
  `id` int(11) NOT NULL,
  `id_satuan_kerja` int(11) NOT NULL,
  `satuan_kerja` varchar(250) NOT NULL,
  `paket_penyedia` int(11) NOT NULL,
  `pagu_penyedia` int(11) NOT NULL,
  `paket_swakelola` int(11) NOT NULL,
  `pagu_swakelola` int(11) NOT NULL,
  `paket_pd_swakelola` int(11) NOT NULL,
  `pagu_pd_swakelola` int(11) NOT NULL,
  `total_paket` int(11) NOT NULL,
  `total_pagu` int(11) NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_master_indikator_subgiat` (
  `id` int(11) NOT NULL auto_increment,
  `id_skpd` int(11) NOT NULL,
  `id_sub_keg` int(11) NOT NULL,
  `indikator` text NOT NULL,
  `satuan` text NOT NULL,
  `active` tinyint(4) NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_prioritas_pusat` (
  `id` int(11) NOT NULL auto_increment,
  `id_prioritas` int(11) DEFAULT NULL,
  `teks_prioritas` text DEFAULT NULL,
  `active` tinyint(4) DEFAULT NULL,
  `id_label_pusat` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `is_locked` int(11) DEFAULT NULL, 
  `set_urut` int(11) DEFAULT NULL, 
  `tahun_awal` year(4) DEFAULT NULL,
  `tahun_akhir` year(4) DEFAULT NULL,
  `nama_label` text DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `update_at` datetime NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_prioritas_prov` (
  `id` int(11) NOT NULL auto_increment,
  `id_prioritas` int(11) DEFAULT NULL,
  `teks_prioritas` text DEFAULT NULL,
  `active` tinyint(4) DEFAULT NULL,
  `id_label_prov` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `is_locked` int(11) DEFAULT NULL,
  `nama_label` text DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `update_at` datetime NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_prioritas_kokab` (
  `id` int(11) NOT NULL auto_increment,
  `id_prioritas` int(11) DEFAULT NULL,
  `teks_prioritas` text DEFAULT NULL,
  `id_label_kokab` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `is_locked` int(11) DEFAULT NULL,
  `nama_label` text DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `active` tinyint(4) DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `update_at` datetime NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_label_giat` (
  `id` int(11) NOT NULL auto_increment,  
  `id_label_giat` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `is_locked` int(11) DEFAULT NULL,
  `nama_label` text DEFAULT NULL,
  `status` text(11) DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `active` tinyint(4) DEFAULT NULL,
  `update_at` datetime NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_renstra_sub_kegiatan` (
  `id` int(11) NOT NULL auto_increment,
  `id_jadwal` int(11) NOT NULL,
  `bidur_lock` tinyint(4) DEFAULT NULL,
  `giat_lock` tinyint(4) DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_sub_giat` int(11) DEFAULT NULL,
  `id_giat` int(11) DEFAULT NULL,
  `id_misi` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `id_sub_unit` int(11) DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `id_indikator` text DEFAULT NULL,
  `indikator` text DEFAULT NULL,
  `id_indikator_usulan` text DEFAULT NULL,
  `indikator_usulan` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_bidang_urusan` text DEFAULT NULL,
  `kode_sub_giat` text DEFAULT NULL,
  `kode_giat` text DEFAULT NULL,
  `kode_kegiatan` text DEFAULT NULL,
  `kode_program` text DEFAULT NULL,
  `kode_sasaran` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `kode_unik_program` text DEFAULT NULL,
  `nama_bidang_urusan` text DEFAULT NULL,
  `nama_sub_giat` text DEFAULT NULL,
  `nama_giat` text DEFAULT NULL,
  `nama_program` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `nama_sub_unit` text DEFAULT NULL,
  `pagu_1` double(20,2) DEFAULT NULL,
  `pagu_2` double(20,2) DEFAULT NULL,
  `pagu_3` double(20,2) DEFAULT NULL,
  `pagu_4` double(20,2) DEFAULT NULL,
  `pagu_5` double(20,2) DEFAULT NULL,
  `realisasi_pagu_1` double(20,2) DEFAULT NULL,
  `realisasi_pagu_2` double(20,2) DEFAULT NULL,
  `realisasi_pagu_3` double(20,2) DEFAULT NULL,
  `realisasi_pagu_4` double(20,2) DEFAULT NULL,
  `realisasi_pagu_5` double(20,2) DEFAULT NULL,
  `program_lock` tinyint(4) DEFAULT NULL,
  `renstra_prog_lock` tinyint(4) DEFAULT NULL,
  `sasaran_lock` tinyint(4) DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `realisasi_target_1` text DEFAULT NULL,
  `realisasi_target_2` text DEFAULT NULL,
  `realisasi_target_3` text DEFAULT NULL,
  `realisasi_target_4` text DEFAULT NULL,
  `realisasi_target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `catatan` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_sasaran` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_sub_giat_lama` text DEFAULT NULL,
  `keterangan_1` text DEFAULT NULL,
  `keterangan_2` text DEFAULT NULL,
  `keterangan_3` text DEFAULT NULL,
  `keterangan_4` text DEFAULT NULL,
  `keterangan_5` text DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_renstra_sub_kegiatan_history` (
  `id` int(11) NOT NULL auto_increment,
  `bidur_lock` tinyint(4) DEFAULT NULL,
  `giat_lock` tinyint(4) DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_sub_giat` int(11) DEFAULT NULL,
  `id_giat` int(11) DEFAULT NULL,
  `id_misi` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `id_sub_unit` int(11) DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `id_indikator` text DEFAULT NULL,
  `indikator` text DEFAULT NULL,
  `id_indikator_usulan` text DEFAULT NULL,
  `indikator_usulan` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_bidang_urusan` text DEFAULT NULL,
  `kode_sub_giat` text DEFAULT NULL,
  `kode_giat` text DEFAULT NULL,
  `kode_kegiatan` text DEFAULT NULL,
  `kode_program` text DEFAULT NULL,
  `kode_sasaran` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `kode_unik_program` text DEFAULT NULL,
  `nama_bidang_urusan` text DEFAULT NULL,
  `nama_sub_giat` text DEFAULT NULL,
  `nama_giat` text DEFAULT NULL,
  `nama_program` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `nama_sub_unit` text DEFAULT NULL,
  `pagu_1` double(20,2) DEFAULT NULL,
  `pagu_2` double(20,2) DEFAULT NULL,
  `pagu_3` double(20,2) DEFAULT NULL,
  `pagu_4` double(20,2) DEFAULT NULL,
  `pagu_5` double(20,2) DEFAULT NULL,
  `pagu_1_usulan` double(20,2) DEFAULT NULL,
  `pagu_2_usulan` double(20,2) DEFAULT NULL,
  `pagu_3_usulan` double(20,2) DEFAULT NULL,
  `pagu_4_usulan` double(20,2) DEFAULT NULL,
  `pagu_5_usulan` double(20,2) DEFAULT NULL,
  `program_lock` tinyint(4) DEFAULT NULL,
  `renstra_prog_lock` tinyint(4) DEFAULT NULL,
  `sasaran_lock` tinyint(4) DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `satuan_usulan` text DEFAULT NULL,
  `target_1_usulan` text DEFAULT NULL,
  `target_2_usulan` text DEFAULT NULL,
  `target_3_usulan` text DEFAULT NULL,
  `target_4_usulan` text DEFAULT NULL,
  `target_5_usulan` text DEFAULT NULL,
  `target_akhir_usulan` text DEFAULT NULL,
  `target_awal_usulan` text DEFAULT NULL,
  `catatan_usulan` text DEFAULT NULL,
  `catatan` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_sasaran` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_sub_giat_lama` text DEFAULT NULL,
  `keterangan_1` text DEFAULT NULL,
  `keterangan_2` text DEFAULT NULL,
  `keterangan_3` text DEFAULT NULL,
  `keterangan_4` text DEFAULT NULL,
  `keterangan_5` text DEFAULT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_renstra_sub_kegiatan_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `bidur_lock` tinyint(4) DEFAULT NULL,
  `giat_lock` tinyint(4) DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_sub_giat` int(11) DEFAULT NULL,
  `id_giat` int(11) DEFAULT NULL,
  `id_misi` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `id_sub_unit` int(11) DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `id_indikator` text DEFAULT NULL,
  `indikator` text DEFAULT NULL,
  `id_indikator_usulan` text DEFAULT NULL,
  `indikator_usulan` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_bidang_urusan` text DEFAULT NULL,
  `kode_sub_giat` text DEFAULT NULL,
  `kode_giat` text DEFAULT NULL,
  `kode_kegiatan` text DEFAULT NULL,
  `kode_program` text DEFAULT NULL,
  `kode_sasaran` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `kode_unik_program` text DEFAULT NULL,
  `nama_bidang_urusan` text DEFAULT NULL,
  `nama_sub_giat` text DEFAULT NULL,
  `nama_giat` text DEFAULT NULL,
  `nama_program` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `nama_sub_unit` text DEFAULT NULL,
  `pagu_1` double(20,2) DEFAULT NULL,
  `pagu_2` double(20,2) DEFAULT NULL,
  `pagu_3` double(20,2) DEFAULT NULL,
  `pagu_4` double(20,2) DEFAULT NULL,
  `pagu_5` double(20,2) DEFAULT NULL,
  `pagu_1_usulan` double(20,2) DEFAULT NULL,
  `pagu_2_usulan` double(20,2) DEFAULT NULL,
  `pagu_3_usulan` double(20,2) DEFAULT NULL,
  `pagu_4_usulan` double(20,2) DEFAULT NULL,
  `pagu_5_usulan` double(20,2) DEFAULT NULL,
  `program_lock` tinyint(4) DEFAULT NULL,
  `renstra_prog_lock` tinyint(4) DEFAULT NULL,
  `sasaran_lock` tinyint(4) DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `satuan_usulan` text DEFAULT NULL,
  `target_1_usulan` text DEFAULT NULL,
  `target_2_usulan` text DEFAULT NULL,
  `target_3_usulan` text DEFAULT NULL,
  `target_4_usulan` text DEFAULT NULL,
  `target_5_usulan` text DEFAULT NULL,
  `target_akhir_usulan` text DEFAULT NULL,
  `target_awal_usulan` text DEFAULT NULL,
  `catatan_usulan` text DEFAULT NULL,
  `catatan` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_sasaran` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_sub_giat_lama` text DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_renstra_sub_kegiatan_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `bidur_lock` tinyint(4) DEFAULT NULL,
  `giat_lock` tinyint(4) DEFAULT NULL,
  `id_bidang_urusan` int(11) DEFAULT NULL,
  `id_sub_giat` int(11) DEFAULT NULL,
  `id_giat` int(11) DEFAULT NULL,
  `id_misi` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_unik` text DEFAULT NULL,
  `id_unik_indikator` text DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `id_sub_unit` int(11) DEFAULT NULL,
  `id_visi` int(11) DEFAULT NULL,
  `id_indikator` text DEFAULT NULL,
  `indikator` text DEFAULT NULL,
  `id_indikator_usulan` text DEFAULT NULL,
  `indikator_usulan` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `is_locked_indikator` tinyint(4) DEFAULT NULL,
  `kode_bidang_urusan` text DEFAULT NULL,
  `kode_sub_giat` text DEFAULT NULL,
  `kode_giat` text DEFAULT NULL,
  `kode_kegiatan` text DEFAULT NULL,
  `kode_program` text DEFAULT NULL,
  `kode_sasaran` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_tujuan` text DEFAULT NULL,
  `kode_unik_program` text DEFAULT NULL,
  `nama_bidang_urusan` text DEFAULT NULL,
  `nama_sub_giat` text DEFAULT NULL,
  `nama_giat` text DEFAULT NULL,
  `nama_program` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `nama_sub_unit` text DEFAULT NULL,
  `pagu_1` double(20,2) DEFAULT NULL,
  `pagu_2` double(20,2) DEFAULT NULL,
  `pagu_3` double(20,2) DEFAULT NULL,
  `pagu_4` double(20,2) DEFAULT NULL,
  `pagu_5` double(20,2) DEFAULT NULL,
  `pagu_1_usulan` double(20,2) DEFAULT NULL,
  `pagu_2_usulan` double(20,2) DEFAULT NULL,
  `pagu_3_usulan` double(20,2) DEFAULT NULL,
  `pagu_4_usulan` double(20,2) DEFAULT NULL,
  `pagu_5_usulan` double(20,2) DEFAULT NULL,
  `program_lock` tinyint(4) DEFAULT NULL,
  `renstra_prog_lock` tinyint(4) DEFAULT NULL,
  `sasaran_lock` tinyint(4) DEFAULT NULL,
  `sasaran_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `target_1` text DEFAULT NULL,
  `target_2` text DEFAULT NULL,
  `target_3` text DEFAULT NULL,
  `target_4` text DEFAULT NULL,
  `target_5` text DEFAULT NULL,
  `target_akhir` text DEFAULT NULL,
  `target_awal` text DEFAULT NULL,
  `satuan_usulan` text DEFAULT NULL,
  `target_1_usulan` text DEFAULT NULL,
  `target_2_usulan` text DEFAULT NULL,
  `target_3_usulan` text DEFAULT NULL,
  `target_4_usulan` text DEFAULT NULL,
  `target_5_usulan` text DEFAULT NULL,
  `target_akhir_usulan` text DEFAULT NULL,
  `target_awal_usulan` text DEFAULT NULL,
  `catatan_usulan` text DEFAULT NULL,
  `catatan` text DEFAULT NULL,
  `tujuan_lock` tinyint(4) DEFAULT NULL,
  `tujuan_teks` text DEFAULT NULL,
  `urut_sasaran` tinyint(4) DEFAULT NULL,
  `urut_tujuan` tinyint(4) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `id_sub_giat_lama` text DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_kamus_usulan_pokir` (
  `id` int(11) NOT NULL auto_increment,
  `anggaran` text DEFAULT NULL,
  `bidang_urusan` text DEFAULT NULL,
  `giat_teks` text DEFAULT NULL,
  `id_kamus` int(11) DEFAULT NULL,
  `id_program` int(11) DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `idbidangurusan` int(11) DEFAULT NULL,
  `idskpd` int(11) DEFAULT NULL,
  `kodeprogram` text DEFAULT NULL,
  `namaprogram` text DEFAULT NULL,
  `jenis_profil` text DEFAULT NULL,
  `kelompok` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `outcome_teks` text DEFAULT NULL,
  `output_teks` text DEFAULT NULL,
  `pekerjaan` text DEFAULT NULL,
  `prioritas_teks` text DEFAULT NULL,
  `satuan` text DEFAULT NULL,
  `tipe` text DEFAULT NULL,
  `id_jenis_usul` int(11) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_file` (
  `id` int(11) NOT NULL auto_increment,
  `nama` text DEFAULT NULL,
  `url_asli` text DEFAULT NULL,
  `path` text DEFAULT NULL,
  `tipe_file` text DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_sp2d_fmis` (
  `id` int(11) NOT NULL auto_increment,
  `DT_RowIndex` text DEFAULT NULL,
  `created_at` text DEFAULT NULL,
  `url_sp2d` text DEFAULT NULL,
  `nama_file` text DEFAULT NULL,
  `created_id` int(11) DEFAULT NULL,
  `idkdbank` int(11) DEFAULT NULL,
  `idsp2d` int(11) DEFAULT NULL,
  `idspm` int(11) DEFAULT NULL,
  `idsubunit` int(11) DEFAULT NULL,
  `info` text DEFAULT NULL,
  `keterangan` text DEFAULT NULL,
  `no_bku` int(11) DEFAULT NULL,
  `no_transaksi` text DEFAULT NULL,
  `npwp_bud` text DEFAULT NULL,
  `penandatangan_jbt` text DEFAULT NULL,
  `penandatangan_nip` text DEFAULT NULL,
  `penandatangan_nm` text DEFAULT NULL,
  `sp2d_no` text DEFAULT NULL,
  `sp2d_tgl` date DEFAULT NULL,
  `status` text DEFAULT NULL,
  `status_tte` text DEFAULT NULL,
  `tahun` year(4) DEFAULT NULL,
  `updated_at` text DEFAULT NULL,
  `updated_id` text DEFAULT NULL,
  `tahun_anggaran` year(4) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_sp2d_sipd` (
  `id` int(11) NOT NULL auto_increment,
  `idSpm` int(11) DEFAULT NULL,
  `nomorSp2d` varchar(80) DEFAULT NULL,
  `tanggalSp2d` date DEFAULT NULL,
  `tahun_anggaran` year(4) DEFAULT NULL,
  `idSubUnit` int(11) DEFAULT NULL,
  `keteranganSp2d` varchar(500) DEFAULT NULL,
  `jenisSp2d` varchar(5) DEFAULT NULL,
  `nilaiSp2d` double DEFAULT NULL,
  `jenisLs` varchar(20) DEFAULT NULL,
  `isPergeseran` bit(1) DEFAULT NULL,
  `isPelimpahan` bit(1) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `isTbpLs` bit(1) DEFAULT NULL,
  `idSkpd` int(11) DEFAULT NULL,
  `isDraft` bit(1) DEFAULT NULL,
  `idSp2d` int(11) DEFAULT NULL,
  `verifikasiSp2d` bit(1) DEFAULT NULL,
  `tanggalVerifikasi` date DEFAULT NULL,
  `idSkpdTujuan` int(11) DEFAULT NULL,
  `kunciRekening` bit(1) DEFAULT NULL,
  `isBku` bit(1) DEFAULT NULL,
  `bulan_gaji` int(11) DEFAULT NULL,
  `tahun_gaji` year(4) DEFAULT NULL,
  `jenis_gaji` tinyint(4) DEFAULT NULL,
  `is_bku_skpd` bit(1) DEFAULT NULL,
  `id_jadwal` int(11) DEFAULT NULL,
  `id_tahap` int(11) DEFAULT NULL,
  `status_tahap` varchar(20) DEFAULT NULL,
  `kode_tahap` varchar(10) DEFAULT NULL,
  `status_aklap` tinyint(4) DEFAULT NULL,
  `nomor_jurnal` varchar(50) DEFAULT NULL,
  `jurnal_id` int(11) DEFAULT NULL,
  `metode` varchar(30) DEFAULT NULL,
  `bulan_tpp` tinyint(4) DEFAULT NULL,
  `tahun_tpp` year(4) DEFAULT NULL,
  `nomor_rekening_pembayar` varchar(30) DEFAULT NULL,
  `bank_rekening_pembayar` varchar(40) DEFAULT NULL,
  `is_rekening_pembayar` bit(1) DEFAULT NULL,
  `nomorSpm` varchar(80) DEFAULT NULL,
  `tanggalSpm` date DEFAULT NULL,
  `tahunSpm` year(4) DEFAULT NULL,
  `keteranganSpm` varchar(500) DEFAULT NULL,
  `verifikasiSpm` tinyint(4) DEFAULT NULL,
  `tanggalVerifikasiSpm` date DEFAULT NULL,
  `jenisSpm` varchar(5) DEFAULT NULL,
  `nilaiSpm` double DEFAULT NULL,
  `keteranganVerifikasiSpm` varchar(500) DEFAULT NULL,
  `isOtorisasi` bit(1) DEFAULT NULL,
  `tanggalOtorisasi` date DEFAULT NULL,
  `is_sptjm` bit(1) DEFAULT NULL,
  `namaSkpd` varchar(200) DEFAULT NULL,
  `kodeSkpd` varchar(50) DEFAULT NULL,
  `is_bpk` bit(1) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_sp2d_sipd_detail` (
  `id` int(11) NOT NULL auto_increment,
  `id_sp_2_d` int(11) DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `jumlah` double(20,2) DEFAULT NULL,
  `kode_rekening` text DEFAULT NULL,
  `total_anggaran` double(20,2) DEFAULT NULL,
  `uraian` text DEFAULT NULL,
  `bank_pihak_ketiga` text DEFAULT NULL,
  `jabatan_bud_kbud` text DEFAULT NULL,
  `keterangan_sp2d` text DEFAULT NULL,
  `nama_bank` text DEFAULT NULL,
  `nama_bud_kbud` text DEFAULT NULL,
  `nama_daerah` text DEFAULT NULL,
  `nama_ibukota` text DEFAULT NULL,
  `nama_pihak_ketiga` text DEFAULT NULL,
  `nama_rek_pihak_ketiga` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `nama_sub_skpd` text DEFAULT NULL,
  `nilai_sp2d` double(20,2) DEFAULT NULL,
  `nip_bud_kbud` text DEFAULT NULL,
  `no_rek_pihak_ketiga` text DEFAULT NULL,
  `nomor_rekening` text DEFAULT NULL,
  `nomor_sp_2_d` text DEFAULT NULL,
  `nomor_spm` text DEFAULT NULL,
  `npwp_pihak_ketiga` text DEFAULT NULL,
  `tahun` year(4) DEFAULT NULL,
  `tanggal_sp_2_d` datetime DEFAULT NULL,
  `tanggal_spm` datetime DEFAULT NULL,
  `tipe` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime DEFAULT NULL,
  `tahun_anggaran` year(4) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_sp2d_sipd_detail_potongan` (
  `id` int(11) NOT NULL auto_increment,
  `id_sp_2_d`  int(11) DEFAULT NULL,
  `id_skpd`  int(11) DEFAULT NULL,
  `id_billing`  int(11) DEFAULT NULL,
  `id_pajak_potongan`  int(11) DEFAULT NULL,
  `nama_pajak_potongan` text DEFAULT NULL,
  `[REDACTED]` double(20,2) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime DEFAULT NULL,
  `tahun_anggaran` year(4) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_sp2d_sipd_ri` (
  `id` int(11) NOT NULL auto_increment,
  `bulan_gaji` int(11) DEFAULT NULL,
  `bulan_tpp` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by` text DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` text DEFAULT NULL,
  `id_bank` int(11) DEFAULT NULL,
  `id_daerah` int(11) DEFAULT NULL,
  `id_jadwal` int(11) DEFAULT NULL,
  `id_pegawai_bud_kbud` int(11) DEFAULT NULL,
  `id_rkud` int(11) DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `id_sp_2_d` int(11) DEFAULT NULL,
  `id_spm` int(11) DEFAULT NULL,
  `id_sub_skpd` int(11) DEFAULT NULL,
  `id_sumber_dana` int(11) DEFAULT NULL,
  `id_tahap` int(11) DEFAULT NULL,
  `id_unit` int(11) DEFAULT NULL,
  `is_gaji` int(11) DEFAULT NULL,
  `[REDACTED]` int(11) DEFAULT NULL,
  `is_pelimpahan` int(11) DEFAULT NULL,
  `is_status_perubahan` int(11) DEFAULT NULL,
  `is_tpp` int(11) DEFAULT NULL,
  `is_transfer_sp_2_d` int(11) DEFAULT NULL,
  `[REDACTED]` int(11) DEFAULT NULL,
  `jenis_gaji` int(11) DEFAULT NULL,
  `jenis_ls_sp_2_d` text DEFAULT NULL,
  `jenis_rkud` text DEFAULT NULL,
  `jenis_sp_2_d` text DEFAULT NULL,
  `jurnal_id` int(11) DEFAULT NULL,
  `[REDACTED]` text DEFAULT NULL,
  `keterangan_transfer_sp_2_d` text DEFAULT NULL,
  `[REDACTED]` text DEFAULT NULL,
  `kode_skpd` text DEFAULT NULL,
  `kode_sub_skpd` text DEFAULT NULL,
  `kode_tahap` text DEFAULT NULL,
  `metode` text DEFAULT NULL,
  `nama_bank` text DEFAULT NULL,
  `nama_bud_kbud` text DEFAULT NULL,
  `nama_rek_bp_bpp` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `nama_sub_skpd` text DEFAULT NULL,
  `[REDACTED]` double DEFAULT NULL,
  `nilai_sp_2_d` double DEFAULT NULL,
  `nip_bud_kbud` text DEFAULT NULL,
  `no_rek_bp_bpp` text DEFAULT NULL,
  `nomor_jurnal` text DEFAULT NULL,
  `nomor_sp_2_d` text DEFAULT NULL,
  `nomor_spm` text DEFAULT NULL,
  `status_aklap` text DEFAULT NULL,
  `status_perubahan_at` datetime DEFAULT NULL,
  `status_perubahan_by` int(11) DEFAULT NULL,
  `status_tahap` text DEFAULT NULL,
  `tahun` int(11) DEFAULT NULL,
  `tahun_gaji` int(11) DEFAULT NULL,
  `tahun_tpp` int(11) DEFAULT NULL,
  `tanggal_sp_2_d` datetime DEFAULT NULL,
  `tanggal_spm` datetime DEFAULT NULL,
  `transfer_sp_2_d_at` text DEFAULT NULL,
  `transfer_sp_2_d_by` text DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by` text DEFAULT NULL,
  `[REDACTED]` datetime DEFAULT NULL,
  `[REDACTED]` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `tahun_anggaran` year(4) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_sp2d_sipd_detail_ri` (
   `id` int(11) NOT NULL auto_increment,
   `id_skpd` int(11) DEFAULT NULL,
   `id_sp_2_d` int(11) DEFAULT NULL,
);

CREATE TABLE `data_spm_sipd` (
  `id` int(11) NOT NULL auto_increment,
  `idSpm` int(11) DEFAULT NULL,
  `idSpp` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `idDetailSpm` int(11) DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `id_jadwal` int(11) DEFAULT NULL,
  `id_tahap` int(11) DEFAULT NULL,
  `status_tahap` varchar(15) DEFAULT NULL,
  `nomorSpp` varchar(80) DEFAULT NULL,
  `nilaiSpp` double DEFAULT NULL,
  `tanggalSpp` date DEFAULT NULL,
  `keteranganSpp` varchar(500) DEFAULT NULL,
  `idSkpd` int(11) DEFAULT NULL,
  `idSubUnit` int(11) DEFAULT NULL,
  `nilaiDisetujuiSpp` double DEFAULT NULL,
  `tanggalDisetujuiSpp` date DEFAULT NULL,
  `jenisSpp` int(11) DEFAULT NULL,
  `verifikasiSpp` varchar(10) DEFAULT NULL,
  `keteranganVerifikasi` varchar(500) DEFAULT NULL,
  `idSpd` int(11) DEFAULT NULL,
  `idPengesahanSpj` int(11) DEFAULT NULL,
  `kunciRekening` bit(1) DEFAULT NULL,
  `alamatPenerimaSpp` varchar(100) DEFAULT NULL,
  `bankPenerimaSpp` varchar(100) DEFAULT NULL,
  `nomorRekeningPenerimaSpp` varchar(35) DEFAULT NULL,
  `npwpPenerimaSpp` varchar(35) DEFAULT NULL,
  `jenisLs` varchar(15) DEFAULT NULL,
  `isUploaded` bit(1) DEFAULT NULL,
  `tahunSpp` year(4) DEFAULT NULL,
  `idKontrak` int(11) DEFAULT NULL,
  `idBA` int(11) DEFAULT NULL,
  `isSpm` bit(1) DEFAULT NULL,
  `statusPerubahan` bit(1) DEFAULT NULL,
  `isDraft` bit(1) DEFAULT NULL,
  `isGaji` bit(1) DEFAULT NULL,
  `is_sptjm` bit(1) DEFAULT NULL,
  `tanggal_otorisasi` date DEFAULT NULL,
  `is_otorisasi` bit(1) DEFAULT NULL,
  `bulan_gaji` tinyint(4) DEFAULT NULL,
  `id_pegawai_pptk` int(11) DEFAULT NULL,
  `nama_pegawai_pptk` varchar(50) DEFAULT NULL,
  `nip_pegawai_pptk` varchar(30) DEFAULT NULL,
  `kode_tahap` varchar(5) DEFAULT NULL,
  `is_tpp` bit(1) DEFAULT NULL,
  `bulan_tpp` tinyint(1) DEFAULT NULL,
  `id_pengajuan_tu` int(11) DEFAULT NULL,
  `nomor_pengajuan_tu` varchar(80) DEFAULT NULL,
  `nomorSpm` varchar(80) DEFAULT NULL,
  `tanggalSpm` date DEFAULT NULL,
  `keteranganSpm` varchar(500) DEFAULT NULL,
  `verifikasiSpm` bit(1) DEFAULT NULL,
  `tanggalVerifikasiSpm` date DEFAULT NULL,
  `jenisSpm` varchar(5) DEFAULT NULL,
  `nilaiSpm` double DEFAULT NULL,
  `keteranganVerifikasiSpm` varchar(500) DEFAULT NULL,
  `isOtorisasi` bit(1) DEFAULT NULL,
  `tanggalOtorisasi` date DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime DEFAULT NULL,
  `tahun_anggaran` year(4) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_dana_sub_keg_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `namadana` text DEFAULT NULL,
  `kodedana` varchar(50) DEFAULT NULL,
  `iddana` int(11) DEFAULT NULL,
  `iddanasubbl` int(11) DEFAULT NULL,
  `pagudana` double(20,2) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `active` tinyint(4) DEFAULT 1,
  `is_locked` tinyint(4) DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `nama_dana_usulan` text DEFAULT NULL,
  `kode_dana_usulan` varchar(50) DEFAULT NULL,
  `id_dana_usulan` int(11) DEFAULT NULL,
  `pagu_dana_usulan` double(20,2) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_dana_sub_keg_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `namadana` text,
  `kodedana` varchar(50) DEFAULT NULL,
  `iddana` int(11) DEFAULT NULL,
  `iddanasubbl` int(11) DEFAULT NULL,
  `pagudana` double(20,2) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `active` tinyint(4) DEFAULT '1',
  `is_locked` tinyint(4) DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `nama_dana_usulan` text DEFAULT NULL,
  `kode_dana_usulan` varchar(50) DEFAULT NULL,
  `id_dana_usulan` int(11) DEFAULT NULL,
  `pagu_dana_usulan` double(20,2) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rka_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `created_user` int(11) DEFAULT NULL,
  `createddate` varchar(10) DEFAULT NULL,
  `createdtime` varchar(10) DEFAULT NULL,
  `harga_satuan` double(20,2) DEFAULT NULL,
  `harga_satuan_murni` double(20,2) DEFAULT NULL,
  `id_daerah` int(11) DEFAULT NULL,
  `id_rinci_sub_bl` int(11) DEFAULT NULL,
  `id_standar_nfs` tinyint(4) DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `jenis_bl` varchar(50) DEFAULT NULL,
  `ket_bl_teks` text DEFAULT NULL,
  `substeks` TEXT DEFAULT NULL,
  `id_dana` int(11) DEFAULT NULL,
  `nama_dana` TEXT DEFAULT NULL,
  `is_paket` tinyint(4) DEFAULT NULL,
  `kode_dana` varchar(30) DEFAULT NULL,
  `subtitle_teks` TEXT DEFAULT NULL,
  `kode_akun` varchar(50) DEFAULT NULL,
  `koefisien` text DEFAULT NULL,
  `koefisien_murni` text DEFAULT NULL,
  `lokus_akun_teks` text DEFAULT NULL,
  `nama_akun` text DEFAULT NULL,
  `nama_komponen` text DEFAULT NULL,
  `spek_komponen` text DEFAULT NULL,
  `satuan` varchar(150) DEFAULT NULL,
  `spek` text DEFAULT NULL,
  `sat1` text DEFAULT NULL,
  `sat2` text DEFAULT NULL,
  `sat3` text DEFAULT NULL,
  `sat4` text DEFAULT NULL,
  `volum1` text DEFAULT NULL,
  `volum2` text DEFAULT NULL,
  `volum3` text DEFAULT NULL,
  `volum4` text DEFAULT NULL,
  `volume` text DEFAULT NULL,
  `volume_murni` text DEFAULT NULL,
  `subs_bl_teks` text DEFAULT NULL,
  `total_harga` double(20,2) DEFAULT NULL,
  `rincian` double(20,2) DEFAULT NULL,
  `rincian_murni` double(20,2) DEFAULT NULL,
  `totalpajak` double(20,2) DEFAULT NULL,
  `pajak` double(20,2) DEFAULT NULL,
  `pajak_murni` double(20,2) DEFAULT NULL,
  `updated_user` int(11) DEFAULT NULL,
  `updateddate` varchar(20) DEFAULT NULL,
  `updatedtime` varchar(20) DEFAULT NULL,
  `user1` text DEFAULT NULL,
  `user2` text DEFAULT NULL,
  `active` tinyint(4) DEFAULT 1,
  `akun_locked` tinyint(4) DEFAULT NULL,
  `ssh_locked` tinyint(4) DEFAULT NULL,
  `update_at` datetime DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL DEFAULT '2021',
  `idbl` int(11) DEFAULT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `kode_bl` varchar(50) NOT NULL,
  `kode_sbl` varchar(50) NOT NULL,
  `id_prop_penerima` int(11) DEFAULT NULL,
  `id_camat_penerima` int(11) DEFAULT NULL,
  `id_kokab_penerima` int(11) DEFAULT NULL,
  `id_lurah_penerima` int(11) DEFAULT NULL,
  `id_penerima` int(11) DEFAULT NULL,
  `idkomponen` double(20,2) DEFAULT NULL,
  `idketerangan` int(11) DEFAULT NULL,
  `idsubtitle` int(11) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_rka_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `created_user` int(11) DEFAULT NULL,
  `createddate` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `createdtime` varchar(10) CHARACTER SET latin1 DEFAULT NULL,
  `harga_satuan` double(20,2) DEFAULT NULL,
  `harga_satuan_murni` double(20,2) DEFAULT NULL,
  `id_daerah` int(11) DEFAULT NULL,
  `id_rinci_sub_bl` int(11) DEFAULT NULL,
  `id_standar_nfs` tinyint(4) DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT NULL,
  `jenis_bl` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `ket_bl_teks` text CHARACTER SET latin1,
  `kode_akun` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `koefisien` text CHARACTER SET latin1,
  `koefisien_murni` text CHARACTER SET latin1,
  `lokus_akun_teks` text CHARACTER SET latin1,
  `nama_akun` text CHARACTER SET latin1,
  `nama_komponen` text CHARACTER SET latin1,
  `spek_komponen` text CHARACTER SET latin1,
  `satuan` varchar(150) CHARACTER SET latin1 DEFAULT NULL,
  `spek` text CHARACTER SET latin1,
  `sat1` text CHARACTER SET latin1,
  `sat2` text CHARACTER SET latin1,
  `sat3` text CHARACTER SET latin1,
  `sat4` text CHARACTER SET latin1,
  `volum1` text CHARACTER SET latin1,
  `volum2` text CHARACTER SET latin1,
  `volum3` text CHARACTER SET latin1,
  `volum4` text CHARACTER SET latin1,
  `volume` text CHARACTER SET latin1,
  `volume_murni` text CHARACTER SET latin1,
  `subs_bl_teks` text CHARACTER SET latin1,
  `subtitle_teks` text CHARACTER SET latin1,
  `kode_dana` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `is_paket` tinyint(4) DEFAULT NULL,
  `nama_dana` text CHARACTER SET latin1,
  `id_dana` int(11) DEFAULT NULL,
  `substeks` text CHARACTER SET latin1,
  `total_harga` double(20,2) DEFAULT NULL,
  `rincian` double(20,2) DEFAULT NULL,
  `rincian_murni` double(20,2) DEFAULT NULL,
  `totalpajak` double(20,2) DEFAULT NULL,
  `pajak` double(20,2) DEFAULT NULL,
  `pajak_murni` double(20,2) DEFAULT NULL,
  `updated_user` int(11) DEFAULT NULL,
  `updateddate` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
  `updatedtime` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
  `user1` text CHARACTER SET latin1,
  `user2` text CHARACTER SET latin1,
  `active` tinyint(4) DEFAULT '1',
  `akun_locked` tinyint(4) DEFAULT NULL,
  `ssh_locked` tinyint(4) DEFAULT NULL,
  `update_at` datetime DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL DEFAULT '2021',
  `idbl` int(11) DEFAULT NULL,
  `idsubbl` int(11) DEFAULT NULL,
  `kode_bl` varchar(50) CHARACTER SET latin1 NOT NULL,
  `kode_sbl` varchar(50) CHARACTER SET latin1 NOT NULL,
  `id_prop_penerima` int(11) DEFAULT NULL,
  `id_camat_penerima` int(11) DEFAULT NULL,
  `id_kokab_penerima` int(11) DEFAULT NULL,
  `id_lurah_penerima` int(11) DEFAULT NULL,
  `id_penerima` int(11) DEFAULT NULL,
  `idkomponen` double(20,2) DEFAULT NULL,
  `idketerangan` int(11) DEFAULT NULL,
  `idsubtitle` int(11) DEFAULT NULL,
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_surat_usulan_ssh` (
  `id` int(11) NOT NULL auto_increment,
  `created_user` text DEFAULT NULL,
  `idskpd` int(11) DEFAULT NULL,
  `nomor_surat` text DEFAULT NULL,
  `nama_file` text DEFAULT NULL,
  `catatan` text DEFAULT NULL,
  `catatan_verifikator` text DEFAULT NULL,
  `jenis_survey` int(11) DEFAULT NULL,
  `jenis_juknis` int(11) DEFAULT NULL,
  `active` tinyint(4) DEFAULT '1',
  `update_at` datetime DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL DEFAULT '2021',
  PRIMARY KEY (id)
);

CREATE TABLE `data_nota_dinas_usulan_ssh` (
  `id` int(11) NOT NULL auto_increment,
  `created_user` text DEFAULT NULL,
  `nomor_surat` text DEFAULT NULL,
  `catatan` text DEFAULT NULL,
  `is_locked` tinyint(4) DEFAULT 0,
  `active` tinyint(4) DEFAULT '1',
  `update_at` datetime DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL DEFAULT '2021',
  PRIMARY KEY (id)
);

CREATE TABLE `data_keg_indikator_hasil_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `hasilteks` text,
  `satuanhasil` varchar(50) DEFAULT NULL,
  `targethasil` varchar(50) DEFAULT NULL,
  `targethasilteks` varchar(50) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `idsubbl` varchar(50) DEFAULT NULL,
  `active` tinyint(4) DEFAULT 1,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `hasilteks_usulan` text,
  `satuanhasil_usulan` varchar(50) DEFAULT NULL,
  `targethasil_usulan` varchar(50) DEFAULT NULL,
  `targethasilteks_usulan` varchar(50) DEFAULT NULL,
  `catatan` text DEFAULT NULL,
  `catatan_usulan` text DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_keg_indikator_hasil_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `hasilteks` text,
  `satuanhasil` varchar(50) DEFAULT NULL,
  `targethasil` varchar(50) DEFAULT NULL,
  `targethasilteks` varchar(50) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `idsubbl` varchar(50) DEFAULT NULL,
  `active` tinyint(4) DEFAULT '1',
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `hasilteks_usulan` text,
  `satuanhasil_usulan` varchar(50) DEFAULT NULL,
  `targethasil_usulan` varchar(50) DEFAULT NULL,
  `targethasilteks_usulan` varchar(50) DEFAULT NULL,
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `catatan` text DEFAULT NULL,
  `catatan_usulan` text DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_jenis_standar_harga`(
  `id` int(11) NOT NULL auto_increment,
  `jenis_standar_harga` varchar(50) DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_label_sub_keg` (
  `id` int(11) NOT NULL auto_increment,
  `id_label_giat` int(11) DEFAULT NULL,
  `id_unik` text,
  `is_locked` int(11) DEFAULT NULL,
  `nama_label` text,
  `status` tinytext,
  `tahun_anggaran` year(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `active` tinyint(4) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `id_label_giat_usulan` int(11) DEFAULT NULL,
  `id_unik_usulan` text DEFAULT NULL,
  `nama_label_usulan` text DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_label_sub_keg_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_label_giat` int(11) DEFAULT NULL,
  `id_unik` text,
  `is_locked` int(11) DEFAULT NULL,
  `nama_label` text,
  `status` tinytext,
  `tahun_anggaran` year(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `active` tinyint(4) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `id_label_giat_usulan` int(11) DEFAULT NULL,
  `id_unik_usulan` text DEFAULT NULL,
  `nama_label_usulan` text DEFAULT NULL,
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_label_sub_keg_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `id_label_giat` int(11) DEFAULT NULL,
  `id_unik` text,
  `is_locked` int(11) DEFAULT NULL,
  `nama_label` text,
  `status` tinytext,
  `tahun_anggaran` year(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `active` tinyint(4) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `id_label_giat_usulan` int(11) DEFAULT NULL,
  `id_unik_usulan` text DEFAULT NULL,
  `nama_label_usulan` text DEFAULT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_label_sub_keg_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_label_giat` int(11) DEFAULT NULL,
  `id_unik` text,
  `is_locked` int(11) DEFAULT NULL,
  `nama_label` text,
  `status` tinytext,
  `tahun_anggaran` year(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `active` tinyint(4) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `id_label_giat_usulan` int(11) DEFAULT NULL,
  `id_unik_usulan` text DEFAULT NULL,
  `nama_label_usulan` text DEFAULT NULL,
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_bkk_desa` (
  `id` int(11) NOT NULL auto_increment,
  `id_kecamatan` int(11) DEFAULT NULL,
  `id_desa` int(11) DEFAULT NULL,
  `kecamatan` text DEFAULT NULL,
  `desa` text DEFAULT NULL,
  `kegiatan` text DEFAULT NULL,
  `alamat` text DEFAULT NULL,
  `total` double(20,2) DEFAULT NULL,
  `id_dana` text DEFAULT NULL,
  `sumber_dana` text DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `active` tinyint(4) DEFAULT 1,
  PRIMARY KEY (id)
);

CREATE TABLE `data_bkk_pilkades_desa` ( 
  `id` int(11) NOT NULL auto_increment, 
  `id_kecamatan` int(11) DEFAULT NULL, 
  `id_desa` int(11) DEFAULT NULL, 
  `kecamatan` text DEFAULT NULL, 
  `desa` text DEFAULT NULL, 
  `total` double(20,2) DEFAULT NULL, 
  `tahun_anggaran` year(4) NOT NULL, 
  `update_at` datetime NOT NULL, 
  `active` tinyint(4) DEFAULT 1, 
  PRIMARY KEY (id) 
);

CREATE TABLE `data_pencairan_bkk_pilkades_desa` ( 
  `id` int(11) NOT NULL auto_increment, 
  `id_bkk_pilkades` int(11) DEFAULT NULL, 
  `total_pencairan` double(20,2) DEFAULT NULL, 
  `keterangan` text DEFAULT NULL, 
  `nama_user` text DEFAULT NULL, 
  `status_ver_total` tinyint(4) DEFAULT 0, 
  `ket_ver_total` text DEFAULT NULL, 
  `update_at` datetime NOT NULL, 
  `status` tinyint(4) DEFAULT 1, 
  PRIMARY KEY (id) 
);

CREATE TABLE `data_pendapatan_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `created_user` int(11) DEFAULT NULL,
  `createddate` varchar(50) DEFAULT NULL,
  `createdtime` varchar(50) DEFAULT NULL,
  `id_pendapatan` int(11) DEFAULT NULL,
  `keterangan` text,
  `kode_akun` varchar(50) DEFAULT NULL,
  `nama_akun` text,
  `nilaimurni` double DEFAULT NULL,
  `program_koordinator` int(11) DEFAULT NULL,
  `rekening` text,
  `skpd_koordinator` int(11) DEFAULT NULL,
  `total` double DEFAULT NULL,
  `pagu_fmis` double(20,2) DEFAULT NULL,
  `updated_user` int(11) DEFAULT NULL,
  `updateddate` varchar(50) DEFAULT NULL,
  `updatedtime` varchar(50) DEFAULT NULL,
  `uraian` text,
  `urusan_koordinator` int(11) DEFAULT NULL,
  `user1` text DEFAULT NULL,
  `user2` text DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `id_akun` int(11) DEFAULT NULL,
  `id_jadwal_murni` int(11) DEFAULT NULL,
  `koefisien` varchar(50) DEFAULT NULL,
  `kua_murni` varchar(50) DEFAULT NULL,
  `kua_pak` varchar(50) DEFAULT NULL,
  `rkpd_murni` varchar(50) DEFAULT NULL,
  `rkpd_pak` varchar(50) DEFAULT NULL,
  `satuan` varchar(50) DEFAULT NULL,
  `volume` varchar(50) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_pendapatan_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `created_user` int(11) DEFAULT NULL,
  `createddate` varchar(50) DEFAULT NULL,
  `createdtime` varchar(50) DEFAULT NULL,
  `id_pendapatan` int(11) DEFAULT NULL,
  `keterangan` text,
  `kode_akun` varchar(50) DEFAULT NULL,
  `nama_akun` text,
  `nilaimurni` double DEFAULT NULL,
  `program_koordinator` int(11) DEFAULT NULL,
  `rekening` text,
  `skpd_koordinator` int(11) DEFAULT NULL,
  `total` double DEFAULT NULL,
  `pagu_fmis` double(20,2) DEFAULT NULL,
  `updated_user` int(11) DEFAULT NULL,
  `updateddate` varchar(50) DEFAULT NULL,
  `updatedtime` varchar(50) DEFAULT NULL,
  `uraian` text,
  `urusan_koordinator` int(11) DEFAULT NULL,
  `user1` text DEFAULT NULL,
  `user2` text DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_bhpd_desa` (
  `id` int(11) NOT NULL auto_increment,
  `id_kecamatan` int(11) DEFAULT NULL,
  `id_desa` int(11) DEFAULT NULL,
  `kecamatan` text DEFAULT NULL,
  `desa` text DEFAULT NULL,
  `total` double(20,2) DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `active` tinyint(4) DEFAULT 1,
  PRIMARY KEY (id)
);

CREATE TABLE `data_bkk_pilkades_desa` (
  `id` int(11) NOT NULL auto_increment,
  `id_kecamatan` int(11) DEFAULT NULL,
  `id_desa` int(11) DEFAULT NULL,
  `kecamatan` text DEFAULT NULL,
  `desa` text DEFAULT NULL,
  `total` double(20,2) DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `active` tinyint(4) DEFAULT 1,
  PRIMARY KEY (id)
);

CREATE TABLE `data_bhrd_desa` (
  `id` int(11) NOT NULL auto_increment,
  `id_kecamatan` int(11) DEFAULT NULL,
  `id_desa` int(11) DEFAULT NULL,
  `kecamatan` text DEFAULT NULL,
  `desa` text DEFAULT NULL,
  `total` double(20,2) DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `active` tinyint(4) DEFAULT 1,
  PRIMARY KEY (id)
);

CREATE TABLE `data_bku_dd_desa` (
  `id` int(11) NOT NULL auto_increment,
  `id_kecamatan` int(11) DEFAULT NULL,
  `id_desa` int(11) DEFAULT NULL,
  `kecamatan` text DEFAULT NULL,
  `desa` text DEFAULT NULL,
  `total` double(20,2) DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `active` tinyint(4) DEFAULT 1,
  PRIMARY KEY (id)
);

CREATE TABLE `data_bku_add_desa` (
  `id` int(11) NOT NULL auto_increment,
  `id_kecamatan` int(11) DEFAULT NULL,
  `id_desa` int(11) DEFAULT NULL,
  `kecamatan` text DEFAULT NULL,
  `desa` text DEFAULT NULL,
  `total` double(20,2) DEFAULT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `active` tinyint(4) DEFAULT 1,
  PRIMARY KEY (id)
);

CREATE TABLE `data_pembiayaan_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `created_user` int(11) DEFAULT NULL,
  `createddate` varchar(50) DEFAULT NULL,
  `createdtime` varchar(50) DEFAULT NULL,
  `id_pembiayaan` int(11) DEFAULT NULL,
  `keterangan` text DEFAULT NULL,
  `kode_akun` varchar(50) DEFAULT NULL,
  `nama_akun` text,
  `nilaimurni` double DEFAULT NULL,
  `program_koordinator` int(11) DEFAULT NULL,
  `rekening` text,
  `skpd_koordinator` int(11) DEFAULT NULL,
  `total` double DEFAULT NULL,
  `pagu_fmis` double(20,2) DEFAULT NULL,
  `updated_user` int(11) DEFAULT NULL,
  `updateddate` varchar(50) DEFAULT NULL,
  `updatedtime` varchar(50) DEFAULT NULL,
  `uraian` text,
  `urusan_koordinator` int(11) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `user1` text DEFAULT NULL,
  `user2`  text DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `id_akun` int(11) DEFAULT NULL,
  `id_jadwal_murni` int(11) DEFAULT NULL,
  `koefisien` varchar(50) DEFAULT NULL,
  `kua_murni` varchar(50) DEFAULT NULL,
  `kua_pak` varchar(50) DEFAULT NULL,
  `rkpd_murni` varchar(50) DEFAULT NULL,
  `rkpd_pak` varchar(50) DEFAULT NULL,
  `satuan` varchar(50) DEFAULT NULL,
  `volume` varchar(50) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_pembiayaan_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `created_user` int(11) DEFAULT NULL,
  `createddate` varchar(50) DEFAULT NULL,
  `createdtime` varchar(50) DEFAULT NULL,
  `id_pembiayaan` int(11) DEFAULT NULL,
  `keterangan` text DEFAULT NULL,
  `kode_akun` varchar(50) DEFAULT NULL,
  `nama_akun` text,
  `nilaimurni` double DEFAULT NULL,
  `program_koordinator` int(11) DEFAULT NULL,
  `rekening` text,
  `skpd_koordinator` int(11) DEFAULT NULL,
  `total` double DEFAULT NULL,
  `pagu_fmis` double(20,2) DEFAULT NULL,
  `updated_user` int(11) DEFAULT NULL,
  `updateddate` varchar(50) DEFAULT NULL,
  `updatedtime` varchar(50) DEFAULT NULL,
  `uraian` text,
  `urusan_koordinator` int(11) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `user1`text DEFAULT NULL,
  `user2`text DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  `id_asli` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_pencairan_bkk_desa` (
  `id` int(11) NOT NULL auto_increment,
  `id_kegiatan` int(11) DEFAULT NULL,
  `total_pencairan` double(20,2) DEFAULT NULL,
  `file_nota_dinas` text DEFAULT NULL,
  `file_sptj` text DEFAULT NULL,
  `file_pakta_integritas` text DEFAULT NULL,
  `file_permohonan_transfer` text DEFAULT NULL,
  `file_verifikasi_rekomendasi` text DEFAULT NULL,
  `file_permohonan_penyaluran_kades` text DEFAULT NULL,
  `file_sptj_kades` text DEFAULT NULL,
  `file_pakta_integritas_kades` text DEFAULT NULL,
  `file_pakta_integritas_3_orang` text DEFAULT NULL,
  `file_proposal_rencana_anggaran` text DEFAULT NULL,
  `file_apbdes` text DEFAULT NULL,
  `file_fc_rek_kas_desa` text DEFAULT NULL,
  `nama_user` text DEFAULT NULL,
  `status_ver_total` tinyint(4) DEFAULT 0,
  `ket_ver_total` text DEFAULT NULL,
  `status_ver_proposal` tinyint(4) DEFAULT 0,
  `ket_ver_proposal` text DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `status` tinyint(4) DEFAULT 1,
  PRIMARY KEY (id)
);

CREATE TABLE `data_pencairan_bhpd_desa` (
  `id` int(11) NOT NULL auto_increment,
  `id_bhpd` int(11) DEFAULT NULL,
  `total_pencairan` double(20,2) DEFAULT NULL,
  `keterangan` text DEFAULT NULL,
  `file_nota_dinas` text DEFAULT NULL,
  `file_sptj` text DEFAULT NULL,
  `file_pakta_integritas` text DEFAULT NULL,
  `file_permohonan_transfer` text DEFAULT NULL,
  `file_rekomendasi` text DEFAULT NULL,
  `file_permohonan_penyaluran_kades` text DEFAULT NULL,
  `file_sptj_kades` text DEFAULT NULL,
  `file_pakta_integritas_kades` text DEFAULT NULL,
  `file_pernyataaan_kades_spj_dbhpd` text DEFAULT NULL,
  `file_sk_bendahara_desa` text DEFAULT NULL,
  `file_fc_ktp_kades` text DEFAULT NULL,
  `file_fc_rek_kas_desa` text DEFAULT NULL,
  `file_laporan_realisasi_tahun_sebelumnya` text DEFAULT NULL,
  `nama_user` text DEFAULT NULL,
  `status_ver_total` tinyint(4) DEFAULT 0,
  `ket_ver_total` text DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `status` tinyint(4) DEFAULT 1,
  PRIMARY KEY (id)
);

CREATE TABLE `data_pencairan_bkk_pilkades_desa` (
  `id` int(11) NOT NULL auto_increment,
  `id_bkk_pilkades` int(11) DEFAULT NULL,
  `total_pencairan` double(20,2) DEFAULT NULL,
  `keterangan` text DEFAULT NULL,
  `nama_user` text DEFAULT NULL,
  `status_ver_total` tinyint(4) DEFAULT 0,
  `ket_ver_total` text DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `status` tinyint(4) DEFAULT 1,
  PRIMARY KEY (id)
);

CREATE TABLE `data_pencairan_bhrd_desa` (
  `id` int(11) NOT NULL auto_increment,
  `id_bhrd` int(11) DEFAULT NULL,
  `total_pencairan` double(20,2) DEFAULT NULL,
  `keterangan` text DEFAULT NULL,
  `file_nota_dinas` text DEFAULT NULL,
  `file_sptj` text DEFAULT NULL,
  `file_pakta_integritas` text DEFAULT NULL,
  `file_rekomendasi` text DEFAULT NULL,
  `file_permohonan_transfer` text DEFAULT NULL,
  `file_permohonan_penyaluran_kades` text DEFAULT NULL,
  `file_sptj_kades` text DEFAULT NULL,
  `file_pakta_integritas_kades` text DEFAULT NULL,
  `file_pernyataaan_kades_spj_dbhpd` text DEFAULT NULL,
  `file_sk_bendahara_desa` text DEFAULT NULL,
  `file_fc_ktp_kades` text DEFAULT NULL,
  `file_fc_rek_kas_desa` text DEFAULT NULL,
  `file_laporan_realisasi_sebelumnya` text DEFAULT NULL,
  `nama_user` text DEFAULT NULL,
  `status_ver_total` tinyint(4) DEFAULT 0,
  `ket_ver_total` text DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `status` tinyint(4) DEFAULT 1,
  PRIMARY KEY (id)
);

CREATE TABLE `data_pencairan_bku_dd_desa` (
  `id` int(11) NOT NULL auto_increment,
  `id_bku_dd` int(11) DEFAULT NULL,
  `total_pencairan` double(20,2) DEFAULT NULL,
  `keterangan` text DEFAULT NULL,
  `file_nota_dinas` text DEFAULT NULL,
  `file_sptj` text DEFAULT NULL,
  `file_pakta_integritas` text DEFAULT NULL,
  `file_permohonan_transfer` text DEFAULT NULL,
  `file_realisasi_tahap_sebelumnya` text DEFAULT NULL,
  `file_dokumen_syarat_umum` text DEFAULT NULL,
  `file_dokumen_syarat_khusus` text DEFAULT NULL,
  `nama_user` text DEFAULT NULL,
  `status_ver_total` tinyint(4) DEFAULT 0,
  `ket_ver_total` text DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `status` tinyint(4) DEFAULT 1,
  PRIMARY KEY (id)
);

CREATE TABLE `data_pencairan_bku_add_desa` (
  `id` int(11) NOT NULL auto_increment,
  `id_bku_add` int(11) DEFAULT NULL,
  `total_pencairan` double(20,2) DEFAULT NULL,
  `keterangan` text DEFAULT NULL,
  `file_nota_dinas` text DEFAULT NULL,
  `file_sptj` text DEFAULT NULL,
  `file_pakta_integritas` text DEFAULT NULL,
  `file_permohonan_transfer` text DEFAULT NULL,
  `file_realisasi_tahap_sebelumnya` text DEFAULT NULL,
  `file_dokumen_syarat_umum` text DEFAULT NULL,
  `file_dokumen_syarat_khusus` text DEFAULT NULL,
  `nama_user` text DEFAULT NULL,
  `status_ver_total` tinyint(4) DEFAULT 0,
  `ket_ver_total` text DEFAULT NULL,
  `update_at` datetime NOT NULL,
  `status` tinyint(4) DEFAULT 1,
  PRIMARY KEY (id)
);

CREATE TABLE `data_mapping_sumberdana_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `id_rinci_sub_bl` int(11) NOT NULL,
  `id_sumber_dana` int(11) NOT NULL,
  `user` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_mapping_sumberdana_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_rinci_sub_bl` int(11) NOT NULL,
  `id_sumber_dana` int(11) NOT NULL,
  `user` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_spp_sipd` (
  `id` int(11) NOT NULL auto_increment,
  `nomorSpp` text DEFAULT NULL,
  `nilaiSpp` double(20,2) DEFAULT NULL,
  `tanggalSpp` date DEFAULT NULL,
  `keteranganSpp` text DEFAULT NULL,
  `idSkpd` int(11) DEFAULT NULL,
  `idSubUnit` int(11) DEFAULT NULL,
  `nilaiDisetujuiSpp` double(20,2) DEFAULT NULL,
  `tanggalDisetujuiSpp` date DEFAULT NULL,
  `jenisSpp` varchar(5) DEFAULT NULL,
  `verifikasiSpp` tinyint(4) DEFAULT NULL,
  `keteranganVerifikasi` text DEFAULT NULL,
  `idSpd` int(11) DEFAULT NULL,
  `idPengesahanSpj` int(11) DEFAULT NULL,
  `kunciRekening` tinyint(4) DEFAULT NULL,
  `alamatPenerimaSpp` text DEFAULT NULL,
  `bankPenerimaSpp` text DEFAULT NULL,
  `nomorRekeningPenerimaSpp` text DEFAULT NULL,
  `npwpPenerimaSpp` text DEFAULT NULL,
  `idUser` int(11) DEFAULT NULL,
  `jenisLs` text DEFAULT NULL,
  `isUploaded` tinyint(4) DEFAULT NULL,
  `tahunSpp` year(4) DEFAULT NULL,
  `idKontrak` int(11) DEFAULT NULL,
  `idBA` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `isSpm` tinyint(4) DEFAULT NULL,
  `statusPerubahan` tinyint(4) DEFAULT NULL,
  `isDraft` tinyint(4) DEFAULT NULL,
  `idSpp` int(11) DEFAULT NULL,
  `kodeDaerah` text DEFAULT NULL,
  `idDaerah` int(11) DEFAULT NULL,
  `isGaji` tinyint(4) DEFAULT NULL,
  `is_sptjm` tinyint(4) DEFAULT NULL,
  `tanggal_otorisasi` datetime DEFAULT NULL,
  `is_otorisasi` tinyint(4) DEFAULT NULL,
  `bulan_gaji` text DEFAULT NULL,
  `id_pegawai_pptk` int(11) DEFAULT NULL,
  `nama_pegawai_pptk` text DEFAULT NULL,
  `nip_pegawai_pptk` text DEFAULT NULL,
  `id_jadwal` int(11) DEFAULT NULL,
  `id_tahap` int(11) DEFAULT NULL,
  `status_tahap` text DEFAULT NULL,
  `kode_tahap` text DEFAULT NULL,
  `is_tpp` tinyint(4) DEFAULT NULL,
  `bulan_tpp` tinyint(4) DEFAULT NULL,
  `id_pengajuan_tu` int(11) DEFAULT NULL,
  `nomor_pengajuan_tu` text DEFAULT NULL,
  `id_npd` int(11) DEFAULT NULL,
  `tipe` varchar(10) NOT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_spp_sipd_detail` (
  `id` int(11) NOT NULL auto_increment,
  `idSpp` int(11) DEFAULT NULL,
  `idKegiatan` int(11) DEFAULT NULL,
  `nilaiDetailSpp` double(20,2) DEFAULT NULL,
  `nilaiDisetujuiDetailSpp` double(20,2) DEFAULT NULL,
  `idRekening` int(11) DEFAULT NULL,
  `idBelanja` int(11) DEFAULT NULL,
  `nominal` text DEFAULT NULL,
  `idDetailSpd` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `idSpd` int(11) DEFAULT NULL,
  `idDetailSpp` int(11) DEFAULT NULL,
  `id_jadwal` int(11) DEFAULT NULL,
  `id_tahap` int(11) DEFAULT NULL,
  `status_tahap` text DEFAULT NULL,
  `id_daerah` int(11) DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `tahun_spp` year DEFAULT NULL,
  `kode_rekening` text DEFAULT NULL,
  `nama_rekening` text DEFAULT NULL,
  `id_sub_kegiatan` int(11) DEFAULT NULL,
  `kode_sub_kegiatan` varchar(50) DEFAULT NULL,
  `nama_sub_kegiatan` text DEFAULT NULL,
  `kode_kegiatan` varchar(50) DEFAULT NULL,
  `nama_kegiatan` text DEFAULT NULL,
  `id_sub_skpd` int(11) DEFAULT NULL,
  `nama_sub_skpd` text DEFAULT NULL,
  `distribusi` text DEFAULT NULL,
  `id_pegawai_kpa` int(11) DEFAULT NULL,
  `id_npd` int(11) DEFAULT NULL,
  `id_detail_npd` int(11) DEFAULT NULL,
  `nilaiDetailSpd` double(20,2) DEFAULT NULL,
  `sisaDetailSpd` double(20,2) DEFAULT NULL,
  `isUp` tinyint(4) DEFAULT NULL,
  `tahun` text DEFAULT NULL,
  `isPengajuanTu` tinyint(4) DEFAULT NULL,
  `idSubKegiatan` int(11) DEFAULT NULL,
  `kodeSubKegiatan` text DEFAULT NULL,
  `namaSubKegiatan` text DEFAULT NULL,
  `kodeRekening` varchar(50) DEFAULT NULL,
  `namaRekening` text DEFAULT NULL,
  `kodeKegiatan` varchar(50) DEFAULT NULL,
  `namaKegiatan` text DEFAULT NULL,
  `idSkpd` int(11) DEFAULT NULL,
  `idDaerah` int(11) DEFAULT NULL,
  `idProgram` int(11) DEFAULT NULL,
  `idSubSkpd` int(11) DEFAULT NULL,
  `idPegawaiKpa` int(11) DEFAULT NULL,
  `kodeSubSkpd` varchar(50) DEFAULT NULL,
  `namaSubSkpd` text DEFAULT NULL,
  `isVerifikasiSpp` tinyint(4) DEFAULT NULL,
  `id_bidang` int(11) DEFAULT NULL,
  `kode_program` varchar(50) DEFAULT NULL,
  `nama_program` text DEFAULT NULL,
  `kode_bidang_urusan` varchar(50) DEFAULT NULL,
  `nama_bidang_urusan` text DEFAULT NULL,
  `tipe` varchar(10) NOT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_spp_sipd_ri_detail` (
  `id` int(11) NOT NULL auto_increment,
  `id_skpd` int(11) DEFAULT NULL,
  `id_spp` int(11) DEFAULT NULL,
  `nomor_spd` text DEFAULT NULL,
  `tanggal_spd` datetime DEFAULT NULL,
  `total_spd` double(20,2) DEFAULT NULL,
  `jumlah` double(20,2) DEFAULT NULL,
  `kode_rekening` text DEFAULT NULL,
  `uraian` text DEFAULT NULL,
  `bank_bp_bpp` text DEFAULT NULL,
  `jabatan_bp_bpp` text DEFAULT NULL,
  `jabatan_pa_kpa` text DEFAULT NULL,
  `jenis_ls_spp` text DEFAULT NULL,
  `keterangan` text DEFAULT NULL,
  `nama_bp_bpp` text DEFAULT NULL,
  `nama_daerah` text DEFAULT NULL,
  `nama_ibukota` text DEFAULT NULL,
  `nama_pa_kpa` text DEFAULT NULL,
  `nama_pptk` text DEFAULT NULL,
  `nama_rek_bp_bpp` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `nama_sub_skpd` text DEFAULT NULL,
  `nilai` double(20,2) DEFAULT NULL,
  `nip_bp_bpp` text DEFAULT NULL,
  `nip_pa_kpa` text DEFAULT NULL,
  `nip_pptk` text DEFAULT NULL,
  `no_rek_bp_bpp` text DEFAULT NULL,
  `nomor_transaksi` text DEFAULT NULL,
  `npwp_bp_bpp` text DEFAULT NULL,
  `tahun` year(4) DEFAULT NULL,
  `tanggal_transaksi` datetime DEFAULT NULL,
  `tipe` varchar(10) NOT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_spm_sipd_detail` (
  `id` int(11) NOT NULL auto_increment,
  `id_spm` int(11) DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `nomor_spd` text DEFAULT NULL,
  `tanggal_spd` datetime DEFAULT NULL,
  `total_spd` double(20,2) DEFAULT NULL,
  `jumlah` double(20,2) DEFAULT NULL,
  `kode_rekening` text DEFAULT NULL,
  `uraian` text DEFAULT NULL,
  `bank_pihak_ketiga` text DEFAULT NULL,
  `jabatan_pa_kpa` text DEFAULT NULL,
  `keterangan_spm` text DEFAULT NULL,
  `nama_daerah` text DEFAULT NULL,
  `nama_ibukota` text DEFAULT NULL,
  `nama_pa_kpa` text DEFAULT NULL,
  `nama_pihak_ketiga` text DEFAULT NULL,
  `nama_rek_pihak_ketiga` text DEFAULT NULL,
  `nama_skpd` text DEFAULT NULL,
  `nama_sub_skpd` text DEFAULT NULL,
  `nilai_spm` double(20,2) DEFAULT NULL,
  `nip_pa_kpa` text DEFAULT NULL,
  `no_rek_pihak_ketiga` text DEFAULT NULL,
  `nomor_spm` text DEFAULT NULL,
  `nomor_spp` text DEFAULT NULL,
  `npwp_pihak_ketiga` text DEFAULT NULL,
  `tahun` year(4) DEFAULT NULL,
  `tanggal_spm` datetime DEFAULT NULL,
  `tanggal_spp` datetime DEFAULT NULL,
  `tipe` varchar(10) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_spm_sipd_detail_potongan` (
  `id` int(11) NOT NULL auto_increment,
  `id_spm` int(11) DEFAULT NULL,
  `id_skpd` int(11) DEFAULT NULL,
  `id_billing` int(11) DEFAULT NULL,
  `id_pajak_potongan` int(11) DEFAULT NULL,
  `nama_pajak_potongan` text DEFAULT NULL,
  `nilai_spp_pajak_potongan` double(20,2) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_verifikasi_rka` (
  `id` int(11) NOT NULL auto_increment,
  `kode_sbl` text NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_user` int(11) NOT NULL,
  `nama_verifikator` varchar(100) NOT NULL,
  `fokus_uraian` text NOT NULL,
  `catatan_verifikasi` text NOT NULL,
  `tanggapan_opd` text NOT NULL,
  `update_at_tanggapan` datetime DEFAULT current_timestamp(),
  `create_at` datetime NOT NULL DEFAULT current_timestamp(),
  `update_at` datetime DEFAULT current_timestamp(),
  `active` tinyint(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_verifikasi_rka_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `kode_sbl` text NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_user` int(11) NOT NULL,
  `nama_verifikator` varchar(100) NOT NULL,
  `fokus_uraian` text NOT NULL,
  `catatan_verifikasi` text NOT NULL,
  `tanggapan_opd` text NOT NULL,
  `update_at_tanggapan` datetime DEFAULT current_timestamp(),
  `create_at` datetime NOT NULL DEFAULT current_timestamp(),
  `update_at` datetime DEFAULT current_timestamp(),
  `active` tinyint(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_verifikasi_rka_history` (
  `id` int(11) NOT NULL auto_increment,
  `kode_sbl` text NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_user` int(11) NOT NULL,
  `nama_verifikator` varchar(100) NOT NULL,
  `fokus_uraian` text NOT NULL,
  `catatan_verifikasi` text NOT NULL,
  `tanggapan_opd` text NOT NULL,
  `update_at_tanggapan` datetime DEFAULT current_timestamp(),
  `create_at` datetime NOT NULL DEFAULT current_timestamp(),
  `update_at` datetime DEFAULT current_timestamp(),
  `active` tinyint(4) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_verifikasi_rka_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `kode_sbl` text NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `id_user` int(11) NOT NULL,
  `nama_verifikator` varchar(100) NOT NULL,
  `fokus_uraian` text NOT NULL,
  `catatan_verifikasi` text NOT NULL,
  `tanggapan_opd` text NOT NULL,
  `update_at_tanggapan` datetime DEFAULT current_timestamp(),
  `create_at` datetime NOT NULL DEFAULT current_timestamp(),
  `update_at` datetime DEFAULT current_timestamp(),
  `active` tinyint(4) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_pptk_sub_keg` (
  `id` int(11) NOT NULL auto_increment,
  `id_user` int(11) NOT NULL,
  `kode_sbl` text NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `update_at` datetime DEFAULT current_timestamp(),
  `active` tinyint(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_pptk_sub_keg_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `id_user` int(11) NOT NULL,
  `kode_sbl` text NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `update_at` datetime DEFAULT current_timestamp(),
  `active` tinyint(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_pptk_sub_keg_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_user` int(11) NOT NULL,
  `kode_sbl` text NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `update_at` datetime DEFAULT current_timestamp(),
  `active` tinyint(4) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_pptk_sub_keg_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_user` int(11) NOT NULL,
  `kode_sbl` text NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `update_at` datetime DEFAULT current_timestamp(),
  `active` tinyint(4) NOT NULL,
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_validasi_verifikasi_rka` (
  `id` int(11) NOT NULL auto_increment,
  `id_user` int(11) NOT NULL,
  `kode_sbl` text NOT NULL,
  `nama_bidang` text NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `update_at` datetime DEFAULT current_timestamp(),
  PRIMARY KEY (id)
);

CREATE TABLE `data_validasi_verifikasi_rka_lokal` (
  `id` int(11) NOT NULL auto_increment,
  `id_user` int(11) NOT NULL,
  `kode_sbl` text NOT NULL,
  `nama_bidang` text NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `update_at` datetime DEFAULT current_timestamp(),
  PRIMARY KEY (id)
);

CREATE TABLE `data_validasi_verifikasi_rka_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_user` int(11) NOT NULL,
  `kode_sbl` text NOT NULL,
  `nama_bidang` text NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `update_at` datetime DEFAULT current_timestamp(),
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_validasi_verifikasi_rka_lokal_history` (
  `id` int(11) NOT NULL auto_increment,
  `id_user` int(11) NOT NULL,
  `kode_sbl` text NOT NULL,
  `nama_bidang` text NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  `update_at` datetime DEFAULT current_timestamp(),
  `id_asli` int(11) NOT NULL,
  `id_jadwal` int(11) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_batasan_pagu_sd`(
  `id` int not null auto_increment,
  `id_dana` int(11) NOT NULL,
  `kode_dana` varchar(50) NOT NULL,
  `nama_dana` text NOT NULL,
  `nilai_batasan` double(20,2) NOT NULL,
  `keterangan` text DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `update_at` datetime DEFAULT current_timestamp(),
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_nota_pencairan_dana` (
    `id` int(11) NOT NULL auto_increment,
    `kode_sbl` text NOT NULL,
    `nomor_npd` VARCHAR(50) NOT NULL,
    `id_user_pptk` int(11) NOT NULL,
    `jenis_panjar` VARCHAR(64) DEFAULT NULL,
    `nomor_dpa` VARCHAR(50) NOT NULL,
    `tahun_anggaran` year(4) NOT NULL,
    `active` tinyint(4) NOT NULL,
    `created_at` datetime DEFAULT current_timestamp(),
    `update_at` datetime DEFAULT current_timestamp(),
    PRIMARY KEY (id)
);

CREATE TABLE `data_rekening_nota_pencairan_dana` (
  `id` int(11) NOT NULL auto_increment,
  `nama_rekening` text NOT NULL,
  `kode_rekening` varchar(50) NOT NULL,
  `id_rekening` int(11) DEFAULT NULL,
  `pagu_dana` double(20,2) DEFAULT NULL,
  `kode_sbl` varchar(50) DEFAULT NULL,
  `id_npd` int(11) NOT NULL,
  `active` tinyint(4) DEFAULT 1,
  `update_at` datetime NOT NULL,
  `tahun_anggaran` year(4) NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `data_buku_kas_umum_pembantu` (
    `id` int(11) NOT NULL auto_increment,
    `kode_sbl` text NOT NULL,
    `nomor_nota_bkup` VARCHAR(50) NOT NULL,
    `nomor_bukti` VARCHAR(50) DEFAULT NULL,
    `uraian` TEXT DEFAULT NULL,
    `tipe` VARCHAR(50) NOT NULL,
    `tanggal_bkup` datetime DEFAULT current_timestamp(),
    `pagu` VARCHAR(50) DEFAULT NULL,
    `jenis_cash` VARCHAR(50) DEFAULT NULL,
    `kode_rekening` varchar(50) NOT NULL,
    `nama_rekening` text NOT NULL,
    `id_npd` int(11) NOT NULL,
    `nama_pemilik_rekening_bank` varchar(50) DEFAULT NULL,
    `nama_rekening_bank` varchar(50) DEFAULT NULL,
    `no_rekening_bank` int(11) DEFAULT NULL,
    `id_rinci_sub_bl` int(11) DEFAULT NULL,
    `tahun_anggaran` year(4) NOT NULL,
    `active` tinyint(4) NOT NULL,
    `created_at` datetime DEFAULT current_timestamp(),
    `update_at` datetime DEFAULT current_timestamp(),
    PRIMARY KEY (id)
);

CREATE TABLE `data_pohon_kinerja` (
  `id` int(11) NOT NULL auto_increment,
  `label` varchar(255) NOT NULL,
  `parent` int(11) DEFAULT 0,
  `label_indikator_kinerja` varchar(255) DEFAULT null,
  `level` int(11) NOT null,
  `tahun_anggaran` year(4) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `update_at` datetime DEFAULT current_timestamp(),
  PRIMARY key (id)
);

CREATE TABLE `data_spt_sppd` (
  `id` int(11) NOT NULL auto_increment,
  `nomor_spt` TEXT NOT NULL,
  `dasar_spt` TEXT NOT NULL,
  `tujuan_spt` TEXT NOT NULL,
  `tgl_spt` DATE NOT NULL,
  `id_ka_opd` int(11) NOT NULL,
  `id_skpd` int(11) NOT NULL,
  `tahun_anggaran` year(4) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `update_at` datetime DEFAULT current_timestamp(),
  PRIMARY key (id)
);

CREATE TABLE `data_pegawai_spt_sppd` (
  `id` int(11) NOT NULL auto_increment,
  `nomor_spt` TEXT NOT NULL,
  `nomor_sppd` TEXT NOT NULL,
  `id_pegawai` int(11) NOT NULL,
  `tingkat` TEXT DEFAULT NULL,
  `alat_angkut` ENUM('Kendaraan Dinas', 'Kendaraan Pribadi', 'Kendaraan Umum') NOT NULL,
  `tempat_berangkat` TEXT DEFAULT NULL,
  `tgl_berangkat` DATE NOT NULL,
  `tempat_tujuan` TEXT DEFAULT NULL,
  `tgl_sampai` DATE NOT NULL,
  `tgl_kembali` DATE NOT NULL,
  `id_skpd_sumber_dana` int(11) NOT NULL,
  `kode_rincian_belanja` TEXT NOT NULL,
  `id_ka_opd` int(11) NOT NULL,
  `tgl_ttd_sppd` DATE NOT NULL,
  `keterangan` TEXT DEFAULT NULL,
  `maksud_sppd` TEXT DEFAULT NULL,
  `tahun_anggaran` year(4) DEFAULT NULL,
  `active` tinyint(4) NOT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `update_at` datetime DEFAULT current_timestamp(),
  PRIMARY key (id)
);