PatientInOutsideSource


Description

Patient outside source associations linking patients to external sources and referral agencies for service coordination and referral management. This junction table manages relationships between patients and outside sources including comments and source information, supporting referral tracking, external service coordination, and comprehensive patient care management across multiple providers.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
POS int identity 4 √ null

Primary key - Unique identifier for each patient-outside source association
fkPatientID int 4 √ null
Patient.PatientID FK__PatientIn__fkPat__57DEA292 C

Patient reference - Links to Patient table for the patient associated with the outside source (foreign key to Patient.PatientID)
fkSourceID int 4 √ null

Source reference - Links to outside source or referral agency
srcComments varchar 500 √ null

Source comments - Comments or notes about the patient’s relationship with this outside source

Indexes

Constraint Name Type Sort Column(s)
PK__PatientInOutside__56EA7E59 Primary key Asc POS

Relationships

Close relationships within degrees of separation