| id_data | bigint(20) |
|
|
|
| id_tagihan | varchar(255) |
|
|
|
| id_siswa | varchar(16) |
|
|
|
| id_pembayaran | varchar(32) |
|
|
|
| kode_tagihan | varchar(32) |
|
|
|
| kode_pembayaran | varchar(32) |
|
|
|
| kode_kelas | varchar(16) |
|
|
|
| nis | varchar(32) |
|
|
|
| nama_siswa | varchar(64) |
|
|
|
| nama_kelas | varchar(16) |
|
|
|
| jurusan | varchar(64) |
|
|
|
| tahun_ajaran | varchar(9) |
|
|
|
| nomor_invoice | varchar(16) |
|
|
|
| nama_penyetor | varchar(64) |
|
|
|
| status_penyetor | varchar(32) |
|
|
|
| pembayaran_tagihan | text |
|
|
|
| biaya_admin | int(5) |
|
|
0
|
| total_pembayaran | int(5) |
|
|
0
|
| tipe_pembayaran | enum | -- |
|
|
| metode_pembayaran | varchar(32) |
|
|
|
| pilihan_pembayaran | varchar(32) |
|
|
|
| waktu_terbit_invoice | datetime |
|
|
|
| waktu_pembayaran | datetime |
|
|
|
| waktu_konfirmasi | datetime |
|
|
|
| waktu_pembatalan | datetime |
|
|
|
| tanggal_pembayaran | varchar(10) |
|
|
|
| bulan_pembayaran | varchar(7) |
|
|
|
| tahun_pembayaran | varchar(4) |
|
|
|
| bukti_pembayaran | varchar(64) |
|
|
|
| catatan | varchar(64) |
|
|
|
| alasan_pembatalan | varchar(128) |
|
|
|
| status | enum | -- |
|
|
| sistem_pembayaran | enum | -- |
|
|
| akun_staff | varchar(32) |
|
|
|
| nama_staff | varchar(64) |
|
|
|
| created_at | datetime |
|
|
|
| updated_at | datetime |
|
|
|
