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