> ## Documentation Index
> Fetch the complete documentation index at: https://superofficeas-bugfix-ty-screen-designer-paradox.mintlify.site/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-bugfix-ty-screen-designer-paradox/bBv7ep-d5A4oaYwj/media/loc/en/database/tables/phone.png?fit=max&auto=format&n=bBv7ep-d5A4oaYwj&q=85&s=0e204947e62b663f713d92db09ed1b75" 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.