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