cmseasy_activity
id:會(huì)話編號(hào);
timestamp:會(huì)話時(shí)間;
operatorid:客服編號(hào);
departmentid:部門(mén)編號(hào);
status:狀態(tài);
cmseasy_annnouncement
id:編號(hào);
title:標(biāo)題;
content:內(nèi)容;
adddate:發(fā)布時(shí)間;
state:狀態(tài);
cmseasy_archive
aid:文章編號(hào)
catid:欄目編號(hào)
typeid:分類(lèi)編號(hào)
title:標(biāo)題
tag:標(biāo)簽
username:用戶名
userid:用戶編號(hào)
view:查看
color:顏色
font:字體
spid:專(zhuān)題ID
ip:IP地址
mtitle:副標(biāo)題
keyword:搜索引擎關(guān)鍵字
description:搜索引擎說(shuō)明
listorder:排序
adddate:發(fā)布時(shí)間
author:作者
image:調(diào)用圖
thumb:縮略圖
state:狀態(tài)
checked:是否審核
introduce:簡(jiǎn)介
introduce_len:簡(jiǎn)介長(zhǎng)度
content:內(nèi)容
template:模版
htmlrule:URL規(guī)則
ishtml:動(dòng)靜態(tài)設(shè)置
linkto:跳轉(zhuǎn)連接
attr1:推薦位
attr2:價(jià)格
attr3:來(lái)源
comment_num:評(píng)論數(shù)
attachment_id:附件ID
attachment_path:附件路徑
grade:等級(jí)
pics:圖片
type:類(lèi)型
province_id:省編號(hào)
city_id:市編號(hào)
section_id:區(qū)編號(hào)
cmseasy_assigns
id:編號(hào);
departmentid:部門(mén);
operatorid:客服;
poll:輪詢;
cmseasy_a_attachment
id:編號(hào);
aid:文章編號(hào);
path:路徑;
thumb:縮略圖;
intro:簡(jiǎn)介;
adddate:上傳時(shí)間;
cmseasy_a_comment
id:評(píng)論編號(hào);
aid:文章編號(hào);
content:內(nèi)容;
userid:用戶編號(hào);
username:用戶名;
adddate:發(fā)布時(shí)間;
ip:IP地址;
state:狀態(tài);
cmseasy_a_rank
id:
aid:
catid:
typeid:
ranks:
cmseasy_a_vote
id:
aid:
titles:
votes:
users:
cmseasy_ballot
id:
title:
type:
num:
order:
cmseasy_b_arctag
id:
aid:
tagid:
cmseasy_b_area
id:編號(hào)
name:地區(qū)名稱
parentid:所說(shuō)上級(jí)欄目ID,如為一級(jí)欄目此處為0;
cmseasy_b_category
catid:欄目ID;
parentid: 所說(shuō)上級(jí)欄目ID,如為一級(jí)欄目此處為0;
catname:欄目名稱;
scategory:
listorder:
image:欄目圖片;
meta_title:欄目網(wǎng)頁(yè)標(biāo)題;
keyword:欄目網(wǎng)頁(yè)關(guān)鍵詞;
description:欄目網(wǎng)頁(yè)描述;
categorycontent:欄目單頁(yè)面內(nèi)容;
htmldir:欄目目錄名稱;
template:欄目應(yīng)用模板的名稱;
listtemplate:下屬欄目列表頁(yè)模板的名稱;
showtemplate:下屬內(nèi)容頁(yè)模板的名稱;
htmlrule: 當(dāng)前欄目URL設(shè)置;
listhtmlrule:下屬欄目列表URL設(shè)置;
showhtmlrule:下屬內(nèi)容頁(yè)URL設(shè)置;
module:所屬模型;
isshow:是否啟用;
ishtml:動(dòng)靜態(tài)設(shè)置;
ispages:是否分頁(yè)顯示;
includecatarchives:子欄目?jī)?nèi)容設(shè)置;
addarcenable:
linkto:外部鏈接;
attr1:
attr2:
attr3:欄目分頁(yè)值;
thumb:是否啟用獨(dú)立縮略圖寬高度設(shè)置;
thumb_width:欄目列表縮略圖寬度;
thumb_height:欄目列表縮略圖高度;
isnav:是否在導(dǎo)航顯示;
cmseasy_b_special
spid:專(zhuān)題編號(hào);
title:專(zhuān)題名稱;
banner:專(zhuān)題橫幅圖片;
description:專(zhuān)題內(nèi)容描述;
template:專(zhuān)題模板;
adddate:專(zhuān)題添加時(shí)間;
listorder:
disabled:
order:
cmseasy_b_tag
tagid:tag編號(hào);
tagname:tab名稱;
cmseasy_chat
id:來(lái)訪者編號(hào)
sessionid:接受客服編號(hào);
name:來(lái)訪者用戶名;
email:來(lái)訪者郵箱;
phone:來(lái)訪者電話;
message:
timestamp:
ip:來(lái)訪者IP;
departmentid:
operatorid:
status:
addmin_status:
cmseasy_departments
id:部門(mén)編號(hào);
name:部門(mén)名字;
visible:是否可見(jiàn);
order:排序;
email:電子郵件;
cmseasy_detail
id:接通客戶內(nèi)容編號(hào);
chatid:客服編號(hào);
detail:接通客戶溝通記錄;
who_witter:
cmseasy_event
id:登錄后臺(tái)記錄編號(hào);
uid:用戶ID;
ip:登錄后臺(tái)IP;
addtime:
event:
note:
cmseasy_friendlink
id:友情鏈接編號(hào);
linktype:鏈接類(lèi)型文字或logo選擇;
typeid:友情鏈接分類(lèi);
name:友情鏈接名稱;
listorder:友情鏈接排序;
url:友情鏈接鏈接地址;
logo:友情鏈接logo地址;
introduce:友情鏈接簡(jiǎn)介;
uid:
username:添加鏈接用戶名;
hits:點(diǎn)擊計(jì)數(shù);
state:審核狀態(tài);
cmseasy_guestbook
id:留言編號(hào);
username:留言者用戶名;
userid:留言者用戶ID;
adddate:留言時(shí)間;
state:
guesttel:留言者電話;
guestemail:留言者郵箱;
guestqq:留言者qq號(hào)碼;
title:留言標(biāo)題;
content:留言內(nèi)容;
reply:管理員回復(fù)內(nèi)容;
cmseasy_linkword
id:內(nèi)容鏈接編號(hào);
linkword:內(nèi)容鏈接詞;
linkurl:內(nèi)容鏈接URL;
linkorder:內(nèi)容鏈接權(quán)重;
linktimes:內(nèi)容鏈接次數(shù);
cmseasy_operators
id:客服編號(hào);
username:名字;
password:密碼;
firstname:姓;
lastname:名;
email:郵件;
level:級(jí)別;
timestamp:時(shí)間;
cmseasy_option
id:
bid:
name:
num:
order:
cmseasy_pay_exchange
exchangeid:
username:
type:
value:
unit:
note:
addtime:
ip:
authid:
cmseasy_p_orders
id:訂單編號(hào);
oid:訂單號(hào);
aid:
status:
mid:
adddate:訂單時(shí)間;
ip:訂單客戶IP;
telphone:訂單客戶手機(jī);
pnums:會(huì)員編號(hào);
pname:訂單單位名稱;
address:客戶地址;
postcode:客戶郵政編碼;
content:訂單留言;
cmseasy_p_pay
pay_id:支付編號(hào);
pay_code:
pay_name:
pay_fee:
pay_desc:
pay_order:
pay_conifg:
enabled:
is_cod:
is_online:
cmseasy_p_shipping
id:
title:
content:
price:
overweight:
cashondelivery:
insure:
insureproportion:
addtime:
cmseasy_sessions
id:
name:
email:
phone:
departmentid:
timestamp:
ip:
status:
cmseasy_sttings
id:配置編號(hào);
type:
tag:
value:
array:
cmseasy_templatetag
id:模板標(biāo)簽編號(hào);
name:模板標(biāo)簽名稱;
tagmodule:所屬模塊;
tagtype:
tagcontent:模板標(biāo)簽內(nèi)容;
tagvar:
note:模板標(biāo)簽說(shuō)明;
tagfrom:
template_name:
cmseasy_type
typeid:分類(lèi)編號(hào);
parentid:所說(shuō)上級(jí)欄目ID,如為一級(jí)欄目此處為0;
typename:分類(lèi)名稱;
stype:
listorder:
image:分類(lèi)圖片;
meta_title:分類(lèi)網(wǎng)頁(yè)標(biāo)題;
keyword:分類(lèi)網(wǎng)頁(yè)關(guān)鍵詞;
description:分類(lèi)網(wǎng)頁(yè)描述;
typecontent:分類(lèi)封面內(nèi)容;
htmldir:分類(lèi)目錄名稱;
template:當(dāng)前分類(lèi)模板;
listtemplate:下屬分類(lèi)列表模板;
showtemplate:下屬內(nèi)容模板;
htmlrule:當(dāng)前分類(lèi)url規(guī)則;
listhtmllrule:下屬分類(lèi)列表url規(guī)則;
showhtmlrule:下屬內(nèi)容url規(guī)則;
module:所屬類(lèi)型;
isshow:是否啟用;
ishtml:動(dòng)靜態(tài)設(shè)置;
ispages:是否分頁(yè)顯示;
includecatarchives:子欄目?jī)?nèi)容設(shè)置;
addarcenable:
linkto:外部鏈接;
attr1:
attr2:
attr3:欄目分頁(yè)值;
thumb:是否啟用獨(dú)立縮略圖寬高度設(shè)置;
thumb_width:欄目列表縮略圖寬度;
thumb_height:欄目列表縮略圖高度;
cmseasy_union
userid:聯(lián)盟用戶編號(hào);
username:聯(lián)盟用戶名;
payaccount:點(diǎn)數(shù);
website:聯(lián)盟用戶網(wǎng)址;
visits:來(lái)訪IP數(shù);
registers:來(lái)訪注冊(cè)數(shù);
settleexpendamount:
totalexpendamount:
totalpayamount:
lastpayamount:
profitmargin:結(jié)算利率;
regtime:加入時(shí)間;
regip:加入IP;
passed:密碼;
cmseasy_union_pay
payid:
userid:
payacconut:
amount:
expendamount:
profitmargin:
inputer:
addtime:
ip:
cmseasy_union_visit
visitid:
userid:
visittime:
visitip:
referer:
regusername:
regtime:
cmseasy_user
userid:用戶編號(hào);
username:用戶名;
password:密碼;
nickname:昵稱;
groupid:所在用戶組;
checked:是否審核;
avatar:頭像;
userip:IP地址;
state:狀態(tài);
qq:QQ號(hào);
e_mail:電子郵件;
address:住址;
tel:電話;
question:安全問(wèn)題;
answer:安全答案;
intro:介紹;
point:積分;
introducer:說(shuō)明;
cmseasy_usergroup
id:編號(hào);
groupid:權(quán)限編號(hào);
name:用戶組名稱;