-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy pathhyperf-amazon.sql
1811 lines (1751 loc) · 129 KB
/
hyperf-amazon.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 : laradock
Source Server Type : MySQL
Source Server Version : 50739
Source Host : 127.0.0.1:3306
Source Schema : hyperf
Target Server Type : MySQL
Target Server Version : 50739
File Encoding : 65001
Date: 27/01/2024 00:18:26
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for amazon_app
-- ----------------------------
DROP TABLE IF EXISTS `amazon_app`;
CREATE TABLE `amazon_app` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(10) unsigned NOT NULL COMMENT '商户id',
`merchant_store_id` int(10) unsigned NOT NULL COMMENT '商户店铺ID',
`seller_id` varchar(128) NOT NULL DEFAULT '' COMMENT '亚马逊seller_id merchant_store.unique_id',
`app_id` varchar(128) NOT NULL DEFAULT '' COMMENT '应用程序 ID',
`app_name` varchar(128) NOT NULL DEFAULT '' COMMENT '应用名称',
`aws_access_key` varchar(128) NOT NULL DEFAULT '' COMMENT 'Aws Access Key',
`aws_secret_key` varchar(128) NOT NULL DEFAULT '' COMMENT 'Aws Secret Key',
`user_arn` varchar(255) NOT NULL DEFAULT '' COMMENT 'User ARN',
`role_arn` varchar(255) NOT NULL DEFAULT '' COMMENT 'ROLE ARN',
`lwa_client_id` varchar(255) NOT NULL DEFAULT '' COMMENT '客户端编码lwaClientId',
`lwa_client_id_secret` varchar(255) NOT NULL DEFAULT '' COMMENT '客户端秘钥lwaClientIdSecret',
`status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态 0禁用 1啓用',
`created_at` datetime NOT NULL COMMENT '创建时间',
`updated_at` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Table structure for amazon_app_region
-- ----------------------------
DROP TABLE IF EXISTS `amazon_app_region`;
CREATE TABLE `amazon_app_region` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商户id',
`merchant_store_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '店铺id',
`amazon_app_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'amazon_app.id',
`region` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '地区',
`country_codes` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '国家(二字码)',
`refresh_token` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '刷新令牌',
`created_at` datetime DEFAULT NULL COMMENT '创建时间',
`updated_at` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for amazon_coupon
-- ----------------------------
DROP TABLE IF EXISTS `amazon_coupon`;
CREATE TABLE `amazon_coupon` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(10) unsigned NOT NULL,
`merchant_store_id` int(10) unsigned NOT NULL,
`promotion_id` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '优惠券ID',
`discount_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '折扣类型 PERCENT_OFF_LIST_PRICE百分比折扣/AMOUNT_OFF_LIST_PRICE金额折扣',
`discount_amount` int(10) unsigned NOT NULL COMMENT '折扣比例或金额',
`created_at` datetime NOT NULL COMMENT '创建时间',
`updated_at` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
KEY `promotion_idx` (`merchant_id`,`merchant_store_id`,`promotion_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for amazon_finance_group
-- ----------------------------
DROP TABLE IF EXISTS `amazon_finance_group`;
CREATE TABLE `amazon_finance_group` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商户id',
`merchant_store_id` int(10) NOT NULL COMMENT '店铺id',
`region` varchar(10) NOT NULL DEFAULT '' COMMENT '地区',
`financial_event_group_id` varchar(128) NOT NULL DEFAULT '' COMMENT '财务事件组的唯一标识符',
`processing_status` varchar(32) NOT NULL DEFAULT '' COMMENT '财务事件组的处理状态表示财务事件组的余额是否已结算。',
`fund_transfer_status` varchar(32) NOT NULL DEFAULT '' COMMENT '资金转移的状态',
`original_total_amount` varchar(20) NOT NULL DEFAULT '' COMMENT '发生交易的市场货币的总金额',
`original_total_code` varchar(32) NOT NULL DEFAULT '' COMMENT '发生交易的市场货币的总金额货币',
`converted_total_amount` varchar(10) NOT NULL DEFAULT '' COMMENT '支付资金的市场货币总额',
`converted_total_code` varchar(32) NOT NULL DEFAULT '' COMMENT '支付资金的市场货币总额货币',
`fund_transfer_date` varchar(20) NOT NULL DEFAULT '' COMMENT '开始支付或收费的日期和时间。仅适用于已关闭的事件组。采用 ISO 8601 日期时间格式。',
`trace_id` varchar(255) NOT NULL DEFAULT '' COMMENT '卖家用来在外部查找交易的跟踪标识符',
`account_tail` varchar(32) NOT NULL DEFAULT '' COMMENT '支付工具的账户尾数',
`beginning_balance_amount` varchar(10) NOT NULL DEFAULT '' COMMENT '期初余额',
`beginning_balance_code` varchar(32) NOT NULL DEFAULT '' COMMENT '期初余额货币',
`financial_event_group_start` varchar(20) NOT NULL DEFAULT '' COMMENT '打开财务事件组的日期和时间。采用 ISO 8601 日期时间格式',
`financial_event_group_end` varchar(20) NOT NULL DEFAULT '' COMMENT '财务事件组关闭的日期和时间。采用 ISO 8601 日期时间格式',
`created_at` datetime DEFAULT NULL COMMENT '系统创建时间',
`updated_at` datetime DEFAULT NULL COMMENT '系统更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=186 DEFAULT CHARSET=utf8mb4 COMMENT='亚马逊财务事件组';
-- ----------------------------
-- Table structure for amazon_finance_shipment_event_list
-- ----------------------------
DROP TABLE IF EXISTS `amazon_finance_shipment_event_list`;
CREATE TABLE `amazon_finance_shipment_event_list` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(10) unsigned NOT NULL COMMENT '商户id',
`merchant_store_id` int(10) unsigned NOT NULL COMMENT '店铺id',
`amazon_order_id` varchar(128) NOT NULL DEFAULT '' COMMENT '亚马逊订单id',
`seller_order_id` varchar(128) NOT NULL DEFAULT '' COMMENT '卖方定义的订单标识符。',
`marketplace_name` varchar(20) NOT NULL COMMENT '市场名称',
`order_charge_list` varchar(128) NOT NULL COMMENT '订单收费列表',
`order_charge_adjustment_list` varchar(128) NOT NULL COMMENT '订单费用调整列表',
`shipment_fee_adjustment_list` varchar(128) NOT NULL COMMENT '运费调整列表',
`order_fee_list` varchar(128) NOT NULL COMMENT '订单费列表',
`order_fee_adjustment_list` varchar(128) NOT NULL COMMENT '订单费调整列表',
`direct_payment_list` varchar(128) NOT NULL COMMENT '买家通过亚马逊提供的信用卡之一向亚马逊付款或买家直接通过COD向卖家付款的交易列表。',
`posted_date` datetime DEFAULT NULL COMMENT '发布财务事件的日期和时间。',
`shipment_item_list` varchar(255) NOT NULL COMMENT '装运物品清单',
`shipment_item_adjustment_list` varchar(255) NOT NULL COMMENT '装运项目调整清单',
`created_at` datetime NOT NULL COMMENT '创建时间',
`updated_at` datetime NOT NULL COMMENT '修改时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Table structure for amazon_inventory
-- ----------------------------
DROP TABLE IF EXISTS `amazon_inventory`;
CREATE TABLE `amazon_inventory` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(10) unsigned NOT NULL COMMENT '商户id',
`merchant_store_id` int(10) NOT NULL DEFAULT '0' COMMENT '店铺ID',
`region` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '地区',
`asin` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`fn_sku` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`seller_sku` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`product_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '商品名称',
`main_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '主图',
`product_type` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '产品类型',
`created_date` datetime DEFAULT NULL COMMENT 'listing创建时间',
`last_updated_date` datetime DEFAULT NULL COMMENT 'listing最后更新时间',
`condition` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '商品状态，例如"NewItem"',
`fulfillable_quantity` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '可履行数量',
`inbound_working_quantity` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '运输中、待上架数量',
`inbound_shipped_quantity` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '已运抵、待上架数量',
`inbound_receiving_quantity` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '正在接收的数量',
`total_reserved_quantity` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '总预留数量',
`pending_customer_order_quantity` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '等待顾客订单数量',
`pending_transshipment_quantity` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '等待转运数量',
`fc_processing_quantity` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'FBA中心处理中数量',
`total_researching_quantity` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '总调查数量',
`researching_quantity_in_short_term` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '短期内调查数量',
`researching_quantity_in_mid_term` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '中期内调查数量',
`researching_quantity_in_long_term` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '长期内调查数量',
`total_unfulfillable_quantity` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '总不可履行数量',
`customer_damaged_quantity` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '顾客损坏数量',
`warehouse_damaged_quantity` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '仓库损坏数量',
`distributor_damaged_quantity` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '经销商损坏数量',
`carrier_damaged_quantity` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '运输商损坏数量',
`defective_quantity` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '有缺陷数量',
`expired_quantity` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '已过期数量',
`last_updated_time` datetime DEFAULT NULL COMMENT '最后更新时间',
`total_quantity` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '总数量',
`country_ids` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '国家二字码',
`created_at` datetime NOT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=323 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='amazon-库存';
-- ----------------------------
-- Table structure for amazon_order
-- ----------------------------
DROP TABLE IF EXISTS `amazon_order`;
CREATE TABLE `amazon_order` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(10) unsigned NOT NULL COMMENT '商户id',
`merchant_store_id` int(10) unsigned NOT NULL COMMENT '店铺id',
`region` varchar(10) NOT NULL DEFAULT '' COMMENT '地区',
`amazon_order_id` varchar(128) NOT NULL DEFAULT '' COMMENT '亚马逊定义的订单标识符，格式为3-7-7',
`seller_order_id` varchar(128) NOT NULL DEFAULT '' COMMENT '卖家定义的订单标识符',
`purchase_date` datetime DEFAULT NULL COMMENT '订单创建时间',
`last_update_date` varchar(30) NOT NULL DEFAULT '' COMMENT '上次更新订单的日期',
`order_status` varchar(50) NOT NULL DEFAULT '' COMMENT '订单状态 Pending,Unshipped,PartiallyShipped,Shipped,Canceled,Unfulfillable,InvoiceUnconfirmed,PendingAvailability',
`fulfillment_channel` varchar(128) NOT NULL DEFAULT '' COMMENT '订单是由亚马逊（AFN）还是由卖方（MFN）完成 MFN,AFN',
`sales_channel` varchar(128) NOT NULL DEFAULT '' COMMENT '订单中第一项的销售渠道',
`order_channel` varchar(128) NOT NULL DEFAULT '' COMMENT '订单中第一项的订单通道',
`ship_service_level` varchar(128) NOT NULL DEFAULT '' COMMENT '订单的发货服务级别',
`order_total_currency` varchar(10) NOT NULL DEFAULT '' COMMENT '订单的总费用(货币)',
`order_total_amount` varchar(20) NOT NULL DEFAULT '' COMMENT '订单的总费用',
`number_of_items_shipped` tinyint(5) unsigned NOT NULL DEFAULT '0' COMMENT '装运的项目数',
`number_of_items_unshipped` tinyint(5) unsigned NOT NULL DEFAULT '0' COMMENT '未装运的项目数',
`payment_execution_detail` text NOT NULL COMMENT '关于货到付款（COD）订单的子付款方式的信息',
`payment_method` varchar(128) NOT NULL DEFAULT '' COMMENT '订单的付款方式。COD,CVS,Other 此属性仅限于货到付款（COD）和便利店（CVS）付款方式。除非您需要PaymentExecutionDetailItem对象提供的特定COD付款信息，否则建议使用PaymentMethodDetails属性获取付款方式信息。',
`payment_method_details` text NOT NULL COMMENT '订单的付款方式列表',
`marketplace_id` varchar(128) NOT NULL DEFAULT '' COMMENT '下订单的市场的标识符',
`shipment_service_level_category` varchar(128) NOT NULL DEFAULT '' COMMENT '订单的装运服务级别类别 Expedited, FreeEconomy, NextDay, SameDay, SecondDay, Scheduled, Standard.',
`easy_ship_shipment_status` varchar(128) NOT NULL DEFAULT '' COMMENT 'Amazon Easy Ship订单的状态。此属性仅适用于Amazon Easy Ship订单。',
`cba_displayable_shipping_label` varchar(128) NOT NULL DEFAULT '' COMMENT '亚马逊（CBA）结账的定制发货标签',
`order_type` varchar(128) NOT NULL DEFAULT '' COMMENT '订单类型 StandardOrder,LongLeadTimeOrder,Preorder,BackOrder,SourcingOnDemandOrder',
`earliest_ship_date` varchar(30) NOT NULL DEFAULT '' COMMENT '您承诺发货订单的时间段的开始。采用ISO 8601日期时间格式。仅针对卖方完成的订单退回。',
`latest_ship_date` varchar(30) NOT NULL DEFAULT '' COMMENT '您承诺发货订单的时间段结束',
`earliest_delivery_date` varchar(30) NOT NULL DEFAULT '' COMMENT '您承诺履行订单的时间段的开始。采用ISO 8601日期时间格式。仅针对卖方完成的订单退回。',
`latest_delivery_date` varchar(30) NOT NULL DEFAULT '' COMMENT '您承诺履行订单的期限结束。采用ISO 8601日期时间格式。仅针对卖家完成的订单返回，这些订单没有挂起可用性、挂起或取消状态',
`is_business_order` varchar(10) NOT NULL DEFAULT '' COMMENT '如果为true，则订单为Amazon Business订单。亚马逊商业订单是指买方是经验证的商业买家的订单',
`is_prime` varchar(10) NOT NULL DEFAULT '' COMMENT '如果为true，则订单是卖家完成的亚马逊Prime订单。',
`is_premium_order` varchar(10) NOT NULL DEFAULT '' COMMENT '如果为true，则订单具有“高级配送服务级别协议”。有关高级配送订单的更多信息，请参阅您所在市场的卖家中心帮助中的“高级配送选项”',
`is_global_express_enabled` varchar(10) NOT NULL DEFAULT '' COMMENT '如果为true，则订单为GlobalExpress订单',
`replaced_order_id` varchar(128) NOT NULL DEFAULT '' COMMENT '正在替换的订单的订单ID值。仅当IsReplacementOrder=true时返回。',
`is_replacement_order` varchar(10) NOT NULL DEFAULT '' COMMENT '如果为true，则这是替换订单。',
`promise_response_due_date` varchar(128) NOT NULL DEFAULT '' COMMENT '表示卖方必须以预计发货日期回复买方的日期。仅针对按需采购订单退回。',
`is_estimated_ship_date_set` varchar(128) NOT NULL DEFAULT '' COMMENT '如果为true，则为订单设置预计发货日期。仅针对按需采购订单退回',
`is_sold_by_ab` varchar(10) NOT NULL DEFAULT '' COMMENT '如果为true，则此订单中的商品由Amazon Business EU SARL（ABEU）购买并转售。通过购买并立即转售您的物品，ABEU成为记录的卖家，使您的库存可供不从第三方卖家购买的客户出售。',
`is_iba` varchar(128) NOT NULL DEFAULT '' COMMENT '如果为true，则此订单中的商品由Amazon Business EU SARL（ABEU）购买并转售。通过购买并立即转售您的物品，ABEU成为记录的卖家，使您的库存可供不从第三方卖家购买的客户出售。',
`default_ship_from_location_address` text NOT NULL COMMENT '卖方装运物品的推荐地点。结账时计算。卖方可以选择或不选择从该地点发货',
`buyer_invoice_preference` varchar(500) NOT NULL DEFAULT '' COMMENT '买方的发票偏好。仅在TR市场上可用',
`buyer_tax_information` text NOT NULL COMMENT '包含业务发票税务信息',
`fulfillment_instruction` text NOT NULL COMMENT '包含有关履行的说明，如从何处履行',
`is_ispu` varchar(10) NOT NULL DEFAULT '' COMMENT '如果为true，则此订单标记为从商店提货，而不是交付',
`is_access_point_order` varchar(10) NOT NULL DEFAULT '' COMMENT '如果为true，则将此订单标记为要交付给接入点。访问位置由客户选择。接入点包括亚马逊中心储物柜、亚马逊中心柜台和运营商运营的取货点。',
`marketplace_tax_info` text NOT NULL COMMENT '有关市场的税务信息',
`seller_display_name` varchar(128) NOT NULL DEFAULT '' COMMENT '卖家在市场上注册的友好名称',
`shipping_address` text NOT NULL COMMENT '订单的发货地址',
`buyer_email` varchar(255) NOT NULL DEFAULT '' COMMENT '买家email',
`buyer_info` text NOT NULL COMMENT '买家信息',
`automated_shipping_settings` text NOT NULL COMMENT '包含有关配送设置自动程序的信息，例如订单的配送设置是否自动生成，以及这些设置是什么',
`has_regulated_items` varchar(255) NOT NULL DEFAULT '' COMMENT '订单是否包含在履行之前可能需要额外批准步骤的监管项目',
`electronic_invoice_status` varchar(255) NOT NULL DEFAULT '' COMMENT '电子发票的状态 NotRequired,NotFound,Processing,Errored,Accepted',
`is_vine_order` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否为VINE类型订单 1是2不是(初始值0)',
`created_at` datetime NOT NULL COMMENT '订单拉取入库时间(内部使用)',
`updated_at` datetime DEFAULT NULL COMMENT '订单最后一次更新入库时间(内部使用)',
PRIMARY KEY (`id`) USING BTREE,
KEY `amazon_order_id_idx` (`amazon_order_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=75130 DEFAULT CHARSET=utf8mb4 COMMENT='亚马逊订单表';
-- ----------------------------
-- Table structure for amazon_order_items
-- ----------------------------
DROP TABLE IF EXISTS `amazon_order_items`;
CREATE TABLE `amazon_order_items` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(10) unsigned NOT NULL COMMENT '商戶id',
`merchant_store_id` int(10) unsigned NOT NULL COMMENT '商户店铺ID',
`seller_id` varchar(128) NOT NULL DEFAULT '' COMMENT '卖家ID',
`region` varchar(10) NOT NULL DEFAULT '' COMMENT '地区',
`marketplace_id` varchar(30) NOT NULL DEFAULT '' COMMENT '市场id',
`order_id` varchar(128) NOT NULL DEFAULT '' COMMENT '亚马逊订单id',
`asin` varchar(128) NOT NULL DEFAULT '' COMMENT '物品的亚马逊标准标识号（ASIN）',
`order_item_id` varchar(128) NOT NULL DEFAULT '' COMMENT 'Amazon定义的订单项标识符',
`seller_sku` varchar(255) NOT NULL COMMENT '商品的卖方库存单位（SKU）',
`title` varchar(255) NOT NULL DEFAULT '' COMMENT '商品标题',
`quantity_ordered` varchar(255) NOT NULL DEFAULT '' COMMENT '商品数量',
`quantity_shipped` varchar(255) NOT NULL DEFAULT '' COMMENT '装运的商品数量',
`product_info_number_of_items` varchar(255) NOT NULL DEFAULT '' COMMENT 'ASIN中包含的项目总数',
`points_granted` text NOT NULL COMMENT '购买商品时获得的亚马逊积分的数量和价值',
`item_price` text NOT NULL COMMENT '订单项的销售价格。请注意，订单项目是项目和数量。这意味着ItemPrice的值等于商品的售价乘以订购数量。请注意，ItemPrice不包括ShippingPrice和GiftWrapPrice。',
`shipping_price` text NOT NULL COMMENT '项目的装运价格',
`item_tax` text NOT NULL COMMENT '项目价格的税',
`shipping_tax` text NOT NULL COMMENT '运费税',
`shipping_discount` text NOT NULL COMMENT '运费折扣',
`shipping_discount_tax` text NOT NULL COMMENT '运费折扣税',
`promotion_discount` text NOT NULL COMMENT '优惠中所有促销折扣的总和',
`promotion_discount_tax` text NOT NULL COMMENT '优惠中所有促销折扣总额的税收',
`promotion_ids` text NOT NULL COMMENT '创建促销时由卖家提供的促销标识符列表',
`cod_fee` text NOT NULL COMMENT 'COD服务费',
`cod_fee_discount` text NOT NULL COMMENT 'COD费折扣',
`is_gift` varchar(10) NOT NULL DEFAULT '' COMMENT '如果为true，则该物品是礼物',
`condition_note` text NOT NULL COMMENT '卖方描述的物品状况',
`condition_id` text NOT NULL COMMENT '项目的状态。可能的值：New新建、Used二手、Collectible可收藏、Refurbished翻新、Preorder预购、Club俱乐部',
`condition_subtype_id` text NOT NULL COMMENT '项目的子条件',
`scheduled_delivery_start_date` varchar(50) NOT NULL DEFAULT '' COMMENT '订单目的地时区中计划交货窗口的开始日期。采用ISO 8601日期时间格式',
`scheduled_delivery_end_date` varchar(50) NOT NULL DEFAULT '' COMMENT '订单目的地时区中计划交货窗口的结束日期。采用ISO 8601日期时间格式',
`price_designation` varchar(255) NOT NULL DEFAULT '' COMMENT '表示销售价格是仅适用于亚马逊业务订单的特殊价格',
`tax_collection` text NOT NULL COMMENT '代扣税款信息',
`serial_number_required` varchar(10) NOT NULL DEFAULT '' COMMENT '如果为true，则此项目的产品类型具有序列号。 仅亚马逊Easy Ship订单退回',
`is_transparency` varchar(10) NOT NULL DEFAULT '' COMMENT '如果为true，则需要透明度代码',
`ioss_number` varchar(128) NOT NULL DEFAULT '' COMMENT '市场的IOSS编号。从欧盟以外地区运往欧盟（EU）的卖家必须在亚马逊收取销售增值税后向其承运人提供此IOSS编号。',
`store_chain_store_id` varchar(255) NOT NULL DEFAULT '' COMMENT '存储链存储标识符。链接到连锁店中的特定商店',
`deemed_reseller_category` varchar(255) NOT NULL DEFAULT '' COMMENT '被视为经销商的类别。这适用于不在欧盟的销售合作伙伴，用于帮助他们符合欧盟和英国的增值税视同经销商税法。',
`buyer_info` text NOT NULL COMMENT '单个项目的买家信息',
`buyer_requested_cancel` text NOT NULL COMMENT '关于买方是否要求取消的信息。\n\n',
`is_estimated_fba_fee` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否为预估费用 0否 1是',
`fba_fee` varchar(255) NOT NULL DEFAULT '' COMMENT 'fba费用',
`fba_fee_currency` varchar(10) NOT NULL DEFAULT '' COMMENT 'fba费用(货币)',
`is_estimated_commission` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否为预估佣金 0否 1是',
`commission` varchar(255) NOT NULL DEFAULT '' COMMENT '佣金',
`commission_currency` varchar(10) NOT NULL DEFAULT '' COMMENT '佣金(货币)',
`created_at` datetime NOT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
KEY `order_id_idx` (`merchant_id`,`merchant_store_id`,`order_id`),
KEY `order_item_asin_idx` (`asin`) USING BTREE,
KEY `order_item_order_id_idx` (`order_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=76502 DEFAULT CHARSET=utf8mb4 COMMENT='亚马逊订单项表';
-- ----------------------------
-- Table structure for amazon_report_amazon_fulfilled_shipments_data_general
-- ----------------------------
DROP TABLE IF EXISTS `amazon_report_amazon_fulfilled_shipments_data_general`;
CREATE TABLE `amazon_report_amazon_fulfilled_shipments_data_general` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(10) unsigned NOT NULL COMMENT '商户id',
`merchant_store_id` int(10) unsigned NOT NULL COMMENT '商户店铺id',
`amazon_order_id` varchar(50) NOT NULL DEFAULT '' COMMENT '亚马逊订单id',
`merchant_order_id` varchar(128) NOT NULL DEFAULT '' COMMENT '商户订单id',
`shipment_id` varchar(128) NOT NULL DEFAULT '' COMMENT '货件id',
`shipment_item_id` varchar(128) NOT NULL DEFAULT '' COMMENT '货件项id',
`amazon_order_item_id` varchar(128) NOT NULL DEFAULT '' COMMENT '亚马逊订单项id',
`merchant_order_item_id` varchar(128) NOT NULL DEFAULT '' COMMENT '商户订单项id',
`purchase_date` datetime DEFAULT NULL COMMENT '购买日期',
`payments_date` datetime DEFAULT NULL COMMENT '付款日期',
`shipment_date` datetime DEFAULT NULL COMMENT '送货日期',
`reporting_date` datetime DEFAULT NULL COMMENT '报告日期',
`buyer_email` varchar(128) NOT NULL DEFAULT '' COMMENT '买家邮箱',
`buyer_name` varchar(255) NOT NULL DEFAULT '' COMMENT '买家名称',
`buyer_phone_number` varchar(50) NOT NULL DEFAULT '' COMMENT '买家手机号',
`sku` varchar(128) NOT NULL DEFAULT '' COMMENT 'sku',
`product_name` varchar(255) NOT NULL DEFAULT '' COMMENT '商品名',
`quantity_shipped` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '配送数量',
`currency` varchar(5) NOT NULL DEFAULT '' COMMENT '货币',
`item_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '商品价格',
`item_tax` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '商品税',
`shipping_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '配送费',
`shipping_tax` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '配送费税',
`gift_wrap_price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '包装费',
`gift_wrap_tax` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '包装费税',
`ship_service_level` varchar(30) NOT NULL DEFAULT '' COMMENT '配送服务等级',
`recipient_name` varchar(50) NOT NULL DEFAULT '' COMMENT '收件人姓名',
`ship_address_1` varchar(255) NOT NULL DEFAULT '' COMMENT '配送-地址1',
`ship_address_2` varchar(255) NOT NULL DEFAULT '' COMMENT '配送-地址2',
`ship_address_3` varchar(255) NOT NULL DEFAULT '' COMMENT '配送-地址3',
`ship_city` varchar(50) NOT NULL DEFAULT '' COMMENT '配送-城市',
`ship_state` varchar(20) NOT NULL DEFAULT '' COMMENT '配送-州',
`ship_postal_code` varchar(30) NOT NULL DEFAULT '' COMMENT '配送-邮编',
`ship_country` varchar(20) NOT NULL DEFAULT '' COMMENT '配送-国家',
`ship_phone_number` varchar(50) NOT NULL DEFAULT '' COMMENT '配送-手机号',
`bill_address_1` varchar(255) NOT NULL DEFAULT '' COMMENT '账单-地址1',
`bill_address_2` varchar(255) NOT NULL DEFAULT '' COMMENT '账单-地址2',
`bill_address_3` varchar(255) NOT NULL DEFAULT '' COMMENT '账单-地址3',
`bill_city` varchar(50) NOT NULL DEFAULT '' COMMENT '账单-城市',
`bill_state` varchar(50) NOT NULL DEFAULT '' COMMENT '账单-州',
`bill_postal_code` varchar(30) NOT NULL DEFAULT '' COMMENT '账单-邮编',
`bill_country` varchar(20) NOT NULL DEFAULT '' COMMENT '账单-国家',
`item_promotion_discount` varchar(20) NOT NULL DEFAULT '' COMMENT '商品项促销折扣',
`ship_promotion_discount` varchar(20) NOT NULL DEFAULT '' COMMENT '配送促销折扣',
`carrier` varchar(50) NOT NULL DEFAULT '' COMMENT '快递运营商',
`tracking_number` varchar(128) NOT NULL DEFAULT '' COMMENT '快递追踪号',
`estimated_arrival_date` datetime NOT NULL COMMENT '预计到达日期',
`fulfillment_center_id` varchar(30) NOT NULL DEFAULT '' COMMENT '配送中心ID',
`fulfillment_channel` varchar(30) NOT NULL DEFAULT '' COMMENT '配送渠道',
`sales_channel` varchar(30) NOT NULL DEFAULT '' COMMENT '销售渠道',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=608 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Table structure for amazon_report_coupon_performance
-- ----------------------------
DROP TABLE IF EXISTS `amazon_report_coupon_performance`;
CREATE TABLE `amazon_report_coupon_performance` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商户ID',
`merchant_store_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '店铺ID',
`coupon_id` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '优惠券ID',
`amazon_merchant_id` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Amazon商户ID',
`marketplace_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`currency_code` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '货币符号',
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '优惠券名称',
`website_message` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`start_date_time` datetime NOT NULL COMMENT '开始时间',
`end_date_time` datetime NOT NULL COMMENT '结束时间',
`discount_type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '折扣类型',
`total_discount` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '总折扣',
`clips` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`redemptions` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`budget` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '预算',
`budget_spent` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '已花费的预算',
`budget_remaining` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '剩余预算',
`budget_percentage_used` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '已花费的预算比例',
`budget_sales` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '销售额',
`discount_amount` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '折扣总额',
`created_at` datetime DEFAULT NULL COMMENT '创建时间',
`updated_at` datetime DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=229 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for amazon_report_coupon_performance_asins
-- ----------------------------
DROP TABLE IF EXISTS `amazon_report_coupon_performance_asins`;
CREATE TABLE `amazon_report_coupon_performance_asins` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(10) NOT NULL COMMENT '商户ID',
`merchant_store_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '店铺ID',
`coupon_performance_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'amazon_coupon_performance.id',
`asin` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
`seller_sku` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` datetime DEFAULT NULL COMMENT '创建时间',
`updated_at` datetime DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=229 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for amazon_report_date_range_financial_transaction_data
-- ----------------------------
DROP TABLE IF EXISTS `amazon_report_date_range_financial_transaction_data`;
CREATE TABLE `amazon_report_date_range_financial_transaction_data` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(10) unsigned NOT NULL COMMENT '商户id',
`merchant_store_id` int(10) unsigned NOT NULL COMMENT '店铺id',
`report_id` varchar(128) NOT NULL DEFAULT '' COMMENT '报告id',
`currency` varchar(10) NOT NULL DEFAULT '' COMMENT '结算货币',
`date` datetime NOT NULL COMMENT '结算时间',
`settlement_id` varchar(128) NOT NULL DEFAULT '' COMMENT '结算id',
`type` varchar(50) NOT NULL DEFAULT '' COMMENT '结算类型',
`order_id` varchar(128) NOT NULL DEFAULT '' COMMENT '订单ID(不一定是商品订单ID)',
`sku` varchar(50) NOT NULL DEFAULT '' COMMENT '订单商品sku(有可能是fn_sku)',
`description` varchar(1000) NOT NULL DEFAULT '' COMMENT '结算描述',
`quantity` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '数量',
`marketplace` varchar(50) NOT NULL DEFAULT '' COMMENT '市场',
`account_type` varchar(30) NOT NULL DEFAULT '' COMMENT '账户类型',
`fulfillment` varchar(50) NOT NULL DEFAULT '' COMMENT '配送',
`order_city` varchar(50) NOT NULL DEFAULT '' COMMENT '订单-城市',
`order_state` varchar(50) NOT NULL DEFAULT '' COMMENT '订单-州',
`order_postal` varchar(50) NOT NULL DEFAULT '' COMMENT '订单-邮编',
`tax_collection_model` varchar(50) NOT NULL DEFAULT '' COMMENT '征税模式',
`product_sales` varchar(20) NOT NULL DEFAULT '' COMMENT '产品销售',
`product_sales_tax` varchar(20) NOT NULL DEFAULT '' COMMENT '产品销售税',
`shipping_credits` varchar(20) NOT NULL DEFAULT '' COMMENT '运输信用',
`shipping_credits_tax` varchar(20) NOT NULL DEFAULT '' COMMENT '运输信用税',
`gift_wrap_credits` varchar(20) NOT NULL DEFAULT '' COMMENT '礼品包装信用',
`gift_wrap_credits_tax` varchar(20) NOT NULL DEFAULT '' COMMENT '礼品包装信用税',
`regulatory_fee` varchar(20) NOT NULL DEFAULT '' COMMENT '监管费',
`tax_on_regulatory_fee` varchar(20) NOT NULL DEFAULT '' COMMENT '监管费税',
`promotional_rebates` varchar(20) NOT NULL DEFAULT '' COMMENT '促销回扣',
`promotional_rebates_tax` varchar(20) NOT NULL DEFAULT '' COMMENT '促销回扣税',
`sales_tax_collected` varchar(20) NOT NULL DEFAULT '' COMMENT '征收的销售税',
`marketplace_facilitator_tax` varchar(20) NOT NULL DEFAULT '' COMMENT '市场促进税',
`marketplace_withheld_tax` varchar(20) NOT NULL DEFAULT '' COMMENT '市场预扣税',
`selling_fees` varchar(20) NOT NULL DEFAULT '' COMMENT '销售费用',
`fba_fees` varchar(20) NOT NULL DEFAULT '' COMMENT 'FBA费用',
`other_transaction_fees` varchar(20) NOT NULL DEFAULT '' COMMENT '其他交易费用',
`other` varchar(20) NOT NULL DEFAULT '' COMMENT '其他',
`total` varchar(20) NOT NULL DEFAULT '' COMMENT '总数',
`md5_hash` varchar(32) NOT NULL DEFAULT '' COMMENT 'hash值',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `idx` (`merchant_id`,`merchant_store_id`,`settlement_id`,`md5_hash`) USING BTREE,
KEY `report_idx` (`merchant_id`,`merchant_store_id`,`report_id`),
KEY `md5_hash` (`merchant_id`,`merchant_store_id`,`md5_hash`)
) ENGINE=InnoDB AUTO_INCREMENT=7183 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Table structure for amazon_report_fba_estimated_fee
-- ----------------------------
DROP TABLE IF EXISTS `amazon_report_fba_estimated_fee`;
CREATE TABLE `amazon_report_fba_estimated_fee` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT ' ',
`merchant_id` int(10) unsigned NOT NULL,
`merchant_store_id` int(10) unsigned NOT NULL,
`country_id` varchar(5) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '国家二字码',
`sku` varchar(128) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`fn_sku` varchar(128) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`asin` varchar(128) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`product_name` varchar(512) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`product_group` varchar(255) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`brand` varchar(128) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`fulfilled_by` varchar(128) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`your_price` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`sales_price` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`longest_side` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`median_side` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`shortest_side` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`length_and_girth` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`unit_of_dimension` varchar(32) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`item_package_weight` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`unit_of_weight` varchar(20) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`product_size_tier` varchar(32) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`currency` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '货币',
`estimated_fee_total` varchar(20) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`estimated_referral_fee_per_unit` varchar(20) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`estimated_wariable_closing_fee` varchar(20) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`estimated_order_handing_fee_per_order` varchar(20) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`estimated_pick_pack_fee_per_unit` varchar(20) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`estimated_variable_closing_fee` varchar(20) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`estimated_weight_handling_fee_per_unit` varchar(20) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`expected_fulfillment_fee_per_unit` varchar(20) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '每单位预期履约费',
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=265 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ----------------------------
-- Table structure for amazon_report_fba_fulfillment_customer_return_data
-- ----------------------------
DROP TABLE IF EXISTS `amazon_report_fba_fulfillment_customer_return_data`;
CREATE TABLE `amazon_report_fba_fulfillment_customer_return_data` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(10) unsigned NOT NULL,
`merchant_store_id` int(10) NOT NULL,
`return_date` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`order_id` varchar(128) NOT NULL DEFAULT '',
`sku` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`fnsku` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`asin` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`product_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`quantity` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`fulfillment_center_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`detailed_disposition` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`status` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`license_plate_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`customer_comments` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`created_at` datetime NOT NULL COMMENT '数据首次拉取时间',
`updated_at` datetime NOT NULL COMMENT '数据更新时间',
PRIMARY KEY (`id`),
KEY `multi_idx` (`merchant_id`,`merchant_store_id`,`return_date`,`order_id`,`sku`,`asin`,`fulfillment_center_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3338 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Table structure for amazon_report_fba_fulfillment_longterm_storage_fee_charges_data
-- ----------------------------
DROP TABLE IF EXISTS `amazon_report_fba_fulfillment_longterm_storage_fee_charges_data`;
CREATE TABLE `amazon_report_fba_fulfillment_longterm_storage_fee_charges_data` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT ' ',
`merchant_id` int(10) unsigned NOT NULL,
`merchant_store_id` int(10) unsigned NOT NULL,
`snapshot_date` datetime NOT NULL COMMENT '快照日期',
`sku` varchar(128) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT 'sku',
`fnsku` varchar(128) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT 'fnsku',
`asin` varchar(128) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT 'asin',
`product_name` varchar(512) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '产品名词',
`condition` varchar(128) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`per_unit_volume` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`currency` varchar(5) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '货币符号',
`volume_unit` varchar(32) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`country` varchar(5) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '国家',
`qty_charged` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`amount_charged` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`surcharge_age_tier` varchar(32) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`rate_surcharge` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`created_at` datetime NOT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
KEY `snap-shot-date-idx` (`merchant_id`,`merchant_store_id`,`snapshot_date`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Amazon-长期仓储费报表';
-- ----------------------------
-- Table structure for amazon_report_fba_inventory_planning_data
-- ----------------------------
DROP TABLE IF EXISTS `amazon_report_fba_inventory_planning_data`;
CREATE TABLE `amazon_report_fba_inventory_planning_data` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(10) unsigned DEFAULT NULL COMMENT '商户id',
`merchant_store_id` int(10) unsigned DEFAULT NULL COMMENT '店铺id',
`snapshot_date` datetime NOT NULL,
`sku` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`fnsku` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`asin` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`product_name` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`condition` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`available` int(10) unsigned NOT NULL DEFAULT '0',
`pending_removal_quantity` int(10) unsigned NOT NULL DEFAULT '0',
`inv_age_0_to_90_days` int(10) unsigned NOT NULL DEFAULT '0',
`inv_age_91_to_180_days` int(10) unsigned NOT NULL DEFAULT '0',
`inv_age_181_to_270_days` int(10) unsigned NOT NULL DEFAULT '0',
`inv_age_271_to_365_days` int(10) unsigned NOT NULL DEFAULT '0',
`inv_age_365_plus_days` int(10) unsigned NOT NULL DEFAULT '0',
`currency` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`units_shipped_t7` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`units_shipped_t30` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`units_shipped_t60` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`units_shipped_t90` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`alert` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`your_price` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`sales_price` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`lowest_price_new_plus_shipping` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`lowest_price_used` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`recommended_action` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`healthy_inventory_level` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`recommended_sales_price` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`recommended_sale_duration_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`recommended_removal_quantity` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`estimated_cost_savings_of_recommended_actions` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`sell_through` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`item_volume` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`volume_unit_measurement` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`storage_type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`storage_volume` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`marketplace` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`product_group` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`sales_rank` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`days_of_supply` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`estimated_excess_quantity` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`weeks_of_cover_t30` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`weeks_of_cover_t90` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`featuredoffer_price` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`sales_shipped_last_7_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`sales_shipped_last_30_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`sales_shipped_last_60_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`sales_shipped_last_90_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`inv_age_0_to_30_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`inv_age_31_to_60_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`inv_age_61_to_90_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`inv_age_181_to_330_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`inv_age_331_to_365_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`estimated_storage_cost_next_month` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`inbound_quantity` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`inbound_working` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`inbound_shipped` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`inbound_received` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`no_sale_last_6_months` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`reserved_quantity` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`unfulfillable_quantity` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`quantity_to_be_charged_ais_181_210_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`estimated_ais_181_210_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`quantity_to_be_charged_ais_211_240_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`estimated_ais_211_240_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`quantity_to_be_charged_ais_241_270_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`estimated_ais_241_270_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`quantity_to_be_charged_ais_271_300_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`estimated_ais_271_300_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`quantity_to_be_charged_ais_301_330_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`estimated_ais_301_330_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`quantity_to_be_charged_ais_331_365_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`estimated_ais_331_365_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`quantity_to_be_charged_ais_365_plus_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`estimated_ais_365_plus_days` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`created_at` datetime NOT NULL COMMENT '数据首次拉取时间',
`updated_at` datetime NOT NULL COMMENT '数据更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- ----------------------------
-- Table structure for amazon_report_fba_myi_unsuppressed_inventory_data
-- ----------------------------
DROP TABLE IF EXISTS `amazon_report_fba_myi_unsuppressed_inventory_data`;
CREATE TABLE `amazon_report_fba_myi_unsuppressed_inventory_data` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(10) unsigned NOT NULL,
`merchant_store_id` int(10) NOT NULL,
`sku` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`fnsku` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`asin` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`product_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`condition` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`your_price` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`mfn_listing_exists` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`mfn_fulfillable_quantity` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`afn_listing_exists` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`afn_warehouse_quantity` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`afn_fulfillable_quantity` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`afn_unsellable_quantity` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`afn_reserved_quantity` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`afn_total_quantity` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`per_unit_volume` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`afn_inbound_working_quantity` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`afn_inbound_shipped_quantity` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`afn_inbound_receiving_quantity` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`afn_researching_quantity` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`afn_reserved_future_supply` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`afn_future_supply_buyable` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`created_at` datetime NOT NULL COMMENT '数据首次拉取时间',
`updated_at` datetime NOT NULL COMMENT '数据更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=169 DEFAULT CHARSET=utf8mb4;
-- ----------------------------
-- Table structure for amazon_report_fba_reimbursement
-- ----------------------------
DROP TABLE IF EXISTS `amazon_report_fba_reimbursement`;
CREATE TABLE `amazon_report_fba_reimbursement` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商户id',
`merchant_store_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '店铺id',
`reimbursement_id` varchar(128) NOT NULL DEFAULT '' COMMENT '报销编号',
`sku` varchar(128) NOT NULL DEFAULT '' COMMENT 'SKU',
`fnsku` varchar(128) NOT NULL DEFAULT '' COMMENT 'FNSKU',
`asin` varchar(32) NOT NULL DEFAULT '' COMMENT 'ASIN',
`product_name` varchar(255) NOT NULL DEFAULT '' COMMENT '产品名称',
`approval_date` datetime DEFAULT NULL COMMENT '日期',
`amazon_order_id` varchar(128) NOT NULL DEFAULT '' COMMENT '亚马逊订单ID',
`case_id` varchar(128) NOT NULL DEFAULT '' COMMENT '问题编号',
`reason` varchar(255) NOT NULL DEFAULT '' COMMENT '原因',
`condition` varchar(128) NOT NULL DEFAULT '' COMMENT '状况',
`currency_unit` varchar(32) NOT NULL DEFAULT '' COMMENT '货币单位',
`amount_per_unit` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '每件商品的金额',
`amount_total` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '总金额',
`quantity_reimbursed_cash` int(10) NOT NULL DEFAULT '0' COMMENT '赔偿数量【现金】',
`quantity_reimbursed_inventory` varchar(10) NOT NULL DEFAULT '' COMMENT '赔偿数量【库存】',
`quantity_reimbursed_total` int(10) NOT NULL DEFAULT '0' COMMENT '赔偿数量【总计】',
`original_reimbursement_id` varchar(128) NOT NULL DEFAULT '' COMMENT '原始赔偿编号',
`original_reimbursement_type` varchar(128) NOT NULL DEFAULT '' COMMENT '原始赔偿类型',
`created_at` datetime DEFAULT NULL COMMENT '创建时间',
`updated_at` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='亚马逊赔偿报告';
-- ----------------------------
-- Table structure for amazon_report_fba_storage_fee_charges_data
-- ----------------------------
DROP TABLE IF EXISTS `amazon_report_fba_storage_fee_charges_data`;
CREATE TABLE `amazon_report_fba_storage_fee_charges_data` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT ' ',
`merchant_id` int(10) unsigned NOT NULL,
`merchant_store_id` int(10) unsigned NOT NULL,
`month_of_charge` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`asin` varchar(128) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT 'asin',
`seller_sku` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'seller sku',
`fnsku` varchar(128) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT 'fnsku',
`product_name` varchar(512) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '产品名称',
`fulfillment_center` varchar(20) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`country_code` varchar(5) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '国家二字码',
`longest_side` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`median_side` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`shortest_side` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`measurement_units` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`weight` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`weight_units` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`item_volume` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`volume_units` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`average_quantity_on_hand` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`average_quantity_pending_removal` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`estimated_total_item_volume` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`storage_utilization_ratio` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`storage_utilization_ratio_units` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`base_rate` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`utilization_surcharge_rate` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`currency` varchar(5) CHARACTER SET utf8mb4 NOT NULL DEFAULT '' COMMENT '货币符号',
`estimated_monthly_storage_fee` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`total_incentive_fee_amount` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`breakdown_incentive_fee_amount` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`average_quantity_customer_orders` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT '',
`dangerous_goods_storage_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
`product_size_tier` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`eligible_for_inventory_discount` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
`qualifies_for_inventory_discount` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`md5_hash` varchar(33) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '唯一值',
`created_at` datetime NOT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
KEY `month-idx` (`merchant_id`,`merchant_store_id`,`month_of_charge`,`asin`,`seller_sku`,`fulfillment_center`) USING BTREE,
KEY `md5_idx` (`merchant_id`,`merchant_store_id`,`md5_hash`)
) ENGINE=InnoDB AUTO_INCREMENT=9439 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Amazon-月度仓储费报表';
-- ----------------------------
-- Table structure for amazon_report_promotion_performance
-- ----------------------------
DROP TABLE IF EXISTS `amazon_report_promotion_performance`;
CREATE TABLE `amazon_report_promotion_performance` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(10) unsigned NOT NULL COMMENT '商户ID(ERP)',
`merchant_store_id` int(10) unsigned NOT NULL COMMENT '店铺ID',
`promotion_id` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '促销ID',
`promotion_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '促销标题',
`marketplace_id` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '市场ID',
`amazon_merchant_id` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Amazon商户ID',
`type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '促销类型',
`status` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '促销状态',
`glance_views` int(10) unsigned NOT NULL DEFAULT '0',
`units_sold` int(10) unsigned NOT NULL DEFAULT '0',
`revenue` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
`revenue_currency_code` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'revenue货币符号',
`start_date_time` datetime NOT NULL COMMENT '开始时间',
`end_date_time` datetime NOT NULL COMMENT '结束时间',
`created_date_time` datetime NOT NULL COMMENT '创建时间',
`last_updated_date_time` datetime NOT NULL COMMENT '最后更新时间',
`created_at` datetime NOT NULL COMMENT '创建时间(表记录)',
`updated_at` datetime NOT NULL COMMENT '更新时间(表记录)',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for amazon_report_promotion_performance_products
-- ----------------------------
DROP TABLE IF EXISTS `amazon_report_promotion_performance_products`;
CREATE TABLE `amazon_report_promotion_performance_products` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(11) unsigned NOT NULL COMMENT '商户ID',
`merchant_store_id` int(11) unsigned NOT NULL COMMENT '店铺ID',
`promotion_performance_id` int(10) unsigned NOT NULL COMMENT 'amazon_promotion_performance.id',
`asin` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`seller_sku` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`product_name` varchar(512) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`product_glance_views` int(10) unsigned NOT NULL DEFAULT '0',
`product_units_sold` int(10) unsigned NOT NULL DEFAULT '0',
`product_revenue` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
`product_revenue_currency_code` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'revenue货币符号',
`created_at` datetime NOT NULL COMMENT '创建时间',
`updated_at` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=186 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for amazon_report_sales_and_traffic_by_asin
-- ----------------------------
DROP TABLE IF EXISTS `amazon_report_sales_and_traffic_by_asin`;
CREATE TABLE `amazon_report_sales_and_traffic_by_asin` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(10) unsigned NOT NULL COMMENT '商户id',
`merchant_store_id` int(10) unsigned NOT NULL COMMENT '店铺id',
`marketplace_id` varchar(32) NOT NULL COMMENT '市场',
`data_time` datetime DEFAULT NULL COMMENT '数据时间',
`parent_asin` varchar(32) NOT NULL DEFAULT '' COMMENT '(父)ASIN',
`child_asin` varchar(32) NOT NULL DEFAULT '' COMMENT '(子)ASIN',
`units_ordered` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '已订购商品数',
`units_ordered_b2b` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '已订购商品数-B2B',
`ordered_product_sales_amount` double(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '已订购商品销售额',
`ordered_product_sales_currency_code` varchar(20) NOT NULL DEFAULT '' COMMENT '已订购商品销售额(货币)',
`ordered_product_sales_b2b_amount` double(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '已订购商品销售额-B2B',
`ordered_product_sales_b2b_amount_currency_code` varchar(20) NOT NULL DEFAULT '' COMMENT '已订购商品销售额-B2B(货币)',
`total_order_items` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '订单商品总数',
`total_order_items_b2b` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '订单商品总数-B2B',
`browser_sessions` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览器会话次数',
`browser_sessions_b2b` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览器会话次数-B2B',
`mobile_app_sessions` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '手机APP会话次数',
`mobile_app_sessions_b2b` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '手机APP会话次数-B2B',
`sessions` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会话次数-总计',
`sessions_b2b` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会话次数-总计-B2B',
`browser_session_percentage` double(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '浏览器会话次数百分比',
`browser_session_percentage_b2b` double(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '浏览器会话次数百分比-B2B',
`mobile_app_session_percentage` double(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '手机APP会话次数百分比',
`mobile_app_session_percentage_b2b` double(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '手机APP会话次数百分比-B2B',
`session_percentage` double(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '会话百分比-总计',
`session_percentage_b2b` double(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '会话百分比-总计-B2B',
`browser_page_views` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览器页面浏览量',
`browser_page_views_b2b` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览器页面浏览量-B2B',
`mobile_app_page_views` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '手机APP页面浏览量',
`mobile_app_page_views_b2b` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '手机APP页面浏览量-B2B',
`page_views` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '页面浏览量-总计',
`page_views_b2b` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '页面浏览量-总计-B2B',
`browser_page_views_percentage` double(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '浏览器页面浏览量百分比',
`browser_page_views_percentage_b2b` double(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '浏览器页面浏览量百分比-B2B',
`mobile_app_page_views_percentage` double(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '手机APP页面浏览量百分比',
`mobile_app_page_views_percentage_b2b` double(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '手机APP页面浏览量百分比-B2B',
`page_views_percentage` double(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '页面浏览量-总计百分比',
`page_views_percentage_b2b` double(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '页面浏览量-总计百分比-B2B',
`buy_box_percentage` double(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '推荐报价（购买按钮）百分比',
`buy_box_percentage_b2b` double(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '推荐报价（购买按钮）百分比 – B2B',
`unit_session_percentage` double(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '商品会话百分比',
`unit_session_percentage_b2b` double(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '商品会话百分比-B2B',
`created_at` datetime DEFAULT NULL COMMENT '创建时间',
`updated_at` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `multi_index` (`merchant_id`,`merchant_store_id`,`marketplace_id`,`data_time`,`parent_asin`,`child_asin`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8331 DEFAULT CHARSET=utf8mb4 COMMENT='亚马逊-销售与流量(ASIN)';
-- ----------------------------
-- Table structure for amazon_report_sales_and_traffic_by_date
-- ----------------------------
DROP TABLE IF EXISTS `amazon_report_sales_and_traffic_by_date`;
CREATE TABLE `amazon_report_sales_and_traffic_by_date` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(10) unsigned NOT NULL COMMENT '商户id',
`merchant_store_id` int(10) unsigned NOT NULL COMMENT '店铺id',
`marketplace_id` varchar(32) NOT NULL COMMENT '市场',
`data_time` datetime DEFAULT NULL COMMENT '数据时间',
`ordered_product_sales_amount` double(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '已订购商品销售总额',
`ordered_product_sales_currency_code` varchar(20) NOT NULL DEFAULT '' COMMENT '已订购商品销售总额(货币)',
`ordered_product_sales_b2b_amount` double(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '已订购商品销售总额-B2B',
`ordered_product_sales_b2b_currency_code` varchar(20) NOT NULL DEFAULT '' COMMENT '已订购商品销售总额-B2B(货币)',
`units_ordered` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '已订购商品数',
`units_ordered_b2b` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '已订购商品数-B2B',
`total_order_items` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '订单商品总数',
`total_order_items_b2b` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '订单商品总数-B2B',
`average_sales_per_order_item_amount` double(10,2) unsigned NOT NULL DEFAULT '0.00',
`average_sales_per_order_item_currency_code` varchar(20) NOT NULL DEFAULT '',
`average_sales_per_order_item_b2b_amount` double(10,2) unsigned NOT NULL DEFAULT '0.00',
`average_sales_per_order_item_b2b_currency_code` varchar(20) NOT NULL DEFAULT '',
`average_units_per_order_item` double(10,2) unsigned NOT NULL DEFAULT '0.00',
`average_units_per_order_item_b2b` double(10,2) unsigned NOT NULL DEFAULT '0.00',
`average_selling_price_amount` double(10,2) unsigned NOT NULL DEFAULT '0.00',
`average_selling_price_currency_code` varchar(20) NOT NULL DEFAULT '',
`average_selling_price_b2b_amount` double(10,2) unsigned NOT NULL DEFAULT '0.00',
`average_selling_price_b2b_currency_code` varchar(20) NOT NULL DEFAULT '',
`units_refunded` int(10) unsigned NOT NULL DEFAULT '0',
`refund_rate` double(10,2) unsigned NOT NULL DEFAULT '0.00',
`claims_granted` int(10) unsigned NOT NULL DEFAULT '0',
`claims_amount_amount` double(10,2) unsigned NOT NULL DEFAULT '0.00',
`claims_amount_currency_code` varchar(20) NOT NULL DEFAULT '',
`shipped_product_sales_amount` double(10,2) unsigned NOT NULL DEFAULT '0.00',
`shipped_product_sales_currency_code` varchar(20) NOT NULL DEFAULT '',
`units_shipped` int(10) unsigned NOT NULL DEFAULT '0',
`orders_shipped` int(10) unsigned NOT NULL DEFAULT '0',
`browser_page_views` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览器页面浏览量',
`browser_page_views_b2b` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览器页面浏览量-B2B',
`mobile_app_page_views` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '手机APP页面浏览量',
`mobile_app_page_views_b2b` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '手机APP页面浏览量-B2B',
`page_views` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '页面浏览量-总计',
`page_views_b2b` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '页面浏览量-总计-B2B',
`browser_sessions` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览器会话次数',
`browser_sessions_b2b` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览器会话次数-B2B',
`mobile_app_sessions` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '手机APP会话次数',
`mobile_app_sessions_b2b` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '手机APP会话次数—B2B',
`sessions` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会话次数-总计',
`sessions_b2b` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会话次数-总计-B2B',
`buy_box_percentage` double(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '推荐报价（购买按钮）百分比',
`buy_box_percentage_b2b` double(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '推荐报价（购买按钮）百分比 – B2B',
`order_item_session_percentage` double(5,2) unsigned NOT NULL DEFAULT '0.00',
`order_item_session_percentage_b2b` double(5,2) unsigned NOT NULL DEFAULT '0.00',
`unit_session_percentage` double(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '商品会话百分比',
`unit_session_percentage_b2b` double(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '商品会话百分比-B2B',
`average_offer_count` int(10) unsigned NOT NULL DEFAULT '0',
`average_parent_items` int(10) unsigned NOT NULL DEFAULT '0',
`feedback_received` int(10) unsigned NOT NULL DEFAULT '0',
`negative_feedback_received` int(10) unsigned NOT NULL DEFAULT '0',
`received_negative_feedback_rate` double(5,2) unsigned NOT NULL DEFAULT '0.00',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `multi_idx` (`merchant_id`,`merchant_store_id`,`marketplace_id`,`data_time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=857 DEFAULT CHARSET=utf8mb4 COMMENT='亚马逊-销售与流量(DATE)';
-- ----------------------------
-- Table structure for amazon_report_settlement_report_data_flat_file_v2
-- ----------------------------
DROP TABLE IF EXISTS `amazon_report_settlement_report_data_flat_file_v2`;
CREATE TABLE `amazon_report_settlement_report_data_flat_file_v2` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(10) unsigned NOT NULL,
`merchant_store_id` int(10) unsigned NOT NULL,
`report_id` varchar(128) NOT NULL DEFAULT '' COMMENT '报告id',
`settlement_id` varchar(128) NOT NULL DEFAULT '' COMMENT '结算id',
`settlement_start_date` datetime DEFAULT NULL COMMENT '结算开始时间',
`settlement_end_date` datetime DEFAULT NULL COMMENT '结算结束时间',
`deposit_date` datetime DEFAULT NULL COMMENT '存款时间',
`total_amount` varchar(128) NOT NULL DEFAULT '' COMMENT '总数',
`currency` varchar(128) NOT NULL DEFAULT '' COMMENT '货币',
`transaction_type` varchar(128) NOT NULL DEFAULT '' COMMENT '交易类型',
`order_id` varchar(128) NOT NULL DEFAULT '' COMMENT '订单ID',
`merchant_order_id` varchar(128) NOT NULL DEFAULT '' COMMENT '商户订单ID',
`adjustment_id` varchar(128) NOT NULL DEFAULT '' COMMENT '调整ID',
`shipment_id` varchar(128) NOT NULL DEFAULT '' COMMENT '装运ID',
`marketplace_name` varchar(128) NOT NULL DEFAULT '' COMMENT '市场名称',
`amount_type` varchar(128) NOT NULL DEFAULT '' COMMENT '金额类型',
`amount_description` varchar(128) NOT NULL DEFAULT '' COMMENT '金额描述',
`amount` varchar(128) NOT NULL DEFAULT '' COMMENT '金额',
`fulfillment_id` varchar(128) NOT NULL DEFAULT '' COMMENT '履行ID',
`posted_date` varchar(128) NOT NULL DEFAULT '' COMMENT '发布日期',
`posted_date_time` varchar(128) NOT NULL DEFAULT '' COMMENT '发布日期时间',
`order_item_code` varchar(128) NOT NULL DEFAULT '' COMMENT '订单商品代码',
`merchant_order_item_id` varchar(128) NOT NULL DEFAULT '' COMMENT '商户订单项ID',
`merchant_adjustment_item_id` varchar(128) NOT NULL DEFAULT '' COMMENT '商户调整项ID',
`sku` varchar(128) NOT NULL DEFAULT '' COMMENT 'SKU',
`quantity_purchased` varchar(128) NOT NULL DEFAULT '' COMMENT '购买数量',
`promotion_id` varchar(128) NOT NULL DEFAULT '' COMMENT '促销ID',
`md5_hash` varchar(33) NOT NULL DEFAULT '' COMMENT '记录行md5哈希值',
`created_at` datetime NOT NULL COMMENT '创建时间',
`updated_at` datetime DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
KEY `idx` (`merchant_id`,`merchant_store_id`,`settlement_id`,`transaction_type`,`order_id`,`amount_type`) USING BTREE,
KEY `report_idx` (`merchant_id`,`merchant_store_id`,`report_id`),
KEY `md5_idx` (`merchant_id`,`merchant_store_id`,`md5_hash`)
) ENGINE=InnoDB AUTO_INCREMENT=342108 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Table structure for amazon_return_goods
-- ----------------------------
DROP TABLE IF EXISTS `amazon_return_goods`;
CREATE TABLE `amazon_return_goods` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商户ID',
`merchant_store_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商户店铺ID',
`return_date` datetime NOT NULL COMMENT '退货日期',
`order_id` varchar(128) NOT NULL DEFAULT '' COMMENT '亚马逊订单ID',
`sku` varchar(128) NOT NULL DEFAULT '' COMMENT '亚马逊SKU',
`asin` varchar(128) NOT NULL DEFAULT '' COMMENT 'ASIN',
`fnsku` varchar(128) NOT NULL DEFAULT '' COMMENT 'FNSKU',
`product_name` varchar(255) NOT NULL DEFAULT '' COMMENT '产品名称',
`quantity` int(10) NOT NULL DEFAULT '0' COMMENT '数量',
`fulfillment_center_id` varchar(128) NOT NULL DEFAULT '' COMMENT '处理退货商品的运营中心',
`detailed_disposition` varchar(32) NOT NULL DEFAULT '' COMMENT '商品状态\r\n - 1.Sellable：可售 \r\n - 2.Damaged：已残损 \r\n - 3.CUSTOMER_DAMAGED：买家导致残损\r\n - 4. CARRIER_DAMAGED：物流承运方导致商品残损\r\n - 5.DEFECTIVE：产品存在瑕疵；',
`reason` varchar(255) NOT NULL DEFAULT '' COMMENT '退货原因（买家原因简述）',
`status` varchar(128) NOT NULL DEFAULT '' COMMENT '退货状态\r\n - Unit Returned to Inventory：商品已退回买家库存 —— 可售/不可售库存有显示；\r\n - reimbursed：亚马逊已批准对商品进行赔偿，赔偿会在 5 天内支付 —— 不退回买家库存；\r\n - Pending Repackaging 等待重新包装，完成后可重新销售；\r\n - Repackaged Successfully 已成功重新包装，并可以销售 —— 已退回在售库存',
`license_plate_number` varchar(128) NOT NULL DEFAULT '' COMMENT '货箱',
`customer_comments` varchar(255) NOT NULL DEFAULT '' COMMENT '买家评论',
`fba_is_scan` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'FBA进销存是否已扫描 1是 0否',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
KEY `amazon_return_order_id_idx` (`order_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='亚马逊退货';
-- ----------------------------
-- Table structure for amazon_sales_and_traffic_by_asin
-- ----------------------------
DROP TABLE IF EXISTS `amazon_sales_and_traffic_by_asin`;
CREATE TABLE `amazon_sales_and_traffic_by_asin` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`merchant_id` int(10) unsigned NOT NULL COMMENT '商户id',
`merchant_store_id` int(10) unsigned NOT NULL COMMENT '店铺id',
`marketplace_id` varchar(32) NOT NULL COMMENT '市场',
`data_time` datetime DEFAULT NULL COMMENT '数据时间',
`sku` varchar(256) NOT NULL DEFAULT '' COMMENT 'SKU',