analysis_finding


Description

{“what”:“Findings from automated analysis runs on entities.”,“why”:“Without it, no record of which entities passed or failed analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:06:06.095487843+00:00”}

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

Relationships