M15

Tables (30)

akses_resit

  • id — UUID
  • resit_id — UUID — Foreign key → resit.id — NOT NULL
  • pengguna_id — UUID — Foreign key → pengguna.id — NOT NULL
  • tindakan — VARCHAR(50) — NOT NULL
  • ip_address — VARCHAR(80)
  • user_agent — TEXT
  • accessed_at — TIMESTAMP — NOT NULL

audit_trail

  • id — UUID
  • entiti — VARCHAR(100) — NOT NULL
  • entiti_id — UUID — NOT NULL
  • tindakan — VARCHAR(100) — NOT NULL
  • nilai_lama — JSON
  • nilai_baharu — JSON
  • pengguna_id — UUID — Foreign key → pengguna.id
  • ip_address — VARCHAR(80)
  • created_at — TIMESTAMP — NOT NULL

bayaran_balik

  • id — UUID
  • tuntutan_bayaran_balik_id — UUID — Foreign key → tuntutan_bayaran_balik.id — NOT NULL
  • kaedah_bayaran_id — UUID — Foreign key → ref_kaedah_bayaran.id — NOT NULL
  • amaun — NUMERIC(18,2) — NOT NULL
  • no_rujukan_bayaran — VARCHAR(120)
  • status_id — UUID — Foreign key → ref_status.id — NOT NULL
  • tarikh_bayaran — TIMESTAMP
  • processed_by — UUID — Foreign key → pengguna.id

bayaran_kaunter

  • id — UUID
  • transaksi_bayaran_id — UUID — Foreign key → transaksi_bayaran.id — NOT NULL
  • sesi_kaunter_id — UUID — Foreign key → sesi_kaunter.id — NOT NULL
  • no_rujukan_bayaran — VARCHAR(120)
  • butiran_bayaran — JSON
  • status_id — UUID — Foreign key → ref_status.id — NOT NULL

bayaran_online

  • id — UUID
  • transaksi_bayaran_id — UUID — Foreign key → transaksi_bayaran.id — NOT NULL
  • payment_gateway_ref — VARCHAR(150)
  • gateway_status — VARCHAR(80)
  • gateway_response — JSON
  • callback_received_at — TIMESTAMP
  • status_id — UUID — Foreign key → ref_status.id — NOT NULL

bayaran_online_attempt

  • id — UUID
  • bayaran_online_id — UUID — Foreign key → bayaran_online.id — NOT NULL
  • attempt_no — INTEGER — NOT NULL
  • request_payload — JSON
  • response_payload — JSON
  • status — VARCHAR(80)
  • created_at — TIMESTAMP — NOT NULL

bil

  • id — UUID
  • no_bil — VARCHAR(80) — NOT NULL
  • pembayar_id — UUID — Foreign key → pembayar.id — NOT NULL
  • kod_perakaunan_id — UUID — Foreign key → kod_perakaunan.id — NOT NULL
  • amaun — NUMERIC(18,2) — NOT NULL
  • amaun_dibayar — NUMERIC(18,2) — NOT NULL
  • baki — NUMERIC(18,2) — NOT NULL
  • status_id — UUID — Foreign key → ref_status.id — NOT NULL
  • tarikh_bil — DATE
  • tarikh_luput — DATE
  • created_at — TIMESTAMP — NOT NULL

buku_tunai

  • id — UUID
  • sesi_kaunter_id — UUID — Foreign key → sesi_kaunter.id — NOT NULL
  • transaksi_bayaran_id — UUID — Foreign key → transaksi_bayaran.id
  • kaedah_bayaran_id — UUID — Foreign key → ref_kaedah_bayaran.id — NOT NULL
  • debit — NUMERIC(18,2) — NOT NULL
  • kredit — NUMERIC(18,2) — NOT NULL
  • baki — NUMERIC(18,2) — NOT NULL
  • tarikh_rekod — TIMESTAMP — NOT NULL

dokumen_sokongan

  • id — UUID
  • entiti — VARCHAR(100) — NOT NULL
  • entiti_id — UUID — NOT NULL
  • nama_fail — VARCHAR(255) — NOT NULL
  • jenis_fail — VARCHAR(80) — NOT NULL
  • saiz_fail — BIGINT
  • ddms_ref_id — VARCHAR(150)
  • checksum — VARCHAR(255)
  • uploaded_by — UUID — Foreign key → pengguna.id
  • uploaded_at — TIMESTAMP — NOT NULL

kod_perakaunan

  • id — UUID
  • kod_akaun — VARCHAR(80) — NOT NULL
  • nama_akaun — VARCHAR(200) — NOT NULL
  • jenis_akaun — VARCHAR(80) — NOT NULL
  • kod_vot — VARCHAR(50)
  • kod_ptj — VARCHAR(50)
  • kod_program — VARCHAR(50)
  • kod_aktiviti — VARCHAR(50)
  • tarikh_kuat_kuasa — DATE
  • tarikh_tamat — DATE
  • status_id — UUID — Foreign key → ref_status.id — NOT NULL
  • created_by — UUID — Foreign key → pengguna.id
  • approved_by — UUID — Foreign key → pengguna.id
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

kod_perakaunan_audit

  • id — UUID
  • kod_perakaunan_id — UUID — Foreign key → kod_perakaunan.id — NOT NULL
  • tindakan — VARCHAR(80) — NOT NULL
  • nilai_lama — JSON
  • nilai_baharu — JSON
  • catatan — TEXT
  • created_by — UUID — Foreign key → pengguna.id
  • created_at — TIMESTAMP — NOT NULL

lejar_hasil

  • id — UUID
  • kod_perakaunan_id — UUID — Foreign key → kod_perakaunan.id — NOT NULL
  • transaksi_bayaran_id — UUID — Foreign key → transaksi_bayaran.id
  • posting_hasil_id — UUID — Foreign key → posting_hasil.id
  • debit — NUMERIC(18,2) — NOT NULL
  • kredit — NUMERIC(18,2) — NOT NULL
  • baki — NUMERIC(18,2) — NOT NULL
  • tarikh_posting — TIMESTAMP — NOT NULL

notifikasi

  • id — UUID
  • entiti — VARCHAR(100) — NOT NULL
  • entiti_id — UUID — NOT NULL
  • penerima_id — UUID — Foreign key → pengguna.id — NOT NULL
  • channel — VARCHAR(50)
  • tajuk — VARCHAR(200) — NOT NULL
  • mesej — TEXT — NOT NULL
  • status_id — UUID — Foreign key → ref_status.id — NOT NULL
  • sent_at — TIMESTAMP

pelarasan_hasil

  • id — UUID
  • pembatalan_resit_id — UUID — Foreign key → pembatalan_resit.id
  • transaksi_bayaran_id — UUID — Foreign key → transaksi_bayaran.id — NOT NULL
  • jenis_pelarasan — VARCHAR(80) — NOT NULL
  • amaun — NUMERIC(18,2) — NOT NULL
  • status_id — UUID — Foreign key → ref_status.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • created_by — UUID — Foreign key → pengguna.id

pelarasan_perbezaan_kutipan

  • id — UUID
  • serahan_juruwang_id — UUID — Foreign key → serahan_juruwang.id — NOT NULL
  • jenis_perbezaan — VARCHAR(50) — NOT NULL
  • amaun — NUMERIC(18,2) — NOT NULL
  • sebab — TEXT — NOT NULL
  • tindakan — TEXT
  • created_by — UUID — Foreign key → pengguna.id
  • created_at — TIMESTAMP — NOT NULL

pembatalan_resit

  • id — UUID
  • resit_id — UUID — Foreign key → resit.id — NOT NULL
  • no_permohonan — VARCHAR(80) — NOT NULL
  • sebab_pembatalan — TEXT — NOT NULL
  • kategori_kesilapan — VARCHAR(100)
  • status_id — UUID — Foreign key → ref_status.id — NOT NULL
  • dimohon_oleh — UUID — Foreign key → pengguna.id
  • diluluskan_oleh — UUID — Foreign key → pengguna.id
  • tarikh_permohonan — TIMESTAMP — NOT NULL
  • tarikh_kelulusan — TIMESTAMP

pembayar

  • id — UUID
  • nama — VARCHAR(200) — NOT NULL
  • no_pengenalan — VARCHAR(50)
  • emel — VARCHAR(150)
  • no_telefon — VARCHAR(50)
  • alamat — TEXT
  • aktif — BOOLEAN — NOT NULL

pengguna

  • id — UUID
  • nama — VARCHAR(200) — NOT NULL
  • no_pengenalan — VARCHAR(50)
  • emel — VARCHAR(150)
  • peranan — VARCHAR(80) — NOT NULL
  • aktif — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

posting_hasil

  • id — UUID
  • transaksi_bayaran_id — UUID — Foreign key → transaksi_bayaran.id — NOT NULL
  • resit_id — UUID — Foreign key → resit.id — NOT NULL
  • kod_perakaunan_id — UUID — Foreign key → kod_perakaunan.id — NOT NULL
  • jenis_posting — VARCHAR(50) — NOT NULL
  • amaun — NUMERIC(18,2) — NOT NULL
  • status_id — UUID — Foreign key → ref_status.id — NOT NULL
  • posted_at — TIMESTAMP
  • posted_by — UUID — Foreign key → pengguna.id

ref_kaedah_bayaran

  • id — UUID
  • kod — VARCHAR(30) — NOT NULL
  • nama — VARCHAR(100) — NOT NULL
  • aktif — BOOLEAN — NOT NULL

ref_kategori_transaksi

  • id — UUID
  • kod — VARCHAR(50) — NOT NULL
  • nama — VARCHAR(150) — NOT NULL

ref_status

  • id — UUID
  • kod — VARCHAR(50) — NOT NULL
  • nama — VARCHAR(150) — NOT NULL
  • kategori — VARCHAR(80) — NOT NULL
  • aktif — BOOLEAN — NOT NULL

resit

  • id — UUID
  • no_resit — VARCHAR(80) — NOT NULL
  • transaksi_bayaran_id — UUID — Foreign key → transaksi_bayaran.id — NOT NULL
  • pembayar_id — UUID — Foreign key → pembayar.id — NOT NULL
  • amaun — NUMERIC(18,2) — NOT NULL
  • status_id — UUID — Foreign key → ref_status.id — NOT NULL
  • resit_asal_id — UUID — Foreign key → resit.id
  • qr_hash — VARCHAR(255)
  • tarikh_resit — TIMESTAMP — NOT NULL
  • generated_by — UUID — Foreign key → pengguna.id

serahan_juruwang

  • id — UUID
  • no_serahan — VARCHAR(80) — NOT NULL
  • sesi_kaunter_id — UUID — Foreign key → sesi_kaunter.id — NOT NULL
  • juruwang_id — UUID — Foreign key → pengguna.id — NOT NULL
  • pegawai_penyelia_id — UUID — Foreign key → pengguna.id
  • jumlah_sistem — NUMERIC(18,2) — NOT NULL
  • jumlah_fizikal — NUMERIC(18,2) — NOT NULL
  • beza_kutipan — NUMERIC(18,2) — NOT NULL
  • status_id — UUID — Foreign key → ref_status.id — NOT NULL
  • tarikh_serahan — TIMESTAMP — NOT NULL
  • tarikh_sah — TIMESTAMP

serahan_juruwang_detail

  • id — UUID
  • serahan_juruwang_id — UUID — Foreign key → serahan_juruwang.id — NOT NULL
  • kaedah_bayaran_id — UUID — Foreign key → ref_kaedah_bayaran.id — NOT NULL
  • jumlah_transaksi — INTEGER — NOT NULL
  • jumlah_amaun — NUMERIC(18,2) — NOT NULL

sesi_kaunter

  • id — UUID
  • juruwang_id — UUID — Foreign key → pengguna.id — NOT NULL
  • lokasi_kaunter — VARCHAR(100)
  • tarikh_sesi — DATE
  • masa_buka — TIMESTAMP
  • masa_tutup — TIMESTAMP
  • status_id — UUID — Foreign key → ref_status.id — NOT NULL

transaksi_bayaran

  • id — UUID
  • no_transaksi — VARCHAR(80) — NOT NULL
  • bil_id — UUID — Foreign key → bil.id — NOT NULL
  • pembayar_id — UUID — Foreign key → pembayar.id — NOT NULL
  • kaedah_bayaran_id — UUID — Foreign key → ref_kaedah_bayaran.id — NOT NULL
  • kategori_transaksi_id — UUID — Foreign key → ref_kategori_transaksi.id — NOT NULL
  • amaun — NUMERIC(18,2) — NOT NULL
  • status_id — UUID — Foreign key → ref_status.id — NOT NULL
  • channel — VARCHAR(50)
  • tarikh_transaksi — TIMESTAMP — NOT NULL
  • created_by — UUID — Foreign key → pengguna.id
  • created_at — TIMESTAMP — NOT NULL

transaksi_bayaran_detail

  • id — UUID
  • transaksi_bayaran_id — UUID — Foreign key → transaksi_bayaran.id — NOT NULL
  • kod_perakaunan_id — UUID — Foreign key → kod_perakaunan.id — NOT NULL
  • amaun — NUMERIC(18,2) — NOT NULL
  • keterangan — TEXT

tuntutan_bayaran_balik

  • id — UUID
  • no_tuntutan — VARCHAR(80) — NOT NULL
  • resit_id — UUID — Foreign key → resit.id — NOT NULL
  • pembayar_id — UUID — Foreign key → pembayar.id — NOT NULL
  • amaun_tuntutan — NUMERIC(18,2) — NOT NULL
  • sebab_tuntutan — TEXT — NOT NULL
  • status_id — UUID — Foreign key → ref_status.id — NOT NULL
  • dimohon_oleh — UUID — Foreign key → pengguna.id
  • disemak_oleh — UUID — Foreign key → pengguna.id
  • diluluskan_oleh — UUID — Foreign key → pengguna.id
  • tarikh_mohon — TIMESTAMP — NOT NULL
  • tarikh_lulus — TIMESTAMP

workflow_approval

  • id — UUID
  • entiti — VARCHAR(100) — NOT NULL
  • entiti_id — UUID — NOT NULL
  • peringkat — VARCHAR(80) — NOT NULL
  • status_id — UUID — Foreign key → ref_status.id — NOT NULL
  • catatan — TEXT
  • tindakan_oleh — UUID — Foreign key → pengguna.id
  • tindakan_at — TIMESTAMP