WebSphere Commerce database table: TKLRACTION

This table holds the actions that can be performed on to-do items.

Column Descriptions
Column Name Column Type Description
TKLRACTION_ID INTEGER NOT NULL Generated unique key.
STORE_ID INTEGER NOT NULL Store for which this action is valid. Stores may establish their own tickler actions.
CODE CHAR(30) NOT NULL Code used to reference the tickler action.
CLOSINGACTION SMALLINT NOT NULL DEFAULT 0 Whether action resolves the issue and hence should close the tickler after this action is recorded. Valid values are as follows:

  • 0 = this action will not close the tickler

  • 1 = this action will close the tickler

MARKFORDELETE INTEGER NOT NULL DEFAULT 0 Indicates if this tickler reason has been marked for deletion:

  • 0 = No.

  • 1 = Yes, this tickler reason has been marked for deletion.

FIELD1 VARCHAR(254) Customizable
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000937 CODE+STORE_ID Unique Index
SQL060903235302320 TKLRACTION_ID Primary Key
I0000947 STORE_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1206 STORE_ID STORE STORE_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1203 TKLRACTION_ID TKLACTHIST TKLRACTION_ID Cascade
F_1205 TKLRACTION_ID TKLRACTDSC TKLRACTION_ID Cascade