OutsidesourceInProgramType


Description

Outside source program associations linking external sources to specific program types for service delivery and referral management. This junction table manages the relationship between outside sources and program types, supporting program-specific external relationships, referral networks, and service coordination for healthcare delivery and community partnerships.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
sourceid int 4 √ null
OutsideSource.SourceID FK__Outsideso__sourc__0AB36FCB C

Source reference - Links to OutsideSource table for the external source (foreign key to OutsideSource.SourceID)
ProgramID int 4 √ null

Program reference - Links to program type that this outside source is associated with

Relationships

Close relationships within degrees of separation