/ 网贷系统/ p2p网贷系统开发数据库架构设计清单

p2p网贷系统开发数据库架构设计清单

发布时间:2014-07-24 分类:互联网金融百科

P2P借贷系统开发之前需要设计好p2p网贷系统的数据库架构,也就是网贷平台开发要用到的数据库表和字段都要设计好。如何做好p2p网贷系统平台数据库架构呢?这里提供个网贷平台数据库模板,以及如何快速利用excel设计数据库表字段并批量导入至数据库。

p2p网贷系统数据库架构设计

p2p网贷系统数据库的数据字典模板设计是工作量极大的活,需要有足够的耐心和细心,下面为P2P借贷系统数据字典样表:

表名 引擎 表字段结构
lzh_acl MyISAM controller:类型=text | 索引=无 | 默认值= group_id:类型=int(10) | 索引=PRI | 默认值= | 其他auto_increment groupname:类型=varchar(100) | 索引=无 | 默认值=
lzh_ad MyISAM id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment content:类型=varchar(5000) | 索引=无 | 默认值= start_time:类型=int(10) | 索引=无 | 默认值= end_time:类型=int(10) | 索引=无 | 默认值= add_time:类型=int(10) | 索引=无 | 默认值=0 title:类型=varchar(100) | 索引=无 | 默认值= ad_type:类型=tinyint(4) | 索引=无 | 默认值=0
lzh_area MyISAM id:类型=smallint(5) unsigned | 索引=PRI | 默认值=auto_increment reid:类型=smallint(5) unsigned | 索引=MUL | 默认值=0 name:类型=varchar(120) | 索引=无 | 默认值= sort_order:类型=smallint(5) unsigned | 索引=无 | 默认值=0 is_open:类型=tinyint(3) unsigned | 索引=MUL | 默认值=0 domain:类型=varchar(10) | 索引=无 | 默认值=
lzh_article MyISAM id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment title:类型=varchar(50) | 索引=无 | 默认值= art_info:类型=varchar(255) | 索引=无 | 默认值= art_keyword:类型=varchar(200) | 索引=无 | 默认值= art_content:类型=text | 索引=无 | 默认值= art_writer:类型=varchar(20) | 索引=无 | 默认值= art_time:类型=int(10) unsigned | 索引=无 | 默认值=0 type_id:类型=smallint(5) unsigned | 索引=MUL | 默认值= art_url:类型=varchar(200) | 索引=无 | 默认值= art_img:类型=varchar(200) | 索引=无 | 默认值= art_userid:类型=smallint(5) unsigned | 索引=无 | 默认值= sort_order:类型=int(10) unsigned | 索引=无 | 默认值= art_click:类型=int(10) unsigned | 索引=无 | 默认值=0 art_set:类型=int(1) unsigned | 索引=无 | 默认值=0 art_attr:类型=tinyint(4) | 索引=无 | 默认值=0
lzh_article_category MyISAM id:类型=smallint(6) | 索引=PRI | 默认值=auto_increment type_name:类型=varchar(40) | 索引=无 | 默认值= type_url:类型=varchar(200) | 索引=无 | 默认值= type_keyword:类型=varchar(200) | 索引=无 | 默认值= type_info:类型=varchar(400) | 索引=无 | 默认值= type_content:类型=text | 索引=无 | 默认值= sort_order:类型=int(11) | 索引=无 | 默认值= type_set:类型=tinyint(1) | 索引=无 | 默认值=0 parent_id:类型=smallint(6) | 索引=无 | 默认值= type_nid:类型=varchar(50) | 索引=无 | 默认值= is_hiden:类型=int(1) unsigned | 索引=无 | 默认值=0 add_time:类型=int(10) unsigned | 索引=无 | 默认值= is_sys:类型=tinyint(3) unsigned | 索引=无 | 默认值= model:类型=char(30) | 索引=无 | 默认值=
lzh_auser_dologs MyISAM id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment type:类型=varchar(16) | 索引=无 | 默认值= tid:类型=int(10) unsigned | 索引=无 | 默认值= tstatus:类型=tinyint(4) unsigned | 索引=无 | 默认值= deal_ip:类型=varchar(16) | 索引=无 | 默认值= deal_time:类型=int(10) unsigned | 索引=无 | 默认值= deal_user:类型=varchar(50) | 索引=MUL | 默认值= deal_info:类型=varchar(200) | 索引=无 | 默认值=
lzh_ausers MyISAM id:类型=int(11) | 索引=PRI | 默认值=auto_increment user_name:类型=varchar(50) | 索引=无 | 默认值= user_pass:类型=varchar(50) | 索引=无 | 默认值= u_group_id:类型=smallint(6) | 索引=无 | 默认值= real_name:类型=varchar(20) | 索引=无 | 默认值=匿名 last_log_time:类型=int(10) | 索引=无 | 默认值=0 last_log_ip:类型=varchar(30) | 索引=无 | 默认值=0 is_ban:类型=int(1) | 索引=无 | 默认值=0 area_id:类型=int(11) | 索引=无 | 默认值= area_name:类型=varchar(10) | 索引=无 | 默认值= is_kf:类型=int(10) unsigned | 索引=MUL | 默认值=0 qq:类型=varchar(20) | 索引=无 | 默认值= phone:类型=varchar(20) | 索引=无 | 默认值= user_word:类型=varchar(100) | 索引=无 | 默认值=
lzh_auto_borrow MyISAM id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment uid:类型=int(10) unsigned | 索引=无 | 默认值= interest_rate:类型=decimal(5,2) | 索引=无 | 默认值= duration_from:类型=tinyint(3) unsigned | 索引=无 | 默认值= duration_to:类型=tinyint(3) unsigned | 索引=无 | 默认值= account_money:类型=decimal(15,2) | 索引=无 | 默认值= end_time:类型=int(10) unsigned | 索引=无 | 默认值= add_time:类型=int(10) unsigned | 索引=无 | 默认值= add_ip:类型=varchar(16) | 索引=无 | 默认值= is_auto_full:类型=int(11) | 索引=无 | 默认值= invest_money:类型=decimal(15,2) | 索引=无 | 默认值= is_use:类型=tinyint(4) | 索引=MUL | 默认值=1 borrow_type:类型=tinyint(4) | 索引=无 | 默认值= min_invest:类型=decimal(15,2) | 索引=无 | 默认值= invest_time:类型=int(10) | 索引=无 | 默认值=0
lzh_borrow_info InnoDB id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment borrow_name:类型=varchar(50) | 索引=无 | 默认值= borrow_uid:类型=int(11) | 索引=MUL | 默认值= borrow_duration:类型=tinyint(3) unsigned | 索引=无 | 默认值= borrow_money:类型=decimal(15,2) | 索引=无 | 默认值= borrow_interest:类型=decimal(15,2) | 索引=无 | 默认值= borrow_interest_rate:类型=decimal(5,2) | 索引=无 | 默认值= borrow_fee:类型=decimal(15,2) | 索引=无 | 默认值= has_borrow:类型=decimal(15,2) unsigned | 索引=无 | 默认值= borrow_times:类型=smallint(5) unsigned | 索引=无 | 默认值=0 repayment_money:类型=decimal(15,2) | 索引=无 | 默认值= repayment_interest:类型=decimal(15,2) | 索引=无 | 默认值= expired_money:类型=decimal(15,2) | 索引=无 | 默认值= repayment_type:类型=tinyint(3) unsigned | 索引=无 | 默认值= borrow_type:类型=tinyint(3) unsigned | 索引=无 | 默认值= borrow_status:类型=tinyint(3) unsigned | 索引=MUL | 默认值= borrow_use:类型=tinyint(3) unsigned | 索引=无 | 默认值= add_time:类型=int(10) | 索引=无 | 默认值= collect_day:类型=tinyint(3) unsigned | 索引=无 | 默认值= collect_time:类型=int(10) unsigned | 索引=无 | 默认值= full_time:类型=int(10) unsigned | 索引=无 | 默认值=0 deadline:类型=int(10) unsigned | 索引=无 | 默认值= first_verify_time:类型=int(10) unsigned | 索引=无 | 默认值= second_verify_time:类型=int(10) unsigned | 索引=无 | 默认值= add_ip:类型=varchar(16) | 索引=无 | 默认值= borrow_info:类型=varchar(500) | 索引=无 | 默认值= total:类型=tinyint(4) | 索引=无 | 默认值= has_pay:类型=tinyint(4) | 索引=无 | 默认值= substitute_money:类型=decimal(15,2) | 索引=无 | 默认值= reward_vouch_rate:类型=float(5,2) | 索引=无 | 默认值= reward_vouch_money:类型=decimal(15,2) unsigned | 索引=无 | 默认值= reward_type:类型=tinyint(3) unsigned | 索引=无 | 默认值=0 reward_num:类型=decimal(10,2) unsigned | 索引=无 | 默认值= reward_money:类型=decimal(15,2) unsigned | 索引=无 | 默认值= borrow_min:类型=mediumint(8) unsigned | 索引=无 | 默认值= borrow_max:类型=mediumint(8) unsigned | 索引=无 | 默认值= province:类型=int(10) unsigned | 索引=无 | 默认值= city:类型=int(10) unsigned | 索引=无 | 默认值= area:类型=int(10) unsigned | 索引=无 | 默认值= vouch_member:类型=varchar(100) | 索引=无 | 默认值= has_vouch:类型=decimal(15,2) | 索引=无 | 默认值= password:类型=char(32) | 索引=无 | 默认值= is_tuijian:类型=tinyint(2) unsigned | 索引=无 | 默认值= can_auto:类型=tinyint(3) unsigned | 索引=无 | 默认值=1 is_huinong:类型=tinyint(3) unsigned | 索引=无 | 默认值=0 updata:类型=varchar(3000) | 索引=无 | 默认值= danbao:类型=int(11) | 索引=无 | 默认值= vouch_money:类型=decimal(15,2) | 索引=无 | 默认值= money_collect:类型=decimal(15,2) | 索引=无 | 默认值=0.00 risk_control:类型=varchar(2000) | 索引=无 | 默认值=
lzh_borrow_info_lock InnoDB id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment suo:类型=int(10) | 索引=无 | 默认值=
lzh_borrow_investor InnoDB id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment status:类型=tinyint(3) unsigned | 索引=无 | 默认值=0 borrow_id:类型=int(10) unsigned | 索引=MUL | 默认值= investor_uid:类型=int(10) unsigned | 索引=MUL | 默认值= borrow_uid:类型=int(11) | 索引=无 | 默认值= investor_capital:类型=decimal(15,2) | 索引=无 | 默认值= investor_interest:类型=decimal(15,2) | 索引=无 | 默认值= receive_capital:类型=decimal(15,2) | 索引=无 | 默认值= receive_interest:类型=decimal(15,2) | 索引=无 | 默认值= substitute_money:类型=decimal(15,2) | 索引=无 | 默认值= expired_money:类型=decimal(15,2) | 索引=无 | 默认值= invest_fee:类型=decimal(15,2) | 索引=无 | 默认值= paid_fee:类型=decimal(15,2) | 索引=无 | 默认值= add_time:类型=int(10) unsigned | 索引=无 | 默认值= deadline:类型=int(10) unsigned | 索引=无 | 默认值= is_auto:类型=tinyint(3) unsigned | 索引=无 | 默认值=0 reward_money:类型=decimal(15,2) | 索引=无 | 默认值= debt_status:类型=tinyint(3) | 索引=无 | 默认值=0 debt_uid:类型=int(11) | 索引=无 | 默认值=
lzh_borrow_tip MyISAM id:类型=int(11) | 索引=PRI | 默认值=auto_increment uid:类型=int(10) unsigned | 索引=无 | 默认值= interest_rate:类型=decimal(5,2) | 索引=无 | 默认值= borrow_type:类型=tinyint(3) unsigned | 索引=MUL | 默认值= duration_from:类型=tinyint(3) unsigned | 索引=无 | 默认值= duration_to:类型=tinyint(3) unsigned | 索引=无 | 默认值= account_money:类型=decimal(15,2) | 索引=无 | 默认值=
lzh_borrow_verify InnoDB borrow_id:类型=int(11) unsigned | 索引=PRI | 默认值= deal_user:类型=mediumint(10) unsigned | 索引=无 | 默认值= deal_time:类型=int(10) unsigned | 索引=无 | 默认值= deal_info:类型=varchar(50) | 索引=无 | 默认值= deal_time_2:类型=int(10) unsigned | 索引=无 | 默认值= deal_user_2:类型=mediumint(10) unsigned | 索引=无 | 默认值= deal_info_2:类型=varchar(50) | 索引=无 | 默认值= deal_status:类型=tinyint(3) unsigned | 索引=无 | 默认值= deal_status_2:类型=tinyint(3) unsigned | 索引=无 | 默认值=
lzh_comment MyISAM id:类型=int(11) | 索引=PRI | 默认值=auto_increment uid:类型=int(10) unsigned | 索引=无 | 默认值= uname:类型=varchar(20) | 索引=无 | 默认值= tid:类型=int(10) unsigned | 索引=无 | 默认值= type:类型=tinyint(4) | 索引=MUL | 默认值= comment:类型=varchar(500) | 索引=无 | 默认值= add_time:类型=int(10) unsigned | 索引=无 | 默认值= deal_time:类型=int(10) unsigned | 索引=无 | 默认值= deal_info:类型=varchar(500) | 索引=无 | 默认值= name:类型=varchar(50) | 索引=无 | 默认值=
lzh_face_apply MyISAM id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment uid:类型=int(10) unsigned | 索引=MUL | 默认值= add_time:类型=int(10) unsigned | 索引=无 | 默认值= add_ip:类型=varchar(16) | 索引=无 | 默认值= apply_status:类型=tinyint(3) unsigned | 索引=无 | 默认值=0 credits:类型=int(11) | 索引=无 | 默认值=0 deal_user:类型=int(10) unsigned | 索引=无 | 默认值= deal_time:类型=int(10) unsigned | 索引=无 | 默认值= deal_info:类型=varchar(50) | 索引=无 | 默认值=
lzh_feedback MyISAM id:类型=int(11) | 索引=PRI | 默认值=auto_increment type:类型=tinyint(3) unsigned | 索引=无 | 默认值= name:类型=varchar(30) | 索引=无 | 默认值= contact:类型=varchar(50) | 索引=无 | 默认值= msg:类型=varchar(500) | 索引=无 | 默认值= ip:类型=varchar(16) | 索引=无 | 默认值= add_time:类型=int(10) unsigned | 索引=无 | 默认值= status:类型=tinyint(3) unsigned | 索引=无 | 默认值=0
lzh_friend MyISAM id:类型=int(11) | 索引=PRI | 默认值=auto_increment link_txt:类型=varchar(50) | 索引=无 | 默认值= link_href:类型=varchar(500) | 索引=无 | 默认值= link_img:类型=varchar(100) | 索引=无 | 默认值= link_order:类型=int(1) | 索引=无 | 默认值=0 link_type:类型=int(1) | 索引=无 | 默认值=0 is_show:类型=int(1) | 索引=无 | 默认值=1 game_id:类型=int(11) | 索引=MUL | 默认值=0 game_name:类型=char(50) | 索引=无 | 默认值=
lzh_global MyISAM id:类型=smallint(6) | 索引=PRI | 默认值=auto_increment type:类型=varchar(10) | 索引=无 | 默认值= text:类型=text | 索引=无 | 默认值= name:类型=varchar(50) | 索引=无 | 默认值= tip:类型=varchar(200) | 索引=无 | 默认值= order_sn:类型=int(11) | 索引=无 | 默认值=0 code:类型=varchar(20) | 索引=无 | 默认值= is_sys:类型=tinyint(3) unsigned | 索引=无 | 默认值=0
lzh_hetong MyISAM id:类型=int(11) | 索引=PRI | 默认值=auto_increment hetong_img:类型=varchar(500) | 索引=无 | 默认值= thumb_hetong_img:类型=varchar(500) | 索引=无 | 默认值= add_time:类型=int(11) | 索引=无 | 默认值= deal_user:类型=varchar(100) | 索引=无 | 默认值= name:类型=varchar(100) | 索引=无 | 默认值= dizhi:类型=varchar(200) | 索引=无 | 默认值= tel:类型=varchar(50) | 索引=无 | 默认值=
lzh_inner_msg MyISAM id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment uid:类型=int(10) unsigned | 索引=无 | 默认值= borrow_id:类型=int(10) unsigned | 索引=无 | 默认值= invest_money:类型=decimal(15,2) unsigned | 索引=无 | 默认值= invest_type:类型=tinyint(3) unsigned | 索引=无 | 默认值= duration:类型=tinyint(3) unsigned | 索引=无 | 默认值= get_credit:类型=float(15,2) unsigned | 索引=无 | 默认值= add_time:类型=int(10) unsigned | 索引=无 | 默认值= add_ip:类型=varchar(16) | 索引=无 | 默认值=
lzh_invest_credit MyISAM id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment uid:类型=int(10) unsigned | 索引=无 | 默认值= borrow_id:类型=int(10) unsigned | 索引=无 | 默认值= invest_money:类型=decimal(15,2) unsigned | 索引=无 | 默认值= invest_type:类型=tinyint(3) unsigned | 索引=无 | 默认值= duration:类型=tinyint(3) unsigned | 索引=无 | 默认值= get_credit:类型=float(15,2) unsigned | 索引=无 | 默认值= add_time:类型=int(10) unsigned | 索引=无 | 默认值= add_ip:类型=varchar(16) | 索引=无 | 默认值=
lzh_invest_detb InnoDB id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment invest_id:类型=int(10) unsigned | 索引=无 | 默认值=0 status:类型=tinyint(1) unsigned | 索引=无 | 默认值=99 sell_uid:类型=int(10) unsigned | 索引=无 | 默认值= transfer_price:类型=decimal(15,2) unsigned | 索引=无 | 默认值=0.00 money:类型=decimal(15,2) unsigned | 索引=无 | 默认值=0.00 period:类型=tinyint(5) unsigned | 索引=无 | 默认值=0 total_period:类型=tinyint(5) unsigned | 索引=无 | 默认值=0 valid:类型=int(10) unsigned | 索引=无 | 默认值=0 remark:类型=text | 索引=无 | 默认值= serialid:类型=varchar(15) | 索引=无 | 默认值= cancel_time:类型=int(10) unsigned | 索引=无 | 默认值= cancel_times:类型=tinyint(1) unsigned | 索引=无 | 默认值=0 buy_uid:类型=int(10) unsigned | 索引=无 | 默认值=0 buy_time:类型=int(10) unsigned | 索引=无 | 默认值=0 addtime:类型=int(10) unsigned | 索引=无 | 默认值=0 ip:类型=char(19) | 索引=无 | 默认值=
lzh_investor_detail InnoDB id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment repayment_time:类型=int(10) unsigned | 索引=无 | 默认值=0 borrow_id:类型=int(10) unsigned | 索引=MUL | 默认值= invest_id:类型=int(10) unsigned | 索引=MUL | 默认值= investor_uid:类型=int(10) unsigned | 索引=无 | 默认值= borrow_uid:类型=int(10) unsigned | 索引=无 | 默认值= capital:类型=decimal(15,2) | 索引=无 | 默认值= interest:类型=decimal(15,2) | 索引=无 | 默认值= interest_fee:类型=decimal(15,2) | 索引=无 | 默认值= status:类型=tinyint(3) unsigned | 索引=无 | 默认值= receive_interest:类型=decimal(15,2) | 索引=无 | 默认值= receive_capital:类型=decimal(15,2) | 索引=无 | 默认值= sort_order:类型=tinyint(3) unsigned | 索引=无 | 默认值= total:类型=tinyint(3) unsigned | 索引=无 | 默认值= deadline:类型=int(10) unsigned | 索引=无 | 默认值= expired_money:类型=decimal(15,2) | 索引=无 | 默认值= expired_days:类型=tinyint(3) unsigned | 索引=无 | 默认值=0 call_fee:类型=decimal(5,2) | 索引=无 | 默认值= substitute_money:类型=decimal(15,2) | 索引=无 | 默认值= substitute_time:类型=int(10) unsigned | 索引=无 | 默认值=0
lzh_jubao MyISAM id:类型=int(11) | 索引=PRI | 默认值=auto_increment uid:类型=int(11) | 索引=无 | 默认值= uemail:类型=varchar(60) | 索引=无 | 默认值= b_uid:类型=int(11) | 索引=无 | 默认值= b_uname:类型=varchar(50) | 索引=无 | 默认值= reason:类型=varchar(100) | 索引=无 | 默认值= text:类型=varchar(500) | 索引=无 | 默认值= add_time:类型=int(10) unsigned | 索引=无 | 默认值= add_ip:类型=varchar(16) | 索引=无 | 默认值=
lzh_kvtable MyISAM id:类型=smallint(5) unsigned | 索引=PRI | 默认值=auto_increment value:类型=varchar(50) | 索引=无 | 默认值= nid:类型=varchar(10) | 索引=MUL | 默认值= sort_order:类型=int(11) | 索引=无 | 默认值= son_count:类型=int(10) unsigned | 索引=无 | 默认值= field_1:类型=int(10) unsigned | 索引=无 | 默认值= field_2:类型=int(10) unsigned | 索引=无 | 默认值= field_3:类型=int(10) unsigned | 索引=无 | 默认值=
lzh_member_address MyISAM id:类型=mediumint(9) unsigned | 索引=PRI | 默认值=auto_increment uid:类型=int(10) unsigned | 索引=MUL | 默认值= name:类型=varchar(10) | 索引=无 | 默认值= main_phone:类型=varchar(20) | 索引=无 | 默认值= secondary_phone:类型=varchar(20) | 索引=无 | 默认值= address:类型=varchar(100) | 索引=无 | 默认值= post_code:类型=varchar(10) | 索引=无 | 默认值= address_type:类型=tinyint(4) | 索引=无 | 默认值=0 province:类型=smallint(5) unsigned | 索引=无 | 默认值= city:类型=smallint(5) unsigned | 索引=无 | 默认值= district:类型=smallint(5) unsigned | 索引=无 | 默认值=
lzh_member_apply MyISAM id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment uid:类型=int(10) unsigned | 索引=MUL | 默认值= add_time:类型=int(10) unsigned | 索引=无 | 默认值= add_ip:类型=varchar(16) | 索引=无 | 默认值= apply_status:类型=tinyint(3) unsigned | 索引=无 | 默认值=0 credit_money:类型=decimal(15,2) | 索引=无 | 默认值= deal_user:类型=int(10) unsigned | 索引=无 | 默认值= deal_time:类型=int(10) unsigned | 索引=无 | 默认值= deal_info:类型=varchar(50) | 索引=无 | 默认值= apply_type:类型=tinyint(3) unsigned | 索引=无 | 默认值= apply_money:类型=decimal(15,2) | 索引=无 | 默认值= apply_info:类型=varchar(200) | 索引=无 | 默认值=
lzh_member_banks MyISAM uid:类型=int(10) unsigned | 索引=PRI | 默认值= bank_num:类型=varchar(50) | 索引=无 | 默认值= bank_province:类型=varchar(20) | 索引=无 | 默认值= bank_city:类型=varchar(20) | 索引=无 | 默认值= bank_address:类型=varchar(100) | 索引=无 | 默认值= bank_name:类型=varchar(50) | 索引=无 | 默认值= add_time:类型=int(10) unsigned | 索引=无 | 默认值= add_ip:类型=varchar(16) | 索引=无 | 默认值=
lzh_member_borrow_show MyISAM id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment uid:类型=int(10) unsigned | 索引=MUL | 默认值= data_url:类型=varchar(100) | 索引=无 | 默认值= data_name:类型=varchar(50) | 索引=无 | 默认值= sort:类型=int(8) unsigned | 索引=无 | 默认值= deal_user:类型=varchar(50) | 索引=无 | 默认值= deal_time:类型=int(10) unsigned | 索引=无 | 默认值=
lzh_member_contact_info MyISAM uid:类型=int(10) unsigned | 索引=PRI | 默认值= address:类型=varchar(200) | 索引=无 | 默认值= tel:类型=varchar(20) | 索引=无 | 默认值= contact1:类型=varchar(50) | 索引=无 | 默认值= contact1_re:类型=varchar(20) | 索引=无 | 默认值= contact1_tel:类型=varchar(50) | 索引=无 | 默认值= contact2:类型=varchar(50) | 索引=无 | 默认值= contact2_re:类型=varchar(20) | 索引=无 | 默认值= contact2_tel:类型=varchar(20) | 索引=无 | 默认值= contact1_other:类型=varchar(100) | 索引=无 | 默认值= contact2_other:类型=varchar(100) | 索引=无 | 默认值= contact3:类型=varchar(40) | 索引=无 | 默认值= contact3_re:类型=varchar(20) | 索引=无 | 默认值= contact3_tel:类型=varchar(100) | 索引=无 | 默认值= contact3_other:类型=varchar(100) | 索引=无 | 默认值=
lzh_member_creditslog InnoDB id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment uid:类型=int(10) unsigned | 索引=MUL | 默认值= type:类型=tinyint(3) unsigned | 索引=无 | 默认值= affect_credits:类型=mediumint(9) | 索引=无 | 默认值= account_credits:类型=mediumint(9) | 索引=无 | 默认值= info:类型=varchar(50) | 索引=无 | 默认值= add_time:类型=int(10) unsigned | 索引=无 | 默认值= add_ip:类型=varchar(16) | 索引=无 | 默认值=
lzh_member_data_info MyISAM id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment uid:类型=int(10) unsigned | 索引=MUL | 默认值= data_url:类型=varchar(100) | 索引=无 | 默认值= type:类型=smallint(5) unsigned | 索引=无 | 默认值= status:类型=tinyint(3) unsigned | 索引=无 | 默认值= add_time:类型=int(10) unsigned | 索引=无 | 默认值= data_name:类型=varchar(50) | 索引=无 | 默认值= size:类型=int(10) unsigned | 索引=无 | 默认值= ext:类型=varchar(10) | 索引=无 | 默认值= deal_info:类型=varchar(40) | 索引=无 | 默认值= deal_credits:类型=smallint(5) unsigned | 索引=无 | 默认值= deal_user:类型=int(11) | 索引=无 | 默认值= deal_time:类型=int(10) unsigned | 索引=无 | 默认值=
lzh_member_department_info MyISAM uid:类型=int(11) | 索引=PRI | 默认值= department_name:类型=varchar(50) | 索引=无 | 默认值= department_tel:类型=varchar(20) | 索引=无 | 默认值= department_address:类型=varchar(200) | 索引=无 | 默认值= department_year:类型=varchar(20) | 索引=无 | 默认值= voucher_name:类型=varchar(20) | 索引=无 | 默认值= voucher_tel:类型=varchar(20) | 索引=无 | 默认值=
lzh_member_ensure_info MyISAM uid:类型=int(11) | 索引=PRI | 默认值= ensuer1_name:类型=varchar(20) | 索引=无 | 默认值= ensuer1_re:类型=varchar(20) | 索引=无 | 默认值= ensuer1_tel:类型=varchar(20) | 索引=无 | 默认值= ensuer2_name:类型=varchar(20) | 索引=无 | 默认值= ensuer2_re:类型=varchar(20) | 索引=无 | 默认值= ensuer2_tel:类型=varchar(20) | 索引=无 | 默认值=
lzh_member_financial_info MyISAM uid:类型=int(10) unsigned | 索引=PRI | 默认值= fin_monthin:类型=varchar(20) | 索引=无 | 默认值= fin_incomedes:类型=varchar(2000) | 索引=无 | 默认值= fin_monthout:类型=varchar(20) | 索引=无 | 默认值= fin_outdes:类型=varchar(2000) | 索引=无 | 默认值= fin_house:类型=varchar(50) | 索引=无 | 默认值= fin_housevalue:类型=varchar(20) | 索引=无 | 默认值= fin_car:类型=varchar(20) | 索引=无 | 默认值= fin_carvalue:类型=varchar(20) | 索引=无 | 默认值= fin_stockcompany:类型=varchar(50) | 索引=无 | 默认值= fin_stockcompanyvalue:类型=varchar(50) | 索引=无 | 默认值= fin_otheremark:类型=varchar(2000) | 索引=无 | 默认值=
lzh_member_friend MyISAM id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment uid:类型=int(10) unsigned | 索引=无 | 默认值= friend_id:类型=int(10) unsigned | 索引=无 | 默认值= apply_status:类型=tinyint(3) unsigned | 索引=无 | 默认值=0 add_time:类型=int(10) | 索引=无 | 默认值=
lzh_member_house_info MyISAM uid:类型=int(11) | 索引=PRI | 默认值= house_dizhi:类型=varchar(200) | 索引=无 | 默认值= house_mianji:类型=float(10,2) | 索引=无 | 默认值= house_nian:类型=varchar(10) | 索引=无 | 默认值= house_gong:类型=varchar(20) | 索引=无 | 默认值= house_suo1:类型=varchar(20) | 索引=无 | 默认值= house_suo2:类型=varchar(20) | 索引=无 | 默认值= house_feng1:类型=float(10,2) | 索引=无 | 默认值= house_feng2:类型=float(10,2) | 索引=无 | 默认值= house_dai:类型=int(11) | 索引=无 | 默认值= house_yuegong:类型=float(10,2) | 索引=无 | 默认值= house_shangxian:类型=float(10,2) | 索引=无 | 默认值= house_anjiebank:类型=varchar(20) | 索引=无 | 默认值=
lzh_member_info MyISAM uid:类型=int(10) unsigned | 索引=PRI | 默认值= sex:类型=varchar(20) | 索引=无 | 默认值= zy:类型=varchar(40) | 索引=无 | 默认值= cell_phone:类型=varchar(11) | 索引=无 | 默认值= info:类型=varchar(500) | 索引=无 | 默认值= marry:类型=varchar(20) | 索引=无 | 默认值= education:类型=varchar(50) | 索引=无 | 默认值= income:类型=varchar(20) | 索引=无 | 默认值= age:类型=int(11) | 索引=无 | 默认值= idcard:类型=varchar(20) | 索引=无 | 默认值= card_img:类型=varchar(200) | 索引=无 | 默认值= real_name:类型=varchar(50) | 索引=无 | 默认值= address:类型=varchar(100) | 索引=无 | 默认值= province:类型=int(11) | 索引=无 | 默认值= province_now:类型=int(11) | 索引=无 | 默认值= city:类型=int(11) | 索引=无 | 默认值= city_now:类型=int(11) | 索引=无 | 默认值= area:类型=int(11) | 索引=无 | 默认值= area_now:类型=int(11) | 索引=无 | 默认值= up_time:类型=int(10) unsigned | 索引=无 | 默认值= card_back_img:类型=varchar(200) | 索引=无 | 默认值=
lzh_member_integrallog MyISAM id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment uid:类型=int(10) unsigned | 索引=MUL | 默认值= type:类型=tinyint(3) unsigned | 索引=无 | 默认值= affect_integral:类型=mediumint(9) | 索引=无 | 默认值= active_integral:类型=mediumint(9) | 索引=无 | 默认值= account_integral:类型=mediumint(9) | 索引=无 | 默认值= info:类型=varchar(50) | 索引=无 | 默认值= add_time:类型=int(10) unsigned | 索引=无 | 默认值= add_ip:类型=varchar(16) | 索引=无 | 默认值=
lzh_member_limitlog InnoDB id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment uid:类型=int(10) unsigned | 索引=MUL | 默认值= type:类型=tinyint(3) unsigned | 索引=无 | 默认值= credit_limit:类型=float(15,2) | 索引=无 | 默认值= borrow_vouch_limit:类型=float(15,2) | 索引=无 | 默认值= invest_vouch_limit:类型=float(15,2) | 索引=无 | 默认值= info:类型=varchar(50) | 索引=无 | 默认值= add_time:类型=int(10) unsigned | 索引=无 | 默认值= add_ip:类型=varchar(16) | 索引=无 | 默认值=
lzh_member_login MyISAM id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment uid:类型=int(10) unsigned | 索引=MUL | 默认值= ip:类型=varchar(15) | 索引=无 | 默认值= add_time:类型=int(10) unsigned | 索引=无 | 默认值=
lzh_member_money InnoDB uid:类型=int(10) unsigned | 索引=PRI | 默认值= money_freeze:类型=decimal(15,2) | 索引=无 | 默认值= money_collect:类型=decimal(15,2) | 索引=无 | 默认值= account_money:类型=decimal(15,2) | 索引=无 | 默认值= back_money:类型=decimal(15,2) | 索引=无 | 默认值= credit_limit:类型=decimal(15,2) | 索引=无 | 默认值= credit_cuse:类型=decimal(15,2) | 索引=无 | 默认值= borrow_vouch_limit:类型=decimal(15,2) | 索引=无 | 默认值= borrow_vouch_cuse:类型=decimal(15,2) | 索引=无 | 默认值= invest_vouch_limit:类型=decimal(15,2) | 索引=无 | 默认值= invest_vouch_cuse:类型=decimal(15,2) | 索引=无 | 默认值=
lzh_member_moneylog InnoDB id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment uid:类型=int(10) unsigned | 索引=MUL | 默认值= type:类型=tinyint(3) unsigned | 索引=无 | 默认值= affect_money:类型=decimal(15,2) | 索引=无 | 默认值= account_money:类型=decimal(15,2) | 索引=无 | 默认值= back_money:类型=decimal(15,2) | 索引=无 | 默认值= collect_money:类型=decimal(15,2) | 索引=无 | 默认值= freeze_money:类型=decimal(15,2) | 索引=无 | 默认值= info:类型=varchar(50) | 索引=无 | 默认值= add_time:类型=int(10) unsigned | 索引=无 | 默认值= add_ip:类型=varchar(16) | 索引=无 | 默认值= target_uid:类型=int(11) | 索引=无 | 默认值=0 target_uname:类型=varchar(20) | 索引=无 | 默认值=
lzh_member_msg MyISAM id:类型=int(11) | 索引=PRI | 默认值=auto_increment from_uid:类型=int(11) | 索引=无 | 默认值= from_uname:类型=varchar(20) | 索引=无 | 默认值= to_uid:类型=int(11) | 索引=无 | 默认值= to_uname:类型=varchar(20) | 索引=无 | 默认值= title:类型=varchar(50) | 索引=无 | 默认值= msg:类型=varchar(2000) | 索引=无 | 默认值= add_time:类型=int(10) unsigned | 索引=无 | 默认值= is_read:类型=tinyint(3) unsigned | 索引=无 | 默认值=0 type:类型=smallint(6) | 索引=无 | 默认值= to_del:类型=tinyint(4) | 索引=无 | 默认值=0 from_del:类型=tinyint(4) | 索引=无 | 默认值=0
lzh_member_payonline InnoDB id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment uid:类型=int(10) unsigned | 索引=MUL | 默认值= nid:类型=char(32) | 索引=无 | 默认值= money:类型=decimal(15,2) | 索引=无 | 默认值= fee:类型=decimal(8,2) | 索引=无 | 默认值= way:类型=varchar(20) | 索引=无 | 默认值= status:类型=tinyint(4) | 索引=无 | 默认值=0 add_time:类型=int(10) unsigned | 索引=无 | 默认值= add_ip:类型=varchar(16) | 索引=无 | 默认值= tran_id:类型=varchar(50) | 索引=无 | 默认值= off_bank:类型=varchar(50) | 索引=无 | 默认值= off_way:类型=varchar(100) | 索引=无 | 默认值= deal_user:类型=varchar(40) | 索引=无 | 默认值= deal_uid:类型=int(11) | 索引=无 | 默认值= payimg:类型=varchar(1000) | 索引=无 | 默认值=
lzh_member_remark MyISAM id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment user_id:类型=int(11) | 索引=无 | 默认值= user_name:类型=varchar(50) | 索引=无 | 默认值= remark:类型=varchar(500) | 索引=无 | 默认值= admin_id:类型=int(11) | 索引=无 | 默认值= admin_real_name:类型=varchar(50) | 索引=无 | 默认值= add_time:类型=int(10) | 索引=无 | 默认值=0
lzh_member_safequestion MyISAM uid:类型=int(10) unsigned | 索引=PRI | 默认值= question1:类型=varchar(100) | 索引=无 | 默认值= answer1:类型=varchar(100) | 索引=无 | 默认值= question2:类型=varchar(100) | 索引=无 | 默认值= answer2:类型=varchar(100) | 索引=无 | 默认值= add_time:类型=int(11) | 索引=无 | 默认值=
lzh_member_withdraw InnoDB id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment uid:类型=int(10) unsigned | 索引=MUL | 默认值= withdraw_money:类型=decimal(15,2) | 索引=无 | 默认值= withdraw_status:类型=tinyint(4) | 索引=无 | 默认值= withdraw_fee:类型=decimal(15,2) | 索引=无 | 默认值= add_time:类型=int(10) unsigned | 索引=无 | 默认值= add_ip:类型=varchar(16) | 索引=无 | 默认值= deal_time:类型=int(10) unsigned | 索引=无 | 默认值= deal_user:类型=varchar(50) | 索引=无 | 默认值= deal_info:类型=varchar(200) | 索引=无 | 默认值= second_fee:类型=decimal(15,2) | 索引=无 | 默认值= success_money:类型=decimal(15,2) | 索引=无 | 默认值=
lzh_members InnoDB id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment user_name:类型=varchar(50) | 索引=MUL | 默认值= user_pass:类型=char(32) | 索引=无 | 默认值= user_type:类型=tinyint(3) unsigned | 索引=无 | 默认值=1 pin_pass:类型=char(32) | 索引=无 | 默认值= user_email:类型=varchar(50) | 索引=MUL | 默认值= user_phone:类型=varchar(11) | 索引=无 | 默认值= reg_time:类型=int(10) unsigned | 索引=无 | 默认值= reg_ip:类型=varchar(15) | 索引=无 | 默认值= user_leve:类型=tinyint(4) | 索引=无 | 默认值=0 time_limit:类型=int(10) unsigned | 索引=无 | 默认值= credits:类型=int(10) | 索引=无 | 默认值= recommend_id:类型=int(10) unsigned | 索引=无 | 默认值=0 customer_id:类型=int(10) unsigned | 索引=无 | 默认值= customer_name:类型=varchar(20) | 索引=无 | 默认值= province:类型=int(10) unsigned | 索引=无 | 默认值= city:类型=int(10) unsigned | 索引=无 | 默认值= area:类型=int(10) unsigned | 索引=无 | 默认值= is_ban:类型=int(11) | 索引=无 | 默认值=0 reward_money:类型=decimal(15,2) | 索引=无 | 默认值= invest_credits:类型=decimal(15,2) unsigned | 索引=无 | 默认值= integral:类型=int(15) | 索引=无 | 默认值= active_integral:类型=int(15) | 索引=无 | 默认值= is_borrow:类型=int(2) | 索引=无 | 默认值=1 is_transfer:类型=int(2) | 索引=无 | 默认值=0 is_vip:类型=tinyint(3) | 索引=无 | 默认值=0 last_log_ip:类型=char(15) | 索引=无 | 默认值= last_log_time:类型=int(10) | 索引=无 | 默认值=0
lzh_members_status InnoDB uid:类型=int(10) unsigned | 索引=PRI | 默认值= phone_status:类型=tinyint(3) unsigned | 索引=无 | 默认值=0 phone_credits:类型=int(10) unsigned | 索引=无 | 默认值=0 id_status:类型=tinyint(3) unsigned | 索引=无 | 默认值=0 id_credits:类型=int(10) unsigned | 索引=无 | 默认值=0 face_status:类型=tinyint(4) | 索引=无 | 默认值=0 face_credits:类型=int(10) unsigned | 索引=无 | 默认值=0 email_status:类型=tinyint(3) unsigned | 索引=无 | 默认值=0 email_credits:类型=int(10) unsigned | 索引=无 | 默认值=0 account_status:类型=tinyint(3) unsigned | 索引=无 | 默认值=0 account_credits:类型=int(10) unsigned | 索引=无 | 默认值=0 credit_status:类型=tinyint(4) | 索引=无 | 默认值=0 credit_credits:类型=int(10) unsigned | 索引=无 | 默认值=0 safequestion_status:类型=tinyint(3) unsigned | 索引=无 | 默认值=0 safequestion_credits:类型=int(10) unsigned | 索引=无 | 默认值=0 video_status:类型=tinyint(4) | 索引=无 | 默认值=0 video_credits:类型=int(10) unsigned | 索引=无 | 默认值=0 vip_status:类型=tinyint(1) unsigned | 索引=无 | 默认值=0 vip_credits:类型=int(10) unsigned | 索引=无 | 默认值=0
lzh_name_apply MyISAM id:类型=int(11) | 索引=PRI | 默认值=auto_increment uid:类型=int(10) unsigned | 索引=无 | 默认值= up_time:类型=int(10) | 索引=无 | 默认值= status:类型=tinyint(3) unsigned | 索引=无 | 默认值= idcard:类型=varchar(20) | 索引=无 | 默认值= deal_info:类型=varchar(80) | 索引=无 | 默认值=
lzh_navigation MyISAM id:类型=smallint(6) | 索引=PRI | 默认值=auto_increment type_name:类型=varchar(40) | 索引=无 | 默认值= type_url:类型=varchar(200) | 索引=无 | 默认值= type_keyword:类型=varchar(200) | 索引=无 | 默认值= type_info:类型=varchar(400) | 索引=无 | 默认值= type_content:类型=text | 索引=无 | 默认值= sort_order:类型=int(11) | 索引=无 | 默认值= type_set:类型=tinyint(1) | 索引=无 | 默认值=0 parent_id:类型=smallint(6) | 索引=无 | 默认值= type_nid:类型=varchar(50) | 索引=无 | 默认值= is_hiden:类型=int(1) unsigned | 索引=无 | 默认值=0 add_time:类型=int(10) unsigned | 索引=无 | 默认值= is_sys:类型=tinyint(3) unsigned | 索引=无 | 默认值= model:类型=char(30) | 索引=无 | 默认值=
lzh_oauth MyISAM id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment is_bind:类型=tinyint(30) | 索引=MUL | 默认值=0 site:类型=varchar(30) | 索引=MUL | 默认值= openid:类型=varchar(255) | 索引=无 | 默认值= nickname:类型=varchar(255) | 索引=无 | 默认值= avatar:类型=varchar(255) | 索引=无 | 默认值= url:类型=varchar(255) | 索引=无 | 默认值= logintimes:类型=int(10) unsigned | 索引=无 | 默认值=0 logintime:类型=int(10) unsigned | 索引=无 | 默认值=0 bind_uid:类型=int(10) | 索引=无 | 默认值=0 addtime:类型=int(10) unsigned | 索引=无 | 默认值=0
lzh_qq InnoDB id:类型=int(11) | 索引=PRI | 默认值=auto_increment qq_num:类型=varchar(50) | 索引=无 | 默认值= qq_title:类型=varchar(100) | 索引=无 | 默认值= qq_order:类型=int(2) | 索引=无 | 默认值= is_show:类型=int(1) | 索引=无 | 默认值=1 type:类型=int(1) | 索引=无 | 默认值=
lzh_smslog MyISAM id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment admin_id:类型=int(11) | 索引=无 | 默认值= admin_real_name:类型=varchar(50) | 索引=无 | 默认值= user_name:类型=varchar(50) | 索引=无 | 默认值= user_email:类型=varchar(50) | 索引=无 | 默认值= user_phone:类型=varchar(50) | 索引=无 | 默认值= title:类型=varchar(20) | 索引=无 | 默认值= content:类型=varchar(500) | 索引=无 | 默认值= add_time:类型=int(10) | 索引=无 | 默认值=0
lzh_sys_tip MyISAM uid:类型=int(10) unsigned | 索引=PRI | 默认值= tipset:类型=varchar(300) | 索引=MUL | 默认值=
lzh_today_reward MyISAM id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment borrow_id:类型=int(10) unsigned | 索引=无 | 默认值= reward_uid:类型=int(10) unsigned | 索引=无 | 默认值= invest_money:类型=decimal(15,2) unsigned | 索引=无 | 默认值= reward_money:类型=decimal(10,2) unsigned | 索引=无 | 默认值= reward_status:类型=tinyint(3) unsigned | 索引=无 | 默认值=0 add_time:类型=int(10) | 索引=无 | 默认值= deal_time:类型=int(10) | 索引=无 | 默认值= add_ip:类型=varchar(20) | 索引=无 | 默认值=
lzh_transfer_borrow_info InnoDB id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment borrow_name:类型=varchar(50) | 索引=无 | 默认值= borrow_uid:类型=int(11) | 索引=MUL | 默认值= borrow_duration:类型=tinyint(3) unsigned | 索引=无 | 默认值= borrow_money:类型=decimal(15,2) | 索引=无 | 默认值= borrow_interest:类型=decimal(15,2) | 索引=无 | 默认值= borrow_interest_rate:类型=decimal(5,2) | 索引=无 | 默认值= repayment_money:类型=decimal(15,2) | 索引=无 | 默认值= repayment_interest:类型=decimal(15,2) | 索引=无 | 默认值= repayment_type:类型=tinyint(3) unsigned | 索引=无 | 默认值= borrow_status:类型=tinyint(3) unsigned | 索引=无 | 默认值= transfer_out:类型=int(10) | 索引=无 | 默认值= transfer_back:类型=int(10) unsigned | 索引=无 | 默认值= transfer_total:类型=int(10) | 索引=无 | 默认值= per_transfer:类型=int(10) | 索引=无 | 默认值= add_time:类型=int(10) | 索引=无 | 默认值= deadline:类型=int(10) unsigned | 索引=无 | 默认值= add_ip:类型=varchar(16) | 索引=无 | 默认值= deal_user:类型=int(10) unsigned | 索引=无 | 默认值= deal_time:类型=int(10) unsigned | 索引=无 | 默认值= deal_info:类型=varchar(500) | 索引=无 | 默认值= borrow_info:类型=varchar(2000) | 索引=无 | 默认值= ensure_department:类型=varchar(10) | 索引=无 | 默认值= updata:类型=varchar(2000) | 索引=无 | 默认值= progress:类型=tinyint(3) unsigned | 索引=无 | 默认值= total:类型=tinyint(4) | 索引=无 | 默认值= is_show:类型=tinyint(4) | 索引=MUL | 默认值=1 min_month:类型=tinyint(4) | 索引=无 | 默认值=0 reward_rate:类型=float(5,2) | 索引=无 | 默认值=0.00 increase_rate:类型=float(5,2) | 索引=无 | 默认值=0.00 borrow_fee:类型=decimal(15,2) | 索引=无 | 默认值= level_can:类型=tinyint(3) | 索引=无 | 默认值=0 borrow_min:类型=int(11) | 索引=无 | 默认值= borrow_max:类型=int(11) | 索引=无 | 默认值= danbao:类型=decimal(15,2) | 索引=无 | 默认值= is_tuijian:类型=tinyint(3) | 索引=无 | 默认值=0 borrow_type:类型=int(11) | 索引=无 | 默认值=6 b_img:类型=varchar(200) | 索引=无 | 默认值= collect_day:类型=int(10) | 索引=无 | 默认值= is_auto:类型=tinyint(3) | 索引=无 | 默认值=0
lzh_transfer_borrow_info_lock InnoDB id:类型=int(10) | 索引=PRI | 默认值=auto_increment suo:类型=int(10) | 索引=无 | 默认值=
lzh_transfer_borrow_investor InnoDB id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment status:类型=tinyint(3) unsigned | 索引=无 | 默认值=0 borrow_id:类型=int(10) unsigned | 索引=MUL | 默认值= investor_uid:类型=int(10) unsigned | 索引=MUL | 默认值= borrow_uid:类型=int(11) | 索引=无 | 默认值= investor_capital:类型=decimal(15,2) | 索引=无 | 默认值= investor_interest:类型=decimal(15,2) | 索引=无 | 默认值= invest_fee:类型=decimal(15,2) | 索引=无 | 默认值= receive_capital:类型=decimal(15,2) | 索引=无 | 默认值= receive_interest:类型=decimal(15,2) | 索引=无 | 默认值= add_time:类型=int(10) unsigned | 索引=无 | 默认值= deadline:类型=int(10) unsigned | 索引=MUL | 默认值= is_auto:类型=tinyint(3) unsigned | 索引=无 | 默认值=0 reward_money:类型=decimal(15,2) | 索引=无 | 默认值= transfer_num:类型=int(10) unsigned | 索引=无 | 默认值=0 transfer_month:类型=int(10) unsigned | 索引=无 | 默认值=0 back_time:类型=int(10) unsigned | 索引=无 | 默认值= final_interest_rate:类型=float(5,2) | 索引=无 | 默认值=0.00
lzh_transfer_detail MyISAM borrow_id:类型=int(10) unsigned | 索引=PRI | 默认值= borrow_breif:类型=varchar(2000) | 索引=无 | 默认值= borrow_capital:类型=varchar(2000) | 索引=无 | 默认值= borrow_use:类型=varchar(2000) | 索引=无 | 默认值= borrow_risk:类型=varchar(2000) | 索引=无 | 默认值= borrow_guarantee:类型=varchar(50) | 索引=无 | 默认值= borrow_img:类型=varchar(2000) | 索引=无 | 默认值=
lzh_transfer_investor_detail InnoDB id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment repayment_time:类型=int(10) unsigned | 索引=无 | 默认值=0 borrow_id:类型=int(10) unsigned | 索引=MUL | 默认值= invest_id:类型=int(10) unsigned | 索引=MUL | 默认值= investor_uid:类型=int(10) unsigned | 索引=无 | 默认值= borrow_uid:类型=int(10) unsigned | 索引=无 | 默认值= capital:类型=decimal(15,2) | 索引=无 | 默认值= interest:类型=decimal(15,2) | 索引=无 | 默认值= interest_fee:类型=decimal(15,2) | 索引=无 | 默认值= status:类型=tinyint(3) unsigned | 索引=无 | 默认值= receive_interest:类型=decimal(15,2) | 索引=无 | 默认值= receive_capital:类型=decimal(15,2) | 索引=无 | 默认值= sort_order:类型=tinyint(3) unsigned | 索引=无 | 默认值= total:类型=tinyint(3) unsigned | 索引=无 | 默认值= deadline:类型=int(10) unsigned | 索引=无 | 默认值= expired_money:类型=decimal(15,2) | 索引=无 | 默认值= expired_days:类型=tinyint(3) unsigned | 索引=无 | 默认值=0 call_fee:类型=decimal(5,2) | 索引=无 | 默认值= substitute_money:类型=decimal(15,2) | 索引=无 | 默认值= substitute_time:类型=int(10) unsigned | 索引=无 | 默认值=0
lzh_verify MyISAM id:类型=int(11) | 索引=PRI | 默认值=auto_increment code:类型=varchar(32) | 索引=无 | 默认值= send_time:类型=int(10) | 索引=无 | 默认值= ukey:类型=int(10) unsigned | 索引=MUL | 默认值= type:类型=tinyint(3) unsigned | 索引=无 | 默认值=
lzh_video_apply MyISAM id:类型=int(10) unsigned | 索引=PRI | 默认值=auto_increment uid:类型=int(10) unsigned | 索引=MUL | 默认值= add_time:类型=int(10) unsigned | 索引=无 | 默认值= add_ip:类型=varchar(16) | 索引=无 | 默认值= apply_status:类型=tinyint(3) unsigned | 索引=无 | 默认值=0 credits:类型=int(11) | 索引=无 | 默认值=0 deal_user:类型=int(10) unsigned | 索引=无 | 默认值= deal_time:类型=int(10) unsigned | 索引=无 | 默认值= deal_info:类型=varchar(50) | 索引=无 | 默认值=
lzh_vip_apply MyISAM id:类型=int(11) | 索引=PRI | 默认值=auto_increment uid:类型=int(10) unsigned | 索引=无 | 默认值= kfid:类型=int(10) unsigned | 索引=无 | 默认值= province_now:类型=int(10) unsigned | 索引=无 | 默认值= city_now:类型=int(11) | 索引=无 | 默认值= area_now:类型=int(11) | 索引=无 | 默认值= des:类型=varchar(1000) | 索引=无 | 默认值= add_time:类型=int(10) | 索引=无 | 默认值= status:类型=tinyint(3) unsigned | 索引=无 | 默认值= deal_time:类型=int(10) unsigned | 索引=无 | 默认值= deal_user:类型=int(10) unsigned | 索引=无 | 默认值= deal_info:类型=varchar(200) | 索引=无 | 默认值=


说明:InnoDB和MyISAM的差别:InnoDB和MyISAM是在使用MySQL最常用的两个表类型,各有优缺点,视具体应用而定。基本的差别为:MyISAM类型不支持事务处理等高级处理,而InnoDB类型支持。MyISAM类型的表强调的是性能,其执行数度比InnoDB类型更快,但是不提供事务支持,而InnoDB提供事务支持已经外部键等高级数据库功能。

p2p网贷系统开发用到的数据表有很多个字段,可以用Excel制作,类似下图,不同工作表表示不同数据表,每个数据表里为该表内数据字段:

接下来根据excel里设计好的网贷系统数据字典,通过数据字典生成工具批量生成为SQL代码,操作如下:

设置好p2p网贷平台数据库字典操作,并运行,如下图。

得到网贷系统SQL代码,执行sql代码即可生成整套p2p网贷系统开发用的数据库表和字段,数据库诞生。

P2P网贷系统开发任务进度分配甘特图

P2P平台是新兴互联网金融一份子,P2P网贷平台制作开发过程不亚于银行级金融系统开发难度。每一步架构设计均为日后的平台安全平稳运行做好铺垫。

标签: p2p网贷系统