======================================================== 连接租户库: ylrz_saas_tenant_1 ======================================================== === 0) 所有表名（含 lobster / industry / company 字眼的）=== company company_ai_workflow company_ai_workflow_edge company_ai_workflow_edge_version company_ai_workflow_exec company_ai_workflow_exec_log company_ai_workflow_node company_ai_workflow_node_type company_ai_workflow_node_version company_ai_workflow_server company_ai_workflow_version company_bill company_bind_ai_model company_bind_gateway company_company_fsuser company_config company_course_redpacket company_deduct company_dept company_div_config company_div_item company_domain company_domain_bind company_domain_bind_user company_external_api_call_log company_external_api_config company_extract company_fs_user company_link company_lobster_dedup_config company_lobster_profile_config company_lobster_sensitive_word company_lobster_tag_user_rel company_logininfor company_menu company_miniapp company_money_logs company_oper_log company_post company_profit company_profit_logs company_recharge company_recharge_order company_red_package_logs company_red_packet_balance_deduction_record company_red_packet_balance_logs company_role company_role_dept company_role_menu company_sms company_sms_logs company_sms_order company_sms_package company_sms_temp company_sop_role company_tag company_tag_copy1 company_tag_group company_tag_template_binding company_tag_user company_tcm_consume company_tcm_report company_tcm_schedule company_traffic_record company_traffic_record_log company_user company_user_card company_user_change_apply company_user_change_apply_user company_user_delay_time company_user_license company_user_post company_user_role company_user_user company_voice company_voice_api company_voice_api_tenant company_voice_api_tiantian company_voice_blacklist company_voice_caller company_voice_clone_ref company_voice_config company_voice_dialog company_voice_logs company_voice_mobile company_voice_package company_voice_package_order company_voice_robotic company_voice_robotic_business company_voice_robotic_call_blacklist company_voice_robotic_call_log company_voice_robotic_call_log_addwx company_voice_robotic_call_log_callphone company_voice_robotic_call_log_sendmsg company_voice_robotic_callees company_voice_robotic_wx company_workflow_lobster company_workflow_lobster_edge company_workflow_lobster_node company_workflow_lobster_record company_workflow_lobster_task company_workflow_lobster_variable company_wx_account company_wx_chat company_wx_client company_wx_dialog company_wx_user company_wx_user_group fs_ai_workflow fs_ai_workflow_company_user fs_ai_workflow_company_voice fs_ai_workflow_edge fs_ai_workflow_node fs_ai_workflow_node_type fs_user_company_bind fs_user_company_package_scrm fs_user_company_user fs_user_company_user_qw fs_user_company_user_transfer_task fs_user_company_user_transfer_task_detail fs_user_course_company_statistics fs_user_course_company_user_time fs_user_course_period_company live_company_code lobster_api_registry lobster_billing_record lobster_channel_account lobster_channel_plugin_config lobster_chat_aggregate lobster_chat_record lobster_compliance_rule lobster_conversation_summary lobster_dead_letter_queue lobster_dialogue_state lobster_dynamic_node_impl lobster_dynamic_node_run lobster_e2e_run lobster_e2e_run_node lobster_event_audit_log lobster_event_node_audit lobster_evolution_log lobster_evolution_suggestion lobster_execution_config lobster_heartbeat_registry lobster_learned_pattern lobster_learning_corpus lobster_learning_event_log lobster_learning_replay_archive lobster_learning_replay_buffer lobster_message_delivery_log lobster_model_config lobster_node_execution_log lobster_optimization_suggestion lobster_profile_stats lobster_prompt_config lobster_sales_corpus lobster_sales_corpus_task lobster_system_prompt lobster_tenant_channel_grant lobster_tenant_keywords lobster_test_scenario lobster_unified_contact lobster_user_node_optimization lobster_user_preference lobster_user_profile lobster_user_segment lobster_vector_store lobster_workflow_instance lobster_workflow_node lobster_workflow_node_type qw_company qw_external_contact_transfer_company_audit qw_external_contact_transfer_company_audit_user store_company_code sys_dict_data sys_dict_type sys_dict_type_copy1 vc_company_user workflow_instance workflow_template ======================================================== 1) 企业表（company/tenant_company）行业字段 ======================================================== -- 表: company 列: [company_id, company_name, company_mobile, company_address, create_time, update_time, status, start_time, limit_time, money, tui_money, voice_api_id, voice_caller_number, company_type, user_id, app_id, app_key, remark, link_name, limit_user_count, corp_id, corp_agent_id, corp_json, is_del, oms_code, red_package_money, fs_user_is_default_black, manager, follow_doctor_ids, join_type, doctor_ids, address_id, restart_time, package_cate_ids, repeat, send_if_type, if_num, group_name, course_ma_app_id, course_mini_app_id, max_pad_num, custom_mini_app_id, dept_id, open_red_packet, company_belong_owner, live_show, is_open_rest_reminder] 行业相关列: [company_type, join_type, send_if_type] SQL: SELECT id, company_name, company_type, join_type, send_if_type FROM company WHERE del_flag='0' OR del_flag IS NULL ORDER BY id LIMIT 100 [ERR] Unknown column 'id' in 'field list' ======================================================== 2) 龙虾工作流表（lobster_workflow / company_workflow_lobster）行业字段 ======================================================== -- 表: company_workflow_lobster 列: [id, company_id, visible_company_ids, template_code, template_name, industry_type, description, canvas_data, execution_mode, enable_content_personalization, enable_flow_personalization, strict_fixed_workflow, auto_start_instance_on_tag, template_kind, source_template_id, status, version, create_by, create_time, update_by, update_time, del_flag] SQL: SELECT id, template_code, template_name, industry_type, status FROM company_workflow_lobster WHERE del_flag='0' OR del_flag IS NULL ORDER BY id LIMIT 200 id=17 | template_code=LOB_1779873851433 | template_name=AI生成工作流方案 | industry_type=餐饮（反向营销“难吃到死”的特色龙虾） | status=0 id=18 | template_code=LOB_1779937813590 | template_name=AI生成工作流方案 | industry_type=我是云联开发者，帮我推销ai写代码的业务 | status=0 id=19 | template_code=LOB_1780451269028 | template_name=AI生成工作流方案 | industry_type=电商 | status=0 id=22 | template_code=TRAVEL_TOP_SALES_001 | template_name=旅游销冠全流程 | industry_type=旅游 | status=1 共 4 行 ======================================================== 3) 行业相关字典/配置表 ======================================================== -- 表: sys_dict_type SQL: SELECT * FROM sys_dict_type WHERE dict_type LIKE '%industry%' OR dict_type LIKE '%lobster%' OR dict_type LIKE '%scene%' LIMIT 200 dict_id=187 | dict_name=企业客户群成员入群方式 | dict_type=sys_qw_groupChat_user_scene | status=0 | dict_source=tenant | is_platform_managed=0 | create_by=sgw | create_time=2024-06-25 18:01:04 | update_by=sgw | update_time=2024-06-25 18:14:10 | remark=null dict_id=198 | dict_name=企业客户退群方式 | dict_type=sys_qw_groupChar_quitScene | status=0 | dict_source=tenant | is_platform_managed=0 | create_by=sgw | create_time=2024-07-04 12:42:06 | update_by= | update_time=null | remark=null 共 2 行 -- 表: sys_dict_data SQL: SELECT * FROM sys_dict_data WHERE dict_type LIKE '%industry%' OR dict_type LIKE '%lobster%' OR dict_label LIKE '%行业%' OR dict_label LIKE '%龙虾%' OR dict_type LIKE '%scene%' LIMIT 200 dict_code=1183 | dict_sort=1 | dict_label=由群成员邀请入群 | dict_value=1 | dict_type=sys_qw_groupChat_user_scene | css_class=null | list_class=default | is_default=N | status=0 | dict_source=tenant | is_platform_managed=0 | create_by=sgw | create_time=2024-06-25 18:01:29 | update_by= | update_time=null | remark=null dict_code=1184 | dict_sort=2 | dict_label=通过邀请链接入群 | dict_value=2 | dict_type=sys_qw_groupChat_user_scene | css_class=null | list_class=default | is_default=N | status=0 | dict_source=tenant | is_platform_managed=0 | create_by=sgw | create_time=2024-06-25 18:01:50 | update_by= | update_time=null | remark=null dict_code=1185 | dict_sort=3 | dict_label=通过扫描群二维码入群 | dict_value=3 | dict_type=sys_qw_groupChat_user_scene | css_class=null | list_class=default | is_default=N | status=0 | dict_source=tenant | is_platform_managed=0 | create_by=sgw | create_time=2024-06-25 18:02:16 | update_by=sgw | update_time=2024-06-25 18:02:29 | remark=null dict_code=1216 | dict_sort=1 | dict_label=自己退群 | dict_value=0 | dict_type=sys_qw_groupChar_quitScene | css_class=null | list_class=warning | is_default=N | status=0 | dict_source=tenant | is_platform_managed=0 | create_by=sgw | create_time=2024-07-04 12:42:58 | update_by= | update_time=null | remark=null dict_code=1217 | dict_sort=2 | dict_label=群主/群管理员移出 | dict_value=1 | dict_type=sys_qw_groupChar_quitScene | css_class=null | list_class=danger | is_default=N | status=0 | dict_source=tenant | is_platform_managed=0 | create_by=sgw | create_time=2024-07-04 12:43:09 | update_by=sgw | update_time=2024-07-04 12:43:15 | remark=null dict_code=1228 | dict_sort=0 | dict_label=由成员邀请入群 | dict_value=0 | dict_type=sys_qw_groupChat_user_scene | css_class=null | list_class=default | is_default=N | status=0 | dict_source=tenant | is_platform_managed=0 | create_by=sgw | create_time=2024-07-17 13:47:53 | update_by= | update_time=null | remark=null 共 6 行 -- 行业/龙虾相关配置表清单： lobster_api_registry lobster_billing_record lobster_channel_account lobster_channel_plugin_config lobster_chat_aggregate lobster_chat_record lobster_compliance_rule lobster_conversation_summary lobster_dead_letter_queue lobster_dialogue_state lobster_dynamic_node_impl lobster_dynamic_node_run lobster_e2e_run lobster_e2e_run_node lobster_event_audit_log lobster_event_node_audit lobster_evolution_log lobster_evolution_suggestion lobster_execution_config lobster_heartbeat_registry lobster_learned_pattern lobster_learning_corpus lobster_learning_event_log lobster_learning_replay_archive lobster_learning_replay_buffer lobster_message_delivery_log lobster_model_config lobster_node_execution_log lobster_optimization_suggestion lobster_profile_stats lobster_prompt_config lobster_sales_corpus lobster_sales_corpus_task lobster_system_prompt lobster_tenant_channel_grant lobster_tenant_keywords lobster_test_scenario lobster_unified_contact lobster_user_node_optimization lobster_user_preference lobster_user_profile lobster_user_segment lobster_vector_store lobster_workflow_instance lobster_workflow_node lobster_workflow_node_type >>> 表 lobster_api_registry 列: [id, api_name, api_key, api_url, api_type, api_description, request_method, request_headers, request_body_template, response_mapping, enabled, priority, is_backup, description, category, provider, base_url, auth_type, auth_config, timeout, company_id, create_by, create_time, update_by, update_time] >>> 表 lobster_billing_record 列: [id, billing_type, token_count, token_coefficient, amount, workflow_instance_id, node_code, model_name, company_id, create_time] >>> 表 lobster_channel_account 列: [id, company_id, channel_type, account_code, account_name, config_json, enabled, is_default, sort_order, create_time, update_time] id=1 | company_id=0 | channel_type=WHATSAPP | account_code=default | account_name=WHATSAPP-default | config_json={} | enabled=0 | is_default=1 | sort_order=0 | create_time=2026-06-20 16:52:45 | update_time=2026-06-20 16:52:45 id=2 | company_id=0 | channel_type=LINE | account_code=default | account_name=LINE-default | config_json={} | enabled=0 | is_default=1 | sort_order=0 | create_time=2026-06-20 16:52:45 | update_time=2026-06-20 16:52:45 id=3 | company_id=0 | channel_type=TELEGRAM | account_code=default | account_name=TELEGRAM-default | config_json={} | enabled=0 | is_default=1 | sort_order=0 | create_time=2026-06-20 16:52:45 | update_time=2026-06-20 16:52:45 id=4 | company_id=0 | channel_type=APP_IM | account_code=default | account_name=APP_IM-default | config_json={} | enabled=0 | is_default=1 | sort_order=0 | create_time=2026-06-20 16:52:45 | update_time=2026-06-20 16:52:45 id=5 | company_id=0 | channel_type=TMALL | account_code=default | account_name=TMALL-default | config_json={} | enabled=0 | is_default=1 | sort_order=0 | create_time=2026-06-20 16:52:45 | update_time=2026-06-20 16:52:45 >>> 表 lobster_channel_plugin_config 列: [id, company_id, channel_type, enabled, config_json, create_time, update_time] id=1 | company_id=0 | channel_type=QW | enabled=1 | config_json={} | create_time=2026-06-20 16:39:47 | update_time=2026-06-20 18:16:15 id=2 | company_id=0 | channel_type=WX | enabled=1 | config_json={} | create_time=2026-06-20 16:39:47 | update_time=2026-06-20 18:16:15 id=3 | company_id=0 | channel_type=IM | enabled=1 | config_json={} | create_time=2026-06-20 16:39:47 | update_time=2026-06-20 18:16:09 id=4 | company_id=0 | channel_type=WHATSAPP | enabled=0 | config_json={} | create_time=2026-06-20 16:39:47 | update_time=2026-06-20 16:39:47 id=5 | company_id=0 | channel_type=LINE | enabled=0 | config_json={} | create_time=2026-06-20 16:39:47 | update_time=2026-06-20 16:39:47 >>> 表 lobster_chat_aggregate 列: [id, session_id, external_user_id, channel_type, message_type, content, direction, workflow_instance_id, node_code, company_id, create_time] >>> 表 lobster_chat_record 列: [id, company_id, instance_id, external_user_id, session_id, msg_id, direction, content, channel_type, message_time, deleted] >>> 表 lobster_compliance_rule 列: [id, company_id, rule_name, rule_type, pattern, description, action, severity, enabled, del_flag, create_by, create_time, update_by, update_time] >>> 表 lobster_conversation_summary 列: [id, company_id, instance_id, contact_id, external_user_id, channel_type, summary_type, summary_content, key_points, sentiment_analysis, next_action_suggestion, message_count, del_flag, create_by, create_time, update_by, update_time, summary_text, customer_attitude, stage, chat_msg_count, key_intents, key_variables, customer_concerns, customer_intention_level, customer_questions, extended_summary, next_action_hint] >>> 表 lobster_dead_letter_queue 列: [id, workflow_instance_id, node_code, error_message, payload, retry_count, status, company_id, create_time, update_time] >>> 表 lobster_dialogue_state 列: [id, company_id, instance_id, external_user_id, channel_type, node_code, detected_intent, sentiment, last_reply, state_json, update_time, create_time] >>> 表 lobster_dynamic_node_impl 列: [id, company_id, node_type, node_type_code, fingerprint, sub_dsl_json, prompt_used, source_model, quality_score, exec_count, success_count, avg_duration_ms, status, last_exec_time, reviewed_by, reviewed_time, reject_reason, create_time, update_time] >>> 表 lobster_dynamic_node_run 列: [id, impl_id, node_type, company_id, instance_id, fingerprint, duration_ms, success, score, exec_path, input_context, output_result, error_msg, create_time] >>> 表 lobster_e2e_run 列: [id, run_id, company_id, template_id, instance_id, scenario_id, business_desc, total_score, passed_node_cnt, total_node_cnt, duration_ms, status, error_msg, evolution_count, create_by, create_time, update_time] >>> 表 lobster_e2e_run_node 列: [id, run_id, node_seq, node_code, node_type, node_name, turn_no, user_input, ai_output, score, score_detail, duration_ms, model_used, evolution_hint, passed, error_msg, create_time] >>> 表 lobster_event_audit_log 列: [id, workflow_instance_id, node_code, event_type, event_data, audit_status, auditor, audit_remark, company_id, create_time, update_time] >>> 表 lobster_event_node_audit 列: [id, company_id, instance_id, workflow_id, node_key, node_name, node_type, node_json, insert_at, insert_ref_node, decision_engine, decision_score, decision_reason, status, audit_by, audit_comment, audit_time, create_time, update_time] >>> 表 lobster_evolution_log 列: [id, company_id, workflow_id, instance_id, contact_id, channel_type, node_code, sent_message, customer_reply, outcome, variables, duration_ms, create_time] id=1 | company_id=1 | workflow_id=1 | instance_id=5 | contact_id=10004 | channel_type=QW | node_code=AI意图识别 | sent_message=null | customer_reply=hello | outcome=other | variables={"replyCount":1,"contactName":"游客-赵六","lastReply":"hello","customerIntent":"othe... | duration_ms=null | create_time=2026-05-09 23:21:37 id=2 | company_id=1 | workflow_id=1 | instance_id=5 | contact_id=10004 | channel_type=QW | node_code=发送旅游方案 | sent_message=null | customer_reply=想了解亲子游路线推荐 | outcome=other | variables={"replyCount":2,"contactName":"游客-赵六","lastReply":"想了解亲子游路线推荐","customerIntent":... | duration_ms=null | create_time=2026-05-09 23:21:38 id=3 | company_id=1 | workflow_id=1 | instance_id=5 | contact_id=10004 | channel_type=QW | node_code=等待客户回复 | sent_message=null | customer_reply=价格方面呢？有没有优惠？ | outcome=purchase | variables={"replyCount":3,"contactName":"游客-赵六","lastReply":"价格方面呢？有没有优惠？","customerIntent... | duration_ms=null | create_time=2026-05-09 23:21:39 id=4 | company_id=1 | workflow_id=1 | instance_id=6 | contact_id=10099 | channel_type=QW | node_code=开始 | sent_message=null | customer_reply=想了解亲子游 | outcome=other | variables={"nodeRound_start":1,"replyCount":1,"contactName":"游客-验证","lastReply":"想了解亲子游","... | duration_ms=null | create_time=2026-05-10 08:15:35 id=5 | company_id=1 | workflow_id=1 | instance_id=6 | contact_id=10099 | channel_type=QW | node_code=AI意图识别 | sent_message=null | customer_reply=预算5000左右 | outcome=other | variables={"nodeRound_start":1,"replyCount":2,"contactName":"游客-验证","lastReply":"预算5000左右"... | duration_ms=null | create_time=2026-05-10 08:15:35 >>> 表 lobster_evolution_suggestion 列: [id, company_id, workflow_id, node_code, channel_type, suggestion_type, current_content, suggested_content, previous_content, confidence, sample_size, reason, status, apply_time, create_time] >>> 表 lobster_execution_config 列: [id, company_id, default_execution_mode, auto_start_instance_on_tag, quality_gate_enabled, quality_pass_score_percent, quality_target_score_percent, quality_min_node_score_percent, quality_min_e2e_avg_score_percent, quality_multiturn_min_avg_score_percent, message_dedup_enabled, message_dedup_exact_window_size, message_dedup_semantic_threshold, message_dedup_window_duration_seconds, create_by, create_time, update_by, update_time] id=1 | company_id=0 | default_execution_mode=HYBRID | auto_start_instance_on_tag=1 | quality_gate_enabled=1 | quality_pass_score_percent=70 | quality_target_score_percent=75 | quality_min_node_score_percent=60 | quality_min_e2e_avg_score_percent=75 | quality_multiturn_min_avg_score_percent=45 | message_dedup_enabled=1 | message_dedup_exact_window_size=5 | message_dedup_semantic_threshold=0.85 | message_dedup_window_duration_seconds=300 | create_by=admin | create_time=2026-06-20 22:26:18 | update_by=admin | update_time=2026-06-21 01:40:13 >>> 表 lobster_heartbeat_registry 列: [id, instance_id, company_id, workflow_id, contact_id, channel_type, interval_ms, timeout_ms, max_retries, auto_execute, status, last_heartbeat, create_time, update_time] >>> 表 lobster_learned_pattern 列: [id, company_id, pattern_type, pattern_key, pattern_value, confidence, source, create_time, update_time] id=1 | company_id=1 | pattern_type=skill_staged | pattern_key=skill_phase2_smoke_node | pattern_value=???[phase2_smoke_node] ??????? (140/160) ???: smoke customer message 2 ???: smok... | confidence=0.88 | source=EvolutionReplay | create_time=2026-06-13 23:59:39 | update_time=2026-06-14 00:01:39 >>> 表 lobster_learning_corpus 列: [id, company_id, salesperson_name, customer_question, sales_answer, scenario, industry_type, tags, status, ai_analysis, usage_count, analyze_time, create_time, update_time] >>> 表 lobster_learning_event_log 列: [id, company_id, instance_id, node_code, event_type, quality_score, context_snapshot, create_time] id=1 | company_id=1 | instance_id=1781366379101 | node_code=phase2_smoke_node | event_type=smoke_test | quality_score=140.0 | context_snapshot={"qualityScore":140} | create_time=2026-06-13 23:59:39 id=2 | company_id=1 | instance_id=1781366379102 | node_code=phase2_smoke_node | event_type=smoke_test | quality_score=140.0 | context_snapshot={"qualityScore":140} | create_time=2026-06-13 23:59:39 id=3 | company_id=1 | instance_id=1781366498773 | node_code=phase2_smoke_node | event_type=smoke_test | quality_score=140.0 | context_snapshot={"qualityScore":140} | create_time=2026-06-14 00:01:39 id=4 | company_id=1 | instance_id=1781366498774 | node_code=phase2_smoke_node | event_type=smoke_test | quality_score=140.0 | context_snapshot={"qualityScore":140} | create_time=2026-06-14 00:01:39 >>> 表 lobster_learning_replay_archive 列: [id, company_id, instance_id, node_code, customer_message, ai_reply, quality_score, create_time, archived_time] >>> 表 lobster_learning_replay_buffer 列: [id, company_id, instance_id, node_code, customer_message, ai_reply, quality_score, create_time] id=1 | company_id=1 | instance_id=1781366379101 | node_code=phase2_smoke_node | customer_message=smoke customer message 1 | ai_reply=smoke ai reply 1 at 1781366379100 | quality_score=140.0 | create_time=2026-06-13 23:59:39 id=2 | company_id=1 | instance_id=1781366379102 | node_code=phase2_smoke_node | customer_message=smoke customer message 2 | ai_reply=smoke ai reply 2 at 1781366379218 | quality_score=140.0 | create_time=2026-06-13 23:59:39 id=3 | company_id=1 | instance_id=1781366498773 | node_code=phase2_smoke_node | customer_message=smoke customer message 1 | ai_reply=smoke ai reply 1 at 1781366498772 | quality_score=140.0 | create_time=2026-06-14 00:01:39 id=4 | company_id=1 | instance_id=1781366498774 | node_code=phase2_smoke_node | customer_message=smoke customer message 2 | ai_reply=smoke ai reply 2 at 1781366498886 | quality_score=140.0 | create_time=2026-06-14 00:01:39 >>> 表 lobster_message_delivery_log 列: [id, company_id, instance_id, workflow_id, contact_id, channel_type, channel_user_id, content, msg_type, channel_msg_id, success, error_msg, create_time] >>> 表 lobster_model_config 列: [id, model_name, model_key, provider, api_endpoint, max_tokens, temperature, enabled, token_coefficient, company_id, create_by, create_time, update_by, update_time] >>> 表 lobster_node_execution_log 列: [id, company_id, instance_id, workflow_id, node_index, node_type, node_name, input_content, output_content, status, retry_count, del_flag, create_by, create_time, update_by, update_time, ai_model, duration_ms, token_usage, error_message] id=1 | company_id=1 | instance_id=3 | workflow_id=1 | node_index=0 | node_type=1 | node_name=开始 | input_content=null | output_content= | status=sent | retry_count=0 | del_flag=0 | create_by=system | create_time=2026-05-09 22:02:09 | update_by=system | update_time=2026-05-09 22:02:09 | ai_model=null | duration_ms=null | token_usage=null | error_message=null id=2 | company_id=1 | instance_id=3 | workflow_id=1 | node_index=0 | node_type=1 | node_name=开始 | input_content=null | output_content=null | status=received | retry_count=0 | del_flag=0 | create_by=system | create_time=2026-05-09 22:04:11 | update_by=system | update_time=2026-05-09 22:04:11 | ai_model=null | duration_ms=null | token_usage=null | error_message=null id=3 | company_id=1 | instance_id=3 | workflow_id=1 | node_index=1 | node_type=2 | node_name=AI意图识别 | input_content=null | output_content= | status=sent | retry_count=0 | del_flag=0 | create_by=system | create_time=2026-05-09 22:04:11 | update_by=system | update_time=2026-05-09 22:04:11 | ai_model=null | duration_ms=null | token_usage=null | error_message=null id=4 | company_id=1 | instance_id=3 | workflow_id=1 | node_index=1 | node_type=2 | node_name=AI意图识别 | input_content=null | output_content=null | status=received | retry_count=0 | del_flag=0 | create_by=system | create_time=2026-05-09 22:07:57 | update_by=system | update_time=2026-05-09 22:07:57 | ai_model=null | duration_ms=null | token_usage=null | error_message=null id=5 | company_id=1 | instance_id=3 | workflow_id=1 | node_index=2 | node_type=3 | node_name=发送旅游方案 | input_content=null | output_content= | status=sent | retry_count=0 | del_flag=0 | create_by=system | create_time=2026-05-09 22:07:57 | update_by=system | update_time=2026-05-09 22:07:57 | ai_model=null | duration_ms=null | token_usage=null | error_message=null >>> 表 lobster_optimization_suggestion 列: [id, workflow_id, suggestion_type, suggestion_content, score, status, applied_at, company_id, create_by, create_time, update_by, update_time] >>> 表 lobster_profile_stats 列: [company_id, total_profiles, enriched_count, interaction_sum, avg_conversations, active_today, refresh_time] company_id=0 | total_profiles=0 | enriched_count=0 | interaction_sum=0 | avg_conversations=0.00 | active_today=0 | refresh_time=2026-06-23 00:44:15 >>> 表 lobster_prompt_config 列: [id, company_id, workflow_code, node_code, prompt_type, content, scope, deleted, create_time, update_time] >>> 表 lobster_sales_corpus 列: [id, dialog_text, customer_question, sales_answer, scenario, score, source_type, external_user_id, company_id, task_id, salesperson_name, tags, status, quality_status, optimized_answer, ai_feedback, kb_written, enabled, create_by, create_time, update_by, update_time, content, source, usage_count] >>> 表 lobster_sales_corpus_task 列: [id, company_id, batch_no, task_name, salesperson_name, scenario, total_count, qualified_count, optimizable_count, optimized_count, kb_written_count, overall_score, ai_summary, status, create_by, create_time, update_by, update_time] >>> 表 lobster_system_prompt 列: [id, prompt_key, prompt_name, prompt_category, prompt_content, model_name, system_role, enabled, sort_order, create_by, create_time, update_time, company_id, industry_type] id=1 | prompt_key=rag_vector_llm | prompt_name=RAG向量检索LLM | prompt_category=rag | prompt_content=根据以下知识库内容回答问题，如果内容不相关请直接说明： 【问题】{query} 【知识库内容】 {context} 请用简洁的语言回答，引用来源时标注【来源... | model_name=doubao-lite | system_role=你是企业知识库助手，只基于提供的知识回答问题 | enabled=1 | sort_order=0 | create_by=admin | create_time=2026-05-10 09:51:42 | update_time=2026-05-10 09:51:42 | company_id=null | industry_type=null id=2 | prompt_key=rag_fallback_llm | prompt_name=RAG兜底LLM | prompt_category=rag | prompt_content=请根据以下知识库内容回答问题，如果知识库中没有相关信息请直接说明。 问题：{query} 知识库：请参考公司内部文档和课程资料（通过语义匹配检索） | model_name=doubao-lite | system_role=你是企业知识库助手，请基于内部知识回答问题 | enabled=1 | sort_order=0 | create_by=admin | create_time=2026-05-10 09:51:42 | update_time=2026-05-10 09:51:42 | company_id=null | industry_type=null id=3 | prompt_key=code_exec_result | prompt_name=代码执行结果消息 | prompt_category=code | prompt_content=代码执行完成：{codeResult} | model_name=doubao-lite | system_role=null | enabled=1 | sort_order=0 | create_by=admin | create_time=2026-05-10 09:51:42 | update_time=2026-05-10 09:51:42 | company_id=null | industry_type=null id=4 | prompt_key=collect_info_question | prompt_name=信息收集提问 | prompt_category=code_collect | prompt_content=请问您的{nextField}是什么？ | model_name=doubao-lite | system_role=null | enabled=1 | sort_order=0 | create_by=admin | create_time=2026-05-10 09:51:42 | update_time=2026-06-24 07:57:27 | company_id=null | industry_type=null id=5 | prompt_key=collect_info_done | prompt_name=信息收集完成 | prompt_category=code_collect | prompt_content=感谢您的配合，信息收集完成！ | model_name=doubao-lite | system_role=null | enabled=1 | sort_order=0 | create_by=admin | create_time=2026-05-10 09:51:42 | update_time=2026-06-24 07:57:27 | company_id=null | industry_type=null >>> 表 lobster_tenant_channel_grant 列: [id, tenant_id, channel_type, granted, create_by, create_time, update_by, update_time] >>> 表 lobster_tenant_keywords 列: [id, company_id, category, keywords, enabled, create_time, update_time] >>> 表 lobster_test_scenario 列: [id, company_id, scenario_name, business_desc, template_id, user_inputs_json, expected_nodes, min_score, enabled, cron, last_run_id, last_run_status, last_run_time, create_by, create_time, update_time] >>> 表 lobster_unified_contact 列: [id, company_id, contact_id, contact_name, contact_phone, channel_type, channel_user_id, extra, del_flag, create_time, update_time] >>> 表 lobster_user_node_optimization 列: [id, company_id, workflow_id, external_user_id, node_code, original_content, optimized_content, optimization_type, confidence, optimization_reason, optimization_detail, status, auditor_id, audit_remark, audit_time, apply_time, create_time] >>> 表 lobster_user_preference 列: [id, company_id, external_user_id, channel_type, snapshot_json, create_time, update_time] >>> 表 lobster_user_profile 列: [id, company_id, external_user_id, channel_type, nickname, persona, current_state, internal_tags, total_purchase, last_active_time, interaction_count, variable_snapshot, latest_stage, latest_customer_attitude, latest_summary_text, profile_aggregate_preview, latest_summary_time, lifecycle_stage, value_score, deleted, create_time, update_time] >>> 表 lobster_user_segment 列: [id, company_id, segment_code, segment_name, description, strategy_config, deleted, create_time, update_time] id=1 | company_id=1 | segment_code=CHURN | segment_name=流失用户 | description=无消费且>90天未活跃，或有消费但>90天未活跃 | strategy_config={"thresholds":{"newMaxInteraction":0,"activeMinInteraction":20,"sleepMinDays":31... | deleted=0 | create_time=2026-06-23 00:33:16 | update_time=2026-06-23 00:33:16 id=2 | company_id=1 | segment_code=DORMANT | segment_name=流失预警 | description=有消费，61-90天未活跃 | strategy_config={"thresholds":{"newMaxInteraction":0,"activeMinInteraction":20,"sleepMinDays":31... | deleted=0 | create_time=2026-06-23 00:33:16 | update_time=2026-06-23 00:33:16 id=3 | company_id=1 | segment_code=SLEEP | segment_name=沉睡用户 | description=有消费，31-60天未活跃 | strategy_config={"thresholds":{"newMaxInteraction":0,"activeMinInteraction":20,"sleepMinDays":31... | deleted=0 | create_time=2026-06-23 00:33:16 | update_time=2026-06-23 00:33:16 id=4 | company_id=1 | segment_code=ACTIVE | segment_name=活跃用户 | description=有消费且最近30天内活跃，或交互>=20次 | strategy_config={"thresholds":{"newMaxInteraction":0,"activeMinInteraction":20,"sleepMinDays":31... | deleted=0 | create_time=2026-06-23 00:33:16 | update_time=2026-06-23 00:33:16 id=5 | company_id=1 | segment_code=NEW | segment_name=新用户 | description=无消费且活跃<=7天的新接入客户 | strategy_config={"thresholds":{"newMaxInteraction":0,"activeMinInteraction":20,"sleepMinDays":31... | deleted=0 | create_time=2026-06-23 00:33:16 | update_time=2026-06-23 00:33:16 >>> 表 lobster_vector_store 列: [id, company_id, category, vec_key, text_content, vector, metadata, create_time, update_time] >>> 表 lobster_workflow_instance 列: [id, company_id, workflow_id, binding_id, instance_name, status, contact_id, contact_name, channel_type, dept_id, company_user_id, qw_user_id, wx_account_id, current_node_index, current_node_name, total_nodes, completed_nodes, context_snapshot, variables, start_time, end_time, last_activity_time, error_message, del_flag, create_by, create_time, update_by, update_time, handoff_agent, handoff_reason, control_mode, control_updated_by, control_updated_at] id=3 | company_id=1 | workflow_id=1 | binding_id=null | instance_name=旅游跟团客户转化模版-1778335328746 | status=completed | contact_id=10002 | contact_name=null | channel_type=QW | dept_id=null | company_user_id=null | qw_user_id=null | wx_account_id=null | current_node_index=7 | current_node_name=结束 | total_nodes=8 | completed_nodes=8 | context_snapshot=null | variables={"travelType":"???","contactName":"??-??","channelType":"QW","contactPhone":"139... | start_time=2026-05-09 22:02:08 | end_time=2026-05-09 22:07:57 | last_activity_time=2026-05-09 22:07:57 | error_message=null | del_flag=0 | create_by=system | create_time=2026-05-09 22:02:09 | update_by=system | update_time=2026-05-09 22:07:58 | handoff_agent=null | handoff_reason=null | control_mode=ai | control_updated_by=null | control_updated_at=null id=4 | company_id=1 | workflow_id=1 | binding_id=null | instance_name=旅游跟团客户转化模版-1778335965133 | status=running | contact_id=10003 | contact_name=null | channel_type=QW | dept_id=null | company_user_id=null | qw_user_id=null | wx_account_id=null | current_node_index=1 | current_node_name=AI意图识别 | total_nodes=8 | completed_nodes=1 | context_snapshot=null | variables={"contactName":"游客-王五","channelType":"QW"} | start_time=2026-05-09 22:12:45 | end_time=null | last_activity_time=2026-05-09 22:12:45 | error_message=null | del_flag=0 | create_by=system | create_time=2026-05-09 22:12:45 | update_by=system | update_time=2026-05-09 22:12:45 | handoff_agent=null | handoff_reason=null | control_mode=ai | control_updated_by=null | control_updated_at=null id=5 | company_id=1 | workflow_id=1 | binding_id=null | instance_name=旅游跟团客户转化模版-1778340095713 | status=running | contact_id=10004 | contact_name=null | channel_type=QW | dept_id=null | company_user_id=null | qw_user_id=null | wx_account_id=null | current_node_index=4 | current_node_name=客户跟进判断 | total_nodes=8 | completed_nodes=4 | context_snapshot=null | variables={"replyCount":3,"contactName":"游客-赵六","lastReply":"价格方面呢？有没有优惠？","customerIntent... | start_time=2026-05-09 23:21:35 | end_time=null | last_activity_time=2026-05-09 23:21:39 | error_message=null | del_flag=0 | create_by=system | create_time=2026-05-09 23:21:36 | update_by=system | update_time=2026-05-09 23:21:39 | handoff_agent=null | handoff_reason=null | control_mode=ai | control_updated_by=null | control_updated_at=null id=6 | company_id=1 | workflow_id=1 | binding_id=null | instance_name=旅游跟团客户转化模版-1778372134429 | status=running | contact_id=10099 | contact_name=null | channel_type=QW | dept_id=null | company_user_id=null | qw_user_id=null | wx_account_id=null | current_node_index=1 | current_node_name=AI意图识别 | total_nodes=11 | completed_nodes=1 | context_snapshot=null | variables={"nodeRound_start":1,"replyCount":1,"contactName":"游客-验证","lastReply":"想了解亲子游","... | start_time=2026-05-10 08:15:34 | end_time=null | last_activity_time=2026-05-10 08:15:35 | error_message=null | del_flag=0 | create_by=system | create_time=2026-05-10 08:15:34 | update_by=system | update_time=2026-05-10 08:15:35 | handoff_agent=null | handoff_reason=null | control_mode=ai | control_updated_by=null | control_updated_at=null id=7 | company_id=1 | workflow_id=1 | binding_id=null | instance_name=旅游跟团客户转化模版-1778372591169 | status=pending_human | contact_id=10088 | contact_name=null | channel_type=QW | dept_id=null | company_user_id=null | qw_user_id=null | wx_account_id=null | current_node_index=7 | current_node_name=人工客服 | total_nodes=11 | completed_nodes=7 | context_snapshot=null | variables={"nodeRound_start":1,"replyCount":1,"contactName":"游客-多轮测试","lastReply":"想了解亲子游"... | start_time=2026-05-10 08:23:11 | end_time=null | last_activity_time=2026-05-10 08:23:14 | error_message=null | del_flag=0 | create_by=system | create_time=2026-05-10 08:23:11 | update_by=system | update_time=2026-05-10 08:23:14 | handoff_agent=null | handoff_reason=null | control_mode=ai | control_updated_by=null | control_updated_at=null >>> 表 lobster_workflow_node 列: [id, instance_id, node_code, node_config, deleted, create_time] >>> 表 lobster_workflow_node_type 列: [id, node_type, node_name, code_name, description, category, icon, color, template_json, enabled, sort_order, created_at, updated_at] id=1 | node_type=1 | node_name=???? | code_name=START | description=???????????????????? | category=basic | icon=el-icon-video-play | color=#22c55e | template_json=null | enabled=1 | sort_order=1 | created_at=2026-06-02 14:35:03 | updated_at=2026-06-03 14:47:28 id=2 | node_type=2 | node_name=???? | code_name=MESSAGE | description=AI ??????? AI ???????????????? | category=flow | icon=el-icon-message | color=#3b82f6 | template_json=null | enabled=1 | sort_order=2 | created_at=2026-06-02 14:35:03 | updated_at=2026-06-03 14:47:28 id=3 | node_type=3 | node_name=???? | code_name=CONDITION | description=???????????/???/?????????? | category=flow | icon=el-icon-question | color=#f59e0b | template_json=null | enabled=1 | sort_order=3 | created_at=2026-06-02 14:35:03 | updated_at=2026-06-03 14:47:28 id=4 | node_type=4 | node_name=???? | code_name=WAIT | description=????????/?????????? | category=flow | icon=el-icon-time | color=#8b5cf6 | template_json=null | enabled=1 | sort_order=4 | created_at=2026-06-02 14:35:03 | updated_at=2026-06-03 14:47:28 id=5 | node_type=5 | node_name=???? | code_name=END | description=???????????? | category=basic | icon=el-icon-video-pause | color=#ef4444 | template_json=null | enabled=1 | sort_order=5 | created_at=2026-06-02 14:35:03 | updated_at=2026-06-03 14:47:28