journey_route


Description

{“what”:“A step in a journey route, linking a run to a sitemap node with expected and actual outcomes.”,“why”:“Without it, journey steps cannot be tracked individually or correlated to runs and sitemap nodes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:01.379888135+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null

{“what”:“Unique identifier for this route step.”,“why”:“Without it, steps cannot be uniquely identified.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:01.415487231+00:00”}

run_id uuid 2147483647 null
journey_run.id journey_route_run_id_fkey C

{“what”:“Identifier of the run this step belongs to.”,“why”:“Groups steps into a single run; without it, steps from different runs are indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:01.442082874+00:00”}

node_index int4 10 null

{“what”:“Zero-based position of this step in the route sequence.”,“why”:“Preserves order; without it, the sequence is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:01.453214987+00:00”}

sitemap_node_id text 2147483647 √ null

{“what”:“Identifier of the sitemap node this step corresponds to.”,“why”:“Links the step to a specific sitemap entry; without it, the step’s origin is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:01.463405651+00:00”}

stage text 2147483647 null

{“what”:“Phase of the journey this step belongs to (e.g., ‘discovery’).”,“why”:“Distinguishes steps by phase; without it, filtering by phase is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:01.524088886+00:00”}

label text 2147483647 null

{“what”:“Descriptive label for this step, e.g., ‘Homepage’.”,“why”:“Provides a readable reference for logs and reports; without it, steps are only identified by IDs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:01.572439069+00:00”}

expected_url text 2147483647 √ null

{“what”:“Full URL expected to be visited at this step.”,“why”:“Allows comparison with actual URL to detect mismatches; without it, expected behavior is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:01.606721973+00:00”}

status text 2147483647 null

{“what”:“Outcome of this step, e.g., ‘passed’, ‘failed’.”,“why”:“Records the result; without it, success/failure is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:01.640556985+00:00”}

reached_at_step int4 10 √ null

{“what”:“Global step number in the journey when this route step was reached.”,“why”:“Correlates steps across branches; without it, timing/order across branches is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:01.661963044+00:00”}

detours jsonb 2147483647 √ '[]'::jsonb

{“what”:“JSON array of detour objects taken at this step.”,“why”:“Records deviations from expected path; without it, detour information is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:01.696156887+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp when this route step record was created.”,“why”:“Provides audit trail and allows time-based analysis; without it, creation time is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:10:01.725885342+00:00”}

Indexes

Constraint Name Type Sort Column(s)
journey_route_pkey Primary key Asc id
idx_route_run Performance Asc/Asc run_id + node_index

Relationships