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