dodil/erp-brick-inventory

DODIL ERP brick: inventory

src/brick_inventory/migrations/00002_v6/up.sql

-- 00002_v6 (spec v6): a standard price may come from a released roll-up (source_ref, the releaser's sub) and an output lot is linked to the input lots it was
-- made from (INV-59). ADD COLUMN is DISRUPTIVE: migrate the test copy first, the live one at a quiet hour.
ALTER TABLE inv_standard_price ADD COLUMN source_ref VARCHAR;

ALTER TABLE inv_standard_price ADD COLUMN set_sub VARCHAR;

CREATE TABLE IF NOT EXISTS inv_lot_link (
    product_id VARCHAR NOT NULL,
    lot_code VARCHAR NOT NULL,
    input_product_id VARCHAR NOT NULL,
    input_lot_code VARCHAR NOT NULL,
    move_ref VARCHAR NOT NULL,
    input_quantity NUMERIC(19,4),
    source_kind VARCHAR,
    source_id VARCHAR,
    created_at TIMESTAMP,
    PRIMARY KEY (product_id, lot_code, input_product_id, input_lot_code, move_ref)
);