This table contains the management information of
each context service activity.
Column Descriptions:
| Name | 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
|
| 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. |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | ACTIVITY_ID | Primary Key |
| I0000831 | CALLER_ID | Non-Unique Index |
| I0000895 | STORE_ID | Non-Unique Index |
| I0000896 | RUNAS_ID | Non-Unique Index |
| I0001299 | LASTACCESSTIME | Non-Unique Index |
| I0001545 | CALLER_ID+RUNAS_ID+STORE_ID+STATUS | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | 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 Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_1085 | ACTIVITY_ID | CTXDATA | ACTIVITY_ID | Cascade |