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 |