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

AssociateHistory Table (507)

Some tooltip text!
• 1 minute to read
 • 1 minute to read

Historical information about associates that have been deleted. Most references are NOT declared as foreign keys; this is a historical table that should not be updated when further changes occur in the database

Fields

Name Description Type Null
associatehistory_id Primary key PK
associateId The original primary key of the deleted associate Int ●
groupId The group id Int ●
personId The person id Int ●
type Associate type Enum AssociateType ●
originalRegistered Registered when UtcDateTime ●
locationAddress Address of location, if this is a resource that is a location String(239) ●
ejUserId The ejuser reference, if any Int ●
name The associate name/initials String(255) ●
firstname First name String(99) ●
middleName Middle name or 'van' etc. String(99) ●
lastname Last name String(99) ●
contactId The original contact_id Int ●
registered Registered when UtcDateTime
registered_associate_id Registered by whom FK associate

AssociateHistory table relationship diagram

Indexes

Fields Types Description
associatehistory_id PK Clustered, Unique

Relationships

Table Description
associate Employees, resources and other users - except for External persons

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