WebSphere Commerce database table: CHKARRANG

This table associates the defined store commands (SCHCMD) with the defined check commands (CHKCMD).

Column Descriptions
Column Name Column Type Description
CHKCMD_ID INTEGER NOT NULL The unique identifier of the check command.
SCHCMD_ID BIGINT NOT NULL The unique identifier of the store scheduler command.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235140670 CHKCMD_ID+SCHCMD_ID Primary Key
I0000533 SCHCMD_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_234 CHKCMD_ID CHKCMD CHKCMD_ID Cascade
F_235 SCHCMD_ID SCHCMD SCHCMD_ID Cascade
Related reference