WebSphere Commerce database table: TKLRACTDSC

WebSphere Commerce database table: TKLRACTDSC

This table holds the description of actions that can be performed on to-do items.
Column Descriptions
Column Name Column Type Description
TKLRACTION_ID INTEGER NOT NULL The ID of the tickler action for this description.
LANGUAGE_ID INTEGER NOT NULL The ID of the language used for the description. For a list of language components, see the LANGUAGE table.
DESCRIPTION VARCHAR(254) Description of the tickler action in the language specified by LANGUAGE_ID.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235302190 TKLRACTION_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1204 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_1205 TKLRACTION_ID TKLRACTION TKLRACTION_ID Cascade

Column Name	Column Type	Description
TKLRACTION_ID	INTEGER NOT NULL	The ID of the tickler action for this description.
LANGUAGE_ID	INTEGER NOT NULL	The ID of the language used for the description. For a list of language components, see the LANGUAGE table.
DESCRIPTION	VARCHAR(254)	Description of the tickler action in the language specified by LANGUAGE_ID.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1204	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade
F_1205	TKLRACTION_ID	TKLRACTION	TKLRACTION_ID	Cascade