--
-- PostgreSQL database dump
--

\restrict uvoocJevg0oTFWUoTdhU411XCo3dUS2CGH1BXC5lHR1YlqOdvB5GMiOVJJPLPSm

-- Dumped from database version 14.22
-- Dumped by pg_dump version 14.22

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: pessoa; Type: TABLE; Schema: public; Owner: chinchila
--

CREATE TABLE public.pessoa (
    id bigint NOT NULL,
    nome character varying(70) NOT NULL,
    tipo character(1) DEFAULT 'F'::bpchar NOT NULL,
    cpf character varying(11),
    datanascimento timestamp(0) without time zone,
    identidade character varying(15),
    siglaorgaoidentidade character varying(10),
    sexo character(1) DEFAULT 'N'::bpchar NOT NULL,
    profissao character varying(70),
    conjuge character varying(70),
    filiacaopai character varying(70),
    filiacaomae character varying(70),
    estadocivil character(1) DEFAULT 'N'::bpchar NOT NULL,
    cidadenatalid bigint,
    estadoidentidadeid bigint,
    razaosocial character varying(70),
    observacao text,
    cnpj character varying(18),
    inscricaoestadual character varying(20),
    ramoatividade character varying(70),
    estadoinscricaoestadualid bigint,
    isentoinscricaoestadual boolean DEFAULT false NOT NULL,
    restricaochequeid bigint,
    suspendercobranca boolean DEFAULT false NOT NULL,
    status character(1) DEFAULT 'A'::bpchar NOT NULL,
    codigoexportacao character varying(20),
    passaporte character varying(20),
    crmrecebernotificacao character(1) DEFAULT '?'::bpchar NOT NULL,
    crmrecebersms boolean DEFAULT false NOT NULL,
    crmreceberemail boolean DEFAULT false NOT NULL,
    crmreceberligacao boolean DEFAULT false NOT NULL,
    matriculacei character varying(12),
    transportadoraid bigint,
    datahorainclusao timestamp(0) without time zone,
    usuarioinclusao bigint,
    inscricaomunicipal character varying(14),
    orgaopublico boolean DEFAULT false NOT NULL,
    datahoraalteracao timestamp(0) without time zone,
    usuarioalteracaoid bigint,
    atuacao character(1) DEFAULT '?'::bpchar NOT NULL,
    inscricaosuframa character varying(9),
    tipoentepublico character(1) DEFAULT '?'::bpchar NOT NULL
);


ALTER TABLE public.pessoa OWNER TO chinchila;

--
-- Name: TABLE pessoa; Type: ACL; Schema: public; Owner: chinchila
--

GRANT SELECT ON TABLE public.pessoa TO leitura_157604907_24022023;
GRANT SELECT ON TABLE public.pessoa TO ediretor;


--
-- PostgreSQL database dump complete
--

\unrestrict uvoocJevg0oTFWUoTdhU411XCo3dUS2CGH1BXC5lHR1YlqOdvB5GMiOVJJPLPSm