journey_step


Description

{“what”:“One recorded action in an automated journey run, ordered by step_index within a run_id.”,“why”:“Without it, the sequence of actions in a run cannot be stored, replayed, or analyzed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:09:42.322413773+00:00”}

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
journey_run.id journey_step_run_id_fkey C

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

Relationships