organisation
Tables (28)
aduan
- 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_klasifikasi_maklumat_id — int(11)
- lkp_jenis_kesalahan_id — int(11)
- lkp_akta_id — int(11)
- lkp_seksyen_id — int(11)
- lkp_cawangan_id — int(11)
- daerah_kejadian_id — int(11)
- lkp_negeri_id — int(11)
- lkp_sektor_rasuah_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)
- id — int(11) — NOT NULL
aduan_organisasi
- id — int(11) — Primary key — NOT NULL
- organisation_id — int(11) — NOT NULL
- Field
bpia_laporan_organisasi
- id — bigint(20) — Primary key — NOT NULL
- bpia_laporan_id — int(11) — NOT NULL
- organisation_id — int(11)
- bpia_lkp_risiko_id — int(11)
- peranan — varchar(191)
- mengurus_semasa_persekutuan — double
- mengurus_semasa_negeri — double
- mengurus_semasa_dalaman — double
- pembangunan_semasa_persekutuan — double
- pembangunan_semasa_negeri — double
- pembangunan_semasa_dalaman — double
- mengurus_sebelum_persekutuan_1 — double
- mengurus_sebelum_negeri_1 — double
- mengurus_sebelum_dalaman_1 — double
- pembangunan_sebelum_persekutuan_1 — double
- pembangunan_sebelum_negeri_1 — double
- pembangunan_sebelum_dalaman_1 — double
- mengurus_sebelum_persekutuan_2 — double
- mengurus_sebelum_negeri_2 — double
- mengurus_sebelum_dalaman_2 — double
- pembangunan_sebelum_persekutuan_2 — double
- pembangunan_sebelum_negeri_2 — double
- pembangunan_sebelum_dalaman_2 — double
- mengurus_sebelum_persekutuan_3 — double
- mengurus_sebelum_negeri_3 — double
- mengurus_sebelum_dalaman_3 — double
- pembangunan_sebelum_persekutuan_3 — double
- pembangunan_sebelum_negeri_3 — double
- pembangunan_sebelum_dalaman_3 — double
- bil_kpt — int(11)
- bil_kpp — int(11)
- bil_sokongan_1 — int(11)
- bil_sokongan_2 — int(11)
- ahli_politik_ind — int(11)
- nama_ahli_politik — text
- syer_kerajaan — double
- kewangan_kerajaan_ind — int(11)
- kewangan_kerajaan — double
- kontrak_kerajaan_ind — int(11)
- kontrak_kerajaan — double
- nama_pengerusi — text
- bil_staf — int(11)
- bil_syarikat — int(11)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
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_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
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
lifestyles
- id — int(11) — Primary key — NOT NULL
- profile_id — int(11) — NOT NULL
- organisation_id — int(11)
- no_ahli — varchar(100)
- jawatan — varchar(255)
- yuran — decimal(10,2)
- date_start — date
- date_end — date
- remark — varchar(255)
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
lkp_mahkamah
- id — bigint(20) — Primary key — NOT NULL
- lkp_mahkamah_type_id — bigint(20) — NOT NULL
- organisation_id — int(11) — NOT NULL
- nama — varchar(255)
- okt_id — int(11)
- status — int(11) — NOT NULL
- is_daftar — int(11) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
lok_lokap_kesihatan
- id — int(11) — Primary key — NOT NULL
- lok_lokap_pergerakan_id — int(11)
- organisation_id — int(11)
- profile_id — int(11)
- nama_doktor — varchar(255)
- nama_penyakit — varchar(255)
- catatan_kesihatan — varchar(255)
- tarikh — datetime
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- deleted_at — datetime
- lok_lokap_tahanan_id — int(11)
oacp_bengkel
- id — bigint(20) — Primary key — NOT NULL
- tempat_bengkel — 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)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
oacp_peserta
- id — bigint(20) — Primary key — NOT NULL
- profile_id — int(11)
- oacp_bengkel_id — int(11)
- organisation_id — int(11)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
oacp_workshop_organisations
- id — bigint(20) — Primary key — NOT NULL
- oacp_status_id — bigint(20)
- organisation_id — bigint(20)
- oacp_workshop_id — bigint(20)
- oacp_user_type_id — bigint(20)
- participant — int(11)
- user_id — int(11)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
oacp_workshop_users
- id — bigint(20) — Primary key — NOT NULL
- oacp_status_id — bigint(20)
- oacp_workshop_organisations_id — bigint(20)
- oacp_workshop_id — bigint(20)
- oacp_user_type_id — bigint(20)
- user_id — int(11)
- profile_id — int(11)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
oacp_workshops
- id — bigint(20) — Primary key — NOT NULL
- oacp_status_id — bigint(20)
- organisation_id — bigint(20)
- tajuk — varchar(191)
- description — text
- location — text
- period_start — date
- period_end — date
- user_id — int(11)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- oacp_workshop_id — bigint(20)
organisation_bahagian
- id — bigint(20) — Primary key — NOT NULL
- organisation_id — bigint(20)
- bahagian_id — bigint(20)
- bidang_id — bigint(20)
- description — varchar(200) — NOT NULL
- website — varchar(200)
- logo — varchar(200)
- no_tel — varchar(200)
- no_fax — varchar(200)
- email — varchar(200)
- alamat_organisasi — tinyint(4)
- active — tinyint(4)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
organisation_category
- id — bigint(20) — Primary key — NOT NULL
- organisation_id — bigint(20)
- type_id — bigint(20)
organisation_cawangan
- id — bigint(20) — Primary key — NOT NULL
- organisation_id — int(11)
- description — varchar(200) — NOT NULL
- alamat_organisasi — tinyint(4)
- active — tinyint(4)
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
organisation_commitee
- id — bigint(20) — Primary key — NOT NULL
- profile_id — bigint(20)
- organisation_id — bigint(20)
- bahagian_id — bigint(20)
- lkp_kumpulan_jawatan_id — bigint(20)
- lkp_kumpulan_perjawatan_id — bigint(20)
- lkp_kumpulan_subperjawatan_id — bigint(20)
- jawatan — varchar(191)
- skim — varchar(191)
- gred — varchar(191)
- remark — varchar(191)
- date_start — date
- date_end — date
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- is_external — int(11)
- is_active — int(11)
organisation_corporate
- id — bigint(20) — Primary key — NOT NULL
- organisation_id — bigint(20)
- visi — text
- misi — text
- matlamat — text
- created_at — timestamp
- updated_at — timestamp
organisation_oacp
- id — bigint(20) — Primary key — NOT NULL
- organisation_id — bigint(20)
- tahun_mula — text
- tahun_tamat — text
- pelan — text
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
organisation_pelan
- id — bigint(20) — Primary key — NOT NULL
- organisation_id — bigint(20)
- tahun_mula — text
- tahun_tamat — text
- pelan — text
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
st_saksi
- id — bigint(20) — Primary key — NOT NULL
- investigation_file_id — bigint(20)
- file_id — bigint(20) — NOT NULL
- profile_id — int(11) — NOT NULL
- organisation_id — int(11)
- waris_profile_id — int(11)
- label — int(11)
- status — int(11) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- deleted_at — timestamp
- idsaksi — int(11)
- saksi_v1 — int(11)
stocks
- id — int(11) — Primary key — NOT NULL
- profile_id — int(11)
- proxy_id — int(11)
- lkp_cara_peroleh_id — int(11)
- lkp_bank_id — int(11)
- organisation_id — int(11)
- jawatan — varchar(255)
- tarikh_belian — date
- jumlah — decimal(15,2)
- lkp_unit_saham_id — int(11)
- nilai_belian — decimal(15,2)
- nilai_semasa — decimal(15,2)
- tarikh_nilai_semasa — date
- keterangan — varchar(255)
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
workplaces
- id — int(11) — Primary key — NOT NULL
- profile_id — int(11) — NOT NULL
- organisation_id — int(11)
- bahagian_id — bigint(20)
- bidang_id — bigint(20)
- lkp_kumpulan_jawatan_id — int(11)
- lkp_kumpulan_perjawatan_id — int(11)
- lkp_kumpulan_subperjawatan_id — int(11)
- date_start — date
- date_end — date
- jawatan — varchar(255)
- gred — varchar(255)
- skim — varchar(200)
- remark — text
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
- is_external — int(11)
- is_active — int(11)