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

Message Table (242)

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

Definition of a message, corresponding to the header of a protocol

Fields

Name Description Type Null
Message_id Primary key PK
sourceHandler Originating message handler FK MessageHandler
targetHandler Target message handler FK MessageHandler
motherId ID of message that this message is correlated to; 0 if this is the first message of a conversation FK Message ●
messageType Application-specific message type UInt
detailsTable Table containing message body (BatchTask, or some thing else) TableNumber
detailsRecord Record containing message body RecordId
description Message description, to aid in debugging and monitoring String(254)
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

Message table relationship diagram

Indexes

Fields Types Description
Message_id PK Clustered, Unique
sourceHandler FK Index
targetHandler FK Index
motherId FK 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
MessageHandler Presence and heartbeat of a message handler, should be updated once a minute. Older records are stale

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