---
title: tm.contactphonenumber
slug: db/tmcontactphonenumber
createdAt: 2023-12-14T14:12:52.330Z
---

Phone numbers for contacts. Each contact can have one or more phone numbers.

## Fields

| FIELD        | TYPE        | DESCRIPTION                                                                                                  |
| ------------ | ----------- | ------------------------------------------------------------------------------------------------------------ |
| id           | `int`       | ID                                                                                                           |
| createdts    | `timestamp` | Created timestamp                                                                                            |
| lastupdatets | `timestamp` | Last update timestamp                                                                                        |
| contactid    | `int`       | Link to the contact<br />**References:** [tm.contact](docId\:uFIX35lrtF5E4t_ERzoMr)                          |
| typeid       | `int`       | Link to the phone number type<br />**References:** [tm.contactphonenumbertype](docId\:RQjkbEJRyX9qCrY8IQxWR) |
| phonenumber  | `string`    | The actual phone number                                                                                      |
| sortorder    | `int`       | Sort order for the phone numbers. The address with sort order 0 is de main address                           |