This table contains the management information of each context service activity.
Column Name | Column Type | Description |
---|---|---|
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 Name | Indexed Column Names | Index 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 Name | Column Name(s) | Foreign Table Name | Foreign 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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_1085 | ACTIVITY_ID | CTXDATA | ACTIVITY_ID | Cascade |