Database structure
- 2016-08-29 10:12:30
- tengfei
- 18215
- Last edited by Zeze on 2016-11-02 08:20:37
eps_address Address
id | id |
account | account |
contact | contact |
address | address |
phone | phone |
zipcode | zipcode |
lang | language |
eps_article Article
id | id |
title | title |
alias | alias |
keywords | keyword |
summary | summary |
content | content |
source | source |
copySite | copySite |
copyURL | copyURL |
author | author |
addedBy | addedBy |
editor | editor |
addedDate |
addedDate |
editedDate | editedDate |
status | statu |
type | type |
submittion | submission |
views | viewa |
sticky | sticky |
order | order |
link | link |
css | CSS |
js | JS |
onlyBody | onlyBody |
lang | language |
eps_blacklist blacklist
type | type |
identity | identity |
reason | reason |
expiredDate | expiredDate |
times | times |
lang | lang |
eps_block Block layout
id |
ID |
originID | originID |
template | template |
type | type |
title | titile |
content |
content |
lang | language |
eps_book Manual/Book
id |
ID |
title |
titile |
alias |
alias |
keywords |
keywords |
summary |
summary |
content |
content
|
type |
type |
parent |
parent |
path | path |
grade | grade |
author | author |
editor | editor |
addedDate | addedDate |
editedDate | editedDate |
views | views |
order |
order |
lang | language |
eps_cart Shopping cart
id | id |
account | account |
product | product |
count | count |
lang | lang |
eps_category category
id | id |
name | name |
abbr | abbr |
alias | alias |
desc | desc |
keywords | keywords |
parent | parent |
path | path |
grade | grade |
order | order |
type | type |
readonly | readonly |
moderators | moderators |
threads | threads |
posts | posts |
postedBy | postedBy |
postedDate | postedDate |
postID | postID |
replyID | replyID |
link | link |
unsaleable | unsaleable |
lang | lang |
eps_config config
id | id |
owner | owner |
module | module |
section | section |
key | key |
value | value |
lang | lang |
eps_down down
id | id |
account | account |
file | file |
ip | ip |
time | time |
referer | referer |
lang | lang |
eps_file attachment
id | Id |
pathname |
pathname |
title |
titile |
extension |
extension |
size |
size |
width | width |
height | height |
objectType | objectType |
objectID | objectID |
addedBy |
addedBy |
addedDate |
addedDate |
public |
public |
score |
score |
downloads | downloads |
extra | extra |
primary |
primary |
editor | editor |
lang | language |
eps_group Group
id |
ID |
name |
group nmae |
role | role |
desc |
group description |
lang | language |
eps_grouppriv grouppriv
group | group |
module | module |
method | method |
lang | language |
eps_layout layout
template | template |
plan | plan |
page | page |
region | region |
object | object |
blocks | blocks |
import | import |
lang | language |
eps_log log
id | id |
account | account |
browser | browser |
ip | ip |
location | location |
date | date |
desc | description |
ext | extension |
type | type |
lang | language |
eps_message Message
id |
ID |
type | type |
objectType | objectType |
objectID | objectID |
account | account |
from |
from |
to | to |
phone |
phone |
mobile |
mobile |
email |
|
date |
date |
content |
content |
link | link |
ip | ip |
status | status |
public | public |
readed |
read |
receiveEmail | receiveEmail |
lang | language |
eps_oauth oauth
account | account |
provider | provider |
openID | openID |
lang | language |
eps_operationlog operationlog
id | id |
type | type |
identity | identity |
operation | operation |
count | count |
createdTime | createdTime |
lang | language |
eps_order_product Orders
id | ID |
orderID | orderID |
productID | productID |
productName | productName |
price |
price |
count |
count |
lang | language |
eps_package Plug-ins
id |
ID |
name |
name |
code |
code |
version |
version |
author |
author |
desc | desccription |
license |
license |
type | type |
site |
site |
chanzhiCompatible | chanzhiCompatible |
templateCompatible | templateCompatible |
installedTime | installedTime |
depends |
depends |
dirs | dirs |
files | files |
status | status |
lang | language |
eps_product_custom Product
id |
ID |
product | product |
label | label |
value | value |
order |
order |
lang | language |
eps_relation relation
type | type |
id | id |
category | category |
lang | language |
eps_reply Reply
id |
Id |
thread | thread |
content |
content |
author |
author |
editor | editor |
addedDate |
addedDate |
editedDate | editedDate |
hidden | hidden |
lang | language |
eps_score Score/Reward Point
id | ID |
account |
account |
method |
method |
type |
type |
count |
count |
before |
before |
after |
after |
objectType | objectType |
objectID | objectID |
actor | actor |
note |
note |
time |
time |
lang | language |
eps_search_index Search
id | id |
objectType | objectType |
objectID | objectID |
title | title |
content | content |
params | params |
addedDate | addedDate |
editedDate | editedDate |
status | status |
lang | lang |
eps_slide Slide
id | id |
group | slide group |
title |
title |
titleColor |
titile color |
mainLink |
main link |
target |
target |
backgroundType | backgroundType |
backgroundColor | backgroundColor |
height |
height |
image |
image |
label |
lable |
buttonClass | buttonClass |
buttonUrl |
button Url |
buttonTarget | buttonTarget |
summary | summary |
createdDate | createdDate |
order | order |
lang | lang |
eps_statlog statlog
id | id |
referer | referer |
domain | domain |
url | url |
link | link |
searchEngine | searchEngine |
keywords | keywords |
visitor | visitor |
osName | osName |
browserName | browserName |
browserVersion | browserVersion |
ip | ip |
country | country |
province | province |
city | city |
account | account |
year | year |
month | month |
day | day |
hour | hour |
new | new |
mobile | mobile |
lang | language |
eps_statreferer statreferer
id | id |
url | url |
domain | domain |
searchEngine | searchEngine |
keywords | keywords |
lang | lang |
eps_statregion statregion
id | id |
timeType | timeType |
timeValue | timeValue |
country | country |
province | province |
city | city |
pv | pv |
uv | uv |
ip | ip |
lang | lang |
eps_statreport statreport
id | id |
type | type |
item | item |
extra | extra |
timeType | timeType |
timeValue | timeValue |
pv | pv |
uv | uv |
ip | ip |
lang | lang |
eps_statvisitor statvisitor
id | id |
osName | osName |
osVersion | osVersion |
browserName | browserName |
browserVersion | browserVersion |
browserLanguage | browserLanguage |
device | device |
resolution | resolution |
createdTime | createdTime |
lang | lang |
eps_tag Keyword
id | id |
tag | tag |
link | link |
rank |
rank |
lang | language |
eps_thread 主题
id | ID |
board |
board |
title |
tiltile |
color | color |
content |
content |
author |
author |
editor | editor |
addedDate | addedDate |
editedDate | editedDate |
readonly |
Read only |
views |
views |
stick |
stick |
replies |
replies |
repliedBy | repliedBy |
repliedDate | repliedDate |
replyID | replyID |
hidden | hidden |
link |
link |
lang | language |
status |
status |
ip | ip |
eps_user Member
id |
ID |
account |
account |
password |
password |
realname |
real name |
realnames | realnames |
nickname |
nickname |
admin |
admin |
avatar |
avatar |
birthday |
birthday |
gender |
gender |
email |
|
skype | skype |
yahoo |
yahoo |
gtalk | Gtalk |
wangwang |
wangwang |
site | site |
mobile |
mobile |
phone |
phone |
company |
compnay/organization |
address |
address |
zipcode |
zip code |
visits |
visits |
ip | IP |
last |
last login |
score |
reward point/score |
rank |
rank |
maxLogin | maxLogin |
fails | fails |
referer | referer |
join |
date of joining |
reset | reset |
locked | once looked, please try in %s |
public | public |
emailCertified | emailCertified |
security | security |
os | os |
browser | browser |
lang | language |
eps_usergroup usergroup
account | account |
group | group |
lang | lang |
eps_widget Widget
id | id |
account | account |
type | type |
title |
widget name |
params |
|
order | order |
grid | grid |
hidden |
hidden |
lang | language |
eps_wx_response wx
id | id |
public | public |
key | key |
group | group |
type | type |
source | source |
content | content |
lang | language |
-
CUSTOMERS
Haier Vanke Skyworth China Mobile -
PRODUCTS
ZenTao ZDOO ZenTao Cloud -
SUPPORT
GitHub SourceForge Dynamic Download -
CONTACT US
Email: Renee@easysoft.ltd Skype: tengfei@cnezsoft.com