PatientDiagnosServiceType


Description

Patient diagnosis service type associations linking patient diagnoses to specific service types for treatment planning and service coordination. This junction table manages the relationship between patient diagnoses and applicable service types, supporting diagnosis-based service planning, treatment coordination, and appropriate service delivery for patient care management.

Columns

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

Primary key - Unique identifier for each diagnosis-service type association
DiagId int 4 √ null

Diagnosis reference - Links to patient diagnosis record
ServiceTypeId int 4 √ null

Service type reference - Links to iCS2.dbo.ServiceType for centralized service type definitions that apply to this diagnosis

Indexes

Constraint Name Type Sort Column(s)
PK__PatientD__3214EC273FFAC725 Primary key Asc ID

Relationships

Close relationships within degrees of separation