Footprints Data Model

Table
Name sys_session
Comment Deprecated in favor of a new locking mechanism.

Column
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