Magento Database – How Magento attributes are storing into Database

Create one attribute called “jute_shipping_yes_no” . Map this attribute to “Jute Tab” attribute_group.This attribute may based on store (or) website (or) etc. Field type, it may text or drop down or etc.. whatever you want you can create. Move this “Jute Tab” attribute groupd to your
attribute set. Once this is done, it will appear in admin -> ManageProduct -> Open any of your attribute set product -> left side you will get this “Jute tab“. Once you open this tab, you will get “jute_shipping_yes_no” field.

This above creation of attribute we will create it from admin section with in a 5-10 min (time based on you). But where this values is storing into DB level ? Will see now here,

Table :: Eav_Attribute
Create attribute code (here, “jute_shipping_yes_no”) will store in this table.If you see this value row, entity_type_id is 4. Here 4 is nothing but catalog_product (“eav_entity_type“). Which means, create attribute is related to products based attribute.Instead of “catalog_product” its “customer” means, created attribute is related to customer based attribute.

Table :: Eav Attribute Group
Created “Jute Tab” will appear in this table. Which means , you can find easily, this is attribute group which is mapped with which attribute_set_id (“default” or “JuteDefault” or which one created by you) and what is sorting order.

Table :: Eav Attribute Label
In this table, you will get created what is the lable of “jute_shipping_yes_no” attribute code. “attribute_Id” column will give attribute Code entityID.

Table :: Eav Attribute Option
From above attribute code “jute_shipping_yes_no” is i created with “dropdown” option.If created attribute is dropdown then this will create one row from eav_attribute_option table. We will get this dropdown option values from “Eav_Attribute_Option_value ” table.

Table ::Eav Attribute Set
Normally before starting of the website, we have to finalise which attribute set we are going to follow. “Default” is a default attribute set of magento. But the option is there to create a new attribute set based on your requirement. Here “JuteDefault” is my attribute set.