Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“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 |
|
|
{“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 |
|
|
{“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 |
|
|
{“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 |