Shopware 5.7.12 s_emarketing_vouchers
Voucher/coupon campaign definitions with discount type, value, and validity rules.
| Column | Type | Nullable | Additional |
| id | int(11) | NO | Primary Key, auto_increment |
| description | varchar(255) | NO | |
| vouchercode | varchar(100) | NO | |
| numberofunits | int(11) | NO | Default: 0 |
| value | double | NO | Default: 0 |
| minimumcharge | double | NO | Default: 0 |
| shippingfree | int(1) | NO | Default: 0 |
| bindtosupplier | int(11) | YES | |
| valid_from | date | YES | |
| valid_to | date | YES | |
| ordercode | varchar(255) | NO | |
| modus | int(1) | NO | Index, Default: 0 |
| percental | int(1) | NO | |
| numorder | int(11) | NO | |
| customergroup | int(11) | YES | |
| restrictarticles | mediumtext | NO | |
| strict | int(1) | NO | |
| subshopID | int(1) | YES | |
| taxconfig | varchar(15) | NO | |
| customer_stream_ids | longtext | YES | |
| Index Name | Columns | Unique |
| modus | modus | No |
| PRIMARY | id | Yes |
Relations (to this table)
1 relations
