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

Description:

Events indicating procedures performed on a patient.

DDL script

Columns

NameTypeNullableDefault valueComment
SUBJECT_IDNUMBER(7)N The patient for the procedure event.
HADM_IDNUMBER(7)N The hospital admission.
ITEMIDNUMBER(7)Y The item identifier for the procedure event.
SEQUENCE_NUMNUMBER(7)N A number indicating the chronological order of this event, relative to the other events for the same patient and hospital admission (lower equates to earlier).
PROC_DTDATEY The date on which the procedure event occurred.

Primary key:

Constraint NameColumns
MIMIC2V26.PROCEDUREEVENTS_PKSUBJECT_ID , HADM_ID , SEQUENCE_NUM

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
MIMIC2V26.PROCEDUREEVENTS_FK_ADMHADM_ID MIMIC2V26.ADMISSIONS MIMIC2V26.ADMISSIONS_PK NO ACTION
MIMIC2V26.PROCEDUREEVENTS_FK_D_CODEDITEMID MIMIC2V26.D_CODEDITEMS MIMIC2V26.D_CODEDITEMS_PK NO ACTION
MIMIC2V26.PROCEDUREEVENTS_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.PROCEDUREEVENTS_O1NORMALNONUNIQUEHADM_ID DDL script
MIMIC2V26.PROCEDUREEVENTS_O2NORMALNONUNIQUEITEMID DDL script
MIMIC2V26.PROCEDUREEVENTS_PKNORMALUNIQUESUBJECT_ID , HADM_ID , SEQUENCE_NUM DDL script
Generated by OraSchemaDoc, (c) Petr Vanek, 2005; Aram Kananov, 2002, on Tue Apr 19 09:28:49 2011