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	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

This table can also contain one or more customfields. Each customfield starts with c_