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

# OnlineApp table

> Echo and track information about Online Apps and their usage

## OnlineApp Table (510)

Echo and track information about Online Apps and their usage

## Fields

| Name                      | Description                                              | Type                            | Nullable |
| ------------------------- | -------------------------------------------------------- | ------------------------------- | :------: |
| onlineapp\_id             | Primary key                                              | PK                              |    No    |
| clientId                  | ID that uniquely identifies the app                      | String(255)                     |    No    |
| displayName               | Name to be displayed in user interface                   | String(255)                     |    Yes   |
| partnerName               | Name of the partner who owns the app                     | String(255)                     |    Yes   |
| authorizationRevoked      | Has the authorization for this app been revoked          | Bool                            |    Yes   |
| lastUsed                  | Last app use date (not time, to reduce number of writes) | DateTime                        |    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    |

<img src="https://mintcdn.com/superofficeas/zNQa3AO19PFK63SB/media/loc/en/database/tables/OnlineApp.png?fit=max&auto=format&n=zNQa3AO19PFK63SB&q=85&s=0f9accdcf3e5b25cba113b4afeb47df6" alt="OnlineApp table relationship diagram" width="630" height="59" data-path="media/loc/en/database/tables/OnlineApp.png" />

## Indexes

| Fields   | Types       | Description |
| -------- | ----------- | ----------- |
| clientId | String(255) | Unique      |

## Relationships

| Table                    | Description                                                        |
| ------------------------ | ------------------------------------------------------------------ |
| [associate](./associate) | Employees, resources and other users - except for External persons |
| [Message](./message)     | Definition of a message, corresponding to the header of a protocol |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [Message table](/en/database/tables/message.md)
- [What's new in version 10.3.9.718](/release-notes/database/changes-10.3.9.md)
- [What's new in version 10.5.1.1092](/release-notes/database/changes-10.5.1.md)
- [What's new in version 10.5.2.435](/release-notes/database/changes-10.5.2.md)
- [What's new in version 10.5.3.711](/release-notes/database/changes-10.5.3.md)
- [What's new in version 10.5.4.867](/release-notes/database/changes-10.5.4.md)