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 ================================================================================ 检查完成 ================================================================================