Each row of this table defines a new primary-foreign relationship between two tables of the commerce. This option provides a specific application/business to impose a primary-foreign relationship instead of creating a new constraint at the metadata level. Thus it avoids possible frequent changes in the database metadata. This relations are picked up by the IdResolver in the process of resolution of Identifiers.
Column Description(s):
Column Name | Column Type | Description |
TABLENAME |
CHAR(18) NOT NULL |
The table which is considered as primary table of the imposed relationship. |
FKTABLE_NAME |
CHAR(18) NOT NULL |
The table which is considered as foreign table of the imposed relationship. |
FKCOLUMN_NAME |
CHAR(18) NOT NULL |
The column which is considered as foreign column of the imposed relationship. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000300 |
TABLENAME+FKTABLE_NAME+FKCOLUMN_NAME |
Unique Index |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.