This table is audited, see voucher_audit for details.
Column Name | Type | Properties | Docu |
voucherid | string:32 | Primary-Key | a 8-32 char code (code39: case-insensitive letters+digits) for the voucher |
price | int32 | price of the voucher (0 if cancelled) | |
orderid | int32 | Foreign-Key=order(orderid) | order this voucher belongs to |
isused | bool | NULL-able default="false" | marker: voucher has been used to pay something |
value | int32 | remaining value in cents (0 for cancelled) | |
tags | string | NULL-able | additional tags for this voucher, can be used by scripts |
validtime | int64 | NULL-able | time till which the voucher is valid or NULL if it is valid indefinitely |