Main Tables Materialized Views Indexes Constraints DDL scrips
Description Columns Primary key Check Constraints Foreign keys Unique Keys Options Indexes Referenced by Triggers Partitions

MIMIC2V26.MEDEVENTS

Description:

Medication events.

DDL script

Columns

NameTypeNullableDefault valueComment
SUBJECT_IDNUMBER(7)N Patient for the medication event.
ICUSTAY_IDNUMBER(7)Y ICU stay for the medication event.
ITEMIDNUMBER(7)N Medication item id for the event.
CHARTTIMETIMESTAMP(6) WITH TIME ZONEN Chart time of the medication event.
ELEMIDNUMBER(7)N Element id for the event.
REALTIMETIMESTAMP(6) WITH TIME ZONEN Real time of the medication event.
CGIDNUMBER(7)Y Care giver for the medication event.
CUIDNUMBER(7)Y Care unit for the medication event.
VOLUMENUMBER(38)Y Volume of the medication event.
DOSENUMBER(38)Y Doseage of the medication event.
DOSEUOMVARCHAR2(20)Y Units of measurement of the doseage of the medication event.
SOLUTIONIDNUMBER(7)Y Solution used in the medication event.
SOLVOLUMENUMBER(38)Y Volume of solution used in the medication event.
SOLUNITSVARCHAR2(20)Y Units of the volume of solution used in the medication event.
ROUTEVARCHAR2(20)Y Route of the medication
STOPPEDVARCHAR2(20)Y Medication stopped

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
MIMIC2V26.MEDEVENTS_FK_ICUSTAYICUSTAY_ID MIMIC2V26.ICUSTAYEVENTS MIMIC2V26.ICUSTAYEV_PK NO ACTION
MIMIC2V26.MEDEVENT_FK2_D_MEDITESOLUTIONID MIMIC2V26.D_MEDITEMS MIMIC2V26.D_MEDITEMS_PK NO ACTION
MIMIC2V26.MEDEVENT_FK_D_CAREGICGID MIMIC2V26.D_CAREGIVERS MIMIC2V26.D_CAREGIVERS_PK NO ACTION
MIMIC2V26.MEDEVENT_FK_D_CAREUNCUID MIMIC2V26.D_CAREUNITS MIMIC2V26.D_CAREUNITS_PK NO ACTION
MIMIC2V26.MEDEVENT_FK_D_MEDITEITEMID MIMIC2V26.D_MEDITEMS MIMIC2V26.D_MEDITEMS_PK NO ACTION
MIMIC2V26.MEDEVENT_FK_D_PATIENSUBJECT_ID MIMIC2V26.D_PATIENTS MIMIC2V26.D_PATIENTS_PK NO ACTION

Options:

OptionSettings
TablespaceMIMIC2_DAT
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
MIMIC2V26.MEDEVENTS_O1NORMALNONUNIQUECUID DDL script
MIMIC2V26.MEDEVENTS_O2NORMALNONUNIQUESUBJECT_ID DDL script
MIMIC2V26.MEDEVENTS_O3NORMALNONUNIQUEITEMID DDL script
MIMIC2V26.MEDEVENTS_O4NORMALNONUNIQUESOLUTIONID DDL script
MIMIC2V26.MEDEVENTS_O5NORMALNONUNIQUEICUSTAY_ID DDL script
MIMIC2V26.MEDEVENTS_O6NORMALNONUNIQUECGID DDL script
MIMIC2V26.MEDEVENTS_PKFUNCTION-BASED NORMALUNIQUESUBJECT_ID , ITEMID , SYS_EXTRACT_UTC("CHARTTIME") , ELEMID DDL script