Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PrescriptionID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each prescription, auto-incrementing integer |
|
| AuthId | int | 4 | null |
|
|
Authorization reference - Foreign key linking to authorization record for this prescription (required field) |
||
| StartDate | datetime | 16,3 | √ | null |
|
|
Prescription start date - Date when the prescription becomes effective |
|
| EndDate | datetime | 16,3 | √ | null |
|
|
Prescription end date - Date when the prescription expires or treatment ends |
|
| TreatingProviderId | int | 4 | √ | null |
|
|
Treating provider - Reference to provider who will administer or oversee the treatment |
|
| OrderingProviderId | int | 4 | √ | null |
|
|
Ordering provider - Reference to provider who prescribed or ordered the treatment |
|
| Comment | varchar | 2147483647 | √ | null |
|
|
Prescription notes - Additional notes, instructions, or comments about the prescription |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator user ID - Reference to user who created this prescription record |
|
| AutoAssignOrderingProvider | bit | 1 | √ | null |
|
|
Auto-assign flag - Boolean indicating if ordering provider should be automatically assigned |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation timestamp - When this prescription was first created |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last modification timestamp - When this prescription was most recently updated |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Last modifier - User ID who made the most recent update |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - When this prescription was logically deleted |
|
| DeletedBy | int | 4 | √ | null |
|
|
Deletion user - User ID who deleted this prescription |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| IX_AuthId | Performance | Asc | AuthId |
| IX_PrescriptionId | Performance | Asc | PrescriptionID |