• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

target_revision_history Table (501)

Some tooltip text!
• 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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top