数据库结构
2018-03-22 13:47:18 0 举报
web点餐系统数据表简单设计
作者其他创作
大纲/内容
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
0 条评论
下一页