Project
project_id(INT)project_name(VARCHAR)description(TEXT)start_date(DATETIME)end_date(DATETIME)completion_rate(VARCHAR)status(INT)creator(INT)manager(INT)
Goal
goal_id(INT)goal_name(VARCHAR)goal_type(VARCHAR)description(TEXT)create_date(DATETIME)active_date(DATETIME)in_progress_date(DATETIME)estimated_date(DATETIME)estimated_effort(INT)history(INT)creator(INT)project(INT)status(INT)drop(INT)
Project_Role
role_id(INT)role_name(VARCHAR)
Membership
project(INT)member(INT)role(INT)
bd_short_message(短信记录表)
id(INT) idcust_no(INT) 用户编号type(INT) 短信类型time(datetime) 短信发送时间price(decimal) 单价channel(int) 渠道平台item(int) 项目类型
System_User
department(VARCHAR)phone(VARCHAR)address(VARCHAR)rank(VARCHAR)
