Shopware 5.7.8 s_emarketing_voucher_codes
Individual voucher codes (unique per use) within a voucher campaign.
Columns
| Column | Type | Nullable | Additional |
|---|---|---|---|
| id | int(11) | NO | Primary Key, auto_increment |
| voucherID | int(11) | NO | Index, Default: 0 |
| userID | int(11) | YES | |
| code | varchar(255) | NO | Unique |
| cashed | int(1) | NO |
Indexes
| Index Name | Columns | Unique |
|---|---|---|
| code | code | Yes |
| PRIMARY | id | Yes |
| voucherID_cashed | voucherID,cashed | No |