小银袋类图

member

id:varchar 36account:varchar 64mobile:varchar 15email:varchar 64pwd:varchar 64pay_pwd：varchar 64salt:varchar 10id_card:varchar 20nick_name:varchar 20real_name:varchar 20birth_place:varchar 30birthday:datetimesex:int 2marry_status:int 2tel:varchar 20fax:varchar 20level:int 4grant:is_mobile_valid:int 2is_email_valid:int 2is_id_valid:int 2status:int 2qq:varchar 20wechat:varchar 50weibo:varchar 250msn:varchar 64img:varchar 250create_time:timestamp CURRENT_TIMESTAMPupdate_time:datetimelast_login_time:datetimeconstellation:varchar 10blood_type:varchar 10address:varchar 250address_code:varchar 50salary_level:int 2job_type:int 2source_id:varchar 30remark:varchar 250

insert();update();select();selectList();del();selectCount();

bankinfo

id:varchar 36bank_name:varchar 50bank_id:varchar 10card_name:varchar 30card_class:varchar 10card_length:int 4card_img:varchar 250create_time:datetimebank_code:varchar 20remark:varchar 250

address

id：varchar 36 member_id：varchar 36receive_name:varchar 20mobile: varchar 25tel: varchar 25address:varchar 250post_code: varchar 10create_time: timestamp CURRENT_TIMESTAMPupdate_time:datetime id_default: int 2remark: varchar 250

trading

id:varchar 36member_id:varchar 36status:int 2create_tiem:datetimeproduct_id:varchar 36current_price:bigint 20real_price:int 11num:int 11favour_price：int 11sum_price:bigint 20remark:varchar 250

member_bank

id:varchar 36member_id:varchar 36bank_name:varchar 50card_number:varchar 20pay_pwd:varchar 64status:int 2owner:varchar 20create_time:datetimeremark:varchar 250

getter();setter();

product

id:varchar 36

silver_bag

id:varchar 36member_id:varchar 36