| PKID | bigint | plain | | | Coupon code ID |
| 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) |
| coupon | integer | plain | | coupons.ID | Coupon ID (**dependency**) |
| transaction | integer | plain | | transactions.ID | Transaction ID |
| flag | smallint | plain | | | Default: 0Flag (`0`=BOOKED, `1`=RESERVED, `2`=CANCELLED) |
| date | bigint | plain | | | Default: date_part('epoch', now())Designated date and time as a Unix timestamp (defaults to current date and time on creation) |
| code | text | main | | | Coupon code |
| value | double precision | plain | | | Default: 0Value |
| 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` |