MIMIC II V2.6 - Table-MIMIC2V26.ADMISSIONS

Main Tables Materialized Views Indexes Constraints DDL scrips

Description Columns Primary key Check Constraints Foreign keys Unique Keys Options Indexes Referenced by Triggers Partitions

MIMIC2V26.ADMISSIONS

Description:

The record of patient admissions to the hospital

Columns

Name	Type	Nullable	Default value	Comment
HADM_ID	NUMBER(7)	N		Table record unique identifier, the hospital admission ID
SUBJECT_ID	NUMBER(7)	N		The patient for the admission.
ADMIT_DT	DATE	N		Date and time the patient was admitted to the hospital
DISCH_DT	DATE	N		Date and time the patient was discharged from the hospital

Primary key:

Constraint Name	Columns
MIMIC2V26.ADMISSIONS_PK	HADM_ID

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
MIMIC2V26.ADMISSIONS_FK_D_PATI	SUBJECT_ID	MIMIC2V26.D_PATIENTS	MIMIC2V26.D_PATIENTS_PK	NO ACTION

Options:

Option	Settings
Tablespace	MIMIC2_DAT
Index Organized	No
Generated by Oracle	No
Clustered	No
Nested	No
Temporary	No

Indexes:

Index Name	Type	Unuqueness	Columns	DDL script
MIMIC2V26.ADMISSIONS_O1	NORMAL	NONUNIQUE	SUBJECT_ID	DDL script
MIMIC2V26.ADMISSIONS_PK	NORMAL	UNIQUE	HADM_ID	DDL script

Referenced by:

Table	Constraint
MIMIC2V26.DEMOGRAPHICEVENTS	MIMIC2V26.DEMOGRAPHICEVENTS_FK_ADMIT
MIMIC2V26.DRGEVENTS	MIMIC2V26.DRGEVENTS_FK_ADMIT
MIMIC2V26.ICD9	MIMIC2V26.ICD9_FK_ADMISS
MIMIC2V26.LABEVENTS	MIMIC2V26.LABEVENTS_FK_HADM_ID
MIMIC2V26.MICROBIOLOGYEVENTS	MIMIC2V26.MICROBIOEV_FK_ADMISSIONS
MIMIC2V26.NOTEEVENTS	MIMIC2V26.NOTEEVEN_FK_ADM
MIMIC2V26.POE_ORDER	MIMIC2V26.POE_ORDER_FK_ADMISS
MIMIC2V26.PROCEDUREEVENTS	MIMIC2V26.PROCEDUREEVENTS_FK_ADM