ylrz_saas_pharmacy/java/scripts/investigate-output.txt

========================================================
 连接租户库: 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