SiteInProgramType


Description

Site program type associations linking agency sites to specific program types for service delivery and organizational management. This junction table manages the relationship between sites and programs including site identifiers and program associations to support multi-site program management, service delivery coordination, and organizational structure for healthcare and early intervention services.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
SPID int identity 4 √ null
UserInSite.SPID FK__UserInSite__SPID__13D2C5B1 C

Primary key - Unique identifier for each site-program association
siteid int 4 √ null
AgencySite.SiteID FK__SiteInPro__sitei__11EA7D3F C

Site reference - Links to AgencySite table for the service delivery site
ProgramID int 4 √ null

Program reference - Links to program type that operates at this site

Indexes

Constraint Name Type Sort Column(s)
PK__SiteInProgramTyp__10F65906 Primary key Asc SPID

Relationships

Close relationships within degrees of separation