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