Main
Tables
Materialized Views
Indexes
Constraints
DDL scrips
Constraints
Name
Type
Table
DDL Script
MIMIC2V26.ADDITIVES_FK_D_CAREGI
Referential
MIMIC2V26.ADDITIVES
MIMIC2V26.ADDITIVES_FK_D_CAREUN
Referential
MIMIC2V26.ADDITIVES
MIMIC2V26.ADDITIVES_FK_D_IOITEM
Referential
MIMIC2V26.ADDITIVES
MIMIC2V26.ADDITIVES_FK_D_MEDITE
Referential
MIMIC2V26.ADDITIVES
MIMIC2V26.ADDITIVES_FK_D_PATIEN
Referential
MIMIC2V26.ADDITIVES
MIMIC2V26.ADDITIVES_FK_ICUSTAY
Referential
MIMIC2V26.ADDITIVES
MIMIC2V26.ADMISSIONS_FK_D_PATI
Referential
MIMIC2V26.ADMISSIONS
MIMIC2V26.ADMISSIONS_PK
Primary key
MIMIC2V26.ADMISSIONS
DDL script
MIMIC2V26.A_CHARTD_FK_D_CAREUN
Referential
MIMIC2V26.A_CHARTDURATIONS
MIMIC2V26.A_CHARTD_FK_D_CHARTI
Referential
MIMIC2V26.A_CHARTDURATIONS
MIMIC2V26.A_CHARTD_FK_D_PATIEN
Referential
MIMIC2V26.A_CHARTDURATIONS
MIMIC2V26.A_CHARTD_FK_ICUSTAY
Referential
MIMIC2V26.A_CHARTDURATIONS
MIMIC2V26.A_IODURA_FK_D_CAREUN
Referential
MIMIC2V26.A_IODURATIONS
MIMIC2V26.A_IODURA_FK_D_IOITEM
Referential
MIMIC2V26.A_IODURATIONS
MIMIC2V26.A_IODURA_FK_D_PATIEN
Referential
MIMIC2V26.A_IODURATIONS
MIMIC2V26.A_IODURA_FK_ICUSTAY
Referential
MIMIC2V26.A_IODURATIONS
DDL script
MIMIC2V26.A_MEDDUR_FK_D_CAREUN
Referential
MIMIC2V26.A_MEDDURATIONS
MIMIC2V26.A_MEDDUR_FK_D_MEDITE
Referential
MIMIC2V26.A_MEDDURATIONS
MIMIC2V26.A_MEDDUR_FK_D_PATIEN
Referential
MIMIC2V26.A_MEDDURATIONS
MIMIC2V26.A_MEDDUR_FK_ICUSTAY
Referential
MIMIC2V26.A_MEDDURATIONS
MIMIC2V26.CENSUSEV_FK2_D_CAREUN
Referential
MIMIC2V26.CENSUSEVENTS
MIMIC2V26.CENSUSEV_FK_D_CAREUN
Referential
MIMIC2V26.CENSUSEVENTS
MIMIC2V26.CENSUSEV_FK_D_PATIEN
Referential
MIMIC2V26.CENSUSEVENTS
MIMIC2V26.CENSUSEV_FK_ICUSTAY
Referential
MIMIC2V26.CENSUSEVENTS
MIMIC2V26.CENSUSEV_PK
Primary key
MIMIC2V26.CENSUSEVENTS
DDL script
MIMIC2V26.CHARTEVE_FK_D_CAREGI
Referential
MIMIC2V26.CHARTEVENTS
MIMIC2V26.CHARTEVE_FK_D_CAREUN
Referential
MIMIC2V26.CHARTEVENTS
MIMIC2V26.CHARTEVE_FK_D_CHARTI
Referential
MIMIC2V26.CHARTEVENTS
MIMIC2V26.CHARTEVE_FK_D_PATIEN
Referential
MIMIC2V26.CHARTEVENTS
MIMIC2V26.CHARTEVE_FK_ICUSTAY
Referential
MIMIC2V26.CHARTEVENTS
MIMIC2V26.DELIVERI_FK_D_CAREGI
Referential
MIMIC2V26.DELIVERIES
MIMIC2V26.DELIVERI_FK_D_CAREUN
Referential
MIMIC2V26.DELIVERIES
MIMIC2V26.DELIVERI_FK_D_IOITEM
Referential
MIMIC2V26.DELIVERIES
MIMIC2V26.DELIVERI_FK_D_PATIEN
Referential
MIMIC2V26.DELIVERIES
MIMIC2V26.DELIVERI_FK_ICUSTAY
Referential
MIMIC2V26.DELIVERIES
MIMIC2V26.DEMOGRAPHICEVENTS_FK_ADMIT
Referential
MIMIC2V26.DEMOGRAPHICEVENTS
MIMIC2V26.DEMOGRAPHICEVENTS_FK_D_PATIEN
Referential
MIMIC2V26.DEMOGRAPHICEVENTS
MIMIC2V26.DEMOGRAPHICEVENTS_FK_ITEMID
Referential
MIMIC2V26.DEMOGRAPHICEVENTS
MIMIC2V26.DEMOGRAPHICEVENTS_PK
Primary key
MIMIC2V26.DEMOGRAPHICEVENTS
DDL script
MIMIC2V26.DRGEVENTS_FK_ADMIT
Referential
MIMIC2V26.DRGEVENTS
MIMIC2V26.DRGEVENTS_FK_D_PATIEN
Referential
MIMIC2V26.DRGEVENTS
MIMIC2V26.DRGEVENTS_FK_ITEMID
Referential
MIMIC2V26.DRGEVENTS
MIMIC2V26.DRGEVENTS_PK
Primary key
MIMIC2V26.DRGEVENTS
DDL script
MIMIC2V26.D_CAREGIVERS_PK
Primary key
MIMIC2V26.D_CAREGIVERS
DDL script
MIMIC2V26.D_CAREUNITS_PK
Primary key
MIMIC2V26.D_CAREUNITS
DDL script
MIMIC2V26.D_CHARTITEMS_PK
Primary key
MIMIC2V26.D_CHARTITEMS
DDL script
MIMIC2V26.D_CODEDITEMS_PK
Primary key
MIMIC2V26.D_CODEDITEMS
DDL script
MIMIC2V26.D_DEMOGRAPHICITEMS_PK
Primary key
MIMIC2V26.D_DEMOGRAPHICITEMS
DDL script
MIMIC2V26.D_IOITEMS_PK
Primary key
MIMIC2V26.D_IOITEMS
DDL script
MIMIC2V26.D_LABITEMS_PK
Primary key
MIMIC2V26.D_LABITEMS
DDL script
MIMIC2V26.D_MEDITEMS_PK
Primary key
MIMIC2V26.D_MEDITEMS
DDL script
MIMIC2V26.D_PATIENTS_PK
Primary key
MIMIC2V26.D_PATIENTS
DDL script
MIMIC2V26.ICD9_FK_ADMISS
Referential
MIMIC2V26.ICD9
MIMIC2V26.ICD9_FK_D_PATIEN
Referential
MIMIC2V26.ICD9
MIMIC2V26.ICUSTAYEV_FK2_D_CAREU
Referential
MIMIC2V26.ICUSTAYEVENTS
MIMIC2V26.ICUSTAYEV_FK_D_CAREU
Referential
MIMIC2V26.ICUSTAYEVENTS
MIMIC2V26.ICUSTAYEV_FK_D_PAT
Referential
MIMIC2V26.ICUSTAYEVENTS
MIMIC2V26.ICUSTAYEV_PK
Primary key
MIMIC2V26.ICUSTAYEVENTS
DDL script
MIMIC2V26.IOEVENTS_FK2_D_IOITEM
Referential
MIMIC2V26.IOEVENTS
DDL script
MIMIC2V26.IOEVENTS_FK_D_CAREGI
Referential
MIMIC2V26.IOEVENTS
MIMIC2V26.IOEVENTS_FK_D_CAREUN
Referential
MIMIC2V26.IOEVENTS
DDL script
MIMIC2V26.IOEVENTS_FK_D_IOITEM
Referential
MIMIC2V26.IOEVENTS
DDL script
MIMIC2V26.IOEVENTS_FK_D_PATIEN
Referential
MIMIC2V26.IOEVENTS
DDL script
MIMIC2V26.IOEVENTS_FK_ICUSTAY
Referential
MIMIC2V26.IOEVENTS
DDL script
MIMIC2V26.LABEVENTS_FK_HADM_ID
Referential
MIMIC2V26.LABEVENTS
MIMIC2V26.LABEVENTS_FK_ICUSTAY_ID
Referential
MIMIC2V26.LABEVENTS
MIMIC2V26.LABEVENTS_FK_ITEMID
Referential
MIMIC2V26.LABEVENTS
MIMIC2V26.LABEVENTS_FK_SUBJECT_ID
Referential
MIMIC2V26.LABEVENTS
MIMIC2V26.MEDEVENTS_FK_ICUSTAY
Referential
MIMIC2V26.MEDEVENTS
MIMIC2V26.MEDEVENT_FK2_D_MEDITE
Referential
MIMIC2V26.MEDEVENTS
MIMIC2V26.MEDEVENT_FK_D_CAREGI
Referential
MIMIC2V26.MEDEVENTS
MIMIC2V26.MEDEVENT_FK_D_CAREUN
Referential
MIMIC2V26.MEDEVENTS
MIMIC2V26.MEDEVENT_FK_D_MEDITE
Referential
MIMIC2V26.MEDEVENTS
MIMIC2V26.MEDEVENT_FK_D_PATIEN
Referential
MIMIC2V26.MEDEVENTS
MIMIC2V26.MICROBIOEV_AB_FK_D_CODED
Referential
MIMIC2V26.MICROBIOLOGYEVENTS
MIMIC2V26.MICROBIOEV_FK_ADMISSIONS
Referential
MIMIC2V26.MICROBIOLOGYEVENTS
MIMIC2V26.MICROBIOEV_FK_D_PATIENTS
Referential
MIMIC2V26.MICROBIOLOGYEVENTS
MIMIC2V26.MICROBIOEV_ORG_FK_D_CODED
Referential
MIMIC2V26.MICROBIOLOGYEVENTS
MIMIC2V26.MICROBIOEV_SPEC_FK_D_CODED
Referential
MIMIC2V26.MICROBIOLOGYEVENTS
MIMIC2V26.NOTEEVEN_FK_ADM
Referential
MIMIC2V26.NOTEEVENTS
MIMIC2V26.NOTEEVEN_FK_D_CAREGI
Referential
MIMIC2V26.NOTEEVENTS
MIMIC2V26.NOTEEVEN_FK_D_CAREUN
Referential
MIMIC2V26.NOTEEVENTS
MIMIC2V26.NOTEEVEN_FK_D_PATIEN
Referential
MIMIC2V26.NOTEEVENTS
MIMIC2V26.NOTEEVEN_FK_ICUSTAY
Referential
MIMIC2V26.NOTEEVENTS
MIMIC2V26.POE_MED_POE_ORDER_FK1
Referential
MIMIC2V26.POE_MED
MIMIC2V26.POE_ORDER_FK_ADMISS
Referential
MIMIC2V26.POE_ORDER
MIMIC2V26.POE_ORDER_FK_D_PATIEN
Referential
MIMIC2V26.POE_ORDER
MIMIC2V26.POE_ORDER_FK_ICUSTAY
Referential
MIMIC2V26.POE_ORDER
MIMIC2V26.POE_ORDER_PK
Primary key
MIMIC2V26.POE_ORDER
DDL script
MIMIC2V26.PROCEDUREEVENTS_FK_ADM
Referential
MIMIC2V26.PROCEDUREEVENTS
MIMIC2V26.PROCEDUREEVENTS_FK_D_CODED
Referential
MIMIC2V26.PROCEDUREEVENTS
MIMIC2V26.PROCEDUREEVENTS_FK_D_PATIEN
Referential
MIMIC2V26.PROCEDUREEVENTS
MIMIC2V26.PROCEDUREEVENTS_PK
Primary key
MIMIC2V26.PROCEDUREEVENTS
DDL script
MIMIC2V26.TOTALBAL_FK_D_CAREGI
Referential
MIMIC2V26.TOTALBALEVENTS
MIMIC2V26.TOTALBAL_FK_D_CAREUN
Referential
MIMIC2V26.TOTALBALEVENTS
MIMIC2V26.TOTALBAL_FK_D_IOITEM
Referential
MIMIC2V26.TOTALBALEVENTS
MIMIC2V26.TOTALBAL_FK_D_PATIEN
Referential
MIMIC2V26.TOTALBALEVENTS
MIMIC2V26.TOTALBAL_FK_ICUSTAY
Referential
MIMIC2V26.TOTALBALEVENTS
MIMIC2V26.WAVEFORM_METADATA_PK
Primary key
MIMIC2V26.WAVEFORM_METADATA
DDL script
MIMIC2V26.WAVEFORM_META_FK_D_PATIEN
Referential
MIMIC2V26.WAVEFORM_METADATA
DDL script
MIMIC2V26.WAVEFORM_SEGMENTS_PK
Primary key
MIMIC2V26.WAVEFORM_SEGMENTS
DDL script
MIMIC2V26.WAVEFORM_SEGMENTS_WAVEFOR_FK1
Referential
MIMIC2V26.WAVEFORM_SEGMENTS
MIMIC2V26.WAVEFORM_SEGMENTS_WAVEFOR_FK2
Referential
MIMIC2V26.WAVEFORM_SEGMENTS
DDL script
MIMIC2V26.WAVEFORM_SEG_SIG_PK
Primary key
MIMIC2V26.WAVEFORM_SEG_SIG
DDL script
MIMIC2V26.WAVEFORM_SEG_SIG_WAVEFORM_FK1
Referential
MIMIC2V26.WAVEFORM_SEG_SIG
MIMIC2V26.WAVEFORM_SEG_SIG_WAVEFORM_FK2
Referential
MIMIC2V26.WAVEFORM_SEG_SIG
DDL script
MIMIC2V26.WAVEFORM_SIGNALS_PK
Primary key
MIMIC2V26.WAVEFORM_SIGNALS
DDL script
MIMIC2V26.WAVEFORM_SIGNALS_WAVEFORM_FK1
Referential
MIMIC2V26.WAVEFORM_SIGNALS
MIMIC2V26.WAVEFORM_SIGNALS_WAVEFORM_FK2
Referential
MIMIC2V26.WAVEFORM_SIGNALS
DDL script
MIMIC2V26.WAVEFORM_TRENDS_FK1
Referential
MIMIC2V26.WAVEFORM_TRENDS
DDL script
MIMIC2V26.WAVEFORM_TRENDS_PK
Primary key
MIMIC2V26.WAVEFORM_TRENDS
DDL script
MIMIC2V26.WAVEFORM_TREND_SIG_FK1
Referential
MIMIC2V26.WAVEFORM_TREND_SIGNALS
MIMIC2V26.WAVEFORM_TREND_SIG_FK2
Referential
MIMIC2V26.WAVEFORM_TREND_SIGNALS
DDL script
MIMIC2V26.WAVEFORM_TREND_SIG_PK
Primary key
MIMIC2V26.WAVEFORM_TREND_SIGNALS
DDL script