tm.event

The list of events in the system. Each event has a number of linked tickettypes and each tickettype has a number of linked tickets

Fields

FieldDescription
id
int
ID
createdts
timestamp
Created timestamp
lastupdatets
timestamp
Last updated timestamp
publishedts
timestamp
Timestamp the event was published
currentstatus
int
The current status for the event (draft, active or closed). See systemtype category 19xxx
seatingplanid
int
Link to the seatingplan

References: tm.seatingplan

seatingplanpricelistid
int
Link to the seatingplan pricelist

References: tm.pricelist

seatingplaneventspecificprices
json
Event specific prices lined to the seatingplan
name<langcode>
mlstring
Name for the event
subtitle<langcode>
mlstring
Subtitle for the event
subtitle2<langcode>
mlstring
Second subtitle for the event
webremark<langcode>
mlstring
Remark that will be displayed during web sales
startts
timestamp
Start of the event
endts
timestamp
End of the event
salestartts
timestamp
Start of the ticket sales for the event
saleendts
timestamp
End of the ticket sales for the event
externalcode
string
External code for the event
productionid
int
Optional link to a production

References: tm.production

locationid
int
Link to the event location

References: tm.eventlocation

ticketfeeid
int
Link to the ticket fee scheme to be applied for the event

References: tm.ticketfee

maxnbrofticketsperbasket
int
Max number of tickets that can be sold for this event in a single order
ticketlayoutid
int
Link to the ticket layout to be applied for the event

References: tm.ticketlayout

typeid
int
The type of event. See systemtype category 15xx

References: tm.systemtype

code
string
The unique code for this event.
isarchived
boolean
Is this event archived.
description<langcode>
mlstring
Description of the event, visible for ticket buyers
schedule<langcode>
mlstring
Schedule for the event, visible for ticket buyers
info<langcode>
mlstring
Practical info for the event, visible for ticket buyers
waitinglisttype
int
The type of waiting list for the event. (29001 - No waiting list, 29002 - No ticket info, 29003 - Full ticket info)

This table can also contain one or more customfields. Each customfield starts with c_