eReferralMessages


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int identity 4 √ null
eReferralMessageAmendments.MessageID FK_eReferralMessageAmendments_eReferralMessageAmendmentsC
eReferralMessageErrors.MessageID FK_eReferralMessageErrors_eReferralMessagesC
MirthID int 4 √ null
ControlID varchar 50 √ null
MRN varchar 20 null
NHS varchar 10 √ null
VisitNumber varchar 20 √ null
PlacerID varchar 20 √ null
Type int 4 null
eReferralMessageType.ID FK_eReferralMessages_eReferralMessageTypeR
Status int 4 null
eReferralProcessingStatus.ID FK_eReferralMessages_eReferralProcessingStatusR
Message xml 1073741823 null
ReceivedOn datetime 16,3 null
ProcessedOn datetime 16,3 √ null
AmendedBy uniqueidentifier 16 √ null
DEPRECATED_21_02_aspnet_Users.UserId FK_eReferralMessages_aspnet_Users_AmendmentsR
RejectedOn datetime 16,3 √ null
RejectedBy uniqueidentifier 16 √ null
DEPRECATED_21_02_aspnet_Users.UserId FK_eReferralMessages_aspnet_UsersR
CareID int 4 √ null
PatientID int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_eReferralMessages Primary key Asc ID
IX_eReferralMessages_HospitalNumberThenType Performance Asc/Asc MRN + Type
IX_eReferralMessages_Type Performance Asc/Asc/Asc/Asc Type + MRN + NHS + Status
IX_eReferralMessages_TypeThenStatus Performance Asc/Asc Type + Status
IX_eReferralMessages_VisitNumberThenPlacerID Performance Asc/Asc VisitNumber + PlacerID

Relationships

Close relationships within degrees of separation