CustomConfig


Description

System configuration items defining customizable configuration options, business rules, and system settings. This flexible configuration table enables system administrators to customize system behavior, define business rules, and manage configurable options across different program types and disciplines.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
configID int identity 4 √ null
CustomConfigInDiscipline.fkConfigID FK__CustomCon__fkCon__22028025 R
CustomConfigInProgType.fkconfigID FK__CustomConfigInProgType__CustomConfig C
Goal.fkConfigIDA FK_Goal_CustomConfig3 R
Goal.fkConfigIDM FK_Goal_CustomConfig R
Goal.fkConfigIDP FK_Goal_CustomConfig2 R
Goal.fkConfigIDR FK_Goal_CustomConfig1 R
Objective.fkConfigIDA FK_Objective_CustomConfig1 R
Objective.fkConfigIDC FK_Objective_CustomConfig2 R
Objective.fkConfigIDP FK_Objective_CustomConfig3 R
Objective.fkConfigIDT FK_Objective_CustomConfig R
ObjectiveInGoal.fkObjectiveID FK__Objective__fkObj__4FFE54FF R
PatientInCustomConfig.fkconfigID FK__PatientInCustomConfig__CustomConfig C
UserInCustomConfig.fkconfigID FK__UserInCustomConfig__CustomConfig C

Primary key - Unique identifier for each configuration item
configDesc varchar 50 √ null

Configuration description - Descriptive name of the configuration option
configComments varchar 200 √ null

Configuration comments - Additional details about the configuration item
configType int 4 √ null

Configuration type - Type or category of configuration (System, User, Patient, etc.)
Temp_ID int 4 √ null

Temporary ID - Temporary identifier for data migration or processing
fkConfigID int 4 √ null

Parent config reference - Links to parent configuration for hierarchical settings
fkPatientID int 4 √ null
Patient.PatientID FK_CustomConfig_Patient R

Patient reference - Links to Patient table if configuration is patient-specific
fkProviderID int 4 √ null
AccessUser.UserID FK_CustomConfig_AccessUser R

Provider reference - Links to AccessUser table if configuration is provider-specific
Deleted bit 1 √ ((0))

Deleted flag - Soft delete flag for audit trail purposes

Indexes

Constraint Name Type Sort Column(s)
PK__CustomConfig__4C77DCDE Primary key Asc configID
IX_ConfigID Performance Asc configID
IX_fkConfigID Performance Asc fkConfigID

Relationships

Close relationships within degrees of separation