compliance_findings


Description

{“what”:“Rows of compliance scan results for a repo-device pair.”,“why”:“Without it, scan results are lost and cannot be audited or acted on.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:22.828549410+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('compliance_findings_id_seq'::regclass)

{“what”:“Unique numeric identifier for each finding; primary key.”,“why”:“Without it, rows cannot be referenced or updated reliably.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:22.841483063+00:00”}

repo text 2147483647 null

{“what”:“Repository identifier such as ‘org/repo’.”,“why”:“Without it, findings cannot be grouped per repository.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:22.859719811+00:00”}

device text 2147483647 null

{“what”:“Hostname or environment label where the scan executed.”,“why”:“Without it, findings cannot be attributed to a specific device.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:22.876102743+00:00”}

kind text 2147483647 null

{“what”:“Issue category like ‘vulnerability’ or ‘misconfiguration’.”,“why”:“Without it, issue types cannot be filtered or prioritized.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:22.890303248+00:00”}

path text 2147483647 null

{“what”:“File path or resource identifier within the repo.”,“why”:“Without it, the exact location of the issue is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:22.901695585+00:00”}

detail text 2147483647 null

{“what”:“Free-text explanation of the compliance violation.”,“why”:“Without it, the nature of the issue is unexplained.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:22.921554077+00:00”}

scanned_at text 2147483647 null

{“what”:“Timestamp in ISO 8601 format (e.g., 2025-01-01T00:00:00Z).”,“why”:“Without it, the recency of the finding cannot be assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:08:22.935848773+00:00”}

Indexes

Constraint Name Type Sort Column(s)
compliance_findings_pkey Primary key Asc id
idx_compliance_repo Performance Asc repo

Relationships