--
--

\restrict uvoocJevg0oTFWUoTdhU411XCo3dUS2CGH1BXC5lHR1YlqOdvB5GMiOVJJPLPSm


SET transaction_timeout = 0;
SELECT pg_catalog.set_config('search_path', '', false);



--
-- 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;


--
--

\unrestrict uvoocJevg0oTFWUoTdhU411XCo3dUS2CGH1BXC5lHR1YlqOdvB5GMiOVJJPLPSm

