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

Description:

Events which occur on a patient chart.

DDL script

Columns

NameTypeNullableDefault valueComment
SUBJECT_IDNUMBER(7)N The patient for the chart event.
ICUSTAY_IDNUMBER(7)Y The ICU stay for the chart event.
ITEMIDNUMBER(7)N The chart item for the event record.
CHARTTIMETIMESTAMP(6) WITH TIME ZONEN The time of the chart event.
ELEMIDNUMBER(7)N The element of the chart event
REALTIMETIMESTAMP(6) WITH TIME ZONEN The real time of the chart event.
CGIDNUMBER(7)Y The care giver for the chart event.
CUIDNUMBER(7)Y The care unit where the chart event took place.
VALUE1VARCHAR2(110)Y The first chart event value.
VALUE1NUMNUMBER(38)Y The first chart event value (cast to numeric value).
VALUE1UOMVARCHAR2(20)Y The units of measurement for the first chart event value.
VALUE2VARCHAR2(110)Y The second chart event value.
VALUE2NUMNUMBER(38)Y The second chart event value (cast to numeric value).
VALUE2UOMVARCHAR2(20)Y The units of measurement for the second chart event value.
RESULTSTATUSVARCHAR2(20)Y The result status.
STOPPEDVARCHAR2(20)Y Whether or not the event was stopped.

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
MIMIC2V26.CHARTEVE_FK_D_CAREGICGID MIMIC2V26.D_CAREGIVERS MIMIC2V26.D_CAREGIVERS_PK NO ACTION
MIMIC2V26.CHARTEVE_FK_D_CAREUNCUID MIMIC2V26.D_CAREUNITS MIMIC2V26.D_CAREUNITS_PK NO ACTION
MIMIC2V26.CHARTEVE_FK_D_CHARTIITEMID MIMIC2V26.D_CHARTITEMS MIMIC2V26.D_CHARTITEMS_PK NO ACTION
MIMIC2V26.CHARTEVE_FK_D_PATIENSUBJECT_ID MIMIC2V26.D_PATIENTS MIMIC2V26.D_PATIENTS_PK NO ACTION
MIMIC2V26.CHARTEVE_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.CHARTEVENTS_O1NORMALNONUNIQUECUID DDL script
MIMIC2V26.CHARTEVENTS_O2NORMALNONUNIQUESUBJECT_ID , ITEMID DDL script
MIMIC2V26.CHARTEVENTS_O3NORMALNONUNIQUESUBJECT_ID DDL script
MIMIC2V26.CHARTEVENTS_O4NORMALNONUNIQUEITEMID DDL script
MIMIC2V26.CHARTEVENTS_O5NORMALNONUNIQUEICUSTAY_ID DDL script
MIMIC2V26.CHARTEVENTS_O6FUNCTION-BASED NORMALNONUNIQUESYS_EXTRACT_UTC("CHARTTIME") DDL script
MIMIC2V26.CHARTEVENTS_O7NORMALNONUNIQUECGID DDL script