Reference > Database > WebSphere Commerce database tables > C


WebSphere Commerce database table: CTXDATA

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

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
SQL100520030322500 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

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search