Key | Name | Data Type | Max Length (Bytes) | Nullability | Description |
---|
 | UserID | [dbo].[uniqueid] | 9 | NOT NULL | The user ID that did the prescription. Link to IDX_User.ID |
 | ItemID | [dbo].[uniqueid] | 9 | NOT NULL | Item ID - Item_Medication.ID |
 ![Foreign Keys FK_PrescriptionLog_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_PrescriptionLog_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | Patient. Link to Person.ID |
 | OrderItemEXT | varchar(35) | 35 | NULL allowed | External Order Identifier value associated to the medication Order |
| CurrentMedicationID | [dbo].[uniqueid] | 9 | NOT NULL | Medication ID. Link to Medication.ID |
 | Medication | varchar(255) | 255 | NOT NULL | Medication description |
 | Dose | varchar(35) | 35 | NULL allowed | Dose |
 | Refill | smallint | 2 | NULL allowed | number of refills |
 | QuantityToDispense | varchar(20) | 20 | NULL allowed | Qty to dispense |
 | DaysToTake | smallint | 2 | NULL allowed | Number of days to take the medication |
 | PrescribedBy | varchar(255) | 255 | NOT NULL | Name of the user who prescribed the medication |
 | WhoFor | varchar(255) | 255 | NOT NULL | Name of the user for who the prescription was done |
 | WhoDidIt | varchar(255) | 255 | NOT NULL | Name of the user who did the prescription |
 | RecordedDTTM | datetime | 8 | NOT NULL | Date prescription recorded |
 | PrintRequestDTTM | datetime | 8 | NOT NULL | Prescription Print requested Date |
| LogType | varchar(20) | 20 | NULL allowed | Log Type |