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)