👤 Magento_Customer · engine innodb
customer_address_entity
Customer Address Entity
Neighbourhood (1-hop foreign-key graph — showing 6 of 6)
flowchart LR c["customer_address_entity"]:::center n0["customer_entity"] click n0 "/schema/table/customer_entity" n0 -- parent_id --> c n1["customer_address_entity_datetime"] click n1 "/schema/table/customer_address_entity_datetime" c -- entity_id --> n1 n2["customer_address_entity_decimal"] click n2 "/schema/table/customer_address_entity_decimal" c -- entity_id --> n2 n3["customer_address_entity_int"] click n3 "/schema/table/customer_address_entity_int" c -- entity_id --> n3 n4["customer_address_entity_text"] click n4 "/schema/table/customer_address_entity_text" c -- entity_id --> n4 n5["customer_address_entity_varchar"] click n5 "/schema/table/customer_address_entity_varchar" c -- entity_id --> n5 click c "/schema/table/customer_address_entity" classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px
Click a node to jump to that table.
Related tables (6)
Columns (25)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| entity_id PK | int unsigned | no | Entity ID | |
| increment_id | varchar(50) | yes | Increment ID | |
| parent_id | int unsigned | yes | Parent ID | |
| created_at | timestamp | no | CURRENT_TIMESTAMP | Created At |
| updated_at | timestamp | no | CURRENT_TIMESTAMP | Updated At |
| is_active | smallint unsigned | no | 1 | Is Active |
| city | varchar(255) | no | City | |
| company | varchar(255) | yes | Company | |
| country_id | varchar(255) | no | Country | |
| fax | varchar(255) | yes | Fax | |
| firstname | varchar(255) | no | First Name | |
| lastname | varchar(255) | no | Last Name | |
| middlename | varchar(255) | yes | Middle Name | |
| postcode | varchar(255) | yes | Zip/Postal Code | |
| prefix | varchar(40) | yes | Name Prefix | |
| region | varchar(255) | yes | State/Province | |
| region_id | int unsigned | yes | State/Province | |
| street | text | no | Street Address | |
| suffix | varchar(40) | yes | Name Suffix | |
| telephone | varchar(255) | no | Phone Number | |
| vat_id | varchar(255) | yes | VAT number | |
| vat_is_valid | int unsigned | yes | VAT number validity | |
| vat_request_date | varchar(255) | yes | VAT number validation request date | |
| vat_request_id | varchar(255) | yes | VAT number validation request ID | |
| vat_request_success | int unsigned | yes | VAT number validation request success |
Keys & indexes
Primary key: entity_id
Indexes
- CUSTOMER_ADDRESS_ENTITY_PARENT_ID (parent_id) btree
References (1)
- parent_id → customer_entity .entity_id (on delete CASCADE)
Referenced by (5)
- customer_address_entity_datetime .entity_id → .entity_id (on delete CASCADE)
- customer_address_entity_decimal .entity_id → .entity_id (on delete CASCADE)
- customer_address_entity_int .entity_id → .entity_id (on delete CASCADE)
- customer_address_entity_text .entity_id → .entity_id (on delete CASCADE)
- customer_address_entity_varchar .entity_id → .entity_id (on delete CASCADE)