DemographicInterfaceMessages


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null
DemographicInterfaceMessageAmendments.MessageId FK_dbo.DemographicInterfaceMessageAmendments_dbo.DemographicInterfaceMessages_MessageIdC
DemographicInterfaceMessageErrors.MessageId FK_dbo.DemographicInterfaceMessageErrors_dbo.DemographicInterfaceMessages_MessageIdC
MirthId int 4 null
ControlID nvarchar 100 √ null
HospitalNumber nvarchar 40 √ null
NhsNumber nvarchar 20 √ null
StatusId int 4 null
MessageStatus.Id FK_dbo.DemographicInterfaceMessages_dbo.MessageStatus_StatusIdC
Message xml 1073741823 √ null
ReceivedOn datetime 16,3 null
ProcessedOn datetime 16,3 √ null
AmendedBy nvarchar 100 √ null
RejectedOn datetime 16,3 √ null
RejectedBy nvarchar 100 √ null
PatientId int 4 √ null
_Deprecated_20_03_PatientPreferredContact.PatientId Implied ConstraintR

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.DemographicInterfaceMessages Primary key Asc Id
IX_StatusId Performance Asc StatusId

Relationships

Close relationships within degrees of separation