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