> ## 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.

# URL table

> Unified Resource Locators, URL to contacts, persons or projects.

## URL Table (54)

Unified Resource Locators, URL to contacts, persons or projects.

## Fields

| Name                      | Description                           | Type                            | Nullable |
| ------------------------- | ------------------------------------- | ------------------------------- | :------: |
| url\_id                   | Primary key                           | PK                              |    No    |
| contact\_id               | Relations to possible owners          | FK [contact](./contact.mdx)     |    Yes   |
| person\_id                | Relations to possible owners          | FK [person](./person.mdx)       |    Yes   |
| project\_id               | Relations to possible owners          | FK [project](./project.mdx)     |    Yes   |
| reserved\_id1             | Reserved for potential future owners  | Id                              |    Yes   |
| reserved\_id2             | Reserved for potential future owners  | Id                              |    Yes   |
| type                      | Fixed, predefined list of types       | UShort                          |    No    |
| description               | Visible field                         | String(254)                     |    No    |
| url\_address              | URL address                           | String(1023)                    |    No    |
| rank                      | Rank order in lists                   | UShort                          |    No    |
| 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    |

<img src="https://mintcdn.com/superofficeas/i6M2qZmvMNH7UTeu/media/loc/en/database/tables/URL.png?fit=max&auto=format&n=i6M2qZmvMNH7UTeu&q=85&s=74203a866fe05b7125abb6812bb8236f" alt="URL table relationship diagram" width="713" height="679" data-path="media/loc/en/database/tables/URL.png" />

## Indexes

| Fields        | Types        | Description |
| ------------- | ------------ | ----------- |
| contact\_id   | FK           | Index       |
| person\_id    | FK           | Index       |
| project\_id   | FK           | Index       |
| reserved\_id1 | Id           | Index       |
| reserved\_id2 | Id           | Index       |
| url\_address  | String(1023) | Index       |
| rank          | UShort       | Index       |

## Relationships

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

## 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

- [extra_menus table](/en/database/tables/extra-menus.md)
- [Webhook table](/en/database/tables/webhook.md)
- [config table](/en/database/tables/config.md)
- [NSPluginUrlResponse](/en/automation/crmscript/reference/CRMScript.NetServer.NSPluginUrlResponse.md)
- [document table](/en/database/tables/document.md)
- [TaskMenu table](/en/database/tables/taskmenu.md)