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 |
|
|
{“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 |