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