devcris_fomia_old

Tables (7)

fomia_doket

  • id — bigint — Primary key — NOT NULL
  • fomia_id — int — NOT NULL
  • serah_user_id — int — NOT NULL
  • terima_user_id — int
  • tarikh_terima — date
  • tarikh_edar — date
  • catatan — varchar(191)
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

fomia_lkp_bantuan

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

fomia_lkp_fail

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

fomia_lkp_status

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

fomia_negara

  • id — bigint — Primary key — NOT NULL
  • negara_id — int — NOT NULL
  • file_id — int — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

fomia_negara_status

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

fomia_permohonan

  • id — bigint — Primary key — NOT NULL
  • aduan_id — int — NOT NULL
  • fomia_lkp_bantuan_id — int — NOT NULL
  • fomia_lkp_status_id — int — NOT NULL
  • file_id — int
  • pemohon_id — int — NOT NULL
  • bantuan_lain — varchar(191)
  • catatan_permohonan — varchar(191)
  • organisation — varchar(191)
  • organisation_code — varchar(191)
  • negara_id — int
  • pegawai_fomia — int — NOT NULL
  • fomia_lkp_fail_id — int
  • ulasan — varchar(191)
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp