WebSphere Commerce database table: CTXDATA

This table contains the data that associates with a particular activity.


Column Description(s):
Column NameColumn TypeDescription
ACTIVITY_ID BIGINT NOT NULL The identifier of the activity. Foreign Key to the CTXMGMT table
NAME VARCHAR(128) NOT NULL The name of the context data object
SERVALUE VARCHAR(2048) The value associated with the context data.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031219440 ACTIVITY_ID+NAME Primary Key
I0000841 ACTIVITY_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1085 ACTIVITY_ID CTXMGMT ACTIVITY_ID Cascade

Feedback