phome_enewsclass数据表字段解释
帝国cms栏目主表
| 字段名 | 类型 | 解释 | 附加说明 | 兼容版本 |
|---|---|---|---|---|
| classid | smallint(5)unsigned | 栏目ID | 6670727580 | |
| bclassid | smallint(5)unsigned | 父栏目ID | 6670727580 | |
| classname | varchar(50) | 栏目名称 | 6670727580 | |
| sonclass | text | 终极栏目ID集合 | 父栏目下所有终极栏目ID集合，多个栏目ID用“|”隔开，例如：|1|5|8| | 6670727580 |
| is_zt | tinyint(1) | 预定义字段，暂时用不到，默认值0 | 6670727580 | |
| lencord | smallint(6) | 每页显示信息数 | 6670727580 | |
| link_num | tinyint(4) | 相关链接数 | 6670727580 | |
| newstempid | smallint(6) | 内容模板ID | 6670727580 | |
| onclick | int(11) | 点击数 | 6670727580 | |
| listtempid | smallint(6) | 列表模板ID | 6670727580 | |
| featherclass | text | 父栏目ID集合 | 所有上级父栏目ID集合，按层次存放，多个栏目ID用“|”隔开，例如：|1|2|3| | 6670727580 |
| islast | tinyint(1) | 是否终极栏目 | 1为终极栏目，0为非终极栏目 | 6670727580 |
| classpath | text | 栏目存放目录 | 6670727580 | |
| classtype | varchar(10) | 栏目文件扩展名 | 6670727580 | |
| newspath | varchar(20) | 内容页日期目录形式 | 6670727580 | |
| filename | tinyint(1) | 内容页文件命名形式 | 6670727580 | |
| filetype | varchar(10) | 内容页文件扩展名 | 6670727580 | |
| openpl | tinyint(1) | 是否开启评论 | 0为开启，1为关闭 | 6670727580 |
| openadd | tinyint(1) | 是否开放投稿 | 0为开启，1为关闭 | 6670727580 |
| newline | int(11) | 最新信息JS显示数 | 6670727580 | |
| hotline | int(11) | 热门信息JS显示数 | 6670727580 | |
| goodline | int(11) | 推荐信息JS显示数 | 6670727580 | |
| classurl | varchar(200) | 栏目绑定域名 | 6670727580 | |
| groupid | smallint(6) | 默认内容页查看权限 | 6670727580 | |
| myorder | smallint(6) | 排序 | 6670727580 | |
| filename_qz | varchar(20) | 内容文件名前缀 | 6670727580 | |
| hotplline | tinyint(4) | 热门评论信息JS显示数 | 6670727580 | |
| modid | smallint(6) | 所属系统模型ID | 6670727580 | |
| checked | tinyint(1) | 信息默认是否审核 | 1为直接审核，0为未审核 | 6670727580 |
| firstline | tinyint(4) | 头条信息JS显示数 | 6670727580 | |
| bname | varchar(50) | 栏目别名 | 6670727580 | |
| islist | tinyint(1) | 页面显示模式 | 0为封面式，1为列表式，2为页面内容式 | 6670727580 |
| searchtempid | smallint(6) | 搜索模板ID | 6670727580 | |
| tid | smallint(6) | 数据表ID | 6670727580 | |
| tbname | varchar(60) | 数据表名 | 6670727580 | |
| maxnum | int(11) | 显示总记录数 | 6670727580 | |
| checkpl | tinyint(1) | 评论是否需要审核 | 1为要审核，0为直接通过 | 6670727580 |
| down_num | tinyint(4) | 每行下载地址数 | 6670727580 | |
| online_num | tinyint(4) | 每行在线观看地址数 | 6670727580 | |
| listorder | varchar(50) | 管理信息排序方式 | 默认：idDESC | 6670727580 |
| reorder | varchar(50) | 列表式页面排序方式 | 默认：newstimeDESC | 6670727580 |
| intro | text | 栏目简介 | 6670727580 | |
| classimg | varchar(255) | 栏目缩略图 | 6670727580 | |
| jstempid | smallint(6) | JS模板ID | 6670727580 | |
| addinfofen | int(11) | 前台投稿加点数 | 6670727580 | |
| listdt | tinyint(1) | 列表模式 | 0为静态列表，1为动态列表 | 6670727580 |
| showclass | tinyint(1) | 是否显示到导航 | 0为显示，1为不显示 | 6670727580 |
| showdt | tinyint(1) | 内容页模式 | 0为静态页面，1为动态生成，2为动态页面 | 6670727580 |
| checkqadd | tinyint(1) | 前台投稿是否要审核 | 0为要审核，1为直接通过 | 6670727580 |
| qaddlist | tinyint(1) | 投稿生成列表 | 0为不生成，1为生成当前栏目，2为生成首页，3为生成父栏目，4为生成当前栏目与父栏目，5为生成父栏目与首页，6为生成当前栏目、父栏目与首页 | 6670727580 |
| qaddgroupid | text | 投稿权限 | 多个会员组ID用“,”半角逗号隔开，例如：,1,2,3, | 6670727580 |
| qaddshowkey | tinyint(1) | 投稿是否开启验证码 | 1为开启，0为关闭 | 6670727580 |
| adminqinfo | tinyint(1) | 管理投稿 | 0为不能管理信息，1为可管理未审核信息，2为只可编辑未审核信息，3为只可删除未审核信息，4为可管理所有信息，5为只可编辑所有信息，6为只可删除所有信息 | 6670727580 |
| doctime | smallint(6) | 信息归档时间 | 6670727580 | |
| classpagekey | varchar(255) | 页面关键字 | 6670727580 | |
| dtlisttempid | smallint(6) | 动态列表模板ID | 6670727580 | |
| classtempid | smallint(6) | 封面模板ID | 6670727580 | |
| nreclass | tinyint(1) | 是否生成栏目页 | 0为生成，1为不生成 | 6670727580 |
| nreinfo | tinyint(1) | 是否生成内容页 | 0为生成，1为不生成 | 6670727580 |
| nrejs | tinyint(1) | 是否生成JS调用 | 0为生成，1为不生成 | 6670727580 |
| nottobq | tinyint(1) | 标签是否调用 | 0为调用，1为不调用 | 6670727580 |
| ipath | varchar(255) | 自定义内容页存放目录 | 6670727580 | |
| addreinfo | tinyint(1) | 发布信息生成内容页 | 1为生成，0为不生成(后台) | 6670727580 |
| haddlist | tinyint(4) | 发布生成列表 | 0为不生成，1为生成当前栏目，2为生成首页，3为生成父栏目，4为生成当前栏目与父栏目，5为生成父栏目与首页，6为生成当前栏目、父栏目与首页(后台) | 6670727580 |
| sametitle | tinyint(1) | 是否检测标题重复 | 0为不检测，1为检测 | 6670727580 |
| definfovoteid | smallint(6) | 信息预设投票ID | 6670727580 | |
| wburl | varchar(255) | 外部栏目链接地址 | 6670727580 | |
| qeditchecked | tinyint(1) | 修改投稿是否需要审核 | 1为需要重新审核，0为不需要 | 6670727580 |
| wapstyleid | smallint(6) | WAP模板ID | 6670727580 | |
| repreinfo | tinyint(1) | 是否生成上一篇信息 | 1为生成，0为不生成 | 6670727580 |
| pltempid | smallint(6) | 评论模板ID | 6670727580 | |
| cgroupid | text | 栏目页访问权限 | 多个会员组ID用“,”半角逗号隔开，例如：,1,2,3, | 6670727580 |
| yhid | smallint(6) | 使用优化方案ID | 6670727580 | |
| wfid | smallint(6) | 使用工作流ID | 6670727580 | |
| cgtoinfo | tinyint(1) | 栏目访问权限应用于信息 | 1为是，0为否 | 6670727580 |
| bdinfoid | varchar(25) | 栏目绑定信息ID | 格式：栏目ID,信息ID | 6670727580 |
| repagenum | smallint(5)unsigned | 生成列表静态页面数 | 70727580 | |
| keycid | smallint(6) | 替换内容关键字分类ID | 70727580 | |
| allinfos | int(10)unsigned | 栏目信息总数 | 70727580 | |
| infos | int(10)unsigned | 审核通过的信息总数 | 70727580 | |
| addtime | int(10)unsigned | 增加栏目时间 | unix时间戳 | 70727580 |
| oneinfo | tinyint(1) | 会员最大发布信息数 | 7580 | |
| addsql | varchar(255) | 列表式显示附加SQL条件 | 7580 | |
| wapislist | tinyint(1) | WAP页面模式 | 7580 | |
| fclast | int(10)unsigned | 栏目最后编辑时间 | 7580 | |
| ecmsvpf | varchar(100) | 栏目访问密码 | 80 |
信息表：每个模型都有以下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
其它表：
-
3.2千+ 23 300 -
3.1千+ 28 300 -
3.1千+ 21 500 -
4.4千+ 21 300 -
3.5千+ 15 300 -
7.6千+ 15 500 -
6.6千+ 31 200 -
5.9千+ 32 200
