tm.event

the list of events in the system each event has a number of linked tm tickettype 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 references tm seatingplan docid\ xxwm0xnj3vbgkstqtjxpb seatingplanpricelistid int link to the seatingplan pricelist 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 references tm production docid\ aomo0ewxsirokpipj4n04 locationid int link to the event location references tm eventlocation docid\ z8wgiiaajhkjuoxvinbid ticketfeeid int link to the ticket fee scheme to be applied for the event 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 references tm ticketlayout docid\ kgu8nq4ojyzf qswse55j typeid int the type of event see systemtype category 15xx 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