Table ticket

This table is audited, see ticket_audit for details.

Column Name	Type	Properties	Docu
ticketid	string:32	Primary-Key	a 8-32 char code (code39: case-insensitive letters+digits) for the ticket; automatically generated
eventid	int32	NULL-able Foreign-Key=event(eventid)
price	int32
pricecategoryid	int32	NULL-able Foreign-Key=pricecategory(pricecategoryid)
status	enum32
orderid	int32	Foreign-Key=order(orderid)
seat	string:32	NULL-able
tags	string	NULL-able	additional tags for this ticket, can be used by scripts

Enum for column status

Reserved=785
The ticket is reserved for a customer, it blocks the seat, but is not to be paid yet.
Ordered=786
The ticket is ordered/sold and possibly paid for (payment is stored in its order).
Used=771
The ticket has been used.
Cancelled=4
The ticket has been given back for some reason and needs to be re-imbursed (if paid already).
Refund=4
Alias for Cancelled
MaskBlock=256
Masking value: if this bit is set the ticket blocks a seat.
MaskPay=512
Masking value: if this bit is set the ticket must be paid by the customer.
MaskUsable=768
Masking value: combines Block+Pay - the ticket can be used to watch a show or is already being used.
MaskReturnable=16
Masking value: if this bit is set the ticket can still be cancelled.
MaskChangeable=16
Masking value: if this bit is set the ticket can still be changed (price, event, etc.). Currently an alias for MaskReturnable.