Next: 6.1.1 ADDITIVES Up: 6. Appendix Previous: 6. Appendix Contents

6.1 Database Schema

This section describes each base table for the MIMIC II database, in alphabetical order. A list of foreign key references, primary keys, and a description of the columns is provided for each table.

The MIMIC II database schema is composed of several additional tables that deal with user authentication, database security, event logging and other application specific storage requirements. The description of these tables is outside the scope of this document.

Subsections

6.1.1 ADDITIVES
- 6.1.1.1 Columns
- 6.1.1.2 Primary key(s)
- 6.1.1.3 Foreign key(s)
6.1.2 ADMISSIONS
- 6.1.2.1 Columns
- 6.1.2.2 Primary key(s)
- 6.1.2.3 Foreign key(s)
6.1.3 A_CHARTDURATIONS
- 6.1.3.1 Columns
- 6.1.3.2 Primary key(s)
- 6.1.3.3 Foreign key(s)
6.1.4 A_IODURATIONS
- 6.1.4.1 Columns
- 6.1.4.2 Primary key(s)
- 6.1.4.3 Foreign key(s)
6.1.5 A_MEDDURATIONS
- 6.1.5.1 Columns
- 6.1.5.2 Primary key(s)
- 6.1.5.3 Foreign key(s)
6.1.6 CENSUSEVENTS
- 6.1.6.1 Columns
- 6.1.6.2 Primary key(s)
- 6.1.6.3 Foreign key(s)
6.1.7 CHARTEVENTS
- 6.1.7.1 Columns
- 6.1.7.2 Primary key(s)
- 6.1.7.3 Foreign key(s)
6.1.8 DB_SCHEMA
- 6.1.8.1 Columns
- 6.1.8.2 Primary key(s)
- 6.1.8.3 Foreign key(s)
6.1.9 DELIVERIES
- 6.1.9.1 Columns
- 6.1.9.2 Primary key(s)
- 6.1.9.3 Foreign key(s)
6.1.10 D_CAREGIVERS
- 6.1.10.1 Columns
- 6.1.10.2 Primary key(s)
- 6.1.10.3 Foreign key(s)
6.1.11 D_CAREUNITS
- 6.1.11.1 Columns
- 6.1.11.2 Primary key(s)
- 6.1.11.3 Foreign key(s)
6.1.12 D_CHARTITEMS
- 6.1.12.1 Columns
- 6.1.12.2 Primary key(s)
- 6.1.12.3 Foreign key(s)
6.1.13 D_IOITEMS
- 6.1.13.1 Columns
- 6.1.13.2 Primary key(s)
- 6.1.13.3 Foreign key(s)
6.1.14 D_LABITEMS
- 6.1.14.1 Columns
- 6.1.14.2 Primary key(s)
- 6.1.14.3 Foreign key(s)
6.1.15 D_MEDITEMS
- 6.1.15.1 Columns
- 6.1.15.2 Primary key(s)
- 6.1.15.3 Foreign key(s)
6.1.16 D_PARAMMAP_ITEMS
- 6.1.16.1 Columns
- 6.1.16.2 Primary key(s)
- 6.1.16.3 Foreign key(s)
6.1.17 D_PATIENTS
- 6.1.17.1 Columns
- 6.1.17.2 Primary key(s)
- 6.1.17.3 Foreign key(s)
6.1.18 ICD9
- 6.1.18.1 Columns
- 6.1.18.2 Primary key(s)
- 6.1.18.3 Foreign key(s)
6.1.19 IOEVENTS
- 6.1.19.1 Columns
- 6.1.19.2 Primary key(s)
- 6.1.19.3 Foreign key(s)
6.1.20 LABEVENTS
- 6.1.20.1 Columns
- 6.1.20.2 Primary key(s)
- 6.1.20.3 Foreign key(s)
6.1.21 MEDEVENTS
- 6.1.21.1 Columns
- 6.1.21.2 Primary key(s)
- 6.1.21.3 Foreign key(s)
6.1.22 PARAMETER_MAPPING
- 6.1.22.1 Columns
- 6.1.22.2 Primary key(s)
- 6.1.22.3 Foreign key(s)
6.1.23 POE_MED
- 6.1.23.1 Columns
- 6.1.23.2 Primary key(s)
- 6.1.23.3 Foreign key(s)
6.1.24 POE_ORDER
- 6.1.24.1 Columns
- 6.1.24.2 Primary key(s)
- 6.1.24.3 Foreign key(s)
6.1.25 TOTALBALEVENTS
- 6.1.25.1 Columns
- 6.1.25.2 Primary key(s)
- 6.1.25.3 Foreign key(s)
6.1.26 Tables

djscott 2010-08-24