1.出售表转化 esf_chushou => chushou roomID => id loupan => wuye loupan_id=> wuyeid lat=> lng=> zibianhao => zibianhao 没变 leibie_id=> xingzhi_id=> zhuangxiu_id=> shebie_id=> quyu_id=> bankuan_id=>bk_id road / road_id / dizhi_long / dizhi_zhilong / dizhi_hao => 由dizhi进行拆分 fangshu=> tingshui=> weishu=> jianzhu => mianji zongjia=> zongjia_range=> 未知 junjia=> jiage maidian=> title gongsi_id=> zjID dept_id=> 新增 dianmian_id => 新增 user_id => uid image_id => 新增  必须从房源或者楼盘库中取得 image_num => xgt_num add_time => addtime 需要把原来时间格式转化成数据格式 last_update => updatetime 需要把原来时间格式转化成数据格式 today_update => update_num today => fabu state => roomIndexed tuijian => choice louceng => 2.出租表转化同上出售表转化 esf_chuzu => chuzu 3.中介表转化 jjr_gongsi => zhongjie 基本上新的表只存些简单的中介信息,原来zhongjie的有效会员转到新的经纪人端口。 companyID =>zjID username =>zj_yonghuming password =>zj_mima company_name =>zj_quancheng company_address =>zj_dizhi company_tel =>zj_dianhua up => 此字段作用于继承中介,分级 leixin_id => 级别 state => inuse 是否审核 time => zj_regdate 注册时间:需要把原来时间格式转化成数字可式 quyu_id => 4.纪经人表 jjr_info => jjr_user_info user_id =>uid quyu_id => gongsi_id =>cp_id dept_id => 新增 dianmian_id => 新增 truename => name domain => domain_name sex => shenfenzheng =>sfz_num birthday =>新增,,生日 按具体某天 转化成数据格式。 tel => cell =>shouji chushou_max =>jjr_chushou chushou_num =>jjr_chushou_yifa chushou_tuijian_max => marrow_num chushou_tuijian_num => 新增,原来直接计算得到 chushou_starttime =>hetong_start 原来出售和出租是同一个 chushou_endtime =>hetong_end 原来出售和出租是同一个 chushou_kmax =>新增 可发布出售库 chushou_knum =>新增 已发布出售房源 chuzu_max =>jjr_chuzu chuzu_tuijian_max => marrow_num chuzu_tuijian_num => 新增,原来直接程序计算 chuzu_starttime =>hetong_start 原来出售和出租是同一个 chuzu_endtime =>hetong_end 原来出售和出租是同一个 chuzu_kmax =>新增 出租库 chuzu_knum =>新增 已发布出租房源 time =>addtime 把原来的时间格式转化成数字格式 jjr_state =>inuse 是否审核