🔌 Magento_Integration · engine innodb

integration

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

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

Click a node to jump to that table.

Related tables (1)

consumer_id → oauth_consumer

Columns (10)

Name	Type	Null	Default	Comment
integration_id PK	int unsigned	no		Integration ID
name	varchar(255)	no		Integration name is displayed in the admin interface
email	varchar(255)	no		Email address of the contact person
endpoint	varchar(255)	yes		Endpoint for posting consumer credentials
status	smallint unsigned	no		Integration status
consumer_id	int unsigned	yes		Oauth consumer
created_at	timestamp	no	CURRENT_TIMESTAMP	Creation Time
updated_at	timestamp	no	CURRENT_TIMESTAMP	Update Time
setup_type	smallint unsigned	no	0	Integration type - manual or config file
identity_link_url	varchar(255)	yes		Identity linking Url

Keys & indexes

Primary key: integration_id

Unique

INTEGRATION_NAME (name)
INTEGRATION_CONSUMER_ID (consumer_id)

References (1)

consumer_id → oauth_consumer .entity_id (on delete CASCADE)