CREATE TABLE IF NOT EXISTS public.par_api_pix_autenticacao
(
    filial integer NOT NULL,
    banco integer NOT NULL,
    client_id character varying(1000) NOT NULL,
    client_secret character varying(1000) NOT NULL,
    app_key character varying(200) NOT NULL,
    scope character varying(300) NOT NULL,
    prod character varying(1) NOT NULL,
    code character varying(200) NOT NULL,
    created_at bigint NOT NULL,
    access_token character varying(2000) NOT NULL,
    access_expires_in integer NOT NULL,
    refresh_token character varying(2000) NOT NULL,
    refresh_expires_in integer NOT NULL,
    CONSTRAINT pk_par_api_pix_autenticacao PRIMARY KEY (filial, banco),
    CONSTRAINT fk_par_api_pix_autenticacao_banco FOREIGN KEY (banco)
        REFERENCES public.flx_banco (codigo) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT,
    CONSTRAINT fk_par_api_pix_autenticacao_filial FOREIGN KEY (filial)
        REFERENCES public.bas_filial (codigo) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.par_api_pix_autenticacao
    OWNER to postgres;