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 tm.ticket
Fields
FIELD | TYPE | DESCRIPTION |
|---|---|---|
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 | mlstring | Name for the event |
subtitle | mlstring | Subtitle for the event |
subtitle2 | mlstring | Second subtitle for the event |
webremark | 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 | mlstring | Description of the event, visible for ticket buyers |
schedule | mlstring | Schedule for the event, visible for ticket buyers |
info | 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_