---
title: tm.contact
slug: db/tmcontact
createdAt: 2023-12-11T14:39:33.271Z
---

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<br />**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_`