in_product_balance_stock_reserved

CREATE TABLE public.in_product_balance_stock_reserved
(
    product_balance_stock_reserved_id bigint NOT NULL DEFAULT nextval('product_balance_stock_reserved_seq'::regclass),
    tenant_id bigint,
    ou_id bigint,
    product_id bigint,
    base_uom_id bigint,
    product_status character varying(50) COLLATE pg_catalog."default",
    qty numeric,
    version bigint NOT NULL,
    create_datetime character varying(14) COLLATE pg_catalog."default",
    create_user_id bigint,
    update_datetime character varying(14) COLLATE pg_catalog."default",
    update_user_id bigint,
    CONSTRAINT in_product_balance_stock_reserved_pkey PRIMARY KEY (product_balance_stock_reserved_id)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.in_product_balance_stock_reserved
    OWNER to sts;

GRANT ALL ON TABLE public.in_product_balance_stock_reserved TO sts;
-- Index: idx_in_product_balance_stock_reserved_01

-- DROP INDEX public.idx_in_product_balance_stock_reserved_01;

CREATE UNIQUE INDEX idx_in_product_balance_stock_reserved_01
    ON public.in_product_balance_stock_reserved USING btree
    (tenant_id ASC NULLS LAST, ou_id ASC NULLS LAST, product_id ASC NULLS LAST, product_status COLLATE pg_catalog."default" ASC NULLS LAST)
    TABLESPACE pg_default;
-- Index: idx_in_product_balance_stock_reserved_02

-- DROP INDEX public.idx_in_product_balance_stock_reserved_02;

CREATE INDEX idx_in_product_balance_stock_reserved_02
    ON public.in_product_balance_stock_reserved USING btree
    (tenant_id ASC NULLS LAST, ou_id ASC NULLS LAST, product_id ASC NULLS LAST)
    TABLESPACE pg_default;