Sessions table / sessions - Totara Learn 12 Database schema / Zoola Analytics

sessions table columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

state

BIGINT

19

0

0 means normal session

sid

VARCHAR

128

Session id

userid

BIGINT

19

null

user.id

sess_use2_fk R

sessdata

LONGTEXT

2147483647

√

null

session content

timecreated

BIGINT

19

null

timemodified

BIGINT

19

null

firstip

VARCHAR

45

√

null

lastip

VARCHAR

45

√

null

Showing 1 to 9 of 9 entries

Table contained -1 rows

sessions table indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
sess_sid_uix	Must be unique	Asc	sid
sess_sta_ix	Performance	Asc	state
sess_tim2_ix	Performance	Asc	timemodified
sess_tim_ix	Performance	Asc	timecreated
sess_use_ix	Performance	Asc	userid

Showing 1 to 6 of 6 entries

Sessions Table Schema (sessions)

Description

sessions table columns

sessions table indexes

sessions table relationships

Close relationships within degrees of separation