欢迎来到WSTMall官网  社区O2O开源多用户商城  客服热线:020-85289921
开源版
授权版
数据表组
1   accreds
2   addons
3   ads
4   ad_positions
5   areas
6   articles
7   article_cats
8   attributes
9   banks
10   brands
11   businesses
12   carts
13   cash_configs
14   cash_draws
15   cat_brands
16   cat_shops
17   channels
18   charge_items
19   coupons
20   coupon_cats
21   coupon_goods
22   coupon_users
23   crons
24   datas
25   data_cats
26   distributors
27   express
28   favorites
29   finds
30   find_cats
31   find_goods
32   friendlinks
33   goods
34   goods_appraises
35   goods_attributes
36   goods_cats
37   goods_scores
38   goods_specs
39   goods_virtuals
40   home_menus
41   hooks
42   images
43   informs
44   invoices
45   log_moneys
46   log_operates
47   log_orders
48   log_pays
49   log_pay_params
50   log_sms
51   log_staff_logins
52   log_user_logins
53   menus
54   messages
55   message_queues
56   mobile_btns
57   navs
58   orderids
59   orders
60   order_complains
61   order_goods
62   order_refunds
63   payments
64   privileges
65   rewards
66   reward_favourables
67   reward_goods
68   roles
69   settlements
70   shops
71   shop_accreds
72   shop_cats
73   shop_configs
74   shop_extras
75   shop_message_cats
76   shop_roles
77   shop_scores
78   shop_users
79   spec_cats
80   spec_items
81   staffs
82   styles
83   switchs
84   sys_configs
85   template_msgs
86   third_users
87   users
88   user_address
89   user_ranks
90   user_scores
91   weapp_session
(wst_shops)
字段名称 字段说明 字段描述 类型 长度 默认 必填
shopId int 11
1 shopLoginName varchar 255 50
2 shopSn varchar 20
3 channelId int 11 0
4 userId int 11
5 areaIdPath varchar 255
6 areaId int 11 0
7 isSelf tinyint 4 0
8 shopName varchar 100
9 shopkeeper varchar 50
10 telephone varchar 20
11 shopCompany varchar 255
12 shopImg varchar 150
13 shopTel varchar 40
14 shopQQ varchar 50
15 shopWangWang varchar 50
16 shopAddress varchar 255
17 bankId int 11 0
18 bankNo varchar 20
19 bankUserName varchar 50
20 isInvoice tinyint 4 0
21 invoiceRemarks varchar 255
22 serviceStartTime time 08:30:00
23 serviceEndTime time 22:30:00
24 freight int 11 0
25 shopAtive tinyint 4 1
26 shopStatus tinyint 4 1
27 statusDesc varchar 255
28 dataFlag tinyint 4 1
29 createTime date
30 shopMoney decimal 11,2 0.00
31 lockMoney decimal 11,2 0.00
32 noSettledOrderNum int 11 0
33 noSettledOrderFee decimal 11,2 0.00
34 paymentMoney decimal 11,2 0.00
35 bankAreaId int 11 0
36 bankAreaIdPath varchar 100
37 applyStatus tinyint 4 0
38 applyDesc varchar 255
39 applyTime datetime
40 applyStep tinyint 4 1
41 shopNotice varchar 300
42 rechargeMoney decimal 11,2 0.00
43 longitude varchar 100
44 latitude varchar 100
45 mapLevel int 11 13
46 businessId int 11 0
47 isNew tinyint 4 0
48 isRecom tinyint 4 0
49 distributionFees text
50 distributionRadius int 11 0
51 distributionAvgTime int 11 30
52 avgeCostMoney int 11 0
53 deliveryStartMoney int 11 0
54 businessDesc varchar 100
55 isSelfPick tinyint 4 0
56 applyStaffId int 11 0