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

# target_revision_history table

> Revision history info in case the original target group or assignment info was deleted

## target\_revision\_history Table (519)

Revision history info in case the original target group or assignment info was deleted

## Fields

| Name                          | Description                                                                    | Type                                                        | Nullable |
| ----------------------------- | ------------------------------------------------------------------------------ | ----------------------------------------------------------- | :------: |
| target\_revision\_history\_id | Primary key                                                                    | PK                                                          |    No    |
| target\_group\_id             | The group id - but it may not still exist                                      | FK [target\_group](./target-group.mdx)                      |    Yes   |
| year                          | The year this set of targets are associated with (2020, 2021...)               | Int                                                         |    Yes   |
| entity\_type                  | Entity type for this set of targets (Sale, Project, Selection, Appointment...) | Enum [TargetEntityType](./enums/targetentitytype.mdx)       |    Yes   |
| associate\_id                 | Associate who owns this target                                                 | FK [associate](./associate.mdx)                             |    Yes   |
| usergroup\_id                 | User group who owns this target                                                | FK [UserGroup](./usergroup.mdx)                             |    Yes   |
| contact\_id                   | Company who owns this target                                                   | FK [contact](./contact.mdx)                                 |    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    |
| target\_assignment\_info\_id  | TargetAssignmentInfo associated with the logged info                           | FK [target\_assignment\_info](./target-assignment-info.mdx) |    Yes   |

<img src="https://mintcdn.com/superofficeas/8-OIGQQJR0VGDXy_/media/loc/en/database/tables/target_revision_history.png?fit=max&auto=format&n=8-OIGQQJR0VGDXy_&q=85&s=ef3272b4f19fb9c84525b5ce97e9d710" alt="target_revision_history table relationship diagram" width="883" height="753" data-path="media/loc/en/database/tables/target_revision_history.png" />

## Indexes

| Fields                       | Types | Description |
| ---------------------------- | ----- | ----------- |
| target\_assignment\_info\_id | FK    | Index       |
| target\_group\_id            | FK    | Index       |

## Relationships

| Table                                                | Description                                                                              |
| ---------------------------------------------------- | ---------------------------------------------------------------------------------------- |
| [associate](./associate)                             | Employees, resources and other users - except for External persons                       |
| [contact](./contact)                                 | Companies and Organizations.                                                             |
| [target\_assignment\_info](./target-assignment-info) | Linking associate, company or user group target and other information with target values |
| [target\_group](./target-group)                      | Info about a set of (sales, project, selection...) targets                               |
| [target\_revision](./target-revision)                | One batch of changes made to targets                                                     |
| [UserGroup](./usergroup)                             | Secondary user groups                                                                    |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [target_revision table](/en/database/tables/target-revision.md)
- [SuperOffice.WebApi.Data.TargetRevisionHistory](/en/api/reference/webapi/SuperOffice.WebApi.Data.TargetRevisionHistory.md)
- [Create Default Target Revision History](/en/api/reference/restful/agent/targets_agent/create-default-target-revision-history.md)
- [SuperOffice.WebApi.Agents.TargetsAgent](/en/api/reference/webapi/SuperOffice.WebApi.Agents.TargetsAgent.md)
- [SuperOffice.WebApi.Agents.ITargetsAgent](/en/api/reference/webapi/SuperOffice.WebApi.Agents.ITargetsAgent.md)
- [Get Target Revision History](/en/api/reference/restful/agent/targets_agent/get-target-revision-history.md)