🔌 Magento_Integration · engine innodb

oauth_consumer

OAuth Consumers

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

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

Click a node to jump to that table.

Related tables (3)

integration → consumer_id oauth_nonce → consumer_id oauth_token → consumer_id

Columns (8)

Name	Type	Null	Default	Comment
entity_id PK	int unsigned	no		Entity ID
created_at	timestamp	no	CURRENT_TIMESTAMP	Created At
updated_at	timestamp	yes	0	Updated At
name	varchar(255)	no		Name of consumer
key	varchar(32)	no		Key code
secret	varchar(128)	no		Secret code
callback_url	text	yes		Callback URL
rejected_callback_url	text	no		Rejected callback URL

Keys & indexes

Primary key: entity_id

Unique

OAUTH_CONSUMER_KEY (key)
OAUTH_CONSUMER_SECRET (secret)

Indexes

OAUTH_CONSUMER_CREATED_AT (created_at) btree
OAUTH_CONSUMER_UPDATED_AT (updated_at) btree

Referenced by (3)

integration .consumer_id → .entity_id (on delete CASCADE)
oauth_nonce .consumer_id → .entity_id (on delete CASCADE)
oauth_token .consumer_id → .entity_id (on delete CASCADE)