Ellm2.1 chat

Tables (34)

ellm_faq

  • doc_id — VARCHAR
  • item_name — VARCHAR
  • title — VARCHAR
  • content — TEXT
  • created_ts — BIGINT
  • updated_ts — BIGINT

ellm_index_template

  • id — VARCHAR
  • name — VARCHAR
  • description — TEXT
  • instance_writing_guide — TEXT
  • sections — TEXT
  • share_type — VARCHAR
  • created_by — VARCHAR
  • created_ts — BIGINT
  • updated_ts — BIGINT

ellm_index_template_attachment

  • id — VARCHAR — Primary key — NOT NULL
  • template_id — VARCHAR
  • filename — VARCHAR
  • path — VARCHAR
  • attachment_type — VARCHAR
  • created_ts — BIGINT
  • updated_ts — BIGINT

ellm_index_template_share

  • template_id — VARCHAR
  • group_id — VARCHAR

ellm_mcp_endpoint

  • id — VARCHAR
  • name — VARCHAR
  • description — VARCHAR
  • url — VARCHAR
  • transport — VARCHAR
  • api_key_type — VARCHAR(16)
  • api_key — VARCHAR
  • is_active — BOOLEAN
  • created_ts — BIGINT
  • updated_ts — BIGINT
  • details — TEXT

ellm_mcp_endpoint_user

  • mcp_endpoint_id — VARCHAR
  • user_id — VARCHAR — 현재 userId 기준으로 사용 권한 관리 기능은 없음
  • api_key — VARCHAR
  • created_ts — BIGINT
  • updated_ts — BIGINT

ellm_prompt_template

  • id — VARCHAR
  • title — VARCHAR
  • content — TEXT
  • created_by — VARCHAR
  • created_ts — BIGINT
  • updated_ts — BIGINT

ellm_scribe_instance

  • id — VARCHAR
  • item_name — VARCHAR
  • template_id — VARCHAR
  • title — VARCHAR
  • stage — VARCHAR
  • instruction — TEXT
  • created_ts — BIGINT
  • updated_ts — BIGINT
  • confirm_generation — BOOLEAN
  • expired_ts — BIGINT
  • create_user_id — VARCHAR
  • create_user_dept_code — VARCHAR(64)
  • create_user_position_code — VARCHAR(64)

ellm_scribe_instance_attachment

  • id — VARCHAR — Primary key — NOT NULL
  • instance_id — VARCHAR
  • filename — VARCHAR
  • path — VARCHAR
  • attachment_type — VARCHAR
  • attachment_status — VARCHAR
  • created_ts — BIGINT
  • updated_ts — BIGINT

ellm_scribe_instance_llm_setting

  • id — VARCHAR — Primary key — NOT NULL
  • instance_id — VARCHAR
  • instruction — TEXT
  • writing_guide — TEXT
  • topic — VARCHAR
  • outline — TEXT
  • additional_context — TEXT
  • keywords — VARCHAR
  • urls — VARCHAR
  • key_sentences — VARCHAR

ellm_scribe_instance_participant

  • instance_id — VARCHAR — Primary key — NOT NULL
  • user_id — VARCHAR — Primary key — NOT NULL
  • authority — VARCHAR — NOT NULL
  • joined_ts — BIGINT
  • last_edit_ts — BIGINT

ellm_scribe_llm_search_result

  • id — VARCHAR
  • instance_id — VARCHAR
  • section_id — VARCHAR
  • source_type — VARCHAR — NOT NULL
  • search_query — TEXT
  • search_result — TEXT
  • citations — JSONB
  • search_date — BIGINT
  • user_info — JSONB
  • llm_model_name — VARCHAR
  • request_api_url — VARCHAR
  • request_client_type — VARCHAR

ellm_scribe_mind_map

  • id — VARCHAR — Primary key — NOT NULL
  • instance_id — VARCHAR — NOT NULL
  • type — VARCHAR(32) — NOT NULL
  • status — VARCHAR(32)
  • discussion_agents — VARCHAR
  • mind_map_content — TEXT
  • created_ts — BIGINT
  • updated_ts — BIGINT

ellm_scribe_section

  • id — VARCHAR
  • instance_id — VARCHAR — NOT NULL
  • depth — INTEGER
  • order_value — FLOAT
  • state — VARCHAR
  • title — VARCHAR
  • instruction — TEXT
  • editable — BOOLEAN
  • generatable — BOOLEAN
  • section_type — VARCHAR
  • created_ts — BIGINT
  • updated_ts — BIGINT
  • locked_by_user_id — VARCHAR
  • locked_until_ts — BIGINT

ellm_scribe_section_history

  • section_id — VARCHAR
  • page — INTEGER
  • updated_ts — BIGINT
  • user_id — VARCHAR — NOT NULL
  • description — TEXT
  • content — TEXT
  • searched_chunks — TEXT
  • top_k_chunks — TEXT
  • used_chunks — TEXT

ellm_scribe_section_image

  • image_no — SERIAL
  • section_id — VARCHAR
  • path — VARCHAR
  • file_name — VARCHAR

ellm_stats_daily_by_user

  • day_tz — DATE — Primary key — NOT NULL
  • user_id — VARCHAR — Primary key — NOT NULL
  • dept_code — VARCHAR(64) — Primary key — NOT NULL
  • position_code — VARCHAR(64) — Primary key — NOT NULL
  • dept_name — VARCHAR(128)
  • user_name — VARCHAR(128)
  • position_name — VARCHAR(128)
  • user_report_count — INTEGER — NOT NULL
  • like_count — INTEGER — NOT NULL
  • dislike_count — INTEGER — NOT NULL
  • guard_count — INTEGER — NOT NULL
  • ai_answer_count — INTEGER — NOT NULL
  • last_answer_ts_ms — BIGINT — NOT NULL
  • updated_at — timestamptz — NOT NULL

ellm_upper_dept

  • dept_hash_code — varchar(128)
  • dept_code — varchar(64)
  • dept_name — varchar(128)
  • dept_order — int

ellm_user_consent

  • user_id — VARCHAR(64)
  • updated_ts — BIGINT

ellm_user_group

  • id — VARCHAR
  • name — VARCHAR
  • description — TEXT
  • created_ts — BIGINT
  • updated_ts — BIGINT

ellm_user_group_participant

  • group_id — VARCHAR
  • user_id — VARCHAR
  • authority — VARCHAR
  • joined_ts — BIGINT

ellm_user_report

  • id — SERIAL
  • type — VARCHAR
  • title — VARCHAR
  • content — TEXT
  • responded — BOOLEAN
  • response_message — TEXT
  • reporter_id — VARCHAR
  • reporter_name — VARCHAR(128)
  • reporter_dept_code — VARCHAR(64)
  • reporter_dept_name — VARCHAR(128)
  • reporter_position_code — VARCHAR(64)
  • reporter_position_name — VARCHAR(128)
  • created_ts — BIGINT
  • responded_ts — BIGINT
  • target_type — VARCHAR
  • target_id — VARCHAR
  • fwd_update_ts — BIGINT
  • upper_depts_hash_code — VARCHAR(128)

ellm_user_report_fwd_user

  • report_id — INTEGER
  • user_id — VARCHAR(64)

item 별 메타 정보 (llm_doc_meta_table_definitions)

  • item_name — VARCHAR
  • meta_table_name — VARCHAR — NOT NULL
  • content_table_name — VARCHAR — NOT NULL
  • description — TEXT
  • from_clause — TEXT — NOT NULL
  • base_where_clause — TEXT — NOT NULL
  • parameter_keys — JSONB — NOT NULL
  • columns_def — JSONB — NOT NULL
  • indexes_def — JSONB
  • meta_extract_strategy — VARCHAR
  • meta_mapping_rules — JSONB
  • dialog_interaction_mode — VARCHAR — NOT NULL
  • target_menu — VARCHAR
  • additional_search_query — TEXT
  • enable_ellm_guard — BOOLEAN
  • guard_policy — JSONB
  • color — VARCHAR
  • item_display_name_kr — VARCHAR — NOT NULL
  • item_display_name_en — VARCHAR — NOT NULL
  • milvus_item_config — JSONB
  • pg_item_config — JSONB

llm_debug_log

  • log_id — VARCHAR
  • details — jsonb
  • entry_ts — BIGINT
  • conversation_id — VARCHAR
  • query_id — VARCHAR
  • response_id — VARCHAR

llm_doc_아이템_이름_content (llm_doc_ellm_2_1_scribe_content)

  • doc_id — VARCHAR
  • start_chunk — INTEGER
  • end_chunk — INTEGER
  • content — TEXT
  • embedding — VECTOR(1024)
  • overlap_idx — INTEGER
  • page — INTEGER

llm_doc_아이템_이름_meta (llm_doc_ellm_2_1_scribe_meta)

  • doc_id — VARCHAR
  • yyyy — INTEGER
  • mm — INTEGER
  • dd — INTEGER
  • parent_id — VARCHAR

모든 문서의 공용 메타 정보 (llm_doc_common_meta)

  • doc_id — VARCHAR
  • doc_type — VARCHAR
  • extracted_ts — BIGINT
  • file_name — VARCHAR
  • file_ext — VARCHAR
  • file_path — VARCHAR
  • file_size — BIGINT
  • extract_group_id — VARCHAR — NOT NULL
  • full_text — TEXT
  • user_id — VARCHAR
  • dept_code — VARCHAR
  • included — BOOLEAN
  • detail — JSONB
  • collection_name — VARCHAR
  • title — VARCHAR

채팅 내용 사용자 리액션 정보 (ellm_message_reaction)

  • message_id — VARCHAR — Primary key — NOT NULL
  • user_id — VARCHAR — Primary key — NOT NULL
  • user_name — VARCHAR(128)
  • dept_code — VARCHAR(64)
  • dept_name — VARCHAR(128)
  • position_code — VARCHAR(64)
  • position_name — VARCHAR(128)
  • upper_depts_hash_code — VARCHAR(128)
  • reaction_type — VARCHAR — NOT NULL
  • created_ts — BIGINT — NOT NULL

채팅 메시지 내역 (ellm_message_history)

  • id — SERIAL
  • item_name — VARCHAR
  • item_names — JSONB
  • message_id — VARCHAR
  • pair_id — VARCHAR
  • conversation_name — VARCHAR
  • message_type — VARCHAR
  • guard_type — VARCHAR
  • guard — JSONB
  • created_by — VARCHAR
  • upper_depts_hash_code — VARCHAR(128)
  • created_ts — BIGINT
  • models — TEXT
  • role — VARCHAR
  • request_ip — VARCHAR
  • user_name — VARCHAR(128)
  • dept_code — VARCHAR(64)
  • dept_name — VARCHAR(128)
  • position_code — VARCHAR(64)
  • position_name — VARCHAR(128)
  • admin_type_name — VARCHAR(128)

채팅 메시지 정보 (llm_chat_message)

  • message_id — VARCHAR
  • parent_message_id — VARCHAR
  • type — VARCHAR
  • content — TEXT
  • reasoning_content — TEXT
  • created_ts — BIGINT
  • child_message_ids — VARCHAR
  • conversation_id — VARCHAR
  • searched_chunks — TEXT
  • top_k_chunks — TEXT
  • used_chunks — TEXT
  • state — VARCHAR
  • ellm_instance_code — VARCHAR
  • created_by — VARCHAR
  • updated_ts — BIGINT
  • guard — JSONB
  • assistant_name — VARCHAR
  • block_context — TEXT
  • mindmap — TEXT
  • mcp_context — TEXT

채팅방 메타 정보 (llm_conversation_meta)

  • conversation_id — VARCHAR(255)
  • conversation_name — VARCHAR
  • category — VARCHAR
  • item_name — VARCHAR
  • conversation_description — VARCHAR
  • created_by — VARCHAR
  • created_ts — bigint
  • updated_ts — bigint
  • last_node_id — VARCHAR
  • is_active — BOOLEAN

채팅방 참여자 정보 (ellm_conversation_participant)

  • conversation_id — VARCHAR(255) — Primary key — NOT NULL
  • user_id — VARCHAR(255) — Primary key — NOT NULL
  • role — VARCHAR
  • joined_ts — BIGINT — NOT NULL
  • last_read_ts — BIGINT
  • is_favorite — BOOLEAN — NOT NULL

채팅방이 가진 부서 권한 (llm_authorized_conversation)

  • conversation_id — varchar — Primary key — NOT NULL
  • authorized_dept_code — varchar