🌐 Magento_Directory · engine innodb

directory_country_region

Directory Country Region

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

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

Click a node to jump to that table.

Related tables (1)

directory_country_region_name → region_id

Columns (4)

Name	Type	Null	Default	Comment
region_id PK	int unsigned	no		Region ID
country_id	varchar(4)	no	0	Country ID in ISO-2
code	varchar(32)	yes		Region code
default_name	varchar(255)	yes		Region Name

Keys & indexes

Primary key: region_id

Indexes

DIRECTORY_COUNTRY_REGION_COUNTRY_ID (country_id) btree

Referenced by (1)

directory_country_region_name .region_id → .region_id (on delete CASCADE)