Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| PatientPrescripID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each patient prescription record |
||||
| PrescripTypeID | int | 4 | √ | null |
|
|
Prescription type reference - Links to prescripTypes table for the type of prescription (foreign key to prescripTypes.prescripTypeID) |
||||
| PatientID | int | 4 | √ | null |
|
|
Patient reference - Links to Patient table for the patient receiving this prescription |
||||
| PrescripStatusID | int | 4 | √ | null |
|
|
Prescription status reference - Links to prescription status classification |
||||
| StartDate | datetime | 16,3 | √ | null |
|
|
Prescription start date - Date when prescription becomes effective |
||||
| EndDate | datetime | 16,3 | √ | null |
|
|
Prescription end date - Date when prescription expires or is discontinued |
||||
| Refill | varchar | 10 | √ | null |
|
|
Refill information - Refill instructions or status for the prescription |
||||
| numOfRefills | int | 4 | √ | null |
|
|
Number of refills - Total number of refills allowed for this prescription |
||||
| numOfDaysBtwnRefills | int | 4 | √ | null |
|
|
Days between refills - Number of days required between prescription refills |
||||
| Route | varchar | 20 | √ | null |
|
|
Administration route - Method of medication administration (e.g., ‘Oral’, ‘Topical’, ‘Injection’) |
||||
| Dose | varchar | 20 | √ | null |
|
|
Dosage amount - Amount of medication per dose |
||||
| Frequency | varchar | 20 | √ | null |
|
|
Dosage frequency - How often medication should be taken (e.g., ‘Daily’, ‘Twice daily’) |
||||
| Quantity | varchar | 20 | √ | null |
|
|
Prescription quantity - Total quantity of medication prescribed |
||||
| Comments | varchar | 100 | √ | null |
|
|
Prescription comments - Additional notes or special instructions for the prescription |
||||
| CaseID | int | 4 | √ | null |
|
|
Case reference - Links to PatientAdministration table for the patient case |
||||
| DateCreated | smalldatetime | 16 | √ | (getdate()) |
|
|
Creation date - Date when the prescription record was created |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created the prescription record |
||||
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Last update date - Date when the prescription record was last modified |
||||
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated the prescription record |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__PatientPrescript__68DD7AB4 | Primary key | Asc | PatientPrescripID |
Relationships
Close relationships within degrees of separation
