Main Tables Materialized Views Indexes Constraints DDL scrips

Constraints

NameTypeTableDDL 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