🛒 Magento_Sales · engine innodb

sales_order_address

Sales Flat Order Address

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

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

Click a node to jump to that table.

Related tables (1)

parent_id → sales_order

Columns (26)

Name	Type	Null	Comment
entity_id PK	int unsigned	no	Entity ID
parent_id	int unsigned	yes	Parent ID
customer_address_id	int	yes	Customer Address ID
quote_address_id	int	yes	Quote Address ID
region_id	int	yes	Region ID
customer_id	int	yes	Customer ID
fax	varchar(255)	yes	Fax
region	varchar(255)	yes	Region
postcode	varchar(255)	yes	Postcode
lastname	varchar(255)	yes	Lastname
street	varchar(255)	yes	Street
city	varchar(255)	yes	City
email	varchar(255)	yes	Email
telephone	varchar(255)	yes	Phone Number
country_id	varchar(2)	yes	Country ID
firstname	varchar(255)	yes	Firstname
address_type	varchar(255)	yes	Address Type
prefix	varchar(255)	yes	Prefix
middlename	varchar(255)	yes	Middlename
suffix	varchar(255)	yes	Suffix
company	varchar(255)	yes	Company
vat_id	text	yes	Vat ID
vat_is_valid	smallint	yes	Vat Is Valid
vat_request_id	text	yes	Vat Request ID
vat_request_date	text	yes	Vat Request Date
vat_request_success	smallint	yes	Vat Request Success

Keys & indexes

Primary key: entity_id

Indexes

SALES_ORDER_ADDRESS_PARENT_ID (parent_id) btree

References (1)

parent_id → sales_order .entity_id (on delete CASCADE)