-- -- 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: 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__app_config_id_doc_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE lb_doc__app_config_id_doc_seq OWNED BY lb_doc__app_config.id_doc; -- -- Name: lb_doc__form; Type: TABLE; Schema: public; Owner: lbu; 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 lbu; -- -- Name: lb_doc__form_id_doc_seq; Type: SEQUENCE; Schema: public; Owner: lbu -- 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 lbu; -- -- 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__history_id_doc_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE lb_doc__history_id_doc_seq OWNED BY lb_doc__history.id_doc; -- -- 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__portal_id_doc_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE lb_doc__portal_id_doc_seq OWNED BY lb_doc__portal.id_doc; -- -- Name: lb_doc__report; Type: TABLE; Schema: public; Owner: lbu; 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 lbu; -- -- Name: lb_doc__report_id_doc_seq; Type: SEQUENCE; Schema: public; Owner: lbu -- 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 lbu; -- -- 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__user_id_doc_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE lb_doc__user_id_doc_seq OWNED BY lb_doc__user.id_doc; -- -- Name: lb_doc_app_user; Type: TABLE; Schema: public; Owner: lbu; 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 lbu; -- -- Name: lb_doc_app_user_id_doc_seq; Type: SEQUENCE; Schema: public; Owner: lbu -- 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 lbu; -- -- 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_lbconverter_id_doc_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE lb_doc_log_lbconverter_id_doc_seq OWNED BY lb_doc_log_lbconverter.id_doc; -- -- 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_doc_log_lbindex_id_doc_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE lb_doc_log_lbindex_id_doc_seq OWNED BY lb_doc_log_lbindex.id_doc; -- -- 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: lbu; 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 lbu; -- -- Name: lb_file__history; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE lb_file__history ( 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__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: lbu; 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 lbu; -- -- Name: lb_file__user; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- CREATE TABLE lb_file__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__user OWNER TO postgres; -- -- Name: lb_file_app_user; Type: TABLE; Schema: public; Owner: lbu; 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 lbu; -- -- 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 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_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_id_error_seq; Type: SEQUENCE; Schema: public; Owner: postgres -- CREATE SEQUENCE lb_index_error_id_error_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE lb_index_error_id_error_seq OWNER TO postgres; -- -- Name: lb_index_error_id_error_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres -- ALTER SEQUENCE lb_index_error_id_error_seq OWNED BY lb_index_error.id_error; -- -- Name: lb_index_error_seq; Type: SEQUENCE; Schema: public; Owner: lbu -- 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 lbu; -- -- 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_doc; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY lb_doc__app_config ALTER COLUMN id_doc SET DEFAULT nextval('lb_doc__app_config_id_doc_seq'::regclass); -- -- Name: id_doc; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY lb_doc__history ALTER COLUMN id_doc SET DEFAULT nextval('lb_doc__history_id_doc_seq'::regclass); -- -- Name: id_doc; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY lb_doc__portal ALTER COLUMN id_doc SET DEFAULT nextval('lb_doc__portal_id_doc_seq'::regclass); -- -- Name: id_doc; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY lb_doc__user ALTER COLUMN id_doc SET DEFAULT nextval('lb_doc__user_id_doc_seq'::regclass); -- -- Name: id_doc; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY lb_doc_log_lbconverter ALTER COLUMN id_doc SET DEFAULT nextval('lb_doc_log_lbconverter_id_doc_seq'::regclass); -- -- Name: id_doc; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY lb_doc_log_lbindex ALTER COLUMN id_doc SET DEFAULT nextval('lb_doc_log_lbindex_id_doc_seq'::regclass); -- -- Name: id_error; Type: DEFAULT; Schema: public; Owner: postgres -- ALTER TABLE ONLY lb_index_error ALTER COLUMN id_error SET DEFAULT nextval('lb_index_error_id_error_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: 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; 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": {"idx_exp": false, "description": "Configurações da aplicação", "color": "#000000", "file_ext_time": 0, "dt_base": "01/01/2015 00:00:00", "idx_exp_url": "", "file_ext": false, "password": "12345678", "id_base": 1, "name": "_app_config", "idx_exp_time": 0, "model": {"manuais": [{"inclusao": {"dt_inclusao": "Text", "nr_cpf_user_inclusao": "Text", "nm_user_inclusao": "Text"}, "color": "Text", "manual": "File", "ch_manual": "Text", "nm_manual": "Text", "alteracao": [{"dt_alteracao": "DateTime", "nm_user_alteracao": "Text", "nr_cpf_user_alteracao": "Text"}]}], "nm_aplicacao": "Text", "nm_apelido": "Text"}}} 2015-01-01 00:00:00 f 0 f 0 \N 2 _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": {"idx_exp": false, "description": "LightBase - History Meta Base.", "color": "#000000", "file_ext_time": 10, "idx_exp_time": 0, "idx_exp_url": "", "model": {"status": "Text", "name": "Text", "author": "Text", "id_base": "Integer", "date": "DateTime", "structure": "Json"}, "password": "password", "dt_base": "01/01/2015 00:00:00", "file_ext": false, "id_base": 2, "name": "_history"}} 2015-01-01 00:00:00 f 0 f 10 \N 3 _portal {"content": [{"field": {"name": "nm_portal", "datatype": "Text", "required": true, "alias": "Nome do Portal", "multivalued": false, "indices": ["Textual", "Ordenado"], "description": "Contm 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 amigvel."}}, {"field": {"name": "ds_portal", "datatype": "Text", "required": true, "alias": "Descriço", "multivalued": false, "indices": ["Textual"], "description": "Contm um texto falando sobre o portal. Qual a finalidade do portal criado."}}, {"field": {"name": "cpf_user", "datatype": "Text", "required": false, "alias": "CPF do Usurio", "multivalued": false, "indices": ["Textual", "Ordenado"], "description": "Indica o cpf do usurio que criou o portal. Auxilia a listar os portais de cada usurio"}}, {"group": {"content": [{"field": {"name": "nm_base", "datatype": "Text", "required": true, "alias": "Nome da Base", "multivalued": false, "indices": ["Textual"], "description": "Contm 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 amigvel 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 pgina de detalhes. O valor oriundo da aplicaço em questo, ou seja, de acordo a aplicaço referenciada o nome da pgina 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 pgina 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": "Contm 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": "Contm 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": "Contm 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": "Contm 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": "Contm 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": "Contm 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": "Contm 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": "Contm uma flag informando se o campo fixo na tela de pesquisa avançada. Nesta tela os campo so 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": "Contm um script para ser executado na pgina nome momento em que o campo exibido."}}], "metadata": {"multivalued": false, "alias": "Informaçes pesquisa avançada", "name": "inf_advanced_search", "description": "Contm 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": "Contm 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": "Contm 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": "Contm 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": "Contm uma flag informando se o campo usado na pesquisa. Essa informaço relevante para a pesquisa direta, que realiza a busca nos campos que contm 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": "Contm um script que ser executado na exibiço do campo na tabela de resultado de pesquisa. til para criar botes, links, etc."}}, {"field": {"name": "in_sortable_listed", "datatype": "Boolean", "required": false, "alias": "Ordenar?", "multivalued": false, "indices": ["Textual"], "description": "Indica se a coluna ordenvel na tabela do resultado de pesquisa."}}], "metadata": {"multivalued": false, "alias": "Informaçes resultado de pesquisa", "name": "inf_listed_search", "description": "Contm 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": "contm 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": "Contm uma flag dizendo se o campo exibido ou no tela de detalhes."}}, {"field": {"name": "in_search_detailed", "datatype": "Boolean", "required": false, "alias": "Pesquisar?", "multivalued": false, "indices": ["Textual"], "description": "Contm uma flag informando se o campo pesquisado para chamar a pgina de detalhes."}}, {"field": {"name": "nr_position_detailed", "datatype": "Integer", "required": false, "alias": "Posiço", "multivalued": false, "indices": ["Textual"], "description": "Contm 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": "Contm um script que deve ser executado na exibiço do campo na pgina de detalhes. Por exemplo, criar um link dentro campo."}}], "metadata": {"multivalued": false, "alias": "Informaçes da tela de detalhes", "name": "inf_detailed_search", "description": "Contm 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": "Contm uma lista de objetos json. Serve para criar uma tabela esttica 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": "Contm o nome do campo da base referenciada que contm o valor."}}, {"field": {"name": "nm_field_key_tabulated", "datatype": "Text", "required": false, "alias": "Nome Campo Chave", "multivalued": false, "indices": ["Textual"], "description": "Contm o nome do campo da base referenciada que contm a chave do valor."}}, {"field": {"name": "relational_key_tabulated", "datatype": "Text", "required": false, "alias": "Chave relacional", "multivalued": false, "indices": ["Textual"], "description": "Contm o nome da coluna que contm 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": "Contm 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 amigvel 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 sero usados pelo portal."}}}], "metadata": {"multivalued": true, "alias": "Bases do Portal", "name": "bases", "description": "Contm as Bases do portal."}}}], "metadata": {"idx_exp": false, "description": "Novo conceito do portal. Uma base _portal lista todos os portais separados por nome e com o id do usu-ario que criou.", "color": "", "file_ext_time": 0, "dt_base": "01/01/2015 00:00:00", "idx_exp_url": "", "file_ext": false, "password": "BRLight@)!$", "id_base": 3, "name": "_portal", "idx_exp_time": 0, "model": {"alias_portal": "Text", "cpf_user": "Text", "bases": [{"url_index": "Url", "nm_base": "Text", "field": [{"inf_advanced_search": {"in_fixed_advanced": "Boolean", "in_display_advanced": "Boolean", "nm_type_control_advanced": "Text", "nm_display_advanced": "Text", "script_advanced": "TextArea"}, "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"}, "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_direct_search": {"nr_position_direct": "Integer", "nm_display_direct": "Text", "script_direct": "TextArea", "nm_type_control_direct": "Text", "in_display_direct": "Boolean"}, "groups_can_view": ["Text"], "ds_field": "Text", "nm_type_field": "Text", "nm_field": "Text", "inf_detailed_search": {"nm_display_detailed": "Text", "in_search_detailed": "Boolean", "in_display_detailed": "Boolean", "script_detailed": "TextArea", "nr_position_detailed": "Integer"}}], "url_detail": "Url", "url_app": "Url", "nr_order": "Integer", "ds_base": "Text"}], "nm_portal": "Text", "ds_portal": "Text"}}} 2015-01-01 00:00:00 f 0 f 0 \N 4 _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": {"idx_exp": false, "description": "LightBase's Users Meta Base.", "color": "#000000", "file_ext_time": 0, "idx_exp_time": 0, "idx_exp_url": "", "model": {"name_user": "Text", "status_user": "Boolean", "bases_user": [{"name_base": "Text", "access_type": "Text"}], "id_user": "Integer", "creation_date_user": "Date", "email_user": "Text", "passwd_user": "Text"}, "password": "3Ax!vj6gV#DEtR", "dt_base": "01/01/2015 00:00:00", "file_ext": false, "id_base": 4, "name": "_user"}} 2015-01-01 00:00:00 f 0 f 0 \N 5 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", "Unico"], "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": {"idx_exp": false, "description": "LightBase - Log de erros do LBConverter", "color": "#000000", "file_ext_time": 0, "dt_base": "01/01/2015 00:00:00", "idx_exp_url": "", "file_ext": false, "password": "qqqqqqqq", "id_base": 5, "name": "log_lbconverter", "idx_exp_time": 0, "model": {"id_file_orig": "Text", "nm_base": "Text", "file_name": "Text", "id_doc_orig": "Integer", "dt_error": "DateTime", "error_msg": "Text"}}} 2015-01-01 00:00:00 f 0 f 0 \N 6 log_lbindex {"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": "identificador do documento", "multivalued": false, "indices": ["Textual", "Ordenado"], "description": "id do documento que originou o erro."}}, {"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 e Hora no formato DD/MM/AAAA - HH:MM:SS do erro"}}, {"field": {"name": "dt_last_up_orig", "datatype": "DateTime", "required": true, "alias": "dt_last_up_orig", "multivalued": false, "indices": ["Textual", "Ordenado"], "description": "Data e Hora no formato DD/MM/AAAA - HH:MM:SS da última atualização do registro que originou o erro."}}], "metadata": {"idx_exp": false, "description": "LightBase - Log de erros do LBIndex", "color": "#000000", "file_ext_time": 0, "dt_base": "01/01/2015 00:00:00", "idx_exp_url": "", "file_ext": false, "password": "qqqqqqqq", "id_base": 6, "name": "log_lbindex", "idx_exp_time": 0, "model": {"dt_last_up_orig": "DateTime", "id_doc_orig": "Integer", "dt_error": "DateTime", "error_msg": "Text", "nm_base": "Text"}}} 2015-01-01 00:00:00 f 0 f 0 \N 7 _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": {"idx_exp": false, "description": "LightBase's Report Meta Base.", "color": "#000000", "file_ext_time": 0, "dt_base": "24/11/2016 17:30:11", "idx_exp_url": "", "file_ext": false, "password": "3Ax!vj6gV#DEtR", "txt_mapping": "", "id_base": 7, "name": "_report", "idx_exp_time": 0, "model": {"structure": "Json", "description": "Text", "name": "Text", "id_base": "Integer", "author": "Text"}}} 2016-11-24 17:30:11.453657 f 0 f 0 8 _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": {"idx_exp": false, "description": "LightBase's Form Meta Base.", "color": "#000000", "file_ext_time": 0, "dt_base": "24/11/2016 17:30:43", "idx_exp_url": "", "file_ext": false, "password": "3Ax!vj6gV#DEtR", "txt_mapping": "", "id_base": 8, "name": "_form", "idx_exp_time": 0, "model": {"structure": "Json", "description": "Text", "name": "Text", "id_base": "Integer", "author": "Text"}}} 2016-11-24 17:30:43.374583 f 0 f 0 9 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": {"idx_exp": false, "description": "LightBase's Users Meta Base.", "color": "#000000", "file_ext_time": 0, "dt_base": "24/11/2016 17:31:03", "idx_exp_url": "", "file_ext": false, "password": "3Ax!vj6gV#DEtR", "txt_mapping": "", "id_base": 9, "name": "app_user", "idx_exp_time": 0, "model": {"name_user": "Text", "status_user": "Boolean", "shortcuts": [{"type": "Text", "id": "Integer"}], "reports": ["Text"], "forms": ["Integer"], "bases": ["Integer"], "id_user": "Text", "creation_date_user": "Date", "email_user": "Text", "passwd_user": "Text"}}} 2016-11-24 17:31:03.745122 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', 9, 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: lbu -- 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: lbu -- 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: lbu -- 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: lbu -- SELECT pg_catalog.setval('lb_doc__report_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: lbu -- 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: lbu -- 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: lbu -- 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: lbu -- COPY lb_file__report (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: lbu -- 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_id_error_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres -- SELECT pg_catalog.setval('lb_index_error_id_error_seq', 1, false); -- -- Name: lb_index_error_seq; Type: SEQUENCE SET; Schema: public; Owner: lbu -- 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: lbu; 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: lbu; Tablespace: -- ALTER TABLE ONLY lb_doc__report ADD CONSTRAINT lb_doc__report_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: lbu; 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: lbu; 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: lbu; Tablespace: -- ALTER TABLE ONLY lb_file__report ADD CONSTRAINT lb_file__report_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: lbu; 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 --