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.IOEVENTS

Description:

Fluid input/output (IO) events.

DDL script

Columns

NameTypeNullableDefault valueComment
SUBJECT_IDNUMBER(7)N Unique patient identifier.
ICUSTAY_IDNUMBER(7)Y Unique ICU stay identifier
ITEMIDNUMBER(7)N The IO item id for the event.
CHARTTIMETIMESTAMP(6) WITH TIME ZONEN The chart time of the IO event.
ELEMIDNUMBER(7)N Element id of a multi component IO event.
ALTIDNUMBER(7)Y Alternate id of the IO event.
REALTIMETIMESTAMP(6) WITH TIME ZONEY The real time of the IO event.
CGIDNUMBER(7)Y The care giver for the IO event.
CUIDNUMBER(7)Y The care unit for the IO event.
VOLUMENUMBER(38)Y The volume of the IO event.
VOLUMEUOMVARCHAR2(20)Y The units of measurement of the volume of the IO event.
UNITSHUNGNUMBER(38)Y The units of measurement for the number of units hung.
UNITSHUNGUOMVARCHAR2(20)Y Units of measurement for the hung fluid
NEWBOTTLENUMBER(38)Y New bottle attached
STOPPEDVARCHAR2(20)Y Stopped recording
ESTIMATEVARCHAR2(20)Y Estimate?

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
MIMIC2V26.IOEVENTS_FK2_D_IOITEMALTID MIMIC2V26.D_IOITEMS MIMIC2V26.D_IOITEMS_PK NO ACTION
MIMIC2V26.IOEVENTS_FK_D_CAREGICGID MIMIC2V26.D_CAREGIVERS MIMIC2V26.D_CAREGIVERS_PK NO ACTION
MIMIC2V26.IOEVENTS_FK_D_CAREUNCUID MIMIC2V26.D_CAREUNITS MIMIC2V26.D_CAREUNITS_PK NO ACTION
MIMIC2V26.IOEVENTS_FK_D_IOITEMITEMID MIMIC2V26.D_IOITEMS MIMIC2V26.D_IOITEMS_PK NO ACTION
MIMIC2V26.IOEVENTS_FK_D_PATIENSUBJECT_ID MIMIC2V26.D_PATIENTS MIMIC2V26.D_PATIENTS_PK NO ACTION
MIMIC2V26.IOEVENTS_FK_ICUSTAYICUSTAY_ID MIMIC2V26.ICUSTAYEVENTS MIMIC2V26.ICUSTAYEV_PK NO ACTION

Options:

OptionSettings
TablespaceMIMIC2_DAT
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
MIMIC2V26.IOEVENTS_FK2_D_IOITEMNORMALNONUNIQUEALTID DDL script
MIMIC2V26.IOEVENTS_FK_D_CAREUNNORMALNONUNIQUECUID DDL script
MIMIC2V26.IOEVENTS_FK_D_IOITEMNORMALNONUNIQUEITEMID DDL script
MIMIC2V26.IOEVENTS_FK_D_PATIENNORMALNONUNIQUESUBJECT_ID DDL script
MIMIC2V26.IOEVENTS_FK_ICUSTAYNORMALNONUNIQUEICUSTAY_ID DDL script
MIMIC2V26.IOEVENTS_O6NORMALNONUNIQUECGID DDL script