PatientInCustomConfig


Description

Patient custom configuration associations linking patients to specific custom configuration options for personalized system behavior and data collection. This junction table manages patient-specific configuration settings including display order and configuration associations, supporting personalized patient data collection, custom form behavior, and patient-specific system configurations for healthcare services.

Columns

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

Primary key - Unique identifier for each patient configuration association
fkPatientID int 4 √ null
Patient.PatientID FK__PatientInCustomConfig__Patient C

Patient reference - Links to Patient table for the patient receiving custom configuration (foreign key to Patient.PatientID)
fkconfigID int 4 √ null
CustomConfig.configID FK__PatientInCustomConfig__CustomConfig C

Configuration reference - Links to CustomConfig table for the configuration option (foreign key to CustomConfig.configID)
DisplayOrder int 4 √ null

Display order - Numeric order for displaying configuration options for this patient

Indexes

Constraint Name Type Sort Column(s)
PK_PatientInCustomConfig Primary key Asc pkPatientConfig

Relationships

Close relationships within degrees of separation