|
id
|
bigint(20) unsigned
|
|
|
|
|
user_id
|
bigint(20) unsigned
|
|
|
|
|
reference
|
varchar(255)
|
|
|
|
|
status
|
enum
|
-- |
|
|
|
remarks
|
text
|
|
|
|
|
product_variant_id
|
varchar(255)
|
|
|
|
|
quantity
|
int(11)
|
|
|
|
|
snapshot_data
|
longtext
|
|
|
|
|
metadata
|
longtext
|
|
|
|
|
success_count
|
int(11)
|
|
|
0
|
|
failed_count
|
int(11)
|
|
|
0
|
|
dynasty_cost
|
decimal(10,2)
|
|
|
|
|
moogold_cost
|
decimal(10,2)
|
|
|
|
|
product_snapshot
|
longtext
|
|
|
|
|
variant_snapshot
|
longtext
|
|
|
|
|
order_source
|
varchar(255)
|
|
|
|
|
api_key_id
|
varchar(255)
|
|
|
|
|
external_reference
|
varchar(255)
|
|
|
|
|
previous_balance
|
decimal(10,0)
|
|
|
|
|
after_balance
|
decimal(10,0)
|
|
|
|
|
created_at
|
timestamp
|
|
|
|
|
updated_at
|
timestamp
|
|
|
|