Reference > Database > WebSphere Commerce database tables > T
WebSphere Commerce database table: TKLRREASON
This table holds reasons for creating to-do items.
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 SQL100520030441690 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
Referenced By 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 _vcc_freeselect_bottom_