dodil/erp-platform

tests/scenario_bricks/scn_stock/schema.sql

-- stock (scenario-harness test brick): one row per reservation, keyed by the caller's derived key.
CREATE TABLE IF NOT EXISTS stock_reservations (
    reservation_key  VARCHAR NOT NULL,
    sku              VARCHAR NOT NULL,
    quantity         INTEGER NOT NULL,
    reserved_by      VARCHAR,
    created_at       TIMESTAMP,
    updated_at       TIMESTAMP,
    PRIMARY KEY (reservation_key)
);