论坛主题数据表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 |
免责声明:好库网所展示的信息由买卖双方自行提供,其真实性、准确性和合法性由信息发布人负责。好库网不提供任何保证,并不承担任何法律责任。