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