MIMIC II V2.6 - Table-MIMIC2V26.ICUSTAYEVENTS

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

Description:

Unique ICU stay definitions per patient

Columns

Name	Type	Nullable	Default value	Comment
ICUSTAY_ID	NUMBER(7)	N		Uniquely identifies an ICU Stay
SUBJECT_ID	NUMBER(7)	N		The patient the ICU Stay refers to.
INTIME	TIMESTAMP(6) WITH TIME ZONE	N		The beginning of the ICU Stay.
OUTTIME	TIMESTAMP(6) WITH TIME ZONE	N		The end of the ICU Stay.
LOS	NUMBER(38)	N		Length of Stay in minutes
FIRST_CAREUNIT	NUMBER(7)	Y		The first careunit the patient was admitted in.
LAST_CAREUNIT	NUMBER(7)	Y		The last careunit the patient was admitted in.

Primary key:

Constraint Name	Columns
MIMIC2V26.ICUSTAYEV_PK	ICUSTAY_ID

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
MIMIC2V26.ICUSTAYEV_FK2_D_CAREU	LAST_CAREUNIT	MIMIC2V26.D_CAREUNITS	MIMIC2V26.D_CAREUNITS_PK	NO ACTION
MIMIC2V26.ICUSTAYEV_FK_D_CAREU	FIRST_CAREUNIT	MIMIC2V26.D_CAREUNITS	MIMIC2V26.D_CAREUNITS_PK	NO ACTION
MIMIC2V26.ICUSTAYEV_FK_D_PAT	SUBJECT_ID	MIMIC2V26.D_PATIENTS	MIMIC2V26.D_PATIENTS_PK	NO ACTION

Options:

Option	Settings
Tablespace	MIMIC2_DAT
Index Organized	No
Generated by Oracle	No
Clustered	No
Nested	No
Temporary	No

Indexes:

Index Name	Type	Unuqueness	Columns	DDL script
MIMIC2V26.ICUSTAYEVENTS_O1	FUNCTION-BASED NORMAL	NONUNIQUE	SYS_EXTRACT_UTC("INTIME")	DDL script
MIMIC2V26.ICUSTAYEVENTS_O2	FUNCTION-BASED NORMAL	NONUNIQUE	SYS_EXTRACT_UTC("OUTTIME")	DDL script
MIMIC2V26.ICUSTAYEVENTS_O3	NORMAL	NONUNIQUE	LAST_CAREUNIT	DDL script
MIMIC2V26.ICUSTAYEVENTS_O4	NORMAL	NONUNIQUE	FIRST_CAREUNIT	DDL script
MIMIC2V26.ICUSTAYEV_PK	NORMAL	UNIQUE	ICUSTAY_ID	DDL script
MIMIC2V26.ICUSTAYEV_U1	FUNCTION-BASED NORMAL	UNIQUE	SUBJECT_ID , SYS_EXTRACT_UTC("INTIME")	DDL script

Referenced by:

Table	Constraint
MIMIC2V26.ADDITIVES	MIMIC2V26.ADDITIVES_FK_ICUSTAY
MIMIC2V26.A_CHARTDURATIONS	MIMIC2V26.A_CHARTD_FK_ICUSTAY
MIMIC2V26.A_IODURATIONS	MIMIC2V26.A_IODURA_FK_ICUSTAY
MIMIC2V26.A_MEDDURATIONS	MIMIC2V26.A_MEDDUR_FK_ICUSTAY
MIMIC2V26.CENSUSEVENTS	MIMIC2V26.CENSUSEV_FK_ICUSTAY
MIMIC2V26.CHARTEVENTS	MIMIC2V26.CHARTEVE_FK_ICUSTAY
MIMIC2V26.DELIVERIES	MIMIC2V26.DELIVERI_FK_ICUSTAY
MIMIC2V26.IOEVENTS	MIMIC2V26.IOEVENTS_FK_ICUSTAY
MIMIC2V26.LABEVENTS	MIMIC2V26.LABEVENTS_FK_ICUSTAY_ID
MIMIC2V26.MEDEVENTS	MIMIC2V26.MEDEVENTS_FK_ICUSTAY
MIMIC2V26.NOTEEVENTS	MIMIC2V26.NOTEEVEN_FK_ICUSTAY
MIMIC2V26.POE_ORDER	MIMIC2V26.POE_ORDER_FK_ICUSTAY
MIMIC2V26.TOTALBALEVENTS	MIMIC2V26.TOTALBAL_FK_ICUSTAY