I have created product attribute with the dropdown in Magento.
Product attribute backend type is int and attribute is filterable with results. but then find the values of that attribute in the catalog_product_entity_int table but it's not showing. but when I am finding in the catalog_product_index_eav table it's showing. I am confused what is the use of catalog_product_index_eav table and why it's showing value in that table.