|
id
|
int(11)
|
|
|
|
|
user_id
|
int(11)
|
|
|
|
|
invoice
|
varchar(50)
|
|
|
|
|
buyer_name
|
varchar(100)
|
|
|
|
|
buyer_email
|
varchar(150)
|
|
|
|
|
buyer_phone
|
varchar(20)
|
|
|
|
|
subtotal
|
decimal(15,0)
|
|
|
0
|
|
total
|
decimal(15,0)
|
|
|
0
|
|
status
|
enum
|
-- |
|
pending
|
|
payment_method
|
varchar(50)
|
|
|
whatsapp
|
|
payment_proof
|
varchar(255)
|
|
|
|
|
wa_number
|
varchar(20)
|
|
|
6281234567890
|
|
notes
|
text
|
|
|
|
|
admin_notes
|
text
|
|
|
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
|