The SPRING_SESSION table contains the user sessions for the SAP CC Cockpit users.
See also the SPRING_SESSION_ATTRIBUTES table.
Note Please refer to the Spring official documentation for more information on this table
and its columns.
| Schema Version | 2022.0.2 | |
| Partitioned | No | |
The SPRING_SESSION table is defined by the following columns in your back-end database. See the column details for more information.
| Name | PK | FK | IX | Uses | Used by | Definition |
|---|---|---|---|---|---|---|
| PRIMARY_ID | PK_SPRING_SESSION |
|
The primary identifier of the user session | |||
| SESSION_ID | IX_SPRING_SESSION |
|
The unique identifier of the user session | |||
| CREATION_TIME |
|
The time when the user session was created | ||||
| LAST_ACCESS_TIME |
|
The last time the user session was accessed | ||||
| MAX_INACTIVE_INTERVAL |
|
The maximum inactive interval between requests before this user session will be invalidated | ||||
| EXPIRY_TIME | IX_SPRING_SESSION_EXPIRY_TIME |
|
The time when the user session will expire | |||
| PRINCIPAL_NAME | IX_SPRING_SESSION_PRINCIPAL_NAME |
|
The login of the SAP CC user associated to the user session |
The database schema defines the following columns. Check the definitions, types, available indexes, and formats:
| Definition | The primary identifier of the user session |
| Type | NVARCHAR(64), NOT NULL |
| Primary Key | PK_SPRING_SESSION |
| Definition | The unique identifier of the user session |
| Type | NVARCHAR(64), NOT NULL |
| Available Index | IX_SPRING_SESSION |
| Definition | The time when the user session was created |
| Type | DECIMAL(28), NOT NULL |
| Definition | The last time the user session was accessed |
| Type | DECIMAL(28), NOT NULL |
| Definition | The maximum inactive interval between requests before this user session will be invalidated |
| Type | DECIMAL(10), NOT NULL |
| Definition | The time when the user session will expire |
| Type | DECIMAL(28), NOT NULL |
| Available Index | IX_SPRING_SESSION_EXPIRY_TIME |
| Definition | The login of the SAP CC user associated to the user session |
| Type | NVARCHAR(256), NULL |
| Available Index | IX_SPRING_SESSION_PRINCIPAL_NAME |
See the primary key information:
| Column(s) | PRIMARY_ID |
| Tablespace | COCKPIT_INDX |
The following database indexes are available in the SPRING_SESSION database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:
| Indexed Column(s) | SESSION_ID |
| Unique | Yes |
| Partitioned | No |
| Indexed Column(s) | EXPIRY_TIME |
| Unique | No |
| Partitioned | No |
| Indexed Column(s) | PRINCIPAL_NAME |
| Unique | No |
| Partitioned | No |
