dodil/erp-brick-sales-order

DODIL ERP brick: sales order

src/brick_sales_order/migrations/00002_audit1/up.sql

-- 00002_audit1 — additive only. The proposer's sub beside proposed_by (the amender is never the approver under EITHER
-- identity), and the claim table that makes an order number unique (DataK3 has no UNIQUE beyond the PK).

ALTER TABLE so_revision ADD COLUMN proposed_sub VARCHAR;

CREATE TABLE IF NOT EXISTS so_order_no_claim (
    order_no VARCHAR NOT NULL,
    sales_order_id VARCHAR,
    claimed_at TIMESTAMP,
    created_at TIMESTAMP,
    updated_at TIMESTAMP,
    PRIMARY KEY (order_no)
);