👤 Magento_Customer · engine innodb
customer_eav_attribute_website
Customer Eav Attribute Website
Neighbourhood (1-hop foreign-key graph — showing 2 of 2)
flowchart LR c["customer_eav_attribute_website"]:::center n0["eav_attribute"] click n0 "/schema/table/eav_attribute" n0 -- attribute_id --> c n1["store_website"] click n1 "/schema/table/store_website" n1 -- website_id --> c click c "/schema/table/customer_eav_attribute_website" classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px
Click a node to jump to that table.
Related tables (2)
Columns (6)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| attribute_id | smallint unsigned | no | Attribute ID | |
| website_id | smallint unsigned | no | Website ID | |
| is_visible | smallint unsigned | yes | Is Visible | |
| is_required | smallint unsigned | yes | Is Required | |
| default_value | text | yes | Default Value | |
| multiline_count | smallint unsigned | yes | Multiline Count |
Keys & indexes
Primary key: attribute_id, website_id
Indexes
- CUSTOMER_EAV_ATTRIBUTE_WEBSITE_WEBSITE_ID (website_id) btree
References (2)
- attribute_id → eav_attribute .attribute_id (on delete CASCADE)
- website_id → store_website .website_id (on delete CASCADE)