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

# History table

> History lists for lists and searchable controls. Maintains history for Navigator or other search (find dialogs). A single table may have more than one record here, as indicated by the extra_id field. The HistorySize (preference may be set in maintenance client) defines how many records you can have in a history list.

## History Table (53)

History lists for lists and searchable controls. Maintains history for Navigator or other search (find dialogs). A single table may have more than one record here, as indicated by the extra\_id field. The HistorySize (preference may be set in maintenance client) defines how many records you can have in a history list.

## Fields

| Name          | Description                                                 | Type                            | Nullable |
| ------------- | ----------------------------------------------------------- | ------------------------------- | :------: |
| history\_id   | Primary key                                                 | PK                              |    No    |
| associate\_id | Owner of history list                                       | FK [associate](./associate.mdx) |    No    |
| table\_id     | Table this is a history of                                  | TableNumber                     |    No    |
| record\_id    | Record within the table                                     | RecordId                        |    No    |
| extra\_id     | Extra ID, used to manage multiple histories per table       | Id                              |    No    |
| rank          | Sort order, indexed so it can used for sorting in the query | UShort                          |    No    |
| updatedCount  | Number of updates made to this record                       | UShort                          |    No    |

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

## Indexes

| Fields                              | Types               | Description |
| ----------------------------------- | ------------------- | ----------- |
| rank                                | UShort              | Index       |
| associate\_id, table\_id, extra\_id | FK, TableNumber, Id | Index       |

## Relationships

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

## Replication Flags

* Copy to satellite and travel prototypes.

## Security Flags

* No access control via user's Role.


## Related topics

- [Save Histories](/en/api/reference/restful/agent/viewstate_agent/save-histories.md)
- [Get History](/en/api/reference/restful/agent/viewstate_agent/get-history.md)
- [NSHistory](/en/automation/crmscript/reference/CRMScript.NetServer.NSHistory.md)
- [Get Histories](/en/api/reference/restful/agent/viewstate_agent/get-histories.md)
- [navigation_history table](/en/database/tables/navigation-history.md)
- [ticket_status_history table](/en/database/tables/ticket-status-history.md)