---
title: tm.contactaddress
slug: db/tmcontactaddress
createdAt: 2023-12-14T14:12:55.930Z
---

Each contact can have one or more addresses.

## Fields

| FIELD        | TYPE        | DESCRIPTION                                                                                                                                                                       |
| ------------ | ----------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| id           | `int`       | ID                                                                                                                                                                                |
| createdts    | `timestamp` | Created timestamp                                                                                                                                                                 |
| lastupdatets | `timestamp` | Last update timestamp                                                                                                                                                             |
| contactid    | `int`       | Contact this address is linked to<br />**References:** [tm.contact](docId\:uFIX35lrtF5E4t_ERzoMr)                                                                                 |
| typeid       | `int`       | Type of address<br />**References:** [tm.contactaddresstype](docId:8t0ELY4YYLUgZr5J-m4Nr)                                                                                         |
| street1      | `string`    | Street                                                                                                                                                                            |
| street2      | `string`    | Number                                                                                                                                                                            |
| street3      | `string`    | Box                                                                                                                                                                               |
| street4      | `string`    | Extra address line                                                                                                                                                                |
| zip          | `string`    | Zipcode                                                                                                                                                                           |
| city         | `string`    | City                                                                                                                                                                              |
| state        | `string`    | State                                                                                                                                                                             |
| countrycode  | `string`    | Country code. Should be an [ISO 3166-1 alpha-2](http://en.wikipedia.org/wiki/ISO_3166-1_alpha-2) two-letter code.<br />**References:** [tm.country](docId\:eQC87riPPHaKuHRCoWdpb) |
| sortorder    | `int`       | Sort order for the addresses. The address with sort order 0 is de main address                                                                                                    |