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

> One batch of changes made to targets

## target\_revision Table (520)

One batch of changes made to targets

## Fields

| Name                          | Description                                            | Type                                                          | Nullable |
| ----------------------------- | ------------------------------------------------------ | ------------------------------------------------------------- | :------: |
| target\_revision\_id          | Primary key                                            | PK                                                            |    No    |
| target\_revision\_history\_id | Info about the target group this history is for        | FK [target\_revision\_history](./target-revision-history.mdx) |    Yes   |
| assignment\_info\_id          | The assignment info id - but it may have been deleted  | FK [target\_assignment\_info](./target-assignment-info.mdx)   |    Yes   |
| log\_event                    | Log event class (create, edit, delete, lock, unlock... | Enum [LogEvent](./enums/logevent.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    |

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

## Indexes

| Fields               | Types | Description |
| -------------------- | ----- | ----------- |
| assignment\_info\_id | FK    | Index       |

## Relationships

| Table                                                  | Description                                                                              |
| ------------------------------------------------------ | ---------------------------------------------------------------------------------------- |
| [associate](./associate)                               | Employees, resources and other users - except for External persons                       |
| [target\_assignment\_info](./target-assignment-info)   | Linking associate, company or user group target and other information with target values |
| [target\_change](./target-change)                      | A single field change.                                                                   |
| [target\_revision\_history](./target-revision-history) | Revision history info in case the original target group or assignment info was deleted   |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [target_revision_history table](/en/database/tables/target-revision-history.md)
- [SuperOffice.WebApi.Data.TargetRevision](/en/api/reference/webapi/SuperOffice.WebApi.Data.TargetRevision.md)
- [target_change table](/en/database/tables/target-change.md)
- [target_assignment_info table](/en/database/tables/target-assignment-info.md)
- [Create Default Target Revision](/en/api/reference/restful/agent/targets_agent/create-default-target-revision.md)
- [SuperOffice.WebApi.Data.TargetRevisionHistory](/en/api/reference/webapi/SuperOffice.WebApi.Data.TargetRevisionHistory.md)