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

MessageHandler Table (241)

Some tooltip text!
• 2 minutes to read
 • 2 minutes to read

Presence and heartbeat of a message handler, should be updated once a minute. Older records are stale

Fields

Name Description Type Null
MessageHandler_id Primary key PK
uniqueIdentifier GUID identifying the handler, generated by the handler when it starts String(39)
machine Machine the handler is running on String(254)
port UDP port this handler is listening on UInt
processIdLow Low word of process id of the message handler process UInt
processIdHigh High word of process id of the message handler process UInt
role 1 = request, 2 = respond, 4 = route (bitmapped flags) Int
registered Registered when UtcDateTime
registered_associate_id Registered by whom FK associate
updated 'heartbeat' that is updated once a minute by the batch task process UtcDateTime
updated_associate_id 'heartbeat' that is updated once a minute by the batch task process FK associate
updatedCount 'heartbeat' that is updated once a minute by the batch task process UShort

MessageHandler table relationship diagram

Indexes

Fields Types Description
MessageHandler_id PK Clustered, Unique
uniqueIdentifier String(39) Unique
machine String(254) Index

Relationships

Table Description
associate Employees, resources and other users - except for External persons
Message Definition of a message, corresponding to the header of a protocol

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