Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('device_uptime_log_id_seq'::regclass) |
|
|
{“what”:“Unique numeric identifier for each log entry.”,“why”:“Allows each row to be referenced and updated independently; no natural key exists.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:04.584699589+00:00”} |
|
| device | text | 2147483647 | null |
|
|
{“what”:“Identifier of the monitored device, e.g. hostname or IP.”,“why”:“Groups log entries per device; without it, entries cannot be attributed to a specific device.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:04.603385594+00:00”} |
||
| reachable | int4 | 10 | null |
|
|
{“what”:“Integer flag: 1 if device responded, 0 otherwise.”,“why”:“Records the outcome of each check; without it, uptime cannot be computed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:04.615772949+00:00”} |
||
| timestamp | text | 2147483647 | null |
|
|
{“what”:“Time the check was performed, stored as text (format not enforced).”,“why”:“Orders entries chronologically; without it, the sequence of checks is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:04.638205075+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| device_uptime_log_pkey | Primary key | Asc | id |
| idx_uptime_device_ts | Performance | Asc/Asc | device + timestamp |