Zdoo ManualBook Info
- 1 Introduction
- 1.1 About Zdoo
- 1.2 Zdoo Features
- 1.3 Technical Support
- 1.4 Zdoo License
- 2 Install and Upgrade
- 2.1 ZDOO Installation (for all systems)
- 2.2 One-click Installation Package for Windows (Recommended)
- 2.3 One-click Installation Package for Linux
- 2.4 Upgrade Zdoo
- 2.5 Zdoo Cloud
- 2.6 Remove zdoo from the address
- 2.7 Data Backup
- 2.8 Install Ioncube
- 2.9 Install php-zip
- 3 CRM
- 3.1 CRM Workflow
- 3.2 Add Product
- 3.3 Add Customer
- 3.4 Create Order
- 3.5 Sign Contract
- 3.6 Manage Contact
- 3.7 Manage List
- 3.8 Manage Supplier
- 3.9 CRM Settings
- 3.10 CRM Report
- 4 OA
- 4.1 Todo
- 4.2 Review
- 4.3 Announcement
- 4.4 Attendance
- 4.5 Leave
- 4.6 Makeup
- 4.7 Overtime
- 4.8 Business Trip
- 4.9 Reimbursement
- 4.10 Lieu
- 4.11 Egress
- 4.12 Holiday
- 4.13 Settings
- 5 Cashflow(Cash)
- 5.1 Introduction
- 5.2 Basic Settings
- 5.3 Add Bank Account
- 5.4 Manage Account
- 5.5 Keep Account
- 5.6 Batch keep accounts and import
- 5.7 Reconciliation
- 5.8 Report
- 6 Project (Proj)
- 6.1 Project Workflow
- 6.2 Create Project
- 6.3 Create Task
- 6.4 Actions in a project
- 6.5 Action Views
- 6.6 Actions in a task
- 7 Document(Doc)
- 7.1 Introduction
- 7.2 Create Document Library
- 7.3 Create Document
- 8 TEAM
- 8.1 Introduction
- 8.2 Settings
- 8.3 Modules
- 9 Inventory(PSI)
- 10 Flow
- 10.1 Introduction
- 10.2 Built-in Flows
- 10.3 Features
- 10.4 Examples
- 11 Ameba
- 11.1 Amoeba Management
- 11.2 Start Ameba
- 11.3 Ameba Category
- 11.4 Ameba Department
- 11.5 Expense Distribution Rules
- 11.6 Income Distribution Rules
- 11.7 Ameba Budget
- 11.8 Ameba Trade
- 11.9 Ameba Report
- 12 Administration
- 12.1 Settings
- 12.2 User
- 12.3 Privileges
- 12.4 Apps
- 12.5 Email settings
- 13 Integration
- 13.1 Introduction
- 13.2 Integrate ZenTao
- 14 Customization
- 14.1 Get Ready
- 14.2 Zdoo Directory
- 14.3 Find the Code
- 14.4 Database Structure
Database Structure
- 2016-08-31 09:36:26
- tengfei
- 8910
- Last edited by MCFEY on 2019-08-12 11:17:00
cash_balance Balance
id | ID |
depositor | account |
date | date |
money | amount |
currency |
currency type |
createdBy | createdBy |
createdDate | createdDate |
editedBy | editedBy |
editedDate | editedDate |
cash_depositor Account
id | ID |
abbr |
abbreviation |
provider | provider |
title |
account name |
tags |
tags |
account |
account number |
bankcode | bankcode |
public |
public account |
type | type |
currency |
type of currency |
status | status |
createdBy | createdBy |
createdDate | createdDate |
editedBy | editedBy |
editedDate | editedDate |
cash_trade Accounting
id | ID |
depositor | account |
parent | parent |
product |
product |
trader | trader |
order | order |
contract | contract |
dept | department |
type | transaction |
money | amount |
currency | currency |
date | date |
handlers |
handler |
category | category |
desc |
description |
createdBy | createdBy |
createdDate | createdDate |
editedBy | editedBy |
editedDate | editedDate |
crm_address Address
id | id |
objectType | objectType |
objectID | objectID |
title | title |
area |
area |
location | location |
crm_contact Contact
id | ID |
realname |
real name |
nickname |
nick name |
resume | resume |
origin | origin |
originAccount | originAccount |
status |
status |
avatar |
avatar |
birthday | birthday |
gender |
gender |
email |
|
skype | Skype |
yahoo |
yahoo |
gtalk | GTalk |
wangwang |
wangwang |
site |
site |
mobile |
mobile |
phone |
phone |
company |
company |
fax |
fax |
weibo |
|
weixin |
Wechat |
desc |
description |
createdBy | createdBy |
createdDate | createdDate |
editedBy | editedBy |
editedDate | editedDate |
contactedBy | contactedBy |
contactedDate | contactedDate |
nextDate |
next contact date |
assignedTo | assign to |
ignoredBy | ignored By |
deleted | deleted |
crm_contract 合同
id |
id |
customer |
customer |
name |
name |
code |
contract number |
amount |
amount |
items |
items |
begin |
date to start |
end |
date to end |
delivery |
delivery |
return |
payment |
currency |
type of currency |
status |
status |
contact |
contact |
handlers |
involved |
signedBy |
signed by |
signedDate |
signed date |
deliveredBy |
delivered by |
deliveredDate |
delovered date |
returnedBy |
returned by |
returnedDate |
returned date |
finishedBy |
finshed by |
finishedDate |
finished date |
canceledBy |
cancelled by |
canceledDate |
cancelled date |
createdBy |
created by |
createdDate |
created date |
editedBy |
edited by |
editedDate |
edited date |
contactedBy |
contacted by |
contactedDate |
contacted date |
nextDate |
next contact date |
deleted | deleted |
crm_contractorder contractorder
contract | contract |
order | order |
crm_customer Customer
id |
ID |
name |
name |
type |
type |
relation |
relation |
size |
size |
industry |
industry |
area |
area |
status |
status |
level |
level |
intension |
intention to buy |
site |
site |
blog |
|
weixin |
Wechat |
category | category |
desc | introduction |
public |
public |
createdBy |
created by |
createdDate |
created date |
assignedTo |
assigned to |
assignedBy |
assigned by |
assignedDate |
assigned date |
editedBy |
edited by |
editedDate |
edited date |
contactedBy | contacted By |
contactedDate |
last contact date |
nextDate |
next contact date |
deleted | deleted |
crm_delivery Delivery
id | id |
contract | contract |
deliveredBy | deliveredBy |
deliveredDate | deliveredDate |
comment | comment |
crm_order Order
id |
ID |
product |
Product |
customer |
customer |
plan |
planned amount |
real |
traded amount |
currency |
type of currency |
status |
status |
createdBy |
created by |
createdDate |
created date |
editedBy |
last edited by |
editedDate |
last edited date |
assignedTo |
assigned to |
assignedBy |
assigned by |
assignedDate |
assigned date |
signedBy |
signed by |
signedDate |
signed date |
closedBy |
closed by |
closedDate |
close date |
closedReason |
close reason |
activatedBy |
activated by |
activatedDate |
activated date |
contactedBy |
conteacted by |
contactedDate |
last contact date |
nextDate |
next contact date |
deleted | deleted |
crm_plan Plan
id | id |
amount | amount |
contract | contract |
returnedBy | returnedBy |
returnedDate | returnedDate |
crm_resume Resume
id |
id |
contact |
contact |
customer |
customer |
maker |
maker |
dept |
department |
title |
title |
address |
address |
join |
join date |
left |
left date |
deleted | deleted |
crm_salesgroup Salesgroup
id | id |
name | name |
desc | desc |
users | users |
crm_salespriv salespriv
account | account |
salesgroup | salesgroup |
priv | priv |
crm_service Service
customer | customer |
product | product |
expire | expire |
crm_test Test
id | id |
deleted | deleted |
name | name |
prise | prise |
num | num |
addedDate | addedDate |
editedBy | editedBy |
oa_attend Attendance
id |
ID |
account |
account |
date |
date |
signIn |
sign in |
signOut |
sign out |
status |
status |
ip | IP |
device |
device |
manualIn |
clock-in time |
manualOut |
clock-out time |
reason |
reason |
desc |
description |
reviewStatus |
review status |
reviewedBy |
reviewed by |
reviewedDate |
reviewed date |
oa_attendstat attendstat
id | id |
account | account |
month | month |
normal | normal |
late | late |
early | early |
absent | absent |
trip | trip |
paidLeave | paidLeave |
unpaidLeave | unpaidLeave |
timeOvertime | timeOvertime |
restOvertime | restOvertime |
holidayOvertime | holidayOvertime |
deserve | deserve |
actual | actual |
status | status |
oa_doc document
id |
ID |
product |
product |
project |
project |
lib |
library |
module | module |
title |
title |
digest |
digest |
keywords |
keywords |
type |
type |
content |
content |
url | URL |
views |
views |
createdBy |
created by |
createdDate |
created date |
editedBy |
edited by |
editedDate |
edited date |
private |
private |
users |
authorized user |
groups |
authorized group |
deleted |
deleted |
oa_doclib document library
id | id |
name | name |
private | private |
users | users |
groups | groups |
createdBy | createdBy |
createdDate | createdDate |
editedBy | editedBy |
editedDate | editedDate |
deleted | deleted |
oa_holiday Holiday
id |
ID |
name |
name |
desc |
description |
year | year |
begin |
time to start |
end |
time to end |
oa_leave Leave
id |
ID |
year | year |
begin |
to begin |
end |
to end |
start |
time to start |
finish |
time to finish |
hours |
time cost |
type |
type |
desc |
description |
status |
status |
createdBy |
created by |
createdDate |
created date |
reviewedBy |
reviewed by |
reviewedDate |
reviewed date |
oa_overtime Overtime
id |
ID |
year | year |
begin |
begin |
end |
end |
start |
time to start |
finish |
time to finish |
hours |
time cost |
type |
type |
desc |
description |
status |
status |
createdBy |
created by |
createdDate |
created date |
reviewedBy |
reviewed by |
reviewedDate |
reviewed date |
oa_project Project View
id |
ID |
name |
name |
desc |
description |
begin |
time to begin |
end |
time to end |
createdBy |
created by |
createdDate |
created date |
editedBy | edited By |
editedDate | edited Date |
status |
status |
whitelist |
white list |
deleted |
deleted |
oa_refund Reimburse
id |
ID |
name |
name |
parent | parent |
category |
category |
date |
date |
money |
amount |
currency |
currency |
desc |
description |
related |
involved |
status |
status |
createdBy |
created by |
createdDate |
created date |
editedBy |
edited by |
editedDate |
edited date |
firstReviewer |
first reviewer |
firstReviewDate |
first review date |
secondReviewer |
second reviewer |
secondReviewDate |
second review date |
refundBy |
reimbursed by |
refundDate |
reimbursed date |
reason |
reason |
oa_todo To-Do
id |
id |
account |
account |
date |
date |
begin |
time to begin |
end |
time to end |
type |
type |
idvalue |
task/oder |
pri |
priority |
name |
name |
desc |
description |
status |
status |
private |
private |
assignedTo |
assigned to |
assignedBy |
assigned by |
assignedDate |
assigned date |
finishedBy |
finished by |
finishedDate |
finished date |
closedBy |
closed by |
closedDate |
closed date |
oa_trip Business Trip
id |
ID |
name |
name |
desc |
description |
year | year |
begin | begin |
end |
end |
start | start |
finish | finish |
from |
from |
to |
to |
createdBy |
created by |
createdDate |
created date |
sys_action System log
id | id |
customer | customer |
contact |
contact |
objectType |
obeject type |
objectID |
object ID |
actor |
Operator |
action |
action |
date |
date |
comment |
comment |
extra | extra |
read | read |
reader | reader |
sys_article Article
id |
ID |
title |
title |
alias |
alias |
keywords |
keyword |
summary |
summary |
content |
content |
original |
origin |
copySite |
copy site |
copyURL | copy URL |
author |
author |
editor |
editor |
createdDate |
created date |
editedDate |
edited date |
status |
status |
type |
type |
views |
views |
sticky | sticky |
order |
oder |
private |
private |
users |
authorized user |
groups |
authorized group |
readers |
number of readers |
sys_block Block
id | id |
account | account |
app | app |
title | title |
source | source |
block | widget |
params |
parameters |
order | order |
grid | grid |
hidden | hidden |
sys_category Category
id | id |
name | name |
alias | alias |
desc | desc |
keywords | keywords |
root | root |
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 |
users | users |
rights | rights |
refund | refund |
major | major |
sys_config Configuration
id | id |
owner | owner |
app | app |
module | module |
section | section |
key | key |
value | value |
sys_cron Timed task
id | id |
m | minute |
h |
hour |
dom |
day |
mon |
month |
dow |
week |
command |
command |
remark |
remark |
type |
type of tasks |
buildin | built-in |
status |
status |
lastTime |
last execution time |
sys_entry Application
id | id |
name | name |
abbr |
abbreviation |
code |
code |
buildin |
built-in applcation |
integration | integration |
open |
open with |
key |
key |
ip | IP |
logo | Logo |
login | login |
logout |
logout |
block |
block |
control |
control |
size | size |
position | position |
visible | visible |
order | order |
zentao |
ZenTao |
category |
category |
sys_file Attachment
id |
ID |
pathname |
path name |
title |
title |
extension |
extension |
size |
size |
objectType | objectType |
objectID | objectID |
createdBy |
created by |
createdDate |
created date |
editor | editor |
primary |
primary |
public |
public |
downloads |
number of download |
extra | extra |
sys_group Group
id |
ID |
name |
name |
desc |
description |
sys_grouppriv grouppriv
group | group |
module | module |
method | method |
sys_history history
id | id |
action | action |
field | field |
old | old |
new | new |
diff | diff |
sys_lang language
id | id |
lang | lang |
app | app |
module | module |
section | section |
key | key |
value | value |
system | system |
sys_message message
id | ID |
type |
type |
objectType | objectType |
objectID | objectID |
account | account |
from |
from |
to | to |
date |
date |
content |
content |
status | status |
readed |
read |
sys_package Plug-ins
id | ID |
name |
NAME |
code |
code |
version |
version |
author |
author |
desc | description |
license |
license |
type | type |
site |
site |
ranzhiCompatible | Zdoo iCompatible |
installedTime | installed Time |
depends |
depend |
dirs | dirs |
files | files |
status | status |
sys_product product
id | id |
name | name |
code | code |
type | type |
status | status |
line | line |
desc | desc |
createdBy | createdBy |
createdDate | createdDate |
editedBy | editedBy |
editedDate | editedDate |
deleted | deleted |
sys_relation relation
type | type |
id | id |
category | category |
sys_schema Import template
id | id |
name | name |
category | category |
trader | trader |
type | type |
money | money |
desc | desc |
date | date |
fee | fee |
dept | dept |
product | product |
sys_sso sso
id | id |
sid | sid |
entry | entry |
token | token |
time | time |
sys_tag Keyword
id | id |
tag | tag |
rank |
rank |
sys_task Task
id |
ID |
project |
project |
customer |
customer |
order |
order |
category |
category |
name |
name |
type |
type |
pri |
priority |
estimate |
estimated |
consumed |
consumed |
left |
left |
deadline |
deadline |
status |
status |
statusCustom |
status order |
mailto |
mail to |
desc |
description |
parent |
parent task |
createdBy |
created by |
createdDate |
created date |
assignedTo |
assigned to |
assignedDate |
assigned date |
estStarted |
estimated start time |
realStarted |
actual start time |
finishedBy |
finished by |
finishedDate |
finished date |
canceledBy |
cancelled by |
canceledDate |
cancelled date |
closedBy |
closed by |
closedDate |
closed date |
closedReason |
closed reason |
editedBy |
edited by |
editedDate |
edited date |
deleted | deleted |
key | key |
sys_team team
type | type |
id | id |
account | account |
role | role |
join | join |
days | days |
hours | hours |
estimate | estimate |
consumed | consumed |
left | left |
order | order |
sys_user Member
id |
ID |
dept |
department |
account |
account |
password |
password |
realname |
real name |
role |
role |
nickname |
nick name |
admin |
admin |
avatar |
avatar |
birthday |
birthday |
gender |
gender |
email |
|
skype | skype |
yahoo |
yahoo |
gtalk | Gtalk |
wangwang |
wangwang |
site | site |
mobile |
mobile |
phone |
phone |
address |
address |
zipcode |
zip code |
visits |
visits |
ip | last IP |
last |
last login |
ping |
ping |
fails | fails |
join |
joined date |
locked |
locked account |
deleted | deleted |
sys_usergroup usergroup
account | account |
group | group |
sys_userquery userquery
id | id |
account | account |
module | module |
title | title |
form | form |
sql | sql |
team_reply Reply
id |
ID |
thread | thread |
content |
content |
author |
author |
editor | editor |
createdDate |
replied date |
editedDate | edited Date |
hidden | hidden |
team_thread thread
id |
ID |
board |
board |
title |
title |
content |
content |
author |
author |
editor | editor |
createdDate | createdDate |
editedDate | editedDate |
readonly |
read only |
views |
views |
stick |
stick |
replies |
replies |
repliedBy | replied By |
repliedDate | repliedDate |
replyID | replyID |
hidden | hidden |
Write a Comment
CUSTOMERS
PRODUCTS
SUPPORT
CONTACT US
- Email: Philip@easycorp.ltd
- Skype: philip517
- Whatsapp: +86 185 6395 3295