WebSphere Commerce database table: TKLRREASON

This table holds reasons for creating to-do items.


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000935 CODE+STORE_ID Unique Index
SQL050212031322370 TKLRREASON_ID Primary Key
I0000943 STORE_ID Non-Unique Index
I0000955 ASSIGNTOROLE Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1218 ASSIGNTOROLE ROLE ROLE_ID Cascade
F_1209 STORE_ID STORE STORE_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_1199 TKLRREASON_ID TICKLER TKLRREASON_ID Cascade
F_1208 TKLRREASON_ID TKLRRSNDSC TKLRREASON_ID Cascade

Feedback