tm.contact

a contact is one of the main entities in ticketmatic it represents a specific person or organisation a contact can either be part of the audience or be part of your relations fields field type description id int id createdts timestamp created timestamp lastupdatets timestamp last update timestamp firstname string first name middlename string middle name lastname string last name titleid int deprecated, use customertitleid references tm contacttitle customertitleid int customer title id (also determines the gender of the contact) company string contains the company name if the contact is a company name vatnumber string vat number (for organizations) organizationfunction string job function sex string sex values can be m (male), f (female) or u (unspecified) email string e mail address languagecode string preferred language birthdate timestamp birthdate isdeleted boolean whether this contact is deleted or not applastusagets timestamp last time the contact used the ticketmatic app this table can also contain one or more customfields each customfield starts with c