WebSphere Commerce database table: TICKLER

This table holds to-do items requiring actions to resolve.

Column Descriptions
Column Name Column Type Description
TICKLER_ID BIGINT NOT NULL The internal reference number of the to-do item.
STATUS SMALLINT NOT NULL DEFAULT 0 Indicates the state of the tickler. Valid values are as follows:

  • 0=Tickler is in open state

  • 1=Tickler is in closed state

STORE_ID INTEGER NOT NULL The identifier of the store in which this to-do item was created.
ACTIONOBJECTTYPE CHAR(5) The type of object to which this to-do item is associated. Valid values are as follows:

  • ORDER=Order

  • QUOTE=Quote

  • RMA=Return

  • USER=Customer

ACTIONOBJECT BIGINT ID to referenced quote, order, return or customer.
TKLRREASON_ID INTEGER NOT NULL The ID of codified reason for some to be tickled.
RESPONSIBLEMEMBER BIGINT Identifier of the member who should act on this to-do item.
LOCKEDBY_ID BIGINT Identifier of the member who locked this to-do item.
CREATEDBY_ID BIGINT Identifier of the member who created this to-do item.
NEXTTICKLEDATE TIMESTAMP NOT NULL When this to-do item should next pop into the tickler queue of the responsible member.
CREATETIME TIMESTAMP NOT NULL Date and time this to-do item was created.
LOCKTIME TIMESTAMP Date and time this to-do item was locked.
LASTUPDATE TIMESTAMP Date and time this to-do item was last updated.
FIELD1 INTEGER Customizable.
FIELD2 VARCHAR(254) Customizable.
FIELD3 BIGINT Customizable.
LANGUAGE_ID INTEGER NOT NULL The ID of the language used for the comment. For a list of language components, see the LANGUAGE table.
TICKLERCOMMENT VARCHAR(1024) Comments on this to-do item.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
RESPONSIBLEROLE INTEGER Role which should act on tickler. Either responsible member or role should be filled.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235301900 TICKLER_ID Primary Key
I0000938 STORE_ID Non-Unique Index
I0000939 TKLRREASON_ID Non-Unique Index
I0000940 LANGUAGE_ID Non-Unique Index
I0000941 CREATEDBY_ID Non-Unique Index
I0000942 LOCKEDBY_ID Non-Unique Index
I0000948 RESPONSIBLEMEMBER+STORE_ID+STATUS+NEXTTICKLEDATE Non-Unique Index
I0000953 RESPONSIBLEROLE+STORE_ID+STATUS Non-Unique Index
I0000954 RESPONSIBLEROLE Non-Unique Index
I0000978 STATUS+NEXTTICKLEDATE Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1194 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_1195 LOCKEDBY_ID MEMBER MEMBER_ID Cascade
F_1196 CREATEDBY_ID MEMBER MEMBER_ID Cascade
F_1197 RESPONSIBLEMEMBER MEMBER MEMBER_ID Cascade
F_1217 RESPONSIBLEROLE ROLE ROLE_ID Cascade
F_1198 STORE_ID STORE STORE_ID Cascade
F_1199 TKLRREASON_ID TKLRREASON TKLRREASON_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1202 TICKLER_ID TKLACTHIST TICKLER_ID Cascade