最进做采集插件接口用到的数据表，现整理下发布
贴子相关数据表
pw_bbs_threads 帖子基本信息表
字段名 数据类型 默认值 允许非空 自动递增 备注
tid int(10) unsigned NO 是
fid smallint(5) unsigned 0 NO
topic_type int(10) unsigned 0 NO
subject varchar(100) NO
overtime int(10) unsigned 0 NO
highlight varchar(64) NO
inspect varchar(30) NO
ifshield tinyint(1) unsigned 0 NO
digest tinyint(3) unsigned 0 NO
topped tinyint(3) unsigned 0 NO
disabled tinyint(1) unsigned 0 NO
ischeck tinyint(3) 1 NO
replies int(10) unsigned 0 NO
hits int(10) unsigned 0 NO
like_count mediumint(8) unsigned 0 NO
special varchar(20) 0 NO
tpcstatus int(10) unsigned 0 NO
ifupload tinyint(3) unsigned 0 NO
created_time int(10) unsigned 0 NO
created_username varchar(15) NO
created_userid int(10) unsigned 0 NO
created_ip varchar(40) NO
modified_time int(10) unsigned 0 NO
modified_username varchar(15) NO
modified_userid int(10) unsigned 0 NO
modified_ip varchar(40) NO
lastpost_time int(10) unsigned 0 NO
lastpost_userid int(10) unsigned 0 NO
lastpost_username varchar(15) NO
special_sort tinyint(4) 0 NO
reply_notice tinyint(3) unsigned 1 NO
reply_topped mediumint(8) unsigned 0 NO
thread_status int(10) unsigned 0 NO
pw_bbs_threads_buy 帖子购买记录贴表
字段名 数据类型 默认值 允许非空 自动递增 备注
tid int(10) unsigned 0 NO
pid int(10) unsigned 0 NO
created_userid int(10) unsigned 0 NO
created_time int(10) unsigned 0 NO
ctype tinyint(3) unsigned 0 NO
cost mediumint(8) unsigned 0 NO
pw_bbs_threads_cate_index 帖子索引表-分类索引
字段名 数据类型 默认值 允许非空 自动递增 备注
tid int(10) unsigned 0 NO
cid smallint(5) unsigned 0 NO
fid smallint(5) unsigned 0 NO
disabled tinyint(3) unsigned 0 NO
created_time int(10) unsigned 0 NO
lastpost_time int(10) unsigned 0 NO
pw_bbs_threads_content 帖子内容表
字段名 数据类型 默认值 允许非空 自动递增 备注
tid int(10) unsigned 0 NO
useubb tinyint(1) unsigned 0 NO
usehtml tinyint(1) unsigned 0 NO
aids smallint(5) unsigned 0 NO
content text YES
sell_count mediumint(8) unsigned 0 NO
reminds varchar(255) NO
word_version smallint(5) unsigned 0 NO
tags varchar(255) NO
ipfrom varchar(255) NO
manage_remind varchar(150) NO
pw_bbs_threads_digest_index 精华帖子索引表
字段名 数据类型 默认值 允许非空 自动递增 备注
tid int(10) unsigned 0 NO
fid smallint(5) unsigned 0 NO
disabled tinyint(3) unsigned 0 NO
cid smallint(5) unsigned 0 NO
topic_type int(10) unsigned 0 NO
created_time int(10) unsigned 0 NO
lastpost_time int(10) unsigned 0 NO
operator varchar(15) NO
operator_userid int(10) unsigned 0 NO
operator_time int(10) unsigned 0 NO
pw_bbs_threads_hits
字段名 数据类型 默认值 允许非空 自动递增 备注
tid int(10) unsigned 0 NO
hits int(10) unsigned 0 NO
pw_bbs_threads_index 帖子索引表-新帖索引
字段名 数据类型 默认值 允许非空 自动递增 备注
tid int(10) unsigned 0 NO
fid smallint(5) unsigned 0 NO
disabled tinyint(3) unsigned 0 NO
created_time int(10) unsigned 0 NO
lastpost_time int(10) unsigned 0 NO
pw_bbs_threads_overtime
字段名 数据类型 默认值 允许非空 自动递增 备注
id int(10) unsigned NO 是
tid int(10) unsigned 0 NO
m_type enum(‘topped’,’highlight’) NO
overtime int(10) unsigned 0 NO
pw_bbs_threads_sort 帖子排序表
字段名 数据类型 默认值 允许非空 自动递增 备注
fid smallint(5) unsigned 0 NO 版块ID
tid int(10) unsigned 0 NO 帖子ID
extra int(10) 0 NO 扩展字段,如置顶1、2、3
sort_type varchar(20) NO 排序类型
created_time int(10) unsigned 0 NO 创建时间
end_time int(10) unsigned 0 NO 到期时间 |
收藏