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

Description:

Items which can be entered on a patient's chart

DDL script

Columns

NameTypeNullableDefault valueComment
ITEMIDNUMBER(7)N Table unique identifier, the chart item id.
LABELVARCHAR2(110)Y The name of the parameter
CATEGORYVARCHAR2(50)Y The chart item category.
DESCRIPTIONVARCHAR2(255)Y Comments or description about the parameter

Primary key:

Constraint NameColumns
MIMIC2V26.D_CHARTITEMS_PKITEMID

Options:

OptionSettings
TablespaceMIMIC2_DAT
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
MIMIC2V26.D_CHARTITEMS_PKNORMALUNIQUEITEMID DDL script

Referenced by:

TableConstraint
MIMIC2V26.A_CHARTDURATIONS MIMIC2V26.A_CHARTD_FK_D_CHARTI
MIMIC2V26.CHARTEVENTS MIMIC2V26.CHARTEVE_FK_D_CHARTI
Generated by OraSchemaDoc, (c) Petr Vanek, 2005; Aram Kananov, 2002, on Tue Apr 19 09:28:47 2011