数据库结构

auth_id

store_id

group_buy_goods

rec_idgroup_idgoods_idgoods_number

store_money_lock

store_idstatus

bank_card

bank_card_idstore_iduser_idcard_numberprovicecitybank_areabank_namebranch_nameadd_timeupdate_time

attr_id

goods_attr_id

user_id

goods_id

queue

id num people is_active is_send is_info store_id user_id add_time update_time

recharge

idstore_idrecharge_moneyface_moneyadd_timeis_deleteremarkpic

attr_values

idstore_idattr_idattr_value

recharge_order

idstore_iduser_idrecharge_idorder_snrecharge_moneyface_moneyadd_timestatus

activity

activity_idactivity_titleactivity_imgstore_idadd_timeend_time

order_id

integral_log

log_iduser_idpay_pointslog_typechange_descchange_timetrade_nozg_log_id

crowd_funding

crowd_iduser_idcrowd_titlestore_idparticipant_totalparticipant_numbercrowd_goodscrowd_statusstart_timeend_timeadd_timeshare_timedinner_timecrowd_moneys

ovl_kc_online

idstore_idlast_acf_timeis_onlinenametypemacipport

crowd_id

user_money

user_money_iduser_idstore_iduser_moneyfrozen_moneyadd_timeupdate_time

goods_attr

idgoods_idattr_idattr_valueattr_price

order_sn

group_id

crowd_goods

category

cat_idcat_namestore_idadd_timeupdate_time

wx_order

wx_order_idorder_snstore_idwx_order_snwx_order_amountwx_receivable_amountwx_statusstart_dateend_dateadd_time

ausers

auth_idstore_idusernamepasswordgroup_idreal_namesort_orderlast_log_timelast_log_ipis_banqqphonesaltuser_wordphotosexcardemailaddresscontentparentadd_timeis_del

wx_payment

pay_idorder_snstore_idwx_order_sntransaction_idpayadd_timedateis_payoffadd_timestatuslast_update_time

cat_id

money_log

mlog_iduser_idval_idaffect_moneytypeorder_sntransaction_idadd_timestatusinfo

goods_type

type_idtype_name

withdrawals

withdrawals_idauth_idstore_idmoneyremarkadmin_remarkbank_numbertypestatusadd_time

code

idstore_idcodecreate_atexpires_inis_usedis_success

printer

printer_iddescriptionprinter_ipprinter_portstore_idcountlast_timeprinter_typeis_list

desk

desk_iddesk_numberdesk_descdesk_statusarea_idmax_peopledesk_feestore_idadd_timeupdate_time

vouchers

voucher_idstore_idvouchers_snis_saledvouchers_moneyadd_timeuse_time

group_buy

group_idgroup_namegroup_goods_namegroup_priceoriginal_pricestore_idadd_timeupdate_time

area_id

products

product_idgoods_idgoods_attr_idproduct_number

admin

admin_iduser_namereal_nameroleauth_keypassword_hashpassword_reset_tokenemailstatusadd_timeupdate_time

store_money

store_money_idstore_idstore_moneyfrozen_moneywxfrozen_7day_moneyadd_time

recharge_log

rcg_idstore_idauth_iduser_idrecharge_moneyface_moneyadd_timestatusremark

order

order_idorder_snextra_iduser_idauth_idorder_statusoperate_typepay_statusprint_statuspaymentstore_iddeskpeopleorder_amountreceivable_totalbalancepos_cardcashpennyfeeorder_typeis_clearorder_sourcepay_sourcevouchersrebategive_group_numberadd_timeready_timepay_time

type_id

recharge_id

store

store_idseller_idstore_nameaddressteladd_timeupdate_timelogoopen_timeclose_timebannerauto_rebaterb_settingfeefee_startfee_endrate

comments

comment_idcomment_typeid_valueuser_iduser_nameuser_facecontentreply_idadd_time

order_goods

rec_idorder_idgoods_idgoods_numbergroup_idis_printis_giving

balance_log

idorder_snuser_idstore_idpaystatusremarksadd_time

finance

finance_idstore_idorder_amountorder_sumwx_amountwx_sumpad_amountpad_sumreceivable_totalcashpos_cardbalancebalance_sumpennypeopleper_capitadateadd_timeis_print

crowd_participant

participant_iduser_idcrowd_idpay_amountparticipant_nameparticipant_faceadd_time

desk_area

idstore_idarea_name

ovl_ks_online

idstore_idlast_acf_timeis_onlinename

user

user_iduser_namenick_namepassworduser_faceemailopenidunionidseller_idstore_idrecommmender_idsexbirthdayuser_moneypay_pointsrank_pointsaddress_iduser_ranksaltreg_timeqqlandlinemobile_phoneis_validatedterminal_idrec_user_idid_noaccount_number

attribute

attr_idstore_idattr_name

wx_payee

idstore_idopenidopenid_statusnick_namereal_namephonephone_statusemailemail_statusadd_time

shift

shift_idstore_idauth_idoperator_idshift_amountshift_wxpayshift_posshift_cashlast_shift_timeshift_timeremarkorder_sourceis_printbalance

goods

goods_idcat_idgoods_sngoods_name goods_priceprinter_idstore_idis_havingis_heatis_necessaryis_fitis_discountis_avoidis_printgoods_thumbadd_timeupdate_time