🌐 Magento_Directory · engine innodb

directory_country_region_name

Directory Country Region Name

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

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

Click a node to jump to that table.

Related tables (1)

region_id → directory_country_region

Columns (3)

Name	Type	Null	Default	Comment
locale	varchar(16)	no		Locale
region_id	int unsigned	no	0	Region ID
name	varchar(255)	yes		Region Name

Keys & indexes

Primary key: locale, region_id

Indexes

DIRECTORY_COUNTRY_REGION_NAME_REGION_ID (region_id) btree

References (1)

region_id → directory_country_region .region_id (on delete CASCADE)