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

Description:

Events indicating demographic information about a patient, recorded upon hospital admission.

DDL script

Columns

NameTypeNullableDefault valueComment
SUBJECT_IDNUMBER(7)N The patient for the demographic event.
HADM_IDNUMBER(7)N The hospital admission.
ITEMIDNUMBER(7)N The item identifier for the demographic.

Primary key:

Constraint NameColumns
MIMIC2V26.DEMOGRAPHICEVENTS_PKSUBJECT_ID , HADM_ID , ITEMID

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
MIMIC2V26.DEMOGRAPHICEVENTS_FK_ADMITHADM_ID MIMIC2V26.ADMISSIONS MIMIC2V26.ADMISSIONS_PK NO ACTION
MIMIC2V26.DEMOGRAPHICEVENTS_FK_D_PATIENSUBJECT_ID MIMIC2V26.D_PATIENTS MIMIC2V26.D_PATIENTS_PK NO ACTION
MIMIC2V26.DEMOGRAPHICEVENTS_FK_ITEMIDITEMID MIMIC2V26.D_DEMOGRAPHICITEMS MIMIC2V26.D_DEMOGRAPHICITEMS_PK NO ACTION

Options:

OptionSettings
TablespaceMIMIC2_DAT
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
MIMIC2V26.DEMOGRAPHICEVENTS_O1NORMALNONUNIQUEHADM_ID DDL script
MIMIC2V26.DEMOGRAPHICEVENTS_O2NORMALNONUNIQUEITEMID DDL script
MIMIC2V26.DEMOGRAPHICEVENTS_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