organisation
Tables (156)
aduan
- id — int(11) — Primary key — NOT NULL
- idaduan — int(11)
- lkp_jenis_kes_id — int(11)
- lkp_punca_maklumat_id — int(11)
- lkp_status_aduan_id — int(11) — NOT NULL
- lkp_jenis_aduan_id — int(11) — NOT NULL
- lkp_klasifikasi_kes_id — int(11)
- lkp_jenis_kesalahan_id — int(11)
- lkp_akta_id — int(11)
- lkp_seksyen_id — int(11)
- lkp_cawangan_id — int(11)
- lkp_negeri_id — int(11)
- lkp_subsektor_rasuah_id — int(11)
- organisation_id — int(11)
- user_id — bigint(20) — NOT NULL
- lkp_matawang_id — int(11)
- no_aduan — varchar(255)
- siri — varchar(191)
- tarikh_jmm — date
- masuk_jmm — tinyint(1)
- no_cms — varchar(50)
- no_rujukan_awam — varchar(100)
- tarikh_aduan — datetime
- no_maklumat — varchar(255)
- tarikh_maklumat — datetime
- no_fail — varchar(50)
- no_ks — varchar(100)
- no_maklumat_bahagian — varchar(50)
- perlindungan_saksi — int(11)
- nilai_rasuah — text
- lain_lain — text
- tohmahan — text
- bcp_lkp_rekod_id — int(11)
- no_fail_bcp — varchar(191)
- no_fail_induk — varchar(191)
- ulasan — text
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- deleted_at — datetime
- is_penjawat_awam — int(5)
- tulis_sendiri — int(1)
- bahasa_pengadu_id — int(11)
- jurubahasa_id — int(11)
- dari_bahasa_id — int(11)
- ke_bahasa_id — int(11)
- sektor_rasuah_id — int(11)
- no_fail_peribadi — varchar(50)
- lkp_negeri_tindakan_id — int(11)
- lkp_cawangan_tindakan_id — int(11)
- bcp_lkp_peraturan_id — int(11)
- tarikh_migrasi — date
- bpia_lantikan_id — int(11)
- lkp_tindakan_id — int(11)
aduan_organisasi
- id — int(11) — Primary key — NOT NULL
- aduan_id — int(11) — Foreign key → aduan.id — NOT NULL
- organisation_id — int(11) — Foreign key — NOT NULL
aduan_xref
- id — bigint(20) — Primary key — NOT NULL
- xref_id — int(11) — Foreign key → aduan.id
- aduan_id — int(11) — Foreign key → aduan.id
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- tarikh_migrasi — datetime
- xref_indicator — int(11)
aduan_xref_03102023
- id — bigint(20) — Primary key — NOT NULL
- xref_id — int(11)
- aduan_id — int(11)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- tarikh_migrasi — datetime
- xref_indicator — int(11)
ahli_jmm
- id — int(11) — Primary key — NOT NULL
- profiles_id — int(11) — Foreign key
- lkp_kod_bahagian_id — int(11)
- lkp_cawangan_id — int(11)
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- deleted_at — datetime
as_aset
- id — int(11) — Primary key — NOT NULL
- user_id — int(11)
- lkp_cawangan_id — int(11)
- no_siri — varchar(100)
- no_aset — varchar(100)
- lokasi — varchar(255)
- tarikh_daftar — date
- catatan — varchar(255)
- as_lkp_jenis_pelaporan_id — int(11)
- is_sprm — int(11)
- bil_peluru — int(11)
- bil_kelopak — int(11)
- kalibar — varchar(50)
- lot_no — varchar(50)
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- deleted_at — datetime
as_senjata_peluru
- id — int(11) — Primary key — NOT NULL
- as_senjata_permohonan_id — int(11) — Foreign key → as_senjata_permohonan.id — NOT NULL
- penyemak_id — int(11)
- pelulus_id — int(11)
- kuantiti — varchar(255)
- catatan_pemohon — varchar(255)
- catatan_penyemak — varchar(255)
- catatan_pelulus — varchar(255)
- tarikh_semak — datetime
- tarikh_lulus — datetime
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- deleted_at — datetime
- lkp_cawangan_id — int(11)
- as_lkp_status_permohonan_id — int(11)
as_senjata_permohonan
- id — int(11) — Primary key — NOT NULL
- as_aset_id — int(11) — Foreign key → as_aset.id
- lkp_cawangan_id — int(11)
- user_id — int(11)
- catatan_pemohon — varchar(255)
- penyemak_id — int(11)
- tarikh_semak — datetime
- catatan_penyemak — varchar(255)
- pelulus_id — int(11)
- tarikh_lulus — datetime
- catatan_pelulus — varchar(255)
- pegawai_inventori_id — int(11)
- pohon_dari — datetime
- pohon_hingga — datetime
- tujuan — varchar(255)
- pl_peluru_id — int(11)
- bil_peluru — varchar(255)
- bil_kelopak — int(11)
- tarikh_serah — datetime
- tarikh_pulang — datetime
- kekerapan_selenggara — varchar(100)
- is_sprm — int(11)
- is_sihat — int(11)
- penyakit — varchar(100)
- tarikh_kursus — date
- is_lulus — int(11)
- markah — double
- is_tembak — int(11)
- tarikh_tembak — date
- is_hilang — int(11)
- tarikh_hilang — date
- no_surat — varchar(50)
- sah_hingga — date
- rujukan_fail — varchar(50)
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- deleted_at — datetime
attachments
- id — int(11) — Primary key — NOT NULL
- module_id — int(11) — Foreign key — NOT NULL
- lkp_attachment_type_id — int(11) — Foreign key — NOT NULL
- record_id — int(11) — NOT NULL
- filename — varchar(255)
- display — mediumtext
- mime — varchar(255)
- path — mediumtext
- is_image — int(11)
- thumb — varchar(255)
- user_id — int(11) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- deleted_at — datetime
- size — int(11)
- status — int(1)
- keywords — varchar(255)
- views — int(11)
- original_name — varchar(255)
- description — text
- tarikh_migrasi — date
- record_id_backup — int(11)
- path_backup — varchar(255)
- dokumen_v1 — int(11)
- idsaksi — int(11)
- idott — int(11)
attachments_08092023
- id — int(11) — Primary key — NOT NULL
- module_id — int(11) — NOT NULL
- lkp_attachment_type_id — int(11) — NOT NULL
- record_id — int(11) — NOT NULL
- filename — varchar(255)
- display — mediumtext
- mime — varchar(255)
- path — mediumtext
- is_image — int(11)
- thumb — varchar(255)
- user_id — int(11) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- deleted_at — datetime
- size — int(11)
- status — int(1)
- keywords — varchar(255)
- views — int(11)
- original_name — varchar(255)
- description — text
- tarikh_migrasi — date
bak_doket
- id — bigint(20) — Primary key — NOT NULL
- serah_user_id — bigint(20) — Foreign key — NOT NULL
- terima_user_id — bigint(20) — Foreign key — NOT NULL
- tarikh_terima — datetime
- tarikh_edar — datetime
- catatan — text
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bak_lkp_status
- id — int(10) — Primary key — NOT NULL
- description — varchar(191) — NOT NULL
- status — int(11) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bak_lkp_type
- id — int(10) — Primary key — NOT NULL
- description — varchar(191) — NOT NULL
- status — int(11) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bak_lkp_type_officer
- id — int(10) — Primary key — NOT NULL
- description — varchar(191) — NOT NULL
- status — int(11) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bak_officer
- id — int(10) — Primary key — NOT NULL
- bak_id — int(11)
- user_id — int(11)
- bak_lkp_type_officer_id — int(11)
- status — int(11) — NOT NULL
- catatan — text
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- deleted_at — timestamp
- created_by — int(11) — NOT NULL
bank_accounts
- id — int(11) — Primary key — NOT NULL
- bank_branch_id — int(11) — NOT NULL
- lkp_bank_id — int(11) — NOT NULL
- lkp_bank_account_status_id — int(11)
- no_akaun — varchar(100)
- baki — decimal(18,2)
- date_start — date
- date_end — date
- remark — varchar(255)
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
bank_branches
- id — int(11) — Primary key — NOT NULL
- lkp_bank_id — int(11) — NOT NULL
- alamat_id — int(11)
- name — varchar(255)
- remark — varchar(255)
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
barang_kes
- id — int(11) — Primary key — NOT NULL
- aduan_id — int(11)
- bk_lkp_status_id — int(11)
- bk_lkp_jenis_perkhidmatan_id — int(11)
- bk_lkp_kategori_id — int(11)
- nama — varchar(255)
- model — varchar(255)
- no_siri — varchar(255)
- bil — int(11)
- catatan — text
- perkhidmatan — text
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
- st_sita_butiran_id — int(11)
- file_id — int(11)
- idbarang — int(11)
- bk_sub_lkp_kategori_id — int(11)
bcp_hukuman
- id — int(11) — NOT NULL
- file_id — int(11)
- user_id — int(11)
- tarikh_tamat — date
- tarikh_keputusan — date
- bcp_lkp_hukuman_id — int(11)
- tarikh_hukuman — date
- catatan — varchar(255)
bcp_jpa
- id — bigint(20) — Primary key — NOT NULL
- file_id — int(11)
- user_id — int(11)
- bcp_lkp_status_lkj_id — int(11)
- tarikh_hantar — datetime
- catatan — text
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bcp_kategori
- id — int(10) — Primary key — NOT NULL
- aduan_id — int(11) — NOT NULL
- bersifat_jenayah — varchar(191) — NOT NULL
- boleh_dikesan — varchar(191) — NOT NULL
- boleh_tindakan — varchar(191) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- deleted_at — timestamp
bcp_lkj_type
- id — int(11) — NOT NULL
- description — varchar(255)
- status — int(11)
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
bcp_lkp_hukuman
- id — bigint(20) — Primary key — NOT NULL
- description — varchar(191)
- status — int(11)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- deleted_at — timestamp
bcp_lkp_kaedah
- id — bigint(20) — Primary key — NOT NULL
- description — varchar(191)
- status — int(11)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bcp_lkp_ltt
- id — bigint(20) — Primary key — NOT NULL
- description — varchar(191)
- status — int(11)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bcp_lkp_pembelaan
- id — bigint(20) — Primary key — NOT NULL
- description — varchar(191)
- status — int(11)
- duration_days — int(11)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bcp_lkp_peraturan
- id — bigint(20) — NOT NULL
- deleted_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- created_at — timestamp — NOT NULL
- status — int(11)
- description — varchar(191)
- file_lkp_status_id — int(11)
bcp_lkp_rekod
- id — bigint(20) — Primary key — NOT NULL
- description — varchar(191)
- status — int(11)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bcp_lkp_status_lkj
- id — bigint(20) — Primary key — NOT NULL
- description — varchar(191)
- status — int(11)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bcp_lkp_tahan
- id — bigint(20) — Primary key — NOT NULL
- description — varchar(191)
- status — int(11)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bcp_lkp_tindakan
- id — bigint(20) — Primary key — NOT NULL
- keterangan — varchar(191)
- status — int(11)
- file_lkp_status_id — bigint(20) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bcp_ltt
- id — bigint(20) — Primary key — NOT NULL
- file_id — int(11)
- user_id — int(11)
- bcp_lkp_ltt_id — int(11)
- tarikh_tindakan — datetime
- catatan — text
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bcp_pembelaan
- id — bigint(20) — Primary key — NOT NULL
- user_id — int(11)
- okt_id — int(11)
- tarikh_mula — date
- tarikh_tamat — date
- catatan — text
- status — int(11)
- bcp_lkp_pembelaan_id — int(11)
- attachment_id — int(11)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bcp_peraturan_35
- id — bigint(20) — Primary key — NOT NULL
- file_id — int(11)
- user_id — int(11)
- bcp_lkp_lembaga_kumpulan_id — int(11)
- bcp_lkp_keputusan_id — int(11)
- tarikh_mesyuarat — datetime
- tarikh_terima — datetime
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bcp_peraturan_36
- id — bigint(20) — Primary key — NOT NULL
- file_id — int(11)
- user_id — int(11)
- bcp_lkp_kaedah_id — int(11)
- bcp_lkp_keputusan_id — int(11)
- bcp_lkp_keputusan_mesyuarat_id — int(11)
- tarikh_edar_pertuduhan — datetime
- tarikh_terima_pertuduhan — datetime
- tarikh_serah — datetime
- tarikh_mesyuarat — datetime
- tarikh_edar_amaran — datetime
- tarikh_terima_amaran — datetime
- tarikh_mesyuarat_ltt — datetime
- ulasan — text
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bcp_peraturan_37
- id — bigint(20) — Primary key — NOT NULL
- file_id — int(11)
- user_id — int(11)
- bcp_lkp_kaedah_id — int(11)
- bcp_lkp_keputusan_id — int(11)
- bcp_lkp_keputusan_mesyuarat_id — int(11)
- tarikh_edar_pertuduhan — datetime
- tarikh_terima_pertuduhan — datetime
- tarikh_serah — datetime
- tarikh_mesyuarat — datetime
- tarikh_edar_amaran — datetime
- tarikh_terima_amaran — datetime
- tarikh_mesyuarat_ltt — datetime
- ulasan — text
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bcp_peraturan_38
- id — bigint(20) — Primary key — NOT NULL
- file_id — int(11)
- user_id — int(11)
- bcp_lkp_kaedah_id — int(11)
- bcp_lkp_hukuman_id — int(11)
- tarikh_keputusan — datetime
- tarikh_hukuman — datetime
- tarikh_tamat — datetime
- tarikh_edar — datetime
- catatan — text
- tarikh_terima — datetime
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bcp_spa
- id — bigint(20) — Primary key — NOT NULL
- file_id — int(11)
- user_id — int(11)
- bcp_lkp_status_lkj_id — int(11)
- tarikh_hantar — datetime
- catatan — text
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bcp_status_lkj
- id — int(11) — NOT NULL
- file_id — int(11)
- bcp_lkj_type_id — int(11)
- bcp_lkp_status_lkj_id — int(11)
- catatan — text
- tarikh — datetime
- created_at — datetime
- deleted_at — datetime
- updated_at — datetime
- user_id — int(11)
bcp_tahan
- id — bigint(20) — Primary key — NOT NULL
- file_id — int(11)
- user_id — int(11)
- bcp_lkp_ltt_id — int(11)
- tarikh_tindakan — datetime
- catatan — text
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- bcp_lkp_tahan_id — int(11)
bk_bilik
- id — int(11) — Primary key — NOT NULL
- barang_kes_id — int(11) — NOT NULL
- user_id — int(11)
- is_kekal — int(1) — NOT NULL
- is_masuk — int(1) — NOT NULL
- catatan — text
- tarikh — datetime
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
- lokasi — varchar(50)
bk_doket
- id — int(11) — Primary key — NOT NULL
- barang_kes_id — int(11) — NOT NULL
- daripada — varchar(50)
- user_id_serah — int(11)
- kepada — varchar(50)
- user_id_terima — int(11)
- catatan — text
- tarikh — date
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
bk_lkp_jenis_perkhidmatan
- id — int(11) — Primary key — NOT NULL
- description — varchar(255)
- status — int(1)
bk_lkp_kategori
- id — int(11) — Primary key — NOT NULL
- description — varchar(255)
- status — int(1)
- can_forensic — int(1)
bk_lkp_status
- id — int(11) — Primary key — NOT NULL
- description — varchar(255)
- status — int(1)
bpia_hebahan
- id — bigint(20) — Primary key — NOT NULL
- tajuk — varchar(191) — NOT NULL
- keterangan — text — NOT NULL
- dari — date
- hingga — date
- lokasi_ind — int(11)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bpia_lantikan
- id — bigint(20) — Primary key — NOT NULL
- bpia_profil_id — int(11) — NOT NULL
- bpia_organisasi_id — int(11) — NOT NULL
- status — int(11) — NOT NULL
- tarikh_lantik — date — NOT NULL
- tarikh_tamat — date — NOT NULL
- peranan — int(11) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bpia_lantikan_clone
- id — bigint(20) — Primary key — NOT NULL
- bpia_profil_id — int(11) — NOT NULL
- bpia_organisasi_id — int(11) — NOT NULL
- status — int(11) — NOT NULL
- tarikh_lantik — date — NOT NULL
- tarikh_tamat — date — NOT NULL
- peranan — int(11) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bpia_lantikan_clone_15_sep
- id — bigint(20) — Primary key — NOT NULL
- bpia_profil_id — int(11) — NOT NULL
- bpia_organisasi_id — int(11) — NOT NULL
- status — int(11) — NOT NULL
- tarikh_lantik — date — NOT NULL
- tarikh_tamat — date — NOT NULL
- peranan — int(11) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bpia_laporan
- id — bigint(20) — Primary key — NOT NULL
- bpia_organisasi_id — int(11) — NOT NULL
- bpia_profil_id — int(11) — NOT NULL
- bpia_lkp_jenis_laporan_id — int(11)
- bpia_lkp_status_laporan_id — int(11) — NOT NULL
- kategori_ind — int(11) — NOT NULL
- bpia_lkp_risiko_id — int(11)
- tarikh — date — NOT NULL
- tahun — int(11) — NOT NULL
- cabaran_awam — text
- cadangan_awam — text
- tarikh_maklumat — date
- ulasan_aduan_swasta — text
- ulasan_pengesanan_swasta — text
- ulasan_pengukuhan_swasta — text
- ulasan_kawalan_swasta — text
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- catatan_semak — text
bpia_laporan_organisasi_bajet
- id — bigint(20) — Primary key — NOT NULL
- bpia_laporan_id — int(11) — NOT NULL
- organisation_id — int(11) — NOT NULL
- mengurus_sebelum_1 — double
- pembangunan_sebelum_1 — double
- mengurus_sebelum_2 — double
- pembangunan_sebelum_2 — double
- mengurus_sebelum_3 — double
- pembangunan_sebelum_3 — double
- mengurus_semasa — double
- pembangunan_semasa — double
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bpia_laporan_organisasi_selia
- id — bigint(20) — Primary key — NOT NULL
- bpia_laporan_id — int(11) — NOT NULL
- organisation_id — int(11) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bpia_laporan_organisasi_ui
- id — bigint(20) — Primary key — NOT NULL
- bpia_laporan_id — int(11) — NOT NULL
- organisation_id — int(11)
- bpia_lkp_struktur_ui_id — int(11)
- bpia_lkp_garis_pelaporan_id — int(11) — NOT NULL
- bpia_lkp_pelaporan_pentadbiran_id — int(11)
- jumlah_perjawatan — int(11)
- jumlah_pengisian — int(11)
- bil_ui — int(11)
- bil_pentadbiran — int(11)
- tubuh_ind — int(11)
- tarikh — date
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bpia_pendaftaran
- id — bigint(20) — Primary key — NOT NULL
- organisation_id — int(11) — NOT NULL
- nama_organisasi — int(11)
- nama — varchar(191) — NOT NULL
- lkp_gelaran_id — int(11)
- emel — char(191) — NOT NULL
- no_bimbit — char(191)
- tarikh_lantik — date
- tarikh_tamat — date
- peranan — int(11) — NOT NULL
- status — int(11) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bpmp_crm
- id — bigint(20) — Primary key — NOT NULL
- user_id — int(11) — NOT NULL
- alamat — text
- organisation_id — int(11)
- tarikh_mula — date
- tarikh_tamat — date
- tarikh_tempoh_kemaskini — date
- tarikh_akhir_kemaskini — date
- no_fail — varchar(191)
- status — int(11)
- kategori — int(11)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bpmp_org_keputusan
- id — bigint(20) — Primary key — NOT NULL
- bpmp_isu_id — bigint(20)
- lkp_tindakan_id — int(11) — Foreign key
- okt_id — int(11) — Foreign key
- catatan — text
- tarikh — date
- created_at — timestamp
- updated_at — timestamp
- tindakan_id — bigint(20) — Foreign key
bpmp_pemantauan
- id — bigint(20) — Primary key — NOT NULL
- bpmp_org_keputusan_id — bigint(20) — Foreign key → bpmp_org_keputusan.id
- kod_keputusan — bigint(20)
- pemantau_user_id — bigint(20)
- pegawaiditemui_user_id — bigint(20)
- kelemahan — text
- cadangan — text
- tarikh — date
- tempat — varchar(191)
- ulasan — text
- tempoh — int(10)
- kemajuan_pelaksanaan — text
- tarikh_keputusan — date
- tarikh_pemantauan — date
- catatan — text
- created_at — timestamp
- updated_at — timestamp
bpmp_penceramah
- id — bigint(20) — Primary key — NOT NULL
- profile_id — int(11)
- bpmp_crm_id — int(11)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bpmp_peserta
- id — bigint(20) — Primary key — NOT NULL
- profile_id — int(11) — NOT NULL
- bpmp_crm_id — int(11) — NOT NULL
- name — varchar(255)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bpmp_potensi
- id — bigint(20) — Primary key — NOT NULL
- bpmp_crm01_id — int(11)
- bpmp_proses_id — int(11)
- bpmp_lkp_status_id — int(11)
- risiko_id — int(11)
- description — varchar(191)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bpmp_profil
- id — bigint(20) — Primary key — NOT NULL
- profile_id — int(11) — NOT NULL
- status — int(11) — NOT NULL
- tarikh_mula — date — NOT NULL
- tarikh_tamat — date — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bpmp_proses
- id — bigint(20) — Primary key — NOT NULL
- bpmp_crm01_id — int(11)
- bpmp_peserta_id — int(11)
- description — varchar(191)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bpmp_risiko
- id — bigint(20) — Primary key — NOT NULL
- bpmp_crm02_id — int(11) — NOT NULL
- bpmp_potensi_id — int(11) — NOT NULL
- bpmp_lkp_risiko_id — int(11) — NOT NULL
- bpmp_lkp_tor_id — int(11)
- bpmp_lkp_status_id — int(11)
- description — varchar(191)
- TOR — varchar(191)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bpmp_surat_nasihat
- id — bigint(20) — Primary key — NOT NULL
- bpmp_org_keputusan_id — bigint(20) — Foreign key → bpmp_org_keputusan.id
- bpmp_lkp_jenis_surat_id — bigint(20)
- tajuk — text
- isu — text
- kandungan — text
- penutup — text
- cadangan — text
- ulasan — text
- tarikh_edaran — date
- tarikh_maklumbalas — date
- tarikh_edaran_hijri — varchar(191)
- created_at — timestamp
- updated_at — timestamp
bpmp_tanggungjawab
- id — bigint(20) — Primary key — NOT NULL
- organisation_id — int(11) — NOT NULL
- description — varchar(191) — NOT NULL
- status — int(11) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bpmp_tor
- id — bigint(20) — Primary key — NOT NULL
- bpmp_risiko_id — int(11)
- bpmp_lkp_tor_id — int(11)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
bpr_ott
- idott — int(11) — Primary key — NOT NULL
- idaduan — int(11) — NOT NULL
- folio — int(5)
- nama_ott — varchar(100)
- gelaran_ott — varchar(50)
- nama_alias_ott — varchar(100)
- no_kp_ott — varchar(20)
- no_kp_lama_ott — varchar(20)
- no_polistentera_ott — varchar(20)
- no_pasport_ott — varchar(20)
- no_rujukan_jari — varchar(20)
- jantina_ott — varchar(10)
- bangsa_ott — varchar(15)
- warganegara_ott — varchar(50)
- umur_ott — int(11)
- agama_ott — varchar(15)
- no_dossier — varchar(30)
- nama_waris — varchar(100)
- hubungan_waris — varchar(30)
- taraf_perkahwinan_ott — varchar(20)
- telefon_rumah — varchar(20)
- telefon_bimbit — varchar(20)
- tkh_lahir — date
- alamat_semasa1 — varchar(100)
- alamat_semasa2 — varchar(100)
- alamat_semasa3 — varchar(100)
- poskod_semasa — varchar(10)
- negeri_semasa — varchar(10)
- alamat_tetap1 — varchar(100)
- alamat_tetap2 — varchar(100)
- alamat_tetap3 — varchar(100)
- poskod_tetap — varchar(10)
- negeri_tetap — varchar(10)
- alamat_keluarga1 — varchar(100)
- alamat_keluarga2 — varchar(100)
- alamat_keluarga3 — varchar(100)
- poskod_keluarga — varchar(10)
- negeri_keluarga — varchar(10)
- idottjabatan — int(11)
- nama_gambar — varchar(50)
- status_gambar — varchar(2) — Y - Ya T - Tidak
- keputusan_kajian — varchar(100)
- tkh_keputusan — date
- keputusan_kajian_kedua — varchar(20)
- tkh_keputusan_kedua — date
- keputusan_kajian_ketiga — varchar(20)
- tkh_keputusan_ketiga — date
- catatankeputusantpr — text
- status_tindakan — varchar(20)
- catatan — text
- bil_pertuduhan — varchar(5)
- tkh_cadang_tuduh — date
- jum_jamin_sprm — varchar(10)
- nama_mahkamah — varchar(200)
- upload_path — varchar(300)
- upload_filename — varchar(300)
- upload_size — varchar(200)
- flag — int(5)
- flag_catatan — varchar(300)
- tkh_masuk — datetime
- … +3
experiences
- id — int(11) — Primary key — NOT NULL
- profile_id — int(11) — NOT NULL
- organisation_id — int(11)
- jawatan — varchar(255)
- pendapatan — decimal(14,2)
- senarai_tugas — varchar(255)
- date_start — date
- date_end — date
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
file_okt_21092023
- file_id — bigint(20) — NOT NULL
- okt_id — int(11) — NOT NULL
- idott — int(11)
- tarikh_migrasi — date
- okt_v1 — int(11)
- fail_v1 — int(11)
- okt_duplicate — int(11)
files
- id — bigint(20) — Primary key — NOT NULL
- file_lkp_status_id — bigint(20) — NOT NULL
- file_lkp_type_id — bigint(20) — NOT NULL
- negeri_tindakan_id — bigint(20) — NOT NULL
- caw_tindakan_id — bigint(20) — NOT NULL
- user_id — bigint(20) — NOT NULL
- no_fail — varchar(191)
- tarikh_buka — date
- detail_type — varchar(191)
- detail_id — bigint(20)
- lkp_klasifikasi_maklumat_id — int(11)
- lkp_jenis_kesalahan_id — int(11)
- lkp_sektor_rasuah_id — int(11)
- lkp_akta_id — int(11)
- lkp_jenis_kes_id — int(11)
- lkp_seksyen_id — int(11)
- negeri_kejadian_id — int(11)
- daerah_kejadian_id — int(11)
- lkp_punca_maklumat_id — int(11)
- is_penjawat_awam — int(11)
- pengadu_id — int(11)
- tulis_sendiri — int(11)
- bahasa_pengadu_id — int(11)
- jurubahasa_id — int(11)
- dari_bahasa_id — int(11)
- ke_bahasa_id — int(11)
- bpia_lantikan_id — int(11)
- ringkasan — text
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- tarikh_migrasi — date
- idaduan — int(11)
- catatan — text
fr_pegawai_proses
- id — int(11) — Primary key — NOT NULL
- fr_permohonan_id — int(11) — NOT NULL
- user_id — bigint(20) — NOT NULL
- tarikh_lantik — datetime
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
- mig_datetime — datetime
fr_permohonan
- id — int(11) — Primary key — NOT NULL
- fr_permohonan_id — int(11)
- user_id — bigint(20) — NOT NULL
- aduan_id — int(11)
- barang_kes_id — int(11)
- fr_lkp_kategori_id — int(11) — NOT NULL
- fr_lkp_status_id — int(11)
- no_kertas_forensik — varchar(255)
- perkhidmatan — text
- catatan — text
- catatan_kelulusan — text
- urgency — int(1)
- tarikh — datetime
- user_id_terima — int(11)
- user_id_serah — int(11)
- keputusan — text
- tarikh_keputusan — date
- updated_at — datetime
- tkh_lantik_pf2 — datetime
- tkh_lantik_pf1 — datetime
- created_at — datetime
- deleted_at — datetime
- fr_sub_lkp_kategori_id — int(11)
- idpenyerah — int(11)
- email_pf1 — varchar(255)
- email_pf2 — varchar(255)
- mig_date — datetime
- tarikh_hantar_barang_kes — datetime
- no_permohonan_forensik — varchar(191)
fr_permohonan_clone
- id — int(11) — Primary key — NOT NULL
- fr_permohonan_id — int(11)
- user_id — bigint(20) — NOT NULL
- aduan_id — int(11)
- barang_kes_id — int(11)
- fr_lkp_kategori_id — int(11) — NOT NULL
- fr_lkp_status_id — int(11)
- no_kertas_forensik — varchar(255)
- perkhidmatan — text
- catatan — text
- catatan_kelulusan — text
- urgency — int(1)
- tarikh — datetime
- user_id_terima — int(11)
- user_id_serah — int(11)
- keputusan — text
- tarikh_keputusan — date
- updated_at — datetime
- tkh_lantik_pf2 — datetime
- tkh_lantik_pf1 — datetime
- created_at — datetime
- deleted_at — datetime
- fr_sub_lkp_kategori_id — int(11)
- idpenyerah — int(11)
- email_pf1 — varchar(255)
- email_pf2 — varchar(255)
- mig_date — datetime
- tarikh_hantar_barang_kes — datetime
- no_permohonan_forensik — varchar(191)
fr_tindakan
- id — int(11) — Primary key — NOT NULL
- user_id — bigint(20) — NOT NULL
- fr_lkp_tindakan_id — int(11) — NOT NULL
- fr_permohonan_id — int(11) — NOT NULL
- catatan — text
- tarikh_pemeriksaan — datetime
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
hebahan
- id — bigint(20) — Primary key — NOT NULL
- tajuk — text — NOT NULL
- keterangan — text — NOT NULL
- dari — date
- hingga — date
- lokasi_ind — int(11)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- status — int(11)
identifications
- id — int(11) — Primary key — NOT NULL
- profile_id — int(11) — NOT NULL
- lkp_identification_type_id — int(11)
- lkp_negara_id — int(11)
- value — varchar(100)
- date_start — date
- date_end — date
- status — int(11)
- remark — varchar(255)
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
- is_latest — int(11)
- tarikh_migrasi — date
identifications_09082023
- id — int(11) — Primary key — NOT NULL
- profile_id — int(11) — NOT NULL
- lkp_identification_type_id — int(11)
- lkp_negara_id — int(11)
- value — varchar(100)
- date_start — date
- date_end — date
- status — int(11)
- remark — varchar(255)
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
- is_latest — int(11)
identifications_12082023
- id — int(11) — Primary key — NOT NULL
- profile_id — int(11) — NOT NULL
- lkp_identification_type_id — int(11)
- lkp_negara_id — int(11)
- value — varchar(100)
- date_start — date
- date_end — date
- status — int(11)
- remark — varchar(255)
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
- is_latest — int(11)
- tarikh_migrasi — date
identifications_15082023
- id — int(11) — Primary key — NOT NULL
- profile_id — int(11) — NOT NULL
- lkp_identification_type_id — int(11)
- lkp_negara_id — int(11)
- value — varchar(100)
- date_start — date
- date_end — date
- status — int(11)
- remark — varchar(255)
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
- is_latest — int(11)
- tarikh_migrasi — date
int_main
- id — bigint(20) — Primary key — NOT NULL
- file_id — int(11)
- operasi — varchar(255)
- jenis_operasi — varchar(255)
- tarikh_buka — datetime
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
- is_zon — tinyint(4) — NOT NULL
- lkp_zon_id — int(11) — NOT NULL
- tarikh_migrasi — date
and 76 more tables