Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('ssh_compliance_results_id_seq'::regclass) |
|
|
{“what”:“Unique numeric identifier for each compliance result row.”,“why”:“Without it, rows cannot be uniquely referenced for updates or deletions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:29.856849679+00:00”} |
|
| scan_timestamp | timestamptz | 35,6 | null |
|
|
{“what”:“Time the scan ran, in UTC with timezone offset.”,“why”:“Without it, results from different scans cannot be ordered or compared over time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:29.874371884+00:00”} |
||
| check_name | text | 2147483647 | null |
|
|
{“what”:“Name of the SSH compliance check, e.g., ‘PermitRootLogin’.”,“why”:“Without it, it is unclear which specific SSH setting or rule the result refers to.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:29.887630740+00:00”} |
||
| status | text | 2147483647 | null |
|
|
{“what”:“Compliance outcome, e.g., ‘pass’, ‘fail’, ‘error’.”,“why”:“Without it, it is unknown whether the check passed or failed, so no action can be taken.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:29.903029104+00:00”} |
||
| severity | text | 2147483647 | null |
|
|
{“what”:“Importance level of the check, e.g., ‘high’, ‘medium’, ‘low’.”,“why”:“Without it, failed checks cannot be prioritized for remediation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:29.916511114+00:00”} |
||
| current_value | text | 2147483647 | √ | null |
|
|
{“what”:“Value found on the system for the checked setting, if any.”,“why”:“Without it, the actual configuration is unknown, so the failure cannot be diagnosed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:29.932703830+00:00”} |
|
| expected_value | text | 2147483647 | √ | null |
|
|
{“what”:“Value the check expects for the setting, if defined.”,“why”:“Without it, the target configuration is unknown, so the gap cannot be measured.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:29.947507531+00:00”} |
|
| description | text | 2147483647 | null |
|
|
{“what”:“Human-readable explanation of what the check verifies.”,“why”:“Without it, engineers lack context on the purpose of the check.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:29.965011637+00:00”} |
||
| auto_fixable | bool | 1 | √ | false |
|
|
{“what”:“Whether the check can be automatically remediated, default false.”,“why”:“Without it, it is unknown which failures can be fixed automatically, blocking automation decisions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:29.989796967+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ssh_compliance_results_pkey | Primary key | Asc | id |