AI기반 패치 영향도 분석

테이블 (3)

analysis_results

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • report_id — BIGINT — 외래 키 → security_reports.id
  • client_key — VARCHAR(100) — NOT NULL
  • overall_risk_level — VARCHAR(20)
  • summary — TEXT
  • detected_vulnerabilities — JSONB
  • remediation_guides — JSONB
  • work_plan — JSONB
  • raw_llm_response — JSONB
  • created_at — TIMESTAMPTZ

chat_messages

  • id — SERIAL — 기본 키 — NOT NULL
  • session_id — VARCHAR(64) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

security_reports

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • client_key — VARCHAR(100) — NOT NULL
  • hostname — VARCHAR(255)
  • report_type — VARCHAR(50)
  • collected_at — TIMESTAMPTZ
  • os_name — VARCHAR(100)
  • os_version — VARCHAR(100)
  • kernel_version — VARCHAR(255)
  • raw_json — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ