Fields (13)
| Name | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | binary(16) | NO | PRI | NULL | |
| promotion_id | binary(16) | NO | MUL | NULL | |
| scope | varchar(32) | NO | NULL | ||
| type | varchar(32) | NO | NULL | ||
| value | double | NO | NULL | ||
| created_at | datetime(3) | NO | NULL | ||
| updated_at | datetime(3) | YES | NULL | ||
| consider_advanced_rules | tinyint(1) | NO | 0 | ||
| max_value | float | YES | NULL | ||
| sorter_key | varchar(255) | YES | NULL | ||
| applier_key | varchar(255) | YES | NULL | ||
| usage_key | varchar(255) | YES | NULL | ||
| picker_key | varchar(255) | YES | NULL |
Indexes (2)
| Name | Columns | Unique |
|---|---|---|
| idx.promotion_discount.promotion_id | promotion_id | No |
| PRIMARY | id | Yes |