Message Table (242)
•
Environment: onsite, online
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 |
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.