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_CHARTDURATIONS

Description:

Chart event durations

DDL script

Columns

NameTypeNullableDefault valueComment
SUBJECT_IDNUMBER(7)N The patient for the chart duration.
ICUSTAY_IDNUMBER(7)Y The ICU stay for the chart duration.
ITEMIDNUMBER(7)N The chart item for the duration record
ELEMIDNUMBER(7)N The element of the duration record
STARTTIMETIMESTAMP(6) WITH TIME ZONEN The scheduled start time of the chart duration
STARTREALTIMETIMESTAMP(6) WITH TIME ZONEN The actual start time of the chart duration
ENDTIMETIMESTAMP(6) WITH TIME ZONEY The end time of the chart duration
CUIDNUMBER(7)Y The care unit where the chart duration event took place
DURATIONNUMBER(38)Y The duration of the charted parameter

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
MIMIC2V26.A_CHARTD_FK_D_CAREUNCUID MIMIC2V26.D_CAREUNITS MIMIC2V26.D_CAREUNITS_PK NO ACTION
MIMIC2V26.A_CHARTD_FK_D_CHARTIITEMID MIMIC2V26.D_CHARTITEMS MIMIC2V26.D_CHARTITEMS_PK NO ACTION
MIMIC2V26.A_CHARTD_FK_D_PATIENSUBJECT_ID MIMIC2V26.D_PATIENTS MIMIC2V26.D_PATIENTS_PK NO ACTION
MIMIC2V26.A_CHARTD_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_CHARTDURATIONS_O1NORMALNONUNIQUECUID DDL script
MIMIC2V26.A_CHARTDURATIONS_O2NORMALNONUNIQUESUBJECT_ID DDL script
MIMIC2V26.A_CHARTDURATIONS_O3NORMALNONUNIQUEICUSTAY_ID DDL script
MIMIC2V26.A_CHARTDURATIONS_O4NORMALNONUNIQUEITEMID DDL script