CREATE TABLE public.trp_transportadora_email
(
  filial_trp integer NOT NULL,
  transportadora integer NOT NULL,
  sequencia integer NOT NULL,
  contato character varying(100) NOT NULL,
  email character varying(100) NOT NULL,
  CONSTRAINT pk_trp_transportadora_email PRIMARY KEY (filial_trp, transportadora, sequencia),
  CONSTRAINT fk_trp_transportadora_email_transportadora FOREIGN KEY (filial_trp, transportadora)
      REFERENCES public.trp_transportadora (filial_trp, codigo) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
  OIDS=FALSE
);
ALTER TABLE public.trp_transportadora_email
  OWNER TO postgres;

COMMENT ON TABLE public.trp_transportadora_email
  IS 'Cadastro de E-mail do Transportador';