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
