crisv2

Tables (632)

_result_menembak

  • id — smallint
  • name — varchar(450)
  • min_mark — float
  • max_mark — float

activity_log

  • id — bigint — Primary key — NOT NULL
  • log_name — varchar(191)
  • description — text — NOT NULL
  • subject_type — varchar(191)
  • subject_id — bigint
  • causer_type — varchar(191)
  • causer_id — bigint
  • properties — longtext
  • created_at — timestamp
  • updated_at — timestamp

aduan

  • id — int — Primary key — NOT NULL
  • idaduan — int
  • lkp_jenis_kes_id — int
  • lkp_punca_maklumat_id — int
  • lkp_status_aduan_id — int — NOT NULL
  • lkp_jenis_aduan_id — int — NOT NULL
  • lkp_klasifikasi_kes_id — int
  • lkp_klasifikasi_maklumat_id — int — Foreign key
  • lkp_jenis_kesalahan_id — int
  • lkp_akta_id — int
  • lkp_seksyen_id — int
  • lkp_cawangan_id — int
  • daerah_kejadian_id — int — Foreign key
  • lkp_negeri_id — int
  • lkp_sektor_rasuah_id — int — Foreign key
  • lkp_subsektor_rasuah_id — int
  • organisation_id — int
  • user_id — bigint — NOT NULL
  • lkp_matawang_id — int
  • 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
  • nilai_rasuah — text
  • lain_lain — text
  • tohmahan — text
  • bcp_lkp_rekod_id — int
  • 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
  • tulis_sendiri — int
  • bahasa_pengadu_id — int
  • jurubahasa_id — int
  • dari_bahasa_id — int
  • ke_bahasa_id — int
  • sektor_rasuah_id — int
  • no_fail_peribadi — varchar(50)
  • lkp_negeri_tindakan_id — int
  • lkp_cawangan_tindakan_id — int
  • bcp_lkp_peraturan_id — int
  • tarikh_migrasi — date
  • bpia_lantikan_id — int
  • lkp_tindakan_id — int
  • nilai_projek — int
  • lkp_matawang_projek_id — int
  • lkp_hala_tuju_id — int

aduan_organisasi

  • id — int — Primary key — NOT NULL
  • aduan_id — int — Foreign key → aduan.id — NOT NULL
  • organisation_id — int — Foreign key — NOT NULL

aduan_xref

  • id — bigint — Primary key — NOT NULL
  • xref_id — int — Foreign key → aduan.id
  • aduan_id — int — Foreign key → aduan.id
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp
  • tarikh_migrasi — datetime
  • xref_indicator — int

aduan_xref_03102023

  • id — bigint — Primary key — NOT NULL
  • xref_id — int
  • aduan_id — int
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp
  • tarikh_migrasi — datetime
  • xref_indicator — int

ahli_jmm

  • id — int — Primary key — NOT NULL
  • profiles_id — int — Foreign key
  • lkp_status_ahli_jmm_id — int — Foreign key — NOT NULL
  • lkp_kategori_ahli_id — int — Foreign key — NOT NULL
  • lkp_kod_bahagian_id — int
  • lkp_cawangan_id — int
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

alamat

  • id — int — Primary key — NOT NULL
  • module_id — int — NOT NULL
  • record_id — int — NOT NULL
  • record_model — varchar(255)
  • lkp_jenis_alamat_id — int — NOT NULL
  • lkp_negara_id — int
  • lkp_negeri_id — int
  • lkp_daerah_id — int
  • lkp_poskod_id — int
  • label — varchar(50)
  • baris_1 — varchar(255) — NOT NULL
  • baris_2 — varchar(255)
  • baris_3 — varchar(255)
  • baris_4 — varchar(255)
  • poskod — varchar(10)
  • bandar — varchar(255)
  • longitud — varchar(50)
  • latitud — varchar(50)
  • status — int — NOT NULL
  • start_date — date
  • end_date — date
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

api_tokens

  • id — bigint — Primary key — NOT NULL
  • token — varchar(191) — NOT NULL
  • owner — varchar(191) — NOT NULL
  • token_type — varchar(191) — NOT NULL
  • status — int — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

as_aset

  • id — int — Primary key — NOT NULL
  • user_id — int
  • as_custodian_id — int — Foreign key → as_custodians.id
  • as_lkp_jenis_id — int — Foreign key → as_lkp_jenis.id — NOT NULL
  • lkp_cawangan_id — int
  • as_lkp_lokasi_id — int — Foreign key → as_lkp_lokasi.id
  • as_lkp_status_id — int — Foreign key → as_lkp_status.id — NOT NULL
  • as_lkp_kondisi_id — int — Foreign key → as_lkp_kondisi.id — NOT NULL
  • no_siri — varchar(100)
  • no_aset — varchar(100)
  • lokasi — varchar(255)
  • tarikh_daftar — date
  • catatan — varchar(255)
  • as_lkp_jenis_pelaporan_id — int
  • is_sprm — int
  • bil_peluru — int
  • bil_kelopak — int
  • kalibar — varchar(50)
  • lot_no — varchar(50)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

as_aset_maklumbalas

  • id — int — Primary key — NOT NULL
  • user_id — int — NOT NULL
  • as_aset_id — int — Foreign key → as_aset.id — NOT NULL
  • perkara — varchar(255)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

as_aset_selenggara

  • id — int — Primary key — NOT NULL
  • user_id — bigint — Foreign key — NOT NULL
  • as_aset_id — int — Foreign key → as_aset.id — NOT NULL
  • tarikh — datetime
  • perkara — varchar(255)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

as_custodians

  • id — int — Primary key — NOT NULL
  • as_aset_id — int — Foreign key → as_aset.id — NOT NULL
  • user_id — int — NOT NULL
  • as_lkp_custodian_status_id — int — Foreign key → as_lkp_custodian_status.id — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

as_doket

  • id — int — Primary key — NOT NULL
  • as_aset_id — int — Foreign key → as_aset.id
  • lkp_cawangan_id — int — Foreign key
  • user_id_serah — int
  • user_id_terima — int
  • catatan — varchar(255)
  • tarikh — date
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime
  • is_masuk — int
  • as_lkp_tujuan_id — int
  • kuantiti_senjata — varchar(255)
  • kuantiti_peluru — varchar(255)
  • catatan_peluru — varchar(255)

as_gari_maklumbalas

  • id — int — Primary key — NOT NULL
  • user_id — int — NOT NULL
  • as_gari_permohonan_id — int — Foreign key → as_gari_permohonan.id — NOT NULL
  • perkara — varchar(255)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

as_gari_pelaporan

  • id — int — Primary key — NOT NULL
  • as_gari_permohonan_id — int — Foreign key → as_gari_permohonan.id — NOT NULL
  • as_lkp_jenis_pelaporan_id — int — Foreign key → as_lkp_jenis_pelaporan.id — NOT NULL
  • as_lkp_status_pelaporan_id — int — Foreign key → as_lkp_status_pelaporan.id — NOT NULL
  • lkp_cawangan_id — int — Foreign key
  • user_id — int — NOT NULL
  • penyemak_id — int
  • pelulus_id — int
  • tarikh_aduan — date
  • tarikh_hantar — date
  • tarikh_hantar_lulus — date
  • catatan — varchar(255)
  • catatan_penyemak — varchar(255)
  • catatan_pelulus — varchar(255)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime
  • tarikh_semak — datetime
  • tarikh_lulus — datetime
  • as_lkp_tindakan_id — int

as_gari_permohonan

  • id — int — Primary key — NOT NULL
  • as_aset_id — int — Foreign key → as_aset.id
  • user_id — int — NOT NULL
  • as_lkp_jenis_id — int — Foreign key → as_lkp_jenis.id
  • as_lkp_status_permohonan_id — int — Foreign key → as_lkp_status_permohonan.id — NOT NULL
  • penyemak_id — int
  • pelulus_id — int
  • pohon_dari — datetime
  • pohon_hingga — datetime
  • tujuan — varchar(255)
  • tarikh_lulus — datetime
  • lulus_dari — datetime
  • lulus_hingga — datetime
  • bil_gari_pinjam — int
  • bil_gari_serah — int
  • bil_gari_pulang — int
  • catatan_pemohon — varchar(255)
  • catatan_penyemak — varchar(255)
  • catatan_pelulus — varchar(255)
  • tarikh_serah — datetime
  • tarikh_pulang — datetime
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime
  • lkp_cawangan_id — int
  • kekerapan_selenggara — varchar(255)
  • tarikh_semak — datetime
  • pegawai_inventori_id — int

as_lkp_custodian_status

  • id — int — Primary key — NOT NULL
  • description — varchar(255)
  • status — int
  • other — varchar(255)

as_lkp_jenis

  • id — int — Primary key — NOT NULL
  • module_id — int — Foreign key — NOT NULL
  • as_lkp_jenis_id — int — NOT NULL
  • description — varchar(255)
  • status — int
  • pl_lkp_jenis_id — int
  • sort — int

as_lkp_jenis_pelaporan

  • id — int — Primary key — NOT NULL
  • description — varchar(255) — NOT NULL
  • status — int — NOT NULL

as_lkp_kondisi

  • id — int — Primary key — NOT NULL
  • description — varchar(255)
  • status — int
  • other — int

as_lkp_lokasi

  • id — int — Primary key — NOT NULL
  • lkp_cawangan_id — int — Foreign key — NOT NULL
  • description — varchar(255)
  • status — int
  • as_lkp_lokasi_id — int
  • kod1 — varchar(50)
  • kod2 — varchar(50)
  • level — int

as_lkp_status

  • id — int — Primary key — NOT NULL
  • module_id — int — Foreign key — NOT NULL
  • description — varchar(255)
  • status — int

as_lkp_status_pelaporan

  • id — int — Primary key — NOT NULL
  • description — varchar(255) — NOT NULL
  • status — int — NOT NULL

as_lkp_status_permohonan

  • id — int — Primary key — NOT NULL
  • description — varchar(255)
  • status — int
  • other — int

as_lkp_sub_status

  • id — int — Primary key — NOT NULL
  • as_lkp_status_id — int — Foreign key → as_lkp_status.id — NOT NULL
  • description — varchar(255)
  • status — int
  • other — int

as_lkp_tindakan

  • id — int — Primary key — NOT NULL
  • description — varchar(45) — NOT NULL
  • status — int — NOT NULL
  • other — int

as_lkp_tujuan

  • id — int — Primary key — NOT NULL
  • description — varchar(45) — NOT NULL
  • status — int — NOT NULL
  • is_masuk — int

as_senjata_maklumbalas

  • id — int — Primary key — NOT NULL
  • user_id — int — NOT NULL
  • as_senjata_permohonan_id — int — Foreign key → as_senjata_permohonan.id — NOT NULL
  • perkara — varchar(255)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

as_senjata_pelaporan

  • id — int — Primary key — NOT NULL
  • as_senjata_permohonan_id — int — Foreign key → as_senjata_permohonan.id — NOT NULL
  • as_lkp_jenis_pelaporan_id — int — Foreign key → as_lkp_jenis_pelaporan.id — NOT NULL
  • as_lkp_status_pelaporan_id — int — Foreign key → as_lkp_status_pelaporan.id — NOT NULL
  • lkp_cawangan_id — int — Foreign key
  • user_id — int — NOT NULL
  • catatan — varchar(255)
  • penyemak_id — int
  • catatan_penyemak — varchar(255)
  • tarikh_semak — datetime
  • pelulus_id — int
  • catatan_pelulus — varchar(255)
  • tarikh_lulus — datetime
  • nilai — varchar(255)
  • lokasi — varchar(255)
  • tarikh — datetime
  • cara_hilang — varchar(255)
  • is_tanggung — int
  • is_tahan — int
  • is_lapor — int
  • langkah_elak — varchar(255)
  • langkah_cegah — varchar(255)
  • no_rujukan — varchar(50)
  • butiran_kerosakan — varchar(255)
  • syor_pegawai — varchar(255)
  • is_baik — int
  • rujukan_polis — varchar(100)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

as_senjata_peluru

  • id — int — Primary key — NOT NULL
  • as_senjata_permohonan_id — int — Foreign key → as_senjata_permohonan.id — NOT NULL
  • penyemak_id — int
  • pelulus_id — int
  • 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
  • as_lkp_status_permohonan_id — int

as_senjata_permohonan

  • id — int — Primary key — NOT NULL
  • as_aset_id — int — Foreign key → as_aset.id
  • lkp_cawangan_id — int
  • as_lkp_jenis_id — int — Foreign key → as_lkp_jenis.id
  • as_lkp_status_permohonan_id — int — Foreign key → as_lkp_status_permohonan.id — NOT NULL
  • user_id — int
  • catatan_pemohon — varchar(255)
  • penyemak_id — int
  • tarikh_semak — datetime
  • catatan_penyemak — varchar(255)
  • pelulus_id — int
  • tarikh_lulus — datetime
  • catatan_pelulus — varchar(255)
  • pegawai_inventori_id — int
  • pohon_dari — datetime
  • pohon_hingga — datetime
  • tujuan — varchar(255)
  • pl_peluru_id — int
  • bil_peluru — varchar(255)
  • bil_kelopak — int
  • tarikh_serah — datetime
  • tarikh_pulang — datetime
  • kekerapan_selenggara — varchar(100)
  • is_sprm — int
  • is_sihat — int
  • penyakit — varchar(100)
  • tarikh_kursus — date
  • is_lulus — int
  • markah — double
  • is_tembak — int
  • tarikh_tembak — date
  • is_hilang — int
  • 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 — Primary key — NOT NULL
  • module_id — int — Foreign key — NOT NULL
  • lkp_attachment_type_id — int — Foreign key — NOT NULL
  • record_id — int — NOT NULL
  • filename — varchar(255)
  • display — mediumtext
  • mime — varchar(255)
  • path — mediumtext
  • is_image — int
  • thumb — varchar(255)
  • user_id — int — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime
  • size — int
  • status — int
  • keywords — varchar(255)
  • views — int
  • original_name — varchar(255)
  • description — text
  • tarikh_migrasi — date
  • record_id_backup — int
  • path_backup — varchar(255)
  • dokumen_v1 — int
  • idsaksi — int
  • idott — int

attachments_08092023

  • id — int — Primary key — NOT NULL
  • module_id — int — NOT NULL
  • lkp_attachment_type_id — int — NOT NULL
  • record_id — int — NOT NULL
  • filename — varchar(255)
  • display — mediumtext
  • mime — varchar(255)
  • path — mediumtext
  • is_image — int
  • thumb — varchar(255)
  • user_id — int — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime
  • size — int
  • status — int
  • keywords — varchar(255)
  • views — int
  • original_name — varchar(255)
  • description — text
  • tarikh_migrasi — date

bak

  • id — int — Primary key — NOT NULL
  • bak_lkp_type_id — int — NOT NULL
  • bak_lkp_status_id — int
  • file_id — int
  • user_id — int
  • tarikh_mohon — date
  • catatan — text
  • catatan_pengarah — text
  • catatan_timbalan_pengarah — text
  • status — int — NOT NULL
  • tarikh_sokong — datetime
  • penyokong_id — int
  • tarikh_sokong_timbalan — datetime
  • created_at — timestamp — NOT NULL
  • penyokong_timbalan_id — int
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp

bak_doket

  • id — bigint — Primary key — NOT NULL
  • bak_id — int — Foreign key → bak.id — NOT NULL
  • serah_user_id — bigint — Foreign key — NOT NULL
  • terima_user_id — bigint — Foreign key
  • tarikh_terima — datetime
  • tarikh_edar — datetime
  • catatan — text
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bak_lkp_status

  • id — int — Primary key — NOT NULL
  • description — varchar(191) — NOT NULL
  • status — int — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bak_lkp_type

  • id — int — Primary key — NOT NULL
  • description — varchar(191) — NOT NULL
  • status — int — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bak_lkp_type_officer

  • id — int — Primary key — NOT NULL
  • description — varchar(191) — NOT NULL
  • status — int — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bak_officer

  • id — int — Primary key — NOT NULL
  • bak_id — int
  • user_id — int
  • bak_lkp_type_officer_id — int
  • status — int — NOT NULL
  • catatan — text
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp
  • created_by — int — NOT NULL

bank_accounts

  • id — int — Primary key — NOT NULL
  • bank_branch_id — int — NOT NULL
  • lkp_bank_id — int — NOT NULL
  • lkp_bank_account_status_id — int
  • 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 — Primary key — NOT NULL
  • lkp_bank_id — int — NOT NULL
  • alamat_id — int
  • name — varchar(255)
  • remark — varchar(255)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime

barang_kes

  • id — int — Primary key — NOT NULL
  • aduan_id — int
  • bk_lkp_status_id — int
  • bk_lkp_jenis_perkhidmatan_id — int
  • bk_lkp_kategori_id — int
  • nama — varchar(255)
  • model — varchar(255)
  • no_siri — varchar(255)
  • tarikh_mula_sita — datetime
  • bil — int
  • catatan — text
  • perkhidmatan — text
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • st_sita_butiran_id — int
  • file_id — int
  • idbarang — int
  • bk_sub_lkp_kategori_id — int

bcp_hukuman

  • id — int — NOT NULL
  • file_id — int
  • user_id — int
  • tarikh_tamat — date
  • tarikh_keputusan — date
  • bcp_lkp_hukuman_id — int
  • tarikh_hukuman — date
  • catatan — varchar(255)

bcp_jpa

  • id — bigint — Primary key — NOT NULL
  • file_id — int
  • user_id — int
  • bcp_lkp_status_lkj_id — int
  • tarikh_hantar — datetime
  • catatan — text
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bcp_kategori

  • id — int — Primary key — NOT NULL
  • aduan_id — int — 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 — NOT NULL
  • description — varchar(255)
  • status — int
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime

bcp_lkp_hukuman

  • id — bigint — Primary key — NOT NULL
  • description — varchar(191)
  • status — int
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp

bcp_lkp_kaedah

  • id — bigint — Primary key — NOT NULL
  • description — varchar(191)
  • status — int
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bcp_lkp_keputusan

  • id — bigint — Primary key — NOT NULL
  • description — varchar(191)
  • status — int
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bcp_lkp_keputusan_mesyuarat

  • id — bigint — Primary key — NOT NULL
  • description — varchar(191)
  • status — int
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bcp_lkp_keputusan_rayuan

  • id — bigint — Primary key — NOT NULL
  • description — varchar(191)
  • status — int
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bcp_lkp_lembaga_kumpulan

  • id — bigint — Primary key — NOT NULL
  • description — varchar(191)
  • status — int
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bcp_lkp_ltt

  • id — bigint — Primary key — NOT NULL
  • description — varchar(191)
  • status — int
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bcp_lkp_pembelaan

  • id — bigint — Primary key — NOT NULL
  • description — varchar(191)
  • status — int
  • duration_days — int
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bcp_lkp_peraturan

  • id — bigint — NOT NULL
  • deleted_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL
  • status — int
  • description — varchar(191)
  • file_lkp_status_id — int

bcp_lkp_rekod

  • id — bigint — Primary key — NOT NULL
  • description — varchar(191)
  • status — int
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bcp_lkp_status_lkj

  • id — bigint — Primary key — NOT NULL
  • description — varchar(191)
  • status — int
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bcp_lkp_tahan

  • id — bigint — Primary key — NOT NULL
  • description — varchar(191)
  • status — int
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bcp_lkp_tindakan

  • id — bigint — Primary key — NOT NULL
  • keterangan — varchar(191)
  • status — int
  • file_lkp_status_id — bigint — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bcp_ltt

  • id — bigint — Primary key — NOT NULL
  • file_id — int
  • user_id — int
  • bcp_lkp_ltt_id — int
  • tarikh_tindakan — datetime
  • catatan — text
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bcp_pembelaan

  • id — bigint — Primary key — NOT NULL
  • user_id — int
  • okt_id — int
  • tarikh_mula — date
  • tarikh_tamat — date
  • catatan — text
  • status — int
  • bcp_lkp_pembelaan_id — int
  • attachment_id — int
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bcp_peraturan_35

  • id — bigint — Primary key — NOT NULL
  • file_id — int
  • user_id — int
  • bcp_lkp_lembaga_kumpulan_id — int
  • bcp_lkp_keputusan_id — int
  • tarikh_mesyuarat — datetime
  • tarikh_terima — datetime
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bcp_peraturan_36

  • id — bigint — Primary key — NOT NULL
  • file_id — int
  • user_id — int
  • bcp_lkp_kaedah_id — int
  • bcp_lkp_keputusan_id — int
  • bcp_lkp_keputusan_mesyuarat_id — int
  • 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 — Primary key — NOT NULL
  • file_id — int
  • user_id — int
  • bcp_lkp_kaedah_id — int
  • bcp_lkp_keputusan_id — int
  • bcp_lkp_keputusan_mesyuarat_id — int
  • 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 — Primary key — NOT NULL
  • file_id — int
  • user_id — int
  • bcp_lkp_kaedah_id — int
  • bcp_lkp_hukuman_id — int
  • 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_rayuan

  • id — bigint — Primary key — NOT NULL
  • file_id — int
  • user_id — int
  • bcp_lkp_keputusan_rayuan_id — int
  • tarikh_terima — datetime
  • tarikh_ulasan — datetime
  • tarikh_serah — datetime
  • tarikh_keputusan — datetime
  • catatan — text
  • ulasan — text
  • cadangan — text
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bcp_spa

  • id — bigint — Primary key — NOT NULL
  • file_id — int
  • user_id — int
  • bcp_lkp_status_lkj_id — int
  • tarikh_hantar — datetime
  • catatan — text
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bcp_status_lkj

  • id — int — NOT NULL
  • file_id — int
  • bcp_lkj_type_id — int
  • bcp_lkp_status_lkj_id — int
  • catatan — text
  • tarikh — datetime
  • created_at — datetime
  • deleted_at — datetime
  • updated_at — datetime
  • user_id — int

bcp_tahan

  • id — bigint — Primary key — NOT NULL
  • file_id — int
  • user_id — int
  • bcp_lkp_ltt_id — int
  • tarikh_tindakan — datetime
  • catatan — text
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp
  • bcp_lkp_tahan_id — int

bk_bilik

  • id — int — Primary key — NOT NULL
  • barang_kes_id — int — NOT NULL
  • user_id — int
  • is_kekal — int — NOT NULL
  • is_masuk — int — NOT NULL
  • catatan — text
  • tarikh — datetime
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • lokasi — varchar(50)

bk_doket

  • id — int — Primary key — NOT NULL
  • barang_kes_id — int — NOT NULL
  • daripada — varchar(50)
  • user_id_serah — int
  • kepada — varchar(50)
  • user_id_terima — int
  • catatan — text
  • tarikh — date
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime

bk_lkp_jenis_perkhidmatan

  • id — int — Primary key — NOT NULL
  • description — varchar(255)
  • status — int

bk_lkp_kategori

  • id — int — Primary key — NOT NULL
  • description — varchar(255)
  • status — int
  • can_forensic — int

bk_lkp_status

  • id — int — Primary key — NOT NULL
  • description — varchar(255)
  • status — int

bpia_hebahan

  • id — bigint — Primary key — NOT NULL
  • tajuk — varchar(191) — NOT NULL
  • keterangan — text — NOT NULL
  • dari — date
  • hingga — date
  • lokasi_ind — int
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bpia_lantikan

  • id — bigint — Primary key — NOT NULL
  • bpia_profil_id — int — NOT NULL
  • bpia_organisasi_id — int — NOT NULL
  • status — int — NOT NULL
  • tarikh_lantik — date — NOT NULL
  • tarikh_tamat — date — NOT NULL
  • peranan — int — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bpia_lantikan_clone

  • id — bigint — Primary key — NOT NULL
  • bpia_profil_id — int — NOT NULL
  • bpia_organisasi_id — int — NOT NULL
  • status — int — NOT NULL
  • tarikh_lantik — date — NOT NULL
  • tarikh_tamat — date — NOT NULL
  • peranan — int — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bpia_lantikan_clone_15_sep

  • id — bigint — Primary key — NOT NULL
  • bpia_profil_id — int — NOT NULL
  • bpia_organisasi_id — int — NOT NULL
  • status — int — NOT NULL
  • tarikh_lantik — date — NOT NULL
  • tarikh_tamat — date — NOT NULL
  • peranan — int — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

bpia_laporan

  • id — bigint — Primary key — NOT NULL
  • bpia_organisasi_id — int — NOT NULL
  • bpia_profil_id — int — NOT NULL
  • bpia_lkp_jenis_laporan_id — int
  • bpia_lkp_status_laporan_id — int — NOT NULL
  • kategori_ind — int — NOT NULL
  • bpia_lkp_risiko_id — int
  • tarikh — date — NOT NULL
  • tahun — int — 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

and 552 more tables