| id |
bigint(20)
|
|
|
|
| no_dokumen |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| member_id |
bigint(20)
|
|
|
 Menjelajahi nilai luar
|
| tanggal_transaksi |
date
|
|
|
|
| club |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| paket_id |
bigint(20)
|
|
|
|
| tanggal_mulai |
date
|
|
|
|
| tanggal_expired |
date
|
|
|
|
| tanggal_bekukan_mulai |
date
|
|
|
|
| tanggal_bekukan_sampai |
date
|
|
|
|
| total_hari_bekukan |
int(10)
|
|
|
|
| catatan_bekukan |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| kunjungan_terpakai |
int(10)
|
|
|
|
| bonus_promo_bulan |
int(10)
|
|
|
|
| bonus_promo_hari |
int(10)
|
|
|
|
| metode_pembayaran |
enum('Cash', 'Transfer', 'QRIS', 'Campuran')
|
utf8mb4_unicode_ci
|
|
|
| harga_paket |
decimal(14,2)
|
|
|
|
| diskon_persen |
decimal(5,2)
|
|
|
|
| diskon_nominal |
decimal(14,2)
|
|
|
|
| harga_setelah_diskon |
decimal(14,2)
|
|
|
|
| total_bayar |
decimal(14,2)
|
|
|
|
| status_pembayaran |
enum('Lunas', 'BB')
|
utf8mb4_unicode_ci
|
|
|
| tanggal_dp |
date
|
|
|
|
| dp |
decimal(14,2)
|
|
|
|
| pelunasan |
decimal(14,2)
|
|
|
|
| tanggal_pelunasan |
date
|
|
|
|
| sold_by |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
