WebSphere Commerce database table: CTXDATA

WebSphere Commerce database table: CTXDATA

This table contains the data that associates with a particular activity.
Column Descriptions
Column Name Column Type Description
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.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235148950 ACTIVITY_ID+NAME Primary Key
I0000841 ACTIVITY_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1085 ACTIVITY_ID CTXMGMT ACTIVITY_ID Cascade

Column Name	Column Type	Description
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 Name	Indexed Column Names	Index Type
SQL060903235148950	ACTIVITY_ID+NAME	Primary Key
I0000841	ACTIVITY_ID	Non-Unique Index