TKLACTHIST

This table holds the description of actions that can be performed on to-do items.

Column Descriptions:

NameTypeDescription
TKLACTHIST_IDBIGINT NOT NULLGenerated unique key.
TICKLER_IDBIGINT NOT NULLPointer to tickler for which this action applies.
TKLRACTION_IDINTEGER NOT NULLCodified tickler action.
ACTIONDATETIMESTAMP NOT NULLDate action was taken.
CREATEDBY_IDBIGINT NOT NULLHuman who created record of action.
LASTUPDATETIMESTAMP NOT NULLLast modification date.
FIELD1INTEGERCustomizable
FIELD2VARCHAR (254)Customizable
FIELD3BIGINTCustomizable
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
LANGUAGE_IDINTEGER NOT NULLLanguage in-use when this action was recorded.
ACTIONCOMMENTVARCHAR (1024)Notes on the action taken.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>TKLACTHIST_IDPrimary Key
I0000936TICKLER_ID+ACTIONDATEUnique Index
I0000944TKLRACTION_IDNon-Unique Index
I0000945LANGUAGE_IDNon-Unique Index
I0000946CREATEDBY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1200LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_1201CREATEDBY_IDMEMBERMEMBER_IDCascade
F_1202TICKLER_IDTICKLERTICKLER_IDCascade
F_1203TKLRACTION_IDTKLRACTIONTKLRACTION_IDCascade