🔌 Magento_Integration · engine innodb

oauth_token

OAuth Tokens

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

flowchart LR
  c["oauth_token"]:::center
  n0["admin_user"]
  click n0 "/schema/table/admin_user"
  n0 -- admin_id --> c
  n1["oauth_consumer"]
  click n1 "/schema/table/oauth_consumer"
  n1 -- consumer_id --> c
  n2["customer_entity"]
  click n2 "/schema/table/customer_entity"
  n2 -- customer_id --> c
  click c "/schema/table/oauth_token"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (3)

admin_id → admin_user consumer_id → oauth_consumer customer_id → customer_entity

Columns (13)

Name	Type	Null	Default	Comment
entity_id PK	int unsigned	no		Entity ID
consumer_id	int unsigned	yes		Oauth Consumer ID
admin_id	int unsigned	yes		Admin user ID
customer_id	int unsigned	yes		Customer user ID
type	varchar(16)	no		Token Type
token	varchar(32)	no		Token
secret	varchar(128)	no		Token Secret
verifier	varchar(32)	yes		Token Verifier
callback_url	text	no		Token Callback URL
revoked	smallint unsigned	no	0	Is Token revoked
authorized	smallint unsigned	no	0	Is Token authorized
user_type	int	yes		User type
created_at	timestamp	no	CURRENT_TIMESTAMP	Token creation timestamp

Keys & indexes

Primary key: entity_id

Unique

OAUTH_TOKEN_TOKEN (token)

Indexes

OAUTH_TOKEN_CONSUMER_ID (consumer_id) btree
OAUTH_TOKEN_CREATED_AT (created_at) btree

References (3)

admin_id → admin_user .user_id (on delete CASCADE)
consumer_id → oauth_consumer .entity_id (on delete CASCADE)
customer_id → customer_entity .entity_id (on delete CASCADE)