Footprints Data Model

Table
Table Name System Session
Table Definition A table that holds records for currently logged in application users. It is not used for component sessions, and the last accessed time is not updated because of performance issues.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
System Session Id The automatically generated primary key of the sys_session table. LONG Yes
Token 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. VARCHAR(255) Yes
Application User Id A Foreign Key to the Application User table. LONG No
Is Active Indicates if Is Active. BOOLEAN No
Create Time The value of a System Session, stored as a date. DATE Yes
Last Accessed Time The last accessed time is not used due to performance problems. It is a transient column. DATE No
Session Type The value of a System Session, stored as a string. VARCHAR(32) No