sessions

Contains user sessions for authentication purposes. The table is almost a direct mapping of the information that express-session requires.

Column NameData TypeNullityDefault valueDescription
idTextNon-nullUnique, non-sequential ID of the session, directly as indicated by express-session
dataTextNon-nullThe session information, in stringified JSON format.
expiresIntegerNon-nullThe expiration date of the session, extracted from the session information. Used to rapidly clean up expired sessions.