5ab1c29c
 tangwang
first commit
|
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
|
check_table_structure.py 的输出
================================================================================
检查 prd_goods_sku 表结构
================================================================================
表字段列表：
Field Type Null Key Default Extra
0 id bigint Yes true None
1 buyer_id bigint Yes false None REPLACE
2 proxy_buyer_id bigint Yes false None REPLACE
3 goods_id bigint Yes false None REPLACE
4 name varchar(1536) Yes false None REPLACE
5 name_pinyin varchar(3072) Yes false None REPLACE
6 accessories varchar(1536) Yes false None REPLACE
7 factory_no_buyer varchar(192) Yes false None REPLACE
8 factory_no varchar(765) Yes false None REPLACE
9 is_has_sample smallint Yes false None REPLACE
10 is_has_pkg_age_label smallint Yes false None REPLACE
11 pkg_age_label varchar(384) Yes false None REPLACE
12 onway_total int Yes false None REPLACE
13 onway_use_total int Yes false None REPLACE
14 onway_unuse_total int Yes false None REPLACE
15 deliver_day int Yes false None REPLACE
16 dev_level varchar(96) Yes false None REPLACE
17 length decimal(12,2) Yes false None REPLACE
18 width decimal(12,2) Yes false None REPLACE
19 height decimal(12,2) Yes false None REPLACE
20 volume decimal(12,8) Yes false None REPLACE
21 out_box_length decimal(12,2) Yes false None REPLACE
22 out_box_width decimal(12,2) Yes false None REPLACE
23 out_box_height decimal(12,2) Yes false None REPLACE
24 out_box_volume decimal(12,8) Yes false None REPLACE
25 out_box_cruft decimal(15,8) Yes false None REPLACE
26 package_length decimal(12,2) Yes false None REPLACE
27 package_width decimal(12,2) Yes false None REPLACE
28 package_height decimal(12,2) Yes false None REPLACE
29 package_volume decimal(12,8) Yes false None REPLACE
30 total_volume decimal(12,8) Yes false None REPLACE
31 gross_weight decimal(12,2) Yes false None REPLACE
32 net_weight decimal(12,2) Yes false None REPLACE
33 is_package_depart smallint Yes false None REPLACE
34 is_fixed_sale smallint Yes false None REPLACE
35 inbox_count int Yes false None REPLACE
36 no varchar(192) Yes false None REPLACE
37 hs_no varchar(192) Yes false None REPLACE
38 erp_old_no varchar(192) Yes false None REPLACE
39 factory_first_price decimal(12,3) Yes false None REPLACE
40 factory_first_price_unit varchar(96) Yes false None REPLACE
41 factory_first_price_date datetime Yes false None REPLACE
42 bar_code varchar(192) Yes false None REPLACE
43 count int Yes false None REPLACE
44 unit varchar(96) Yes false None REPLACE
45 price_supplier decimal(12,3) Yes false None REPLACE
46 gross_profit decimal(12,5) Yes false None REPLACE
47 price_base decimal(12,3) Yes false None REPLACE
48 bulk_result varchar(96) Yes false None REPLACE
49 bulk_type varchar(96) Yes false None REPLACE
50 purchase_moq int Yes false None REPLACE
51 capacity int Yes false None REPLACE
52 package_type_id bigint Yes false None REPLACE
53 package_type_name varchar(192) Yes false None REPLACE
54 package_type_value varchar(96) Yes false None REPLACE
55 sale_price decimal(12,3) Yes false None REPLACE
56 has_quote_rang smallint Yes false None REPLACE
57 is_stop_product smallint Yes false None REPLACE
58 is_upload_pic smallint Yes false None REPLACE
59 status varchar(96) Yes false None REPLACE
60 sku_compose_md5 varchar(192) Yes false None REPLACE
61 sku_compose varchar(6144) Yes false None REPLACE
62 src varchar(96) Yes false None REPLACE
63 price_bom_total decimal(12,3) Yes false None REPLACE
64 bom_id bigint Yes false None REPLACE
65 off_sell_time datetime Yes false None REPLACE
66 off_sell_user_id bigint Yes false None REPLACE
67 sort_time datetime Yes false None REPLACE
68 fir_on_sell_time datetime Yes false None REPLACE
69 on_sell_time datetime Yes false None REPLACE
70 on_sell_user_id bigint Yes false None REPLACE
71 is_draft smallint Yes false None REPLACE
72 per_pcs_price decimal(12,3) Yes false None REPLACE
73 fcl_price decimal(12,3) Yes false None REPLACE
74 init_price decimal(12,3) Yes false None REPLACE
75 last_pic_update_user_Id bigint Yes false None REPLACE
76 last_pic_update_time datetime Yes false None REPLACE
77 hide smallint Yes false None REPLACE
78 supplier_source varchar(192) Yes false None REPLACE
79 ref_sku_id bigint Yes false None REPLACE
80 ref_season_type varchar(192) Yes false None REPLACE
81 is_category_error smallint Yes false None REPLACE
82 is_attribute_error smallint Yes false None REPLACE
83 is_option_error smallint Yes false None REPLACE
84 price_protection_time datetime Yes false None REPLACE
85 remark varchar(6144) Yes false None REPLACE
86 audit_remark varchar(1536) Yes false None REPLACE
87 attribute_uid varchar(96) Yes false None REPLACE
88 refact_count int Yes false None REPLACE
89 last_refact_time datetime Yes false None REPLACE
90 last_refact_by bigint Yes false None REPLACE
91 is_delete smallint Yes false None REPLACE
92 soft_delete_time datetime Yes false None REPLACE
93 version bigint Yes false None REPLACE
94 last_update_by bigint Yes false None REPLACE
95 last_update_time datetime Yes false None REPLACE
96 create_by bigint Yes false None REPLACE
97 create_time datetime Yes false None REPLACE
98 ref_count bigint Yes false None REPLACE
99 can_update smallint Yes false None REPLACE
100 can_delete smallint Yes false None REPLACE
101 mig_old_id varchar(384) Yes false None REPLACE
102 mig_update_time datetime Yes false None REPLACE
103 mig_migrate_log_id bigint Yes false None REPLACE
104 create_platform varchar(150) Yes false None REPLACE
105 create_user_id bigint Yes false None REPLACE
106 last_update_platform varchar(150) Yes false None REPLACE
107 last_update_user_id bigint Yes false None REPLACE
108 is_market_sku smallint Yes false None REPLACE
109 is_star smallint Yes false None REPLACE
110 good_type tinyint Yes false None REPLACE
111 bom_config_id bigint Yes false None REPLACE
112 source_sku_id bigint Yes false None REPLACE
================================================================================
检查 sensors_events 表结构
================================================================================
表字段列表：
Field Type Null Key Default Extra
0 id bigint No true None
1 ip varchar(128) Yes false None NONE
2 create_time datetime No false None NONE
3 last_update_time datetime Yes false None NONE
4 business_platform varchar(128) No false None NONE
5 client_platform varchar(128) No false None NONE
6 distinct_id varchar(128) No false None NONE
7 login_id int Yes false None NONE
8 anonymous_id varchar(128) Yes false None NONE
9 item_id int Yes false None NONE
10 item_type varchar(255) Yes false None NONE
11 event varchar(128) No false None NONE
12 location_src_type varchar(255) Yes false None NONE
13 location_src varchar(512) Yes false None NONE
14 search_content varchar(512) Yes false None NONE
15 page_type varchar(255) Yes false None NONE
16 module_name varchar(255) Yes false None NONE
17 position_name varchar(255) Yes false None NONE
18 channel_type varchar(512) Yes false None NONE
19 channel_mode varchar(1024) Yes false None NONE
20 channel_source varchar(512) Yes false None NONE
21 request_id bigint Yes false None NONE
22 session_id varchar(128) Yes false None NONE
23 session_duration int Yes false None NONE
24 stay_duration int Yes false None NONE
25 __properties json Yes false None NONE
26 __lib json Yes false None NONE
27 __identities json Yes false None NONE
28 __url_path varchar(1024) Yes false None NONE
29 __title varchar(2048) Yes false None NONE
30 __referrer_host varchar(128) Yes false None NONE
31 __is_first_day boolean Yes false None NONE
32 __is_first_time boolean Yes false None NONE
33 __os varchar(512) Yes false None NONE
34 __os_version varchar(512) Yes false None NONE
35 __browser varchar(512) Yes false None NONE
36 __browser_version varchar(255) Yes false None NONE
37 __browser_language varchar(255) Yes false None NONE
38 __screen_height int Yes false None NONE
39 __screen_width int Yes false None NONE
40 __user_agent varchar(512) Yes false None NONE
41 __url varchar(2048) Yes false None NONE
42 __element_type varchar(256) Yes false None NONE
43 __element_content varchar(1024) Yes false None NONE
44 __referrer varchar(1024) Yes false None NONE
================================================================================
检查完成
================================================================================
|