tm.contact

1 min

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_