-- Table: public.bas_smtp_email_log_envio

CREATE TABLE public.bas_smtp_email_log_envio
(
	sequencia integer NOT NULL,
	filial integer NOT NULL,
	data_emissao date NOT NULL,
	hora_emissao time without time zone NOT NULL,
	retorno character varying NOT NULL,
	tipo_envio character varying(1) NOT NULL,
	host_smtp character varying(50) NOT NULL,
	usuario_smtp character varying(50) NOT NULL,
	senha_smtp character varying(50) NOT NULL,
	tipo_conexao character varying(6) NOT NULL,
	porta integer NOT NULL,
	email_remetente character varying(100) NOT NULL,
	nome_remetente character varying(50) NOT NULL,
	confirmacao_recebimento character varying(1) NOT NULL,
	copia_email_remetente character varying(1) NOT NULL,
	corpo_html character varying(1) NOT NULL,
	conexao_segura character varying(6) NOT NULL,
	assunto character varying(200) NOT NULL,
	mensagem character varying NOT NULL,
	destinatario_email character varying(500) NOT NULL,
	destinatario_nome character varying(500) NOT NULL,
	copia_email character varying(500) NOT NULL,
	copia_nome character varying(500) NOT NULL,
	copia_oculta_email character varying(500) NOT NULL,
	copia_oculta_nome character varying(500) NOT NULL,
	anexos character varying NOT NULL,
	
	CONSTRAINT pk_bas_smtp_email_log_envio PRIMARY KEY (sequencia)
)

TABLESPACE pg_default;

ALTER TABLE public.bas_smtp_email_log_envio OWNER to postgres;