Reference > Database > WebSphere Commerce database tables > T
WebSphere Commerce database table: TKLACTHIST
This table holds the description of actions that can be performed on to-do items.
Column Name Column Type Description 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.
Indexes Index Name Indexed Column Names Index Type I0000936 TICKLER_ID+ACTIONDATE Unique Index SQL100520030441250 TKLACTHIST_ID Primary Key I0000944 TKLRACTION_ID Non-Unique Index I0000945 LANGUAGE_ID Non-Unique Index I0000946 CREATEDBY_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names 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 _vcc_freeselect_bottom_