Database structure

2016-08-31 09:36:26
tengfei
2650
Last edited by Renee on 2017-01-06 14:03:47

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
Write a Comment
Comment will be posted once reviewed.
right-information