Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | null |
|
|
{“what”:“Unique UUID for this step row, used as primary key.”,“why”:“Provides an unambiguous reference to a single step for joins and updates.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.344379098+00:00”} |
|||||
| run_id | uuid | 2147483647 | null |
|
|
{“what”:“UUID of the journey run that contains this step.”,“why”:“Groups all steps of a single run; without it, steps from different runs are indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.370983687+00:00”} |
|||||
| step_index | int4 | 10 | null |
|
|
{“what”:“Zero-based integer position of this step within its run.”,“why”:“Preserves the exact order of actions; without it, the sequence is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.387764629+00:00”} |
|||||
| action | text | 2147483647 | null |
|
|
{“what”:“Type of action performed, e.g., click, type, navigate.”,“why”:“Enables filtering and analysis by action type; without it, step semantics are unclear.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.417214290+00:00”} |
|||||
| action_text | text | 2147483647 | √ | null |
|
|
{“what”:“User-visible text associated with the action, such as a button label.”,“why”:“Identifies the specific UI element targeted; without it, the action’s target is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.443274970+00:00”} |
||||
| action_rationale | text | 2147483647 | √ | null |
|
|
{“what”:“Free-text explanation of why the agent chose this action.”,“why”:“Provides reasoning for debugging and transparency; without it, decisions are opaque.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.464853903+00:00”} |
||||
| funnel_stage | text | 2147483647 | null |
|
|
{“what”:“Funnel stage this step belongs to, e.g., signup, checkout.”,“why”:“Enables funnel conversion analysis; without it, steps cannot be attributed to stages.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.479462757+00:00”} |
|||||
| focus_name | text | 2147483647 | √ | null |
|
|
{“what”:“Name of the UI element or area the action focused on.”,“why”:“Helps identify which part of the page was interacted with; without it, context is incomplete.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.508698283+00:00”} |
||||
| url | text | 2147483647 | √ | null |
|
|
{“what”:“Full URL of the page at the time of the step.”,“why”:“Provides page context; without it, the environment of the action is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.523903148+00:00”} |
||||
| screenshot_path | text | 2147483647 | √ | null |
|
|
{“what”:“File path to a screenshot captured at this step.”,“why”:“Offers visual evidence for debugging or review; without it, no visual record exists.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.548310528+00:00”} |
||||
| transcript_len | int4 | 10 | √ | null |
|
|
{“what”:“Length of the conversation transcript up to this step, in characters.”,“why”:“Indicates how much context the agent had; without it, context size is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.561704792+00:00”} |
||||
| caused_state_change | bool | 1 | √ | false |
|
|
{“what”:“Boolean flag: true if this step changed the application state.”,“why”:“Distinguishes state-changing actions from passive ones; without it, state impact is unclear.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.593818105+00:00”} |
||||
| is_error | bool | 1 | √ | false |
|
|
{“what”:“Boolean flag: true if this step resulted in an error.”,“why”:“Flags problematic steps for error analysis; without it, failures are invisible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.608132692+00:00”} |
||||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp with time zone when the step was recorded.”,“why”:“Provides chronological ordering and enables time-based analysis; without it, timing is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.625195536+00:00”} |
|||||
| screen_state_key | text | 2147483647 | √ | null |
|
|
{“what”:“Key referencing the screen state snapshot before the action.”,“why”:“Links to the exact UI state; without it, the pre-action state cannot be retrieved.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.637646741+00:00”} |
||||
| model_prompt_key | text | 2147483647 | √ | null |
|
|
{“what”:“Key referencing the prompt sent to the model for this step.”,“why”:“Allows retrieval of the exact prompt; without it, the input to the model is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.653994790+00:00”} |
||||
| model_raw_key | text | 2147483647 | √ | null |
|
|
{“what”:“Key referencing the raw model output for this step.”,“why”:“Allows inspection of the model’s response; without it, the output is unavailable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.669275709+00:00”} |
||||
| latency_ms | int4 | 10 | √ | null |
|
|
{“what”:“Time taken for the model to respond, in milliseconds.”,“why”:“Measures performance and identifies slow steps; without it, latency cannot be assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.687816450+00:00”} |
||||
| prompt_tokens | int4 | 10 | √ | null |
|
|
{“what”:“Number of tokens in the prompt sent to the model.”,“why”:“Tracks token usage and cost; without it, prompt size is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.717661934+00:00”} |
||||
| completion_tokens | int4 | 10 | √ | null |
|
|
{“what”:“Number of tokens in the model’s completion.”,“why”:“Tracks token usage and cost; without it, completion size is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.815375399+00:00”} |
||||
| captured | bool | 1 | true |
|
|
{“what”:“Boolean flag: true if this step was recorded during the run, false if synthesized.”,“why”:“Distinguishes real recorded steps from generated ones; without it, data provenance is unclear.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.832219351+00:00”} |
|||||
| sitemap_node_id | text | 2147483647 | √ | null |
|
|
{“what”:“Identifier of the sitemap node corresponding to this step’s page.”,“why”:“Links the step to a known page in the site structure; without it, page mapping is missing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.851781710+00:00”} |
||||
| narrative_beat | text | 2147483647 | √ | null |
|
|
{“what”:“Label for the narrative segment this step belongs to, e.g., ‘introduction’.”,“why”:“Groups steps into story-like phases for analysis; without it, narrative structure is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.920338768+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| journey_step_pkey | Primary key | Asc | id |
| idx_step_run | Performance | Asc/Asc | run_id + step_index |