| PKID | integer | plain | | | Coupon ID |
| fork | integer | plain | | forks.ID | Fork ID (`null` for base module) |
| ownergroup | integer | plain | | groups.ID | Owner group ID (`null`=PUBLIC) |
| creator | integer | plain | | users.ID | Creator user ID (defaults to authenticated user on creation) |
| creationdate | bigint | plain | | | Default: date_part('epoch', now())Creation date and time as a Unix timestamp (defaults to current date and time on creation) |
| lastmodified | bigint | plain | | | Default: date_part('epoch', now())Last modification date and time as a Unix timestamp (auto-reset on modification) |
| activity | smallint | plain | | | Default: 0Activity (`0`=ACTIVE, `1`=DEACTIVATED, `2`=DELETED) |
| name | text | main | | | Name |
| type | smallint | plain | | | Default: 0Coupon type (`0`=PROMOTION, `1`=INDIVIDUAL) |
| code | text | main | | | Default: ''Promotion code; only for PROMOTION |
| value | double precision | plain | | | Default: 0Default value |
| taxrate | double precision | plain | | | Tax rate in percent |
| neutral | smallint | plain | | | Default: 0Neutral in transaction |
| datefrom | bigint | plain | | | Start date and time as a Unix timestamp; must be less than or equal to `dateto` |
| dateto | bigint | plain | | | End date and time as a Unix timestamp; must be greater than or equal to `datefrom` |
| description | text | extended | | | Default: ''Detailed general description |
| foreigntaxrates | json | extended | | | Country-specific tax rates in percent; use country code as object key |