Magento Product EAV Notes "keep up with the new ..."

Magento the product information in the Sub-table, the topmost table is catalog_product_entity, contains only the product information (SKU)//table Eav_attribute, this table in Magento for all the different entities stored all the attributes// Note entity_type_id, each entity has entity_type_id. The record values in Catalog_product_entity are 10//the ID values of all entity entities stored in the Eav_entity_type table//eav_attribute_set the values of all attribute sets stored in the table//magento in eav_ The attribute table uses the Backend_type record to be able to find the product attribute backend_type//the following simple query entity_id (product_id) is 2 of the product's Name property value selecte.entity_id As product_id,var.value as Product_namefromb2c_catalog_product_entity E,b2c_eav_attribute eav,b2c_catalog_product_ Entity_varchar varwheree.entity_type_id = Eav.entity_type_idand eav.attribute_code = ' name ' and eav.attribute_id = Var.attribute_idand var.entity_id = E.entity_idand e.entity_id = 2;

Magento Product EAV Notes "keep up with the new ..."