Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkPatientConfig | int | 4 | null |
|
|
Patient config primary key - Unique identifier for each patient configuration record |
||
| fkPatientID | int | 4 | √ | null |
|
|
Patient reference - Links to Patient table for the associated patient |
|
| fkconfigID | int | 4 | √ | null |
|
|
Configuration reference - Links to CustomConfig table for the configuration definition |
|
| DisplayOrder | int | 4 | √ | null |
|
|
Display order - Numeric order for displaying configurations in user interfaces |
|
| configID | int | 4 | null |
|
|
Config definition ID - Primary key from CustomConfig table |
||
| configDesc | varchar | 50 | √ | null |
|
|
Configuration description - Descriptive name of the configuration |
|
| configComments | varchar | 200 | √ | null |
|
|
Configuration comments - Additional notes about the configuration |
|
| configType | int | 4 | √ | null |
|
|
Configuration type - Type classification of the configuration |
|
| Temp_ID | int | 4 | √ | null |
|
|
Temporary ID - Temporary identifier for configuration processing |
Relationships
Close relationships within degrees of separation
