Saltar al contenido

app.po_change_order_state_transitions

TablaSeguridad a nivel de fila activa

Append-only ledger of po change order state changes, written only by the po change order transition RPCs and creation.

Clave primaria: id

Columnas de app.po_change_order_state_transitions
ColumnaTipoAdmite nulosDescripción
iduuidNoPrimary key, UUID v7.
org_iduuidNoOwning org, derived from app.po_change_orders on insert; never accepted from the caller and never changed.Hace referencia a app.organizations.id
po_change_order_iduuidNoThe po change order that changed state.Hace referencia a app.po_change_orders.id
from_stateapp.po_change_order_stateSíState before the change; NULL for the creation entry.
to_stateapp.po_change_order_stateNoState after the change.
reasontextNoWhy the state changed.
created_attimestamp with time zoneNoWhen the row was inserted. Set by the database.
created_byuuidSíPerson who inserted the row, or null for a platform process. Set by the database.Hace referencia a app.people.id
updated_attimestamp with time zoneNoWhen the row last changed. Set by the database.
updated_byuuidSíPerson who last changed the row, or null for a platform process. Set by the database.Hace referencia a app.people.id
deleted_attimestamp with time zoneSíSoft delete time. A row with deleted_at set is ignored by every access helper.