核心数据库表

1:n

Project_predict_info

project_idpredict_index(varchar)predict_price(int)budget(int)per_cost(int)apply_num(int)coupon_type(varchar)coupon_limit_val(int)coupon_face_val(int)predict_use_num(int)predict_unit_price(int)per_cost_history(int)per_cost_friend(int)roi(float)roi_history(float)

1:1

budget_pool

pool_id(int)bugget_type(varchar)name(varchar)total(int)out_total(int)actual_out_total(int)predict_out_total(int)remain(int)actual_remail(int)

Project_finance_info

finance_subject(varchar)budget_pool_id(varchar)budget_total(int)

Project_basic_info

project_id(int)fee_type(varchar)business_type(varchar)resource_type(varchar)department(varchar)erp(varchar)created_depart(varchar)phone(varchar)

attach_info

project_idname(varchar)temp_name(varchar)attach_type

Project_normal_info

name(varchar)project_type(varchar)desc(varchar)cost(int)start_time(varchar)end_time(varchar)status(int)cooperation_name(varchar)cooperation_type(varchar)cooperation_mode(varchar)extension_products(varchar)put_type(varchar)channel(varchar)risk_rule(varchar)pool_type(varchar)settle_type(varchar)platform(varchar)

Project

basic_infonormal_infopredict_infofinance_info