--- title: tm.ticket slug: db/tmticket createdAt: 2023-12-14T14:10:59.086Z --- Ticket contains all tickets defined for contingents. At contingent creation time the required number of tickets are created immediately. A ticket is added to an order by updating the field orderid. ## Fields | FIELD | TYPE | DESCRIPTION | | ------------------------------------ | ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | id | `int` | ID | | tickettypeid | `int` | Link to the contingent this ticket belongs to
**References:** [tm.tickettype](#) | | seatzoneid | `int` | Optional seatzone for the ticket | | seatzonename | `string` | Zone name for the ticket (only for seated tickets) | | seatrownumber | `string` | Row number for the ticket (only for seated tickets) | | seatseatnumber | `string` | Seat number for the ticket (only for seated tickets) | | seatdescription | `mlstring` | The seat description for this ticket (only for seated tickets) | | seatcoordinatex | `int` | DEPRECATED: No longer in use. | | seatcoordinatey | `int` | DEPRECATED: No longer in use. | | seatpriority | `int` | Number indicating the priority for this ticket for the best available algorithm. Tickets with a higher priority will be considered first when performing a best available allocation. | | currentstatus | `int` | Current status for the ticket. null = available, 101 = reserved/sold, 103 = delivered, 104 = locked | | orderid | `int` | Link to the order the ticket is contained in
**References:** [tm.order](#) | | orderprice | `decimal` | DEPRECATED: Use price instead. | | orderfee | `decimal` | Fee for the ticket in the order | | ordertickettypepriceid | `int` | DEPRECATED: Use tickettypepriceid instead.
**References:** [tm.tickettypeprice](#) | | orderticketholderid | `int` | DEPRECATED: Use ticketholderid instead.
**References:** [tm.contact](#) | | price | `decimal` | Price for the ticket in the order (without fee) | | ticketname | `string` | Optional name on the ticket | | ticketholderid | `int` | Optional link to the contact that is the ticketholder for this ticket | | ticketholdername | `string` | DEPRECATED: Use ticketholderid | | tickettypepriceid | `int` | Link to the tickettypeprice that is assigned to this ticket for the order. Through the tickettypeprice you can retrieve the pricetype | | bundleid | `int` | Link to the bundle (orderproduct) that this ticket belongs to. | | vouchercodeid | `int` | Link to the vouchercode that was used to reserve this ticket.
**References:** [tm.vouchercode](#) | | barcode | `string` | 12-digit unique code that is used for generating a barcode for the ticket | | locktypeid | `int` | Link to the locktype used for locking the ticket (currentstatus will be 104)
**References:** [tm.locktype](#) | | previouslocktypeid | `int` | Link to the previous locktype | | accesscontrolstatus | `int` | The access control status for this ticket. 0 means not scanned, 1 means succesful entry, 2 means succesful exit | | accesscontrollastenteredts | `timestamp` | The timestamp of the last succesful entry with this ticket | | accesscontrollastexitts | `timestamp` | The timestamp of the last succesful exit with this ticket | | accesscontrollastenteredscandeviceid | `int` | The id of the scanner used for the last succesful entry | | accesscontrollastexitscandeviceid | `int` | The id of the scanner used for the last succesful exit | | deliveredts | `timestamp` | The tmestamp of the last delivery of this ticket | | properties | `json` | String to string key-value mapping of properties | | transferredto | `int` | Link to the contact the ticket was transferred to ticket | This table can also contain one or more customfields. Each customfield starts with `c_`