Main Tables Materialized Views Indexes Constraints DDL scrips

Tables

TableDescriptionDDL Script
MIMIC2V26.ADDITIVES  DDL script
MIMIC2V26.ADMISSIONS The record of patient admissions to the hospital...DDL script
MIMIC2V26.A_CHARTDURATIONS Chart event durations...DDL script
MIMIC2V26.A_IODURATIONS Duration of IO events...DDL script
MIMIC2V26.A_MEDDURATIONS Duration of medication events...DDL script
MIMIC2V26.CENSUSEVENTS Events which record ICU transfers...DDL script
MIMIC2V26.CHARTEVENTS Events which occur on a patient chart....DDL script
MIMIC2V26.COMORBIDITY_SCORES  DDL script
MIMIC2V26.DB_SCHEMA Database schema information....DDL script
MIMIC2V26.DELIVERIES  DDL script
MIMIC2V26.DEMOGRAPHICEVENTS Events indicating demographic information about a ...DDL script
MIMIC2V26.DEMOGRAPHIC_DETAIL  DDL script
MIMIC2V26.DRGEVENTS Events indicating DRGs recorded for a patient....DDL script
MIMIC2V26.D_CAREGIVERS Care givers...DDL script
MIMIC2V26.D_CAREUNITS Care units...DDL script
MIMIC2V26.D_CHARTITEMS Items which can be entered on a patient's chart...DDL script
MIMIC2V26.D_CODEDITEMS Items with an attached code; may be used in DRGEVE...DDL script
MIMIC2V26.D_DEMOGRAPHICITEMS Demographic items: items that can be entered into ...DDL script
MIMIC2V26.D_IOITEMS IO items. Patient fluid input/output records...DDL script
MIMIC2V26.D_LABITEMS Laboratory tests....DDL script
MIMIC2V26.D_MEDITEMS Medication items. Possible medications which can b...DDL script
MIMIC2V26.D_PARAMMAP_ITEMS Types of parameter mapping provided. The actual ma...DDL script
MIMIC2V26.D_PATIENTS Patient table. Contains patient specific informati...DDL script
MIMIC2V26.D_WAVEFORM_SIG Mapping between signal classes and types...DDL script
MIMIC2V26.ICD9 ICD9 code records for each hospital admission....DDL script
MIMIC2V26.ICUSTAYEVENTS Unique ICU stay definitions per patient...DDL script
MIMIC2V26.ICUSTAY_DAYS  DDL script
MIMIC2V26.ICUSTAY_DETAIL  DDL script
MIMIC2V26.IOEVENTS Fluid input/output (IO) events....DDL script
MIMIC2V26.LABEVENTS Laboratory tests...DDL script
MIMIC2V26.MEDEVENTS Medication events....DDL script
MIMIC2V26.MICROBIOLOGYEVENTS Events indicating microbiology tests taken from a ...DDL script
MIMIC2V26.NOTEEVENTS Note events. Patient nursing/doctor notes, dischar...DDL script
MIMIC2V26.PARAMETER_MAPPING Mappings between parameters which do not fit in th...DDL script
MIMIC2V26.POE_MED Medications which make up a POE_ORDER. For each en...DDL script
MIMIC2V26.POE_ORDER POE Orders. Each row in this table indicates a POE...DDL script
MIMIC2V26.PROCEDUREEVENTS Events indicating procedures performed on a patien...DDL script
MIMIC2V26.TOTALBALEVENTS Total fluid balance events....DDL script
MIMIC2V26.WAVEFORM_METADATA Metadata for the MIMIC-II waveforms from PhysioNet...DDL script
MIMIC2V26.WAVEFORM_SEGMENTS Metadata for the MIMIC-II waveform segments...DDL script
MIMIC2V26.WAVEFORM_SEG_SIG Metadata for the MIMIC-II waveform segment signals...DDL script
MIMIC2V26.WAVEFORM_SIGNALS Metadata for the MIMIC-II waveform signals...DDL script
MIMIC2V26.WAVEFORM_TRENDS Metadata for the MIMIC-II waveform trends...DDL script
MIMIC2V26.WAVEFORM_TREND_SIGNALS Metadata for the MIMIC-II waveform trend signals...DDL script