WebSphere Commerce database table: CATCNTR

Each row of this table associates a catalog with a contract.

Column Descriptions
Column Name Column Type Description
CATALOG_ID BIGINT NOT NULL The identifier of the catalog.
CONTRACT_ID BIGINT NOT NULL The identifier of the contract.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235137100 CONTRACT_ID+CATALOG_ID Primary Key
I0000513 CATALOG_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_187 CATALOG_ID CATALOG CATALOG_ID Cascade
F_188 CONTRACT_ID CONTRACT CONTRACT_ID Cascade
Related reference