WebSphere Commerce database table: CTXMGMT

This table contains the management information of each context service activity.


Column Description(s):
Column NameColumn TypeDescription
ACTIVITY_ID BIGINT NOT NULL This is the generated primary key of the table.
CALLER_ID BIGINT The caller who is associated with this activity. Foreign Key to the MEMBER table.
STARTTIME TIMESTAMP The start time of the activity
ENDTIME TIMESTAMP The end time of the activity.
STATUS CHAR(1) NOT NULL The status of the activity.
U = uninitialized
A = active
T = terminated
E = expired
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
STORE_ID INTEGER The store that is associated with this activity. Foreign Key to the STORE table.
RUNAS_ID BIGINT The user that this activity is to be run under. Foreign Key to the MEMBER table.
LASTACCESSTIME TIMESTAMP The time that this activity is last accessed. This column will only be updated when the expiry management feature in the Business Context Service is enabled.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031219600 ACTIVITY_ID Primary Key
I0000831 CALLER_ID Non-Unique Index
I0000895 STORE_ID Non-Unique Index
I0000896 RUNAS_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1086 CALLER_ID MEMBER MEMBER_ID Cascade
F_1143 RUNAS_ID MEMBER MEMBER_ID Cascade
F_1144 STORE_ID STORE STORE_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_1085 ACTIVITY_ID CTXDATA ACTIVITY_ID Cascade

Feedback