reg_states


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

Relationships