WebSphere Commerce database table: TKLACTHIST

This table holds the history of actions that are performed on to-do items.


Column Description(s):
Column NameColumn TypeDescription
TKLACTHIST_ID BIGINT NOT NULL Generated unique key.
TICKLER_ID BIGINT NOT NULL Pointer to tickler for which this action applies.
TKLRACTION_ID INTEGER NOT NULL Codified tickler action.
ACTIONDATE TIMESTAMP NOT NULL Date action was taken.
CREATEDBY_ID BIGINT NOT NULL Human who created record of action.
LASTUPDATE TIMESTAMP NOT NULL Last modification date.
FIELD1 INTEGER Customizable
FIELD2 VARCHAR(254) Customizable
FIELD3 BIGINT Customizable
OPTCOUNTER SMALLINT Reserved for IBM internal use.
LANGUAGE_ID INTEGER NOT NULL Language in-use when this action was recorded.
ACTIONCOMMENT VARCHAR(1024) Notes on the action taken.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000936 TICKLER_ID+ACTIONDATE Unique Index
SQL050212031321920 TKLACTHIST_ID Primary Key
I0000944 TKLRACTION_ID Non-Unique Index
I0000945 LANGUAGE_ID Non-Unique Index
I0000946 CREATEDBY_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1200 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_1201 CREATEDBY_ID MEMBER MEMBER_ID Cascade
F_1202 TICKLER_ID TICKLER TICKLER_ID Cascade
F_1203 TKLRACTION_ID TKLRACTION TKLRACTION_ID Cascade

Feedback