好库网首页 | 我的好库
论坛主题数据表pre_forum_thread是我们打交道最多的一张表，列表中的主体都存在这张表里，具体结构请看下表：
| No. | Field | Comment | Type | Key | Null | Default | Extra |
|---|---|---|---|---|---|---|---|
| 1 | tid | 主题ID | mediumint(8) unsigned | PRI | NO | auto_increment | |
| 2 | fid | 版块ID | mediumint(8) unsigned | MUL | NO | 0 | |
| 3 | posttableid | 帖子分表ID | smallint(6) unsigned | NO | 0 | ||
| 4 | typeid | 主题分类ID | smallint(6) unsigned | NO | 0 | ||
| 5 | sortid | 分类信息ID | smallint(6) unsigned | MUL | NO | 0 | |
| 6 | readperm | 阅读权限 | tinyint(3) unsigned | NO | 0 | ||
| 7 | price | 售价 | smallint(6) | NO | 0 | ||
| 8 | author | 作者用户名 | char(15) | NO | |||
| 9 | authorid | 作者用户ID | mediumint(8) unsigned | MUL | NO | 0 | |
| 10 | subject | 标题 | char(80) | NO | |||
| 11 | dateline | 发布时间 | int(10) unsigned | NO | 0 | ||
| 12 | lastpost | 最后发表时间 | int(10) unsigned | NO | 0 | ||
| 13 | lastposter | 最后发表人用户名 | char(15) | NO | |||
| 14 | views | 查看次数 | int(10) unsigned | NO | 0 | ||
| 15 | replies | 回复次数 | mediumint(8) unsigned | NO | 0 | ||
| 16 | displayorder | 显示顺序 | tinyint(1) | NO | 0 | ||
| 17 | highlight | 是否高亮 | tinyint(1) | NO | 0 | ||
| 18 | digest | 是否精华 | tinyint(1) | MUL | NO | 0 | |
| 19 | rate | 是否评分 | tinyint(1) | NO | 0 | ||
| 20 | special | 特殊主题 | tinyint(1) | MUL | NO | 0 | |
| 21 | attachment | 附件 | tinyint(1) | NO | 0 | ||
| 22 | moderated | 是否被管理员改动 | tinyint(1) | NO | 0 | ||
| 23 | closed | 是否关闭主题 | mediumint(8) unsigned | NO | 0 | ||
| 24 | stickreply | 是否有回帖置顶 | tinyint(1) unsigned | NO | 0 | ||
| 25 | recommends | 推荐指数 | smallint(6) | MUL | NO | 0 | |
| 26 | recommend_add | 支持人数 | smallint(6) | NO | 0 | ||
| 27 | recommend_sub | 反对人数 | smallint(6) | NO | 0 | ||
| 28 | heats | 主题热度值 | int(10) unsigned | MUL | NO | 0 | |
| 29 | status | 主题状态 | smallint(6) unsigned | NO | 0 | ||
| 30 | isgroup | 是否为群组主题 | tinyint(1) | MUL | NO | 0 | |
| 31 | favtimes | 收藏人数 | mediumint(8) | NO | 0 | ||
| 32 | sharetimes | 分享人数 | mediumint(8) | NO | 0 | ||
| 33 | stamp | 主题鉴定(图章,图标) | tinyint(3) | NO | -1 | ||
| 34 | icon | 鉴定图片ID | tinyint(3) | NO | -1 | ||
| 35 | pushedaid | 生成的文章ID | mediumint(8) | NO | 0 |
免责声明：好库网所展示的信息由买卖双方自行提供，其真实性、准确性和合法性由信息发布人负责。好库网不提供任何保证，并不承担任何法律责任。
