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_LABITEMS

Description:

Laboratory tests.

DDL script

Columns

NameTypeNullableDefault valueComment
ITEMIDNUMBER(7)N Table record unique identifier, the lab item ID.
TEST_NAMEVARCHAR2(50)N The name of the lab test performed
FLUIDVARCHAR2(50)N The fluid on which the test was performed
CATEGORYVARCHAR2(50)N Item category
LOINC_CODEVARCHAR2(7)Y LOINC code for lab item
LOINC_DESCRIPTIONVARCHAR2(100)Y LOINC description for lab item

Primary key:

Constraint NameColumns
MIMIC2V26.D_LABITEMS_PKITEMID

Options:

OptionSettings
TablespaceMIMIC2_DAT
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
MIMIC2V26.D_LABITEMS_PKNORMALUNIQUEITEMID DDL script

Referenced by:

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