WebSphere Commerce database table: TKLRREASON

This table holds reasons for creating to-do items.

Column Descriptions
Column Name Column Type Description
TKLRREASON_ID INTEGER NOT NULL Generated unique key.
STORE_ID INTEGER NOT NULL The Store in which the tickler reason is defined. Stores may establish their own tickler reasons.
SYSTEMDEFINED SMALLINT NOT NULL DEFAULT 0 Indicates if this tickler reason is used by system defined tickler:

  • 0 = No.

  • 1 = Yes, this tickler reason is used by system defined tickler.

CODE CHAR(30) NOT NULL Code, consistent across stores, for reasons used for creating ticklers.
TICKLEFREQUENCY INTEGER NOT NULL DEFAULT 0 How soon after an action is taken should ticklers of this reason reappear in the tickler queue. Measured in minutes
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.
ASSIGNTOROLE INTEGER Role to assign tickler to.

Indexes
Index Name Indexed Column Names Index Type
I0000935 CODE+STORE_ID Unique Index
SQL060903235302490 TKLRREASON_ID Primary Key
I0000943 STORE_ID Non-Unique Index
I0000955 ASSIGNTOROLE Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1218 ASSIGNTOROLE ROLE ROLE_ID Cascade
F_1209 STORE_ID STORE STORE_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1199 TKLRREASON_ID TICKLER TKLRREASON_ID Cascade
F_1208 TKLRREASON_ID TKLRRSNDSC TKLRREASON_ID Cascade