Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for each finding row.”,“why”:“Needed to reference or update a specific finding.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:06.116550642+00:00”} |
|
| analyzed_entity_type | varchar | 254 | null |
|
|
{“what”:“Type of analyzed entity, e.g., ‘repository’ or ‘file’.”,“why”:“Disambiguates which table analyzed_entity_id points to.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:06.141481278+00:00”} |
||
| analyzed_entity_id | int4 | 10 | null |
|
|
{“what”:“Primary key of the entity within its type’s table.”,“why”:“Together with type, uniquely identifies the analyzed entity.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:06.161971690+00:00”} |
||
| analysis_version | int4 | 10 | null |
|
|
{“what”:“Version number of the analysis logic that produced this finding.”,“why”:“Distinguishes results from different analysis versions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:06.181808275+00:00”} |
||
| analyzed_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp (with time zone) when the analysis ran.”,“why”:“Records when the finding was produced; needed for time-based queries.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:06.207542806+00:00”} |
||
| result | bool | 1 | null |
|
|
{“what”:“Boolean outcome: true if analysis passed, false if failed.”,“why”:“Indicates pass/fail; without it, no conclusion exists.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:06.241645551+00:00”} |
||
| stale | bool | 1 | false |
|
|
{“what”:“Flag indicating whether this finding is outdated (default false).”,“why”:“Allows filtering out old findings; without it, stale results appear current.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:06.309509248+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| analysis_finding_pkey | Primary key | Asc | id |
| idx_analysis_finding_stale | Performance | Asc | stale |
| idx_analysis_result | Performance | Asc | result |
| idx_analyzed_entity | Performance | Asc/Asc | analyzed_entity_type + analyzed_entity_id |
| idx_unique_analysis_finding | Must be unique | Asc/Asc | analyzed_entity_type + analyzed_entity_id |