Table ticket_audit

Column Name	Type	Properties	Docu
auditid	seq64	Primary-Key	additional primary key for auditing
audittime	int64	NULL-able	Time at which the change was made.
audituname	string:64	NULL-able	The user name of the user who made the change.
audittransaction	string:64	NULL-able	The transaction name under which the change was made.
ticketid	string:32		a 8-32 char code (code39: case-insensitive letters+digits) for the ticket; automatically generated
eventid	int32	NULL-able
price	int32
pricecategoryid	int32	NULL-able
status	enum32
orderid	int32
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.