CREATE TABLE public.ctb_aux_saldo
(
    filial integer NOT NULL,
    terminal_ip character varying(15) COLLATE pg_catalog."default" NOT NULL,
    conta_contabil numeric(16,0) NOT NULL,
    ano_mes numeric(6,0) NOT NULL,
    saldo_atual numeric(18,6) NOT NULL,
    CONSTRAINT pk_ctb_aux_saldo PRIMARY KEY (filial, terminal_ip, conta_contabil, ano_mes),
    CONSTRAINT fk_ctb_auxsaldo FOREIGN KEY (conta_contabil)
        REFERENCES public.ctb_conta_contabil (codigo) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.ctb_aux_saldo
    OWNER to postgres;