|
id
|
int(10) unsigned
|
|
|
|
|
code
|
varchar(40)
|
|
|
|
|
description
|
varchar(255)
|
|
|
|
|
discount_type
|
enum
|
-- |
|
percent
|
|
amount
|
decimal(12,2)
|
|
|
0.00
|
|
min_spend
|
decimal(12,2)
|
|
|
|
|
max_spend
|
decimal(12,2)
|
|
|
|
|
usage_limit
|
int(10) unsigned
|
|
|
|
|
usage_limit_per_user
|
int(10) unsigned
|
|
|
|
|
expires_at
|
date
|
|
|
|
|
free_shipping
|
tinyint(1)
|
|
|
0
|
|
individual_use
|
tinyint(1)
|
|
|
0
|
|
active
|
tinyint(1)
|
|
|
1
|
|
last_synced_at
|
datetime
|
|
|
|
|
last_sync_error
|
varchar(255)
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|