EC-Magento2-store-eav
Magento2-eav erd
Tables (22)
eav_attribute
- attribute_id — smallint(5) — Primary key — NOT NULL — Attribute Id
- entity_type_id — smallint(5) — Foreign key → eav_entity_type.entity_type_id — NOT NULL — Entity Type Id
- attribute_code — varchar(255) — Attribute Code
- attribute_model — varchar(255) — Attribute Model
- backend_model — varchar(255) — Backend Model
- backend_type — varchar(8) — NOT NULL — Backend Type
- backend_table — varchar(255) — Backend Table
- frontend_model — varchar(255) — Frontend Model
- frontend_input — varchar(50) — Frontend Input
- frontend_label — varchar(255) — Frontend Label
- frontend_class — varchar(255) — Frontend Class
- source_model — varchar(255) — Source Model
- is_required — smallint(5) — NOT NULL — Defines Is Required
- is_user_defined — smallint(5) — NOT NULL — Defines Is User Defined
- default_value — text — Default Value
- is_unique — smallint(5) — NOT NULL — Defines Is Unique
- note — varchar(255) — Note
eav_attribute_group
- attribute_group_id — smallint(5) — Primary key — NOT NULL — Attribute Group Id
- attribute_set_id — smallint(5) — Foreign key → eav_attribute_set.attribute_set_id — NOT NULL — Attribute Set Id
- attribute_group_name — varchar(255) — Attribute Group Name
- sort_order — smallint(6) — NOT NULL — Sort Order
- default_id — smallint(5) — Default Id
- attribute_group_code — varchar(255) — NOT NULL — Attribute Group Code
- tab_group_code — varchar(255) — Tab Group Code
eav_attribute_label
- attribute_label_id — int(10) — Primary key — NOT NULL — Attribute Label Id
- attribute_id — smallint(5) — Foreign key → eav_attribute.attribute_id — NOT NULL — Attribute Id
- store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store Id
- value — varchar(255) — Value
eav_attribute_option
- option_id — int(10) — Primary key — NOT NULL — Option Id
- attribute_id — smallint(5) — Foreign key → eav_attribute.attribute_id — NOT NULL — Attribute Id
- sort_order — smallint(5) — NOT NULL — Sort Order
eav_attribute_option_swatch
- swatch_id — int(10) — Primary key — NOT NULL — Swatch ID
- store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store ID
- option_id — int(10) — Foreign key → eav_attribute_option.option_id — NOT NULL — Option ID
- type — smallint(5) — NOT NULL — Swatch type: 0 - text, 1 - visual color, 2 - visual image
- value — varchar(255) — Swatch Value
eav_attribute_option_value
- value_id — int(10) — Primary key — NOT NULL — Value Id
- store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store Id
- option_id — int(10) — Foreign key → eav_attribute_option.option_id — NOT NULL — Option Id
- value — varchar(255) — Value
eav_attribute_set
- attribute_set_id — smallint(5) — Primary key — NOT NULL — Attribute Set Id
- entity_type_id — smallint(5) — Foreign key → eav_entity_type.entity_type_id — NOT NULL — Entity Type Id
- attribute_set_name — varchar(255) — Attribute Set Name
- sort_order — smallint(6) — NOT NULL — Sort Order
eav_entity
- entity_id — int(10) — Primary key — NOT NULL — Entity Id
- entity_type_id — smallint(5) — Foreign key → eav_entity_type.entity_type_id — NOT NULL — Entity Type Id
- store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store Id
- attribute_set_id — smallint(5) — NOT NULL — Attribute Set Id
- increment_id — varchar(50) — Increment Id
- parent_id — int(10) — NOT NULL — Parent Id
- created_at — timestamp — NOT NULL — Created At
- updated_at — timestamp — NOT NULL — Updated At
- is_active — smallint(5) — NOT NULL — Defines Is Entity Active
eav_entity_attribute
- entity_attribute_id — int(10) — Primary key — NOT NULL — Entity Attribute Id
- attribute_id — smallint(5) — Foreign key → eav_attribute.attribute_id — NOT NULL — Attribute Id
- attribute_group_id — smallint(5) — Foreign key → eav_attribute_group.attribute_group_id — NOT NULL — Attribute Group Id
- entity_type_id — smallint(5) — NOT NULL — Entity Type Id
- attribute_set_id — smallint(5) — NOT NULL — Attribute Set Id
- sort_order — smallint(6) — NOT NULL — Sort Order
eav_entity_datetime
- value_id — int(11) — Primary key — NOT NULL — Value Id
- entity_id — int(10) — Foreign key → eav_entity.entity_id — NOT NULL — Entity Id
- store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store Id
- entity_type_id — smallint(5) — Foreign key → eav_entity_type.entity_type_id — NOT NULL — Entity Type Id
- attribute_id — smallint(5) — NOT NULL — Attribute Id
- value — datetime — Attribute Value
eav_entity_decimal
- value_id — int(11) — Primary key — NOT NULL — Value Id
- entity_id — int(10) — Foreign key → eav_entity.entity_id — NOT NULL — Entity Id
- entity_type_id — smallint(5) — Foreign key → eav_entity_type.entity_type_id — NOT NULL — Entity Type Id
- store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store Id
- attribute_id — smallint(5) — NOT NULL — Attribute Id
- value — decimal(12,4) — NOT NULL — Attribute Value
eav_entity_int
- value_id — int(11) — Primary key — NOT NULL — Value Id
- entity_id — int(10) — Foreign key → eav_entity.entity_id — NOT NULL — Entity Id
- entity_type_id — smallint(5) — Foreign key → eav_entity_type.entity_type_id — NOT NULL — Entity Type Id
- store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store Id
- attribute_id — smallint(5) — NOT NULL — Attribute Id
- value — int(11) — NOT NULL — Attribute Value
eav_entity_store
- entity_store_id — int(10) — Primary key — NOT NULL — Entity Store Id
- entity_type_id — smallint(5) — Foreign key → eav_entity_type.entity_type_id — NOT NULL — Entity Type Id
- store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store Id
- increment_prefix — varchar(20) — Increment Prefix
- increment_last_id — varchar(50) — Last Incremented Id
eav_entity_text
- value_id — int(11) — Primary key — NOT NULL — Value Id
- entity_id — int(10) — Foreign key → eav_entity.entity_id — NOT NULL — Entity Id
- entity_type_id — smallint(5) — Foreign key → eav_entity_type.entity_type_id — NOT NULL — Entity Type Id
- store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store Id
- attribute_id — smallint(5) — NOT NULL — Attribute Id
- value — text — NOT NULL — Attribute Value
eav_entity_type
- entity_type_id — smallint(5) — Primary key — NOT NULL — Entity Type Id
- entity_type_code — varchar(50) — NOT NULL — Entity Type Code
- entity_model — varchar(255) — NOT NULL — Entity Model
- attribute_model — varchar(255) — Attribute Model
- entity_table — varchar(255) — Entity Table
- value_table_prefix — varchar(255) — Value Table Prefix
- entity_id_field — varchar(255) — Entity Id Field
- is_data_sharing — smallint(5) — NOT NULL — Defines Is Data Sharing
- data_sharing_key — varchar(100) — Data Sharing Key
- default_attribute_set_id — smallint(5) — NOT NULL — Default Attribute Set Id
- increment_model — varchar(255) — Increment Model
- increment_per_store — smallint(5) — NOT NULL — Increment Per Store
- increment_pad_length — smallint(5) — NOT NULL — Increment Pad Length
- increment_pad_char — varchar(1) — NOT NULL — Increment Pad Char
- additional_attribute_table — varchar(255) — Additional Attribute Table
- entity_attribute_collection — varchar(255) — Entity Attribute Collection
eav_entity_varchar
- value_id — int(11) — Primary key — NOT NULL — Value Id
- entity_id — int(10) — Foreign key → eav_entity.entity_id — NOT NULL — Entity Id
- entity_type_id — smallint(5) — Foreign key → eav_entity_type.entity_type_id — NOT NULL — Entity Type Id
- store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store Id
- attribute_id — smallint(5) — NOT NULL — Attribute Id
- value — varchar(255) — Attribute Value
eav_form_element
- element_id — int(10) — Primary key — NOT NULL — Element Id
- attribute_id — smallint(5) — Foreign key → eav_attribute.attribute_id — NOT NULL — Attribute Id
- type_id — smallint(5) — Foreign key → eav_form_type.type_id — NOT NULL — Type Id
- fieldset_id — smallint(5) — Foreign key → eav_form_fieldset.fieldset_id — Fieldset Id
- sort_order — int(11) — NOT NULL — Sort Order
eav_form_fieldset
- fieldset_id — smallint(5) — Primary key — NOT NULL — Fieldset Id
- type_id — smallint(5) — Foreign key → eav_form_type.type_id — NOT NULL — Type Id
- code — varchar(64) — NOT NULL — Code
- sort_order — int(11) — NOT NULL — Sort Order
eav_form_fieldset_label
- store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store Id
- fieldset_id — smallint(5) — Foreign key → eav_form_fieldset.fieldset_id — NOT NULL — Fieldset Id
- label — varchar(255) — NOT NULL — Label
eav_form_type
- type_id — smallint(5) — Primary key — NOT NULL — Type Id
- store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store Id
- code — varchar(64) — NOT NULL — Code
- label — varchar(255) — NOT NULL — Label
- is_system — smallint(5) — NOT NULL — Is System
- theme — varchar(64) — Theme
eav_form_type_entity
- type_id — smallint(5) — Foreign key → eav_form_type.type_id — NOT NULL — Type Id
- entity_type_id — smallint(5) — Foreign key → eav_entity_type.entity_type_id — NOT NULL — Entity Type Id
store
- store_id — smallint(5) — Primary key — NOT NULL — Store Id