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 |