CREATE TABLE IF NOT EXISTS public.par_api_banco_servico
(
    codigo character varying(1) COLLATE pg_catalog."default" NOT NULL,
    descricao character varying(50) COLLATE pg_catalog."default" NOT NULL,
    CONSTRAINT par_api_banco_servico_pkey PRIMARY KEY (codigo)
);

INSERT INTO par_api_banco_servico VALUES ('E', 'Extrato'), ('C', 'Cobranca'), ('P', 'Pagamento');

CREATE TABLE IF NOT EXISTS public.par_api_banco_autenticacao
(
    filial integer NOT NULL,
    banco integer NOT NULL,
    agencia character varying(10) COLLATE pg_catalog."default" NOT NULL,
    conta character varying(10) COLLATE pg_catalog."default" NOT NULL,
    tipo_servico character varying(1) COLLATE pg_catalog."default" NOT NULL,
    client_id character varying(200) COLLATE pg_catalog."default" NOT NULL,
    client_secret character varying(300) COLLATE pg_catalog."default" NOT NULL,
    app_key character varying(200) COLLATE pg_catalog."default" NOT NULL,
    escopo character varying(750) COLLATE pg_catalog."default" NOT NULL,
    homo_prod character varying(1) COLLATE pg_catalog."default" NOT NULL,
    id_token character varying(500) COLLATE pg_catalog."default" NOT NULL,
    refresh_token character varying COLLATE pg_catalog."default" NOT NULL,
    access_token character varying COLLATE pg_catalog."default" NOT NULL,
    tempo_criacao bigint NOT NULL,
    tempo_expiracao integer NOT NULL,
    CONSTRAINT par_api_banco_autenticacao_pkey PRIMARY KEY (filial, banco, agencia, conta, tipo_servico)
);

CREATE TABLE IF NOT EXISTS public.par_api_banco
(
    filial integer NOT NULL,
    cod_banco integer NOT NULL,
    url_token_hm character varying(100) COLLATE pg_catalog."default" NOT NULL,
    url_token_prod character varying(100) COLLATE pg_catalog."default" NOT NULL,
    url_servico_hm character varying(100) COLLATE pg_catalog."default" NOT NULL,
    url_servico_prod character varying(100) COLLATE pg_catalog."default" NOT NULL,
    redirect_url character varying(100) COLLATE pg_catalog."default" NOT NULL,
    CONSTRAINT par_api_banco_pkey PRIMARY KEY (cod_banco, filial)
);