ai 챗봇

테이블 (7)

chatbot_feedback

  • chatbot_feedback_id — BIGINT(20) — 기본 키 — NOT NULL
  • message_id — BIGINT(20) — 외래 키 → message.message_id — NOT NULL
  • user_id — VARCHAR(36) — NOT NULL
  • feedback_type — VARCHAR(10) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

chatbot_usage_stat

  • stat_id — BIGINT(20) — 기본 키 — NOT NULL
  • stat_date — DATE — NOT NULL
  • total_users — INT — NOT NULL
  • total_sessions — INT — NOT NULL
  • total_messages — INT — NOT NULL
  • total_tokens — INT — NOT NULL
  • response_time — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

file_contents

  • id — INT(11) — 기본 키 — NOT NULL
  • file_path — VARCHAR(1024) — NOT NULL
  • file_name — VARCHAR(512) — NOT NULL
  • trans_file_name — VARCHAR(512)
  • file_ext — VARCHAR(50) — NOT NULL
  • file_size — BIGINT(20) — NOT NULL
  • file_hash — CHAR(64) — NOT NULL
  • file_blob — LONGBLOB
  • file_status — VARCHAR(32)
  • is_updated — TINYINT(1) — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL
  • is_transferring — TINYINT(1) — NOT NULL
  • transfer_attempt — INT(11) — NOT NULL
  • is_indexed — TINYINT(1) — NOT NULL
  • last_transferred_at — DATETIME
  • collected_at — DATETIME — NOT NULL

file_info

  • id — INT(11) — 기본 키 — NOT NULL
  • status — VARCHAR(100) — NOT NULL
  • file_id — INT(11) — 외래 키 → file_contents.id — NOT NULL
  • file_title — VARCHAR(255) — NOT NULL
  • extension — VARCHAR(20) — NOT NULL
  • file_path — LONGTEXT — NOT NULL
  • user_id — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • file_size — BIGINT(20) — NOT NULL
  • collection — VARCHAR(100) — NOT NULL
  • content_hash — VARCHAR(256)
  • source — VARCHAR(50)
  • summary — VARCHAR(2000)

luxia_api_log

  • api_log_id — BIGINT(20) — 기본 키 — NOT NULL
  • user_id — VARCHAR(36) — NOT NULL
  • request_body — LONGTEXT — NOT NULL
  • response_body — LONGTEXT
  • http_status — INT(11) — NOT NULL
  • error_message — VARCHAR(2000)
  • request_at — DATETIME(6) — NOT NULL
  • response_at — DATETIME(6)

luxia_token_usage

  • usage_id — BIGINT(20) — 기본 키 — NOT NULL
  • user_id — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • user_name — VARCHAR(100) — NOT NULL
  • department_name — VARCHAR(100)
  • usage_date — DATETIME(6) — NOT NULL
  • total_tokens — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

message

  • message_id — BIGINT(20) — 기본 키 — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • created_by — VARCHAR(100) — NOT NULL
  • debug_info_map — LONGTEXT
  • deleted — VARCHAR(1) — NOT NULL
  • feedback_type — VARCHAR(10)
  • uxia_plugin_type — VARCHAR(50) — NOT NULL
  • message — VARCHAR(5000) — NOT NULL
  • message_type — VARCHAR(10) — NOT NULL
  • suggest_question_list — VARCHAR(1000)
  • uuid — VARCHAR(36) — NOT NULL
  • conversation_id — BIGINT(20) — NOT NULL
  • question_message_id — BIGINT(20) — 외래 키 → message.message_id
  • index_number — BIGINT(20) — NOT NULL
  • parent_id — BIGINT(20) — 외래 키 → message.message_id
  • parent_uuid — VARCHAR(255)
  • usage — TEXT