S_NC_Medicine (ver 13.6.0)
This table is an child table of the Students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 13.6.0 | NUMBER(19,0) | Primary key |
| STUDENTSDCID | 13.6.0 | NUMBER(19,0) | Foreign key to Students table |
Dosage | 13.6.0 | NUMBER(25,10) | The dosage of the medication. |
Dosage_Unit_Type | 13.6.0 | NUMBER(11,0) | The unit type for the dosage. |
End_Date | 13.6.0 | DATE | The end date for the medication to be dispensed. |
Frequency | 13.6.0 | VARCHAR2(50) | The frequency the medication should be taken. |
Friday | 13.6.0 | VARCHAR2(1) | |
Measurement_Code | 13.6.0 | VARCHAR2(50) | |
Medication_Code | 13.6.0 | VARCHAR2(50) | |
Monday | 13.6.0 | VARCHAR2(1) | |
Name_Of_Pharmacy | 13.6.0 | VARCHAR2(50) | The name of the pharmacy on the prescription. |
Per_Request_As_Necessary | 13.6.0 | VARCHAR2(1) | |
Pharmacy_Phone_Number | 13.6.0 | VARCHAR2(10) | The pharmacy phone number. |
Reason | 13.6.0 | VARCHAR2(20) | The reason the medication is required. |
Reserved1 | 13.6.0 | VARCHAR2(50) | |
Reserved2 | 13.6.0 | VARCHAR2(50) | |
Reserved3 | 13.6.0 | VARCHAR2(50) | |
Rx_Number | 13.6.0 | NUMBER(11,0) | The prescription number. |
Saturday | 13.6.0 | VARCHAR2(1) | |
Special_Instructions | 13.6.0 | VARCHAR2(300) | Any special instructions for the dispensation of the medication. |
Start_Date | 13.6.0 | DATE | The start date for the medication. |
Sunday | 13.6.0 | VARCHAR2(1) | |
Thursday | 13.6.0 | VARCHAR2(1) | |
Tuesday | 13.6.0 | VARCHAR2(1) | |
Wednesday | 13.6.0 | VARCHAR2(1) |