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	email
skype	Skype
qq	QQ
yahoo	yahoo
gtalk	GTalk
wangwang	wangwang
site	site
mobile	mobile
phone	phone
company	company
fax	fax
weibo	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
weibo	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	email
skype	skype
qq	QQ
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