scan_findings


Description

{“what”:“A single issue detected by a scan, with location and metadata.”,“why”:“Without it, scan results would be lost and cannot be tracked or resolved.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:20.761969823+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null

{“what”:“Unique numeric identifier for each finding.”,“why”:“Needed to reference a specific finding in updates or joins.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:20.772003430+00:00”}

path text 2147483647 √ null

{“what”:“File path or resource location where the issue was found.”,“why”:“Identifies the affected file; without it, the finding cannot be located.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:20.795214035+00:00”}

kind text 2147483647 √ null

{“what”:“Category or type of the finding, e.g., ‘bug’ or ‘vulnerability’.”,“why”:“Groups findings by type for triage and prioritization.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:20.828547917+00:00”}

suggestion text 2147483647 √ null

{“what”:“Suggested fix or remediation text provided by the scan.”,“why”:“Gives developers actionable guidance; without it, remediation steps are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:20.858722165+00:00”}

severity text 2147483647 √ null

{“what”:“Severity level such as ‘low’, ‘medium’, ‘high’.”,“why”:“Prioritizes which findings to address first.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:20.878563038+00:00”}

size int8 19 √ null

{“what”:“Size of the affected resource in bytes.”,“why”:“Helps assess impact or correlate with resource limits.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:20.900113547+00:00”}

scanned_at int8 19 √ null

{“what”:“Unix timestamp (seconds) when the scan ran.”,“why”:“Tracks when the finding was discovered; needed for time-based analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:20.919646416+00:00”}

resolved int8 19 √ 0

{“what”:“Unix timestamp when resolved, or 0 if not resolved.”,“why”:“Distinguishes open from closed findings; without it, resolution status is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:20.934155971+00:00”}

Indexes

Constraint Name Type Sort Column(s)
scan_findings_pkey Primary key Asc id

Relationships