Main Tables Materialized Views Indexes Constraints DDL scrips

Indexes

IndexTypeTableDDL Script
MIMIC2V26.ADDITIVES_O1 NORMAL MIMIC2V26.ADDITIVES DDL script
MIMIC2V26.ADDITIVES_O2 NORMAL MIMIC2V26.ADDITIVES DDL script
MIMIC2V26.ADDITIVES_O3 NORMAL MIMIC2V26.ADDITIVES DDL script
MIMIC2V26.ADDITIVES_O4 NORMAL MIMIC2V26.ADDITIVES DDL script
MIMIC2V26.ADDITIVES_O5 NORMAL MIMIC2V26.ADDITIVES DDL script
MIMIC2V26.ADDITIVES_O6 NORMAL MIMIC2V26.ADDITIVES DDL script
MIMIC2V26.ADMISSIONS_O1 NORMAL MIMIC2V26.ADMISSIONS DDL script
MIMIC2V26.ADMISSIONS_PK NORMAL MIMIC2V26.ADMISSIONS DDL script
MIMIC2V26.A_CHARTDURATIONS_O1 NORMAL MIMIC2V26.A_CHARTDURATIONS DDL script
MIMIC2V26.A_CHARTDURATIONS_O2 NORMAL MIMIC2V26.A_CHARTDURATIONS DDL script
MIMIC2V26.A_CHARTDURATIONS_O3 NORMAL MIMIC2V26.A_CHARTDURATIONS DDL script
MIMIC2V26.A_CHARTDURATIONS_O4 NORMAL MIMIC2V26.A_CHARTDURATIONS DDL script
MIMIC2V26.A_IODURATIONS_O1 NORMAL MIMIC2V26.A_IODURATIONS DDL script
MIMIC2V26.A_IODURATIONS_O2 NORMAL MIMIC2V26.A_IODURATIONS DDL script
MIMIC2V26.A_IODURATIONS_O3 NORMAL MIMIC2V26.A_IODURATIONS DDL script
MIMIC2V26.A_IODURATIONS_PK FUNCTION-BASED NORMAL MIMIC2V26.A_IODURATIONS DDL script
MIMIC2V26.A_IODURA_FK_ICUSTAY NORMAL MIMIC2V26.A_IODURATIONS DDL script
MIMIC2V26.A_MEDDURATIONS_O1 NORMAL MIMIC2V26.A_MEDDURATIONS DDL script
MIMIC2V26.A_MEDDURATIONS_O2 NORMAL MIMIC2V26.A_MEDDURATIONS DDL script
MIMIC2V26.A_MEDDURATIONS_O3 NORMAL MIMIC2V26.A_MEDDURATIONS DDL script
MIMIC2V26.A_MEDDURATIONS_O4 NORMAL MIMIC2V26.A_MEDDURATIONS DDL script
MIMIC2V26.A_MEDDURATIONS_PK FUNCTION-BASED NORMAL MIMIC2V26.A_MEDDURATIONS DDL script
MIMIC2V26.CENSUSEVENTS_01 NORMAL MIMIC2V26.CENSUSEVENTS DDL script
MIMIC2V26.CENSUSEVENTS_O2 NORMAL MIMIC2V26.CENSUSEVENTS DDL script
MIMIC2V26.CENSUSEVENTS_O3 NORMAL MIMIC2V26.CENSUSEVENTS DDL script
MIMIC2V26.CENSUSEVENTS_O4 NORMAL MIMIC2V26.CENSUSEVENTS DDL script
MIMIC2V26.CENSUSEVENTS_U1 FUNCTION-BASED NORMAL MIMIC2V26.CENSUSEVENTS DDL script
MIMIC2V26.CENSUSEV_PK NORMAL MIMIC2V26.CENSUSEVENTS DDL script
MIMIC2V26.CHARTEVENTS_O1 NORMAL MIMIC2V26.CHARTEVENTS DDL script
MIMIC2V26.CHARTEVENTS_O2 NORMAL MIMIC2V26.CHARTEVENTS DDL script
MIMIC2V26.CHARTEVENTS_O3 NORMAL MIMIC2V26.CHARTEVENTS DDL script
MIMIC2V26.CHARTEVENTS_O4 NORMAL MIMIC2V26.CHARTEVENTS DDL script
MIMIC2V26.CHARTEVENTS_O5 NORMAL MIMIC2V26.CHARTEVENTS DDL script
MIMIC2V26.CHARTEVENTS_O6 FUNCTION-BASED NORMAL MIMIC2V26.CHARTEVENTS DDL script
MIMIC2V26.CHARTEVENTS_O7 NORMAL MIMIC2V26.CHARTEVENTS DDL script
MIMIC2V26.COMORBIDITY_O1 NORMAL MIMIC2V26.COMORBIDITY_SCORES DDL script
MIMIC2V26.COMORBIDITY_O2 NORMAL MIMIC2V26.COMORBIDITY_SCORES DDL script
MIMIC2V26.COMORBIDITY_O3 NORMAL MIMIC2V26.COMORBIDITY_SCORES DDL script
MIMIC2V26.DELIVERIES_O1 NORMAL MIMIC2V26.DELIVERIES DDL script
MIMIC2V26.DELIVERIES_O2 NORMAL MIMIC2V26.DELIVERIES DDL script
MIMIC2V26.DELIVERIES_O3 NORMAL MIMIC2V26.DELIVERIES DDL script
MIMIC2V26.DELIVERIES_O4 NORMAL MIMIC2V26.DELIVERIES DDL script
MIMIC2V26.DELIVERIES_O5 NORMAL MIMIC2V26.DELIVERIES DDL script
MIMIC2V26.DELIVERIES_PK FUNCTION-BASED NORMAL MIMIC2V26.DELIVERIES DDL script
MIMIC2V26.DEMOGRAPHICEVENTS_O1 NORMAL MIMIC2V26.DEMOGRAPHICEVENTS DDL script
MIMIC2V26.DEMOGRAPHICEVENTS_O2 NORMAL MIMIC2V26.DEMOGRAPHICEVENTS DDL script
MIMIC2V26.DEMOGRAPHICEVENTS_PK NORMAL MIMIC2V26.DEMOGRAPHICEVENTS DDL script
MIMIC2V26.DRGEVENTS_O1 NORMAL MIMIC2V26.DRGEVENTS DDL script
MIMIC2V26.DRGEVENTS_O2 NORMAL MIMIC2V26.DRGEVENTS DDL script
MIMIC2V26.DRGEVENTS_O32 NORMAL MIMIC2V26.DRGEVENTS DDL script
MIMIC2V26.DRGEVENTS_PK NORMAL MIMIC2V26.DRGEVENTS DDL script
MIMIC2V26.D_CAREGIVERS_PK NORMAL MIMIC2V26.D_CAREGIVERS DDL script
MIMIC2V26.D_CAREUNITS_PK NORMAL MIMIC2V26.D_CAREUNITS DDL script
MIMIC2V26.D_CHARTITEMS_PK NORMAL MIMIC2V26.D_CHARTITEMS DDL script
MIMIC2V26.D_CODEDITEMS_PK NORMAL MIMIC2V26.D_CODEDITEMS DDL script
MIMIC2V26.D_DEMOGRAPHICITEMS_PK NORMAL MIMIC2V26.D_DEMOGRAPHICITEMS DDL script
MIMIC2V26.D_IOITEMS_PK NORMAL MIMIC2V26.D_IOITEMS DDL script
MIMIC2V26.D_LABITEMS_PK NORMAL MIMIC2V26.D_LABITEMS DDL script
MIMIC2V26.D_MEDITEMS_PK NORMAL MIMIC2V26.D_MEDITEMS DDL script
MIMIC2V26.D_PATIENTS_PK NORMAL MIMIC2V26.D_PATIENTS DDL script
MIMIC2V26.ICD9_O2 NORMAL MIMIC2V26.ICD9 DDL script
MIMIC2V26.ICU9_O1 NORMAL MIMIC2V26.ICD9 DDL script
MIMIC2V26.ICUSTAYEVENTS_O1 FUNCTION-BASED NORMAL MIMIC2V26.ICUSTAYEVENTS DDL script
MIMIC2V26.ICUSTAYEVENTS_O2 FUNCTION-BASED NORMAL MIMIC2V26.ICUSTAYEVENTS DDL script
MIMIC2V26.ICUSTAYEVENTS_O3 NORMAL MIMIC2V26.ICUSTAYEVENTS DDL script
MIMIC2V26.ICUSTAYEVENTS_O4 NORMAL MIMIC2V26.ICUSTAYEVENTS DDL script
MIMIC2V26.ICUSTAYEV_PK NORMAL MIMIC2V26.ICUSTAYEVENTS DDL script
MIMIC2V26.ICUSTAYEV_U1 FUNCTION-BASED NORMAL MIMIC2V26.ICUSTAYEVENTS DDL script
MIMIC2V26.ICUSTAY_DAYS_O1 NORMAL MIMIC2V26.ICUSTAY_DAYS DDL script
MIMIC2V26.ICUSTAY_DETAIL_PK NORMAL MIMIC2V26.ICUSTAY_DETAIL DDL script
MIMIC2V26.ICUSTAY_DETAIL_U1 NORMAL MIMIC2V26.ICUSTAY_DETAIL DDL script
MIMIC2V26.IOEVENTS_FK2_D_IOITEM NORMAL MIMIC2V26.IOEVENTS DDL script
MIMIC2V26.IOEVENTS_FK_D_CAREUN NORMAL MIMIC2V26.IOEVENTS DDL script
MIMIC2V26.IOEVENTS_FK_D_IOITEM NORMAL MIMIC2V26.IOEVENTS DDL script
MIMIC2V26.IOEVENTS_FK_D_PATIEN NORMAL MIMIC2V26.IOEVENTS DDL script
MIMIC2V26.IOEVENTS_FK_ICUSTAY NORMAL MIMIC2V26.IOEVENTS DDL script
MIMIC2V26.IOEVENTS_O6 NORMAL MIMIC2V26.IOEVENTS DDL script
MIMIC2V26.LABEVENTS_O1 NORMAL MIMIC2V26.LABEVENTS DDL script
MIMIC2V26.LABEVENTS_O2 NORMAL MIMIC2V26.LABEVENTS DDL script
MIMIC2V26.LABEVENTS_O3 NORMAL MIMIC2V26.LABEVENTS DDL script
MIMIC2V26.LABEVENTS_O4 NORMAL MIMIC2V26.LABEVENTS DDL script
MIMIC2V26.LABEVENTS_O5 NORMAL MIMIC2V26.LABEVENTS DDL script
MIMIC2V26.MEDEVENTS_O1 NORMAL MIMIC2V26.MEDEVENTS DDL script
MIMIC2V26.MEDEVENTS_O2 NORMAL MIMIC2V26.MEDEVENTS DDL script
MIMIC2V26.MEDEVENTS_O3 NORMAL MIMIC2V26.MEDEVENTS DDL script
MIMIC2V26.MEDEVENTS_O4 NORMAL MIMIC2V26.MEDEVENTS DDL script
MIMIC2V26.MEDEVENTS_O5 NORMAL MIMIC2V26.MEDEVENTS DDL script
MIMIC2V26.MEDEVENTS_O6 NORMAL MIMIC2V26.MEDEVENTS DDL script
MIMIC2V26.MEDEVENTS_PK FUNCTION-BASED NORMAL MIMIC2V26.MEDEVENTS DDL script
MIMIC2V26.MICROBIOLOGYEVENTS_O1 NORMAL MIMIC2V26.MICROBIOLOGYEVENTS DDL script
MIMIC2V26.MICROBIOLOGYEVENTS_O2 NORMAL MIMIC2V26.MICROBIOLOGYEVENTS DDL script
MIMIC2V26.MICROBIOLOGYEVENTS_O3 NORMAL MIMIC2V26.MICROBIOLOGYEVENTS DDL script
MIMIC2V26.MICROBIOLOGYEVENTS_O4 NORMAL MIMIC2V26.MICROBIOLOGYEVENTS DDL script
MIMIC2V26.MICROBIOLOGYEVENTS_O5 NORMAL MIMIC2V26.MICROBIOLOGYEVENTS DDL script
MIMIC2V26.NOTEEVENTS_O1 NORMAL MIMIC2V26.NOTEEVENTS DDL script
MIMIC2V26.NOTEEVENTS_O2 NORMAL MIMIC2V26.NOTEEVENTS DDL script
MIMIC2V26.NOTEEVENTS_O3 NORMAL MIMIC2V26.NOTEEVENTS DDL script
MIMIC2V26.NOTEEVENTS_O4 NORMAL MIMIC2V26.NOTEEVENTS DDL script
MIMIC2V26.NOTEEVENTS_O5 NORMAL MIMIC2V26.NOTEEVENTS DDL script
MIMIC2V26.NOTEEVENTS_O6 NORMAL MIMIC2V26.NOTEEVENTS DDL script
MIMIC2V26.POE_MED_O1 NORMAL MIMIC2V26.POE_MED DDL script
MIMIC2V26.POE_ORDER_O1 NORMAL MIMIC2V26.POE_ORDER DDL script
MIMIC2V26.POE_ORDER_O2 NORMAL MIMIC2V26.POE_ORDER DDL script
MIMIC2V26.POE_ORDER_O3 NORMAL MIMIC2V26.POE_ORDER DDL script
MIMIC2V26.POE_ORDER_O4 NORMAL MIMIC2V26.POE_ORDER DDL script
MIMIC2V26.POE_ORDER_PK NORMAL MIMIC2V26.POE_ORDER DDL script
MIMIC2V26.PROCEDUREEVENTS_O1 NORMAL MIMIC2V26.PROCEDUREEVENTS DDL script
MIMIC2V26.PROCEDUREEVENTS_O2 NORMAL MIMIC2V26.PROCEDUREEVENTS DDL script
MIMIC2V26.PROCEDUREEVENTS_PK NORMAL MIMIC2V26.PROCEDUREEVENTS DDL script
MIMIC2V26.TOTALBALEVENTS_O1 NORMAL MIMIC2V26.TOTALBALEVENTS DDL script
MIMIC2V26.TOTALBALEVENTS_O2 NORMAL MIMIC2V26.TOTALBALEVENTS DDL script
MIMIC2V26.TOTALBALEVENTS_O3 NORMAL MIMIC2V26.TOTALBALEVENTS DDL script
MIMIC2V26.TOTALBALEVENTS_O4 NORMAL MIMIC2V26.TOTALBALEVENTS DDL script
MIMIC2V26.TOTALBALEVENTS_O5 NORMAL MIMIC2V26.TOTALBALEVENTS DDL script
MIMIC2V26.WAVEFORM_METADATA_O1 NORMAL MIMIC2V26.WAVEFORM_METADATA DDL script
MIMIC2V26.WAVEFORM_METADATA_PK NORMAL MIMIC2V26.WAVEFORM_METADATA DDL script
MIMIC2V26.WAVEFORM_META_FK_D_PATIEN NORMAL MIMIC2V26.WAVEFORM_METADATA DDL script
MIMIC2V26.WAVEFORM_SEGMENTS_PK NORMAL MIMIC2V26.WAVEFORM_SEGMENTS DDL script
MIMIC2V26.WAVEFORM_SEGMENTS_WAVEFOR_FK2 NORMAL MIMIC2V26.WAVEFORM_SEGMENTS DDL script
MIMIC2V26.WAVEFORM_SEG_SIG_PK NORMAL MIMIC2V26.WAVEFORM_SEG_SIG DDL script
MIMIC2V26.WAVEFORM_SEG_SIG_WAVEFORM_FK2 NORMAL MIMIC2V26.WAVEFORM_SEG_SIG DDL script
MIMIC2V26.WAVEFORM_SIGNALS_PK NORMAL MIMIC2V26.WAVEFORM_SIGNALS DDL script
MIMIC2V26.WAVEFORM_SIGNALS_WAVEFORM_FK2 NORMAL MIMIC2V26.WAVEFORM_SIGNALS DDL script
MIMIC2V26.WAVEFORM_TRENDS_FK1 NORMAL MIMIC2V26.WAVEFORM_TRENDS DDL script
MIMIC2V26.WAVEFORM_TRENDS_PK NORMAL MIMIC2V26.WAVEFORM_TRENDS DDL script
MIMIC2V26.WAVEFORM_TREND_SIG_FK2 NORMAL MIMIC2V26.WAVEFORM_TREND_SIGNALS DDL script
MIMIC2V26.WAVEFORM_TREND_SIG_PK NORMAL MIMIC2V26.WAVEFORM_TREND_SIGNALS DDL script
Generated by OraSchemaDoc, (c) Petr Vanek, 2005; Aram Kananov, 2002, on Tue Apr 19 09:28:45 2011