Name |
Datatype |
Comment |
Is PK |
Is FK |
sys_session_id |
bigint |
The automatically generated primary key of the sys_session table. |
Yes |
No |
token |
varchar(255) |
A Global Unique IDentifier search key for the System Session, composed of
letters and numbers. It is computed by the client and typically used in
unstructured data.
|
No |
No |
app_user_id |
bigint |
A Foreign Key to the Application User table. |
No |
Yes |
is_active |
bit |
Indicates if Is Active. |
No |
No |
create_time |
datetime |
The value of a System Session, stored as a date. |
No |
No |
last_accessed_time |
datetime |
The last accessed time is not used due to performance problems. It is a
transient column.
|
No |
No |
session_type |
varchar(32) |
The value of a System Session, stored as a string. |
No |
No |