phome_enewsf数据表字段解释
帝国cms模型字段表
字段名 | 类型 | 解释 | 附加说明 |
---|---|---|---|
fid | smallint(5) | 字段ID | |
f | varchar(30) | 字段名 | |
fname | varchar(30) | 字段标识 | |
fform | varchar(20) | 输入表单显示元素 | |
fhtml | mediumtext | 输入表单替换html代码 | |
fzs | varchar(255) | 注释 | |
isadd | tinyint(1) | 是否系统字段 | 0为系统字段,1为自己增加的字段 |
isshow | tinyint(1) | 是否显示字段 | 值0 |
iscj | tinyint(1) | 是否为采集项 | 1为采集项,0为不是采集项 |
cjhtml | mediumtext | 采集表单替换html代码 | |
myorder | smallint(6) | 显示顺序 | |
ftype | varchar(30) | 字段类型 | |
flen | varchar(20) | 字段长度 | |
dotemp | tinyint(1) | 是否为模板项 | 值0 |
tid | smallint(6) | 数据表ID | |
tbname | varchar(60) | 数据表名 | |
savetxt | tinyint(1) | 是否内容存文本 | 1为存文本,0为普通字段 |
fvalue | text | 字段初始值 | 多个值之间用“|”分隔,如:福建|北京 |
iskey | tinyint(1) | 是否为索引字段 | 1为加索引,0为不加索引 |
tobr | tinyint(1) | 内容回车替换成换行符 | 1为替换,0为不替换 |
dohtml | tinyint(1) | 内容支持html代码 | 1为支持,0为不支持 |
qfhtml | mediumtext | 投稿表单替换html代码 | |
isonly | tinyint(1) | 字段值是否唯一 | 1为唯一,0为不限 |
linkfieldval | varchar(30) | 关联显示值字段名 | |
samedata | tinyint(1) | 关联是否数据同步 | 1为同步数据,0为不同步数据 |
fformsize | varchar(12) | 表单元素长度 | |
tbdataf | tinyint(1) | 是否为副表字段 | 0为主表,1为副表 |
ispage | tinyint(1) | 是否分页字段 | 1为分页字段,0为普通字段 |
adddofun | varchar(255) | 后台增加信息处理函数 | 格式“函数名##参数”参数可不设置 |
editdofun | varchar(255) | 后台修改信息处理函数 | 格式“函数名##参数”参数可不设置 |
qadddofun | varchar(255) | 前台增加信息处理函数 | 格式“函数名##参数”参数可不设置 |
qeditdofun | varchar(255) | 前台修改信息处理函数 | 格式“函数名##参数”参数可不设置 |
linkfieldtb | varchar(60) | 关联数据表名 | |
linkfieldshow | varchar(30) | 关联显示字段 | |
editorys | tinyint(1) | 编辑器样式 | 0为标准型,1为简洁型 |
issmalltext | tinyint(1) | 是否简介字段 | 1为简介字段,0为普通字段 |
fmvnum | varchar(30) | 多值字段数量属性 |
信息表:每个模型都有以下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_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_enewslog
- phome_enewsdolog
- phome_enewsloginfail
- phome_enewsgroup
- phome_enewsuser
- phome_enewsuseradd
- phome_enewsuserclass
- phome_enewsuserloginck
系统模型相关表:
模块相关表:
- phome_enewsad
- phome_enewsgfenip
- phome_enewsadclass
- phome_enewsnotcj
- phome_enewsfeedback
- phome_enewsfeedbackclass
- phome_enewsfeedbackf
- phome_enewsgbook
- phome_enewsgbookclass
- phome_enewslink
- phome_enewslinkclass
- phome_enewsvote
其它表:
-
1.2千+ 1千+ 300
-
1.4千+ 16 300
-
1.5千+ 24 300
-
1.2千+ 3 200
-
1.4千+ 8 300
-
1.4千+ 12 500
-
1.3千+ 28 200
-
2.9千+ 22 200