---
title: tm.event
slug: db/tmevent
createdAt: 2023-12-14T14:12:43.690Z
---

The list of events in the system. Each event has a number of linked [tickettypes](docId\:cd8xjLoJJt5o0drcPbNYA) and each tickettype has a number of linked [tm.ticket](docId\:Ng_G3ImT5NlU1CH0cq7BG)

## 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<br />**References:** [tm.seatingplan](docId\:XxWm0XNJ3vbGKSTqtjXpb)                                |
| seatingplanpricelistid         | `int`       | Link to the seatingplan pricelist<br />**References:** [tm.pricelist](docId:7lxHTZdDwnza74oorm3Hd)                         |
| 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<br />**References:** [tm.production](docId\:aomO0EwxSiROkPipj4n04)                           |
| locationid                     | `int`       | Link to the event location<br />**References:** [tm.eventlocation](docId\:Z8wgiIaAjhKjUOXvinBID)                           |
| ticketfeeid                    | `int`       | Link to the ticket fee scheme to be applied for the event<br />**References:** [tm.ticketfee](docId:_436HsRa0Of6UhDYMtnBp) |
| 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<br />**References:** [tm.ticketlayout](docId\:Kgu8nQ4ojYzF-QsWse55j) |
| typeid                         | `int`       | The type of event. See systemtype category 15xx<br />**References:** [tm.systemtype](docId\:YVf7OQ_iruf6NpUOHG2XQ)         |
| 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_`