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

Description:

Mappings between parameters which do not fit in the schema. The 'category' field provides the types of mappings

DDL script

Columns

NameTypeNullableDefault valueComment
PARAM1_STRVARCHAR2(50)Y The domain element (the "key") of the mapping, as a string.
PARAM1_NUMNUMBER(38)Y The domain element (the "key") of the mapping, as a number.
CATEGORYVARCHAR2(50)N The unique identifier indicating the type of mapping given by the row; a foreign key to D_PARAMMAP_ITEMS.CATEGORY.
PARAM2_STRVARCHAR2(50)Y The range element (the "value") of the mapping, as a string.
PARAM2_NUMNUMBER(38)Y The range element (the "value") of the mapping, as a number.
ORDER_NUMNUMBER(38)Y For multi-part mappings, the order of application.
VALID_FLGCHAR(1)N An indication of whether the mapping given by this row is currently valid; 'Y' indicates yes, while 'N' indicates no.
COMMENTSVARCHAR2(255)Y Row-specific, human-readable comments.

Options:

OptionSettings
TablespaceMIMIC2_DAT
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo