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

Description:

Duration of 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 for the duration record
ELEMIDNUMBER(7)N The element of a combined IO duration
STARTTIMETIMESTAMP(6) WITH TIME ZONEN The start time of the IO event
STARTREALTIMETIMESTAMP(6) WITH TIME ZONEY The actual start time of the IO event
ENDTIMETIMESTAMP(6) WITH TIME ZONEY The end time of the IO event
CUIDNUMBER(7)Y The care unit where the IO event took place.
DURATIONNUMBER(38)Y The duration of the IO event

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
MIMIC2V26.A_IODURA_FK_D_CAREUNCUID MIMIC2V26.D_CAREUNITS MIMIC2V26.D_CAREUNITS_PK NO ACTION
MIMIC2V26.A_IODURA_FK_D_IOITEMITEMID MIMIC2V26.D_IOITEMS MIMIC2V26.D_IOITEMS_PK NO ACTION
MIMIC2V26.A_IODURA_FK_D_PATIENSUBJECT_ID MIMIC2V26.D_PATIENTS MIMIC2V26.D_PATIENTS_PK NO ACTION
MIMIC2V26.A_IODURA_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.A_IODURATIONS_O1NORMALNONUNIQUECUID DDL script
MIMIC2V26.A_IODURATIONS_O2NORMALNONUNIQUESUBJECT_ID DDL script
MIMIC2V26.A_IODURATIONS_O3NORMALNONUNIQUEITEMID DDL script
MIMIC2V26.A_IODURATIONS_PKFUNCTION-BASED NORMALUNIQUESUBJECT_ID , ITEMID , ELEMID , SYS_EXTRACT_UTC("STARTTIME") DDL script
MIMIC2V26.A_IODURA_FK_ICUSTAYNORMALNONUNIQUEICUSTAY_ID DDL script