Reference > Database > WebSphere Commerce database tables > T
WebSphere Commerce database table: TKLRACTION
This table holds the actions that can be performed on to-do items.
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...
- 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 SQL100520030441540 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
Referenced By 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 _vcc_freeselect_bottom_