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