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.ICD9

Description:

ICD9 code records for each hospital admission.

DDL script

Columns

NameTypeNullableDefault valueComment
SUBJECT_IDNUMBER(7)N The patient for the ICD9 code record.
HADM_IDNUMBER(7)N The hospital admission for the ICD9 code record.
SEQUENCENUMBER(7)N The order/priority of the code for the hospital admission referred by the column HADM_ID, for example: sequence = 1 is the primary ICD9 code
CODEVARCHAR2(100)N The ICD9 code.
DESCRIPTIONVARCHAR2(255)Y A description of the ICD9 code.

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
MIMIC2V26.ICD9_FK_ADMISSHADM_ID MIMIC2V26.ADMISSIONS MIMIC2V26.ADMISSIONS_PK NO ACTION
MIMIC2V26.ICD9_FK_D_PATIENSUBJECT_ID MIMIC2V26.D_PATIENTS MIMIC2V26.D_PATIENTS_PK NO ACTION

Options:

OptionSettings
TablespaceMIMIC2_DAT
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
MIMIC2V26.ICD9_O2NORMALNONUNIQUEHADM_ID DDL script
MIMIC2V26.ICU9_O1NORMALNONUNIQUESUBJECT_ID DDL script
Generated by OraSchemaDoc, (c) Petr Vanek, 2005; Aram Kananov, 2002, on Tue Apr 19 09:28:47 2011