target_revision_history table - SuperOffice

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	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	Yes
associate_id	Associate who owns this target	FK associate	Yes
usergroup_id	User group who owns this target	FK UserGroup	Yes
contact_id	Company who owns this target	FK contact	Yes
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	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	Yes

target_revision_history table relationship diagram

Indexes

Fields	Types	Description
target_assignment_info_id	FK	Index
target_group_id	FK	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
contact	Companies and Organizations.
target_assignment_info	Linking associate, company or user group target and other information with target values
target_group	Info about a set of (sales, project, selection…) targets
target_revision	One batch of changes made to targets
UserGroup	Secondary user groups

Replication Flags

None

Security Flags

No access control via user’s Role.