help_relation - xiaoboluo768/mysql-system-schema GitHub Wiki
- 该表提供查询帮助关键字信息和主题信息之间的映射，用于关联查询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表