Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ProgramID | int identity | 4 | null |
|
|
Program identifier - Unique identifier for each healthcare program type |
||
| ProgramName | varchar | 255 | √ | null |
|
|
Program name - Descriptive name of the healthcare program type |
|
| securityOrder | int | 4 | √ | null |
|
|
Security order - Numeric order for security-based program sorting and access control |
|
| userID | int | 4 | √ | null |
|
|
User reference - Links to AccessUser table for the user with access to this program |
|
| groupID | int | 4 | √ | null |
|
|
Group reference - Links to user group that has access to this program type |
Relationships
Close relationships within degrees of separation
