jmeeuynz_digitalso
Tables coupons
| Field | Type | Default | Key | Action |
|---|---|---|---|---|
| id | int | NULL | PRI | |
| seller_id | int | NULL | ||
| coupon_code | varchar(50) | NULL | ||
| discount_rate | smallint | NULL | ||
| coupon_count | int | NULL | ||
| minimum_order_amount | bigint | NULL | ||
| currency | varchar(20) | NULL | ||
| usage_type | varchar(20) | single | ||
| category_ids | text | NULL | ||
| expiry_date | timestamp | NULL | ||
| is_public | tinyint(1) | 1 | ||
| created_at | timestamp | NULL |