ActionMessage


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ActionMessageSeq int identity 4 √ null
ActionMessageSubscriber.ActionMessageSeq FK_ActionMessageSubscriber_ActionMessageSeq_ActionMessage_ActionMessageSeq R
CreatedDateTime datetime 16,3 (getdate())
MessageTypeCode varchar 50 null
ActionMessageType.Code FK_ActionMessage_MessageTypeCode_ActionMessageType_Code R
TargetUserID int 4 √ null
Community.ID FK_ActionMessage_TargetUserID_Community_ID R
TasksSeq int 4 √ null
Tasks.TasksSeq FK_ActionMessage_TasksSeq_Tasks_TasksSeq R
MessageErrorFlag bit 1 ((0))
Summary varchar 255 ('')
ExternalFlag bit 1 ((0))
OriginatorSystem varchar 200 ('')
OriginatorUser varchar 200 ('')
OriginatorUserID int 4 √ null
OriginatorSchool varchar 200 ('')
OriginatorCreated datetime 16,3 (getdate())
Source varchar 200 ('')
SourceKey int 4 √ null
DatabaseCode varchar 15 null
Reference sysname 256 ('')
ReferenceKey varchar 200 ('')
ActionedDateTime datetime 16,3 √ null
ActionedByUserID int 4 √ null
Community.ID FK_ActionMessage_ActionedByUserID_Community_ID R
MessageText nvarchar 1073741823 √ null
CheckSumValue int 4 √ null
DuplicateFlag bit 1 ((0))
XMLData xml 1073741823 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_ActionMessage Primary key Asc ActionMessageSeq
AK_ActionMessage_ActionMessagesSeq_Covering Performance Asc ActionMessageSeq
AK_ActionMessage_Clustered Performance Asc/Asc/Asc/Asc ActionMessageSeq + CreatedDateTime + MessageTypeCode + TargetUserID
AK_ActionMessage_MessageTypeCode Performance Asc MessageTypeCode
AK_ActionMessage_Reference Performance Asc Reference
AK_ActionMessage_ReferenceKey Performance Asc ReferenceKey
AK_ActionMessage_TargetUserID Performance Asc TargetUserID
AK_ActionMessage_TasksSeq Performance Asc TasksSeq

Relationships

Close relationships within degrees of separation