tblLinkedReferrals


Columns

Column Type Size Nulls Auto Default Children Parents Comments
OriginalCareID int 4 null
tblMAIN_REFERRALS.CARE_ID FK_tblLinkedReferrals_tblMAIN_REFERRALSR
LinkedCareID int 4 null
tblMAIN_REFERRALS.CARE_ID FK_tblLinkedReferrals_tblMAIN_REFERRALS1R
PatientID int 4 null
tblDEMOGRAPHICS.PATIENT_ID FK_tblLinkedReferrals_tblDEMOGRAPHICSR
LinkTypeID int 4 null
ltblReferralLinkType.LinkTypeID FK_tblLinkedReferrals_ltblReferralLinkTypeR

Indexes

Constraint Name Type Sort Column(s)
PK_tblLinkedReferrals Primary key Asc/Asc OriginalCareID + LinkedCareID

Relationships