AWS 기반 서비스 보안 구축 프로젝트
테이블 (7)
cross_validations
- id — BIGINT
- project_name — VARCHAR(255) — NOT NULL
- commit_hash — VARCHAR(64)
- phase — INTEGER
- category — VARCHAR(20)
- tool_a — VARCHAR(50)
- tool_b — VARCHAR(50)
- judgement_code — VARCHAR(50)
- confidence — VARCHAR(20)
- severity — VARCHAR(32)
- llm_summary — TEXT
- gate_result — VARCHAR(20)
- gate_score — DOUBLE
- raw_report — JSON
- created_at — TIMESTAMP — NOT NULL
isms_checks
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- data — JSON
pipeline_runs
- id — BIGINT
- project_name — VARCHAR(255) — NOT NULL
- commit_hash — VARCHAR(64)
- branch — VARCHAR(100) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- gate_result — VARCHAR(20)
- gate_score — DOUBLE
- scan_ids — JSON
- created_at — TIMESTAMP — NOT NULL
scans
- id — BIGINT
- tool — VARCHAR(50) — NOT NULL
- category — VARCHAR(20)
- project_name — VARCHAR(255) — NOT NULL
- commit_hash — VARCHAR(64)
- raw_result — JSON
- status — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
siem_events
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- data — JSON
tool_results
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- data — JSON
vulnerabilities
- id — BIGINT
- scan_id — BIGINT — 외래 키 → scans.id
- tool — VARCHAR(50)
- category — VARCHAR(20)
- severity — VARCHAR(32) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- file_path — VARCHAR(500)
- line_number — INTEGER
- cwe_id — VARCHAR(50)
- cve_id — VARCHAR(50)
- confidence — VARCHAR(32) — NOT NULL
- description — TEXT
- status — VARCHAR(32) — NOT NULL
- created_at — TIMESTAMP — NOT NULL