target_revision_history Table (502)

•
Environment: onsite, online
• 2 minutes to read
 • 2 minutes to read

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

Fields

Name Description Type Null
target_revision_history_id Primary key PK
target_group_id The group id - but it may not still exist FK target_group ●
year The year this set of targets are associated with (2020, 2021...) Int ●
entity_type Entity type for this set of targets (Sale, Project, Selection, Appointment...) Enum TargetEntityType ●
associate_id Associate who owns this target FK associate ●
usergroup_id User group who owns this target FK UserGroup ●
contact_id Company who owns this target FK contact ●
registered Registered when UtcDateTime
registered_associate_id Registered by whom FK associate
updated Last updated when UtcDateTime
updated_associate_id Last updated by whom FK associate
updatedCount Number of updates made to this record UShort
target_assignment_info_id TargetAssignmentInfo associated with the logged info FK target_assignment_info ●

target_revision_history table relationship diagram

Indexes

Fields Types Description
target_revision_history_id PK Clustered, Unique
target_group_id FK Unique
target_assignment_info_id FK Index

Relationships

Table Description
associate Employees, resources and other users - except for External persons
contact Companies and Organizations. This table features a special record containing information about the contact that owns the database.
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.