S_NC_Medicine_History (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 |
Administered_By | 13.6.0 | Varchar2(30) | |
Applied_Time | 13.6.0 | Date | |
Dosage | 13.6.0 | Number(25,10) | |
Dosage_Taken | 13.6.0 | Number(25,10) | |
Dosage_Unit_Type | 13.6.0 | Number(11,0) | |
Dosage_Unit_Type_Taken | 13.6.0 | Varchar2(50) | |
Measurement_Type | 13.6.0 | Number(11,0) | |
Measurement_Value | 13.6.0 | Varchar2(50) | |
Medication_Date | 13.6.0 | Date | |
Medication_Time | 13.6.0 | Date | |
ParentTable_ID | 13.6.0 | Number(11,0) | |
Waste_Dosage | 13.6.0 | Number(25,10) | |
Waste_Dosage_Unit_Type | 13.6.0 | Varchar2(50) |