help_relation

• 该表提供查询帮助关键字信息和主题信息之间的映射，用于关联查询help_keyword与help_topic表
• 表结构定义

CREATE TABLE `help_relation` (
  `help_topic_id` int(10) unsigned NOT NULL,
  `help_keyword_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`help_keyword_id`,`help_topic_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='keyword-topic relation';

• 表字段含义

• help_topic_id：帮助主题ID，该ID值与help_topic表中的help_topic_id相等
• help_keyword_id：帮助主题详细信息ID，该ID值与help_keyword表中的help_keyword_id相等

• 表记录内容示例

root@localhost : mysql 01:13:09> select * from help_relation limit 5;
+---------------+-----------------+
| help_topic_id | help_keyword_id |
+---------------+-----------------+
|             0 |               0 |
|           535 |               0 |
|           294 |               1 |
|           277 |               2 |
|             2 |               3 |
+---------------+-----------------+
5 rows in set (0.00 sec)

---

上一篇：help_keyword表 |下一篇：help_topic表