第一秒EPopup商城库表详细设计

popup_prop_key

id bigint primary keyname varcharpriority int

category_id

popup_order_good_rel

id bigint primary keysum intprice intremarks varcharpay_type intpay_status intinvoice_status intgoods_props varchar json

order_idgoods_id

popup_pay_config

id bigint primary keyicon_url varcharname varcharconfig varchar jsontype intopen int

wechat_id

popup_good

id bigint primary keyname varcharprice intcount intdesc varchartype intgood_no

wechat_idcategory_id

popup_constant

popup bigint primary key

popup_user_address

id bigint primary keyreceier_name varcharreceiver_phone intprivince_id intcity_id intarea_id intdesc varcharstatus int

member_id

country_area

id bigint primary keycode varcharname_zh varcharname_en varcharpid int

Popup Store Table v1.0Author: Owen JiaDate: 2017-05-31

popup_prop

id bigint primary keyname varcharprice intcount intpriority int

prop_key_idwechat_id

popup_user_good_rel

sum

member_idgood_prop_rel_id

member

id int

...

popup_order

id bigint primary keyaddress varchar jsoninvoice_open intinvoice_addres varchar jsoninvoice_type intinvoice_title varcharinvoice_info varchargift_content varcharmsm_notify intmsm_phone intdelivery_type intdelivery_date datetime

member_idgood_prop_id

wechat

popup_good_prop_rel

id bigint primary key

good_idprop_idwechat_id

popup_category

id bigint primary keyparent_id bigintname varchar

popup_config

id bigint primary keytype intval varchar

popup_pay_log

id bigint primary keystatus intdata_info varchar jsonpay_type int

order_idmember_idwechat_id

全局生成id表从1开始，每次自增1