-
Notifications
You must be signed in to change notification settings - Fork 0
/
gmall_study.sql
4486 lines (4423 loc) · 426 KB
/
gmall_study.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
/*
Navicat Premium Data Transfer
Source Server : 108
Source Server Type : MySQL
Source Server Version : 80019
Source Host : 192.168.1.108:3306
Source Schema : gmall_study
Target Server Type : MySQL
Target Server Version : 80019
File Encoding : 65001
Date: 30/01/2020 21:14:11
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for oms_cart_item
-- ----------------------------
DROP TABLE IF EXISTS `oms_cart_item`;
CREATE TABLE `oms_cart_item` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`product_id` bigint(20) NULL DEFAULT NULL,
`product_sku_id` bigint(20) NULL DEFAULT NULL,
`member_id` bigint(20) NULL DEFAULT NULL,
`quantity` int(11) NULL DEFAULT NULL COMMENT '购买数量',
`price` decimal(10, 2) NULL DEFAULT NULL COMMENT '添加到购物车的价格',
`sp1` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销售属性1',
`sp2` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销售属性2',
`sp3` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销售属性3',
`product_pic` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品主图',
`product_name` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品名称',
`product_sub_title` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品副标题（卖点）',
`product_sku_code` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品sku条码',
`member_nickname` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '会员昵称',
`create_date` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`modify_date` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
`delete_status` int(1) NULL DEFAULT 0 COMMENT '是否删除',
`product_category_id` bigint(20) NULL DEFAULT NULL COMMENT '商品分类',
`product_brand` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`product_sn` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`product_attr` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品销售属性:[{\"key\":\"颜色\",\"value\":\"颜色\"},{\"key\":\"容量\",\"value\":\"4G\"}]',
`is_checked` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '购物车表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of oms_cart_item
-- ----------------------------
INSERT INTO `oms_cart_item` VALUES (21, 67, 110, 1, 19, 6699.00, NULL, NULL, NULL, 'http://192.168.1.108/group1/M00/00/00/wKgJbF3nE92AYB5gAAAo7Ah4vxY260.jpg', '荣耀20S 李现同款 3200万人像超级夜景 4800万超广角AI三摄 麒麟810 全网通版6GB+128GB 蝶羽白', NULL, NULL, NULL, '2019-12-13 10:28:52', '2019-12-13 10:28:52', 0, 61, NULL, NULL, NULL, '0');
INSERT INTO `oms_cart_item` VALUES (22, 67, 109, 1, 1, 6688.00, NULL, NULL, NULL, 'http://192.168.1.108/group1/M00/00/00/wKgJbF3nE8aAB23zAAAtnRR4fGE178.jpg', '华为 HUAWEI Mate 30 Pro 5G 麒麟990 环幕屏双4000万徕卡电影四摄8GB', NULL, NULL, NULL, '2019-12-13 17:05:29', '2019-12-13 17:05:29', 0, 61, NULL, NULL, NULL, '1');
-- ----------------------------
-- Table structure for oms_company_address
-- ----------------------------
DROP TABLE IF EXISTS `oms_company_address`;
CREATE TABLE `oms_company_address` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`address_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址名称',
`send_status` int(1) NULL DEFAULT NULL COMMENT '默认发货地址：0->否；1->是',
`receive_status` int(1) NULL DEFAULT NULL COMMENT '是否默认收货地址：0->否；1->是',
`name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收发货人姓名',
`phone` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收货人电话',
`province` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '省/直辖市',
`city` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '市',
`region` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区',
`detail_address` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '详细地址',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '公司收发货地址表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of oms_company_address
-- ----------------------------
INSERT INTO `oms_company_address` VALUES (1, '深圳发货点', 1, 1, '大梨', '18000000000', '广东省', '深圳市', '南山区', '科兴科学园');
INSERT INTO `oms_company_address` VALUES (2, '北京发货点', 0, 0, '大梨', '18000000000', '北京市', NULL, '南山区', '科兴科学园');
INSERT INTO `oms_company_address` VALUES (3, '南京发货点', 0, 0, '大梨', '18000000000', '江苏省', '南京市', '南山区', '科兴科学园');
-- ----------------------------
-- Table structure for oms_order
-- ----------------------------
DROP TABLE IF EXISTS `oms_order`;
CREATE TABLE `oms_order` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '订单id',
`member_id` bigint(20) NOT NULL,
`coupon_id` bigint(20) NULL DEFAULT NULL,
`order_sn` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单编号',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '提交时间',
`member_username` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户帐号',
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '订单总金额',
`pay_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '应付金额（实际支付金额）',
`freight_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '运费金额',
`promotion_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '促销优化金额（促销价、满减、阶梯价）',
`integration_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '积分抵扣金额',
`coupon_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '优惠券抵扣金额',
`discount_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '管理员后台调整订单使用的折扣金额',
`pay_type` int(1) NULL DEFAULT NULL COMMENT '支付方式：0->未支付；1->支付宝；2->微信',
`source_type` int(1) NULL DEFAULT NULL COMMENT '订单来源：0->PC订单；1->app订单',
`status` int(1) NULL DEFAULT NULL COMMENT '订单状态：0->待付款；1->待发货；2->已发货；3->已完成；4->已关闭；5->无效订单',
`order_type` int(1) NULL DEFAULT NULL COMMENT '订单类型：0->正常订单；1->秒杀订单',
`delivery_company` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '物流公司(配送方式)',
`delivery_sn` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '物流单号',
`auto_confirm_day` int(11) NULL DEFAULT NULL COMMENT '自动确认时间（天）',
`integration` int(11) NULL DEFAULT NULL COMMENT '可以获得的积分',
`growth` int(11) NULL DEFAULT NULL COMMENT '可以活动的成长值',
`promotion_info` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '活动信息',
`bill_type` int(1) NULL DEFAULT NULL COMMENT '发票类型：0->不开发票；1->电子发票；2->纸质发票',
`bill_header` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票抬头',
`bill_content` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发票内容',
`bill_receiver_phone` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收票人电话',
`bill_receiver_email` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收票人邮箱',
`receiver_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '收货人姓名',
`receiver_phone` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '收货人电话',
`receiver_post_code` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '收货人邮编',
`receiver_province` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '省份/直辖市',
`receiver_city` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '城市',
`receiver_region` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区',
`receiver_detail_address` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '详细地址',
`note` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单备注',
`confirm_status` int(1) NULL DEFAULT NULL COMMENT '确认收货状态：0->未确认；1->已确认',
`delete_status` int(1) NOT NULL DEFAULT 0 COMMENT '删除状态：0->未删除；1->已删除',
`use_integration` int(11) NULL DEFAULT NULL COMMENT '下单时使用的积分',
`payment_time` datetime(0) NULL DEFAULT NULL COMMENT '支付时间',
`delivery_time` datetime(0) NULL DEFAULT NULL COMMENT '发货时间',
`receive_time` datetime(0) NULL DEFAULT NULL COMMENT '确认收货时间',
`comment_time` datetime(0) NULL DEFAULT NULL COMMENT '评价时间',
`modify_time` datetime(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 37 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of oms_order
-- ----------------------------
INSERT INTO `oms_order` VALUES (12, 1, 2, '201809150101000001', '2018-09-15 12:24:27', 'test', 18732.00, 16377.75, 20.00, 2344.25, 0.00, 10.00, 10.00, 0, 1, 4, 0, '', '', 15, 13284, 13284, '单品促销,打折优惠：满3件，打7.50折,满减优惠：满1000.00元，减120.00元,满减优惠：满1000.00元，减120.00元,无优惠', NULL, NULL, NULL, NULL, NULL, '大梨', '18033441849', '518000', '江苏省', '常州市', '天宁区', '东晓街道', 'xxx', 0, 0, NULL, NULL, NULL, NULL, NULL, '2018-10-30 14:43:49');
INSERT INTO `oms_order` VALUES (13, 1, 2, '201809150102000002', '2018-09-15 14:24:29', 'test', 18732.00, 16377.75, 0.00, 2344.25, 0.00, 10.00, 0.00, 1, 1, 1, 0, '', '', 15, 13284, 13284, '单品促销,打折优惠：满3件，打7.50折,满减优惠：满1000.00元，减120.00元,满减优惠：满1000.00元，减120.00元,无优惠', NULL, NULL, NULL, NULL, NULL, '大梨', '18033441849', '518000', '广东省', '深圳市', '福田区', '东晓街道', NULL, 0, 0, 1000, '2018-10-11 14:04:19', NULL, NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (14, 1, 2, '201809130101000001', '2018-09-13 16:57:40', 'test', 18732.00, 16377.75, 0.00, 2344.25, 0.00, 10.00, 0.00, 2, 1, 2, 0, '顺丰快递', '201707196398345', 15, 13284, 13284, '单品促销,打折优惠：满3件，打7.50折,满减优惠：满1000.00元，减120.00元,满减优惠：满1000.00元，减120.00元,无优惠', NULL, NULL, NULL, NULL, NULL, '大梨', '18033441849', '518000', '广东省', '深圳市', '福田区', '东晓街道', NULL, 0, 0, NULL, '2018-10-13 13:44:04', '2018-10-16 13:43:41', NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (15, 1, 2, '201809130102000002', '2018-09-13 17:03:00', 'test', 18732.00, 16377.75, 0.00, 2344.25, 0.00, 10.00, 0.00, 1, 1, 3, 0, '顺丰快递', '201707196398346', 15, 13284, 13284, '单品促销,打折优惠：满3件，打7.50折,满减优惠：满1000.00元，减120.00元,满减优惠：满1000.00元，减120.00元,无优惠', NULL, NULL, NULL, NULL, NULL, '大梨', '18033441849', '518000', '广东省', '深圳市', '福田区', '东晓街道', NULL, 1, 0, NULL, '2018-10-13 13:44:54', '2018-10-16 13:45:01', '2018-10-18 14:05:31', NULL, NULL);
INSERT INTO `oms_order` VALUES (16, 1, 2, '201809140101000001', '2018-09-14 16:16:16', 'test', 18732.00, 16377.75, 0.00, 2344.25, 0.00, 10.00, 0.00, 2, 1, 4, 0, NULL, NULL, 15, 13284, 13284, '单品促销,打折优惠：满3件，打7.50折,满减优惠：满1000.00元，减120.00元,满减优惠：满1000.00元，减120.00元,无优惠', NULL, NULL, NULL, NULL, NULL, '大梨', '18033441849', '518000', '广东省', '深圳市', '福田区', '东晓街道', NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (17, 1, 2, '201809150101000003', '2018-09-15 12:24:27', 'test', 18732.00, 16377.75, 0.00, 2344.25, 0.00, 10.00, 0.00, 0, 1, 4, 0, '顺丰快递', '201707196398345', 15, NULL, NULL, '单品促销,打折优惠：满3件，打7.50折,满减优惠：满1000.00元，减120.00元,满减优惠：满1000.00元，减120.00元,无优惠', NULL, NULL, NULL, NULL, NULL, '大梨', '18033441849', '518000', '广东省', '深圳市', '福田区', '东晓街道', NULL, 0, 0, NULL, NULL, '2018-10-12 14:01:28', NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (18, 1, 2, '201809150102000004', '2018-09-15 14:24:29', 'test', 18732.00, 16377.75, 0.00, 2344.25, 0.00, 10.00, 0.00, 1, 1, 1, 0, '圆通快递', 'xx', 15, NULL, NULL, '单品促销,打折优惠：满3件，打7.50折,满减优惠：满1000.00元，减120.00元,满减优惠：满1000.00元，减120.00元,无优惠', NULL, NULL, NULL, NULL, NULL, '大梨', '18033441849', '518000', '广东省', '深圳市', '福田区', '东晓街道', NULL, 0, 0, 1000, NULL, '2018-10-16 14:42:17', NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (19, 1, 2, '201809130101000003', '2018-09-13 16:57:40', 'test', 18732.00, 16377.75, 0.00, 2344.25, 0.00, 10.00, 0.00, 2, 1, 2, 0, NULL, NULL, 15, NULL, NULL, '单品促销,打折优惠：满3件，打7.50折,满减优惠：满1000.00元，减120.00元,满减优惠：满1000.00元，减120.00元,无优惠', NULL, NULL, NULL, NULL, NULL, '大梨', '18033441849', '518000', '广东省', '深圳市', '福田区', '东晓街道', NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (20, 1, 2, '201809130102000004', '2018-09-13 17:03:00', 'test', 18732.00, 16377.75, 0.00, 2344.25, 0.00, 10.00, 0.00, 1, 1, 3, 0, NULL, NULL, 15, NULL, NULL, '单品促销,打折优惠：满3件，打7.50折,满减优惠：满1000.00元，减120.00元,满减优惠：满1000.00元，减120.00元,无优惠', NULL, NULL, NULL, NULL, NULL, '大梨', '18033441849', '518000', '广东省', '深圳市', '福田区', '东晓街道', NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (21, 1, 2, '201809140101000002', '2018-09-14 16:16:16', 'test', 18732.00, 16377.75, 0.00, 2344.25, 0.00, 10.00, 0.00, 2, 1, 4, 0, NULL, NULL, 15, 18682, 18682, '单品促销,打折优惠：满3件，打7.50折,满减优惠：满1000.00元，减120.00元,满减优惠：满1000.00元，减120.00元,无优惠', NULL, NULL, NULL, NULL, NULL, '大梨', '18033441849', '518000', '广东省', '深圳市', '福田区', '东晓街道', NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (22, 1, 2, '201809150101000005', '2018-09-15 12:24:27', 'test', 18732.00, 16377.75, 0.00, 2344.25, 0.00, 10.00, 0.00, 0, 1, 4, 0, '顺丰快递', '201707196398345', 15, 0, 0, '单品促销,打折优惠：满3件，打7.50折,满减优惠：满1000.00元，减120.00元,满减优惠：满1000.00元，减120.00元,无优惠', NULL, NULL, NULL, NULL, NULL, '大梨', '18033441849', '518000', '广东省', '深圳市', '福田区', '东晓街道', NULL, 0, 0, NULL, NULL, '2018-10-12 14:01:28', NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (23, 1, 2, '201809150102000006', '2018-09-15 14:24:29', 'test', 18732.00, 16377.75, 0.00, 2344.25, 0.00, 10.00, 0.00, 1, 1, 1, 0, '顺丰快递', 'xxx', 15, 0, 0, '单品促销,打折优惠：满3件，打7.50折,满减优惠：满1000.00元，减120.00元,满减优惠：满1000.00元，减120.00元,无优惠', NULL, NULL, NULL, NULL, NULL, '大梨', '18033441849', '518000', '广东省', '深圳市', '福田区', '东晓街道', NULL, 0, 0, 1000, NULL, '2018-10-16 14:41:28', NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (24, 1, 2, '201809130101000005', '2018-09-13 16:57:40', 'test', 18732.00, 16377.75, 0.00, 2344.25, 0.00, 10.00, 0.00, 2, 1, 2, 0, NULL, NULL, 15, 18682, 18682, '单品促销,打折优惠：满3件，打7.50折,满减优惠：满1000.00元，减120.00元,满减优惠：满1000.00元，减120.00元,无优惠', NULL, NULL, NULL, NULL, NULL, '大梨', '18033441849', '518000', '广东省', '深圳市', '福田区', '东晓街道', NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (25, 1, 2, '201809130102000006', '2018-09-13 17:03:00', 'test', 18732.00, 16377.75, 10.00, 2344.25, 0.00, 10.00, 5.00, 1, 1, 4, 0, NULL, NULL, 15, 18682, 18682, '单品促销,打折优惠：满3件，打7.50折,满减优惠：满1000.00元，减120.00元,满减优惠：满1000.00元，减120.00元,无优惠', NULL, NULL, NULL, NULL, NULL, '大梨22', '18033441849', '518000', '北京市', '北京城区', '东城区', '东城街道', 'xxx', 0, 0, NULL, NULL, NULL, NULL, NULL, '2018-10-30 15:08:31');
INSERT INTO `oms_order` VALUES (26, 1, 2, '201809140101000003', '2018-09-14 16:16:16', 'test', 18732.00, 16377.75, 0.00, 2344.25, 0.00, 10.00, 0.00, 2, 1, 4, 0, NULL, NULL, 15, 18682, 18682, '单品促销,打折优惠：满3件，打7.50折,满减优惠：满1000.00元，减120.00元,满减优惠：满1000.00元，减120.00元,无优惠', NULL, NULL, NULL, NULL, NULL, '大梨', '18033441849', '518000', '广东省', '深圳市', '福田区', '东晓街道', NULL, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (35, 1, NULL, 'gmall202001051905461578222346566', '2020-01-05 19:05:47', 'windir', 6510.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '大梨', '18033441849', NULL, '广东省', '深圳市', '福田区', '东晓街道', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (36, 1, NULL, 'gmall202001060053511578243231409', '2020-01-06 00:53:51', 'test', 6688.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '大梨', '18033441849', NULL, '广东省', '深圳市', '福田区', '东晓街道', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `oms_order` VALUES (37, 1, NULL, 'gmall202001060136101578245770977', '2020-01-06 01:36:11', 'test', 6688.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '大梨', '18033441849', NULL, '广东省', '深圳市', '福田区', '东晓街道', NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL);
-- ----------------------------
-- Table structure for oms_order_item
-- ----------------------------
DROP TABLE IF EXISTS `oms_order_item`;
CREATE TABLE `oms_order_item` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`order_id` bigint(20) NULL DEFAULT NULL COMMENT '订单id',
`order_sn` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单编号',
`product_id` bigint(20) NULL DEFAULT NULL,
`product_pic` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`product_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`product_brand` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`product_sn` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`product_price` decimal(10, 2) NULL DEFAULT NULL COMMENT '销售价格',
`product_quantity` int(11) NULL DEFAULT NULL COMMENT '购买数量',
`product_sku_id` bigint(20) NULL DEFAULT NULL COMMENT '商品sku编号',
`product_sku_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品sku条码',
`product_category_id` bigint(20) NULL DEFAULT NULL COMMENT '商品分类id',
`sp1` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品的销售属性',
`sp2` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`sp3` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`promotion_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品促销名称',
`promotion_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '商品促销分解金额',
`coupon_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '优惠券优惠分解金额',
`integration_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '积分优惠分解金额',
`real_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '该商品经过优惠后的分解金额',
`gift_integration` int(11) NULL DEFAULT 0,
`gift_growth` int(11) NULL DEFAULT 0,
`product_attr` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品销售属性:[{\"key\":\"颜色\",\"value\":\"颜色\"},{\"key\":\"容量\",\"value\":\"4G\"}]',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 55 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单中所包含的商品' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of oms_order_item
-- ----------------------------
INSERT INTO `oms_order_item` VALUES (21, 12, '201809150101000001', 26, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180607/5ac1bf58Ndefaac16.jpg', '华为 HUAWEI P20', '华为', '6946605', 3788.00, 1, 90, '201806070026001', 19, NULL, NULL, NULL, '单品促销', 200.00, 2.02, 0.00, 3585.98, 3788, 3788, '[{\"key\":\"颜色\",\"value\":\"金色\"},{\"key\":\"容量\",\"value\":\"16G\"}]');
INSERT INTO `oms_order_item` VALUES (22, 12, '201809150101000001', 27, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180615/xiaomi.jpg', '小米8', '小米', '7437788', 2699.00, 3, 98, '201808270027001', 19, NULL, NULL, NULL, '打折优惠：满3件，打7.50折', 674.75, 1.44, 0.00, 2022.81, 2699, 2699, '[{\"key\":\"颜色\",\"value\":\"黑色\"},{\"key\":\"容量\",\"value\":\"32G\"}]');
INSERT INTO `oms_order_item` VALUES (23, 12, '201809150101000001', 28, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180615/5a9d248cN071f4959.jpg', '红米5A', '小米', '7437789', 649.00, 1, 102, '201808270028001', 19, NULL, NULL, NULL, '满减优惠：满1000.00元，减120.00元', 57.60, 0.35, 0.00, 591.05, 649, 649, '[{\"key\":\"颜色\",\"value\":\"金色\"},{\"key\":\"容量\",\"value\":\"16G\"}]');
INSERT INTO `oms_order_item` VALUES (24, 12, '201809150101000001', 28, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180615/5a9d248cN071f4959.jpg', '红米5A', '小米', '7437789', 699.00, 1, 103, '201808270028001', 19, NULL, NULL, NULL, '满减优惠：满1000.00元，减120.00元', 62.40, 0.37, 0.00, 636.23, 649, 649, '[{\"key\":\"颜色\",\"value\":\"金色\"},{\"key\":\"容量\",\"value\":\"32G\"}]');
INSERT INTO `oms_order_item` VALUES (25, 12, '201809150101000001', 29, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180615/5acc5248N6a5f81cd.jpg', 'Apple iPhone 8 Plus', '苹果', '7437799', 5499.00, 1, 106, '201808270029001', 19, NULL, NULL, NULL, '无优惠', 0.00, 2.94, 0.00, 5496.06, 5499, 5499, '[{\"key\":\"颜色\",\"value\":\"金色\"},{\"key\":\"容量\",\"value\":\"32G\"}]');
INSERT INTO `oms_order_item` VALUES (26, 13, '201809150102000002', 26, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180607/5ac1bf58Ndefaac16.jpg', '华为 HUAWEI P20', '华为', '6946605', 3788.00, 1, 90, '201806070026001', 19, NULL, NULL, NULL, '单品促销', 200.00, 2.02, 0.00, 3585.98, 3788, 3788, '[{\"key\":\"颜色\",\"value\":\"金色\"},{\"key\":\"容量\",\"value\":\"16G\"}]');
INSERT INTO `oms_order_item` VALUES (27, 13, '201809150102000002', 27, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180615/xiaomi.jpg', '小米8', '小米', '7437788', 2699.00, 3, 98, '201808270027001', 19, NULL, NULL, NULL, '打折优惠：满3件，打7.50折', 674.75, 1.44, 0.00, 2022.81, 2699, 2699, '[{\"key\":\"颜色\",\"value\":\"黑色\"},{\"key\":\"容量\",\"value\":\"32G\"}]');
INSERT INTO `oms_order_item` VALUES (28, 13, '201809150102000002', 28, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180615/5a9d248cN071f4959.jpg', '红米5A', '小米', '7437789', 649.00, 1, 102, '201808270028001', 19, NULL, NULL, NULL, '满减优惠：满1000.00元，减120.00元', 57.60, 0.35, 0.00, 591.05, 649, 649, '[{\"key\":\"颜色\",\"value\":\"金色\"},{\"key\":\"容量\",\"value\":\"16G\"}]');
INSERT INTO `oms_order_item` VALUES (29, 13, '201809150102000002', 28, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180615/5a9d248cN071f4959.jpg', '红米5A', '小米', '7437789', 699.00, 1, 103, '201808270028001', 19, NULL, NULL, NULL, '满减优惠：满1000.00元，减120.00元', 62.40, 0.37, 0.00, 636.23, 649, 649, '[{\"key\":\"颜色\",\"value\":\"金色\"},{\"key\":\"容量\",\"value\":\"32G\"}]');
INSERT INTO `oms_order_item` VALUES (30, 13, '201809150102000002', 29, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180615/5acc5248N6a5f81cd.jpg', 'Apple iPhone 8 Plus', '苹果', '7437799', 5499.00, 1, 106, '201808270029001', 19, NULL, NULL, NULL, '无优惠', 0.00, 2.94, 0.00, 5496.06, 5499, 5499, '[{\"key\":\"颜色\",\"value\":\"金色\"},{\"key\":\"容量\",\"value\":\"32G\"}]');
INSERT INTO `oms_order_item` VALUES (31, 14, '201809130101000001', 26, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180607/5ac1bf58Ndefaac16.jpg', '华为 HUAWEI P20', '华为', '6946605', 3788.00, 1, 90, '201806070026001', 19, NULL, NULL, NULL, '单品促销', 200.00, 2.02, 0.00, 3585.98, 3788, 3788, '[{\"key\":\"颜色\",\"value\":\"金色\"},{\"key\":\"容量\",\"value\":\"16G\"}]');
INSERT INTO `oms_order_item` VALUES (32, 14, '201809130101000001', 27, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180615/xiaomi.jpg', '小米8', '小米', '7437788', 2699.00, 3, 98, '201808270027001', 19, NULL, NULL, NULL, '打折优惠：满3件，打7.50折', 674.75, 1.44, 0.00, 2022.81, 2699, 2699, '[{\"key\":\"颜色\",\"value\":\"黑色\"},{\"key\":\"容量\",\"value\":\"32G\"}]');
INSERT INTO `oms_order_item` VALUES (33, 14, '201809130101000001', 28, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180615/5a9d248cN071f4959.jpg', '红米5A', '小米', '7437789', 649.00, 1, 102, '201808270028001', 19, NULL, NULL, NULL, '满减优惠：满1000.00元，减120.00元', 57.60, 0.35, 0.00, 591.05, 649, 649, '[{\"key\":\"颜色\",\"value\":\"金色\"},{\"key\":\"容量\",\"value\":\"16G\"}]');
INSERT INTO `oms_order_item` VALUES (34, 14, '201809130101000001', 28, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180615/5a9d248cN071f4959.jpg', '红米5A', '小米', '7437789', 699.00, 1, 103, '201808270028001', 19, NULL, NULL, NULL, '满减优惠：满1000.00元，减120.00元', 62.40, 0.37, 0.00, 636.23, 649, 649, '[{\"key\":\"颜色\",\"value\":\"金色\"},{\"key\":\"容量\",\"value\":\"32G\"}]');
INSERT INTO `oms_order_item` VALUES (35, 14, '201809130101000001', 29, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180615/5acc5248N6a5f81cd.jpg', 'Apple iPhone 8 Plus', '苹果', '7437799', 5499.00, 1, 106, '201808270029001', 19, NULL, NULL, NULL, '无优惠', 0.00, 2.94, 0.00, 5496.06, 5499, 5499, '[{\"key\":\"颜色\",\"value\":\"金色\"},{\"key\":\"容量\",\"value\":\"32G\"}]');
INSERT INTO `oms_order_item` VALUES (36, 15, '201809130101000001', 26, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180607/5ac1bf58Ndefaac16.jpg', '华为 HUAWEI P20', '华为', '6946605', 3788.00, 1, 90, '201806070026001', 19, NULL, NULL, NULL, '单品促销', 200.00, 2.02, 0.00, 3585.98, 3788, 3788, '[{\"key\":\"颜色\",\"value\":\"金色\"},{\"key\":\"容量\",\"value\":\"16G\"}]');
INSERT INTO `oms_order_item` VALUES (37, 15, '201809130101000001', 27, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180615/xiaomi.jpg', '小米8', '小米', '7437788', 2699.00, 3, 98, '201808270027001', 19, NULL, NULL, NULL, '打折优惠：满3件，打7.50折', 674.75, 1.44, 0.00, 2022.81, 2699, 2699, '[{\"key\":\"颜色\",\"value\":\"黑色\"},{\"key\":\"容量\",\"value\":\"32G\"}]');
INSERT INTO `oms_order_item` VALUES (38, 15, '201809130101000001', 28, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180615/5a9d248cN071f4959.jpg', '红米5A', '小米', '7437789', 649.00, 1, 102, '201808270028001', 19, NULL, NULL, NULL, '满减优惠：满1000.00元，减120.00元', 57.60, 0.35, 0.00, 591.05, 649, 649, '[{\"key\":\"颜色\",\"value\":\"金色\"},{\"key\":\"容量\",\"value\":\"16G\"}]');
INSERT INTO `oms_order_item` VALUES (39, 15, '201809130101000001', 28, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180615/5a9d248cN071f4959.jpg', '红米5A', '小米', '7437789', 699.00, 1, 103, '201808270028001', 19, NULL, NULL, NULL, '满减优惠：满1000.00元，减120.00元', 62.40, 0.37, 0.00, 636.23, 649, 649, '[{\"key\":\"颜色\",\"value\":\"金色\"},{\"key\":\"容量\",\"value\":\"32G\"}]');
INSERT INTO `oms_order_item` VALUES (40, 15, '201809130101000001', 29, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180615/5acc5248N6a5f81cd.jpg', 'Apple iPhone 8 Plus', '苹果', '7437799', 5499.00, 1, 106, '201808270029001', 19, NULL, NULL, NULL, '无优惠', 0.00, 2.94, 0.00, 5496.06, 5499, 5499, '[{\"key\":\"颜色\",\"value\":\"金色\"},{\"key\":\"容量\",\"value\":\"32G\"}]');
INSERT INTO `oms_order_item` VALUES (41, 16, '201809140101000001', 26, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180607/5ac1bf58Ndefaac16.jpg', '华为 HUAWEI P20', '华为', '6946605', 3788.00, 1, 90, '201806070026001', 19, NULL, NULL, NULL, '单品促销', 200.00, 2.02, 0.00, 3585.98, 3788, 3788, '[{\"key\":\"颜色\",\"value\":\"金色\"},{\"key\":\"容量\",\"value\":\"16G\"}]');
INSERT INTO `oms_order_item` VALUES (42, 16, '201809140101000001', 27, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180615/xiaomi.jpg', '小米8', '小米', '7437788', 2699.00, 3, 98, '201808270027001', 19, NULL, NULL, NULL, '打折优惠：满3件，打7.50折', 674.75, 1.44, 0.00, 2022.81, 2699, 2699, '[{\"key\":\"颜色\",\"value\":\"黑色\"},{\"key\":\"容量\",\"value\":\"32G\"}]');
INSERT INTO `oms_order_item` VALUES (43, 16, '201809140101000001', 28, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180615/5a9d248cN071f4959.jpg', '红米5A', '小米', '7437789', 649.00, 1, 102, '201808270028001', 19, NULL, NULL, NULL, '满减优惠：满1000.00元，减120.00元', 57.60, 0.35, 0.00, 591.05, 649, 649, '[{\"key\":\"颜色\",\"value\":\"金色\"},{\"key\":\"容量\",\"value\":\"16G\"}]');
INSERT INTO `oms_order_item` VALUES (44, 16, '201809140101000001', 28, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180615/5a9d248cN071f4959.jpg', '红米5A', '小米', '7437789', 699.00, 1, 103, '201808270028001', 19, NULL, NULL, NULL, '满减优惠：满1000.00元，减120.00元', 62.40, 0.37, 0.00, 636.23, 649, 649, '[{\"key\":\"颜色\",\"value\":\"金色\"},{\"key\":\"容量\",\"value\":\"32G\"}]');
INSERT INTO `oms_order_item` VALUES (45, 16, '201809140101000001', 29, 'http://macro-oss.oss-cn-shenzhen.aliyuncs.com/mall/images/20180615/5acc5248N6a5f81cd.jpg', 'Apple iPhone 8 Plus', '苹果', '7437799', 5499.00, 1, 106, '201808270029001', 19, NULL, NULL, NULL, '无优惠', 0.00, 2.94, 0.00, 5496.06, 5499, 5499, '[{\"key\":\"颜色\",\"value\":\"金色\"},{\"key\":\"容量\",\"value\":\"32G\"}]');
INSERT INTO `oms_order_item` VALUES (53, 35, 'gmall202001051905461578222346566', 66, 'http://192.168.1.108/group1/M00/00/00/wKgJbF3nE92AYB5gAAAo7Ah4vxY260.jpg', '荣耀V30 5G 双模 麒麟990 突破性相机矩阵 游戏手机 6GB+128GB 幻夜星河 移动联通电信5G 双卡双待', NULL, '仓库对应的商品编号', 3255.00, 2, 112, NULL, 61, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL);
INSERT INTO `oms_order_item` VALUES (54, 36, 'gmall202001060053511578243231409', 67, 'http://192.168.1.108/group1/M00/00/00/wKgJbF3nE8aAB23zAAAtnRR4fGE178.jpg', '华为 HUAWEI Mate 30 Pro 5G 麒麟990 环幕屏双4000万徕卡电影四摄8GB', NULL, '仓库对应的商品编号', 6688.00, 1, 109, NULL, 61, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL);
INSERT INTO `oms_order_item` VALUES (55, 37, 'gmall202001060136101578245770977', 67, 'http://192.168.1.108/group1/M00/00/00/wKgJbF3nE8aAB23zAAAtnRR4fGE178.jpg', '华为 HUAWEI Mate 30 Pro 5G 麒麟990 环幕屏双4000万徕卡电影四摄8GB', NULL, '仓库对应的商品编号', 6688.00, 1, 109, NULL, 61, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL);
-- ----------------------------
-- Table structure for payment_info
-- ----------------------------
DROP TABLE IF EXISTS `payment_info`;
CREATE TABLE `payment_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
`order_sn` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '对外业务编号',
`order_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单编号',
`alipay_trade_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '支付宝交易编号',
`total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '支付金额',
`subject` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '交易内容',
`payment_status` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '支付状态',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`confirm_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`callback_content` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '回调信息',
`callback_time` datetime(0) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 281 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '支付信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of payment_info
-- ----------------------------
INSERT INTO `payment_info` VALUES (250, 'atguigu201903201547321553068052208', '281', '2019032022001409701031928056', 10001.00, '黑鲨游戏手机Gmall1015系列低配双核版', '已支付', '2019-03-20 15:47:35', NULL, 'charset=utf-8&out_trade_no=atguigu201903201551591553068319124&method=alipay.trade.page.pay.return&total_amount=0.01&sign=JHMpfB9wv%2FOaNV9Cpjp7%2B6uY83ScfJ4YIG6dsDtrJlbbRJj6Z7%2FMlT3EazeB487wlKGPFim9L2xzIl8MwBpCwOc2qI95pCDwDrXgaO%2F2yA%2FlDp6bDkcRx84Lkm%2F2MNwZ%2FyFSW%2FyyDxWGEI3izHYMm1rf8T6nNDKvfuKTrKiKiIAGSv%2FJX1z7InGW%2BgeWtLlYWdV9fS1aKDEUZwGJaKwQeGf0c2YpZ2u%2FPoBuT32IQTbACx60SO4Jdz4y%2BVjwF5UmvLZD6HP7n5hvcQE833r9FOCU3rOskdAWNWt4wEvaJ%2FAuq%2BFAg6xHTDk1E2iDwkLVjumnYM%2FUcpw6G6Yu60nVtQ%3D%3D&trade_no=2019032022001409701031928056&auth_app_id=2018020102122556&version=1.0&app_id=2018020102122556&sign_type=RSA2&seller_id=2088921750292524×tamp=2019-03-20+15%3A52%3A40', '2019-03-20 15:52:43');
INSERT INTO `payment_info` VALUES (251, 'atguigu201903201549081553068148868', '282', '2019032022001409701031928056', 10001.00, '黑鲨游戏手机Gmall1015系列低配双核版', '已支付', '2019-03-20 15:49:12', NULL, 'charset=utf-8&out_trade_no=atguigu201903201551591553068319124&method=alipay.trade.page.pay.return&total_amount=0.01&sign=JHMpfB9wv%2FOaNV9Cpjp7%2B6uY83ScfJ4YIG6dsDtrJlbbRJj6Z7%2FMlT3EazeB487wlKGPFim9L2xzIl8MwBpCwOc2qI95pCDwDrXgaO%2F2yA%2FlDp6bDkcRx84Lkm%2F2MNwZ%2FyFSW%2FyyDxWGEI3izHYMm1rf8T6nNDKvfuKTrKiKiIAGSv%2FJX1z7InGW%2BgeWtLlYWdV9fS1aKDEUZwGJaKwQeGf0c2YpZ2u%2FPoBuT32IQTbACx60SO4Jdz4y%2BVjwF5UmvLZD6HP7n5hvcQE833r9FOCU3rOskdAWNWt4wEvaJ%2FAuq%2BFAg6xHTDk1E2iDwkLVjumnYM%2FUcpw6G6Yu60nVtQ%3D%3D&trade_no=2019032022001409701031928056&auth_app_id=2018020102122556&version=1.0&app_id=2018020102122556&sign_type=RSA2&seller_id=2088921750292524×tamp=2019-03-20+15%3A52%3A40', '2019-03-20 15:52:43');
INSERT INTO `payment_info` VALUES (252, 'atguigu201903201551591553068319124', '283', '2019032022001409701031928056', 10001.00, '黑鲨游戏手机Gmall1015系列低配双核版', '已支付', '2019-03-20 15:52:01', NULL, 'charset=utf-8&out_trade_no=atguigu201903201551591553068319124&method=alipay.trade.page.pay.return&total_amount=0.01&sign=JHMpfB9wv%2FOaNV9Cpjp7%2B6uY83ScfJ4YIG6dsDtrJlbbRJj6Z7%2FMlT3EazeB487wlKGPFim9L2xzIl8MwBpCwOc2qI95pCDwDrXgaO%2F2yA%2FlDp6bDkcRx84Lkm%2F2MNwZ%2FyFSW%2FyyDxWGEI3izHYMm1rf8T6nNDKvfuKTrKiKiIAGSv%2FJX1z7InGW%2BgeWtLlYWdV9fS1aKDEUZwGJaKwQeGf0c2YpZ2u%2FPoBuT32IQTbACx60SO4Jdz4y%2BVjwF5UmvLZD6HP7n5hvcQE833r9FOCU3rOskdAWNWt4wEvaJ%2FAuq%2BFAg6xHTDk1E2iDwkLVjumnYM%2FUcpw6G6Yu60nVtQ%3D%3D&trade_no=2019032022001409701031928056&auth_app_id=2018020102122556&version=1.0&app_id=2018020102122556&sign_type=RSA2&seller_id=2088921750292524×tamp=2019-03-20+15%3A52%3A40', '2019-03-20 15:52:43');
INSERT INTO `payment_info` VALUES (281, 'gmall202001060136101578245770977', '37', '2020010622001491441408133238', 6688.00, '谷粒商城商品', '成功付款', '2020-01-06 01:36:15', NULL, 'charset=utf-8&out_trade_no=gmall202001060136101578245770977&method=alipay.trade.page.pay.return&total_amount=0.01&sign=EdeH97flMIuDs%2FkMsE9P%2FhKGLrNOJbJEbn2RPae%2BoWiOQXEN8u9Gzq7VDGtYFt%2BbIwfBoVfuR7ctmrAuj0UoRKgG7LH1doq5Csor%2FvCsMiKT755gKlDdQSUsyolYRrGXS5NQe3BLg5DHMHuM%2F1v40Wb2pd7lwRNFaFT8YH3moDs0tw0KoTueNXMFvaJnQ%2Bm3I46WUY9nWDec81jpJ%2FKpYlceyRn1ost5jcRJnarcGQO1StiUVoY%2F4twGK5R6WUSuvPH1cFmXP3bQ4KX3qjHAKYgLnqnWslkOi2%2Bsgyp23pDuXykaIGGZaPtxQ1mMa3de4%2BqWmN9dweiwsWxmKElY%2FQ%3D%3D&trade_no=2020010622001491441408133238&auth_app_id=2018020102122556&version=1.0&app_id=2018020102122556&sign_type=RSA2&seller_id=2088921750292524×tamp=2020-01-06+01%3A36%3A39', '2020-01-06 01:37:58');
-- ----------------------------
-- Table structure for pms_base_attr_info
-- ----------------------------
DROP TABLE IF EXISTS `pms_base_attr_info`;
CREATE TABLE `pms_base_attr_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
`attr_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '属性名称',
`catalog3_id` bigint(20) NULL DEFAULT NULL,
`is_enabled` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '启用：1 停用：0',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 48 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '属性表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of pms_base_attr_info
-- ----------------------------
INSERT INTO `pms_base_attr_info` VALUES (12, '尺寸', 61, NULL);
INSERT INTO `pms_base_attr_info` VALUES (13, '内存', 61, NULL);
INSERT INTO `pms_base_attr_info` VALUES (25, '屏幕尺寸', 61, NULL);
INSERT INTO `pms_base_attr_info` VALUES (26, '内存容量', 61, NULL);
INSERT INTO `pms_base_attr_info` VALUES (27, '颜色', 61, NULL);
INSERT INTO `pms_base_attr_info` VALUES (28, 'cpu', 61, NULL);
INSERT INTO `pms_base_attr_info` VALUES (29, '外壳', 61, NULL);
INSERT INTO `pms_base_attr_info` VALUES (31, '容错率', 61, NULL);
INSERT INTO `pms_base_attr_info` VALUES (32, '时空传送距离', 61, NULL);
INSERT INTO `pms_base_attr_info` VALUES (33, '待机时间', 61, NULL);
INSERT INTO `pms_base_attr_info` VALUES (34, '线宽', 61, NULL);
INSERT INTO `pms_base_attr_info` VALUES (35, '高度', 61, NULL);
INSERT INTO `pms_base_attr_info` VALUES (36, '吃鸡性能', 61, NULL);
INSERT INTO `pms_base_attr_info` VALUES (37, 'lol性能', 61, NULL);
INSERT INTO `pms_base_attr_info` VALUES (38, '续航时间', 61, NULL);
INSERT INTO `pms_base_attr_info` VALUES (45, '处理器', 285, NULL);
INSERT INTO `pms_base_attr_info` VALUES (46, '存储', 285, NULL);
INSERT INTO `pms_base_attr_info` VALUES (47, '显示', 285, NULL);
INSERT INTO `pms_base_attr_info` VALUES (48, '价格', 285, NULL);
-- ----------------------------
-- Table structure for pms_base_attr_value
-- ----------------------------
DROP TABLE IF EXISTS `pms_base_attr_value`;
CREATE TABLE `pms_base_attr_value` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
`value_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '属性值名称',
`attr_id` bigint(20) NOT NULL COMMENT '属性id',
`is_enabled` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '启用：1 停用：0 1',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 115 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '属性值表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of pms_base_attr_value
-- ----------------------------
INSERT INTO `pms_base_attr_value` VALUES (39, '4寸以下', 25, '');
INSERT INTO `pms_base_attr_value` VALUES (40, '4.1寸-5寸', 25, '');
INSERT INTO `pms_base_attr_value` VALUES (41, '5.1寸-5.5寸', 25, '');
INSERT INTO `pms_base_attr_value` VALUES (42, '5.6寸以上', 25, '');
INSERT INTO `pms_base_attr_value` VALUES (43, '16G', 26, '');
INSERT INTO `pms_base_attr_value` VALUES (44, '32G', 26, '');
INSERT INTO `pms_base_attr_value` VALUES (45, '64G', 26, '');
INSERT INTO `pms_base_attr_value` VALUES (46, '128G', 26, '');
INSERT INTO `pms_base_attr_value` VALUES (47, '256G', 26, '');
INSERT INTO `pms_base_attr_value` VALUES (48, 'z1', 12, '');
INSERT INTO `pms_base_attr_value` VALUES (49, 'z2', 12, '');
INSERT INTO `pms_base_attr_value` VALUES (50, 'z3', 12, '');
INSERT INTO `pms_base_attr_value` VALUES (51, 'n1', 13, '');
INSERT INTO `pms_base_attr_value` VALUES (52, 'n2', 13, '');
INSERT INTO `pms_base_attr_value` VALUES (53, 'n3', 13, '');
INSERT INTO `pms_base_attr_value` VALUES (54, '红色', 27, '');
INSERT INTO `pms_base_attr_value` VALUES (55, '蓝色', 27, '');
INSERT INTO `pms_base_attr_value` VALUES (56, '紫色', 27, '');
INSERT INTO `pms_base_attr_value` VALUES (57, '灰色', 27, '');
INSERT INTO `pms_base_attr_value` VALUES (58, '100寸', 25, '');
INSERT INTO `pms_base_attr_value` VALUES (59, 'i5', 28, '');
INSERT INTO `pms_base_attr_value` VALUES (60, 'i7', 28, '');
INSERT INTO `pms_base_attr_value` VALUES (61, 'i9', 28, '');
INSERT INTO `pms_base_attr_value` VALUES (62, '陶瓷', 29, '');
INSERT INTO `pms_base_attr_value` VALUES (63, '铁', 29, '');
INSERT INTO `pms_base_attr_value` VALUES (64, '金', 29, '');
INSERT INTO `pms_base_attr_value` VALUES (65, '环绕立体声', 32, '');
INSERT INTO `pms_base_attr_value` VALUES (66, '影院效果', 32, '');
INSERT INTO `pms_base_attr_value` VALUES (67, '不容错', 31, NULL);
INSERT INTO `pms_base_attr_value` VALUES (68, '容错', 31, NULL);
INSERT INTO `pms_base_attr_value` VALUES (69, '100m', 32, NULL);
INSERT INTO `pms_base_attr_value` VALUES (70, '200m', 32, NULL);
INSERT INTO `pms_base_attr_value` VALUES (71, '300m', 32, NULL);
INSERT INTO `pms_base_attr_value` VALUES (72, '1小时', 33, NULL);
INSERT INTO `pms_base_attr_value` VALUES (73, '2小时', 33, NULL);
INSERT INTO `pms_base_attr_value` VALUES (74, '3小时', 33, NULL);
INSERT INTO `pms_base_attr_value` VALUES (75, '线宽1', 34, NULL);
INSERT INTO `pms_base_attr_value` VALUES (76, '线宽2', 34, NULL);
INSERT INTO `pms_base_attr_value` VALUES (77, '线宽3', 34, NULL);
INSERT INTO `pms_base_attr_value` VALUES (78, '1米', 35, NULL);
INSERT INTO `pms_base_attr_value` VALUES (79, '2米', 35, NULL);
INSERT INTO `pms_base_attr_value` VALUES (80, '3米', 35, NULL);
INSERT INTO `pms_base_attr_value` VALUES (81, '入门级', 36, NULL);
INSERT INTO `pms_base_attr_value` VALUES (82, '大师级', 36, NULL);
INSERT INTO `pms_base_attr_value` VALUES (83, '超神', 36, NULL);
INSERT INTO `pms_base_attr_value` VALUES (84, '最低配置', 37, NULL);
INSERT INTO `pms_base_attr_value` VALUES (85, '中等配置', 37, NULL);
INSERT INTO `pms_base_attr_value` VALUES (86, '高等配置', 37, NULL);
INSERT INTO `pms_base_attr_value` VALUES (87, '1天', 38, NULL);
INSERT INTO `pms_base_attr_value` VALUES (88, '2天', 38, NULL);
INSERT INTO `pms_base_attr_value` VALUES (89, '3天', 38, NULL);
INSERT INTO `pms_base_attr_value` VALUES (107, 'i5', 45, NULL);
INSERT INTO `pms_base_attr_value` VALUES (108, 'i7', 45, NULL);
INSERT INTO `pms_base_attr_value` VALUES (109, '500G', 46, NULL);
INSERT INTO `pms_base_attr_value` VALUES (110, '1000G', 46, NULL);
INSERT INTO `pms_base_attr_value` VALUES (111, 'GTX1080', 47, NULL);
INSERT INTO `pms_base_attr_value` VALUES (112, 'GTX2008', 47, NULL);
INSERT INTO `pms_base_attr_value` VALUES (113, '5000以下', 48, NULL);
INSERT INTO `pms_base_attr_value` VALUES (114, '5000-10000', 48, NULL);
INSERT INTO `pms_base_attr_value` VALUES (115, '10000以上', 48, NULL);
-- ----------------------------
-- Table structure for pms_base_catalog1
-- ----------------------------
DROP TABLE IF EXISTS `pms_base_catalog1`;
CREATE TABLE `pms_base_catalog1` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
`name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '分类名称',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '一级分类表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of pms_base_catalog1
-- ----------------------------
INSERT INTO `pms_base_catalog1` VALUES (1, '图书、音像、电子书刊');
INSERT INTO `pms_base_catalog1` VALUES (2, '手机');
INSERT INTO `pms_base_catalog1` VALUES (3, '家用电器');
INSERT INTO `pms_base_catalog1` VALUES (4, '数码');
INSERT INTO `pms_base_catalog1` VALUES (5, '家居家装');
INSERT INTO `pms_base_catalog1` VALUES (6, '电脑办公');
INSERT INTO `pms_base_catalog1` VALUES (7, '厨具');
INSERT INTO `pms_base_catalog1` VALUES (8, '个护化妆');
INSERT INTO `pms_base_catalog1` VALUES (9, '服饰内衣');
INSERT INTO `pms_base_catalog1` VALUES (10, '钟表');
INSERT INTO `pms_base_catalog1` VALUES (11, '鞋靴');
INSERT INTO `pms_base_catalog1` VALUES (12, '母婴');
INSERT INTO `pms_base_catalog1` VALUES (13, '礼品箱包');
INSERT INTO `pms_base_catalog1` VALUES (14, '食品饮料、保健食品');
INSERT INTO `pms_base_catalog1` VALUES (15, '珠宝');
INSERT INTO `pms_base_catalog1` VALUES (16, '汽车用品');
INSERT INTO `pms_base_catalog1` VALUES (17, '运动健康');
INSERT INTO `pms_base_catalog1` VALUES (18, '玩具乐器');
INSERT INTO `pms_base_catalog1` VALUES (19, '彩票、旅行、充值、票务');
INSERT INTO `pms_base_catalog1` VALUES (20, '生鲜');
INSERT INTO `pms_base_catalog1` VALUES (21, '整车');
-- ----------------------------
-- Table structure for pms_base_catalog2
-- ----------------------------
DROP TABLE IF EXISTS `pms_base_catalog2`;
CREATE TABLE `pms_base_catalog2` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
`name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '二级分类名称',
`catalog1_id` int(11) NULL DEFAULT NULL COMMENT '一级分类编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 143 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of pms_base_catalog2
-- ----------------------------
INSERT INTO `pms_base_catalog2` VALUES (1, '电子书刊', 1);
INSERT INTO `pms_base_catalog2` VALUES (2, '音像', 1);
INSERT INTO `pms_base_catalog2` VALUES (3, '英文原版', 1);
INSERT INTO `pms_base_catalog2` VALUES (4, '文艺', 1);
INSERT INTO `pms_base_catalog2` VALUES (5, '少儿', 1);
INSERT INTO `pms_base_catalog2` VALUES (6, '人文社科', 1);
INSERT INTO `pms_base_catalog2` VALUES (7, '经管励志', 1);
INSERT INTO `pms_base_catalog2` VALUES (8, '生活', 1);
INSERT INTO `pms_base_catalog2` VALUES (9, '科技', 1);
INSERT INTO `pms_base_catalog2` VALUES (10, '教育', 1);
INSERT INTO `pms_base_catalog2` VALUES (11, '港台图书', 1);
INSERT INTO `pms_base_catalog2` VALUES (12, '其他', 1);
INSERT INTO `pms_base_catalog2` VALUES (13, '手机通讯', 2);
INSERT INTO `pms_base_catalog2` VALUES (14, '运营商', 2);
INSERT INTO `pms_base_catalog2` VALUES (15, '手机配件', 2);
INSERT INTO `pms_base_catalog2` VALUES (16, '大 家 电', 3);
INSERT INTO `pms_base_catalog2` VALUES (17, '厨卫大电', 3);
INSERT INTO `pms_base_catalog2` VALUES (18, '厨房小电', 3);
INSERT INTO `pms_base_catalog2` VALUES (19, '生活电器', 3);
INSERT INTO `pms_base_catalog2` VALUES (20, '个护健康', 3);
INSERT INTO `pms_base_catalog2` VALUES (21, '五金家装', 3);
INSERT INTO `pms_base_catalog2` VALUES (22, '摄影摄像', 4);
INSERT INTO `pms_base_catalog2` VALUES (23, '数码配件', 4);
INSERT INTO `pms_base_catalog2` VALUES (24, '智能设备', 4);
INSERT INTO `pms_base_catalog2` VALUES (25, '影音娱乐', 4);
INSERT INTO `pms_base_catalog2` VALUES (26, '电子教育', 4);
INSERT INTO `pms_base_catalog2` VALUES (27, '虚拟商品', 4);
INSERT INTO `pms_base_catalog2` VALUES (28, '家纺', 5);
INSERT INTO `pms_base_catalog2` VALUES (29, '灯具', 5);
INSERT INTO `pms_base_catalog2` VALUES (30, '生活日用', 5);
INSERT INTO `pms_base_catalog2` VALUES (31, '家装软饰', 5);
INSERT INTO `pms_base_catalog2` VALUES (32, '宠物生活', 5);
INSERT INTO `pms_base_catalog2` VALUES (33, '电脑整机', 6);
INSERT INTO `pms_base_catalog2` VALUES (34, '电脑配件', 6);
INSERT INTO `pms_base_catalog2` VALUES (35, '外设产品', 6);
INSERT INTO `pms_base_catalog2` VALUES (36, '游戏设备', 6);
INSERT INTO `pms_base_catalog2` VALUES (37, '网络产品', 6);
INSERT INTO `pms_base_catalog2` VALUES (38, '办公设备', 6);
INSERT INTO `pms_base_catalog2` VALUES (39, '文具/耗材', 6);
INSERT INTO `pms_base_catalog2` VALUES (40, '服务产品', 6);
INSERT INTO `pms_base_catalog2` VALUES (41, '烹饪锅具', 7);
INSERT INTO `pms_base_catalog2` VALUES (42, '刀剪菜板', 7);
INSERT INTO `pms_base_catalog2` VALUES (43, '厨房配件', 7);
INSERT INTO `pms_base_catalog2` VALUES (44, '水具酒具', 7);
INSERT INTO `pms_base_catalog2` VALUES (45, '餐具', 7);
INSERT INTO `pms_base_catalog2` VALUES (46, '酒店用品', 7);
INSERT INTO `pms_base_catalog2` VALUES (47, '茶具/咖啡具', 7);
INSERT INTO `pms_base_catalog2` VALUES (48, '清洁用品', 8);
INSERT INTO `pms_base_catalog2` VALUES (49, '面部护肤', 8);
INSERT INTO `pms_base_catalog2` VALUES (50, '身体护理', 8);
INSERT INTO `pms_base_catalog2` VALUES (51, '口腔护理', 8);
INSERT INTO `pms_base_catalog2` VALUES (52, '女性护理', 8);
INSERT INTO `pms_base_catalog2` VALUES (53, '洗发护发', 8);
INSERT INTO `pms_base_catalog2` VALUES (54, '香水彩妆', 8);
INSERT INTO `pms_base_catalog2` VALUES (55, '女装', 9);
INSERT INTO `pms_base_catalog2` VALUES (56, '男装', 9);
INSERT INTO `pms_base_catalog2` VALUES (57, '内衣', 9);
INSERT INTO `pms_base_catalog2` VALUES (58, '洗衣服务', 9);
INSERT INTO `pms_base_catalog2` VALUES (59, '服饰配件', 9);
INSERT INTO `pms_base_catalog2` VALUES (60, '钟表', 10);
INSERT INTO `pms_base_catalog2` VALUES (61, '流行男鞋', 11);
INSERT INTO `pms_base_catalog2` VALUES (62, '时尚女鞋', 11);
INSERT INTO `pms_base_catalog2` VALUES (63, '奶粉', 12);
INSERT INTO `pms_base_catalog2` VALUES (64, '营养辅食', 12);
INSERT INTO `pms_base_catalog2` VALUES (65, '尿裤湿巾', 12);
INSERT INTO `pms_base_catalog2` VALUES (66, '喂养用品', 12);
INSERT INTO `pms_base_catalog2` VALUES (67, '洗护用品', 12);
INSERT INTO `pms_base_catalog2` VALUES (68, '童车童床', 12);
INSERT INTO `pms_base_catalog2` VALUES (69, '寝居服饰', 12);
INSERT INTO `pms_base_catalog2` VALUES (70, '妈妈专区', 12);
INSERT INTO `pms_base_catalog2` VALUES (71, '童装童鞋', 12);
INSERT INTO `pms_base_catalog2` VALUES (72, '安全座椅', 12);
INSERT INTO `pms_base_catalog2` VALUES (73, '潮流女包', 13);
INSERT INTO `pms_base_catalog2` VALUES (74, '精品男包', 13);
INSERT INTO `pms_base_catalog2` VALUES (75, '功能箱包', 13);
INSERT INTO `pms_base_catalog2` VALUES (76, '礼品', 13);
INSERT INTO `pms_base_catalog2` VALUES (77, '奢侈品', 13);
INSERT INTO `pms_base_catalog2` VALUES (78, '婚庆', 13);
INSERT INTO `pms_base_catalog2` VALUES (79, '进口食品', 14);
INSERT INTO `pms_base_catalog2` VALUES (80, '地方特产', 14);
INSERT INTO `pms_base_catalog2` VALUES (81, '休闲食品', 14);
INSERT INTO `pms_base_catalog2` VALUES (82, '粮油调味', 14);
INSERT INTO `pms_base_catalog2` VALUES (83, '饮料冲调', 14);
INSERT INTO `pms_base_catalog2` VALUES (84, '食品礼券', 14);
INSERT INTO `pms_base_catalog2` VALUES (85, '茗茶', 14);
INSERT INTO `pms_base_catalog2` VALUES (86, '时尚饰品', 15);
INSERT INTO `pms_base_catalog2` VALUES (87, '黄金', 15);
INSERT INTO `pms_base_catalog2` VALUES (88, 'K金饰品', 15);
INSERT INTO `pms_base_catalog2` VALUES (89, '金银投资', 15);
INSERT INTO `pms_base_catalog2` VALUES (90, '银饰', 15);
INSERT INTO `pms_base_catalog2` VALUES (91, '钻石', 15);
INSERT INTO `pms_base_catalog2` VALUES (92, '翡翠玉石', 15);
INSERT INTO `pms_base_catalog2` VALUES (93, '水晶玛瑙', 15);
INSERT INTO `pms_base_catalog2` VALUES (94, '彩宝', 15);
INSERT INTO `pms_base_catalog2` VALUES (95, '铂金', 15);
INSERT INTO `pms_base_catalog2` VALUES (96, '木手串/把件', 15);
INSERT INTO `pms_base_catalog2` VALUES (97, '珍珠', 15);
INSERT INTO `pms_base_catalog2` VALUES (98, '维修保养', 16);
INSERT INTO `pms_base_catalog2` VALUES (99, '车载电器', 16);
INSERT INTO `pms_base_catalog2` VALUES (100, '美容清洗', 16);
INSERT INTO `pms_base_catalog2` VALUES (101, '汽车装饰', 16);
INSERT INTO `pms_base_catalog2` VALUES (102, '安全自驾', 16);
INSERT INTO `pms_base_catalog2` VALUES (103, '汽车服务', 16);
INSERT INTO `pms_base_catalog2` VALUES (104, '赛事改装', 16);
INSERT INTO `pms_base_catalog2` VALUES (105, '运动鞋包', 17);
INSERT INTO `pms_base_catalog2` VALUES (106, '运动服饰', 17);
INSERT INTO `pms_base_catalog2` VALUES (107, '骑行运动', 17);
INSERT INTO `pms_base_catalog2` VALUES (108, '垂钓用品', 17);
INSERT INTO `pms_base_catalog2` VALUES (109, '游泳用品', 17);
INSERT INTO `pms_base_catalog2` VALUES (110, '户外鞋服', 17);
INSERT INTO `pms_base_catalog2` VALUES (111, '户外装备', 17);
INSERT INTO `pms_base_catalog2` VALUES (112, '健身训练', 17);
INSERT INTO `pms_base_catalog2` VALUES (113, '体育用品', 17);
INSERT INTO `pms_base_catalog2` VALUES (114, '适用年龄', 18);
INSERT INTO `pms_base_catalog2` VALUES (115, '遥控/电动', 18);
INSERT INTO `pms_base_catalog2` VALUES (116, '毛绒布艺', 18);
INSERT INTO `pms_base_catalog2` VALUES (117, '娃娃玩具', 18);
INSERT INTO `pms_base_catalog2` VALUES (118, '模型玩具', 18);
INSERT INTO `pms_base_catalog2` VALUES (119, '健身玩具', 18);
INSERT INTO `pms_base_catalog2` VALUES (120, '动漫玩具', 18);
INSERT INTO `pms_base_catalog2` VALUES (121, '益智玩具', 18);
INSERT INTO `pms_base_catalog2` VALUES (122, '积木拼插', 18);
INSERT INTO `pms_base_catalog2` VALUES (123, 'DIY玩具', 18);
INSERT INTO `pms_base_catalog2` VALUES (124, '创意减压', 18);
INSERT INTO `pms_base_catalog2` VALUES (125, '乐器', 18);
INSERT INTO `pms_base_catalog2` VALUES (126, '彩票', 19);
INSERT INTO `pms_base_catalog2` VALUES (127, '机票', 19);
INSERT INTO `pms_base_catalog2` VALUES (128, '酒店', 19);
INSERT INTO `pms_base_catalog2` VALUES (129, '旅行', 19);
INSERT INTO `pms_base_catalog2` VALUES (130, '充值', 19);
INSERT INTO `pms_base_catalog2` VALUES (131, '游戏', 19);
INSERT INTO `pms_base_catalog2` VALUES (132, '票务', 19);
INSERT INTO `pms_base_catalog2` VALUES (133, '产地直供', 20);
INSERT INTO `pms_base_catalog2` VALUES (134, '水果', 20);
INSERT INTO `pms_base_catalog2` VALUES (135, '猪牛羊肉', 20);
INSERT INTO `pms_base_catalog2` VALUES (136, '海鲜水产', 20);
INSERT INTO `pms_base_catalog2` VALUES (137, '禽肉蛋品', 20);
INSERT INTO `pms_base_catalog2` VALUES (138, '冷冻食品', 20);
INSERT INTO `pms_base_catalog2` VALUES (139, '熟食腊味', 20);
INSERT INTO `pms_base_catalog2` VALUES (140, '饮品甜品', 20);
INSERT INTO `pms_base_catalog2` VALUES (141, '蔬菜', 20);
INSERT INTO `pms_base_catalog2` VALUES (142, '全新整车', 21);
INSERT INTO `pms_base_catalog2` VALUES (143, '二手车', 21);
-- ----------------------------
-- Table structure for pms_base_catalog3
-- ----------------------------
DROP TABLE IF EXISTS `pms_base_catalog3`;
CREATE TABLE `pms_base_catalog3` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
`name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '三级分类名称',
`catalog2_id` bigint(20) NULL DEFAULT NULL COMMENT '二级分类编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1259 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of pms_base_catalog3
-- ----------------------------
INSERT INTO `pms_base_catalog3` VALUES (1, '电子书', 1);
INSERT INTO `pms_base_catalog3` VALUES (2, '网络原创', 1);
INSERT INTO `pms_base_catalog3` VALUES (3, '数字杂志', 1);
INSERT INTO `pms_base_catalog3` VALUES (4, '多媒体图书', 1);
INSERT INTO `pms_base_catalog3` VALUES (5, '音乐', 2);
INSERT INTO `pms_base_catalog3` VALUES (6, '影视', 2);
INSERT INTO `pms_base_catalog3` VALUES (7, '教育音像', 2);
INSERT INTO `pms_base_catalog3` VALUES (8, '少儿', 3);
INSERT INTO `pms_base_catalog3` VALUES (9, '商务投资', 3);
INSERT INTO `pms_base_catalog3` VALUES (10, '英语学习与考试', 3);
INSERT INTO `pms_base_catalog3` VALUES (11, '文学', 3);
INSERT INTO `pms_base_catalog3` VALUES (12, '传记', 3);
INSERT INTO `pms_base_catalog3` VALUES (13, '励志', 3);
INSERT INTO `pms_base_catalog3` VALUES (14, '小说', 4);
INSERT INTO `pms_base_catalog3` VALUES (15, '文学', 4);
INSERT INTO `pms_base_catalog3` VALUES (16, '青春文学', 4);
INSERT INTO `pms_base_catalog3` VALUES (17, '传记', 4);
INSERT INTO `pms_base_catalog3` VALUES (18, '艺术', 4);
INSERT INTO `pms_base_catalog3` VALUES (19, '少儿', 5);
INSERT INTO `pms_base_catalog3` VALUES (20, '0-2岁', 5);
INSERT INTO `pms_base_catalog3` VALUES (21, '3-6岁', 5);
INSERT INTO `pms_base_catalog3` VALUES (22, '7-10岁', 5);
INSERT INTO `pms_base_catalog3` VALUES (23, '11-14岁', 5);
INSERT INTO `pms_base_catalog3` VALUES (24, '历史', 6);
INSERT INTO `pms_base_catalog3` VALUES (25, '哲学', 6);
INSERT INTO `pms_base_catalog3` VALUES (26, '国学', 6);
INSERT INTO `pms_base_catalog3` VALUES (27, '政治/军事', 6);
INSERT INTO `pms_base_catalog3` VALUES (28, '法律', 6);
INSERT INTO `pms_base_catalog3` VALUES (29, '人文社科', 6);
INSERT INTO `pms_base_catalog3` VALUES (30, '心理学', 6);
INSERT INTO `pms_base_catalog3` VALUES (31, '文化', 6);
INSERT INTO `pms_base_catalog3` VALUES (32, '社会科学', 6);
INSERT INTO `pms_base_catalog3` VALUES (33, '经济', 7);
INSERT INTO `pms_base_catalog3` VALUES (34, '金融与投资', 7);
INSERT INTO `pms_base_catalog3` VALUES (35, '管理', 7);
INSERT INTO `pms_base_catalog3` VALUES (36, '励志与成功', 7);
INSERT INTO `pms_base_catalog3` VALUES (37, '生活', 8);
INSERT INTO `pms_base_catalog3` VALUES (38, '健身与保健', 8);
INSERT INTO `pms_base_catalog3` VALUES (39, '家庭与育儿', 8);
INSERT INTO `pms_base_catalog3` VALUES (40, '旅游', 8);
INSERT INTO `pms_base_catalog3` VALUES (41, '烹饪美食', 8);
INSERT INTO `pms_base_catalog3` VALUES (42, '工业技术', 9);
INSERT INTO `pms_base_catalog3` VALUES (43, '科普读物', 9);
INSERT INTO `pms_base_catalog3` VALUES (44, '建筑', 9);
INSERT INTO `pms_base_catalog3` VALUES (45, '医学', 9);
INSERT INTO `pms_base_catalog3` VALUES (46, '科学与自然', 9);
INSERT INTO `pms_base_catalog3` VALUES (47, '计算机与互联网', 9);
INSERT INTO `pms_base_catalog3` VALUES (48, '电子通信', 9);
INSERT INTO `pms_base_catalog3` VALUES (49, '中小学教辅', 10);
INSERT INTO `pms_base_catalog3` VALUES (50, '教育与考试', 10);
INSERT INTO `pms_base_catalog3` VALUES (51, '外语学习', 10);
INSERT INTO `pms_base_catalog3` VALUES (52, '大中专教材', 10);
INSERT INTO `pms_base_catalog3` VALUES (53, '字典词典', 10);
INSERT INTO `pms_base_catalog3` VALUES (54, '艺术/设计/收藏', 11);
INSERT INTO `pms_base_catalog3` VALUES (55, '经济管理', 11);
INSERT INTO `pms_base_catalog3` VALUES (56, '文化/学术', 11);
INSERT INTO `pms_base_catalog3` VALUES (57, '少儿', 11);
INSERT INTO `pms_base_catalog3` VALUES (58, '工具书', 12);
INSERT INTO `pms_base_catalog3` VALUES (59, '杂志/期刊', 12);
INSERT INTO `pms_base_catalog3` VALUES (60, '套装书', 12);
INSERT INTO `pms_base_catalog3` VALUES (61, '手机', 13);
INSERT INTO `pms_base_catalog3` VALUES (62, '对讲机', 13);
INSERT INTO `pms_base_catalog3` VALUES (63, '合约机', 14);
INSERT INTO `pms_base_catalog3` VALUES (64, '选号中心', 14);
INSERT INTO `pms_base_catalog3` VALUES (65, '装宽带', 14);
INSERT INTO `pms_base_catalog3` VALUES (66, '办套餐', 14);
INSERT INTO `pms_base_catalog3` VALUES (67, '移动电源', 15);
INSERT INTO `pms_base_catalog3` VALUES (68, '电池/移动电源', 15);
INSERT INTO `pms_base_catalog3` VALUES (69, '蓝牙耳机', 15);
INSERT INTO `pms_base_catalog3` VALUES (70, '充电器/数据线', 15);
INSERT INTO `pms_base_catalog3` VALUES (71, '苹果周边', 15);
INSERT INTO `pms_base_catalog3` VALUES (72, '手机耳机', 15);
INSERT INTO `pms_base_catalog3` VALUES (73, '手机贴膜', 15);
INSERT INTO `pms_base_catalog3` VALUES (74, '手机存储卡', 15);
INSERT INTO `pms_base_catalog3` VALUES (75, '充电器', 15);
INSERT INTO `pms_base_catalog3` VALUES (76, '数据线', 15);
INSERT INTO `pms_base_catalog3` VALUES (77, '手机保护套', 15);
INSERT INTO `pms_base_catalog3` VALUES (78, '车载配件', 15);
INSERT INTO `pms_base_catalog3` VALUES (79, 'iPhone 配件', 15);
INSERT INTO `pms_base_catalog3` VALUES (80, '手机电池', 15);
INSERT INTO `pms_base_catalog3` VALUES (81, '创意配件', 15);
INSERT INTO `pms_base_catalog3` VALUES (82, '便携/无线音响', 15);
INSERT INTO `pms_base_catalog3` VALUES (83, '手机饰品', 15);
INSERT INTO `pms_base_catalog3` VALUES (84, '拍照配件', 15);
INSERT INTO `pms_base_catalog3` VALUES (85, '手机支架', 15);
INSERT INTO `pms_base_catalog3` VALUES (86, '平板电视', 16);
INSERT INTO `pms_base_catalog3` VALUES (87, '空调', 16);
INSERT INTO `pms_base_catalog3` VALUES (88, '冰箱', 16);
INSERT INTO `pms_base_catalog3` VALUES (89, '洗衣机', 16);
INSERT INTO `pms_base_catalog3` VALUES (90, '家庭影院', 16);
INSERT INTO `pms_base_catalog3` VALUES (91, 'DVD/电视盒子', 16);
INSERT INTO `pms_base_catalog3` VALUES (92, '迷你音响', 16);
INSERT INTO `pms_base_catalog3` VALUES (93, '冷柜/冰吧', 16);
INSERT INTO `pms_base_catalog3` VALUES (94, '家电配件', 16);
INSERT INTO `pms_base_catalog3` VALUES (95, '功放', 16);
INSERT INTO `pms_base_catalog3` VALUES (96, '回音壁/Soundbar', 16);
INSERT INTO `pms_base_catalog3` VALUES (97, 'Hi-Fi专区', 16);
INSERT INTO `pms_base_catalog3` VALUES (98, '电视盒子', 16);
INSERT INTO `pms_base_catalog3` VALUES (99, '酒柜', 16);
INSERT INTO `pms_base_catalog3` VALUES (100, '燃气灶', 17);
INSERT INTO `pms_base_catalog3` VALUES (101, '油烟机', 17);
INSERT INTO `pms_base_catalog3` VALUES (102, '热水器', 17);
INSERT INTO `pms_base_catalog3` VALUES (103, '消毒柜', 17);
INSERT INTO `pms_base_catalog3` VALUES (104, '洗碗机', 17);
INSERT INTO `pms_base_catalog3` VALUES (105, '料理机', 18);
INSERT INTO `pms_base_catalog3` VALUES (106, '榨汁机', 18);
INSERT INTO `pms_base_catalog3` VALUES (107, '电饭煲', 18);
INSERT INTO `pms_base_catalog3` VALUES (108, '电压力锅', 18);
INSERT INTO `pms_base_catalog3` VALUES (109, '豆浆机', 18);
INSERT INTO `pms_base_catalog3` VALUES (110, '咖啡机', 18);
INSERT INTO `pms_base_catalog3` VALUES (111, '微波炉', 18);
INSERT INTO `pms_base_catalog3` VALUES (112, '电烤箱', 18);
INSERT INTO `pms_base_catalog3` VALUES (113, '电磁炉', 18);
INSERT INTO `pms_base_catalog3` VALUES (114, '面包机', 18);
INSERT INTO `pms_base_catalog3` VALUES (115, '煮蛋器', 18);
INSERT INTO `pms_base_catalog3` VALUES (116, '酸奶机', 18);
INSERT INTO `pms_base_catalog3` VALUES (117, '电炖锅', 18);
INSERT INTO `pms_base_catalog3` VALUES (118, '电水壶/热水瓶', 18);
INSERT INTO `pms_base_catalog3` VALUES (119, '电饼铛', 18);
INSERT INTO `pms_base_catalog3` VALUES (120, '多用途锅', 18);
INSERT INTO `pms_base_catalog3` VALUES (121, '电烧烤炉', 18);
INSERT INTO `pms_base_catalog3` VALUES (122, '果蔬解毒机', 18);
INSERT INTO `pms_base_catalog3` VALUES (123, '其它厨房电器', 18);
INSERT INTO `pms_base_catalog3` VALUES (124, '养生壶/煎药壶', 18);
INSERT INTO `pms_base_catalog3` VALUES (125, '电热饭盒', 18);
INSERT INTO `pms_base_catalog3` VALUES (126, '取暖电器', 19);
INSERT INTO `pms_base_catalog3` VALUES (127, '净化器', 19);
INSERT INTO `pms_base_catalog3` VALUES (128, '加湿器', 19);
INSERT INTO `pms_base_catalog3` VALUES (129, '扫地机器人', 19);
INSERT INTO `pms_base_catalog3` VALUES (130, '吸尘器', 19);
INSERT INTO `pms_base_catalog3` VALUES (131, '挂烫机/熨斗', 19);
INSERT INTO `pms_base_catalog3` VALUES (132, '插座', 19);
INSERT INTO `pms_base_catalog3` VALUES (133, '电话机', 19);
INSERT INTO `pms_base_catalog3` VALUES (134, '清洁机', 19);
INSERT INTO `pms_base_catalog3` VALUES (135, '除湿机', 19);
INSERT INTO `pms_base_catalog3` VALUES (136, '干衣机', 19);
INSERT INTO `pms_base_catalog3` VALUES (137, '收录/音机', 19);
INSERT INTO `pms_base_catalog3` VALUES (138, '电风扇', 19);
INSERT INTO `pms_base_catalog3` VALUES (139, '冷风扇', 19);
INSERT INTO `pms_base_catalog3` VALUES (140, '其它生活电器', 19);
INSERT INTO `pms_base_catalog3` VALUES (141, '生活电器配件', 19);
INSERT INTO `pms_base_catalog3` VALUES (142, '净水器', 19);
INSERT INTO `pms_base_catalog3` VALUES (143, '饮水机', 19);
INSERT INTO `pms_base_catalog3` VALUES (144, '剃须刀', 20);
INSERT INTO `pms_base_catalog3` VALUES (145, '剃/脱毛器', 20);
INSERT INTO `pms_base_catalog3` VALUES (146, '口腔护理', 20);
INSERT INTO `pms_base_catalog3` VALUES (147, '电吹风', 20);
INSERT INTO `pms_base_catalog3` VALUES (148, '美容器', 20);
INSERT INTO `pms_base_catalog3` VALUES (149, '理发器', 20);
INSERT INTO `pms_base_catalog3` VALUES (150, '卷/直发器', 20);
INSERT INTO `pms_base_catalog3` VALUES (151, '按摩椅', 20);
INSERT INTO `pms_base_catalog3` VALUES (152, '按摩器', 20);
INSERT INTO `pms_base_catalog3` VALUES (153, '足浴盆', 20);
INSERT INTO `pms_base_catalog3` VALUES (154, '血压计', 20);
INSERT INTO `pms_base_catalog3` VALUES (155, '电子秤/厨房秤', 20);
INSERT INTO `pms_base_catalog3` VALUES (156, '血糖仪', 20);
INSERT INTO `pms_base_catalog3` VALUES (157, '体温计', 20);
INSERT INTO `pms_base_catalog3` VALUES (158, '其它健康电器', 20);
INSERT INTO `pms_base_catalog3` VALUES (159, '计步器/脂肪检测仪', 20);
INSERT INTO `pms_base_catalog3` VALUES (160, '电动工具', 21);
INSERT INTO `pms_base_catalog3` VALUES (161, '手动工具', 21);
INSERT INTO `pms_base_catalog3` VALUES (162, '仪器仪表', 21);
INSERT INTO `pms_base_catalog3` VALUES (163, '浴霸/排气扇', 21);
INSERT INTO `pms_base_catalog3` VALUES (164, '灯具', 21);
INSERT INTO `pms_base_catalog3` VALUES (165, 'LED灯', 21);
INSERT INTO `pms_base_catalog3` VALUES (166, '洁身器', 21);
INSERT INTO `pms_base_catalog3` VALUES (167, '水槽', 21);
INSERT INTO `pms_base_catalog3` VALUES (168, '龙头', 21);
INSERT INTO `pms_base_catalog3` VALUES (169, '淋浴花洒', 21);
INSERT INTO `pms_base_catalog3` VALUES (170, '厨卫五金', 21);
INSERT INTO `pms_base_catalog3` VALUES (171, '家具五金', 21);
INSERT INTO `pms_base_catalog3` VALUES (172, '门铃', 21);
INSERT INTO `pms_base_catalog3` VALUES (173, '电气开关', 21);
INSERT INTO `pms_base_catalog3` VALUES (174, '插座', 21);
INSERT INTO `pms_base_catalog3` VALUES (175, '电工电料', 21);
INSERT INTO `pms_base_catalog3` VALUES (176, '监控安防', 21);
INSERT INTO `pms_base_catalog3` VALUES (177, '电线/线缆', 21);
INSERT INTO `pms_base_catalog3` VALUES (178, '数码相机', 22);
INSERT INTO `pms_base_catalog3` VALUES (179, '单电/微单相机', 22);
INSERT INTO `pms_base_catalog3` VALUES (180, '单反相机', 22);
INSERT INTO `pms_base_catalog3` VALUES (181, '摄像机', 22);
INSERT INTO `pms_base_catalog3` VALUES (182, '拍立得', 22);
INSERT INTO `pms_base_catalog3` VALUES (183, '运动相机', 22);
INSERT INTO `pms_base_catalog3` VALUES (184, '镜头', 22);
INSERT INTO `pms_base_catalog3` VALUES (185, '户外器材', 22);
INSERT INTO `pms_base_catalog3` VALUES (186, '影棚器材', 22);
INSERT INTO `pms_base_catalog3` VALUES (187, '冲印服务', 22);
INSERT INTO `pms_base_catalog3` VALUES (188, '数码相框', 22);
INSERT INTO `pms_base_catalog3` VALUES (189, '存储卡', 23);
INSERT INTO `pms_base_catalog3` VALUES (190, '读卡器', 23);
INSERT INTO `pms_base_catalog3` VALUES (191, '滤镜', 23);
INSERT INTO `pms_base_catalog3` VALUES (192, '闪光灯/手柄', 23);
INSERT INTO `pms_base_catalog3` VALUES (193, '相机包', 23);
INSERT INTO `pms_base_catalog3` VALUES (194, '三脚架/云台', 23);
INSERT INTO `pms_base_catalog3` VALUES (195, '相机清洁/贴膜', 23);
INSERT INTO `pms_base_catalog3` VALUES (196, '机身附件', 23);
INSERT INTO `pms_base_catalog3` VALUES (197, '镜头附件', 23);
INSERT INTO `pms_base_catalog3` VALUES (198, '电池/充电器', 23);
INSERT INTO `pms_base_catalog3` VALUES (199, '移动电源', 23);
INSERT INTO `pms_base_catalog3` VALUES (200, '数码支架', 23);
INSERT INTO `pms_base_catalog3` VALUES (201, '智能手环', 24);
INSERT INTO `pms_base_catalog3` VALUES (202, '智能手表', 24);
INSERT INTO `pms_base_catalog3` VALUES (203, '智能眼镜', 24);
INSERT INTO `pms_base_catalog3` VALUES (204, '运动跟踪器', 24);
INSERT INTO `pms_base_catalog3` VALUES (205, '健康监测', 24);
INSERT INTO `pms_base_catalog3` VALUES (206, '智能配饰', 24);
INSERT INTO `pms_base_catalog3` VALUES (207, '智能家居', 24);
INSERT INTO `pms_base_catalog3` VALUES (208, '体感车', 24);
INSERT INTO `pms_base_catalog3` VALUES (209, '其他配件', 24);
INSERT INTO `pms_base_catalog3` VALUES (210, '智能机器人', 24);
INSERT INTO `pms_base_catalog3` VALUES (211, '无人机', 24);
INSERT INTO `pms_base_catalog3` VALUES (212, 'MP3/MP4', 25);
INSERT INTO `pms_base_catalog3` VALUES (213, '智能设备', 25);
INSERT INTO `pms_base_catalog3` VALUES (214, '耳机/耳麦', 25);
INSERT INTO `pms_base_catalog3` VALUES (215, '便携/无线音箱', 25);
INSERT INTO `pms_base_catalog3` VALUES (216, '音箱/音响', 25);
INSERT INTO `pms_base_catalog3` VALUES (217, '高清播放器', 25);
INSERT INTO `pms_base_catalog3` VALUES (218, '收音机', 25);
INSERT INTO `pms_base_catalog3` VALUES (219, 'MP3/MP4配件', 25);
INSERT INTO `pms_base_catalog3` VALUES (220, '麦克风', 25);
INSERT INTO `pms_base_catalog3` VALUES (221, '专业音频', 25);
INSERT INTO `pms_base_catalog3` VALUES (222, '苹果配件', 25);
INSERT INTO `pms_base_catalog3` VALUES (223, '学生平板', 26);
INSERT INTO `pms_base_catalog3` VALUES (224, '点读机/笔', 26);
INSERT INTO `pms_base_catalog3` VALUES (225, '早教益智', 26);
INSERT INTO `pms_base_catalog3` VALUES (226, '录音笔', 26);
INSERT INTO `pms_base_catalog3` VALUES (227, '电纸书', 26);
INSERT INTO `pms_base_catalog3` VALUES (228, '电子词典', 26);
INSERT INTO `pms_base_catalog3` VALUES (229, '复读机', 26);
INSERT INTO `pms_base_catalog3` VALUES (230, '延保服务', 27);
INSERT INTO `pms_base_catalog3` VALUES (231, '杀毒软件', 27);
INSERT INTO `pms_base_catalog3` VALUES (232, '积分商品', 27);
INSERT INTO `pms_base_catalog3` VALUES (233, '桌布/罩件', 28);
INSERT INTO `pms_base_catalog3` VALUES (234, '地毯地垫', 28);
INSERT INTO `pms_base_catalog3` VALUES (235, '沙发垫套/椅垫', 28);
INSERT INTO `pms_base_catalog3` VALUES (236, '床品套件', 28);
INSERT INTO `pms_base_catalog3` VALUES (237, '被子', 28);
INSERT INTO `pms_base_catalog3` VALUES (238, '枕芯', 28);
INSERT INTO `pms_base_catalog3` VALUES (239, '床单被罩', 28);
INSERT INTO `pms_base_catalog3` VALUES (240, '毯子', 28);
INSERT INTO `pms_base_catalog3` VALUES (241, '床垫/床褥', 28);
INSERT INTO `pms_base_catalog3` VALUES (242, '蚊帐', 28);
INSERT INTO `pms_base_catalog3` VALUES (243, '抱枕靠垫', 28);
INSERT INTO `pms_base_catalog3` VALUES (244, '毛巾浴巾', 28);
INSERT INTO `pms_base_catalog3` VALUES (245, '电热毯', 28);
INSERT INTO `pms_base_catalog3` VALUES (246, '窗帘/窗纱', 28);
INSERT INTO `pms_base_catalog3` VALUES (247, '布艺软饰', 28);
INSERT INTO `pms_base_catalog3` VALUES (248, '凉席', 28);
INSERT INTO `pms_base_catalog3` VALUES (249, '台灯', 29);
INSERT INTO `pms_base_catalog3` VALUES (250, '节能灯', 29);
INSERT INTO `pms_base_catalog3` VALUES (251, '装饰灯', 29);
INSERT INTO `pms_base_catalog3` VALUES (252, '落地灯', 29);
INSERT INTO `pms_base_catalog3` VALUES (253, '应急灯/手电', 29);
INSERT INTO `pms_base_catalog3` VALUES (254, 'LED灯', 29);
INSERT INTO `pms_base_catalog3` VALUES (255, '吸顶灯', 29);
INSERT INTO `pms_base_catalog3` VALUES (256, '五金电器', 29);
INSERT INTO `pms_base_catalog3` VALUES (257, '筒灯射灯', 29);
INSERT INTO `pms_base_catalog3` VALUES (258, '吊灯', 29);
INSERT INTO `pms_base_catalog3` VALUES (259, '氛围照明', 29);
INSERT INTO `pms_base_catalog3` VALUES (260, '保暖防护', 30);
INSERT INTO `pms_base_catalog3` VALUES (261, '收纳用品', 30);
INSERT INTO `pms_base_catalog3` VALUES (262, '雨伞雨具', 30);
INSERT INTO `pms_base_catalog3` VALUES (263, '浴室用品', 30);
INSERT INTO `pms_base_catalog3` VALUES (264, '缝纫/针织用品', 30);
INSERT INTO `pms_base_catalog3` VALUES (265, '洗晒/熨烫', 30);
INSERT INTO `pms_base_catalog3` VALUES (266, '净化除味', 30);
INSERT INTO `pms_base_catalog3` VALUES (267, '相框/照片墙', 31);
INSERT INTO `pms_base_catalog3` VALUES (268, '装饰字画', 31);
INSERT INTO `pms_base_catalog3` VALUES (269, '节庆饰品', 31);
INSERT INTO `pms_base_catalog3` VALUES (270, '手工/十字绣', 31);
INSERT INTO `pms_base_catalog3` VALUES (271, '装饰摆件', 31);
INSERT INTO `pms_base_catalog3` VALUES (272, '帘艺隔断', 31);
INSERT INTO `pms_base_catalog3` VALUES (273, '墙贴/装饰贴', 31);
INSERT INTO `pms_base_catalog3` VALUES (274, '钟饰', 31);
INSERT INTO `pms_base_catalog3` VALUES (275, '花瓶花艺', 31);
INSERT INTO `pms_base_catalog3` VALUES (276, '香薰蜡烛', 31);
INSERT INTO `pms_base_catalog3` VALUES (277, '创意家居', 31);
INSERT INTO `pms_base_catalog3` VALUES (278, '宠物主粮', 32);
INSERT INTO `pms_base_catalog3` VALUES (279, '宠物零食', 32);
INSERT INTO `pms_base_catalog3` VALUES (280, '医疗保健', 32);
INSERT INTO `pms_base_catalog3` VALUES (281, '家居日用', 32);
INSERT INTO `pms_base_catalog3` VALUES (282, '宠物玩具', 32);
INSERT INTO `pms_base_catalog3` VALUES (283, '出行装备', 32);
INSERT INTO `pms_base_catalog3` VALUES (284, '洗护美容', 32);
INSERT INTO `pms_base_catalog3` VALUES (285, '笔记本', 33);
INSERT INTO `pms_base_catalog3` VALUES (286, '超极本', 33);
INSERT INTO `pms_base_catalog3` VALUES (287, '游戏本', 33);
INSERT INTO `pms_base_catalog3` VALUES (288, '平板电脑', 33);
INSERT INTO `pms_base_catalog3` VALUES (289, '平板电脑配件', 33);
INSERT INTO `pms_base_catalog3` VALUES (290, '台式机', 33);
INSERT INTO `pms_base_catalog3` VALUES (291, '服务器/工作站', 33);
INSERT INTO `pms_base_catalog3` VALUES (292, '笔记本配件', 33);
INSERT INTO `pms_base_catalog3` VALUES (293, '一体机', 33);
INSERT INTO `pms_base_catalog3` VALUES (294, 'CPU', 34);
INSERT INTO `pms_base_catalog3` VALUES (295, '主板', 34);
INSERT INTO `pms_base_catalog3` VALUES (296, '显卡', 34);
INSERT INTO `pms_base_catalog3` VALUES (297, '硬盘', 34);
INSERT INTO `pms_base_catalog3` VALUES (298, 'SSD固态硬盘', 34);
INSERT INTO `pms_base_catalog3` VALUES (299, '内存', 34);
INSERT INTO `pms_base_catalog3` VALUES (300, '机箱', 34);
INSERT INTO `pms_base_catalog3` VALUES (301, '电源', 34);
INSERT INTO `pms_base_catalog3` VALUES (302, '显示器', 34);
INSERT INTO `pms_base_catalog3` VALUES (303, '刻录机/光驱', 34);
INSERT INTO `pms_base_catalog3` VALUES (304, '散热器', 34);
INSERT INTO `pms_base_catalog3` VALUES (305, '声卡/扩展卡', 34);
INSERT INTO `pms_base_catalog3` VALUES (306, '装机配件', 34);
INSERT INTO `pms_base_catalog3` VALUES (307, '组装电脑', 34);
INSERT INTO `pms_base_catalog3` VALUES (308, '移动硬盘', 35);
INSERT INTO `pms_base_catalog3` VALUES (309, 'U盘', 35);
INSERT INTO `pms_base_catalog3` VALUES (310, '鼠标', 35);
INSERT INTO `pms_base_catalog3` VALUES (311, '键盘', 35);
INSERT INTO `pms_base_catalog3` VALUES (312, '鼠标垫', 35);
INSERT INTO `pms_base_catalog3` VALUES (313, '摄像头', 35);
INSERT INTO `pms_base_catalog3` VALUES (314, '手写板', 35);
INSERT INTO `pms_base_catalog3` VALUES (315, '硬盘盒', 35);
INSERT INTO `pms_base_catalog3` VALUES (316, '插座', 35);
INSERT INTO `pms_base_catalog3` VALUES (317, '线缆', 35);
INSERT INTO `pms_base_catalog3` VALUES (318, 'UPS电源', 35);
INSERT INTO `pms_base_catalog3` VALUES (319, '电脑工具', 35);
INSERT INTO `pms_base_catalog3` VALUES (320, '游戏设备', 35);
INSERT INTO `pms_base_catalog3` VALUES (321, '电玩', 35);
INSERT INTO `pms_base_catalog3` VALUES (322, '电脑清洁', 35);
INSERT INTO `pms_base_catalog3` VALUES (323, '网络仪表仪器', 35);
INSERT INTO `pms_base_catalog3` VALUES (324, '游戏机', 36);
INSERT INTO `pms_base_catalog3` VALUES (325, '游戏耳机', 36);
INSERT INTO `pms_base_catalog3` VALUES (326, '手柄/方向盘', 36);
INSERT INTO `pms_base_catalog3` VALUES (327, '游戏软件', 36);
INSERT INTO `pms_base_catalog3` VALUES (328, '游戏周边', 36);
INSERT INTO `pms_base_catalog3` VALUES (329, '路由器', 37);
INSERT INTO `pms_base_catalog3` VALUES (330, '网卡', 37);
INSERT INTO `pms_base_catalog3` VALUES (331, '交换机', 37);
INSERT INTO `pms_base_catalog3` VALUES (332, '网络存储', 37);
INSERT INTO `pms_base_catalog3` VALUES (333, '4G/3G上网', 37);
INSERT INTO `pms_base_catalog3` VALUES (334, '网络盒子', 37);
INSERT INTO `pms_base_catalog3` VALUES (335, '网络配件', 37);
INSERT INTO `pms_base_catalog3` VALUES (336, '投影机', 38);
INSERT INTO `pms_base_catalog3` VALUES (337, '投影配件', 38);
INSERT INTO `pms_base_catalog3` VALUES (338, '多功能一体机', 38);
INSERT INTO `pms_base_catalog3` VALUES (339, '打印机', 38);
INSERT INTO `pms_base_catalog3` VALUES (340, '传真设备', 38);
INSERT INTO `pms_base_catalog3` VALUES (341, '验钞/点钞机', 38);
INSERT INTO `pms_base_catalog3` VALUES (342, '扫描设备', 38);
INSERT INTO `pms_base_catalog3` VALUES (343, '复合机', 38);
INSERT INTO `pms_base_catalog3` VALUES (344, '碎纸机', 38);
INSERT INTO `pms_base_catalog3` VALUES (345, '考勤机', 38);
INSERT INTO `pms_base_catalog3` VALUES (346, '收款/POS机', 38);
INSERT INTO `pms_base_catalog3` VALUES (347, '会议音频视频', 38);
INSERT INTO `pms_base_catalog3` VALUES (348, '保险柜', 38);
INSERT INTO `pms_base_catalog3` VALUES (349, '装订/封装机', 38);
INSERT INTO `pms_base_catalog3` VALUES (350, '安防监控', 38);
INSERT INTO `pms_base_catalog3` VALUES (351, '办公家具', 38);
INSERT INTO `pms_base_catalog3` VALUES (352, '白板', 38);
INSERT INTO `pms_base_catalog3` VALUES (353, '硒鼓/墨粉', 39);
INSERT INTO `pms_base_catalog3` VALUES (354, '墨盒', 39);
INSERT INTO `pms_base_catalog3` VALUES (355, '色带', 39);
INSERT INTO `pms_base_catalog3` VALUES (356, '纸类', 39);
INSERT INTO `pms_base_catalog3` VALUES (357, '办公文具', 39);
INSERT INTO `pms_base_catalog3` VALUES (358, '学生文具', 39);
INSERT INTO `pms_base_catalog3` VALUES (359, '财会用品', 39);
INSERT INTO `pms_base_catalog3` VALUES (360, '文件管理', 39);
INSERT INTO `pms_base_catalog3` VALUES (361, '本册/便签', 39);
INSERT INTO `pms_base_catalog3` VALUES (362, '计算器', 39);
INSERT INTO `pms_base_catalog3` VALUES (363, '笔类', 39);
INSERT INTO `pms_base_catalog3` VALUES (364, '画具画材', 39);
INSERT INTO `pms_base_catalog3` VALUES (365, '刻录碟片/附件', 39);
INSERT INTO `pms_base_catalog3` VALUES (366, '上门安装', 40);
INSERT INTO `pms_base_catalog3` VALUES (367, '延保服务', 40);
INSERT INTO `pms_base_catalog3` VALUES (368, '维修保养', 40);
INSERT INTO `pms_base_catalog3` VALUES (369, '电脑软件', 40);
INSERT INTO `pms_base_catalog3` VALUES (370, '京东服务', 40);
INSERT INTO `pms_base_catalog3` VALUES (371, '炒锅', 41);
INSERT INTO `pms_base_catalog3` VALUES (372, '煎锅', 41);
INSERT INTO `pms_base_catalog3` VALUES (373, '压力锅', 41);
INSERT INTO `pms_base_catalog3` VALUES (374, '蒸锅', 41);
INSERT INTO `pms_base_catalog3` VALUES (375, '汤锅', 41);
INSERT INTO `pms_base_catalog3` VALUES (376, '奶锅', 41);
INSERT INTO `pms_base_catalog3` VALUES (377, '锅具套装', 41);
INSERT INTO `pms_base_catalog3` VALUES (378, '煲类', 41);
INSERT INTO `pms_base_catalog3` VALUES (379, '水壶', 41);
INSERT INTO `pms_base_catalog3` VALUES (380, '火锅', 41);
INSERT INTO `pms_base_catalog3` VALUES (381, '菜刀', 42);
INSERT INTO `pms_base_catalog3` VALUES (382, '剪刀', 42);
INSERT INTO `pms_base_catalog3` VALUES (383, '刀具套装', 42);
INSERT INTO `pms_base_catalog3` VALUES (384, '砧板', 42);
INSERT INTO `pms_base_catalog3` VALUES (385, '瓜果刀/刨', 42);
INSERT INTO `pms_base_catalog3` VALUES (386, '多功能刀', 42);
INSERT INTO `pms_base_catalog3` VALUES (387, '保鲜盒', 43);
INSERT INTO `pms_base_catalog3` VALUES (388, '烘焙/烧烤', 43);
INSERT INTO `pms_base_catalog3` VALUES (389, '饭盒/提锅', 43);
INSERT INTO `pms_base_catalog3` VALUES (390, '储物/置物架', 43);
INSERT INTO `pms_base_catalog3` VALUES (391, '厨房DIY/小工具', 43);
INSERT INTO `pms_base_catalog3` VALUES (392, '塑料杯', 44);
INSERT INTO `pms_base_catalog3` VALUES (393, '运动水壶', 44);
INSERT INTO `pms_base_catalog3` VALUES (394, '玻璃杯', 44);
INSERT INTO `pms_base_catalog3` VALUES (395, '陶瓷/马克杯', 44);
INSERT INTO `pms_base_catalog3` VALUES (396, '保温杯', 44);
INSERT INTO `pms_base_catalog3` VALUES (397, '保温壶', 44);
INSERT INTO `pms_base_catalog3` VALUES (398, '酒杯/酒具', 44);
INSERT INTO `pms_base_catalog3` VALUES (399, '杯具套装', 44);
INSERT INTO `pms_base_catalog3` VALUES (400, '餐具套装', 45);
INSERT INTO `pms_base_catalog3` VALUES (401, '碗/碟/盘', 45);
INSERT INTO `pms_base_catalog3` VALUES (402, '筷勺/刀叉', 45);
INSERT INTO `pms_base_catalog3` VALUES (403, '一次性用品', 45);
INSERT INTO `pms_base_catalog3` VALUES (404, '果盘/果篮', 45);
INSERT INTO `pms_base_catalog3` VALUES (405, '自助餐炉', 46);
INSERT INTO `pms_base_catalog3` VALUES (406, '酒店餐具', 46);
INSERT INTO `pms_base_catalog3` VALUES (407, '酒店水具', 46);
INSERT INTO `pms_base_catalog3` VALUES (408, '整套茶具', 47);
INSERT INTO `pms_base_catalog3` VALUES (409, '茶杯', 47);
INSERT INTO `pms_base_catalog3` VALUES (410, '茶壶', 47);
INSERT INTO `pms_base_catalog3` VALUES (411, '茶盘茶托', 47);
INSERT INTO `pms_base_catalog3` VALUES (412, '茶叶罐', 47);
INSERT INTO `pms_base_catalog3` VALUES (413, '茶具配件', 47);
INSERT INTO `pms_base_catalog3` VALUES (414, '茶宠摆件', 47);
INSERT INTO `pms_base_catalog3` VALUES (415, '咖啡具', 47);
INSERT INTO `pms_base_catalog3` VALUES (416, '其他', 47);
INSERT INTO `pms_base_catalog3` VALUES (417, '纸品湿巾', 48);
INSERT INTO `pms_base_catalog3` VALUES (418, '衣物清洁', 48);
INSERT INTO `pms_base_catalog3` VALUES (419, '清洁工具', 48);
INSERT INTO `pms_base_catalog3` VALUES (420, '驱虫用品', 48);
INSERT INTO `pms_base_catalog3` VALUES (421, '家庭清洁', 48);
INSERT INTO `pms_base_catalog3` VALUES (422, '皮具护理', 48);
INSERT INTO `pms_base_catalog3` VALUES (423, '一次性用品', 48);
INSERT INTO `pms_base_catalog3` VALUES (424, '洁面', 49);
INSERT INTO `pms_base_catalog3` VALUES (425, '乳液面霜', 49);
INSERT INTO `pms_base_catalog3` VALUES (426, '面膜', 49);
INSERT INTO `pms_base_catalog3` VALUES (427, '剃须', 49);
INSERT INTO `pms_base_catalog3` VALUES (428, '套装', 49);
INSERT INTO `pms_base_catalog3` VALUES (429, '精华', 49);
INSERT INTO `pms_base_catalog3` VALUES (430, '眼霜', 49);
INSERT INTO `pms_base_catalog3` VALUES (431, '卸妆', 49);
INSERT INTO `pms_base_catalog3` VALUES (432, '防晒', 49);
INSERT INTO `pms_base_catalog3` VALUES (433, '防晒隔离', 49);
INSERT INTO `pms_base_catalog3` VALUES (434, 'T区护理', 49);
INSERT INTO `pms_base_catalog3` VALUES (435, '眼部护理', 49);
INSERT INTO `pms_base_catalog3` VALUES (436, '精华露', 49);
INSERT INTO `pms_base_catalog3` VALUES (437, '爽肤水', 49);