Table voucher

This table is audited, see voucher_audit for details.

Column NameTypePropertiesDocu
voucheridstring:32Primary-Key a 8-32 char code (code39: case-insensitive letters+digits) for the voucher
priceint32price of the voucher (0 if cancelled)
orderidint32Foreign-Key=order(orderid) order this voucher belongs to
isusedboolNULL-able default="false" marker: voucher has been used to pay something
valueint32remaining value in cents (0 for cancelled)
tagsstringNULL-able additional tags for this voucher, can be used by scripts
validtimeint64NULL-able time till which the voucher is valid or NULL if it is valid indefinitely