🔐 Magento_Security · engine innodb

admin_user_session

Admin User sessions table

Neighbourhood (1-hop foreign-key graph — showing 1 of 1)

flowchart LR
  c["admin_user_session"]:::center
  n0["admin_user"]
  click n0 "/schema/table/admin_user"
  n0 -- user_id --> c
  click c "/schema/table/admin_user_session"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (1)

user_id → admin_user

Columns (7)

Name	Type	Null	Default	Comment
id PK	int unsigned	no		Entity ID
session_id	varchar(1)	yes		Deprecated: Session ID value no longer used
user_id	int unsigned	yes		Admin User ID
status	smallint unsigned	no	1	Current Session status
created_at	timestamp	no	CURRENT_TIMESTAMP	Created Time
updated_at	timestamp	no	CURRENT_TIMESTAMP	Update Time
ip	varchar(45)	no		Remote user IP

Keys & indexes

Primary key: id

Indexes

ADMIN_USER_SESSION_SESSION_ID (session_id) btree
ADMIN_USER_SESSION_USER_ID (user_id) btree

References (1)

user_id → admin_user .user_id (on delete CASCADE)