当前位置：文江博客话题详情

magento数据库结构？

发布于 2024-09-18 09:20:52 字数 226 浏览 4 评论 0原文

目前正在与magento项目合作.. 我一直坚持这一点.. 那是当管理员添加任何子类别/类别时按

管理类别-> 客户设计

这里的

提供了两个选项，例如Active from和Active to.. 了解magento数据库的任何人都可以告诉我这两个值存储在哪里或在哪个表中

感谢您的任何建议或帮助！

原文

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

夏末 2024-09-25 09:20:52

我在下面列出了目录类别的属性。由于类别是 EAV 类型，因此您需要查看特定的子表来获取您的值。在本例中，custom_design_from 和 custom_design_to 是日期时间值，实体名称为 catalog_category_entity，因此您想要的表为 Catalog_category_entity_datetime。

您将发现的下一个问题是获取正确的属性 ID。由于它们可能会发生变化，因此需要运行以下 SQL 查询来获取它们：

select attribute_id, attribute_code from eav_attribute where entity_type_id = 3 and attribute_code in ('custom_design_from', 'custom_design_to');

我得到 52 和 53，但得到 YMWV。希望有帮助！

谢谢，
乔

+----------------------+--------------+
| attribute_code       | backend_type |
+----------------------+--------------+
| name                 | varchar      |
| is_active            | int          |
| url_key              | varchar      |
| description          | text         |
| image                | varchar      |
| meta_title           | varchar      |
| meta_keywords        | text         |
| meta_description     | text         |
| display_mode         | varchar      |
| landing_page         | int          |
| is_anchor            | int          |
| path                 | static       |
| position             | static       |
| all_children         | text         |
| path_in_store        | text         |
| children             | text         |
| url_path             | varchar      |
| custom_design        | varchar      |
| custom_design_apply  | int          |
| custom_design_from   | datetime     |
| custom_design_to     | datetime     |
| page_layout          | varchar      |
| custom_layout_update | text         |
| level                | static       |
| children_count       | static       |
| available_sort_by    | text         |
| default_sort_by      | varchar      |
| include_in_menu      | int          |
+----------------------+--------------+

I've listed the attributes for catalog categories below. Since categories are an EAV type, you'll need to look in a particular subtable to get your values. In this case, custom_design_from and custom_design_to are datetime values, and the name of your entity is catalog_category_entity, so the table you want is catalog_category_entity_datetime.

Next problem you'll find is getting the right attribute ID. Since they're liable to change, here's the SQL query to run in order to grab them:

select attribute_id, attribute_code from eav_attribute where entity_type_id = 3 and attribute_code in ('custom_design_from', 'custom_design_to');

I get 52 and 53, but YMWV. Hope that helps!

Thanks,
Joe

+----------------------+--------------+
| attribute_code       | backend_type |
+----------------------+--------------+
| name                 | varchar      |
| is_active            | int          |
| url_key              | varchar      |
| description          | text         |
| image                | varchar      |
| meta_title           | varchar      |
| meta_keywords        | text         |
| meta_description     | text         |
| display_mode         | varchar      |
| landing_page         | int          |
| is_anchor            | int          |
| path                 | static       |
| position             | static       |
| all_children         | text         |
| path_in_store        | text         |
| children             | text         |
| url_path             | varchar      |
| custom_design        | varchar      |
| custom_design_apply  | int          |
| custom_design_from   | datetime     |
| custom_design_to     | datetime     |
| page_layout          | varchar      |
| custom_layout_update | text         |
| level                | static       |
| children_count       | static       |
| available_sort_by    | text         |
| default_sort_by      | varchar      |
| include_in_menu      | int          |
+----------------------+--------------+

回复收藏 0 原文

风尘浪孓 2024-09-25 09:20:52

Active from is an attribute whose attribute_code is custom_design_from(attribute_id 57) and Active To is an attribute whose attribute_code(attribute_id 58) is custom_design_to.
This both attributes value are stored in database table `catalog_category_entity_datetime`.

检查上面的表格，其中entity_id的值是您的类别ID，attribute_id是57，并且活动值存储在表的value字段中，相同的活动值存储在value中其中entity_id字段是你的类别id，attribute_id是58。

Active from is an attribute whose attribute_code is custom_design_from(attribute_id 57) and Active To is an attribute whose attribute_code(attribute_id 58) is custom_design_to.
This both attributes value are stored in database table `catalog_category_entity_datetime`.

Check above table with row like value of entity_id is your category id, attribute_id is 57 and active from value is store in value field of table same active to value is stored in value field with entity_id is your category id, attribute_id is 58.

回复收藏 0 原文

~没有更多了~