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