🗃️ Magento_Eav · engine innodb
eav_entity_type
Eav Entity Type
Neighbourhood (1-hop foreign-key graph — showing 6 of 10)
flowchart LR c["eav_entity_type"]:::center n0["eav_attribute"] click n0 "/schema/table/eav_attribute" c -- entity_type_id --> n0 n1["eav_entity"] click n1 "/schema/table/eav_entity" c -- entity_type_id --> n1 n2["eav_entity_datetime"] click n2 "/schema/table/eav_entity_datetime" c -- entity_type_id --> n2 n3["eav_entity_decimal"] click n3 "/schema/table/eav_entity_decimal" c -- entity_type_id --> n3 n4["eav_entity_int"] click n4 "/schema/table/eav_entity_int" c -- entity_type_id --> n4 n5["eav_entity_text"] click n5 "/schema/table/eav_entity_text" c -- entity_type_id --> n5 click c "/schema/table/eav_entity_type" classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px
Click a node to jump to that table.
Related tables (10)
eav_attribute → entity_type_ideav_attribute_set → entity_type_ideav_entity → entity_type_ideav_entity_datetime → entity_type_ideav_entity_decimal → entity_type_ideav_entity_int → entity_type_ideav_entity_store → entity_type_ideav_entity_text → entity_type_ideav_entity_varchar → entity_type_ideav_form_type_entity → entity_type_id
Columns (16)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| entity_type_id PK | smallint unsigned | no | Entity Type ID | |
| entity_type_code | varchar(50) | no | Entity Type Code | |
| entity_model | varchar(255) | no | Entity Model | |
| attribute_model | varchar(255) | yes | Attribute Model | |
| entity_table | varchar(255) | yes | Entity Table | |
| value_table_prefix | varchar(255) | yes | Value Table Prefix | |
| entity_id_field | varchar(255) | yes | Entity ID Field | |
| is_data_sharing | smallint unsigned | no | 1 | Defines Is Data Sharing |
| data_sharing_key | varchar(100) | yes | default | Data Sharing Key |
| default_attribute_set_id | smallint unsigned | no | 0 | Default Attribute Set ID |
| increment_model | varchar(255) | yes | Increment Model | |
| increment_per_store | smallint unsigned | no | 0 | Increment Per Store |
| increment_pad_length | smallint unsigned | no | 8 | Increment Pad Length |
| increment_pad_char | varchar(1) | no | 0 | Increment Pad Char |
| additional_attribute_table | varchar(255) | yes | Additional Attribute Table | |
| entity_attribute_collection | varchar(255) | yes | Entity Attribute Collection |
Keys & indexes
Primary key: entity_type_id
Indexes
- EAV_ENTITY_TYPE_ENTITY_TYPE_CODE (entity_type_code) btree
Referenced by (10)
- eav_attribute .entity_type_id → .entity_type_id (on delete CASCADE)
- eav_attribute_set .entity_type_id → .entity_type_id (on delete CASCADE)
- eav_entity .entity_type_id → .entity_type_id (on delete CASCADE)
- eav_entity_datetime .entity_type_id → .entity_type_id (on delete CASCADE)
- eav_entity_decimal .entity_type_id → .entity_type_id (on delete CASCADE)
- eav_entity_int .entity_type_id → .entity_type_id (on delete CASCADE)
- eav_entity_store .entity_type_id → .entity_type_id (on delete CASCADE)
- eav_entity_text .entity_type_id → .entity_type_id (on delete CASCADE)
- eav_entity_varchar .entity_type_id → .entity_type_id (on delete CASCADE)
- eav_form_type_entity .entity_type_id → .entity_type_id (on delete CASCADE)