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

Description:

Events indicating DRGs recorded for a patient.

DDL script

Columns

NameTypeNullableDefault valueComment
SUBJECT_IDNUMBER(7)N The patient for the DRG event.
HADM_IDNUMBER(7)N The hospital admission.
ITEMIDNUMBER(7)N The item identifier for the DRG event.
COST_WEIGHTNUMBER(38)Y The weight for the DRG event.

Primary key:

Constraint NameColumns
MIMIC2V26.DRGEVENTS_PKSUBJECT_ID , HADM_ID , ITEMID

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
MIMIC2V26.DRGEVENTS_FK_ADMITHADM_ID MIMIC2V26.ADMISSIONS MIMIC2V26.ADMISSIONS_PK NO ACTION
MIMIC2V26.DRGEVENTS_FK_D_PATIENSUBJECT_ID MIMIC2V26.D_PATIENTS MIMIC2V26.D_PATIENTS_PK NO ACTION
MIMIC2V26.DRGEVENTS_FK_ITEMIDITEMID MIMIC2V26.D_CODEDITEMS MIMIC2V26.D_CODEDITEMS_PK NO ACTION

Options:

OptionSettings
TablespaceMIMIC2_DAT
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
MIMIC2V26.DRGEVENTS_O1NORMALNONUNIQUEHADM_ID DDL script
MIMIC2V26.DRGEVENTS_O2NORMALNONUNIQUEITEMID DDL script
MIMIC2V26.DRGEVENTS_O32NORMALNONUNIQUESUBJECT_ID DDL script
MIMIC2V26.DRGEVENTS_PKNORMALUNIQUESUBJECT_ID , HADM_ID , ITEMID DDL script
Generated by OraSchemaDoc, (c) Petr Vanek, 2005; Aram Kananov, 2002, on Tue Apr 19 09:28:47 2011