Reference > Database > WebSphere Commerce database tables > R
WebSphere Commerce database table: REFKEYS
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 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.
Indexes Index Name Indexed Column Names Index Type I0000300 TABLENAME+FKTABLE_NAME+FKCOLUMN_NAME Unique Index
Related reference
_vcc_freeselect_bottom_