Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| agPrefID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each preference setting |
|
| prefID | int | 4 | √ | null |
|
|
Preference type - Links to preference definition for the type of setting |
|
| ProgramTypeID | int | 4 | √ | null |
|
|
Program type - Links to program type if preference is program-specific |
|
| yesNo | int | 4 | √ | null |
|
|
Boolean value - Yes/No or numeric value for the preference setting |
|
| IDType | int | 4 | √ | null |
|
|
ID type preference - Preferred ID type for patient identification in this context |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__AgencyPreference__691D71D6 | Primary key | Asc | agPrefID |
| IX_PrefID | Performance | Asc/Asc | prefID + yesNo |
| IX_ProgramTypeID | Performance | Asc | ProgramTypeID |
Relationships
Close relationships within degrees of separation
