Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('ssh_auth_events_id_seq'::regclass) |
|
|
{“what”:“Unique numeric identifier for each event row.”,“why”:“Without it, rows cannot be uniquely referenced for updates, deletes, or joins.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:23.939524353+00:00”} |
||||
| timestamp | timestamptz | 35,6 | null |
|
|
{“what”:“UTC timestamp of when the SSH event occurred.”,“why”:“Without it, event ordering and time-based analysis (e.g., brute-force detection) are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:23.958689700+00:00”} |
|||||
| event_type | text | 2147483647 | null |
|
|
{“what”:“Outcome category such as ‘success’, ‘failed’, ‘timeout’.”,“why”:“Without it, cannot distinguish successful logins from failed attempts, hiding security breaches.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:23.974531127+00:00”} |
|||||
| source_ip | text | 2147483647 | null |
|
|
{“what”:“IP address of the client that initiated the SSH connection.”,“why”:“Without it, cannot identify attack sources or geolocate suspicious activity.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:23.991322241+00:00”} |
|||||
| username | text | 2147483647 | √ | null |
|
|
{“what”:“Account name attempted or used in the SSH authentication.”,“why”:“Without it, cannot attribute events to specific users or detect username enumeration attacks.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:24.003911525+00:00”} |
||||
| auth_method | text | 2147483647 | √ | null |
|
|
{“what”:“Authentication mechanism used, e.g., ‘password’, ‘publickey’.”,“why”:“Without it, cannot assess security posture or enforce policies on weak methods.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:24.033724340+00:00”} |
||||
| key_fingerprint | text | 2147483647 | √ | null |
|
|
{“what”:“SHA256 fingerprint of the SSH public key used, if any.”,“why”:“Without it, cannot track key-based access or revoke compromised keys.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:24.047465874+00:00”} |
||||
| details | text | 2147483647 | √ | null |
|
|
{“what”:“Free-form additional context such as error messages or client version.”,“why”:“Without it, diagnostic information for troubleshooting or forensic analysis is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:56:24.123038148+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ssh_auth_events_pkey | Primary key | Asc | id |
| idx_ssh_auth_source | Performance | Asc | source_ip |
| idx_ssh_auth_ts | Performance | Asc | timestamp |