👤 Magento_Customer · engine innodb
customer_entity
Customer Entity
Neighbourhood (1-hop foreign-key graph — showing 6 of 26)
flowchart LR c["customer_entity"]:::center n0["store"] click n0 "/schema/table/store" n0 -- store_id --> c n1["store_website"] click n1 "/schema/table/store_website" n1 -- website_id --> c n2["sales_order"] click n2 "/schema/table/sales_order" c -- customer_id --> n2 n3["customer_address_entity"] click n3 "/schema/table/customer_address_entity" c -- parent_id --> n3 n4["catalog_compare_item"] click n4 "/schema/table/catalog_compare_item" c -- customer_id --> n4 n5["product_alert_price"] click n5 "/schema/table/product_alert_price" c -- customer_id --> n5 click c "/schema/table/customer_entity" classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px
Click a node to jump to that table.
Related tables (26)
store_id → storewebsite_id → store_websitecatalog_compare_item → customer_idcatalog_compare_list → customer_idcatalog_product_frontend_action → customer_idcustomer_address_entity → parent_idcustomer_entity_datetime → entity_idcustomer_entity_decimal → entity_idcustomer_entity_int → entity_idcustomer_entity_text → entity_idcustomer_entity_varchar → entity_iddownloadable_link_purchased → customer_idlogin_as_customer_assistance_allowed → customer_idoauth_token → customer_idpaypal_billing_agreement → customer_idpersistent_session → customer_idproduct_alert_price → customer_idproduct_alert_stock → customer_idreport_compared_product_index → customer_idreport_viewed_product_index → customer_idreview_detail → customer_idsales_order → customer_idsalesrule_coupon_usage → customer_idsalesrule_customer → customer_idvault_payment_token → customer_idwishlist → customer_id
Columns (29)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| entity_id PK | int unsigned | no | Entity ID | |
| website_id | smallint unsigned | yes | Website ID | |
| varchar(255) | yes | |||
| group_id | smallint unsigned | no | 0 | Group ID |
| increment_id | varchar(50) | yes | Increment ID | |
| store_id | smallint unsigned | yes | 0 | Store 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 |
| disable_auto_group_change | smallint unsigned | no | 0 | Disable automatic group change based on VAT ID |
| created_in | varchar(255) | yes | Created From | |
| prefix | varchar(40) | yes | Name Prefix | |
| firstname | varchar(255) | yes | First Name | |
| middlename | varchar(255) | yes | Middle Name/Initial | |
| lastname | varchar(255) | yes | Last Name | |
| suffix | varchar(40) | yes | Name Suffix | |
| dob | date | yes | Date of Birth | |
| password_hash | varchar(128) | yes | Password_hash | |
| rp_token | varchar(128) | yes | Reset password token | |
| rp_token_created_at | datetime | yes | Reset password token creation time | |
| default_billing | int unsigned | yes | Default Billing Address | |
| default_shipping | int unsigned | yes | Default Shipping Address | |
| taxvat | varchar(50) | yes | Tax/VAT Number | |
| confirmation | varchar(64) | yes | Is Confirmed | |
| gender | smallint unsigned | yes | Gender | |
| failures_num | smallint | yes | 0 | Failure Number |
| first_failure | timestamp | yes | First Failure | |
| lock_expires | timestamp | yes | Lock Expiration Date | |
| session_cutoff | timestamp | yes | Session Cutoff Time |
Keys & indexes
Primary key: entity_id
Unique
- CUSTOMER_ENTITY_EMAIL_WEBSITE_ID (email, website_id)
Indexes
- CUSTOMER_ENTITY_STORE_ID (store_id) btree
- CUSTOMER_ENTITY_WEBSITE_ID (website_id) btree
- CUSTOMER_ENTITY_FIRSTNAME (firstname) btree
- CUSTOMER_ENTITY_LASTNAME (lastname) btree
References (2)
- store_id → store .store_id (on delete SET NULL)
- website_id → store_website .website_id (on delete SET NULL)
Referenced by (24)
- catalog_compare_item .customer_id → .entity_id (on delete CASCADE)
- catalog_compare_list .customer_id → .entity_id (on delete CASCADE)
- catalog_product_frontend_action .customer_id → .entity_id (on delete CASCADE)
- customer_address_entity .parent_id → .entity_id (on delete CASCADE)
- customer_entity_datetime .entity_id → .entity_id (on delete CASCADE)
- customer_entity_decimal .entity_id → .entity_id (on delete CASCADE)
- customer_entity_int .entity_id → .entity_id (on delete CASCADE)
- customer_entity_text .entity_id → .entity_id (on delete CASCADE)
- customer_entity_varchar .entity_id → .entity_id (on delete CASCADE)
- downloadable_link_purchased .customer_id → .entity_id (on delete SET NULL)
- login_as_customer_assistance_allowed .customer_id → .entity_id (on delete CASCADE)
- oauth_token .customer_id → .entity_id (on delete CASCADE)
- paypal_billing_agreement .customer_id → .entity_id (on delete CASCADE)
- persistent_session .customer_id → .entity_id (on delete CASCADE)
- product_alert_price .customer_id → .entity_id (on delete CASCADE)
- product_alert_stock .customer_id → .entity_id (on delete CASCADE)
- report_compared_product_index .customer_id → .entity_id (on delete CASCADE)
- report_viewed_product_index .customer_id → .entity_id (on delete CASCADE)
- review_detail .customer_id → .entity_id (on delete SET NULL)
- sales_order .customer_id → .entity_id (on delete SET NULL)
- salesrule_coupon_usage .customer_id → .entity_id (on delete CASCADE)
- salesrule_customer .customer_id → .entity_id (on delete CASCADE)
- vault_payment_token .customer_id → .entity_id (on delete CASCADE)
- wishlist .customer_id → .entity_id (on delete CASCADE)