phome_ecms_infotmp_news数据表字段解释
帝国cms新闻系统模型－采集临时表
| 字段名 | 类型 | 解释 | 附加说明 | 兼容版本 |
|---|---|---|---|---|
| id | bigint(20)unsigned | 信息ID | 6670727580 | |
| classid | int(10)unsigned | 采集节点ID | 6670727580 | |
| oldurl | varchar(200) | 采集页面地址 | 6670727580 | |
| checked | tinyint(1) | 是否已入库 | 0为未入库，1为已入库 | 6670727580 |
| tmptime | datetime | 采集时间 | 6670727580 | |
| userid | mediumint(8)unsigned | 采集者用户ID | 6670727580 | |
| username | varchar(20) | 采集者用户名 | 6670727580 | |
| truetime | int(10)unsigned | 真实发布时间 | 6670727580 | |
| keyboard | varchar(100) | 关键字 | 6670727580 | |
| title | varchar(100) | 标题字段 | 6670727580 | |
| newstime | datetime | 发布时间字段 | 6670727580 | |
| titlepic | varchar(120) | 标题图片字段 | 6670727580 | |
| ftitle | varchar(120) | 副标题字段 | 6670727580 | |
| smalltext | varchar(255) | 简介字段 | 6670727580 | |
| writer | varchar(30) | 作者字段 | 6670727580 | |
| befrom | varchar(60) | 信息来源字段 | 6670727580 | |
| newstext | mediumtext | 内容字段 | 6670727580 | |
| diggtop | int(11) | DIGG字段 | 6670727580 |
信息表：每个模型都有以下10个表
- phome_ecms_news_index
- phome_ecms_news
- phome_ecms_news_data_1
- phome_ecms_news_check
- phome_ecms_news_check_data
- phome_ecms_news_doc_index
- phome_ecms_news_doc
- phome_ecms_news_doc_data
- phome_ecms_infoclass_news
- phome_ecms_infotmp_news
信息相关表：
- phome_enewswriter
- phome_enewsdownrecord
- phome_enewspl_set
- phome_enewsbefrom
- phome_enewsdownurlqz
- phome_enewsplf
- phome_enewskey
- phome_enewsplayer
- phome_enewspostdata
- phome_enewsfile_1
- phome_enewskeyclass
- phome_enewspostserver
- phome_enewspublic_update
- phome_enewsfile_member
- phome_enewswords
- phome_enewssearch
- phome_enewsfile_public
- phome_enewsdiggips
- phome_enewsfile_other
- phome_enewssearchall
- phome_enewsdo
- phome_enewsinfovote
- phome_enewssearchall_load
- phome_enewstask
- phome_enewsvotemod
- phome_enewsdownerror
- phome_enewsshop_address
- phome_enewspl_1
- phome_enewserrorclass
- phome_enewsshop_ddlog
- phome_enewsshop_precode
- phome_enewssp_1
- phome_enewsshop_set
- phome_enewssp_2
- phome_enewsshopdd
- phome_enewssp_3
- phome_enewsshopdd_add
- phome_enewssp_3_bak
- phome_enewsshoppayfs
- phome_enewsspclass
- phome_enewsshopps
- phome_enewswfinfo
- phome_enewstags
- phome_enewswfinfolog
- phome_enewsworkflow
- phome_enewstagsclass
- phome_enewsworkflowitem
- phome_enewstagsdata
- phome_enewssp
- phome_enewsfile
- phome_enewspl
- phome_enewspl_data_1
- phome_enewsgoodtype
- phome_enewsfileclass
- phome_enewsfileclasst
- phome_enewsfz_class
- phome_enewsfz_data_1
- phome_enewsfz_data_check
- phome_enewsfz_info
- phome_enewsfz_infoclass
- phome_enewsfz_set
- phome_enewstagsdata_check
- phome_enewsuser_save
栏目及相关表：
- phome_enewsclass
- phome_enewsztclass
- phome_enewsclassadd
- phome_enewsztf
- phome_enewsclassf
- phome_enewsztinfo
- phome_enewsclass_stats
- phome_enewszttype
- phome_enewszttypeadd
- phome_enewsclass_stats_ip
- phome_enewsclass_stats_set
- phome_enewstogzts
- phome_enewsclassnavcache
- phome_enewsinfotype
- phome_enewszt
- phome_enewsztadd
模板表：每个模板组都有以下加粗表
- phome_enewsbqtemp
- phome_enewspagetemp
- phome_enewsbqtempclass
- phome_enewspltemp
- phome_enewsclasstemp
- phome_enewsprinttemp
- phome_enewsclasstempclass
- phome_enewspubtemp
- phome_enewsjstemp
- phome_enewssearchtemp
- phome_enewsjstempclass
- phome_enewssearchtempclass
- phome_enewslisttemp
- phome_enewstempvar
- phome_enewslisttempclass
- phome_enewstempvarclass
- phome_enewsnewstemp
- phome_enewsvotetemp
- phome_enewsnewstempclass
模板相关表：
- phome_enewsadminstyle
- phome_enewsuserjs
- phome_enewsbq
- phome_enewsuserjsclass
- phome_enewsbqclass
- phome_enewsuserlist
- phome_enewsuserlistclass
- phome_enewsindexpage
- phome_enewswapstyle
- phome_enewspage
- phome_enewspageclass
- phome_enewsspacestyle
- phome_enewstempbak
- phome_enewstempdt
- phome_enewstempgroup
采集相关表：
会员相关表：
- phome_enewsbuybak
- phome_enewsmember_connect
- phome_enewsnotice
- phome_enewsbuygroup
- phome_enewsmember_connect_app
- phome_enewsmembergroup
- phome_enewscard
- phome_enewsmemberf
- phome_enewsfava
- phome_enewsmemberform
- phome_enewsfavaclass
- phome_enewsmemberfeedback
- phome_enewshy
- phome_enewsmembergbook
- phome_enewshyclass
- phome_enewshmsg
- phome_enewsmember
- phome_enewsqmsg
- phome_enewsmemberadd
- phome_enewshnotice
- phome_enewsmemberpub
- phome_enewsag
- phome_enewsingroup
- phome_enewsvg
- phome_enewsvglist
- phome_enewsmemberphno
- phome_enewsmembertitle
- phome_enewspayrecordst
后台用户相关表：
- phome_enewslog
- phome_enewsdolog
- phome_enewsloginfail
- phome_enewsgroup
- phome_enewsuser
- phome_enewsuseradd
- phome_enewsuserclass
- phome_enewsuserloginck
- phome_enewsloginfail_u
- phome_enewsuseronepass
系统模型相关表：
- phome_enewsf
- phome_enewsmod
- phome_enewstable
- phome_enewssql
- phome_enewsyh
- phome_enewspublic_fc
- phome_enewspublic_up
- phome_enewspublicadd
- phome_enewsmodlist
模块相关表：
- phome_enewsad
- phome_enewsgfenip
- phome_enewsadclass
- phome_enewsnotcj
- phome_enewsfeedback
- phome_enewsfeedbackclass
- phome_enewsfeedbackf
- phome_enewsgbook
- phome_enewsgbookclass
- phome_enewslink
- phome_enewslinkclass
- phome_enewsvote
- phome_enewsautodo
- phome_enewsdtuserpage
- phome_enewsdtuserpageclass
- phome_enewsformhash
- phome_enewsphmsg
- phome_enewssearchurl
其它表：
-
3802.9千+ 23 300 -
3792.9千+ 28 300 -
3763.1千+ 21 500 -
3734.3千+ 21 300 -
3723.4千+ 15 300 -
3237.4千+ 15 500 -
3226.6千+ 31 200 -
3205.8千+ 32 200
Copyright@2008-2025 版权所有 帝国CMS模板