DROP TABLE pricequote.target_prices_base CASCADE;

CREATE TABLE pricequote.target_prices_base (
    compset TEXT        NOT NULL,
    stlc    TEXT        NOT NULL,
    floor   NUMERIC     NOT NULL,
    ds      TEXT        NOT NULL,
    chan    TEXT        NOT NULL,
    tier    TEXT        NOT NULL,
    vol     INT4RANGE   NOT NULL,
    val     NUMERIC     NOT NULL,
    price   NUMERIC,
    math    TEXT[],
    PRIMARY KEY (stlc, ds, chan, tier, vol)
);

GRANT SELECT, INSERT, UPDATE, DELETE ON pricequote.target_prices_base TO PUBLIC;