CREATE TABLE IF NOT EXISTS public.rcb_dup_historico_bolecode_canc
(
    filial integer NOT NULL,
    sequencia integer NOT NULL,
    usuario integer NOT NULL,
    data date NOT NULL,
    hora time without time zone NOT NULL,
    historico_filial_dup integer NOT NULL,
    historico_sequencia integer NOT NULL,
    historico_url character varying NOT NULL,
    historico_txid character varying NOT NULL,
    historico_emv character varying NOT NULL,
    CONSTRAINT pk_rcb_dup_historico_bolecode_canc PRIMARY KEY (filial, sequencia)
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.rcb_dup_historico_bolecode_canc
    OWNER to postgres;

COMMENT ON TABLE public.rcb_dup_historico_bolecode_canc
    IS 'Cadastro cancelamento do historico de PIX (bolecode)';


ALTER TABLE IF EXISTS rcb_dup_rcb_bolecode ALTER COLUMN filial_dup SET NOT NULL;
ALTER TABLE IF EXISTS rcb_dup_rcb_bolecode ALTER COLUMN sequencia SET NOT NULL;
ALTER TABLE IF EXISTS rcb_dup_rcb_bolecode ALTER COLUMN url SET NOT NULL;
ALTER TABLE IF EXISTS rcb_dup_rcb_bolecode ALTER COLUMN txid SET NOT NULL;
ALTER TABLE IF EXISTS rcb_dup_rcb_bolecode ALTER COLUMN emv SET NOT NULL;