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

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