Check Kopilot

Tables (6)

card (답변카드)

  • id (카드ID) — CHAR(36) — Primary key — NOT NULL
  • session_id (세션ID) — VARCHAR(64) — NOT NULL
  • payload (카드데이터) — LONGTEXT — NOT NULL
  • created_at (생성시각) — DATETIME — NOT NULL

catalog_request (수요조사요청)

  • id (요청ID) — BIGINT — Primary key — NOT NULL
  • session_id (세션ID) — VARCHAR(64)
  • topic (주제) — VARCHAR(255) — NOT NULL
  • question (사용자 질문) — LONGTEXT
  • matched_api_ids (매칭API목록) — VARCHAR(255)
  • source (출처) — VARCHAR(16) — NOT NULL
  • created_at (생성시각) — DATETIME — NOT NULL

chat_log (대화로그)

  • id (로그ID) — BIGINT — Primary key — NOT NULL
  • session_id (세션ID) — VARCHAR(64) — NOT NULL
  • role (역할) — VARCHAR(20) — NOT NULL
  • tool_name (도구명) — VARCHAR(60)
  • content (내용) — LONGTEXT — NOT NULL
  • created_at (생성시각) — DATETIME — NOT NULL

check_fallback (외부API폴백캐시)

  • cache_key (캐시키) — VARCHAR(200) — Primary key — NOT NULL
  • payload (응답원문) — LONGTEXT — NOT NULL
  • fetched_at (수집시각) — DATETIME — NOT NULL

stock_alias (종목별칭)

  • alias (별칭) — VARCHAR(80) — Primary key — NOT NULL
  • code (종목코드) — VARCHAR(12) — Foreign key → stock_master.code — NOT NULL

stock_master (종목마스터)

  • code (종목코드) — VARCHAR(12) — Primary key — NOT NULL
  • name (종목명) — VARCHAR(80) — NOT NULL
  • market (시장구분) — VARCHAR(10) — NOT NULL
  • type (종목유형) — VARCHAR(10) — NOT NULL