🔐 Magento_User · engine innodb

admin_user

Admin User Table

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

flowchart LR
  c["admin_user"]:::center
  n0["oauth_token"]
  click n0 "/schema/table/oauth_token"
  c -- admin_id --> n0
  n1["admin_adobe_ims_webapi"]
  click n1 "/schema/table/admin_adobe_ims_webapi"
  c -- admin_user_id --> n1
  n2["admin_passwords"]
  click n2 "/schema/table/admin_passwords"
  c -- user_id --> n2
  n3["admin_user_expiration"]
  click n3 "/schema/table/admin_user_expiration"
  c -- user_id --> n3
  n4["admin_user_session"]
  click n4 "/schema/table/admin_user_session"
  c -- user_id --> n4
  n5["adobe_user_profile"]
  click n5 "/schema/table/adobe_user_profile"
  c -- admin_user_id --> n5
  click c "/schema/table/admin_user"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (9)

admin_adobe_ims_webapi → admin_user_id admin_passwords → user_id admin_user_expiration → user_id admin_user_session → user_id adobe_user_profile → admin_user_id oauth_token → admin_id release_notification_viewer_log → viewer_id tfa_user_config → user_id ui_bookmark → user_id

Columns (19)

Name	Type	Null	Default	Comment
user_id PK	int unsigned	no		User ID
firstname	varchar(32)	yes		User First Name
lastname	varchar(32)	yes		User Last Name
email	varchar(128)	yes		User Email
username	varchar(40)	yes		User Login
password	varchar(255)	no		User Password
created	timestamp	no	CURRENT_TIMESTAMP	User Created Time
modified	timestamp	no	CURRENT_TIMESTAMP	User Modified Time
logdate	timestamp	yes		User Last Login Time
lognum	smallint unsigned	no	0	User Login Number
reload_acl_flag	smallint	no	0	Reload ACL
is_active	smallint	no	1	User Is Active
extra	text	yes		User Extra Data
rp_token	text	yes		Reset Password Link Token
rp_token_created_at	timestamp	yes		Reset Password Link Token Creation Date
interface_locale	varchar(16)	no	en_US	Backend interface locale
failures_num	smallint	yes	0	Failure Number
first_failure	timestamp	yes		First Failure
lock_expires	timestamp	yes		Expiration Lock Dates

Keys & indexes

Primary key: user_id

Unique

ADMIN_USER_USERNAME (username)

Referenced by (9)

admin_adobe_ims_webapi .admin_user_id → .user_id (on delete CASCADE)
admin_passwords .user_id → .user_id (on delete CASCADE)
admin_user_expiration .user_id → .user_id (on delete CASCADE)
admin_user_session .user_id → .user_id (on delete CASCADE)
adobe_user_profile .admin_user_id → .user_id (on delete CASCADE)
oauth_token .admin_id → .user_id (on delete CASCADE)
release_notification_viewer_log .viewer_id → .user_id (on delete CASCADE)
tfa_user_config .user_id → .user_id (on delete CASCADE)
ui_bookmark .user_id → .user_id (on delete CASCADE)