* id_api apps_id api_title id_apitype api_desc id_query dependency_variable variable_input variable_output delimeter_col delimeter_row insert_date insert_by update_date update_by delete_date delete_by is_deleted

* id_apiparser apps_id api_title id_apitype api_desc api_url dependency_variable variable_input variable_output delimeter_col delimeter_row insert_date insert_by update_date update_by delete_date delete_by is_deleted

* apps_id apps_title apps_desc ui_themes su_name su_pwd apps_icon apps_background_img apps_splash_screen apps_production_server apps_production_ip apps_production_uname apps_production_pwd apps_production_ppath apps_production_url apps_bucket_server apps_bucket_ip apps_bucket_uname apps_bucket_pwd apps_bucket_ppath apps_bucket_url insert_date insert_by update_date update_by delete_date delete_by is_deleted table_prefix company_id jasper_url jasper_user jasper_password

* id_app_ui apps_id ui_title ui_url insert_date insert_by update_date update_by delete_date delete_by is_deleted

* appvar_id apps_id apps_token apps_title apps_ui apps_icon apps_bgimages apps_server_ppath apps_server_url apps_bucket_ppath apps_bucket_url transaction_upload_ppath transaction_upload_url allowed_ext max_file_size upload_file_format table_prefix insert_date insert_by udpate_date update_by delete_date delete_by is_deleted

* id apps_id user_id

* id apps_id user_id

* id_page apps_id id_pagetype page_title no_section menu_id insert_date insert_by update_date update_by delete_date delete_by is_deleted index_flag

* id_pagedetail id_page section_no id_component id_tbl_component col_position width1_12 insert_date insert_by update_date update_by delete_date delete_by is_deleted

* id apps_id user_id

* chart_catalog_id id_chart chart_title apps_id description id_query chart_config insert_date insert_by update_date update_by delete_date delete_by is_deleted field_label field_data

* id_custom_component custom_title custom_content insert_date insert_by update_date update_by delete_date delete_by is_deleted apps_id api_url

* id_ref_auth_group id_data group_id crud_type insert_date insert_by update_date update_by delete_date delete_by is_deleted

* id_numbering module_name prefix prefix_separator company_info id_query_company query_syntax_company dependency_field_company branch_info id_query_branch query_syntax_branch dependency_field_branch yr_info yr_info_separator period_info period_info_separator date_source_type date_source_field insert_date insert_by update_date update_by delete_date delete_by is_deleted apps_id padding company_info_separator branch_info_separator prefix_config

* id_numbering_detail id_numbering prefix last_number insert_date insert_by update_date update_by delete_date delete_by is_deleted

* id_data apps_id data_title data_description dependency_id id_query search_col sort_col show_col show_caption new_col_caption new_trigger_query id_form_new edit_col_caption edit_trigger_query id_form_edit view_col_caption id_form_view v_additional_button_1 v_button_1_condition v_additional_button_2 v_button_2_condition v_additional_button_3 v_button_3_condition insert_date insert_by update_date update_by delete_date delete_by is_deleted new_form_title edit_form_title view_form_title two_column_flag

* id_data_child id_data apps_id data_title data_description dependency_id id_query search_col sort_col show_col show_caption new_col_caption new_trigger_query id_form_new edit_col_caption edit_trigger_query id_form_edit view_col_caption id_form_view v_additional_button_1 v_button_1_condition v_additional_button_2 v_button_2_condition v_additional_button_3 v_button_3_condition insert_date insert_by update_date update_by delete_date delete_by is_deleted new_form_title edit_form_title view_form_title two_column_flag dependency_value

* id_data_wf id_data wf_id stage_name stage_desc button_stage_caption label_color_data id_status order_no id_data_wf_parent insert_date insert_by update_date update_by delete_date delete_by is_deleted condition_type id_query_condition query_syntax_condition variable_query_output

* id_data_wf_condition id_data_wf param_type_1 param_value_1 id_group_condition insert_date insert_by update_date update_by delete_date delete_by is_deleted param_type_2 param_value_2

* id_data_wf_log id_data_wf id_data wf_id table_field table_value stage_name stage_desc order_no condition_type group_id user_id insert_date insert_by update_date update_by delete_date delete_by is_deleted action_type

* id_data_wf_detail id_data_wf group_id insert_date insert_by update_date update_by delete_date delete_by is_deleted

* id_dbcon apps_id id_dbtype db_name server_name ip_addr port_no user_name pwd audit_trail_table_name insert_date insert_by update_date update_by delete_date delete_by is_deleted

* table_id db_name table_name insert_date insert_by update_date update_by delete_date delete_by is_deleted

* field_id table_id field_value insert_date insert_by update_date update_by delete_date delete_by is_deleted

* id_form apps_id form_title form_desc form_size_cols variable_input variable_caption variable_validation form_action_url insert_date insert_by update_date update_by delete_date delete_by is_deleted id_api form_config field_used

* id_formdetail id_form col field_name field_caption dependency_field query_list field_type field_size id_validation insert_date insert_by update_date update_by delete_date delete_by is_deleted id_form_group row mandatory_flag col_size field_properties

* id_form_group id_form group_title group_desc row_pos col_pos size insert_date insert_by update_date update_by delete_date delete_by is_deleted

* group_id apps_id group_name notes insert_date insert_by update_date update_by delete_date delete_by is_deleted

* group_auth_id group_id auth_id insert_date insert_by update_date update_by delete_date delete_by is_deleted

* group_user_id group_id user_id insert_date insert_by update_date update_by delete_date delete_by is_deleted

* id_login apps_id login_title id_logintype is_captcha insert_date insert_by update_date update_by delete_date delete_by is_deleted

* id_company company_code company_name insert_date insert_by update_date update_by delete_date delete_by is_deleted

* id employee_code employee_name position company_code employee_parent_code email

* id kabupaten_kode kabupaten_nama propinsi_kode insert_date insert_by update_date update_by deleted_date delete_by is_deleted

* id kecamatan_kode kecamatan_nama kabupaten_kode insert_date insert_by update_date update_by deleted_date delete_by is_deleted

* id kelurahan_kode kelurahan_nama kecamatan_kode kodepos insert_date insert_by update_date update_by deleted_date delete_by is_deleted

* id employee_code employee_name email join_date grade employee_level position_id position_name job_family lokper lokper_name cost_center_code cost_center_name al_code al_name al_email al_position_id al_position_name aal_code aal_name aal_email aal_position_id aal_position_name insert_date insert_by update_date update_by delete_date delete_by is_deleted

* id propinsi_kode propinsi_nama insert_date insert_by update_date update_by deleted_date delete_by is_deleted

* menu_id apps_id title id_page parent_id class_menu level auth_id order insert_date insert_by update_date update_by delete_date delete_by is_deleted url_external enabled menu_header_id

* menu_header_id apps_id menu_title description insert_date insert_by update_date update_by delete_date delete_by is_deleted

* id_query query_name query_desc query_syntax search_col search_table search_table_join search_condition insert_date insert_by update_date update_by delete_date delete_by is_deleted apps_id id_dbcon main_table_aliases

* user_id user_name pwd pin full_name notes group_id email apps_id insert_date insert_by update_date update_by delete_date delete_by is_deleted

* id_apitype apitype_title apitype_desc insert_date insert_by update_date update_by delete_date delete_by is_deleted

* auth_id apps_id auth_name notes parent_id insert_date insert_by update_date update_by delete_date delete_by is_deleted id_data id_page

* auth_group_id auth_id group_id insert_date insert_by update_date update_by delete_date delete_by is_deleted

* id_chart chart_title chart_description dependency_id chart_code_url insert_date insert_by update_date update_by delete_date delete_by is_deleted

* id_component component_title component_desc table_component component_url insert_date insert_by update_date update_by delete_date delete_by is_deleted

* id_dbtype db_engine description insert_date insert_by update_date update_by delete_date delete_by is_deleted

* id_form_component form_comp_title form_comp_desc form_comp_code insert_date insert_by update_date update_by delete_date delete_by is_deleted

* language_id charset display_name image

* id_word apps_id lang_id lang_en insert_date insert_by update_date update_by delete_date delete_by is_deleted

* id_logintype logtype_title logtype_desc insert_date insert_by update_date update_by delete_date delete_by is_deleted

* id_pagetype page_title page_desc page_icon page_template_url insert_date insert_by update_date update_by delete_date delete_by is_deleted

* id_status status_name status_desc insert_date insert_by update_date update_by delete_date delete_by is_deleted id_data

* user_id user_name pwd pin full_name notes group_id email apps_id insert_date insert_by update_date update_by delete_date delete_by is_deleted

* id_validation validation_name validation_desc validation_script insert_date insert_by update_date update_by delete_date delete_by is_deleted

* id_report apps_id report_title report_description dependency_id id_query search_col show_col show_caption insert_date insert_by update_date update_by delete_date delete_by is_deleted sort_col

* wf_id wf_name wf_desc insert_date insert_by update_date update_by delete_date delete_by is_deleted

select table psi_api_catalog psi_api_parser psi_application psi_application_ui psi_application_variable psi_app_configurator psi_app_dba psi_app_page psi_app_page_detail psi_app_reviewer psi_chart_catalog psi_custom_component psi_datatables_group psi_data_numbering psi_data_numbering_detail psi_data_tables psi_data_tables_child psi_data_tables_wf psi_data_tables_wf_condition psi_data_tables_wf_log psi_data_wf_detail psi_db_catalog psi_db_table psi_db_table_field psi_form_catalog psi_form_catalog_detail psi_form_catalog_group psi_group psi_groupauthorization psi_group_user psi_login_setting psi_master_companies psi_master_employees psi_master_kabupaten psi_master_kecamatan psi_master_kelurahan psi_master_new_employees psi_master_propinsi psi_menu psi_menu_header psi_query_catalog psi_ref_admin psi_ref_apitype psi_ref_authorization psi_ref_authorization_group psi_ref_chart_component psi_ref_component psi_ref_dbtype psi_ref_form_component psi_ref_language psi_ref_language_dictionary psi_ref_logintype psi_ref_pagetype psi_ref_status psi_ref_user psi_ref_validationform psi_report_catalog psi_workflowtype . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table psi_api_catalog psi_api_parser psi_application psi_application_ui psi_application_variable psi_app_configurator psi_app_dba psi_app_page psi_app_page_detail psi_app_reviewer psi_chart_catalog psi_custom_component psi_datatables_group psi_data_numbering psi_data_numbering_detail psi_data_tables psi_data_tables_child psi_data_tables_wf psi_data_tables_wf_condition psi_data_tables_wf_log psi_data_wf_detail psi_db_catalog psi_db_table psi_db_table_field psi_form_catalog psi_form_catalog_detail psi_form_catalog_group psi_group psi_groupauthorization psi_group_user psi_login_setting psi_master_companies psi_master_employees psi_master_kabupaten psi_master_kecamatan psi_master_kelurahan psi_master_new_employees psi_master_propinsi psi_menu psi_menu_header psi_query_catalog psi_ref_admin psi_ref_apitype psi_ref_authorization psi_ref_authorization_group psi_ref_chart_component psi_ref_component psi_ref_dbtype psi_ref_form_component psi_ref_language psi_ref_language_dictionary psi_ref_logintype psi_ref_pagetype psi_ref_status psi_ref_user psi_ref_validationform psi_report_catalog psi_workflowtype .	select column