Software Público Brasileiro

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: alembic_version; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE alembic_version (
    version_num character varying(32) NOT NULL
);


ALTER TABLE alembic_version OWNER TO postgres;

--
-- Name: lb_base; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_base (
    id_base integer NOT NULL,
    name character varying NOT NULL,
    struct character varying NOT NULL,
    dt_base timestamp without time zone NOT NULL,
    idx_exp boolean NOT NULL,
    idx_exp_url character varying,
    idx_exp_time integer,
    file_ext boolean NOT NULL,
    file_ext_time integer,
    txt_mapping character varying
);


ALTER TABLE lb_base OWNER TO postgres;

--
-- Name: lb_base_id_base_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE lb_base_id_base_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_base_id_base_seq OWNER TO postgres;

--
-- Name: lb_base_id_base_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE lb_base_id_base_seq OWNED BY lb_base.id_base;


--
-- Name: lb_doc__app_config; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_doc__app_config (
    id_doc integer NOT NULL,
    document json NOT NULL,
    dt_doc timestamp without time zone NOT NULL,
    dt_last_up timestamp without time zone NOT NULL,
    dt_del timestamp without time zone,
    dt_idx timestamp without time zone,
    nm_user_alteracao character varying[],
    nm_apelido character varying,
    nm_aplicacao character varying
);


ALTER TABLE lb_doc__app_config OWNER TO postgres;

--
-- Name: lb_doc__app_config_id_doc_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE lb_doc__app_config_id_doc_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_doc__app_config_id_doc_seq OWNER TO postgres;

--
-- Name: lb_doc__form; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_doc__form (
    id_doc integer NOT NULL,
    document json NOT NULL,
    dt_doc timestamp without time zone NOT NULL,
    dt_last_up timestamp without time zone NOT NULL,
    dt_del timestamp without time zone,
    dt_idx timestamp without time zone
);


ALTER TABLE lb_doc__form OWNER TO postgres;

--
-- Name: lb_doc__form_id_doc_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE lb_doc__form_id_doc_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_doc__form_id_doc_seq OWNER TO postgres;

--
-- Name: lb_doc__history; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_doc__history (
    id_doc integer NOT NULL,
    document json NOT NULL,
    dt_doc timestamp without time zone NOT NULL,
    dt_last_up timestamp without time zone NOT NULL,
    dt_del timestamp without time zone,
    dt_idx timestamp without time zone
);


ALTER TABLE lb_doc__history OWNER TO postgres;

--
-- Name: lb_doc__history_id_doc_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE lb_doc__history_id_doc_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_doc__history_id_doc_seq OWNER TO postgres;

--
-- Name: lb_doc__portal; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_doc__portal (
    id_doc integer NOT NULL,
    document json NOT NULL,
    dt_doc timestamp without time zone NOT NULL,
    dt_last_up timestamp without time zone NOT NULL,
    dt_del timestamp without time zone,
    dt_idx timestamp without time zone,
    cpf_user character varying,
    nm_portal character varying
);


ALTER TABLE lb_doc__portal OWNER TO postgres;

--
-- Name: lb_doc__portal_id_doc_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE lb_doc__portal_id_doc_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_doc__portal_id_doc_seq OWNER TO postgres;

--
-- Name: lb_doc__report; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_doc__report (
    id_doc integer NOT NULL,
    document json NOT NULL,
    dt_doc timestamp without time zone NOT NULL,
    dt_last_up timestamp without time zone NOT NULL,
    dt_del timestamp without time zone,
    dt_idx timestamp without time zone
);


ALTER TABLE lb_doc__report OWNER TO postgres;

--
-- Name: lb_doc__report_id_doc_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE lb_doc__report_id_doc_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_doc__report_id_doc_seq OWNER TO postgres;

--
-- Name: lb_doc__search; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_doc__search (
    id_doc integer NOT NULL,
    document json NOT NULL,
    dt_doc timestamp without time zone NOT NULL,
    dt_last_up timestamp without time zone NOT NULL,
    dt_del timestamp without time zone,
    dt_idx timestamp without time zone
);


ALTER TABLE lb_doc__search OWNER TO postgres;

--
-- Name: lb_doc__search_id_doc_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE lb_doc__search_id_doc_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_doc__search_id_doc_seq OWNER TO postgres;

--
-- Name: lb_doc__user; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_doc__user (
    id_doc integer NOT NULL,
    document json NOT NULL,
    dt_doc timestamp without time zone NOT NULL,
    dt_last_up timestamp without time zone NOT NULL,
    dt_del timestamp without time zone,
    dt_idx timestamp without time zone,
    name_base character varying[],
    id_user integer,
    status_user boolean,
    access_type character varying[],
    name_user character varying,
    creation_date_user date,
    email_user character varying,
    passwd_user character varying
);


ALTER TABLE lb_doc__user OWNER TO postgres;

--
-- Name: lb_doc__user_id_doc_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE lb_doc__user_id_doc_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_doc__user_id_doc_seq OWNER TO postgres;

--
-- Name: lb_doc_app_user; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_doc_app_user (
    id_doc integer NOT NULL,
    document json NOT NULL,
    dt_doc timestamp without time zone NOT NULL,
    dt_last_up timestamp without time zone NOT NULL,
    dt_del timestamp without time zone,
    dt_idx timestamp without time zone,
    id_user character varying,
    status_user boolean,
    name_user character varying,
    creation_date_user date,
    email_user character varying,
    passwd_user character varying
);


ALTER TABLE lb_doc_app_user OWNER TO postgres;

--
-- Name: lb_doc_app_user_id_doc_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE lb_doc_app_user_id_doc_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_doc_app_user_id_doc_seq OWNER TO postgres;

--
-- Name: lb_doc_log_lbconverter; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_doc_log_lbconverter (
    id_doc integer NOT NULL,
    document json NOT NULL,
    dt_doc timestamp without time zone NOT NULL,
    dt_last_up timestamp without time zone NOT NULL,
    dt_del timestamp without time zone,
    dt_idx timestamp without time zone,
    file_name character varying,
    id_doc_orig integer,
    nm_base character varying,
    dt_error timestamp without time zone
);


ALTER TABLE lb_doc_log_lbconverter OWNER TO postgres;

--
-- Name: lb_doc_log_lbconverter_id_doc_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE lb_doc_log_lbconverter_id_doc_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_doc_log_lbconverter_id_doc_seq OWNER TO postgres;

--
-- Name: lb_doc_log_lbindex; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_doc_log_lbindex (
    id_doc integer NOT NULL,
    document json NOT NULL,
    dt_doc timestamp without time zone NOT NULL,
    dt_last_up timestamp without time zone NOT NULL,
    dt_del timestamp without time zone,
    dt_idx timestamp without time zone,
    id_doc_orig integer,
    dt_last_up_orig timestamp without time zone,
    nm_base character varying,
    dt_error timestamp without time zone
);


ALTER TABLE lb_doc_log_lbindex OWNER TO postgres;

--
-- Name: lb_doc_log_lbindex_id_doc_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE lb_doc_log_lbindex_id_doc_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_doc_log_lbindex_id_doc_seq OWNER TO postgres;

--
-- Name: lb_file__app_config; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_file__app_config (
    id_file uuid NOT NULL,
    id_doc integer,
    filename character varying NOT NULL,
    file bytea NOT NULL,
    mimetype character varying NOT NULL,
    filesize integer NOT NULL,
    filetext character varying,
    dt_ext_text timestamp without time zone
);


ALTER TABLE lb_file__app_config OWNER TO postgres;

--
-- Name: lb_file__form; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_file__form (
    id_file uuid NOT NULL,
    id_doc integer,
    filename character varying NOT NULL,
    file bytea NOT NULL,
    mimetype character varying NOT NULL,
    filesize integer NOT NULL,
    filetext character varying,
    dt_ext_text timestamp without time zone
);


ALTER TABLE lb_file__form OWNER TO postgres;

--
-- Name: lb_file__history; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_file__history (
    id_file integer NOT NULL,
    id_doc integer NOT NULL,
    filename character varying NOT NULL,
    file bytea NOT NULL,
    mimetype character varying NOT NULL,
    filesize integer NOT NULL,
    filetext character varying,
    dt_ext_text timestamp without time zone
);


ALTER TABLE lb_file__history OWNER TO postgres;

--
-- Name: lb_file__portal; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_file__portal (
    id_file uuid NOT NULL,
    id_doc integer,
    filename character varying NOT NULL,
    file bytea NOT NULL,
    mimetype character varying NOT NULL,
    filesize integer NOT NULL,
    filetext character varying,
    dt_ext_text timestamp without time zone
);


ALTER TABLE lb_file__portal OWNER TO postgres;

--
-- Name: lb_file__report; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_file__report (
    id_file uuid NOT NULL,
    id_doc integer,
    filename character varying NOT NULL,
    file bytea NOT NULL,
    mimetype character varying NOT NULL,
    filesize integer NOT NULL,
    filetext character varying,
    dt_ext_text timestamp without time zone
);


ALTER TABLE lb_file__report OWNER TO postgres;

--
-- Name: lb_file__search; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_file__search (
    id_file uuid NOT NULL,
    id_doc integer,
    filename character varying NOT NULL,
    file bytea NOT NULL,
    mimetype character varying NOT NULL,
    filesize integer NOT NULL,
    filetext character varying,
    dt_ext_text timestamp without time zone
);


ALTER TABLE lb_file__search OWNER TO postgres;

--
-- Name: lb_file__user; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_file__user (
    id_file integer NOT NULL,
    id_doc integer NOT NULL,
    filename character varying NOT NULL,
    file bytea NOT NULL,
    mimetype character varying NOT NULL,
    filesize integer NOT NULL,
    filetext character varying,
    dt_ext_text timestamp without time zone
);


ALTER TABLE lb_file__user OWNER TO postgres;

--
-- Name: lb_file_app_user; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_file_app_user (
    id_file uuid NOT NULL,
    id_doc integer,
    filename character varying NOT NULL,
    file bytea NOT NULL,
    mimetype character varying NOT NULL,
    filesize integer NOT NULL,
    filetext character varying,
    dt_ext_text timestamp without time zone
);


ALTER TABLE lb_file_app_user OWNER TO postgres;

--
-- Name: lb_file_log_lbconverter; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_file_log_lbconverter (
    id_file uuid NOT NULL,
    id_doc integer,
    filename character varying NOT NULL,
    file bytea NOT NULL,
    mimetype character varying NOT NULL,
    filesize integer NOT NULL,
    filetext character varying,
    dt_ext_text timestamp without time zone
);


ALTER TABLE lb_file_log_lbconverter OWNER TO postgres;

--
-- Name: lb_file_log_lbindex; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_file_log_lbindex (
    id_file integer NOT NULL,
    id_doc integer NOT NULL,
    filename character varying NOT NULL,
    file bytea NOT NULL,
    mimetype character varying NOT NULL,
    filesize integer NOT NULL,
    filetext character varying,
    dt_ext_text timestamp without time zone
);


ALTER TABLE lb_file_log_lbindex OWNER TO postgres;

--
-- Name: lb_index_error; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_index_error (
    id_error integer NOT NULL,
    base character varying NOT NULL,
    id_doc integer NOT NULL,
    dt_error timestamp without time zone NOT NULL,
    msg_error character varying
);


ALTER TABLE lb_index_error OWNER TO postgres;

--
-- Name: lb_index_error_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE lb_index_error_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_index_error_seq OWNER TO postgres;

--
-- Name: lb_txt_idx; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE lb_txt_idx (
    id_idx integer NOT NULL,
    nm_idx character varying NOT NULL,
    cfg_idx character varying NOT NULL,
    dt_crt_idx timestamp without time zone NOT NULL,
    dt_upt_idx timestamp without time zone NOT NULL,
    url_idx character varying NOT NULL,
    actv_idx boolean NOT NULL,
    struct character varying NOT NULL
);


ALTER TABLE lb_txt_idx OWNER TO postgres;

--
-- Name: lb_txt_idx_id_idx_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE lb_txt_idx_id_idx_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE lb_txt_idx_id_idx_seq OWNER TO postgres;

--
-- Name: lb_txt_idx_id_idx_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE lb_txt_idx_id_idx_seq OWNED BY lb_txt_idx.id_idx;


--
-- Name: id_base; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY lb_base ALTER COLUMN id_base SET DEFAULT nextval('lb_base_id_base_seq'::regclass);


--
-- Name: id_idx; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY lb_txt_idx ALTER COLUMN id_idx SET DEFAULT nextval('lb_txt_idx_id_idx_seq'::regclass);


--
-- Data for Name: alembic_version; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY alembic_version (version_num) FROM stdin;
541f8046f693
\.


--
-- Data for Name: lb_base; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lb_base (id_base, name, struct, dt_base, idx_exp, idx_exp_url, idx_exp_time, file_ext, file_ext_time, txt_mapping) FROM stdin;
2	_form	{"content":[{"field":{"name":"id_base","datatype":"Integer","required":true,"alias":"id_base","multivalued":false,"indices":["Textual"],"description":"Base ID."}},{"field":{"name":"author","datatype":"Text","required":true,"alias":"author","multivalued":false,"indices":["Textual"],"description":"Event Author."}},{"field":{"name":"name","datatype":"Text","required":true,"alias":"name","multivalued":false,"indices":["Textual"],"description":"Form name."}},{"field":{"name":"description","datatype":"Text","required":true,"alias":"description","multivalued":false,"indices":["Textual"],"description":"Form description."}},{"field":{"name":"structure","datatype":"Json","required":true,"alias":"structure","multivalued":false,"indices":["Textual"],"description":"Form structure"}}],"metadata":{"admin_users":[],"color":"#000000","description":"LightBase's Form Meta Base.","dt_base":"01/01/2017 00:00:00","file_ext":false,"file_ext_time":0,"idx_exp":false,"idx_exp_time":0,"idx_exp_url":"","id_base":2,"name":"_form","owner":"","password":"","txt_mapping":"","model":{"author":"Text","description":"Text","id_base":"Integer","name":"Text","structure":"Json"}}}	2017-01-01 00:00:00	f		0	f	0	
3	_history	{"content":[{"field":{"alias":"id_base","description":"Base old ID.","name":"id_base","datatype":"Integer","indices":["Textual"],"required":true,"multivalued":false}},{"field":{"alias":"author","description":"Event Author.","name":"author","datatype":"Text","indices":["Textual"],"required":true,"multivalued":false}},{"field":{"alias":"date","description":"Event Date.","name":"date","datatype":"DateTime","indices":["Textual"],"required":true,"multivalued":false}},{"field":{"alias":"name","description":"Base old name.","name":"name","datatype":"Text","indices":["Textual"],"required":true,"multivalued":false}},{"field":{"alias":"structure","description":"Base old structure","name":"structure","datatype":"Json","indices":["Textual"],"required":true,"multivalued":false}},{"field":{"alias":"status","description":"Base status","name":"status","datatype":"Text","indices":["Textual"],"required":true,"multivalued":false}}],"metadata":{"admin_users":[],"color":"#000000","description":"LightBase - History Meta Base.","dt_base":"01/01/2017 00:00:00","file_ext":false,"file_ext_time":0,"idx_exp":false,"idx_exp_time":0,"idx_exp_url":"","id_base":3,"name":"_history","owner":"","password":"","txt_mapping":"","model":{"author":"Text","date":"DateTime","id_base":"Integer","name":"Text","status":"Text","structure":"Json"}}}	2017-01-01 00:00:00	f		0	f	0	
7	_user	{"content":[{"field":{"alias":"id","description":"LightBase's uses ID","name":"id_user","datatype":"Integer","indices":["Textual","Ordenado"],"required":true,"multivalued":false}},{"field":{"alias":"name","description":"User's name","name":"name_user","datatype":"Text","indices":["Textual","Ordenado"],"required":true,"multivalued":false}},{"field":{"alias":"email","description":"User's mail","name":"email_user","datatype":"Text","indices":["Textual","Ordenado"],"required":true,"multivalued":false}},{"field":{"alias":"passwd","description":"User's password","name":"passwd_user","datatype":"Text","indices":["Textual","Ordenado"],"required":true,"multivalued":false}},{"group":{"content":[{"field":{"alias":"name_base","description":"Name of the base the user can access","name":"name_base","datatype":"Text","indices":["Textual","Ordenado","Fuzzy"],"required":false,"multivalued":false}},{"field":{"alias":"access_type","description":"Type of access the user has","name":"access_type","datatype":"Text","indices":["Textual","Ordenado"],"required":false,"multivalued":false}}],"metadata":{"alias":"bases","description":"List of bases that the user can access and what kind of access it is","multivalued":true,"name":"bases_user"}}},{"field":{"alias":"creation_date","description":"Date the user account was created","name":"creation_date_user","datatype":"Date","indices":["Textual","Ordenado"],"required":true,"multivalued":false}},{"field":{"alias":"status","description":"Check if the user is activer or not","name":"status_user","datatype":"Boolean","indices":["Textual","Ordenado"],"required":true,"multivalued":false}}],"metadata":{"admin_users":[],"color":"#000000","description":"LightBase's Users Meta Base.","dt_base":"01/01/2017 00:00:00","file_ext":false,"file_ext_time":0,"idx_exp":false,"idx_exp_time":0,"idx_exp_url":"","id_base":7,"name":"_user","owner":"","password":"","txt_mapping":"","model":{"creation_date_user":"Date","email_user":"Text","id_user":"Integer","name_user":"Text","passwd_user":"Text","status_user":"Boolean","bases_user":[{"access_type":"Text","name_base":"Text"}]}}}	2017-01-01 00:00:00	f		0	f	0	
8	app_user	{"content":[{"field":{"name":"id_user","datatype":"Text","required":true,"alias":"id_user","multivalued":false,"indices":["Textual","Ordenado"],"description":"LightBase's uses ID"}},{"field":{"name":"name_user","datatype":"Text","required":true,"alias":"name","multivalued":false,"indices":["Textual","Ordenado"],"description":"User's name"}},{"field":{"name":"email_user","datatype":"Text","required":true,"alias":"email","multivalued":false,"indices":["Textual","Ordenado"],"description":"User's mail"}},{"field":{"name":"passwd_user","datatype":"Text","required":true,"alias":"passwd","multivalued":false,"indices":["Textual","Ordenado"],"description":"User's password"}},{"field":{"name":"bases","datatype":"Integer","required":false,"alias":"bases","multivalued":true,"indices":["Textual"],"description":"Id doc list the base the user is owner"}},{"field":{"name":"forms","datatype":"Integer","required":false,"alias":"forms","multivalued":true,"indices":["Textual"],"description":"Id doc list of the form where user can access"}},{"field":{"name":"reports","datatype":"Text","required":false,"alias":"reports","multivalued":true,"indices":["Textual"],"description":"Id doc list of the report where user can access"}},{"group":{"content":[{"field":{"name":"id","datatype":"Integer","required":true,"alias":"id","multivalued":false,"indices":["Textual"],"description":"Id doc of element"}},{"field":{"name":"type","datatype":"Text","required":true,"alias":"type","multivalued":false,"indices":["Textual"],"description":"Types allowed form, base and report"}}],"metadata":{"multivalued":true,"alias":"shortcuts","name":"shortcuts","description":"List of shortcuts of user"}}},{"field":{"name":"creation_date_user","datatype":"Date","required":true,"alias":"creation_date","multivalued":false,"indices":["Textual","Ordenado"],"description":"Date the user account was created"}},{"field":{"name":"status_user","datatype":"Boolean","required":true,"alias":"status","multivalued":false,"indices":["Textual","Ordenado"],"description":"Check if the user is activer or not"}}],"metadata":{"admin_users":[],"color":"#000000","description":"LightBase's Users Meta Base.","dt_base":"01/01/2017 00:00:00","file_ext":false,"file_ext_time":0,"idx_exp":false,"idx_exp_time":0,"idx_exp_url":"","id_base":8,"name":"app_user","owner":"","password":"","txt_mapping":"","model":{"bases":["Integer"],"creation_date_user":"Date","email_user":"Text","forms":["Integer"],"id_user":"Text","name_user":"Text","passwd_user":"Text","reports":["Text"],"status_user":"Boolean","shortcuts":[{"id":"Integer","type":"Text"}]}}}	2017-01-01 00:00:00	f		0	f	0	
9	log_lbconverter	{"content":[{"field":{"name":"nm_base","datatype":"Text","required":true,"alias":"Nome da base","multivalued":false,"indices":["Ordenado"],"description":"Nome da base"}},{"field":{"name":"id_doc_orig","datatype":"Integer","required":true,"alias":"id_doc_orig","multivalued":false,"indices":["Textual","Ordenado"],"description":"id do documento que originou o erro."}},{"field":{"name":"id_file_orig","datatype":"Text","required":true,"alias":"id_file_orig","multivalued":false,"indices":["Textual"],"description":"ID do arquivo que originou o erro."}},{"field":{"name":"file_name","datatype":"Text","required":true,"alias":"file_name","multivalued":false,"indices":["Ordenado"],"description":"File name"}},{"field":{"name":"error_msg","datatype":"Text","required":true,"alias":"Mensagem de erro","multivalued":false,"indices":["Nenhum"],"description":"Mensagem de erro"}},{"field":{"name":"dt_error","datatype":"DateTime","required":true,"alias":"Data do erro","multivalued":false,"indices":["Textual","Ordenado"],"description":"Data do erro"}}],"metadata":{"admin_users":[],"color":"#000000","description":"LightBase - Log de erros do LBConverter","dt_base":"01/01/2017 00:00:00","file_ext":false,"file_ext_time":0,"idx_exp":false,"idx_exp_time":0,"idx_exp_url":"","id_base":9,"name":"log_lbconverter","owner":"","password":"","txt_mapping":"","model":{"dt_error":"DateTime","error_msg":"Text","file_name":"Text","id_doc_orig":"Integer","id_file_orig":"Text","nm_base":"Text"}}}	2017-01-01 00:00:00	f		0	f	0	
5	_report	{"content":[{"field":{"name":"id_base","datatype":"Integer","required":true,"alias":"id_base","multivalued":false,"indices":["Textual"],"description":"Base ID."}},{"field":{"name":"author","datatype":"Text","required":true,"alias":"author","multivalued":false,"indices":["Textual"],"description":"Event Author."}},{"field":{"name":"name","datatype":"Text","required":true,"alias":"name","multivalued":false,"indices":["Textual"],"description":"Report name."}},{"field":{"name":"description","datatype":"Text","required":true,"alias":"description","multivalued":false,"indices":["Textual"],"description":"Report description."}},{"field":{"name":"structure","datatype":"Json","required":true,"alias":"structure","multivalued":false,"indices":["Textual"],"description":"Report structure"}}],"metadata":{"admin_users":[],"color":"#000000","description":"LightBase's Report Meta Base.","dt_base":"01/01/2017 00:00:00","file_ext":false,"file_ext_time":0,"idx_exp":false,"idx_exp_time":0,"idx_exp_url":"","id_base":5,"name":"_report","owner":"","password":"","txt_mapping":"","model":{"author":"Text","description":"Text","id_base":"Integer","name":"Text","structure":"Json"}}}	2017-01-01 00:00:00	f		0	f	0	
10	log_lbindex	{"content":[{"field":{"alias":"Nome da base","description":"Nome da base","name":"nm_base","datatype":"Text","indices":["Ordenado"],"required":true,"multivalued":false}},{"field":{"alias":"identificador do documento","description":"id do documento que originou o erro.","name":"id_doc_orig","datatype":"Integer","indices":["Textual","Ordenado"],"required":true,"multivalued":false}},{"field":{"alias":"Mensagem de erro","description":"Mensagem de erro","name":"error_msg","datatype":"Text","indices":["Nenhum"],"required":true,"multivalued":false}},{"field":{"alias":"Data do erro","description":"Data e Hora no formato DD/MM/AAAA - HH:MM:SS do erro","name":"dt_error","datatype":"DateTime","indices":["Textual","Ordenado"],"required":true,"multivalued":false}},{"field":{"alias":"dt_last_up_orig","description":"Data e Hora no formato DD/MM/AAAA - HH:MM:SS da última atualização do registro que originou o erro.","name":"dt_last_up_orig","datatype":"DateTime","indices":["Textual","Ordenado"],"required":true,"multivalued":false}}],"metadata":{"admin_users":[],"color":"#000000","description":"LightBase - Log de erros do LBIndex","dt_base":"01/01/2017 00:00:00","file_ext":false,"file_ext_time":0,"idx_exp":false,"idx_exp_time":0,"idx_exp_url":"","id_base":10,"name":"log_lbindex","owner":"","password":"","txt_mapping":"","model":{"dt_error":"DateTime","dt_last_up_orig":"DateTime","error_msg":"Text","id_doc_orig":"Integer","nm_base":"Text"}}}	2017-01-01 00:00:00	f		0	f	0	
6	_search	{"content":[{"field":{"name":"id_base","datatype":"Integer","required":true,"alias":"id_base","multivalued":false,"indices":["Textual"],"description":"Base ID. Identifies the base from which the search was generated."}},{"field":{"name":"author","datatype":"Text","required":true,"alias":"author","multivalued":false,"indices":["Textual"],"description":"Event Author. Contains the id of the author, user, who created the search."}},{"field":{"name":"name","datatype":"Text","required":true,"alias":"Name","multivalued":false,"indices":["Textual"],"description":"Search name. It is a name that identifies the search."}},{"field":{"name":"type","datatype":"Text","required":true,"alias":"Type","multivalued":false,"indices":["Textual"],"description":"Type search. Identifies what type of search. Initially there are 3 types, general, direct and advanced."}},{"field":{"name":"description","datatype":"Text","required":true,"alias":"description","multivalued":false,"indices":["Textual"],"description":"Search description. Explanatory or complementary description to help identify the search."}},{"field":{"name":"structure","datatype":"Json","required":true,"alias":"structure","multivalued":false,"indices":["Textual"],"description":"Search structure. Contains the settings for each search field."}}],"metadata":{"admin_users":[],"color":"#000000","description":"LightBase's Search Meta Base.","dt_base":"01/01/2017 00:00:00","file_ext":false,"file_ext_time":0,"idx_exp":false,"idx_exp_time":0,"idx_exp_url":"","id_base":6,"name":"_search","owner":"","password":"","txt_mapping":"","model":{"author":"Text","description":"Text","id_base":"Integer","name":"Text","structure":"Json","type":"Text"}}}	2017-01-01 00:00:00	f		0	f	0	
4	_portal	{"content":[{"field":{"name":"nm_portal","datatype":"Text","required":true,"alias":"Nome do Portal","multivalued":false,"indices":["Textual","Ordenado"],"description":"Contém o nome do portal. Usado para diferenciar os portais."}},{"field":{"name":"alias_portal","datatype":"Text","required":true,"alias":"Apelido do Portal","multivalued":false,"indices":["Textual"],"description":"Este campo informa um apelido, possibilitando exibir um nome amigável."}},{"field":{"name":"ds_portal","datatype":"Text","required":true,"alias":"Descrição","multivalued":false,"indices":["Textual"],"description":"Contém um texto falando sobre o portal. Qual a finalidade do portal criado."}},{"field":{"name":"cpf_user","datatype":"Text","required":false,"alias":"CPF do Usuário","multivalued":false,"indices":["Textual","Ordenado"],"description":"Indica o cpf do usuário que criou o portal. Auxilia a listar os portais de cada usuário"}},{"group":{"content":[{"field":{"name":"nm_base","datatype":"Text","required":true,"alias":"Nome da Base","multivalued":false,"indices":["Textual"],"description":"Contém o nome da base, deve ser o mesmo nome com o qual a base está salva no lightbase. Será usado para auxiliar nas pesquisas feitas pelo portal."}},{"field":{"name":"ds_base","datatype":"Text","required":true,"alias":"Apelido da Base","multivalued":false,"indices":["Textual"],"description":"Este campo informa um apelido, possibilitando exibir um nome amigável no Portal de Pesquisas."}},{"field":{"name":"url_index","datatype":"Url","required":false,"alias":"Url do Indexador","multivalued":false,"indices":["Textual"],"description":"Uma URL que indica o host onde será feita a pesquisa via REST. Pode ser, por exemplo, a URL de um host com o ELastic Search instalado e com os dados indexados."}},{"field":{"name":"url_detail","datatype":"Url","required":false,"alias":"URL de Detalhe","multivalued":false,"indices":["Textual"],"description":"Representa a URL da página de detalhes. O valor é oriundo da aplicação em questão, ou seja, de acordo a aplicação referenciada o nome da página pode ser DetalhesRecebidos.aspx ou DetalhesExpedido.aspx"}},{"field":{"name":"url_app","datatype":"Url","required":false,"alias":"Url da aplicação","multivalued":false,"indices":["Textual"],"description":"Este campo é usado para possibilitar links entre o portal e a aplicação que utiliza esta base, como, por exemplo, abrir os detalhes de um registro pesquisado para abrir na página da aplicação."}},{"field":{"name":"nr_order","datatype":"Integer","required":false,"alias":"Ordem","multivalued":false,"indices":["Textual"],"description":"Auxilia a ordenar as abas no portal de pesquisa."}},{"group":{"content":[{"group":{"content":[{"field":{"name":"nm_display_direct","datatype":"Text","required":false,"alias":"Nome exibido","multivalued":false,"indices":["Textual"],"description":"Contém o nome com o qual o campo deve ser exibido na tela de pesquisa direta."}},{"field":{"name":"in_display_direct","datatype":"Boolean","required":false,"alias":"Exibir?","multivalued":false,"indices":["Textual"],"description":"Contém uma flag informando se o campo deve ser exibido na tela de pesquisa direta."}},{"field":{"name":"nm_type_control_direct","datatype":"Text","required":false,"alias":"Tipo de controle","multivalued":false,"indices":["Textual"],"description":"Define o controle que deve ser carregado para o campo na tela de pesquisa direta."}},{"field":{"name":"nr_position_direct","datatype":"Integer","required":false,"alias":"Posição","multivalued":false,"indices":["Textual"],"description":"Contém um inteiro informando a posição do campo na tela de pesquisa direta."}},{"field":{"name":"script_direct","datatype":"TextArea","required":false,"alias":"script","multivalued":false,"indices":["Textual"],"description":"Contém um script que será executado no momento que o campo for exibido na tela de pesquisa direta."}}],"metadata":{"multivalued":false,"alias":"Informações busca direta","name":"inf_direct_search","description":"Contém informações de como o campo se comporta na tela de busca direta."}}},{"group":{"content":[{"field":{"name":"nm_display_advanced","datatype":"Text","required":false,"alias":"Nome exibido","multivalued":false,"indices":["Textual"],"description":"Contém o nome com o qual o campo deve ser exibido na tela de pesquisa avançada."}},{"field":{"name":"in_display_advanced","datatype":"Boolean","required":false,"alias":"Exibir?","multivalued":false,"indices":["Textual"],"description":"Contém uma flag informando se o campo deve ser exibido na tela de pesquisa avançada."}},{"field":{"name":"in_fixed_advanced","datatype":"Boolean","required":false,"alias":"Campo fixo?","multivalued":false,"indices":["Textual"],"description":"Contém uma flag informando se o campo é fixo na tela de pesquisa avançada. Nesta tela os campo são escolhidos dinamicamente e inseridos como argumento de pesquisa, mas se o campo for fixo ela já fica fixado na tela."}},{"field":{"name":"nm_type_control_advanced","datatype":"Text","required":false,"alias":"Tipo de Controle","multivalued":false,"indices":["Textual"],"description":"Define o controle que deve ser carregado na pesquisa avançada para exibir este campo."}},{"field":{"name":"script_advanced","datatype":"TextArea","required":false,"alias":"script","multivalued":false,"indices":["Textual"],"description":"Contém um script para ser executado na página nome momento em que o campo é exibido."}}],"metadata":{"multivalued":false,"alias":"Informações pesquisa avançada","name":"inf_advanced_search","description":"Contém informações que definem como o campo se comporta na tela de pesquisa avançada."}}},{"group":{"content":[{"field":{"name":"nm_display_listed","datatype":"Text","required":false,"alias":"Nome exibido","multivalued":false,"indices":["Textual"],"description":"Contém o nome que deve exibido na coluna da tabela resultado de pesquisa."}},{"field":{"name":"in_select_listed","datatype":"Boolean","required":false,"alias":"Recuperar?","multivalued":false,"indices":["Textual"],"description":"Contém uma flag informando se o campo deve ser selecionado no resultado de pesquisa, ou seja, recuperado nas consultas."}},{"field":{"name":"in_display_listed","datatype":"Boolean","required":false,"alias":"Exibir?","multivalued":false,"indices":["Textual"],"description":"Contém uma flag informando se o campo deve ser exibido no resultado de pesquisa"}},{"field":{"name":"in_search_listed","datatype":"Boolean","required":false,"alias":"Pesquisar?","multivalued":false,"indices":["Textual"],"description":"Contém uma flag informando se o campo é usado na pesquisa. Essa informação é relevante para a pesquisa direta, que realiza a busca nos campos que contém essa flag marcada com true."}},{"field":{"name":"nr_position_listed","datatype":"Integer","required":false,"alias":"Posição","multivalued":false,"indices":["Textual"],"description":"Defina a posição da coluna na tabela de resultado de pesquisa."}},{"field":{"name":"script_listed","datatype":"TextArea","required":false,"alias":"script","multivalued":false,"indices":["Textual"],"description":"Contém um script que será executado na exibição do campo na tabela de resultado de pesquisa. É útil para criar botões, links, etc."}},{"field":{"name":"in_sortable_listed","datatype":"Boolean","required":false,"alias":"Ordenar?","multivalued":false,"indices":["Textual"],"description":"Indica se a coluna é ordenável na tabela do resultado de pesquisa."}}],"metadata":{"multivalued":false,"alias":"Informações resultado de pesquisa","name":"inf_listed_search","description":"Contém as informações do campo de como se comportar na pesquisa listada."}}},{"group":{"content":[{"field":{"name":"nm_display_detailed","datatype":"Text","required":false,"alias":"Nome exibido","multivalued":false,"indices":["Textual"],"description":"contém o nome com o qual o campo deve ser exibido na tela de detalhes."}},{"field":{"name":"in_display_detailed","datatype":"Boolean","required":false,"alias":"Exibir?","multivalued":false,"indices":["Textual"],"description":"Contém uma flag dizendo se o campo é exibido ou não tela de detalhes."}},{"field":{"name":"in_search_detailed","datatype":"Boolean","required":false,"alias":"Pesquisar?","multivalued":false,"indices":["Textual"],"description":"Contém uma flag informando se o campo é pesquisado para chamar a página de detalhes."}},{"field":{"name":"nr_position_detailed","datatype":"Integer","required":false,"alias":"Posição","multivalued":false,"indices":["Textual"],"description":"Contém um inteiro informando a posição do campo na tela de detalhes."}},{"field":{"name":"script_detailed","datatype":"TextArea","required":false,"alias":"Script","multivalued":false,"indices":["Textual"],"description":"Contém um script que deve ser executado na exibição do campo na página de detalhes. Por exemplo, criar um link dentro campo."}}],"metadata":{"multivalued":false,"alias":"Informações da tela de detalhes","name":"inf_detailed_search","description":"Contém as informações de como o campo se comporta na tela de detalhes. Caso esta tela seja tratada no portal, pois ela pode ser de outra aplicação e neste caso usasse o campo url_detail."}}},{"group":{"content":[{"field":{"name":"data_tabulated","datatype":"Json","required":false,"alias":"Lista de dados","multivalued":false,"indices":["Textual"],"description":"Contém uma lista de objetos json. Serve para criar uma tabela estática com os campo tabelados. Por exemplo, uma tabela de siglas e nomes de estados."}},{"field":{"name":"nm_field_value_tabulated","datatype":"Text","required":false,"alias":"Nome do campo valor","multivalued":false,"indices":["Textual"],"description":"Contém o nome do campo da base referenciada que contém o valor."}},{"field":{"name":"nm_field_key_tabulated","datatype":"Text","required":false,"alias":"Nome Campo Chave","multivalued":false,"indices":["Textual"],"description":"Contém o nome do campo da base referenciada que contém a chave do valor."}},{"field":{"name":"relational_key_tabulated","datatype":"Text","required":false,"alias":"Chave relacional","multivalued":false,"indices":["Textual"],"description":"Contém o nome da coluna que contém a chave da relação. É o campo referenciado na base."}},{"field":{"name":"nm_table_tabulated","datatype":"Text","required":false,"alias":"Nome da tabela referenciada","multivalued":false,"indices":["Textual"],"description":"Contém o nome da tabela que está sendo usada para tabelar o campo."}}],"metadata":{"multivalued":false,"alias":"Informações Campo Tabelado","name":"inf_field_tabulated","description":"Define as informações de campos tabelados. Só precisa ser preenchido se o tipo de campo for igual a tabulated."}}},{"field":{"name":"groups_can_view","datatype":"Text","required":false,"alias":"Grupos","multivalued":true,"indices":["Textual"],"description":"Define os grupos que podem visualizar o campo."}},{"field":{"name":"ds_field","datatype":"Text","required":false,"alias":"Apelido do campo","multivalued":false,"indices":["Textual"],"description":"Define o apelido do campo. É um nome mais amigável para ser exibido no portal."}},{"field":{"name":"nm_field","datatype":"Text","required":true,"alias":"Nome do campo","multivalued":false,"indices":["Textual"],"description":"Nome do campo da base. Deve coincidir com o nome do campo que está salvo no lightbase."}},{"field":{"name":"nm_type_field","datatype":"Text","required":true,"alias":"Tipo de campo","multivalued":false,"indices":["Textual"],"description":"Indica qual o tipo de campo. É utilizado pelo portal para saber como exibir o campo. É oriundo dos tipos de campo que o lightbase usa para criar campos."}}],"metadata":{"multivalued":true,"alias":"Campo","name":"field","description":"Representa os campos da base. Informa onde e como serão usados pelo portal."}}}],"metadata":{"multivalued":true,"alias":"Bases do Portal","name":"bases","description":"Contém as Bases do portal."}}}],"metadata":{"admin_users":[],"color":"#000000","description":"Novo conceito do portal. Uma base _portal lista todos os portais separados por nome e com o id do usu-ario que criou.","dt_base":"01/01/2017 00:00:00","file_ext":false,"file_ext_time":0,"idx_exp":false,"idx_exp_time":0,"idx_exp_url":"","id_base":4,"name":"_portal","owner":"","password":"","txt_mapping":"","model":{"alias_portal":"Text","cpf_user":"Text","ds_portal":"Text","nm_portal":"Text","bases":[{"ds_base":"Text","nm_base":"Text","nr_order":"Integer","url_app":"Url","url_detail":"Url","url_index":"Url","field":[{"ds_field":"Text","groups_can_view":["Text"],"nm_field":"Text","nm_type_field":"Text","inf_advanced_search":{"in_fixed_advanced":"Boolean","in_display_advanced":"Boolean","nm_type_control_advanced":"Text","nm_display_advanced":"Text","script_advanced":"TextArea"},"inf_detailed_search":{"nm_display_detailed":"Text","in_search_detailed":"Boolean","in_display_detailed":"Boolean","script_detailed":"TextArea","nr_position_detailed":"Integer"},"inf_direct_search":{"nr_position_direct":"Integer","nm_display_direct":"Text","script_direct":"TextArea","nm_type_control_direct":"Text","in_display_direct":"Boolean"},"inf_field_tabulated":{"nm_table_tabulated":"Text","nm_field_key_tabulated":"Text","relational_key_tabulated":"Text","data_tabulated":"Json","nm_field_value_tabulated":"Text"},"inf_listed_search":{"in_search_listed":"Boolean","nm_display_listed":"Text","in_select_listed":"Boolean","in_sortable_listed":"Boolean","nr_position_listed":"Integer","script_listed":"TextArea","in_display_listed":"Boolean"}}]}]}}}	2017-01-01 00:00:00	f		0	f	0	
1	_app_config	{"content":[{"field":{"name":"nm_aplicacao","datatype":"Text","required":false,"alias":"Aplicação","multivalued":false,"indices":["Textual","Ordenado"],"description":"Define o nome da aplicação"}},{"field":{"name":"nm_apelido","datatype":"Text","required":false,"alias":"nm_apelido","multivalued":false,"indices":["Textual","Ordenado"],"description":"Apelido da aplicação. Campo usado para identificar à qual aplicação o config pertence ou de qual aplicação. Oriundo da tabela Aplicação nm_apelido."}},{"group":{"content":[{"field":{"name":"manual","datatype":"File","required":false,"alias":"manual","multivalued":false,"indices":["Textual"],"description":"Manuais"}},{"field":{"name":"ch_manual","datatype":"Text","required":true,"alias":"Chave do manual","multivalued":false,"indices":["Textual"],"description":"Chave para tornar única a identificação de cada manual."}},{"field":{"name":"nm_manual","datatype":"Text","required":true,"alias":"Nome do manual","multivalued":false,"indices":["Textual"],"description":"Nome do manual"}},{"field":{"name":"color","datatype":"Text","required":false,"alias":"Cor","multivalued":false,"indices":["Textual"],"description":"Cor na qual aparece para download"}},{"group":{"content":[{"field":{"name":"nr_cpf_user_alteracao","datatype":"Text","required":false,"alias":"Número do CPF do usuário da alteração","multivalued":false,"indices":["Textual"],"description":"Número do CPF do usuário da ultima alteração. Campo usado para informar o cpf do usuário que fez a ultima alteração."}},{"field":{"name":"dt_alteracao","datatype":"DateTime","required":false,"alias":"Data e hora da alteração","multivalued":false,"indices":["Textual"],"description":"Data e Hora no formato DD/MM/AAAA - HH:MM:SS . Campo usado para informar a data e hora da alteração."}},{"field":{"name":"nm_user_alteracao","datatype":"Text","required":false,"alias":"Nome do usuário da alteração","multivalued":false,"indices":["Textual","Ordenado"],"description":"Nome do usuário da alteração. Campo usado para informar o nome do usuário que fez a alteração."}}],"metadata":{"multivalued":true,"alias":"Alteração","name":"alteracao","description":"Alteração"}}},{"group":{"content":[{"field":{"name":"nr_cpf_user_inclusao","datatype":"Text","required":false,"alias":"Número do CPF do usuário que incluiu.","multivalued":false,"indices":["Textual"],"description":"Número do CPF do usuário que incluiu. Campo usado para informar o cpf do usuário que fez a inclusão do registro."}},{"field":{"name":"dt_inclusao","datatype":"Text","required":false,"alias":"Data e Hora da inclusão","multivalued":false,"indices":["Textual"],"description":"Data e Hora no formato DD/MM/AAAA - HH:MM:SS de inclusão do usuário no Cadastro. Campo usado para informar a data que o usuário foi incluído."}},{"field":{"name":"nm_user_inclusao","datatype":"Text","required":false,"alias":"Nome do usuário que incluiu","multivalued":false,"indices":["Textual"],"description":"Nome do usuário que incluiu. Campo usado para informar o nome do usuário que realizou a inclusão do usuário."}}],"metadata":{"multivalued":false,"alias":"Inclusão","name":"inclusao","description":"Inclusão"}}}],"metadata":{"multivalued":true,"alias":"Manuais","name":"manuais","description":"Manuais"}}}],"metadata":{"admin_users":[],"color":"#000000","description":"Configurações da aplicação","dt_base":"01/01/2017 00:00:00","file_ext":false,"file_ext_time":0,"idx_exp":false,"idx_exp_time":0,"idx_exp_url":"","id_base":1,"name":"_app_config","owner":"","password":"","txt_mapping":"","model":{"nm_apelido":"Text","nm_aplicacao":"Text","manuais":[{"ch_manual":"Text","color":"Text","manual":"File","nm_manual":"Text","alteracao":[{"dt_alteracao":"DateTime","nm_user_alteracao":"Text","nr_cpf_user_alteracao":"Text"}],"inclusao":{"dt_inclusao":"Text","nm_user_inclusao":"Text","nr_cpf_user_inclusao":"Text"}}]}}}	2017-01-01 00:00:00	f		0	f	0	
\.


--
-- Name: lb_base_id_base_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('lb_base_id_base_seq', 10, true);


--
-- Data for Name: lb_doc__app_config; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lb_doc__app_config (id_doc, document, dt_doc, dt_last_up, dt_del, dt_idx, nm_user_alteracao, nm_apelido, nm_aplicacao) FROM stdin;
\.


--
-- Name: lb_doc__app_config_id_doc_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('lb_doc__app_config_id_doc_seq', 1, false);


--
-- Data for Name: lb_doc__form; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lb_doc__form (id_doc, document, dt_doc, dt_last_up, dt_del, dt_idx) FROM stdin;
\.


--
-- Name: lb_doc__form_id_doc_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('lb_doc__form_id_doc_seq', 1, false);


--
-- Data for Name: lb_doc__history; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lb_doc__history (id_doc, document, dt_doc, dt_last_up, dt_del, dt_idx) FROM stdin;
\.


--
-- Name: lb_doc__history_id_doc_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('lb_doc__history_id_doc_seq', 1, false);


--
-- Data for Name: lb_doc__portal; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lb_doc__portal (id_doc, document, dt_doc, dt_last_up, dt_del, dt_idx, cpf_user, nm_portal) FROM stdin;
\.


--
-- Name: lb_doc__portal_id_doc_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('lb_doc__portal_id_doc_seq', 1, false);


--
-- Data for Name: lb_doc__report; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lb_doc__report (id_doc, document, dt_doc, dt_last_up, dt_del, dt_idx) FROM stdin;
\.


--
-- Name: lb_doc__report_id_doc_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('lb_doc__report_id_doc_seq', 1, false);


--
-- Data for Name: lb_doc__search; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lb_doc__search (id_doc, document, dt_doc, dt_last_up, dt_del, dt_idx) FROM stdin;
\.


--
-- Name: lb_doc__search_id_doc_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('lb_doc__search_id_doc_seq', 1, false);


--
-- Data for Name: lb_doc__user; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lb_doc__user (id_doc, document, dt_doc, dt_last_up, dt_del, dt_idx, name_base, id_user, status_user, access_type, name_user, creation_date_user, email_user, passwd_user) FROM stdin;
\.


--
-- Name: lb_doc__user_id_doc_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('lb_doc__user_id_doc_seq', 1, false);


--
-- Data for Name: lb_doc_app_user; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lb_doc_app_user (id_doc, document, dt_doc, dt_last_up, dt_del, dt_idx, id_user, status_user, name_user, creation_date_user, email_user, passwd_user) FROM stdin;
\.


--
-- Name: lb_doc_app_user_id_doc_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('lb_doc_app_user_id_doc_seq', 1, false);


--
-- Data for Name: lb_doc_log_lbconverter; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lb_doc_log_lbconverter (id_doc, document, dt_doc, dt_last_up, dt_del, dt_idx, file_name, id_doc_orig, nm_base, dt_error) FROM stdin;
\.


--
-- Name: lb_doc_log_lbconverter_id_doc_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('lb_doc_log_lbconverter_id_doc_seq', 1, false);


--
-- Data for Name: lb_doc_log_lbindex; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lb_doc_log_lbindex (id_doc, document, dt_doc, dt_last_up, dt_del, dt_idx, id_doc_orig, dt_last_up_orig, nm_base, dt_error) FROM stdin;
\.


--
-- Name: lb_doc_log_lbindex_id_doc_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('lb_doc_log_lbindex_id_doc_seq', 1, false);


--
-- Data for Name: lb_file__app_config; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lb_file__app_config (id_file, id_doc, filename, file, mimetype, filesize, filetext, dt_ext_text) FROM stdin;
\.


--
-- Data for Name: lb_file__form; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lb_file__form (id_file, id_doc, filename, file, mimetype, filesize, filetext, dt_ext_text) FROM stdin;
\.


--
-- Data for Name: lb_file__history; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lb_file__history (id_file, id_doc, filename, file, mimetype, filesize, filetext, dt_ext_text) FROM stdin;
\.


--
-- Data for Name: lb_file__portal; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lb_file__portal (id_file, id_doc, filename, file, mimetype, filesize, filetext, dt_ext_text) FROM stdin;
\.


--
-- Data for Name: lb_file__report; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lb_file__report (id_file, id_doc, filename, file, mimetype, filesize, filetext, dt_ext_text) FROM stdin;
\.


--
-- Data for Name: lb_file__search; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lb_file__search (id_file, id_doc, filename, file, mimetype, filesize, filetext, dt_ext_text) FROM stdin;
\.


--
-- Data for Name: lb_file__user; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lb_file__user (id_file, id_doc, filename, file, mimetype, filesize, filetext, dt_ext_text) FROM stdin;
\.


--
-- Data for Name: lb_file_app_user; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lb_file_app_user (id_file, id_doc, filename, file, mimetype, filesize, filetext, dt_ext_text) FROM stdin;
\.


--
-- Data for Name: lb_file_log_lbconverter; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lb_file_log_lbconverter (id_file, id_doc, filename, file, mimetype, filesize, filetext, dt_ext_text) FROM stdin;
\.


--
-- Data for Name: lb_file_log_lbindex; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lb_file_log_lbindex (id_file, id_doc, filename, file, mimetype, filesize, filetext, dt_ext_text) FROM stdin;
\.


--
-- Data for Name: lb_index_error; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lb_index_error (id_error, base, id_doc, dt_error, msg_error) FROM stdin;
\.


--
-- Name: lb_index_error_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('lb_index_error_seq', 1, false);


--
-- Data for Name: lb_txt_idx; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY lb_txt_idx (id_idx, nm_idx, cfg_idx, dt_crt_idx, dt_upt_idx, url_idx, actv_idx, struct) FROM stdin;
\.


--
-- Name: lb_txt_idx_id_idx_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('lb_txt_idx_id_idx_seq', 1, false);


--
-- Name: lb_base_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_base
    ADD CONSTRAINT lb_base_name_key UNIQUE (name);


--
-- Name: lb_base_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_base
    ADD CONSTRAINT lb_base_pkey PRIMARY KEY (id_base);


--
-- Name: lb_doc__app_config_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_doc__app_config
    ADD CONSTRAINT lb_doc__app_config_pkey PRIMARY KEY (id_doc);


--
-- Name: lb_doc__form_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_doc__form
    ADD CONSTRAINT lb_doc__form_pkey PRIMARY KEY (id_doc);


--
-- Name: lb_doc__history_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_doc__history
    ADD CONSTRAINT lb_doc__history_pkey PRIMARY KEY (id_doc);


--
-- Name: lb_doc__portal_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_doc__portal
    ADD CONSTRAINT lb_doc__portal_pkey PRIMARY KEY (id_doc);


--
-- Name: lb_doc__report_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_doc__report
    ADD CONSTRAINT lb_doc__report_pkey PRIMARY KEY (id_doc);


--
-- Name: lb_doc__search_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_doc__search
    ADD CONSTRAINT lb_doc__search_pkey PRIMARY KEY (id_doc);


--
-- Name: lb_doc__user_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_doc__user
    ADD CONSTRAINT lb_doc__user_pkey PRIMARY KEY (id_doc);


--
-- Name: lb_doc_app_user_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_doc_app_user
    ADD CONSTRAINT lb_doc_app_user_pkey PRIMARY KEY (id_doc);


--
-- Name: lb_doc_log_lbconverter_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_doc_log_lbconverter
    ADD CONSTRAINT lb_doc_log_lbconverter_pkey PRIMARY KEY (id_doc);


--
-- Name: lb_doc_log_lbindex_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_doc_log_lbindex
    ADD CONSTRAINT lb_doc_log_lbindex_pkey PRIMARY KEY (id_doc);


--
-- Name: lb_file__app_config_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_file__app_config
    ADD CONSTRAINT lb_file__app_config_pkey PRIMARY KEY (id_file);


--
-- Name: lb_file__form_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_file__form
    ADD CONSTRAINT lb_file__form_pkey PRIMARY KEY (id_file);


--
-- Name: lb_file__history_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_file__history
    ADD CONSTRAINT lb_file__history_pkey PRIMARY KEY (id_file);


--
-- Name: lb_file__portal_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_file__portal
    ADD CONSTRAINT lb_file__portal_pkey PRIMARY KEY (id_file);


--
-- Name: lb_file__report_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_file__report
    ADD CONSTRAINT lb_file__report_pkey PRIMARY KEY (id_file);


--
-- Name: lb_file__search_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_file__search
    ADD CONSTRAINT lb_file__search_pkey PRIMARY KEY (id_file);


--
-- Name: lb_file__user_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_file__user
    ADD CONSTRAINT lb_file__user_pkey PRIMARY KEY (id_file);


--
-- Name: lb_file_app_user_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_file_app_user
    ADD CONSTRAINT lb_file_app_user_pkey PRIMARY KEY (id_file);


--
-- Name: lb_file_log_lbconverter_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_file_log_lbconverter
    ADD CONSTRAINT lb_file_log_lbconverter_pkey PRIMARY KEY (id_file);


--
-- Name: lb_file_log_lbindex_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_file_log_lbindex
    ADD CONSTRAINT lb_file_log_lbindex_pkey PRIMARY KEY (id_file);


--
-- Name: lb_index_error_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_index_error
    ADD CONSTRAINT lb_index_error_pkey PRIMARY KEY (id_error);


--
-- Name: lb_txt_idx_nm_idx_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_txt_idx
    ADD CONSTRAINT lb_txt_idx_nm_idx_key UNIQUE (nm_idx);


--
-- Name: lb_txt_idx_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY lb_txt_idx
    ADD CONSTRAINT lb_txt_idx_pkey PRIMARY KEY (id_idx);


--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--