Table event

Column NameTypePropertiesDocu
eventidseq32Primary-Key
titlestring
artistidint32NULL-able Foreign-Key=artist(artistid)
descriptiontextNULL-able
commenttextNULL-able
starttimeint64
endtimeint64
roomidstring:64NULL-able Foreign-Key=room(roomid)
seatplanidint32NULL-able Foreign-Key=seatplan(seatplanid)
capacityint32
iscancelledboolNULL-able default="0"
flagsstringNULL-able filter: who can sell tickets for this event
taxint32NULL-able taxes on this event in hundredth of a percent, this value is actually never used internall, but may be used by printing routines for calculations
tagsstringNULL-able internal tags: can be used by macros and printer routines to change behavior or output
cancelreasonstringNULL-able