Metadata Properties Reference
Metadata Properties enable you to configure metadata information for the database concepts and their properties.
Metadata Properties for a Database Concept
Property Name | Global Variables supported? | Description |
---|---|---|
OBJECT_NAME
|
Yes | Name of the database table or view. |
PRIMARY_KEY_PROPS
|
No | Displays a comma-separated list of names of database concept properties that are derived from primary key columns in the database, enclosed in square brackets, for example,
[ORDER_ID, ITEM_ID] . The values are generated at import time. If there are no primary key columns, the square brackets are empty.
The value of
Primary key information from
|
EXTID_PROPS
|
No | Not created by the import utility. Add as needed. If none of the columns imported for a database concept are primary keys (and so
PRIMARY_KEY_PROPS has no value), or if you want to override the value of
PRIMARY_KEY_PROPS , use the
EXTID_PROPS metadata property to define an
extId value. The value of these property names at runtime should uniquely identify a database concept instance.
Set the value to a comma-separated list of database concept property names. The value is case sensitive. Unlike
The value of
|
JDBC_RESOURCE
|
No | A JDBC URI to which this database concept maps. |
OBJECT_TYPE
|
Yes |
|
SCHEMA_NAME
|
Yes | Name of the database schema from where this concept originates. |
Metadata Properties for a Database Concept Property
Property Name | Description |
---|---|
Primitive Properties | |
COLUMN_NAME
|
Name of the column in the database. |
DATA_TYPE
|
Data type as specified in the database. |
LENGTH
|
Length as defined in the database. |
PRECISION
|
Precision as defined in the database. |
Relationship Properties | |
REL_TYPE
|
C - If the concept held in this property is a contained concept.
R - If it is a reference. Note: All relationships are modeled as references, even those defined as contained concepts.
|
REL_KEYS
|
A table containing join keys mapping source and target concepts.
The Name and Value fields show the column names from the database tables that either form a Containment or Reference relationship. Name is the property name of the concept, and Value is the property name of the related concept. |