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

DDL script

Columns

NameTypeNullableDefault valueComment
ICUSTAY_IDNUMBER(7)Y Unique icustay identifier
SUBJECT_IDNUMBER(7)Y Unique subject identifier
SEQNUMBER(7)Y Day number of the ICU stay
BEGINTIMETIMESTAMP(6) WITH TIME ZONEY Start time of the ICU stay day
ENDTIMETIMESTAMP(6) WITH TIME ZONEY End time of the ICU stay day.
FIRST_DAY_FLGCHAR(1)Y The first day of the ICU stay
LAST_DAY_FLGCHAR(1)Y The last day of the ICU stay

Options:

OptionSettings
TablespaceMIMIC2_DAT
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
MIMIC2V26.ICUSTAY_DAYS_O1NORMALNONUNIQUEICUSTAY_ID , SEQ DDL script
Generated by OraSchemaDoc, (c) Petr Vanek, 2005; Aram Kananov, 2002, on Tue Apr 19 09:28:47 2011