4.3 Discuz! X5.0 开源版数据字典 第3部分

本篇涵盖：pre_forum_attachment_5 附件表 ~ pre_forum_tradecomment 信用评价

pre_forum_attachment_5 附件表 - aid, mediumint, 附件id, - tid, mediumint, 主题id, - pid, int, 帖子id, - uid, mediumint, 会员id, - dateline, int, 上传时间, - filename, varchar, 原文件名, - filesize, int, 文件大小, - attachment, varchar, 服务器路径, - remote, tinyint, 是否远程附件, - description, varchar, 说明, - readperm, tinyint, 阅读权限, - price, smallint, 附件价格, - isimage, tinyint, 是否图片, - width, smallint, 附件宽度, - thumb, tinyint, 是否是缩率图, - picid, mediumint, 相册图片ID ,

pre_forum_attachment_6 附件表 - aid, mediumint, 附件id, - tid, mediumint, 主题id, - pid, int, 帖子id, - uid, mediumint, 会员id, - dateline, int, 上传时间, - filename, varchar, 原文件名, - filesize, int, 文件大小, - attachment, varchar, 服务器路径, - remote, tinyint, 是否远程附件, - description, varchar, 说明, - readperm, tinyint, 阅读权限, - price, smallint, 附件价格, - isimage, tinyint, 是否图片, - width, smallint, 附件宽度, - thumb, tinyint, 是否是缩率图, - picid, mediumint, 相册图片ID ,

pre_forum_attachment_7 附件表 - aid, mediumint, 附件id, - tid, mediumint, 主题id, - pid, int, 帖子id, - uid, mediumint, 会员id, - dateline, int, 上传时间, - filename, varchar, 原文件名, - filesize, int, 文件大小, - attachment, varchar, 服务器路径, - remote, tinyint, 是否远程附件, - description, varchar, 说明, - readperm, tinyint, 阅读权限, - price, smallint, 附件价格, - isimage, tinyint, 是否图片, - width, smallint, 附件宽度, - thumb, tinyint, 是否是缩率图, - picid, mediumint, 相册图片ID ,

pre_forum_attachment_8 附件表 - aid, mediumint, 附件id, - tid, mediumint, 主题id, - pid, int, 帖子id, - uid, mediumint, 会员id, - dateline, int, 上传时间, - filename, varchar, 原文件名, - filesize, int, 文件大小, - attachment, varchar, 服务器路径, - remote, tinyint, 是否远程附件, - description, varchar, 说明, - readperm, tinyint, 阅读权限, - price, smallint, 附件价格, - isimage, tinyint, 是否图片, - width, smallint, 附件宽度, - thumb, tinyint, 是否是缩率图, - picid, mediumint, 相册图片ID ,

pre_forum_attachment_9 附件表 - aid, mediumint, 附件id, - tid, mediumint, 主题id, - pid, int, 帖子id, - uid, mediumint, 会员id, - dateline, int, 上传时间, - filename, varchar, 原文件名, - filesize, int, 文件大小, - attachment, varchar, 服务器路径, - remote, tinyint, 是否远程附件, - description, varchar, 说明, - readperm, tinyint, 阅读权限, - price, smallint, 附件价格, - isimage, tinyint, 是否图片, - width, smallint, 附件宽度, - thumb, tinyint, 是否是缩率图, - picid, mediumint, 相册图片ID ,

pre_forum_attachment_exif Exif缓存表 - aid, mediumint, 附件id, - exif, text, exif信息,

pre_forum_attachment_unused 未使用附件表 - aid, mediumint, 附件id, - uid, mediumint, 会员id, - dateline, int, 上传时间, - filename, varchar, 原文件名, - filesize, int, 文件大小, - attachment, varchar, 服务器路径, - remote, tinyint, 是否远程附件, - isimage, tinyint, 是否图片, - width, smallint, 附件宽度, - thumb, tinyint, 是否是缩率图,

pre_forum_attachtype 附件类型表 - id, smallint, 类型id, - fid, mediumint, 论坛id, - extension, char, 扩展名, - maxsize, int, 允许上传最大值,

pre_forum_bbcode Discuz! 代码表 - id, mediumint, 代码id, - available, tinyint, 是否启用n(0:不启用 1:启用但不显示 2:启用并显示), - tag, varchar, 标签, - icon, varchar, 图标, - replacement, text, 替换内容, - example, varchar, 例子, - explanation, text, 解释说明, - params, tinyint, 参数个数, - prompt, text, 标签描述, - nest, tinyint, 嵌套层次, - displayorder, tinyint, 显示顺序, - perm, text, 有权使用的用户组,

pre_forum_collection 淘帖专辑表 - ctid, mediumint, 专辑ID, - uid, mediumint, 用户ID, - username, varchar, 用户名, - name, varchar, 专辑名, - dateline, int, 创建时间, - follownum, mediumint, 订阅数, - threadnum, mediumint, 主题数, - commentnum, mediumint, 评论数, - desc, varchar, 简介, - lastupdate, int, 最后变动时间, - rate, float, 评分, - ratenum, mediumint, 评分次数, - lastpost, mediumint, 最后主题ID, - lastsubject, varchar, 最后主题标题, - lastposttime, int, 最后主题时间, - lastposter, varchar, 最后主题发帖者, - lastvisit, int, 创建者最后访问, - keyword, varchar, 专辑关键词, - cover, tinyint, 是否包含封面, - icon, tinyint, 是否包含图标,

pre_forum_collectioncomment 淘帖评论表 - cid, mediumint, 评论ID, - ctid, mediumint, 专辑ID, - uid, mediumint, 用户ID, - username, varchar, 用户名, - message, text, 评论内容, - dateline, int, 评论时间, - useip, varchar, IP地址, - port, smallint, 端口号, - rate, float, 评分,

pre_forum_collectionfollow 淘帖关注表 - uid, mediumint, 用户ID, - username, char, 用户名, - ctid, mediumint, 专辑ID, - dateline, int, 关注时间, - lastvisit, int, 最后访问专辑时间,

pre_forum_collectioninvite 邀请管理淘专辑 - ctid, mediumint, 专辑ID, - uid, mediumint, 邀请合作者ID, - dateline, int, 邀请时间,

pre_forum_collectionrelated 淘帖主题被收入专辑表 - tid, mediumint, 主题ID, - collection, text, 专辑列表,

pre_forum_collectionteamworker 淘帖合作编辑表 - ctid, mediumint, 专辑ID, - uid, mediumint, 合作者ID, - name, varchar, 专辑名, - username, varchar, 用户名, - lastvisit, int, 最后访问专辑时间,

pre_forum_collectionthread 淘帖包含主题表 - ctid, mediumint, 专辑ID, - tid, mediumint, 专辑内主题ID, - dateline, int, 主题日期, - reason, varchar, 推荐理由,

pre_forum_creditslog 转帐记录表 - uid, mediumint, 会员id, - fromto, char, 来自/到, - sendcredits, tinyint, 转出积分字段, - receivecredits, tinyint, 接受积分字段, - send, int, 转出积分, - receive, int, 接受积分, - dateline, int, 转帐日期, - operation, char, 操作,

pre_forum_debate 辩论主题表 - tid, mediumint, 主题id, - uid, mediumint, 发起人id, - starttime, int, 开始时间, - endtime, int, 结束时间, - affirmdebaters, mediumint, 正方辩论人数, - negadebaters, mediumint, 反方辩论人数, - affirmvotes, mediumint, 正方得票数, - negavotes, mediumint, 反方得票数, - umpire, varchar, 裁判用户名, - winner, tinyint, 获胜方n(0:平局 1:为正方 2:为反方)n裁判评判结果, - bestdebater, varchar, 最佳辩手用户名, - affirmpoint, text, 正方观点, - negapoint, text, 反方观点, - umpirepoint, text, 裁判观点，裁判结束辩论时填写, - affirmvoterids, text, 正方投票人的 id 集合, - negavoterids, text, 反方投票人的 id 集合, - affirmreplies, mediumint, 正方回复次数，用来翻页, - negareplies, mediumint, 反方回复次数，用来翻页,

pre_forum_debatepost 辩论帖子表 - pid, int, 帖子id, - stand, tinyint, 立场n(0:中立 1:正方 2:为反方), - tid, mediumint, 主题id, - uid, mediumint, 发起人id, - dateline, int, 发表的时间, - voters, mediumint, 投票人数, - voterids, text, 投票人的 id 集合,

pre_forum_faq 论坛帮助表 - id, smallint, 帮助id, - fpid, smallint, 帮助父id, - displayorder, tinyint, 排序, - identifier, varchar, 帮助标识, - keyword, varchar, 帮助关键词, - title, varchar, 帮助标题, - message, text, 帮助内容,

pre_forum_forum 版块表 - fid, mediumint, 论坛id, - fup, mediumint, 上级论坛id, - type, enum, 类型n(group:分类 forum:普通论坛 sub:子论坛), - name, char, 名称, - status, tinyint, 显示状态n(0:隐藏 1:正常 3:群组), - displayorder, smallint, 显示顺序, - styleid, smallint, 风格id, - threads, mediumint, 主题数量, - posts, mediumint, 帖子数量, - todayposts, mediumint, 今日发帖数量, - yesterdayposts, mediumint, 昨日发帖数量, - rank, smallint, 排名, - oldrank, smallint, 前天排名, - lastpost, char, 最后发表, - domain, char, 绑定的二级域名, - allowsmilies, tinyint, 允许使用表情, - allowhtml, tinyint, 允许使用html, - allowbbcode, tinyint, 允许bbcode, - allowimgcode, tinyint, 允许img, - allowmediacode, tinyint, 允许使用多媒体代码, - allowanonymous, tinyint, 允许匿名, - allowpostspecial, smallint, 允许发表特殊主题, - allowspecialonly, tinyint, 只允许发表特殊主题, - allowappend, tinyint, 是否开启帖子补充, - alloweditrules, tinyint, 允许版主修改论坛规则, - allowfeed, tinyint, 允许推送动态,默认推送广播, - allowside, tinyint, 显示边栏, - recyclebin, tinyint, 是否启用回收站, - modnewposts, tinyint, 是否审核发帖, - jammer, tinyint, 是否启用干扰码, - disablewatermark, tinyint, 是否图片附件增加水印, - inheritedmod, tinyint, 本论坛或分类版主的权力继承到下级论坛, - autoclose, smallint, 自动关闭主题, - forumcolumns, tinyint, 增加论坛水平横排设置, - catforumcolumns, tinyint, 增加分区版块水平横排设置, - threadcaches, tinyint, 主题缓存功能设置, - alloweditpost, tinyint, 允许编辑帖子, - simple, tinyint, 只显示子版块, - modworks, tinyint, 本版有待处理的管理事项, - allowglobalstick, tinyint, 是否显示全局置顶, - level, smallint, 群组等级, - commoncredits, int, 群组公共积分, - archive, tinyint, 是否有存档表, - recommend, smallint, 推荐到的版块, - favtimes, mediumint, 版块或群组的收藏次数, - sharetimes, mediumint, 版块或群组的分享次数, - disablethumb, tinyint, 是否添加缩略图, - disablecollect, tinyint, 禁止淘帖,

pre_forum_forum_threadtable 版块存档信息 - fid, smallint, 版块id, - threadtableid, smallint, thread分区id, - threads, int, 主题数, - posts, int, 帖子数,

pre_forum_forumfield 版块扩展表 - fid, mediumint, 版块id, - description, text, 解释说明, - password, varchar, 私密论坛密码, - icon, varchar, 图标, - redirect, varchar, URL转发, - attachextensions, varchar, 允许上传附件类型, - creditspolicy, mediumtext, 版块积分策略, - formulaperm, text, 版块权限表达式, - moderators, text, 版主列表，格式:admin, - rules, text, 版块规则, - threadtypes, text, 主题分类，序列化存放的设置，格式为一个数组, - threadsorts, text, 分类信息，序列化存放的设置，格式为一个数组, - viewperm, text, 阅读权限, 格式: 1 4 5, - postperm, text, 发表权限, 格式: 1 4 5, - replyperm, text, 回复权限, 格式: 1 4 5, - getattachperm, text, 下载附件权限, 格式: 1 4 5, - postattachperm, text, 上传附件权限, 格式: 1 4 5, - postimageperm, text, 上传图片权限, 格式: 1 4 5, - spviewperm, text, 不受限于版权权限表达式, 格式: 1 4 5, - seotitle, text, 版块seo标题, - keywords, text, 版块seo关键词, - seodescription, text, 版块seo描述, - supe_pushsetting, text, supe推送设置，序列化存放设置数据，格式为一个数组。, - modrecommend, text, 版主推荐规则, - threadplugin, text, 特殊主题插件数据, - replybg, text, 回复框背景, - extra, TEXT, - jointype, tinyint, 加入群组方式 -1为关闭，0为公开， 2邀请, - gviewperm, tinyint, 群组浏览权限 0:仅成员 1:所有用户, - membernum, smallint, 群组成员数, - dateline, int, 群组创建时间, - lastupdate, int, 群组最后更新时间, - activity, int, 群组活跃度, - founderuid, mediumint, 群组创始人UID, - foundername, varchar, 群组创始人名称, - banner, varchar, 群组头图片, - groupnum, smallint, 分类下的群组数量, - commentitem, TEXT, - relatedgroup, TEXT, - picstyle, tinyint, 帖子列表是否以图片形式显示 0:否 1:是, - widthauto, tinyint, 默认是否宽屏 0:全局 -1:宽屏 1:窄屏, - noantitheft, tinyint, 禁止防采集, - noforumhidewater, tinyint, 禁止隐藏水帖, - noforumrecommend, tinyint, 禁止推荐回复, - livetid, mediumint, 版块直播帖tid, - price, mediumint, 进入版块所需支付的积分,

pre_forum_forumrecommend 版主推荐表 - fid, mediumint, 版块id, - tid, mediumint, 帖子id, - typeid, smallint, 是否含有附件图片, - displayorder, tinyint, 推荐顺序, - subject, char, 推荐主题标题, - author, char, 推荐主题作者, - authorid, mediumint, 推荐主题作者id, - moderatorid, mediumint, 推荐管理人员id, - expiration, int, 推荐主题有效期, - position, tinyint, 显示位置, - highlight, tinyint, 高亮颜色, - aid, mediumint, 附件ID, - filename, char, 附件文件,

pre_forum_groupcreditslog 群组积分日志表 - fid, mediumint, 群组ID, - uid, mediumint, 成员UID, - logdate, int, 日期/20100308,

pre_forum_groupfield 群组扩展信息缓存 - fid, mediumint, 群组关联fid, - privacy, tinyint, 群组隐私设置, - dateline, int, 缓存生成时间, - type, varchar, 缓存类型, - data, text, 缓存数据,

pre_forum_groupinvite 群组邀请 - fid, MEDIUMINT, 群组id, - uid, MEDIUMINT, 邀请人id, - inviteuid, MEDIUMINT, 被邀请人id, - dateline, INT, 邀请时间,

pre_forum_grouplevel 群组等级表 - levelid, smallint, 等级ID, - type, enum, 类型, - leveltitle, varchar, 群组等级名称, - creditshigher, int, 该等级的积分上限, - creditslower, int, 该等级的积分下限, - icon, varchar, 等级图标, - creditspolicy, text, 积分策略, - postpolicy, text, 帖子策略, - specialswitch, text, 特殊开能开关,

pre_forum_groupuser 群组成员 - fid, MEDIUMINT, 群组关联fid, - uid, MEDIUMINT, 成员id, - username, CHAR, 成员名, - level, TINYINT, 成员等级n(0:待审核 1:群主 2:副群主 3:明星成员 4:普通成员), - threads, MEDIUMINT, 成员主题数, - replies, MEDIUMINT, 成员回复数, - joindateline, INT, 成员加入群组时间, - lastupdate, INT, 成员最后活动时间, - privacy, TINYINT, 成员隐私设置,

pre_forum_imagetype 图片 表情 头像等 分类 - typeid, smallint, 分类id, - available, tinyint, 是否启用, - name, char, 分类名称, - type, enum, 分类类型n(smiley:表情 icon:图标 avatar:头像), - displayorder, tinyint, 分类顺序, - directory, char, 图片目录,

pre_forum_medal 勋章表 - medalid, smallint, 勋章id, - name, varchar, 勋章名称, - available, tinyint, 是否启用, - image, varchar, 勋章图片, - type, tinyint, 勋章类型, - displayorder, tinyint, 勋章显示顺序, - description, varchar, 勋章描述, - expiration, smallint, 勋章有效期, - permission, mediumtext, 勋章获得条件表达式, - credit, tinyint, 勋章购买使用积分, - price, mediumint, 勋章价格,

pre_forum_medallog 勋章日志表 - id, mediumint, 记录id, - uid, mediumint, 勋章拥有着用户id, - medalid, smallint, 勋章id, - type, tinyint, 勋章类型id, - dateline, int, 颁发时间id, - expiration, int, 有效期id, - status, tinyint, 勋章状态id,

pre_forum_memberrecommend 用户推荐表 - tid, mediumint, 主题ID, - recommenduid, mediumint, 推荐会员ID, - dateline, int, 推荐时间,

pre_forum_moderator 版主表 - uid, mediumint, 会员id, - fid, mediumint, 论坛id, - displayorder, tinyint, 显示顺序, - inherited, tinyint, 是否继承,

pre_forum_modwork 论坛管理统计表 - uid, mediumint, 会员id, - modaction, char, 动作, - dateline, date, 时间段, - count, smallint, 登录次数, - posts, smallint, 发表数,

pre_forum_onlinelist 在线列表定制 - groupid, smallint, 会员组id, - displayorder, tinyint, 显示顺序, - title, varchar, 组名称, - url, varchar, 图例URL,

pre_forum_order 订单信息表 - orderid, char, 订单号id, - status, char, 状态, - buyer, char, 购买者姓名, - admin, char, 补单管理员姓名, - uid, mediumint, 购买者id, - amount, int, 数量, - price, float, 价格, - submitdate, int, 提交日期, - confirmdate, int, 确认日期, - email, char, 购买时的Email, - ip, char, 购买时的IP,

pre_forum_poll 投票表 - tid, mediumint, 主题id, - overt, tinyint, 是否公开投票参与人, - multiple, tinyint, 是否多选, - visible, tinyint, 是否投票后可见, - maxchoices, tinyint, 最大可选项数, - isimage, tinyint, 是否为图片投票0: 普通投票; 1:图片投票, - expiration, int, 过期时间, - pollpreview, varchar, 选项内容前两项预览, - voters, mediumint, 投票人数,

pre_forum_polloption 投票选项表 - polloptionid, int, 选项id, - tid, mediumint, 主题id, - votes, mediumint, 票数, - displayorder, tinyint, 显示顺序, - polloption, varchar, 选项内容, - voterids, mediumtext, 投票人id,

pre_forum_polloption_image 投票选项图片 - aid, int, 图片附件id, - poid, int, 选项id, - tid, mediumint, 主题id, - pid, int, 帖子id, - uid, mediumint, 会员id, - filename, varchar, 原文件名, - filesize, int, 文件大小, - attachment, varchar, 服务器路径, - remote, tinyint, 是否远程附件, - width, smallint, 附件宽度, - thumb, tinyint, 是否有缩略率图, - dateline, int, 上传时间,

pre_forum_pollvoter 投票用户表 - tid, mediumint, 主题id, - uid, mediumint, 会员id, - username, varchar, 会员名, - options, text, 选项 t 分隔, - dateline, int, 发表时间,

pre_forum_post 帖子表 - pid, int, 帖子id, - fid, mediumint, 论坛id, - tid, mediumint, 主题id, - first, tinyint, 是否是首贴, - author, varchar, 作者姓名, - authorid, mediumint, 作者id, - subject, varchar, 标题, - summary, varchar, 摘要, - original, tinyint, 原创标识, - dateline, int, 发表时间, - message, mediumtext, 消息, - content, json, JSON内容, - source, json, 文章来源, - useip, varchar, 发帖者IP, - port, smallint, 端口号, - invisible, tinyint, 是否通过审核, - anonymous, tinyint, 是否匿名, - usesig, tinyint, 是否启用签名, - htmlon, tinyint, 是否允许HTML, - bbcodeoff, tinyint, 是否关闭BBCODE, - smileyoff, tinyint, 是否关闭表情, - parseurloff, tinyint, 是否允许粘贴URL, - attachment, tinyint, 附件, - rate, smallint, 评分分数, - ratetimes, tinyint, 评分次数, - status, int, 帖子状态, - tags, varchar, 新增字段，用于存放tag, - comment, tinyint, 是否存在点评, - replycredit, int, 回帖获得积分记录, - position, int, 帖子位置信息, - bestanswer, tinyint, 最佳答案,

pre_forum_post_location 帖子地理位置表 - pid, int, - tid, mediumint, - uid, mediumint, - mapx, varchar, - mapy, varchar, - location, varchar,

pre_forum_post_moderate 帖子审核数据表 - id, int, ID, - status, tinyint, 状态 0 审核中，1 已忽略, - dateline, int,

pre_forum_post_tableid post分表协调表 - pid, int, Post ID,

pre_forum_postcache 论坛帖子缓存表 - pid, int, - comment, text, 点评内容缓存, - rate, text, 评分情况缓存, - dateline, int,

pre_forum_postcomment 点评帖子表 - id, int, - tid, mediumint, 主题ID, - pid, int, 帖子ID, - author, varchar, 作者, - authorid, mediumint, 作者ID x1.5以后：0为游客　-1为观点, - dateline, int, 时间, - comment, varchar, 点评内容, - score, tinyint, 是否包含点评观点, - useip, varchar, 发帖者IP, - port, smallint, 端口号, - rpid, int, 关联的帖子ID,

pre_forum_postlog 漫游帖子日志（X3.5已删除） - pid, int, - tid, mediumint, - fid, smallint, - uid, mediumint, - action, char, - dateline, int,

pre_forum_poststick 回帖置顶表 - tid, mediumint, - pid, int, - position, int, - dateline, int,

pre_forum_promotion 论坛推广 - ip, char, IP地址, - uid, mediumint, 会员id, - username, char, 会员名,

pre_forum_ratelog 帖子评分记录表 - pid, int, 帖子id, - uid, mediumint, 会员id, - username, char, 会员名, - extcredits, tinyint, 评分字段, - dateline, int, 评分时间, - score, smallint, 分数, - reason, char, 操作理由,

pre_forum_relatedthread 相关主题表 - tid, mediumint, 主题id, - type, enum, 关键词类型, - expiration, int, 过期时间, - keywords, varchar, 关键字, - relatedthreads, text, 相关主题序列,

pre_forum_replycredit 主题回帖获得积分规则表 - tid, mediumint, 主题tid, - extcredits, mediumint, 单次回复奖励额度, - extcreditstype, tinyint, 本规则下奖励积分的类型, - times, smallint, 回复奖励次数, - membertimes, smallint, 单个用户参与次数, - random, tinyint, 用户设置的回帖奖励几率,

pre_forum_rsscache rss缓存表 - lastupdate, int, 最后更新时间, - fid, mediumint, 论坛id, - tid, mediumint, 主题id, - dateline, int, 发表时间, - forum, char, 论坛名称, - author, char, 作者, - subject, char, 标题, - description, char, 解释说明, - guidetype, char, 导读中的类型,

pre_forum_spacecache minispace缓存表 - uid, mediumint, 用户 uid, - variable, varchar, 缓存变量的名称, - value, text, 缓存变量的值, - expiration, int, 过期时间,

pre_forum_statlog 版块统计日志表 - logdate, date, 日志日期, - fid, mediumint, 版块ID, - type, smallint, 记录类型, - value, int, 记录值,

pre_forum_thread 主题表 - tid, mediumint, 主题id, - fid, mediumint, 上级论坛, - posttableid, smallint, 帖子表ID, - typeid, smallint, 主题分类id, - sortid, smallint, 分类信息id, - readperm, tinyint, 阅读权限, - price, smallint, 价格, - author, char, 会员名, - authorid, mediumint, 会员id, - subject, char, 标题, - summary, varchar, 摘要, - dateline, int, 发表时间, - lastpost, int, 最后发表, - lastposter, char, 最后发表人id, - original, tinyint, 原创标识, - views, int, 浏览次数, - replies, mediumint, 回复次数, - displayorder, tinyint, 显示顺序, - highlight, tinyint, 是否高亮, - digest, tinyint, 是否精华, - rate, tinyint, 是否评分, - special, tinyint, 特殊主题,1:投票;2:商品;3:悬赏;4:活动;5:辩论贴;127:插件相关, - attachment, tinyint, 附件,0无附件 1普通附件 2有图片附件, - moderated, tinyint, 是否被管理员改动, - closed, mediumint, 是否关闭, - stickreply, tinyint, 是否有回帖置顶, - recommends, smallint, 推荐指数, - recommend_add, smallint, 支持人数, - recommend_sub, smallint, 反对人数, - heats, int, 主题热度值, - status, smallint, - isgroup, tinyint, 是否为群组帖子, - favtimes, mediumint, 主题收藏次数, - sharetimes, mediumint, 主题分享次数, - stamp, tinyint, 主题图章, - icon, tinyint, 主题图标, - pushedaid, mediumint, 被推送到的文章aid, - cover, smallint, 主题封面 负数:远程　正数:本地 0:无封面, - replycredit, smallint, 回帖奖励积分主题记录积分值, - relatebytag, char, 根据帖子标签取的相关主题id (time /t tid,...), - maxposition, int, 最大回帖位置信息, - bgcolor, char, 保存高亮背景色, - comments, int, 点评数, - hidden, smallint, 是否隐藏,

pre_forum_thread_moderate 主题审核数据表 - id, int, ID, - status, tinyint, 状态 0 审核中，1 已忽略, - dateline, int,

pre_forum_threadaddviews 主题查看数延时更新表 - tid, mediumint, 主题id, - addviews, int, 浏览次数,

pre_forum_threadcalendar 热帖日历表 - cid, mediumint, 帖子日历ID, - fid, mediumint, 版块ID, - dateline, int, 日期, - hotnum, int, 热帖总数,

pre_forum_threadclass 主题分类表 - typeid, mediumint, 分类ID, - fid, mediumint, 所属版块ID, - name, varchar, 分类名称, - displayorder, mediumint, 显示顺序, - icon, varchar, 分类图标URL, - moderators, tinyint, 仅管理者可用,

pre_forum_threadclosed 主题转移后保留的指向记录 - tid, mediumint, 对应源主题, - redirect, mediumint, 保留的指向 tid,

pre_forum_threaddisablepos 主题有楼层不准确时不使用position查询 - tid, mediumint, 主题id,

pre_forum_threadhidelog 主题隐藏记录 - tid, mediumint, 主题ID, - uid, mediumint, 用户ID,

pre_forum_threadhot 热帖日历数据表 - cid, mediumint, 帖子日历ID, - fid, mediumint, 版块ID, - tid, mediumint, 主题ID,

pre_forum_threadimage 主题图片表 - tid, mediumint, - attachment, varchar, 服务器路径, - remote, tinyint, 是否远程附件,

pre_forum_threadlog 漫游主题日志 - tid, mediumint, - fid, smallint, - uid, mediumint, - otherid, smallint, - action, char, - expiry, int, - dateline, int,

pre_forum_threadmod 主题管理记录表 - tid, mediumint, 主题id, - uid, mediumint, 会员id, - username, char, 会员名, - dateline, int, 操作时间, - expiration, int, 有效时间, - action, char, 操作, - status, tinyint, 状态, - magicid, smallint, 使用道具id, - stamp, TINYINT, 主题图章/图标 ID, - reason, char, 操作原因,

pre_forum_threadpartake 主题参与者记录表 - tid, mediumint, 主题id, - uid, mediumint, 会员id, - dateline, int, 参与时间,

pre_forum_threadpreview 服务于广播 - tid, mediumint, 主题ID, - relay, int, 转播次数, - content, text, 主题内容预览,

pre_forum_threadrush 抢楼设置表 - tid, mediumint, 主题id, - stopfloor, mediumint, 截止楼层, - starttimefrom, int, 开始时间, - starttimeto, int, 结束时间, - rewardfloor, text, 奖励楼层, - creditlimit, int, 积分下限, - replylimit, smallint, 回帖次数上限,

pre_forum_threadtype 分类信息表 - typeid, smallint, 分类信息id, - fid, mediumint, - displayorder, smallint, 显示顺序, - name, varchar, 名称, - description, varchar, 解释说明, - icon, varchar, 分类图标URL, - special, smallint, 分类状态, - modelid, smallint, 分类模型id, - expiration, tinyint, 分类有效期, - template, text, 分类信息内容模板, - stemplate, text, 分类信息主题模板, - ptemplate, text, 分类信息发帖模板, - btemplate, text, 分类信息模块调用模板, - super, text, 超级分类信息数据,

pre_forum_trade 商品数据表 - tid, mediumint, 主题id, - pid, int, 帖子id, - typeid, smallint, 主题分类id, - sellerid, mediumint, 卖家id, - seller, char, 卖家名, - account, char, 卖家帐号, - tenpayaccount, char, 卖家财付通账号, - subject, char, 标题, - price, decimal, 价格, - amount, smallint, 数量, - quality, tinyint, 成色, - locus, char, 所在地, - transport, tinyint, 物流方式, - ordinaryfee, smallint, 平邮附加费, - expressfee, smallint, 快递附加费, - emsfee, smallint, EMS附加费, - itemtype, tinyint, 商品类型, - dateline, int, 交易时间, - expiration, int, 过期时间, - lastbuyer, char, 最后买家用户名, - lastupdate, int, 最后交易时间, - totalitems, smallint, 总交易量, - tradesum, decimal, 总交易额, - closed, tinyint, 是否关闭, - aid, mediumint, 商品图片的 Aid, - displayorder, tinyint, 显示顺序, - costprice, decimal, 商品原价, - credit, int, 积分价格, - costcredit, int, 积分原价, - credittradesum, int, 总积分交易额,

pre_forum_tradecomment 信用评价 - id, mediumint, id, - orderid, char, 订单 id, - pid, int, 帖子 id, - type, tinyint, 类型, - raterid, mediumint, 评价方会员id, - rater, char, 评价方用户名, - rateeid, mediumint, 被评价方会员id, - ratee, char, 被评价方用户名, - message, char, 评价内容, - explanation, char, 解释, - score, tinyint, 评分, - dateline, int, 评价时间,

整理自 Discuz! 官方开放平台技术文档（open.dismall.com），由 WorkBuddy 整理发布。