WebSphere Commerce database table: TICKLER

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


Column Description(s):
Column NameColumn TypeDescription
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 refenced 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. Only responsible member or role should be filled; not both.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031321790 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
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)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

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_1202 TICKLER_ID TKLACTHIST TICKLER_ID Cascade

Feedback