Skip to content

app.integration_sync_run_state_transitions

TableRow level security on

Append-only ledger of integration sync run state changes, written only by the integration sync run transition RPCs and creation.

Primary key: id

Columns of app.integration_sync_run_state_transitions
ColumnTypeNullableDescription
iduuidNoPrimary key, UUID v7.
org_iduuidNoOwning org, derived from app.integration_sync_runs on insert; never accepted from the caller and never changed.References app.organizations.id
integration_sync_run_iduuidNoThe integration sync run that changed state.References app.integration_sync_runs.id
from_stateapp.integration_sync_run_stateYesState before the change; NULL for the creation entry.
to_stateapp.integration_sync_run_stateNoState after the change.
reasontextNoWhy the state changed.
created_attimestamp with time zoneNoWhen the row was inserted. Set by the database.
created_byuuidYesPerson who inserted the row, or null for a platform process. Set by the database.References app.people.id
updated_attimestamp with time zoneNoWhen the row last changed. Set by the database.
updated_byuuidYesPerson who last changed the row, or null for a platform process. Set by the database.References app.people.id
deleted_attimestamp with time zoneYesSoft delete time. A row with deleted_at set is ignored by every access helper.