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 Descriptions:
| Name | 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 NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| I0000300 | TABLENAME+FKTABLE_NAME+FKCOLUMN_NAME | Unique Index |