1:1
chat
+ chat_id:int+ chat_content:String+ chat_time:Datetime+ state:int- sender_id:int- receiver_id:int
n:1
staff
+ staff_id:int+ staff_pwd:String+ staff_name:String+ staff_job:String+ staff_phone:String+ staff_mail:String+ staff_qq:String+ staff_type:int+ sort_key:String- department_id:int
channel
+ channel_id:int- user_id:int
customer
+ cus_id:int+ cus_pwd:String+ cus_name:String+ cus_job:String+ cus_phone:String+ cus_mail:String+ cus_qq:String+ cus_company:String+ sort_key:String- staff_id:int
1:n
department
+ department_id:int+ department_name:String+ sort_key:String- manager_id:int
order
+ order_id:int+ order_title:String+ order_detail:String+ order_type:int+ contract_no:int- cus_id:int- supp_id:int- staff_id:int
supplier
+ supp_id:int+ supp_name:String+ supp_job:String+ supp_phone:String+ supp_mail:String+ supp_qq:String+ supp_company:String+ sort_key:String- staff_id:int
task
+ task_id:int+ task_title:String+ task_degree:int+ task_detail:String- staff_id:int
