Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| user_id | text | 2147483647 | null |
|
|
{“what”:“User identifier (text) that uniquely owns a state row.”,“why”:“Without it, states cannot be attributed to a specific user.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:51.629212742+00:00”} |
||
| state | bytea | 2147483647 | null |
|
|
{“what”:“Serialized registration state as binary data (e.g., JSON or protocol buffer).”,“why”:“Without it, the registration flow cannot resume after a redirect or page refresh.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:51.667450921+00:00”} |
||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp (with time zone) when the state row was created.”,“why”:“Without it, stale states cannot be expired or cleaned up.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-22T23:55:51.679151881+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| reg_states_pkey | Primary key | Asc | user_id |