CREATE TABLE public.log_bas_vendedor
(
    log_sequencia integer NOT NULL,
    log_terminal_ip character varying NOT NULL,
    log_usuario integer NOT NULL,
    log_formulario character varying(100) NOT NULL,
    log_data date NOT NULL,
    log_hora time without time zone NOT NULL,
    log_observacao character varying(200) NOT NULL,
    log_tipo_operacao integer NOT NULL,
    
    ant_filial integer NOT NULL,
    ant_codigo integer NOT NULL,
    ant_nome character varying(100) NOT NULL,
    ant_porc_comissao numeric(18,6) NOT NULL,
    ant_tabela_regressao integer NOT NULL,
    ant_supervisor integer NOT NULL,
    ant_gerente integer NOT NULL,
    ant_filial_trabalho integer NOT NULL,
    ant_plano_saude character varying(1) NOT NULL,
    ant_vale_transporte character varying(1) NOT NULL,
    ant_data_admissao date NOT NULL,
    ant_cart_profissional integer NOT NULL,
    ant_nr_registro integer NOT NULL,
    ant_serie_registro integer NOT NULL,
    ant_rg character varying(12) NOT NULL,
    ant_orgao_emissor character varying(10) NOT NULL,
    ant_data_nascimento date NOT NULL,
    ant_nome_mae character varying(100) NOT NULL,
    ant_estado_civil character varying(1) NOT NULL,
    ant_escolaridade character varying(1) NOT NULL,
    ant_nr_pis numeric(14,0) NOT NULL,
    ant_situacao character varying(1) NOT NULL,
    ant_uf character varying(2) NOT NULL,
    ant_cidade character varying(50) NOT NULL,
    ant_bairro character varying(80) NOT NULL,
    ant_endereco character varying(100) NOT NULL,
    ant_numero integer NOT NULL,
    ant_complemento character varying(80) NOT NULL,
    ant_cep character varying(8) NOT NULL,
    ant_ddd_01 integer NOT NULL,
    ant_telefone_01 numeric NOT NULL,
    ant_ddd_02 integer NOT NULL,
    ant_telefone_02 numeric NOT NULL,
    ant_email character varying(100) NOT NULL,
    ant_cpf character varying(14) NOT NULL,
    ant_desconto_max_permitido numeric(18,6) NOT NULL,
    ant_observacao character varying(1500) NOT NULL,
    ant_cnpj character varying(16) NOT NULL,
    ant_cod_usuario integer NOT NULL,
    ant_interno_externo character varying(1) NOT NULL,
    ant_instalador character varying(1) NOT NULL,
    
    atu_filial integer NOT NULL,
    atu_codigo integer NOT NULL,
    atu_nome character varying(100) NOT NULL,
    atu_porc_comissao numeric(18,6) NOT NULL,
    atu_tabela_regressao integer NOT NULL,
    atu_supervisor integer NOT NULL,
    atu_gerente integer NOT NULL,
    atu_filial_trabalho integer NOT NULL,
    atu_plano_saude character varying(1) NOT NULL,
    atu_vale_transporte character varying(1) NOT NULL,
    atu_data_admissao date NOT NULL,
    atu_cart_profissional integer NOT NULL,
    atu_nr_registro integer NOT NULL,
    atu_serie_registro integer NOT NULL,
    atu_rg character varying(12) NOT NULL,
    atu_orgao_emissor character varying(10) NOT NULL,
    atu_data_nascimento date NOT NULL,
    atu_nome_mae character varying(100) NOT NULL,
    atu_estado_civil character varying(1) NOT NULL,
    atu_escolaridade character varying(1) NOT NULL,
    atu_nr_pis numeric(14,0) NOT NULL,
    atu_situacao character varying(1) NOT NULL,
    atu_uf character varying(2) NOT NULL,
    atu_cidade character varying(50) NOT NULL,
    atu_bairro character varying(80) NOT NULL,
    atu_endereco character varying(100) NOT NULL,
    atu_numero integer NOT NULL,
    atu_complemento character varying(80) NOT NULL,
    atu_cep character varying(8) NOT NULL,
    atu_ddd_01 integer NOT NULL,
    atu_telefone_01 numeric NOT NULL,
    atu_ddd_02 integer NOT NULL,
    atu_telefone_02 numeric NOT NULL,
    atu_email character varying(100) NOT NULL,
    atu_cpf character varying(14) NOT NULL,
    atu_desconto_max_permitido numeric(18,6) NOT NULL,
    atu_observacao character varying(1500) NOT NULL,
    atu_cnpj character varying(16) NOT NULL,
    atu_cod_usuario integer NOT NULL,
    atu_interno_externo character varying(1) NOT NULL,
    atu_instalador character varying(1) NOT NULL,
    
    CONSTRAINT pk_log_bas_vendedor PRIMARY KEY (log_sequencia)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.bas_vendedor
    OWNER to postgres;



INSERT INTO log_tipo_operacao VALUES (34, 'Alteracao do cadastro de vendedor');






CREATE SEQUENCE public.seq_log_bas_vendedor
    INCREMENT 1
    START 1
    MINVALUE 1
    MAXVALUE 9999999999
    CACHE 1;

ALTER SEQUENCE public.seq_log_bas_vendedor
    OWNER TO postgres;

COMMENT ON SEQUENCE public.seq_log_bas_vendedor
    IS 'Sequence do log do cadastro de vendedor';