PersistedOperation

In-memory representation of a row in trax.persisted_operation. Returned by IPersistedOperationStore reads.

Properties

Property	Type	Column	Notes
`TenantKey`	`string?`	`tenant_key`	Null at the C# boundary. Stored as `''` sentinel because the column participates in the composite primary key.
`Id`	`string`	`id`	Build-time-stable id, e.g. `userProfile_v1`.
`OperationName`	`string`	`operation_name`	Original GraphQL operation name (often differs from id by case).
`Version`	`int`	`version`	Operator-set metadata, from `UpsertOptions.Version` (`0` when not given). The id is opaque; nothing is parsed from it.
`Document`	`string`	`document`	Full GraphQL document text.
`ShapeFingerprint`	`string`	`shape_fingerprint`	sha-256 hex of the canonicalized response shape.
`IsActive`	`bool`	`is_active`	False indicates a soft-delete. Inactive rows do not serve requests.
`DeprecationReason`	`string?`	`deprecation_reason`	Required when `IsActive` is false.
`Description`	`string?`	`description`	Operator-facing note.
`CreatedAt`	`DateTime`	`created_at`	UTC.
`UpdatedAt`	`DateTime`	`updated_at`	UTC.

Schema

The table is created by Trax migration 035_persisted_operations.sql, which also creates trax.persisted_operation_history for audit and rollback. Both tables live in the trax schema alongside the rest of the Trax tables (metadata, manifest, log, etc.), and both are sets on the Effect DataContext (PersistedOperations, PersistedOperationHistories). There is no separate persisted-operations DbContext.

For history, prefer IPersistedOperationsService.GetHistoryAsync, the call behind the persistedOperationHistory management query.

PersistedOperationHistory properties

One row per change to a live row, in trax.persisted_operation_history.

Property	Type	Column	Notes
`HistoryId`	`long`	`history_id`	Surrogate key (`bigserial`).
`TenantKey`	`string?`	`tenant_key`	Mirrors the live row.
`Id`	`string`	`id`	Mirrors the live row.
`Document`	`string`	`document`	Snapshot at the time of the change.
`ShapeFingerprint`	`string`	`shape_fingerprint`	Snapshot at the time of the change.
`ChangeType`	`string`	`change_type`	One of `Upsert`, `Deactivate`, `Restore`.
`ChangedAt`	`DateTime`	`changed_at`	UTC.
`ChangedReason`	`string?`	`changed_reason`	Required on deactivate.