CREATE TABLE public.rpc_automatica_tabela
(
    sequencia integer NOT NULL,
    tabela character varying(50) NOT NULL,
    campo_data character varying(50) NOT NULL,
    tabela_log character varying(50) NOT NULL,
    campo_data_log character varying(50) NOT NULL,
    campo_hora_log character varying(50) NOT NULL,
    operacao character varying(1) NOT NULL,
    ativo character varying(1) NOT NULL,
    CONSTRAINT pk_rpc_automatica_tabela PRIMARY KEY (sequencia)
)

TABLESPACE pg_default;

COMMENT ON COLUMN public.rpc_automatica_tabela.operacao
    IS 'I - IMPORTA; E - EXPORTA; A - AMBOS;';
    
ALTER TABLE public.rpc_automatica_tabela
    OWNER to postgres;


CREATE TABLE public.rpc_automatica_tabela_chave
(
    tabela integer NOT NULL,
    sequencia integer NOT NULL,
    coluna character varying(50) NOT NULL,
    coluna_log character varying(50) NOT NULL,
    CONSTRAINT pk_rpc_automatica_tabela_chave PRIMARY KEY (tabela, sequencia),
     CONSTRAINT fk_rpc_automatica_tabela_chave_coluna FOREIGN KEY (tabela)
        REFERENCES public.rpc_automatica_tabela (sequencia) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE public.rpc_automatica_tabela_chave
    OWNER to postgres;


CREATE TABLE public.rpc_automatica_tabela_filial
(
    tabela integer NOT NULL,
    sequencia integer NOT NULL,
    coluna character varying(50) NOT NULL,
    coluna_log character varying(50) NOT NULL,
    CONSTRAINT pk_rpc_automatica_tabela_filial PRIMARY KEY (tabela, sequencia),
     CONSTRAINT fk_rpc_automatica_tabela_filial_coluna FOREIGN KEY (tabela)
        REFERENCES public.rpc_automatica_tabela (sequencia) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE public.rpc_automatica_tabela_filial
    OWNER to postgres;


CREATE TABLE public.rpc_automatica_tabela_conferencia
(
    tabela integer NOT NULL,
    sequencia integer NOT NULL,
    coluna character varying(50) NOT NULL,
    tabela_conferencia character varying(50) NOT NULL,
    coluna_conferencia character varying(50) NOT NULL,
    valor_padrao character varying(50) NOT NULL,
    CONSTRAINT pk_rpc_automatica_tabela_conferencia PRIMARY KEY (tabela, sequencia),
     CONSTRAINT fk_rpc_automatica_tabela_conferencia_coluna FOREIGN KEY (tabela)
        REFERENCES public.rpc_automatica_tabela (sequencia) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE public.rpc_automatica_tabela_conferencia
    OWNER to postgres;

CREATE TABLE public.rpc_automatica_tabela_exclusao
(
    tabela integer NOT NULL,
    sequencia integer NOT NULL,
    coluna character varying(50) NOT NULL,
    CONSTRAINT pk_rpc_automatica_tabela_exclusao PRIMARY KEY (tabela, sequencia),
     CONSTRAINT fk_rpc_automatica_tabela_exclusao_coluna FOREIGN KEY (tabela)
        REFERENCES public.rpc_automatica_tabela (sequencia) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE public.rpc_automatica_tabela_exclusao
    OWNER to postgres;

CREATE TABLE public.rpc_automatica_historico
(
    sequencia integer NOT NULL,
    tabela integer NOT NULL,
    filial integer NOT NULL,
    data_inicial date NOT NULL,
    hora_inicial time without time zone NOT NULL,
    data_final date NOT NULL,
    hora_final time without time zone NOT NULL,
    CONSTRAINT pk_rpc_automatica_historico PRIMARY KEY (sequencia),
    CONSTRAINT fk_rrpc_automatica_historico_tabela FOREIGN KEY (tabela)
        REFERENCES public.rpc_automatica_tabela (sequencia) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE public.rpc_automatica_historico
    OWNER to postgres;



CREATE TABLE public.rpc_aux_automatica_importados
(
    tabela integer NOT NULL,
    sequencia integer NOT NULL,
    importados character varying(50) COLLATE pg_catalog."default" NOT NULL,
    CONSTRAINT pk_rpc_aux_automatica_importados PRIMARY KEY (tabela, sequencia),
    CONSTRAINT fk_rpc_aux_automatica_importados_tabela FOREIGN KEY (tabela)
        REFERENCES public.rpc_automatica_tabela (sequencia) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE public.rpc_aux_automatica_importados
    OWNER to postgres;