catalog_product_entity_int table we have one value column, can anyone help me to find the details that we are populating on the basis of which table.
as per my understanding that in the eav_attribute table, we can check the description regarding attribute but for the value of that attribute we can check in eav_attribute_option_value, I tried the same but for some default products some values i am not able to understand, kindly help me to understand the same.
like for 136 attributes, it coming 2 99 attribute it's coming 4
its new for me so please share any relevant link where i can get the eav module details
CodePudding user response:
eav_attribute
table contains all attributes created in every eav model in Magento. If you want to filter product's attributes, you can usually do a SELECT * from eav_attribute where entity_type_id = 4
, where 4 is for catalog_product
entity, mentioned at eav_entity_type
table.
Once you filter that with the query above, you'll know what attributes are available for the catalog_product entity and in witch table they are.
This is how you can associate product attributes in Magento 1.x or 2.x.
The values of each attribute are saved in a relationship of entity_id and value.