Magento

There are 7 different tables relating to category and I’m not clear on which table/column is the category id column. Can anyone shed some light on this mystery for me?

Gregg

catalog_category_entity is the “key” table, entity_id is the category’s id.  You’ll find the name of the category in catalog_category_entity_varchar.value where catalog_category_entity_varchar.entity_id=catalog_category_entity.entity_id.  If you want to know what each “value” is in catalog_category_entity_varchar/text/int/etc, tie in eav_attribute where catalog_category_entity_(int/varchar/text/etc).attribute_id=eav_attribute.attribute_id.

Just FYI, products, customers, orders, etc., are all handled in a very similar fashion.  Also, multiselect attributes are stored in foo_bar_entity_int, where the interger value equals eav_attribute_option_value.value_id.