action


Description

{“what”:“User-defined actions that can be triggered from a UI, with parameters and display settings.”,“why”:“Without it, actions cannot be persisted, shared, or executed consistently.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:57.733475812+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
http_action.action_id fk_http_action_ref_action_id C
implicit_action.action_id fk_implicit_action_action_id C
query_action.action_id fk_query_action_ref_action_id C
report_dashboardcard.action_id fk_report_dashboardcard_ref_action_id C

{“what”:“Unique integer identifier for each action.”,“why”:“Without it, actions cannot be uniquely referenced in foreign keys or API calls.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:57.760095263+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp of row creation, stored with timezone.”,“why”:“Without it, creation time is unknown, breaking audit and ordering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:57.775515324+00:00”}

updated_at timestamptz 35,6 now()

{“what”:“Timestamp of last row update, stored with timezone.”,“why”:“Without it, last modification time is unknown, breaking change tracking.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:57.797019352+00:00”}

type text 2147483647 null

{“what”:“Text label that determines how the action is executed.”,“why”:“Without it, the system cannot decide how to run the action or validate its parameters.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:57.825459400+00:00”}

model_id int4 10 null
report_card.id fk_action_model_id C

{“what”:“Identifier of the model this action is associated with.”,“why”:“Without it, the action cannot be scoped to a specific model, breaking its context.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:57.851952087+00:00”}

name varchar 254 null

{“what”:“Human-readable name for the action, used in UI.”,“why”:“Without it, actions cannot be displayed or referenced by users.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:57.867559268+00:00”}

description text 2147483647 √ null

{“what”:“Optional free-text description of the action’s purpose.”,“why”:“Without it, the action’s intent may be unclear to other users.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:57.884991387+00:00”}

parameters text 2147483647 √ null

{“what”:“JSON text defining input parameters for the action.”,“why”:“Without it, the action cannot accept user input or validate arguments.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:57.904083627+00:00”}

parameter_mappings text 2147483647 √ null

{“what”:“JSON text mapping action parameters to model fields or variables.”,“why”:“Without it, parameter values cannot be correctly bound to the underlying query.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:57.918253277+00:00”}

visualization_settings text 2147483647 √ null

{“what”:“JSON text for UI display settings of the action’s result.”,“why”:“Without it, the action’s output cannot be rendered with the intended layout.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:57.952828787+00:00”}

public_uuid varchar 254 √ null

{“what”:“Public UUID for sharing the action without authentication.”,“why”:“Without it, the action cannot be shared publicly via a secret link.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:57.983578963+00:00”}

made_public_by_id int4 10 √ null
core_user.id fk_action_made_public_by_id C

{“what”:“User ID of the person who made the action public.”,“why”:“Without it, the public sharing cannot be attributed or revoked.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:58.018605048+00:00”}

creator_id int4 10 √ null
core_user.id fk_action_creator_id R

{“what”:“User ID of the action’s creator.”,“why”:“Without it, ownership and permissions for the action are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:58.031097465+00:00”}

archived bool 1 false

{“what”:“Flag indicating whether the action is archived (soft-deleted).”,“why”:“Without it, archived actions would still appear in lists and break filtering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:58.050046795+00:00”}

entity_id bpchar 21 √ null

{“what”:“Stable unique identifier for the action, used for cross-instance sync.”,“why”:“Without it, actions cannot be reliably synced or merged between environments.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:58.062800960+00:00”}

public_uuid_prefix varchar 36 √ null

{“what”:“Short prefix for the public UUID, used in share links.”,“why”:“Without it, share links cannot be shortened or branded.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:05:58.077619027+00:00”}

Indexes

Constraint Name Type Sort Column(s)
action_pkey Primary key Asc id
action_entity_id_key Must be unique Asc entity_id
action_public_uuid_key Must be unique Asc public_uuid
idx_action_creator_id Performance Asc creator_id
idx_action_made_public_by_id Performance Asc made_public_by_id
idx_action_model_id Performance Asc model_id
idx_action_public_uuid Performance Asc public_uuid
idx_action_public_uuid_prefix Performance Asc public_uuid_prefix

Relationships