> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# phone table

> Contact and Person phonenumbers (+fax)

## phone Table (8)

Contact and Person phonenumbers (+fax)

## Fields

| Name                      | Description                                                            | Type                                    | Nullable |
| ------------------------- | ---------------------------------------------------------------------- | --------------------------------------- | :------: |
| phone\_id                 | Primary key                                                            | PK                                      |    No    |
| owner\_id                 | Record id of owner: Contact or Person                                  | Id                                      |    No    |
| ptype\_idx                | Bit mask, combines phone type (EPhoneType) and owner type (EOwnerType) | Enum [PhoneType](./enums/phonetype.mdx) |    No    |
| phone                     | Actual phone number as enterd by the user                              | String(239)                             |    No    |
| rank                      | Sort order                                                             | UShort                                  |    Yes   |
| description               | Visible description                                                    | String(99)                              |    Yes   |
| registered                | Registered when                                                        | UtcDateTime                             |    No    |
| registered\_associate\_id | Registered by whom                                                     | FK [associate](./associate.mdx)         |    No    |
| updated                   | Last updated when                                                      | UtcDateTime                             |    No    |
| updated\_associate\_id    | Last updated by whom                                                   | FK [associate](./associate.mdx)         |    No    |
| updatedCount              | Number of updates made to this record                                  | UShort                                  |    No    |
| validFrom                 | Valid from date for this record                                        | DateTime                                |    Yes   |
| validTo                   | Valid to date for this record                                          | DateTime                                |    Yes   |
| searchPhoneNumber         | Stripped phone number for searching, takes over for search\_phone      | String(239)                             |    Yes   |

<img src="https://mintcdn.com/superofficeas/6OcOTPa_ISkjXJg4/media/loc/en/database/tables/phone.png?fit=max&auto=format&n=6OcOTPa_ISkjXJg4&q=85&s=1c965648b641817de81b823b8077de0e" alt="phone table relationship diagram" width="583" height="575" data-path="media/loc/en/database/tables/phone.png" />

## Indexes

| Fields                | Types       | Description |
| --------------------- | ----------- | ----------- |
| rank                  | UShort      | Index       |
| owner\_id, ptype\_idx | Id, Enum    | Index       |
| searchPhoneNumber     | String(239) | Index       |

## Relationships

| Table                    | Description                                                        |
| ------------------------ | ------------------------------------------------------------------ |
| [associate](./associate) | Employees, resources and other users - except for External persons |
| [contact](./contact)     | Companies and Organizations.                                       |
| [person](./person)       | Persons                                                            |

## Replication Flags

* Area Management controlled table. Contents replicated to satellites and traveller databases.
* Replicate changes UP from satellites and travellers back to central.
* Copy to satellite and travel prototypes.

## Security Flags

* Sentry controls access to items in this table using user's Role and data rights matrix on the table's parent.


## Related topics

- [PhoneFormat table](/en/database/tables/phoneformat.md)
- [Get Phones](/en/api/reference/restful/agent/person_agent/get-phones.md)
- [Get Favorites Phones](/en/api/reference/restful/agent/phonelist_agent/get-favorites-phones.md)
- [Get Contact Phones](/en/api/reference/restful/agent/phonelist_agent/get-contact-phones.md)
- [Get Department Phones](/en/api/reference/restful/agent/phonelist_agent/get-department-phones.md)
- [Person table](/en/api/bulk-operations/bulk-update/reference/person-table.md)