# PersistedOperation

In-memory representation of a row in `trax.persisted_operation`. Returned by [IPersistedOperationStore](/docs/sdk-reference/persisted-operations/i-persisted-operation-store) 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. |