This table holds the history of actions that are performed on to-do items.
Column Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index 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 Name | Column Name(s) | Foreign Table Name | Foreign 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 |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.