target_revision table - SuperOffice

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	Yes
assignment_info_id	The assignment info id - but it may have been deleted	FK target_assignment_info	Yes
log_event	Log event class (create, edit, delete, lock, unlock…	Enum LogEvent	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

Indexes

Fields	Types	Description
assignment_info_id	FK	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
target_assignment_info	Linking associate, company or user group target and other information with target values
target_change	A single field change.
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.