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