tblTERTIARY_REFERRALS


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TertiaryReferralID int identity 4 √ null
tblTERTIARY_REFERRALS_IPTF.TertiaryReferralID FK_tblTERTIARY_REFERRALS_IPTF_tblTERTIARY_REFERRALSR
tblTERTIARY_REFERRALS_SENT.TertiaryReferralID FK_tblTERTIARY_REFERRALS_SENT_tblTERTIARY_REFERRALSR
TertiaryReferralReturns.TertiaryReferralID FK_TertiaryReferralReturns_tblTERTIARY_REFERRALSR
CareID int 4 √ null
ReferringOrgID int 4 √ null
ReceivingOrgID int 4 √ null
ReasonID int 4 √ null
Comments varchar 2147483647 √ null
ACTION_ID int 4 √ null
IsTransferOfCare bit 1 null
PayloadID int 4 √ null
tblTERTIARY_REFERRALS_ELECTRONIC.ID FK_tblTERTIARY_REFERRALS_PayloadIDR

Indexes

Constraint Name Type Sort Column(s)
PK_tblTERTIARY_REFERRALS Primary key Asc TertiaryReferralID
IX_tblTERTIARY_REFERRALS_CareID Performance Asc CareID
IX_tblTERTIARY_REFERRALS_CareID_Temp Performance Asc CareID
IX_TR_PayloadID Performance Asc PayloadID
UQ_tblTERTIARY_REFERRALS_PayloadID Must be unique Asc PayloadID

Relationships

Close relationships within degrees of separation