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