CREATE TABLE cli_cliente_orgao_publico
(
  filial_cliente integer NOT NULL,
  cliente integer NOT NULL,
  orgao_publico character varying(1) NOT NULL,
  CONSTRAINT pk_cli_cliente_orgao_publico PRIMARY KEY (filial_cliente, cliente),
  CONSTRAINT fk_cli_cliente_orgao_publico FOREIGN KEY (filial_cliente, cliente)
      REFERENCES cli_cliente (filial, codigo) MATCH SIMPLE
      ON UPDATE RESTRICT ON DELETE RESTRICT
)
WITH (
  OIDS=FALSE
);
ALTER TABLE cli_cliente_orgao_publico
  OWNER TO postgres;