Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PrescriptionID | int identity | 4 | √ | null |
|
|
Prescription primary key - Unique identifier for each prescription or treatment order |
|
| AuthId | int | 4 | null |
|
|
Authorization reference - Links to Authorize table for the associated service authorization |
||
| StartDate | datetime | 16,3 | √ | null |
|
|
Prescription start date - Date when the prescription or treatment begins |
|
| EndDate | datetime | 16,3 | √ | null |
|
|
Prescription end date - Date when the prescription or treatment expires |
|
| TreatingProviderId | int | 4 | √ | null |
|
|
Treating provider reference - Links to AccessUser table for the provider delivering treatment |
|
| OrderingProviderId | int | 4 | √ | null |
|
|
Ordering provider reference - Links to AccessUser table for the provider who ordered the prescription |
|
| Comment | varchar | 2147483647 | √ | null |
|
|
Prescription comments - Detailed notes and instructions about the prescription or treatment |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this prescription record |
|
| AutoAssignOrderingProvider | bit | 1 | √ | null |
|
|
Auto-assign flag - Indicates if ordering provider should be automatically assigned |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation date - Date when this prescription record was created |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last update date - Date when this prescription was last modified |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated this prescription |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when this prescription was soft deleted |
|
| DeletedBy | int | 4 | √ | null |
|
|
Deleted by user - UserID of the person who deleted this prescription |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| IX_AuthId | Performance | Asc | AuthId |
| IX_PrescriptionId | Performance | Asc | PrescriptionID |
Relationships
Close relationships within degrees of separation
