Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ProviderName | varchar | 101 | √ | null |
|
|
Provider full name - Combined first and last name of the healthcare provider |
|
| AccessUserID | int | 4 | √ | null |
|
|
Provider user ID - Links to AccessUser table for the healthcare provider |
|
| PatientID | int | 4 | √ | null |
|
|
Patient identifier - Links to Patient table for the patient assigned to this provider |
|
| GroupID | int | 4 | √ | null |
|
|
Provider group ID - Links to user group classification for the provider |
