CTXMGMT

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

Column Descriptions:

NameTypeDescription
ACTIVITY_IDBIGINT NOT NULLThis is the generated primary key of the table.
CALLER_IDBIGINTThe caller who is associated with this activity. Foreign Key to the MEMBER table.
STARTTIMETIMESTAMPThe start time of the activity
ENDTIMETIMESTAMPThe end time of the activity.
STATUSCHAR (1) NOT NULLThe status of the activity. U = uninitialized A = active T = terminated E = expired
STORE_IDINTEGERThe store that is associated with this activity. Foreign Key to the STORE table.
RUNAS_IDBIGINTThe user that this activity is to be run under. Foreign Key to the MEMBER table.
LASTACCESSTIMETIMESTAMPThe 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.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ACTIVITY_IDPrimary Key
I0000831CALLER_IDNon-Unique Index
I0000895STORE_IDNon-Unique Index
I0000896RUNAS_IDNon-Unique Index
I0001299LASTACCESSTIMENon-Unique Index
I0001545CALLER_ID+RUNAS_ID+STORE_ID+STATUSNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1086CALLER_IDMEMBERMEMBER_IDCascade
F_1143RUNAS_IDMEMBERMEMBER_IDCascade
F_1144STORE_IDSTORESTORE_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1085ACTIVITY_IDCTXDATAACTIVITY_IDCascade