mcp
Tables (10)
category_large
- large_category_id — bigint(20) — Primary key — NOT NULL
- large_category_name — varchar(255) — NOT NULL
- created_at — timestamp
category_medium
- medium_category_id — bigint(20) — Primary key — NOT NULL
- medium_category_name — varchar(255) — NOT NULL
- large_category_id — bigint(20) — Foreign key → category_large.large_category_id — NOT NULL
- created_at — timestamp
category_small
- small_category_id — bigint(20) — Primary key — NOT NULL
- product_name — varchar(255) — NOT NULL
- large_category_id — bigint(20) — Foreign key → category_large.large_category_id — NOT NULL
- medium_category_id — bigint(20) — Foreign key → category_medium.medium_category_id — NOT NULL
- created_at — timestamp
chat_message
- message_id — bigint(20) — Primary key — NOT NULL — 메시지 ID
- room_id — bigint(20) — Foreign key → chat_room.room_id — NOT NULL — 채팅방 ID
- request_id — bigint(20) — Foreign key → chat_request_log.request_id — 요청 ID
- message_role — varchar(20) — NOT NULL — 메시지 역할 (USER, ASSISTANT, SYSTEM)
- message_type — varchar(20) — NOT NULL — 메시지 타입 (TEXT, TABLE, CHART, ERROR)
- message_text — longtext — NOT NULL — 메시지 본문
- sequence_no — int(11) — NOT NULL — 채팅방 내 메시지 순번
- status — varchar(20) — NOT NULL — 처리 상태 (PENDING, PROCESSING, DONE, FAILED)
- error_message — text — 오류 메시지
- created_at — datetime — NOT NULL — 생성일시
- updated_at — datetime — NOT NULL — 수정일시
chat_request_log
- request_id — bigint(20) — Primary key — NOT NULL — 요청 ID
- room_id — bigint(20) — Foreign key → chat_room.room_id — NOT NULL — 채팅방 ID
- user_message_id — bigint(20) — Foreign key → chat_message.message_id — NOT NULL — 사용자 질문 메시지 ID
- assistant_message_id — bigint(20) — Foreign key → chat_message.message_id — AI 응답 메시지 ID
- request_text — longtext — NOT NULL — 원본 질문
- response_text — longtext — 최종 응답
- request_status — varchar(20) — NOT NULL — 요청 상태 (PROCESSING, DONE, FAILED)
- db_query_text — longtext — 내부 DB 조회 쿼리/조건
- db_result_json — longtext — 내부 DB 조회 결과 JSON
- prompt_text — longtext — GPT 전달 프롬프트
- model_name — varchar(100) — 모델명
- started_at — datetime — NOT NULL — 처리 시작 시각
- finished_at — datetime — 처리 종료 시각
- created_at — datetime — NOT NULL — 생성일시
chat_room
- room_id — bigint(20) — Primary key — NOT NULL — 채팅방 ID
- title — varchar(200) — NOT NULL — 채팅방 제목
- room_status — varchar(20) — NOT NULL — 채팅방 상태 (ACTIVE, ARCHIVED, DELETED)
- first_question — text — 첫 질문
- last_message_preview — varchar(500) — 최근 메시지 미리보기
- last_message_at — datetime — 최근 메시지 시각
- deleted_yn — char(1) — NOT NULL — 삭제 여부 (Y/N)
- created_at — datetime — NOT NULL — 생성일시
- updated_at — datetime — NOT NULL — 수정일시
file_detail
- file_detail_id — bigint(20) — Primary key — NOT NULL
- file_path — varchar(500) — NOT NULL
- file_name — varchar(255) — NOT NULL
- origin_file_name — varchar(255)
- extension — varchar(20)
- file_size — bigint(20)
- file_master_id — bigint(20) — Foreign key → file_master.file_master_id — NOT NULL
file_master
- file_master_id — bigint(20) — Primary key — NOT NULL
- category — enum('ITEM_COLUMN','ITEM_DATA','ITEM_DOWNLOAD_REPORT') — NOT NULL
item_column
- column_id — bigint(20) — Primary key — NOT NULL
- column_name — varchar(255) — NOT NULL
- unit — varchar(50) — 단위 (예: kg, cm, 원, 개)
- column_type — enum('TEXT', 'NUMBER', 'DATE', 'FILE')
- medium_category_id — bigint(20) — Foreign key → category_medium.medium_category_id — NOT NULL
- file_master_id — bigint(20) — Foreign key → file_master.file_master_id
- created_at — timestamp
item_data
- data_id — bigint(20) — Primary key — NOT NULL
- small_category_id — bigint(20) — Foreign key → category_small.small_category_id — NOT NULL
- column_id — bigint(20) — Foreign key → item_column.column_id — NOT NULL
- data_value — text
- file_master_id — bigint(20) — Foreign key → file_master.file_master_id
- created_at — timestamp