Append-only fulfillment transition history of finalized orders.
orders.status is the current state, and this table is the durable record of how it got
there: one row per committed transition, in commit order. A correction therefore never
erases an earlier fact — it is simply another appended row — and a transition whose row is
missing can never be reconstructed from the current state alone. fromStatus and
toStatus are drawn from the same status vocabulary as orders.status, so
history can never claim a state the order could not hold.
transitionedAt is database transaction time, the same clock that stamps queue entry, so
history and current state always agree on when something happened. The monotonic id
orders rows that share one transaction timestamp, which is what keeps the history sequence
deterministic rather than dependent on physical row order.
Append-only fulfillment transition history of finalized orders.
orders.statusis the current state, and this table is the durable record of how it got there: one row per committed transition, in commit order. A correction therefore never erases an earlier fact — it is simply another appended row — and a transition whose row is missing can never be reconstructed from the current state alone.fromStatusandtoStatusare drawn from the same status vocabulary asorders.status, so history can never claim a state the order could not hold.transitionedAtis database transaction time, the same clock that stamps queue entry, so history and current state always agree on when something happened. The monotonicidorders rows that share one transaction timestamp, which is what keeps the history sequence deterministic rather than dependent on physical row order.