Recent
`information_schema`.`PARAMETERS`
`mysql`.`user`
`information_schema`.`SESSION_STATUS`
`psi_studio`.`psi_application_variable`
`psi_studio`.`psi_api_parser`
`information_schema`.`ENGINES`
`information_schema`.`PROFILING`
`information_schema`.`OPTIMIZER_TRACE`
`psi_studio`.`psi_data_tables_wf_log`
`information_schema`.`INNODB_METRICS`
Favorites
There are no favorite tables.
New
db
db_jokam
db_pmsa
information_schema
mysql
performance_schema
phpmyadmin
psi_studio
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customize appearance of the navigation panel.
Navigation panel
Show databases navigation as tree
In the navigation panel, replaces the database tree with a selector
Link with main panel
Link with main panel by highlighting the current database or table.
Display logo
Show logo in navigation panel.
Logo link URL
URL where logo in the navigation panel will point to.
Logo link target
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Enable highlighting
Highlight server under the mouse cursor.
Maximum items on first level
The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box
Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables
Maximum number of recently used tables; set 0 to disable.
Favorite tables
Maximum number of favorite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customize the navigation tree.
Navigation tree
Maximum items in branch
The number of items that can be displayed on each page of the navigation tree.
Group items in the tree
Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion
Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree
Whether to show tables under database in the navigation tree
Show views in tree
Whether to show views under database in the navigation tree
Show functions in tree
Whether to show functions under database in the navigation tree
Show procedures in tree
Whether to show procedures under database in the navigation tree
Show events in tree
Whether to show events under database in the navigation tree
Expand single database
Whether to expand single database in the navigation tree automatically.
Servers
Servers display options.
Servers
Display servers selection
Display server choice at the top of the navigation panel.
Display servers as a list
Show server listing as a list instead of a drop down.
Databases
Databases display options.
Databases
Minimum number of databases to display the database filter box
Database tree separator
String that separates databases into different tree levels.
Tables
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: psi_studio
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Tracking
Designer
Central columns
Console
Clear
History
Options
Bookmarks
Debug SQL
Press Ctrl+Enter to execute query
Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse
Expand
Show trace
Hide trace
Count
Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Label:
Target database:
Share this bookmark
OK
Options
Set default
Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme
Collapse
Expand
Requery
Edit
Explain
Profiling
Bookmark
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Switch to
visual builder
Saved bookmarked search:
New bookmark
Column:
`psi_api_catalog`.*
`psi_api_catalog`.`id_api`
`psi_api_catalog`.`apps_id`
`psi_api_catalog`.`api_title`
`psi_api_catalog`.`id_apitype`
`psi_api_catalog`.`api_desc`
`psi_api_catalog`.`id_query`
`psi_api_catalog`.`dependency_variable`
`psi_api_catalog`.`variable_input`
`psi_api_catalog`.`variable_output`
`psi_api_catalog`.`delimeter_col`
`psi_api_catalog`.`delimeter_row`
`psi_api_catalog`.`insert_date`
`psi_api_catalog`.`insert_by`
`psi_api_catalog`.`update_date`
`psi_api_catalog`.`update_by`
`psi_api_catalog`.`delete_date`
`psi_api_catalog`.`delete_by`
`psi_api_catalog`.`is_deleted`
`psi_api_parser`.*
`psi_api_parser`.`id_apiparser`
`psi_api_parser`.`apps_id`
`psi_api_parser`.`api_title`
`psi_api_parser`.`id_apitype`
`psi_api_parser`.`api_desc`
`psi_api_parser`.`api_url`
`psi_api_parser`.`dependency_variable`
`psi_api_parser`.`variable_input`
`psi_api_parser`.`variable_output`
`psi_api_parser`.`delimeter_col`
`psi_api_parser`.`delimeter_row`
`psi_api_parser`.`insert_date`
`psi_api_parser`.`insert_by`
`psi_api_parser`.`update_date`
`psi_api_parser`.`update_by`
`psi_api_parser`.`delete_date`
`psi_api_parser`.`delete_by`
`psi_api_parser`.`is_deleted`
`psi_app_configurator`.*
`psi_app_configurator`.`id`
`psi_app_configurator`.`apps_id`
`psi_app_configurator`.`user_id`
`psi_app_dba`.*
`psi_app_dba`.`id`
`psi_app_dba`.`apps_id`
`psi_app_dba`.`user_id`
`psi_app_page`.*
`psi_app_page`.`id_page`
`psi_app_page`.`apps_id`
`psi_app_page`.`id_pagetype`
`psi_app_page`.`page_title`
`psi_app_page`.`no_section`
`psi_app_page`.`menu_id`
`psi_app_page`.`insert_date`
`psi_app_page`.`insert_by`
`psi_app_page`.`update_date`
`psi_app_page`.`update_by`
`psi_app_page`.`delete_date`
`psi_app_page`.`delete_by`
`psi_app_page`.`is_deleted`
`psi_app_page`.`index_flag`
`psi_app_page_detail`.*
`psi_app_page_detail`.`id_pagedetail`
`psi_app_page_detail`.`id_page`
`psi_app_page_detail`.`section_no`
`psi_app_page_detail`.`id_component`
`psi_app_page_detail`.`id_tbl_component`
`psi_app_page_detail`.`col_position`
`psi_app_page_detail`.`width1_12`
`psi_app_page_detail`.`insert_date`
`psi_app_page_detail`.`insert_by`
`psi_app_page_detail`.`update_date`
`psi_app_page_detail`.`update_by`
`psi_app_page_detail`.`delete_date`
`psi_app_page_detail`.`delete_by`
`psi_app_page_detail`.`is_deleted`
`psi_app_reviewer`.*
`psi_app_reviewer`.`id`
`psi_app_reviewer`.`apps_id`
`psi_app_reviewer`.`user_id`
`psi_application`.*
`psi_application`.`apps_id`
`psi_application`.`apps_title`
`psi_application`.`apps_desc`
`psi_application`.`ui_themes`
`psi_application`.`su_name`
`psi_application`.`su_pwd`
`psi_application`.`apps_icon`
`psi_application`.`apps_background_img`
`psi_application`.`apps_splash_screen`
`psi_application`.`apps_production_server`
`psi_application`.`apps_production_ip`
`psi_application`.`apps_production_uname`
`psi_application`.`apps_production_pwd`
`psi_application`.`apps_production_ppath`
`psi_application`.`apps_production_url`
`psi_application`.`apps_bucket_server`
`psi_application`.`apps_bucket_ip`
`psi_application`.`apps_bucket_uname`
`psi_application`.`apps_bucket_pwd`
`psi_application`.`apps_bucket_ppath`
`psi_application`.`apps_bucket_url`
`psi_application`.`insert_date`
`psi_application`.`insert_by`
`psi_application`.`update_date`
`psi_application`.`update_by`
`psi_application`.`delete_date`
`psi_application`.`delete_by`
`psi_application`.`is_deleted`
`psi_application`.`table_prefix`
`psi_application`.`company_id`
`psi_application`.`jasper_url`
`psi_application`.`jasper_user`
`psi_application`.`jasper_password`
`psi_application_ui`.*
`psi_application_ui`.`id_app_ui`
`psi_application_ui`.`apps_id`
`psi_application_ui`.`ui_title`
`psi_application_ui`.`ui_url`
`psi_application_ui`.`insert_date`
`psi_application_ui`.`insert_by`
`psi_application_ui`.`update_date`
`psi_application_ui`.`update_by`
`psi_application_ui`.`delete_date`
`psi_application_ui`.`delete_by`
`psi_application_ui`.`is_deleted`
`psi_application_variable`.*
`psi_application_variable`.`appvar_id`
`psi_application_variable`.`apps_id`
`psi_application_variable`.`apps_token`
`psi_application_variable`.`apps_title`
`psi_application_variable`.`apps_ui`
`psi_application_variable`.`apps_icon`
`psi_application_variable`.`apps_bgimages`
`psi_application_variable`.`apps_server_ppath`
`psi_application_variable`.`apps_server_url`
`psi_application_variable`.`apps_bucket_ppath`
`psi_application_variable`.`apps_bucket_url`
`psi_application_variable`.`transaction_upload_ppath`
`psi_application_variable`.`transaction_upload_url`
`psi_application_variable`.`allowed_ext`
`psi_application_variable`.`max_file_size`
`psi_application_variable`.`upload_file_format`
`psi_application_variable`.`table_prefix`
`psi_application_variable`.`insert_date`
`psi_application_variable`.`insert_by`
`psi_application_variable`.`udpate_date`
`psi_application_variable`.`update_by`
`psi_application_variable`.`delete_date`
`psi_application_variable`.`delete_by`
`psi_application_variable`.`is_deleted`
`psi_chart_catalog`.*
`psi_chart_catalog`.`chart_catalog_id`
`psi_chart_catalog`.`id_chart`
`psi_chart_catalog`.`chart_title`
`psi_chart_catalog`.`apps_id`
`psi_chart_catalog`.`description`
`psi_chart_catalog`.`id_query`
`psi_chart_catalog`.`chart_config`
`psi_chart_catalog`.`insert_date`
`psi_chart_catalog`.`insert_by`
`psi_chart_catalog`.`update_date`
`psi_chart_catalog`.`update_by`
`psi_chart_catalog`.`delete_date`
`psi_chart_catalog`.`delete_by`
`psi_chart_catalog`.`is_deleted`
`psi_chart_catalog`.`field_label`
`psi_chart_catalog`.`field_data`
`psi_custom_component`.*
`psi_custom_component`.`id_custom_component`
`psi_custom_component`.`custom_title`
`psi_custom_component`.`custom_content`
`psi_custom_component`.`insert_date`
`psi_custom_component`.`insert_by`
`psi_custom_component`.`update_date`
`psi_custom_component`.`update_by`
`psi_custom_component`.`delete_date`
`psi_custom_component`.`delete_by`
`psi_custom_component`.`is_deleted`
`psi_custom_component`.`apps_id`
`psi_custom_component`.`api_url`
`psi_data_numbering`.*
`psi_data_numbering`.`id_numbering`
`psi_data_numbering`.`module_name`
`psi_data_numbering`.`prefix`
`psi_data_numbering`.`prefix_separator`
`psi_data_numbering`.`company_info`
`psi_data_numbering`.`id_query_company`
`psi_data_numbering`.`query_syntax_company`
`psi_data_numbering`.`dependency_field_company`
`psi_data_numbering`.`branch_info`
`psi_data_numbering`.`id_query_branch`
`psi_data_numbering`.`query_syntax_branch`
`psi_data_numbering`.`dependency_field_branch`
`psi_data_numbering`.`yr_info`
`psi_data_numbering`.`yr_info_separator`
`psi_data_numbering`.`period_info`
`psi_data_numbering`.`period_info_separator`
`psi_data_numbering`.`date_source_type`
`psi_data_numbering`.`date_source_field`
`psi_data_numbering`.`insert_date`
`psi_data_numbering`.`insert_by`
`psi_data_numbering`.`update_date`
`psi_data_numbering`.`update_by`
`psi_data_numbering`.`delete_date`
`psi_data_numbering`.`delete_by`
`psi_data_numbering`.`is_deleted`
`psi_data_numbering`.`apps_id`
`psi_data_numbering`.`padding`
`psi_data_numbering`.`company_info_separator`
`psi_data_numbering`.`branch_info_separator`
`psi_data_numbering`.`prefix_config`
`psi_data_numbering_detail`.*
`psi_data_numbering_detail`.`id_numbering_detail`
`psi_data_numbering_detail`.`id_numbering`
`psi_data_numbering_detail`.`prefix`
`psi_data_numbering_detail`.`last_number`
`psi_data_numbering_detail`.`insert_date`
`psi_data_numbering_detail`.`insert_by`
`psi_data_numbering_detail`.`update_date`
`psi_data_numbering_detail`.`update_by`
`psi_data_numbering_detail`.`delete_date`
`psi_data_numbering_detail`.`delete_by`
`psi_data_numbering_detail`.`is_deleted`
`psi_data_tables`.*
`psi_data_tables`.`id_data`
`psi_data_tables`.`apps_id`
`psi_data_tables`.`data_title`
`psi_data_tables`.`data_description`
`psi_data_tables`.`dependency_id`
`psi_data_tables`.`id_query`
`psi_data_tables`.`search_col`
`psi_data_tables`.`sort_col`
`psi_data_tables`.`show_col`
`psi_data_tables`.`show_caption`
`psi_data_tables`.`new_col_caption`
`psi_data_tables`.`new_trigger_query`
`psi_data_tables`.`id_form_new`
`psi_data_tables`.`edit_col_caption`
`psi_data_tables`.`edit_trigger_query`
`psi_data_tables`.`id_form_edit`
`psi_data_tables`.`view_col_caption`
`psi_data_tables`.`id_form_view`
`psi_data_tables`.`v_additional_button_1`
`psi_data_tables`.`v_button_1_condition`
`psi_data_tables`.`v_additional_button_2`
`psi_data_tables`.`v_button_2_condition`
`psi_data_tables`.`v_additional_button_3`
`psi_data_tables`.`v_button_3_condition`
`psi_data_tables`.`insert_date`
`psi_data_tables`.`insert_by`
`psi_data_tables`.`update_date`
`psi_data_tables`.`update_by`
`psi_data_tables`.`delete_date`
`psi_data_tables`.`delete_by`
`psi_data_tables`.`is_deleted`
`psi_data_tables`.`new_form_title`
`psi_data_tables`.`edit_form_title`
`psi_data_tables`.`view_form_title`
`psi_data_tables`.`two_column_flag`
`psi_data_tables_child`.*
`psi_data_tables_child`.`id_data_child`
`psi_data_tables_child`.`id_data`
`psi_data_tables_child`.`apps_id`
`psi_data_tables_child`.`data_title`
`psi_data_tables_child`.`data_description`
`psi_data_tables_child`.`dependency_id`
`psi_data_tables_child`.`id_query`
`psi_data_tables_child`.`search_col`
`psi_data_tables_child`.`sort_col`
`psi_data_tables_child`.`show_col`
`psi_data_tables_child`.`show_caption`
`psi_data_tables_child`.`new_col_caption`
`psi_data_tables_child`.`new_trigger_query`
`psi_data_tables_child`.`id_form_new`
`psi_data_tables_child`.`edit_col_caption`
`psi_data_tables_child`.`edit_trigger_query`
`psi_data_tables_child`.`id_form_edit`
`psi_data_tables_child`.`view_col_caption`
`psi_data_tables_child`.`id_form_view`
`psi_data_tables_child`.`v_additional_button_1`
`psi_data_tables_child`.`v_button_1_condition`
`psi_data_tables_child`.`v_additional_button_2`
`psi_data_tables_child`.`v_button_2_condition`
`psi_data_tables_child`.`v_additional_button_3`
`psi_data_tables_child`.`v_button_3_condition`
`psi_data_tables_child`.`insert_date`
`psi_data_tables_child`.`insert_by`
`psi_data_tables_child`.`update_date`
`psi_data_tables_child`.`update_by`
`psi_data_tables_child`.`delete_date`
`psi_data_tables_child`.`delete_by`
`psi_data_tables_child`.`is_deleted`
`psi_data_tables_child`.`new_form_title`
`psi_data_tables_child`.`edit_form_title`
`psi_data_tables_child`.`view_form_title`
`psi_data_tables_child`.`two_column_flag`
`psi_data_tables_child`.`dependency_value`
`psi_data_tables_wf`.*
`psi_data_tables_wf`.`id_data_wf`
`psi_data_tables_wf`.`id_data`
`psi_data_tables_wf`.`wf_id`
`psi_data_tables_wf`.`stage_name`
`psi_data_tables_wf`.`stage_desc`
`psi_data_tables_wf`.`button_stage_caption`
`psi_data_tables_wf`.`label_color_data`
`psi_data_tables_wf`.`id_status`
`psi_data_tables_wf`.`order_no`
`psi_data_tables_wf`.`id_data_wf_parent`
`psi_data_tables_wf`.`insert_date`
`psi_data_tables_wf`.`insert_by`
`psi_data_tables_wf`.`update_date`
`psi_data_tables_wf`.`update_by`
`psi_data_tables_wf`.`delete_date`
`psi_data_tables_wf`.`delete_by`
`psi_data_tables_wf`.`is_deleted`
`psi_data_tables_wf`.`condition_type`
`psi_data_tables_wf`.`id_query_condition`
`psi_data_tables_wf`.`query_syntax_condition`
`psi_data_tables_wf`.`variable_query_output`
`psi_data_tables_wf_condition`.*
`psi_data_tables_wf_condition`.`id_data_wf_condition`
`psi_data_tables_wf_condition`.`id_data_wf`
`psi_data_tables_wf_condition`.`param_type_1`
`psi_data_tables_wf_condition`.`param_value_1`
`psi_data_tables_wf_condition`.`id_group_condition`
`psi_data_tables_wf_condition`.`insert_date`
`psi_data_tables_wf_condition`.`insert_by`
`psi_data_tables_wf_condition`.`update_date`
`psi_data_tables_wf_condition`.`update_by`
`psi_data_tables_wf_condition`.`delete_date`
`psi_data_tables_wf_condition`.`delete_by`
`psi_data_tables_wf_condition`.`is_deleted`
`psi_data_tables_wf_condition`.`param_type_2`
`psi_data_tables_wf_condition`.`param_value_2`
`psi_data_tables_wf_log`.*
`psi_data_tables_wf_log`.`id_data_wf_log`
`psi_data_tables_wf_log`.`id_data_wf`
`psi_data_tables_wf_log`.`id_data`
`psi_data_tables_wf_log`.`wf_id`
`psi_data_tables_wf_log`.`table_field`
`psi_data_tables_wf_log`.`table_value`
`psi_data_tables_wf_log`.`stage_name`
`psi_data_tables_wf_log`.`stage_desc`
`psi_data_tables_wf_log`.`order_no`
`psi_data_tables_wf_log`.`condition_type`
`psi_data_tables_wf_log`.`group_id`
`psi_data_tables_wf_log`.`user_id`
`psi_data_tables_wf_log`.`insert_date`
`psi_data_tables_wf_log`.`insert_by`
`psi_data_tables_wf_log`.`update_date`
`psi_data_tables_wf_log`.`update_by`
`psi_data_tables_wf_log`.`delete_date`
`psi_data_tables_wf_log`.`delete_by`
`psi_data_tables_wf_log`.`is_deleted`
`psi_data_tables_wf_log`.`action_type`
`psi_data_wf_detail`.*
`psi_data_wf_detail`.`id_data_wf_detail`
`psi_data_wf_detail`.`id_data_wf`
`psi_data_wf_detail`.`group_id`
`psi_data_wf_detail`.`insert_date`
`psi_data_wf_detail`.`insert_by`
`psi_data_wf_detail`.`update_date`
`psi_data_wf_detail`.`update_by`
`psi_data_wf_detail`.`delete_date`
`psi_data_wf_detail`.`delete_by`
`psi_data_wf_detail`.`is_deleted`
`psi_datatables_group`.*
`psi_datatables_group`.`id_ref_auth_group`
`psi_datatables_group`.`id_data`
`psi_datatables_group`.`group_id`
`psi_datatables_group`.`crud_type`
`psi_datatables_group`.`insert_date`
`psi_datatables_group`.`insert_by`
`psi_datatables_group`.`update_date`
`psi_datatables_group`.`update_by`
`psi_datatables_group`.`delete_date`
`psi_datatables_group`.`delete_by`
`psi_datatables_group`.`is_deleted`
`psi_db_catalog`.*
`psi_db_catalog`.`id_dbcon`
`psi_db_catalog`.`apps_id`
`psi_db_catalog`.`id_dbtype`
`psi_db_catalog`.`db_name`
`psi_db_catalog`.`server_name`
`psi_db_catalog`.`ip_addr`
`psi_db_catalog`.`port_no`
`psi_db_catalog`.`user_name`
`psi_db_catalog`.`pwd`
`psi_db_catalog`.`audit_trail_table_name`
`psi_db_catalog`.`insert_date`
`psi_db_catalog`.`insert_by`
`psi_db_catalog`.`update_date`
`psi_db_catalog`.`update_by`
`psi_db_catalog`.`delete_date`
`psi_db_catalog`.`delete_by`
`psi_db_catalog`.`is_deleted`
`psi_db_table`.*
`psi_db_table`.`table_id`
`psi_db_table`.`db_name`
`psi_db_table`.`table_name`
`psi_db_table`.`insert_date`
`psi_db_table`.`insert_by`
`psi_db_table`.`update_date`
`psi_db_table`.`update_by`
`psi_db_table`.`delete_date`
`psi_db_table`.`delete_by`
`psi_db_table`.`is_deleted`
`psi_db_table_field`.*
`psi_db_table_field`.`field_id`
`psi_db_table_field`.`table_id`
`psi_db_table_field`.`field_value`
`psi_db_table_field`.`insert_date`
`psi_db_table_field`.`insert_by`
`psi_db_table_field`.`update_date`
`psi_db_table_field`.`update_by`
`psi_db_table_field`.`delete_date`
`psi_db_table_field`.`delete_by`
`psi_db_table_field`.`is_deleted`
`psi_form_catalog`.*
`psi_form_catalog`.`id_form`
`psi_form_catalog`.`apps_id`
`psi_form_catalog`.`form_title`
`psi_form_catalog`.`form_desc`
`psi_form_catalog`.`form_size_cols`
`psi_form_catalog`.`variable_input`
`psi_form_catalog`.`variable_caption`
`psi_form_catalog`.`variable_validation`
`psi_form_catalog`.`form_action_url`
`psi_form_catalog`.`insert_date`
`psi_form_catalog`.`insert_by`
`psi_form_catalog`.`update_date`
`psi_form_catalog`.`update_by`
`psi_form_catalog`.`delete_date`
`psi_form_catalog`.`delete_by`
`psi_form_catalog`.`is_deleted`
`psi_form_catalog`.`id_api`
`psi_form_catalog`.`form_config`
`psi_form_catalog`.`field_used`
`psi_form_catalog_detail`.*
`psi_form_catalog_detail`.`id_formdetail`
`psi_form_catalog_detail`.`id_form`
`psi_form_catalog_detail`.`col`
`psi_form_catalog_detail`.`field_name`
`psi_form_catalog_detail`.`field_caption`
`psi_form_catalog_detail`.`dependency_field`
`psi_form_catalog_detail`.`query_list`
`psi_form_catalog_detail`.`field_type`
`psi_form_catalog_detail`.`field_size`
`psi_form_catalog_detail`.`id_validation`
`psi_form_catalog_detail`.`insert_date`
`psi_form_catalog_detail`.`insert_by`
`psi_form_catalog_detail`.`update_date`
`psi_form_catalog_detail`.`update_by`
`psi_form_catalog_detail`.`delete_date`
`psi_form_catalog_detail`.`delete_by`
`psi_form_catalog_detail`.`is_deleted`
`psi_form_catalog_detail`.`id_form_group`
`psi_form_catalog_detail`.`row`
`psi_form_catalog_detail`.`mandatory_flag`
`psi_form_catalog_detail`.`col_size`
`psi_form_catalog_detail`.`field_properties`
`psi_form_catalog_group`.*
`psi_form_catalog_group`.`id_form_group`
`psi_form_catalog_group`.`id_form`
`psi_form_catalog_group`.`group_title`
`psi_form_catalog_group`.`group_desc`
`psi_form_catalog_group`.`row_pos`
`psi_form_catalog_group`.`col_pos`
`psi_form_catalog_group`.`size`
`psi_form_catalog_group`.`insert_date`
`psi_form_catalog_group`.`insert_by`
`psi_form_catalog_group`.`update_date`
`psi_form_catalog_group`.`update_by`
`psi_form_catalog_group`.`delete_date`
`psi_form_catalog_group`.`delete_by`
`psi_form_catalog_group`.`is_deleted`
`psi_group`.*
`psi_group`.`group_id`
`psi_group`.`apps_id`
`psi_group`.`group_name`
`psi_group`.`notes`
`psi_group`.`insert_date`
`psi_group`.`insert_by`
`psi_group`.`update_date`
`psi_group`.`update_by`
`psi_group`.`delete_date`
`psi_group`.`delete_by`
`psi_group`.`is_deleted`
`psi_group_user`.*
`psi_group_user`.`group_user_id`
`psi_group_user`.`group_id`
`psi_group_user`.`user_id`
`psi_group_user`.`insert_date`
`psi_group_user`.`insert_by`
`psi_group_user`.`update_date`
`psi_group_user`.`update_by`
`psi_group_user`.`delete_date`
`psi_group_user`.`delete_by`
`psi_group_user`.`is_deleted`
`psi_groupauthorization`.*
`psi_groupauthorization`.`group_auth_id`
`psi_groupauthorization`.`group_id`
`psi_groupauthorization`.`auth_id`
`psi_groupauthorization`.`insert_date`
`psi_groupauthorization`.`insert_by`
`psi_groupauthorization`.`update_date`
`psi_groupauthorization`.`update_by`
`psi_groupauthorization`.`delete_date`
`psi_groupauthorization`.`delete_by`
`psi_groupauthorization`.`is_deleted`
`psi_login_setting`.*
`psi_login_setting`.`id_login`
`psi_login_setting`.`apps_id`
`psi_login_setting`.`login_title`
`psi_login_setting`.`id_logintype`
`psi_login_setting`.`is_captcha`
`psi_login_setting`.`insert_date`
`psi_login_setting`.`insert_by`
`psi_login_setting`.`update_date`
`psi_login_setting`.`update_by`
`psi_login_setting`.`delete_date`
`psi_login_setting`.`delete_by`
`psi_login_setting`.`is_deleted`
`psi_master_companies`.*
`psi_master_companies`.`id_company`
`psi_master_companies`.`company_code`
`psi_master_companies`.`company_name`
`psi_master_companies`.`insert_date`
`psi_master_companies`.`insert_by`
`psi_master_companies`.`update_date`
`psi_master_companies`.`update_by`
`psi_master_companies`.`delete_date`
`psi_master_companies`.`delete_by`
`psi_master_companies`.`is_deleted`
`psi_master_employees`.*
`psi_master_employees`.`id`
`psi_master_employees`.`employee_code`
`psi_master_employees`.`employee_name`
`psi_master_employees`.`position`
`psi_master_employees`.`company_code`
`psi_master_employees`.`employee_parent_code`
`psi_master_employees`.`email`
`psi_master_kabupaten`.*
`psi_master_kabupaten`.`id`
`psi_master_kabupaten`.`kabupaten_kode`
`psi_master_kabupaten`.`kabupaten_nama`
`psi_master_kabupaten`.`propinsi_kode`
`psi_master_kabupaten`.`insert_date`
`psi_master_kabupaten`.`insert_by`
`psi_master_kabupaten`.`update_date`
`psi_master_kabupaten`.`update_by`
`psi_master_kabupaten`.`deleted_date`
`psi_master_kabupaten`.`delete_by`
`psi_master_kabupaten`.`is_deleted`
`psi_master_kecamatan`.*
`psi_master_kecamatan`.`id`
`psi_master_kecamatan`.`kecamatan_kode`
`psi_master_kecamatan`.`kecamatan_nama`
`psi_master_kecamatan`.`kabupaten_kode`
`psi_master_kecamatan`.`insert_date`
`psi_master_kecamatan`.`insert_by`
`psi_master_kecamatan`.`update_date`
`psi_master_kecamatan`.`update_by`
`psi_master_kecamatan`.`deleted_date`
`psi_master_kecamatan`.`delete_by`
`psi_master_kecamatan`.`is_deleted`
`psi_master_kelurahan`.*
`psi_master_kelurahan`.`id`
`psi_master_kelurahan`.`kelurahan_kode`
`psi_master_kelurahan`.`kelurahan_nama`
`psi_master_kelurahan`.`kecamatan_kode`
`psi_master_kelurahan`.`kodepos`
`psi_master_kelurahan`.`insert_date`
`psi_master_kelurahan`.`insert_by`
`psi_master_kelurahan`.`update_date`
`psi_master_kelurahan`.`update_by`
`psi_master_kelurahan`.`deleted_date`
`psi_master_kelurahan`.`delete_by`
`psi_master_kelurahan`.`is_deleted`
`psi_master_new_employees`.*
`psi_master_new_employees`.`id`
`psi_master_new_employees`.`employee_code`
`psi_master_new_employees`.`employee_name`
`psi_master_new_employees`.`email`
`psi_master_new_employees`.`join_date`
`psi_master_new_employees`.`grade`
`psi_master_new_employees`.`employee_level`
`psi_master_new_employees`.`position_id`
`psi_master_new_employees`.`position_name`
`psi_master_new_employees`.`job_family`
`psi_master_new_employees`.`lokper`
`psi_master_new_employees`.`lokper_name`
`psi_master_new_employees`.`cost_center_code`
`psi_master_new_employees`.`cost_center_name`
`psi_master_new_employees`.`al_code`
`psi_master_new_employees`.`al_name`
`psi_master_new_employees`.`al_email`
`psi_master_new_employees`.`al_position_id`
`psi_master_new_employees`.`al_position_name`
`psi_master_new_employees`.`aal_code`
`psi_master_new_employees`.`aal_name`
`psi_master_new_employees`.`aal_email`
`psi_master_new_employees`.`aal_position_id`
`psi_master_new_employees`.`aal_position_name`
`psi_master_new_employees`.`insert_date`
`psi_master_new_employees`.`insert_by`
`psi_master_new_employees`.`update_date`
`psi_master_new_employees`.`update_by`
`psi_master_new_employees`.`delete_date`
`psi_master_new_employees`.`delete_by`
`psi_master_new_employees`.`is_deleted`
`psi_master_propinsi`.*
`psi_master_propinsi`.`id`
`psi_master_propinsi`.`propinsi_kode`
`psi_master_propinsi`.`propinsi_nama`
`psi_master_propinsi`.`insert_date`
`psi_master_propinsi`.`insert_by`
`psi_master_propinsi`.`update_date`
`psi_master_propinsi`.`update_by`
`psi_master_propinsi`.`deleted_date`
`psi_master_propinsi`.`delete_by`
`psi_master_propinsi`.`is_deleted`
`psi_menu`.*
`psi_menu`.`menu_id`
`psi_menu`.`apps_id`
`psi_menu`.`title`
`psi_menu`.`id_page`
`psi_menu`.`parent_id`
`psi_menu`.`class_menu`
`psi_menu`.`level`
`psi_menu`.`auth_id`
`psi_menu`.`order`
`psi_menu`.`insert_date`
`psi_menu`.`insert_by`
`psi_menu`.`update_date`
`psi_menu`.`update_by`
`psi_menu`.`delete_date`
`psi_menu`.`delete_by`
`psi_menu`.`is_deleted`
`psi_menu`.`url_external`
`psi_menu`.`enabled`
`psi_menu`.`menu_header_id`
`psi_menu_header`.*
`psi_menu_header`.`menu_header_id`
`psi_menu_header`.`apps_id`
`psi_menu_header`.`menu_title`
`psi_menu_header`.`description`
`psi_menu_header`.`insert_date`
`psi_menu_header`.`insert_by`
`psi_menu_header`.`update_date`
`psi_menu_header`.`update_by`
`psi_menu_header`.`delete_date`
`psi_menu_header`.`delete_by`
`psi_menu_header`.`is_deleted`
`psi_query_catalog`.*
`psi_query_catalog`.`id_query`
`psi_query_catalog`.`query_name`
`psi_query_catalog`.`query_desc`
`psi_query_catalog`.`query_syntax`
`psi_query_catalog`.`search_col`
`psi_query_catalog`.`search_table`
`psi_query_catalog`.`search_table_join`
`psi_query_catalog`.`search_condition`
`psi_query_catalog`.`insert_date`
`psi_query_catalog`.`insert_by`
`psi_query_catalog`.`update_date`
`psi_query_catalog`.`update_by`
`psi_query_catalog`.`delete_date`
`psi_query_catalog`.`delete_by`
`psi_query_catalog`.`is_deleted`
`psi_query_catalog`.`apps_id`
`psi_query_catalog`.`id_dbcon`
`psi_query_catalog`.`main_table_aliases`
`psi_ref_admin`.*
`psi_ref_admin`.`user_id`
`psi_ref_admin`.`user_name`
`psi_ref_admin`.`pwd`
`psi_ref_admin`.`pin`
`psi_ref_admin`.`full_name`
`psi_ref_admin`.`notes`
`psi_ref_admin`.`group_id`
`psi_ref_admin`.`email`
`psi_ref_admin`.`apps_id`
`psi_ref_admin`.`insert_date`
`psi_ref_admin`.`insert_by`
`psi_ref_admin`.`update_date`
`psi_ref_admin`.`update_by`
`psi_ref_admin`.`delete_date`
`psi_ref_admin`.`delete_by`
`psi_ref_admin`.`is_deleted`
`psi_ref_apitype`.*
`psi_ref_apitype`.`id_apitype`
`psi_ref_apitype`.`apitype_title`
`psi_ref_apitype`.`apitype_desc`
`psi_ref_apitype`.`insert_date`
`psi_ref_apitype`.`insert_by`
`psi_ref_apitype`.`update_date`
`psi_ref_apitype`.`update_by`
`psi_ref_apitype`.`delete_date`
`psi_ref_apitype`.`delete_by`
`psi_ref_apitype`.`is_deleted`
`psi_ref_authorization`.*
`psi_ref_authorization`.`auth_id`
`psi_ref_authorization`.`apps_id`
`psi_ref_authorization`.`auth_name`
`psi_ref_authorization`.`notes`
`psi_ref_authorization`.`parent_id`
`psi_ref_authorization`.`insert_date`
`psi_ref_authorization`.`insert_by`
`psi_ref_authorization`.`update_date`
`psi_ref_authorization`.`update_by`
`psi_ref_authorization`.`delete_date`
`psi_ref_authorization`.`delete_by`
`psi_ref_authorization`.`is_deleted`
`psi_ref_authorization`.`id_data`
`psi_ref_authorization`.`id_page`
`psi_ref_authorization_group`.*
`psi_ref_authorization_group`.`auth_group_id`
`psi_ref_authorization_group`.`auth_id`
`psi_ref_authorization_group`.`group_id`
`psi_ref_authorization_group`.`insert_date`
`psi_ref_authorization_group`.`insert_by`
`psi_ref_authorization_group`.`update_date`
`psi_ref_authorization_group`.`update_by`
`psi_ref_authorization_group`.`delete_date`
`psi_ref_authorization_group`.`delete_by`
`psi_ref_authorization_group`.`is_deleted`
`psi_ref_chart_component`.*
`psi_ref_chart_component`.`id_chart`
`psi_ref_chart_component`.`chart_title`
`psi_ref_chart_component`.`chart_description`
`psi_ref_chart_component`.`dependency_id`
`psi_ref_chart_component`.`chart_code_url`
`psi_ref_chart_component`.`insert_date`
`psi_ref_chart_component`.`insert_by`
`psi_ref_chart_component`.`update_date`
`psi_ref_chart_component`.`update_by`
`psi_ref_chart_component`.`delete_date`
`psi_ref_chart_component`.`delete_by`
`psi_ref_chart_component`.`is_deleted`
`psi_ref_component`.*
`psi_ref_component`.`id_component`
`psi_ref_component`.`component_title`
`psi_ref_component`.`component_desc`
`psi_ref_component`.`table_component`
`psi_ref_component`.`component_url`
`psi_ref_component`.`insert_date`
`psi_ref_component`.`insert_by`
`psi_ref_component`.`update_date`
`psi_ref_component`.`update_by`
`psi_ref_component`.`delete_date`
`psi_ref_component`.`delete_by`
`psi_ref_component`.`is_deleted`
`psi_ref_dbtype`.*
`psi_ref_dbtype`.`id_dbtype`
`psi_ref_dbtype`.`db_engine`
`psi_ref_dbtype`.`description`
`psi_ref_dbtype`.`insert_date`
`psi_ref_dbtype`.`insert_by`
`psi_ref_dbtype`.`update_date`
`psi_ref_dbtype`.`update_by`
`psi_ref_dbtype`.`delete_date`
`psi_ref_dbtype`.`delete_by`
`psi_ref_dbtype`.`is_deleted`
`psi_ref_form_component`.*
`psi_ref_form_component`.`id_form_component`
`psi_ref_form_component`.`form_comp_title`
`psi_ref_form_component`.`form_comp_desc`
`psi_ref_form_component`.`form_comp_code`
`psi_ref_form_component`.`insert_date`
`psi_ref_form_component`.`insert_by`
`psi_ref_form_component`.`update_date`
`psi_ref_form_component`.`update_by`
`psi_ref_form_component`.`delete_date`
`psi_ref_form_component`.`delete_by`
`psi_ref_form_component`.`is_deleted`
`psi_ref_language`.*
`psi_ref_language`.`language_id`
`psi_ref_language`.`charset`
`psi_ref_language`.`display_name`
`psi_ref_language`.`image`
`psi_ref_language_dictionary`.*
`psi_ref_language_dictionary`.`id_word`
`psi_ref_language_dictionary`.`apps_id`
`psi_ref_language_dictionary`.`lang_id`
`psi_ref_language_dictionary`.`lang_en`
`psi_ref_language_dictionary`.`insert_date`
`psi_ref_language_dictionary`.`insert_by`
`psi_ref_language_dictionary`.`update_date`
`psi_ref_language_dictionary`.`update_by`
`psi_ref_language_dictionary`.`delete_date`
`psi_ref_language_dictionary`.`delete_by`
`psi_ref_language_dictionary`.`is_deleted`
`psi_ref_logintype`.*
`psi_ref_logintype`.`id_logintype`
`psi_ref_logintype`.`logtype_title`
`psi_ref_logintype`.`logtype_desc`
`psi_ref_logintype`.`insert_date`
`psi_ref_logintype`.`insert_by`
`psi_ref_logintype`.`update_date`
`psi_ref_logintype`.`update_by`
`psi_ref_logintype`.`delete_date`
`psi_ref_logintype`.`delete_by`
`psi_ref_logintype`.`is_deleted`
`psi_ref_pagetype`.*
`psi_ref_pagetype`.`id_pagetype`
`psi_ref_pagetype`.`page_title`
`psi_ref_pagetype`.`page_desc`
`psi_ref_pagetype`.`page_icon`
`psi_ref_pagetype`.`page_template_url`
`psi_ref_pagetype`.`insert_date`
`psi_ref_pagetype`.`insert_by`
`psi_ref_pagetype`.`update_date`
`psi_ref_pagetype`.`update_by`
`psi_ref_pagetype`.`delete_date`
`psi_ref_pagetype`.`delete_by`
`psi_ref_pagetype`.`is_deleted`
`psi_ref_status`.*
`psi_ref_status`.`id_status`
`psi_ref_status`.`status_name`
`psi_ref_status`.`status_desc`
`psi_ref_status`.`insert_date`
`psi_ref_status`.`insert_by`
`psi_ref_status`.`update_date`
`psi_ref_status`.`update_by`
`psi_ref_status`.`delete_date`
`psi_ref_status`.`delete_by`
`psi_ref_status`.`is_deleted`
`psi_ref_status`.`id_data`
`psi_ref_user`.*
`psi_ref_user`.`user_id`
`psi_ref_user`.`user_name`
`psi_ref_user`.`pwd`
`psi_ref_user`.`pin`
`psi_ref_user`.`full_name`
`psi_ref_user`.`notes`
`psi_ref_user`.`group_id`
`psi_ref_user`.`email`
`psi_ref_user`.`apps_id`
`psi_ref_user`.`insert_date`
`psi_ref_user`.`insert_by`
`psi_ref_user`.`update_date`
`psi_ref_user`.`update_by`
`psi_ref_user`.`delete_date`
`psi_ref_user`.`delete_by`
`psi_ref_user`.`is_deleted`
`psi_ref_validationform`.*
`psi_ref_validationform`.`id_validation`
`psi_ref_validationform`.`validation_name`
`psi_ref_validationform`.`validation_desc`
`psi_ref_validationform`.`validation_script`
`psi_ref_validationform`.`insert_date`
`psi_ref_validationform`.`insert_by`
`psi_ref_validationform`.`update_date`
`psi_ref_validationform`.`update_by`
`psi_ref_validationform`.`delete_date`
`psi_ref_validationform`.`delete_by`
`psi_ref_validationform`.`is_deleted`
`psi_report_catalog`.*
`psi_report_catalog`.`id_report`
`psi_report_catalog`.`apps_id`
`psi_report_catalog`.`report_title`
`psi_report_catalog`.`report_description`
`psi_report_catalog`.`dependency_id`
`psi_report_catalog`.`id_query`
`psi_report_catalog`.`search_col`
`psi_report_catalog`.`show_col`
`psi_report_catalog`.`show_caption`
`psi_report_catalog`.`insert_date`
`psi_report_catalog`.`insert_by`
`psi_report_catalog`.`update_date`
`psi_report_catalog`.`update_by`
`psi_report_catalog`.`delete_date`
`psi_report_catalog`.`delete_by`
`psi_report_catalog`.`is_deleted`
`psi_report_catalog`.`sort_col`
`psi_workflowtype`.*
`psi_workflowtype`.`wf_id`
`psi_workflowtype`.`wf_name`
`psi_workflowtype`.`wf_desc`
`psi_workflowtype`.`insert_date`
`psi_workflowtype`.`insert_by`
`psi_workflowtype`.`update_date`
`psi_workflowtype`.`update_by`
`psi_workflowtype`.`delete_date`
`psi_workflowtype`.`delete_by`
`psi_workflowtype`.`is_deleted`
`psi_api_catalog`.*
`psi_api_catalog`.`id_api`
`psi_api_catalog`.`apps_id`
`psi_api_catalog`.`api_title`
`psi_api_catalog`.`id_apitype`
`psi_api_catalog`.`api_desc`
`psi_api_catalog`.`id_query`
`psi_api_catalog`.`dependency_variable`
`psi_api_catalog`.`variable_input`
`psi_api_catalog`.`variable_output`
`psi_api_catalog`.`delimeter_col`
`psi_api_catalog`.`delimeter_row`
`psi_api_catalog`.`insert_date`
`psi_api_catalog`.`insert_by`
`psi_api_catalog`.`update_date`
`psi_api_catalog`.`update_by`
`psi_api_catalog`.`delete_date`
`psi_api_catalog`.`delete_by`
`psi_api_catalog`.`is_deleted`
`psi_api_parser`.*
`psi_api_parser`.`id_apiparser`
`psi_api_parser`.`apps_id`
`psi_api_parser`.`api_title`
`psi_api_parser`.`id_apitype`
`psi_api_parser`.`api_desc`
`psi_api_parser`.`api_url`
`psi_api_parser`.`dependency_variable`
`psi_api_parser`.`variable_input`
`psi_api_parser`.`variable_output`
`psi_api_parser`.`delimeter_col`
`psi_api_parser`.`delimeter_row`
`psi_api_parser`.`insert_date`
`psi_api_parser`.`insert_by`
`psi_api_parser`.`update_date`
`psi_api_parser`.`update_by`
`psi_api_parser`.`delete_date`
`psi_api_parser`.`delete_by`
`psi_api_parser`.`is_deleted`
`psi_app_configurator`.*
`psi_app_configurator`.`id`
`psi_app_configurator`.`apps_id`
`psi_app_configurator`.`user_id`
`psi_app_dba`.*
`psi_app_dba`.`id`
`psi_app_dba`.`apps_id`
`psi_app_dba`.`user_id`
`psi_app_page`.*
`psi_app_page`.`id_page`
`psi_app_page`.`apps_id`
`psi_app_page`.`id_pagetype`
`psi_app_page`.`page_title`
`psi_app_page`.`no_section`
`psi_app_page`.`menu_id`
`psi_app_page`.`insert_date`
`psi_app_page`.`insert_by`
`psi_app_page`.`update_date`
`psi_app_page`.`update_by`
`psi_app_page`.`delete_date`
`psi_app_page`.`delete_by`
`psi_app_page`.`is_deleted`
`psi_app_page`.`index_flag`
`psi_app_page_detail`.*
`psi_app_page_detail`.`id_pagedetail`
`psi_app_page_detail`.`id_page`
`psi_app_page_detail`.`section_no`
`psi_app_page_detail`.`id_component`
`psi_app_page_detail`.`id_tbl_component`
`psi_app_page_detail`.`col_position`
`psi_app_page_detail`.`width1_12`
`psi_app_page_detail`.`insert_date`
`psi_app_page_detail`.`insert_by`
`psi_app_page_detail`.`update_date`
`psi_app_page_detail`.`update_by`
`psi_app_page_detail`.`delete_date`
`psi_app_page_detail`.`delete_by`
`psi_app_page_detail`.`is_deleted`
`psi_app_reviewer`.*
`psi_app_reviewer`.`id`
`psi_app_reviewer`.`apps_id`
`psi_app_reviewer`.`user_id`
`psi_application`.*
`psi_application`.`apps_id`
`psi_application`.`apps_title`
`psi_application`.`apps_desc`
`psi_application`.`ui_themes`
`psi_application`.`su_name`
`psi_application`.`su_pwd`
`psi_application`.`apps_icon`
`psi_application`.`apps_background_img`
`psi_application`.`apps_splash_screen`
`psi_application`.`apps_production_server`
`psi_application`.`apps_production_ip`
`psi_application`.`apps_production_uname`
`psi_application`.`apps_production_pwd`
`psi_application`.`apps_production_ppath`
`psi_application`.`apps_production_url`
`psi_application`.`apps_bucket_server`
`psi_application`.`apps_bucket_ip`
`psi_application`.`apps_bucket_uname`
`psi_application`.`apps_bucket_pwd`
`psi_application`.`apps_bucket_ppath`
`psi_application`.`apps_bucket_url`
`psi_application`.`insert_date`
`psi_application`.`insert_by`
`psi_application`.`update_date`
`psi_application`.`update_by`
`psi_application`.`delete_date`
`psi_application`.`delete_by`
`psi_application`.`is_deleted`
`psi_application`.`table_prefix`
`psi_application`.`company_id`
`psi_application`.`jasper_url`
`psi_application`.`jasper_user`
`psi_application`.`jasper_password`
`psi_application_ui`.*
`psi_application_ui`.`id_app_ui`
`psi_application_ui`.`apps_id`
`psi_application_ui`.`ui_title`
`psi_application_ui`.`ui_url`
`psi_application_ui`.`insert_date`
`psi_application_ui`.`insert_by`
`psi_application_ui`.`update_date`
`psi_application_ui`.`update_by`
`psi_application_ui`.`delete_date`
`psi_application_ui`.`delete_by`
`psi_application_ui`.`is_deleted`
`psi_application_variable`.*
`psi_application_variable`.`appvar_id`
`psi_application_variable`.`apps_id`
`psi_application_variable`.`apps_token`
`psi_application_variable`.`apps_title`
`psi_application_variable`.`apps_ui`
`psi_application_variable`.`apps_icon`
`psi_application_variable`.`apps_bgimages`
`psi_application_variable`.`apps_server_ppath`
`psi_application_variable`.`apps_server_url`
`psi_application_variable`.`apps_bucket_ppath`
`psi_application_variable`.`apps_bucket_url`
`psi_application_variable`.`transaction_upload_ppath`
`psi_application_variable`.`transaction_upload_url`
`psi_application_variable`.`allowed_ext`
`psi_application_variable`.`max_file_size`
`psi_application_variable`.`upload_file_format`
`psi_application_variable`.`table_prefix`
`psi_application_variable`.`insert_date`
`psi_application_variable`.`insert_by`
`psi_application_variable`.`udpate_date`
`psi_application_variable`.`update_by`
`psi_application_variable`.`delete_date`
`psi_application_variable`.`delete_by`
`psi_application_variable`.`is_deleted`
`psi_chart_catalog`.*
`psi_chart_catalog`.`chart_catalog_id`
`psi_chart_catalog`.`id_chart`
`psi_chart_catalog`.`chart_title`
`psi_chart_catalog`.`apps_id`
`psi_chart_catalog`.`description`
`psi_chart_catalog`.`id_query`
`psi_chart_catalog`.`chart_config`
`psi_chart_catalog`.`insert_date`
`psi_chart_catalog`.`insert_by`
`psi_chart_catalog`.`update_date`
`psi_chart_catalog`.`update_by`
`psi_chart_catalog`.`delete_date`
`psi_chart_catalog`.`delete_by`
`psi_chart_catalog`.`is_deleted`
`psi_chart_catalog`.`field_label`
`psi_chart_catalog`.`field_data`
`psi_custom_component`.*
`psi_custom_component`.`id_custom_component`
`psi_custom_component`.`custom_title`
`psi_custom_component`.`custom_content`
`psi_custom_component`.`insert_date`
`psi_custom_component`.`insert_by`
`psi_custom_component`.`update_date`
`psi_custom_component`.`update_by`
`psi_custom_component`.`delete_date`
`psi_custom_component`.`delete_by`
`psi_custom_component`.`is_deleted`
`psi_custom_component`.`apps_id`
`psi_custom_component`.`api_url`
`psi_data_numbering`.*
`psi_data_numbering`.`id_numbering`
`psi_data_numbering`.`module_name`
`psi_data_numbering`.`prefix`
`psi_data_numbering`.`prefix_separator`
`psi_data_numbering`.`company_info`
`psi_data_numbering`.`id_query_company`
`psi_data_numbering`.`query_syntax_company`
`psi_data_numbering`.`dependency_field_company`
`psi_data_numbering`.`branch_info`
`psi_data_numbering`.`id_query_branch`
`psi_data_numbering`.`query_syntax_branch`
`psi_data_numbering`.`dependency_field_branch`
`psi_data_numbering`.`yr_info`
`psi_data_numbering`.`yr_info_separator`
`psi_data_numbering`.`period_info`
`psi_data_numbering`.`period_info_separator`
`psi_data_numbering`.`date_source_type`
`psi_data_numbering`.`date_source_field`
`psi_data_numbering`.`insert_date`
`psi_data_numbering`.`insert_by`
`psi_data_numbering`.`update_date`
`psi_data_numbering`.`update_by`
`psi_data_numbering`.`delete_date`
`psi_data_numbering`.`delete_by`
`psi_data_numbering`.`is_deleted`
`psi_data_numbering`.`apps_id`
`psi_data_numbering`.`padding`
`psi_data_numbering`.`company_info_separator`
`psi_data_numbering`.`branch_info_separator`
`psi_data_numbering`.`prefix_config`
`psi_data_numbering_detail`.*
`psi_data_numbering_detail`.`id_numbering_detail`
`psi_data_numbering_detail`.`id_numbering`
`psi_data_numbering_detail`.`prefix`
`psi_data_numbering_detail`.`last_number`
`psi_data_numbering_detail`.`insert_date`
`psi_data_numbering_detail`.`insert_by`
`psi_data_numbering_detail`.`update_date`
`psi_data_numbering_detail`.`update_by`
`psi_data_numbering_detail`.`delete_date`
`psi_data_numbering_detail`.`delete_by`
`psi_data_numbering_detail`.`is_deleted`
`psi_data_tables`.*
`psi_data_tables`.`id_data`
`psi_data_tables`.`apps_id`
`psi_data_tables`.`data_title`
`psi_data_tables`.`data_description`
`psi_data_tables`.`dependency_id`
`psi_data_tables`.`id_query`
`psi_data_tables`.`search_col`
`psi_data_tables`.`sort_col`
`psi_data_tables`.`show_col`
`psi_data_tables`.`show_caption`
`psi_data_tables`.`new_col_caption`
`psi_data_tables`.`new_trigger_query`
`psi_data_tables`.`id_form_new`
`psi_data_tables`.`edit_col_caption`
`psi_data_tables`.`edit_trigger_query`
`psi_data_tables`.`id_form_edit`
`psi_data_tables`.`view_col_caption`
`psi_data_tables`.`id_form_view`
`psi_data_tables`.`v_additional_button_1`
`psi_data_tables`.`v_button_1_condition`
`psi_data_tables`.`v_additional_button_2`
`psi_data_tables`.`v_button_2_condition`
`psi_data_tables`.`v_additional_button_3`
`psi_data_tables`.`v_button_3_condition`
`psi_data_tables`.`insert_date`
`psi_data_tables`.`insert_by`
`psi_data_tables`.`update_date`
`psi_data_tables`.`update_by`
`psi_data_tables`.`delete_date`
`psi_data_tables`.`delete_by`
`psi_data_tables`.`is_deleted`
`psi_data_tables`.`new_form_title`
`psi_data_tables`.`edit_form_title`
`psi_data_tables`.`view_form_title`
`psi_data_tables`.`two_column_flag`
`psi_data_tables_child`.*
`psi_data_tables_child`.`id_data_child`
`psi_data_tables_child`.`id_data`
`psi_data_tables_child`.`apps_id`
`psi_data_tables_child`.`data_title`
`psi_data_tables_child`.`data_description`
`psi_data_tables_child`.`dependency_id`
`psi_data_tables_child`.`id_query`
`psi_data_tables_child`.`search_col`
`psi_data_tables_child`.`sort_col`
`psi_data_tables_child`.`show_col`
`psi_data_tables_child`.`show_caption`
`psi_data_tables_child`.`new_col_caption`
`psi_data_tables_child`.`new_trigger_query`
`psi_data_tables_child`.`id_form_new`
`psi_data_tables_child`.`edit_col_caption`
`psi_data_tables_child`.`edit_trigger_query`
`psi_data_tables_child`.`id_form_edit`
`psi_data_tables_child`.`view_col_caption`
`psi_data_tables_child`.`id_form_view`
`psi_data_tables_child`.`v_additional_button_1`
`psi_data_tables_child`.`v_button_1_condition`
`psi_data_tables_child`.`v_additional_button_2`
`psi_data_tables_child`.`v_button_2_condition`
`psi_data_tables_child`.`v_additional_button_3`
`psi_data_tables_child`.`v_button_3_condition`
`psi_data_tables_child`.`insert_date`
`psi_data_tables_child`.`insert_by`
`psi_data_tables_child`.`update_date`
`psi_data_tables_child`.`update_by`
`psi_data_tables_child`.`delete_date`
`psi_data_tables_child`.`delete_by`
`psi_data_tables_child`.`is_deleted`
`psi_data_tables_child`.`new_form_title`
`psi_data_tables_child`.`edit_form_title`
`psi_data_tables_child`.`view_form_title`
`psi_data_tables_child`.`two_column_flag`
`psi_data_tables_child`.`dependency_value`
`psi_data_tables_wf`.*
`psi_data_tables_wf`.`id_data_wf`
`psi_data_tables_wf`.`id_data`
`psi_data_tables_wf`.`wf_id`
`psi_data_tables_wf`.`stage_name`
`psi_data_tables_wf`.`stage_desc`
`psi_data_tables_wf`.`button_stage_caption`
`psi_data_tables_wf`.`label_color_data`
`psi_data_tables_wf`.`id_status`
`psi_data_tables_wf`.`order_no`
`psi_data_tables_wf`.`id_data_wf_parent`
`psi_data_tables_wf`.`insert_date`
`psi_data_tables_wf`.`insert_by`
`psi_data_tables_wf`.`update_date`
`psi_data_tables_wf`.`update_by`
`psi_data_tables_wf`.`delete_date`
`psi_data_tables_wf`.`delete_by`
`psi_data_tables_wf`.`is_deleted`
`psi_data_tables_wf`.`condition_type`
`psi_data_tables_wf`.`id_query_condition`
`psi_data_tables_wf`.`query_syntax_condition`
`psi_data_tables_wf`.`variable_query_output`
`psi_data_tables_wf_condition`.*
`psi_data_tables_wf_condition`.`id_data_wf_condition`
`psi_data_tables_wf_condition`.`id_data_wf`
`psi_data_tables_wf_condition`.`param_type_1`
`psi_data_tables_wf_condition`.`param_value_1`
`psi_data_tables_wf_condition`.`id_group_condition`
`psi_data_tables_wf_condition`.`insert_date`
`psi_data_tables_wf_condition`.`insert_by`
`psi_data_tables_wf_condition`.`update_date`
`psi_data_tables_wf_condition`.`update_by`
`psi_data_tables_wf_condition`.`delete_date`
`psi_data_tables_wf_condition`.`delete_by`
`psi_data_tables_wf_condition`.`is_deleted`
`psi_data_tables_wf_condition`.`param_type_2`
`psi_data_tables_wf_condition`.`param_value_2`
`psi_data_tables_wf_log`.*
`psi_data_tables_wf_log`.`id_data_wf_log`
`psi_data_tables_wf_log`.`id_data_wf`
`psi_data_tables_wf_log`.`id_data`
`psi_data_tables_wf_log`.`wf_id`
`psi_data_tables_wf_log`.`table_field`
`psi_data_tables_wf_log`.`table_value`
`psi_data_tables_wf_log`.`stage_name`
`psi_data_tables_wf_log`.`stage_desc`
`psi_data_tables_wf_log`.`order_no`
`psi_data_tables_wf_log`.`condition_type`
`psi_data_tables_wf_log`.`group_id`
`psi_data_tables_wf_log`.`user_id`
`psi_data_tables_wf_log`.`insert_date`
`psi_data_tables_wf_log`.`insert_by`
`psi_data_tables_wf_log`.`update_date`
`psi_data_tables_wf_log`.`update_by`
`psi_data_tables_wf_log`.`delete_date`
`psi_data_tables_wf_log`.`delete_by`
`psi_data_tables_wf_log`.`is_deleted`
`psi_data_tables_wf_log`.`action_type`
`psi_data_wf_detail`.*
`psi_data_wf_detail`.`id_data_wf_detail`
`psi_data_wf_detail`.`id_data_wf`
`psi_data_wf_detail`.`group_id`
`psi_data_wf_detail`.`insert_date`
`psi_data_wf_detail`.`insert_by`
`psi_data_wf_detail`.`update_date`
`psi_data_wf_detail`.`update_by`
`psi_data_wf_detail`.`delete_date`
`psi_data_wf_detail`.`delete_by`
`psi_data_wf_detail`.`is_deleted`
`psi_datatables_group`.*
`psi_datatables_group`.`id_ref_auth_group`
`psi_datatables_group`.`id_data`
`psi_datatables_group`.`group_id`
`psi_datatables_group`.`crud_type`
`psi_datatables_group`.`insert_date`
`psi_datatables_group`.`insert_by`
`psi_datatables_group`.`update_date`
`psi_datatables_group`.`update_by`
`psi_datatables_group`.`delete_date`
`psi_datatables_group`.`delete_by`
`psi_datatables_group`.`is_deleted`
`psi_db_catalog`.*
`psi_db_catalog`.`id_dbcon`
`psi_db_catalog`.`apps_id`
`psi_db_catalog`.`id_dbtype`
`psi_db_catalog`.`db_name`
`psi_db_catalog`.`server_name`
`psi_db_catalog`.`ip_addr`
`psi_db_catalog`.`port_no`
`psi_db_catalog`.`user_name`
`psi_db_catalog`.`pwd`
`psi_db_catalog`.`audit_trail_table_name`
`psi_db_catalog`.`insert_date`
`psi_db_catalog`.`insert_by`
`psi_db_catalog`.`update_date`
`psi_db_catalog`.`update_by`
`psi_db_catalog`.`delete_date`
`psi_db_catalog`.`delete_by`
`psi_db_catalog`.`is_deleted`
`psi_db_table`.*
`psi_db_table`.`table_id`
`psi_db_table`.`db_name`
`psi_db_table`.`table_name`
`psi_db_table`.`insert_date`
`psi_db_table`.`insert_by`
`psi_db_table`.`update_date`
`psi_db_table`.`update_by`
`psi_db_table`.`delete_date`
`psi_db_table`.`delete_by`
`psi_db_table`.`is_deleted`
`psi_db_table_field`.*
`psi_db_table_field`.`field_id`
`psi_db_table_field`.`table_id`
`psi_db_table_field`.`field_value`
`psi_db_table_field`.`insert_date`
`psi_db_table_field`.`insert_by`
`psi_db_table_field`.`update_date`
`psi_db_table_field`.`update_by`
`psi_db_table_field`.`delete_date`
`psi_db_table_field`.`delete_by`
`psi_db_table_field`.`is_deleted`
`psi_form_catalog`.*
`psi_form_catalog`.`id_form`
`psi_form_catalog`.`apps_id`
`psi_form_catalog`.`form_title`
`psi_form_catalog`.`form_desc`
`psi_form_catalog`.`form_size_cols`
`psi_form_catalog`.`variable_input`
`psi_form_catalog`.`variable_caption`
`psi_form_catalog`.`variable_validation`
`psi_form_catalog`.`form_action_url`
`psi_form_catalog`.`insert_date`
`psi_form_catalog`.`insert_by`
`psi_form_catalog`.`update_date`
`psi_form_catalog`.`update_by`
`psi_form_catalog`.`delete_date`
`psi_form_catalog`.`delete_by`
`psi_form_catalog`.`is_deleted`
`psi_form_catalog`.`id_api`
`psi_form_catalog`.`form_config`
`psi_form_catalog`.`field_used`
`psi_form_catalog_detail`.*
`psi_form_catalog_detail`.`id_formdetail`
`psi_form_catalog_detail`.`id_form`
`psi_form_catalog_detail`.`col`
`psi_form_catalog_detail`.`field_name`
`psi_form_catalog_detail`.`field_caption`
`psi_form_catalog_detail`.`dependency_field`
`psi_form_catalog_detail`.`query_list`
`psi_form_catalog_detail`.`field_type`
`psi_form_catalog_detail`.`field_size`
`psi_form_catalog_detail`.`id_validation`
`psi_form_catalog_detail`.`insert_date`
`psi_form_catalog_detail`.`insert_by`
`psi_form_catalog_detail`.`update_date`
`psi_form_catalog_detail`.`update_by`
`psi_form_catalog_detail`.`delete_date`
`psi_form_catalog_detail`.`delete_by`
`psi_form_catalog_detail`.`is_deleted`
`psi_form_catalog_detail`.`id_form_group`
`psi_form_catalog_detail`.`row`
`psi_form_catalog_detail`.`mandatory_flag`
`psi_form_catalog_detail`.`col_size`
`psi_form_catalog_detail`.`field_properties`
`psi_form_catalog_group`.*
`psi_form_catalog_group`.`id_form_group`
`psi_form_catalog_group`.`id_form`
`psi_form_catalog_group`.`group_title`
`psi_form_catalog_group`.`group_desc`
`psi_form_catalog_group`.`row_pos`
`psi_form_catalog_group`.`col_pos`
`psi_form_catalog_group`.`size`
`psi_form_catalog_group`.`insert_date`
`psi_form_catalog_group`.`insert_by`
`psi_form_catalog_group`.`update_date`
`psi_form_catalog_group`.`update_by`
`psi_form_catalog_group`.`delete_date`
`psi_form_catalog_group`.`delete_by`
`psi_form_catalog_group`.`is_deleted`
`psi_group`.*
`psi_group`.`group_id`
`psi_group`.`apps_id`
`psi_group`.`group_name`
`psi_group`.`notes`
`psi_group`.`insert_date`
`psi_group`.`insert_by`
`psi_group`.`update_date`
`psi_group`.`update_by`
`psi_group`.`delete_date`
`psi_group`.`delete_by`
`psi_group`.`is_deleted`
`psi_group_user`.*
`psi_group_user`.`group_user_id`
`psi_group_user`.`group_id`
`psi_group_user`.`user_id`
`psi_group_user`.`insert_date`
`psi_group_user`.`insert_by`
`psi_group_user`.`update_date`
`psi_group_user`.`update_by`
`psi_group_user`.`delete_date`
`psi_group_user`.`delete_by`
`psi_group_user`.`is_deleted`
`psi_groupauthorization`.*
`psi_groupauthorization`.`group_auth_id`
`psi_groupauthorization`.`group_id`
`psi_groupauthorization`.`auth_id`
`psi_groupauthorization`.`insert_date`
`psi_groupauthorization`.`insert_by`
`psi_groupauthorization`.`update_date`
`psi_groupauthorization`.`update_by`
`psi_groupauthorization`.`delete_date`
`psi_groupauthorization`.`delete_by`
`psi_groupauthorization`.`is_deleted`
`psi_login_setting`.*
`psi_login_setting`.`id_login`
`psi_login_setting`.`apps_id`
`psi_login_setting`.`login_title`
`psi_login_setting`.`id_logintype`
`psi_login_setting`.`is_captcha`
`psi_login_setting`.`insert_date`
`psi_login_setting`.`insert_by`
`psi_login_setting`.`update_date`
`psi_login_setting`.`update_by`
`psi_login_setting`.`delete_date`
`psi_login_setting`.`delete_by`
`psi_login_setting`.`is_deleted`
`psi_master_companies`.*
`psi_master_companies`.`id_company`
`psi_master_companies`.`company_code`
`psi_master_companies`.`company_name`
`psi_master_companies`.`insert_date`
`psi_master_companies`.`insert_by`
`psi_master_companies`.`update_date`
`psi_master_companies`.`update_by`
`psi_master_companies`.`delete_date`
`psi_master_companies`.`delete_by`
`psi_master_companies`.`is_deleted`
`psi_master_employees`.*
`psi_master_employees`.`id`
`psi_master_employees`.`employee_code`
`psi_master_employees`.`employee_name`
`psi_master_employees`.`position`
`psi_master_employees`.`company_code`
`psi_master_employees`.`employee_parent_code`
`psi_master_employees`.`email`
`psi_master_kabupaten`.*
`psi_master_kabupaten`.`id`
`psi_master_kabupaten`.`kabupaten_kode`
`psi_master_kabupaten`.`kabupaten_nama`
`psi_master_kabupaten`.`propinsi_kode`
`psi_master_kabupaten`.`insert_date`
`psi_master_kabupaten`.`insert_by`
`psi_master_kabupaten`.`update_date`
`psi_master_kabupaten`.`update_by`
`psi_master_kabupaten`.`deleted_date`
`psi_master_kabupaten`.`delete_by`
`psi_master_kabupaten`.`is_deleted`
`psi_master_kecamatan`.*
`psi_master_kecamatan`.`id`
`psi_master_kecamatan`.`kecamatan_kode`
`psi_master_kecamatan`.`kecamatan_nama`
`psi_master_kecamatan`.`kabupaten_kode`
`psi_master_kecamatan`.`insert_date`
`psi_master_kecamatan`.`insert_by`
`psi_master_kecamatan`.`update_date`
`psi_master_kecamatan`.`update_by`
`psi_master_kecamatan`.`deleted_date`
`psi_master_kecamatan`.`delete_by`
`psi_master_kecamatan`.`is_deleted`
`psi_master_kelurahan`.*
`psi_master_kelurahan`.`id`
`psi_master_kelurahan`.`kelurahan_kode`
`psi_master_kelurahan`.`kelurahan_nama`
`psi_master_kelurahan`.`kecamatan_kode`
`psi_master_kelurahan`.`kodepos`
`psi_master_kelurahan`.`insert_date`
`psi_master_kelurahan`.`insert_by`
`psi_master_kelurahan`.`update_date`
`psi_master_kelurahan`.`update_by`
`psi_master_kelurahan`.`deleted_date`
`psi_master_kelurahan`.`delete_by`
`psi_master_kelurahan`.`is_deleted`
`psi_master_new_employees`.*
`psi_master_new_employees`.`id`
`psi_master_new_employees`.`employee_code`
`psi_master_new_employees`.`employee_name`
`psi_master_new_employees`.`email`
`psi_master_new_employees`.`join_date`
`psi_master_new_employees`.`grade`
`psi_master_new_employees`.`employee_level`
`psi_master_new_employees`.`position_id`
`psi_master_new_employees`.`position_name`
`psi_master_new_employees`.`job_family`
`psi_master_new_employees`.`lokper`
`psi_master_new_employees`.`lokper_name`
`psi_master_new_employees`.`cost_center_code`
`psi_master_new_employees`.`cost_center_name`
`psi_master_new_employees`.`al_code`
`psi_master_new_employees`.`al_name`
`psi_master_new_employees`.`al_email`
`psi_master_new_employees`.`al_position_id`
`psi_master_new_employees`.`al_position_name`
`psi_master_new_employees`.`aal_code`
`psi_master_new_employees`.`aal_name`
`psi_master_new_employees`.`aal_email`
`psi_master_new_employees`.`aal_position_id`
`psi_master_new_employees`.`aal_position_name`
`psi_master_new_employees`.`insert_date`
`psi_master_new_employees`.`insert_by`
`psi_master_new_employees`.`update_date`
`psi_master_new_employees`.`update_by`
`psi_master_new_employees`.`delete_date`
`psi_master_new_employees`.`delete_by`
`psi_master_new_employees`.`is_deleted`
`psi_master_propinsi`.*
`psi_master_propinsi`.`id`
`psi_master_propinsi`.`propinsi_kode`
`psi_master_propinsi`.`propinsi_nama`
`psi_master_propinsi`.`insert_date`
`psi_master_propinsi`.`insert_by`
`psi_master_propinsi`.`update_date`
`psi_master_propinsi`.`update_by`
`psi_master_propinsi`.`deleted_date`
`psi_master_propinsi`.`delete_by`
`psi_master_propinsi`.`is_deleted`
`psi_menu`.*
`psi_menu`.`menu_id`
`psi_menu`.`apps_id`
`psi_menu`.`title`
`psi_menu`.`id_page`
`psi_menu`.`parent_id`
`psi_menu`.`class_menu`
`psi_menu`.`level`
`psi_menu`.`auth_id`
`psi_menu`.`order`
`psi_menu`.`insert_date`
`psi_menu`.`insert_by`
`psi_menu`.`update_date`
`psi_menu`.`update_by`
`psi_menu`.`delete_date`
`psi_menu`.`delete_by`
`psi_menu`.`is_deleted`
`psi_menu`.`url_external`
`psi_menu`.`enabled`
`psi_menu`.`menu_header_id`
`psi_menu_header`.*
`psi_menu_header`.`menu_header_id`
`psi_menu_header`.`apps_id`
`psi_menu_header`.`menu_title`
`psi_menu_header`.`description`
`psi_menu_header`.`insert_date`
`psi_menu_header`.`insert_by`
`psi_menu_header`.`update_date`
`psi_menu_header`.`update_by`
`psi_menu_header`.`delete_date`
`psi_menu_header`.`delete_by`
`psi_menu_header`.`is_deleted`
`psi_query_catalog`.*
`psi_query_catalog`.`id_query`
`psi_query_catalog`.`query_name`
`psi_query_catalog`.`query_desc`
`psi_query_catalog`.`query_syntax`
`psi_query_catalog`.`search_col`
`psi_query_catalog`.`search_table`
`psi_query_catalog`.`search_table_join`
`psi_query_catalog`.`search_condition`
`psi_query_catalog`.`insert_date`
`psi_query_catalog`.`insert_by`
`psi_query_catalog`.`update_date`
`psi_query_catalog`.`update_by`
`psi_query_catalog`.`delete_date`
`psi_query_catalog`.`delete_by`
`psi_query_catalog`.`is_deleted`
`psi_query_catalog`.`apps_id`
`psi_query_catalog`.`id_dbcon`
`psi_query_catalog`.`main_table_aliases`
`psi_ref_admin`.*
`psi_ref_admin`.`user_id`
`psi_ref_admin`.`user_name`
`psi_ref_admin`.`pwd`
`psi_ref_admin`.`pin`
`psi_ref_admin`.`full_name`
`psi_ref_admin`.`notes`
`psi_ref_admin`.`group_id`
`psi_ref_admin`.`email`
`psi_ref_admin`.`apps_id`
`psi_ref_admin`.`insert_date`
`psi_ref_admin`.`insert_by`
`psi_ref_admin`.`update_date`
`psi_ref_admin`.`update_by`
`psi_ref_admin`.`delete_date`
`psi_ref_admin`.`delete_by`
`psi_ref_admin`.`is_deleted`
`psi_ref_apitype`.*
`psi_ref_apitype`.`id_apitype`
`psi_ref_apitype`.`apitype_title`
`psi_ref_apitype`.`apitype_desc`
`psi_ref_apitype`.`insert_date`
`psi_ref_apitype`.`insert_by`
`psi_ref_apitype`.`update_date`
`psi_ref_apitype`.`update_by`
`psi_ref_apitype`.`delete_date`
`psi_ref_apitype`.`delete_by`
`psi_ref_apitype`.`is_deleted`
`psi_ref_authorization`.*
`psi_ref_authorization`.`auth_id`
`psi_ref_authorization`.`apps_id`
`psi_ref_authorization`.`auth_name`
`psi_ref_authorization`.`notes`
`psi_ref_authorization`.`parent_id`
`psi_ref_authorization`.`insert_date`
`psi_ref_authorization`.`insert_by`
`psi_ref_authorization`.`update_date`
`psi_ref_authorization`.`update_by`
`psi_ref_authorization`.`delete_date`
`psi_ref_authorization`.`delete_by`
`psi_ref_authorization`.`is_deleted`
`psi_ref_authorization`.`id_data`
`psi_ref_authorization`.`id_page`
`psi_ref_authorization_group`.*
`psi_ref_authorization_group`.`auth_group_id`
`psi_ref_authorization_group`.`auth_id`
`psi_ref_authorization_group`.`group_id`
`psi_ref_authorization_group`.`insert_date`
`psi_ref_authorization_group`.`insert_by`
`psi_ref_authorization_group`.`update_date`
`psi_ref_authorization_group`.`update_by`
`psi_ref_authorization_group`.`delete_date`
`psi_ref_authorization_group`.`delete_by`
`psi_ref_authorization_group`.`is_deleted`
`psi_ref_chart_component`.*
`psi_ref_chart_component`.`id_chart`
`psi_ref_chart_component`.`chart_title`
`psi_ref_chart_component`.`chart_description`
`psi_ref_chart_component`.`dependency_id`
`psi_ref_chart_component`.`chart_code_url`
`psi_ref_chart_component`.`insert_date`
`psi_ref_chart_component`.`insert_by`
`psi_ref_chart_component`.`update_date`
`psi_ref_chart_component`.`update_by`
`psi_ref_chart_component`.`delete_date`
`psi_ref_chart_component`.`delete_by`
`psi_ref_chart_component`.`is_deleted`
`psi_ref_component`.*
`psi_ref_component`.`id_component`
`psi_ref_component`.`component_title`
`psi_ref_component`.`component_desc`
`psi_ref_component`.`table_component`
`psi_ref_component`.`component_url`
`psi_ref_component`.`insert_date`
`psi_ref_component`.`insert_by`
`psi_ref_component`.`update_date`
`psi_ref_component`.`update_by`
`psi_ref_component`.`delete_date`
`psi_ref_component`.`delete_by`
`psi_ref_component`.`is_deleted`
`psi_ref_dbtype`.*
`psi_ref_dbtype`.`id_dbtype`
`psi_ref_dbtype`.`db_engine`
`psi_ref_dbtype`.`description`
`psi_ref_dbtype`.`insert_date`
`psi_ref_dbtype`.`insert_by`
`psi_ref_dbtype`.`update_date`
`psi_ref_dbtype`.`update_by`
`psi_ref_dbtype`.`delete_date`
`psi_ref_dbtype`.`delete_by`
`psi_ref_dbtype`.`is_deleted`
`psi_ref_form_component`.*
`psi_ref_form_component`.`id_form_component`
`psi_ref_form_component`.`form_comp_title`
`psi_ref_form_component`.`form_comp_desc`
`psi_ref_form_component`.`form_comp_code`
`psi_ref_form_component`.`insert_date`
`psi_ref_form_component`.`insert_by`
`psi_ref_form_component`.`update_date`
`psi_ref_form_component`.`update_by`
`psi_ref_form_component`.`delete_date`
`psi_ref_form_component`.`delete_by`
`psi_ref_form_component`.`is_deleted`
`psi_ref_language`.*
`psi_ref_language`.`language_id`
`psi_ref_language`.`charset`
`psi_ref_language`.`display_name`
`psi_ref_language`.`image`
`psi_ref_language_dictionary`.*
`psi_ref_language_dictionary`.`id_word`
`psi_ref_language_dictionary`.`apps_id`
`psi_ref_language_dictionary`.`lang_id`
`psi_ref_language_dictionary`.`lang_en`
`psi_ref_language_dictionary`.`insert_date`
`psi_ref_language_dictionary`.`insert_by`
`psi_ref_language_dictionary`.`update_date`
`psi_ref_language_dictionary`.`update_by`
`psi_ref_language_dictionary`.`delete_date`
`psi_ref_language_dictionary`.`delete_by`
`psi_ref_language_dictionary`.`is_deleted`
`psi_ref_logintype`.*
`psi_ref_logintype`.`id_logintype`
`psi_ref_logintype`.`logtype_title`
`psi_ref_logintype`.`logtype_desc`
`psi_ref_logintype`.`insert_date`
`psi_ref_logintype`.`insert_by`
`psi_ref_logintype`.`update_date`
`psi_ref_logintype`.`update_by`
`psi_ref_logintype`.`delete_date`
`psi_ref_logintype`.`delete_by`
`psi_ref_logintype`.`is_deleted`
`psi_ref_pagetype`.*
`psi_ref_pagetype`.`id_pagetype`
`psi_ref_pagetype`.`page_title`
`psi_ref_pagetype`.`page_desc`
`psi_ref_pagetype`.`page_icon`
`psi_ref_pagetype`.`page_template_url`
`psi_ref_pagetype`.`insert_date`
`psi_ref_pagetype`.`insert_by`
`psi_ref_pagetype`.`update_date`
`psi_ref_pagetype`.`update_by`
`psi_ref_pagetype`.`delete_date`
`psi_ref_pagetype`.`delete_by`
`psi_ref_pagetype`.`is_deleted`
`psi_ref_status`.*
`psi_ref_status`.`id_status`
`psi_ref_status`.`status_name`
`psi_ref_status`.`status_desc`
`psi_ref_status`.`insert_date`
`psi_ref_status`.`insert_by`
`psi_ref_status`.`update_date`
`psi_ref_status`.`update_by`
`psi_ref_status`.`delete_date`
`psi_ref_status`.`delete_by`
`psi_ref_status`.`is_deleted`
`psi_ref_status`.`id_data`
`psi_ref_user`.*
`psi_ref_user`.`user_id`
`psi_ref_user`.`user_name`
`psi_ref_user`.`pwd`
`psi_ref_user`.`pin`
`psi_ref_user`.`full_name`
`psi_ref_user`.`notes`
`psi_ref_user`.`group_id`
`psi_ref_user`.`email`
`psi_ref_user`.`apps_id`
`psi_ref_user`.`insert_date`
`psi_ref_user`.`insert_by`
`psi_ref_user`.`update_date`
`psi_ref_user`.`update_by`
`psi_ref_user`.`delete_date`
`psi_ref_user`.`delete_by`
`psi_ref_user`.`is_deleted`
`psi_ref_validationform`.*
`psi_ref_validationform`.`id_validation`
`psi_ref_validationform`.`validation_name`
`psi_ref_validationform`.`validation_desc`
`psi_ref_validationform`.`validation_script`
`psi_ref_validationform`.`insert_date`
`psi_ref_validationform`.`insert_by`
`psi_ref_validationform`.`update_date`
`psi_ref_validationform`.`update_by`
`psi_ref_validationform`.`delete_date`
`psi_ref_validationform`.`delete_by`
`psi_ref_validationform`.`is_deleted`
`psi_report_catalog`.*
`psi_report_catalog`.`id_report`
`psi_report_catalog`.`apps_id`
`psi_report_catalog`.`report_title`
`psi_report_catalog`.`report_description`
`psi_report_catalog`.`dependency_id`
`psi_report_catalog`.`id_query`
`psi_report_catalog`.`search_col`
`psi_report_catalog`.`show_col`
`psi_report_catalog`.`show_caption`
`psi_report_catalog`.`insert_date`
`psi_report_catalog`.`insert_by`
`psi_report_catalog`.`update_date`
`psi_report_catalog`.`update_by`
`psi_report_catalog`.`delete_date`
`psi_report_catalog`.`delete_by`
`psi_report_catalog`.`is_deleted`
`psi_report_catalog`.`sort_col`
`psi_workflowtype`.*
`psi_workflowtype`.`wf_id`
`psi_workflowtype`.`wf_name`
`psi_workflowtype`.`wf_desc`
`psi_workflowtype`.`insert_date`
`psi_workflowtype`.`insert_by`
`psi_workflowtype`.`update_date`
`psi_workflowtype`.`update_by`
`psi_workflowtype`.`delete_date`
`psi_workflowtype`.`delete_by`
`psi_workflowtype`.`is_deleted`
`psi_api_catalog`.*
`psi_api_catalog`.`id_api`
`psi_api_catalog`.`apps_id`
`psi_api_catalog`.`api_title`
`psi_api_catalog`.`id_apitype`
`psi_api_catalog`.`api_desc`
`psi_api_catalog`.`id_query`
`psi_api_catalog`.`dependency_variable`
`psi_api_catalog`.`variable_input`
`psi_api_catalog`.`variable_output`
`psi_api_catalog`.`delimeter_col`
`psi_api_catalog`.`delimeter_row`
`psi_api_catalog`.`insert_date`
`psi_api_catalog`.`insert_by`
`psi_api_catalog`.`update_date`
`psi_api_catalog`.`update_by`
`psi_api_catalog`.`delete_date`
`psi_api_catalog`.`delete_by`
`psi_api_catalog`.`is_deleted`
`psi_api_parser`.*
`psi_api_parser`.`id_apiparser`
`psi_api_parser`.`apps_id`
`psi_api_parser`.`api_title`
`psi_api_parser`.`id_apitype`
`psi_api_parser`.`api_desc`
`psi_api_parser`.`api_url`
`psi_api_parser`.`dependency_variable`
`psi_api_parser`.`variable_input`
`psi_api_parser`.`variable_output`
`psi_api_parser`.`delimeter_col`
`psi_api_parser`.`delimeter_row`
`psi_api_parser`.`insert_date`
`psi_api_parser`.`insert_by`
`psi_api_parser`.`update_date`
`psi_api_parser`.`update_by`
`psi_api_parser`.`delete_date`
`psi_api_parser`.`delete_by`
`psi_api_parser`.`is_deleted`
`psi_app_configurator`.*
`psi_app_configurator`.`id`
`psi_app_configurator`.`apps_id`
`psi_app_configurator`.`user_id`
`psi_app_dba`.*
`psi_app_dba`.`id`
`psi_app_dba`.`apps_id`
`psi_app_dba`.`user_id`
`psi_app_page`.*
`psi_app_page`.`id_page`
`psi_app_page`.`apps_id`
`psi_app_page`.`id_pagetype`
`psi_app_page`.`page_title`
`psi_app_page`.`no_section`
`psi_app_page`.`menu_id`
`psi_app_page`.`insert_date`
`psi_app_page`.`insert_by`
`psi_app_page`.`update_date`
`psi_app_page`.`update_by`
`psi_app_page`.`delete_date`
`psi_app_page`.`delete_by`
`psi_app_page`.`is_deleted`
`psi_app_page`.`index_flag`
`psi_app_page_detail`.*
`psi_app_page_detail`.`id_pagedetail`
`psi_app_page_detail`.`id_page`
`psi_app_page_detail`.`section_no`
`psi_app_page_detail`.`id_component`
`psi_app_page_detail`.`id_tbl_component`
`psi_app_page_detail`.`col_position`
`psi_app_page_detail`.`width1_12`
`psi_app_page_detail`.`insert_date`
`psi_app_page_detail`.`insert_by`
`psi_app_page_detail`.`update_date`
`psi_app_page_detail`.`update_by`
`psi_app_page_detail`.`delete_date`
`psi_app_page_detail`.`delete_by`
`psi_app_page_detail`.`is_deleted`
`psi_app_reviewer`.*
`psi_app_reviewer`.`id`
`psi_app_reviewer`.`apps_id`
`psi_app_reviewer`.`user_id`
`psi_application`.*
`psi_application`.`apps_id`
`psi_application`.`apps_title`
`psi_application`.`apps_desc`
`psi_application`.`ui_themes`
`psi_application`.`su_name`
`psi_application`.`su_pwd`
`psi_application`.`apps_icon`
`psi_application`.`apps_background_img`
`psi_application`.`apps_splash_screen`
`psi_application`.`apps_production_server`
`psi_application`.`apps_production_ip`
`psi_application`.`apps_production_uname`
`psi_application`.`apps_production_pwd`
`psi_application`.`apps_production_ppath`
`psi_application`.`apps_production_url`
`psi_application`.`apps_bucket_server`
`psi_application`.`apps_bucket_ip`
`psi_application`.`apps_bucket_uname`
`psi_application`.`apps_bucket_pwd`
`psi_application`.`apps_bucket_ppath`
`psi_application`.`apps_bucket_url`
`psi_application`.`insert_date`
`psi_application`.`insert_by`
`psi_application`.`update_date`
`psi_application`.`update_by`
`psi_application`.`delete_date`
`psi_application`.`delete_by`
`psi_application`.`is_deleted`
`psi_application`.`table_prefix`
`psi_application`.`company_id`
`psi_application`.`jasper_url`
`psi_application`.`jasper_user`
`psi_application`.`jasper_password`
`psi_application_ui`.*
`psi_application_ui`.`id_app_ui`
`psi_application_ui`.`apps_id`
`psi_application_ui`.`ui_title`
`psi_application_ui`.`ui_url`
`psi_application_ui`.`insert_date`
`psi_application_ui`.`insert_by`
`psi_application_ui`.`update_date`
`psi_application_ui`.`update_by`
`psi_application_ui`.`delete_date`
`psi_application_ui`.`delete_by`
`psi_application_ui`.`is_deleted`
`psi_application_variable`.*
`psi_application_variable`.`appvar_id`
`psi_application_variable`.`apps_id`
`psi_application_variable`.`apps_token`
`psi_application_variable`.`apps_title`
`psi_application_variable`.`apps_ui`
`psi_application_variable`.`apps_icon`
`psi_application_variable`.`apps_bgimages`
`psi_application_variable`.`apps_server_ppath`
`psi_application_variable`.`apps_server_url`
`psi_application_variable`.`apps_bucket_ppath`
`psi_application_variable`.`apps_bucket_url`
`psi_application_variable`.`transaction_upload_ppath`
`psi_application_variable`.`transaction_upload_url`
`psi_application_variable`.`allowed_ext`
`psi_application_variable`.`max_file_size`
`psi_application_variable`.`upload_file_format`
`psi_application_variable`.`table_prefix`
`psi_application_variable`.`insert_date`
`psi_application_variable`.`insert_by`
`psi_application_variable`.`udpate_date`
`psi_application_variable`.`update_by`
`psi_application_variable`.`delete_date`
`psi_application_variable`.`delete_by`
`psi_application_variable`.`is_deleted`
`psi_chart_catalog`.*
`psi_chart_catalog`.`chart_catalog_id`
`psi_chart_catalog`.`id_chart`
`psi_chart_catalog`.`chart_title`
`psi_chart_catalog`.`apps_id`
`psi_chart_catalog`.`description`
`psi_chart_catalog`.`id_query`
`psi_chart_catalog`.`chart_config`
`psi_chart_catalog`.`insert_date`
`psi_chart_catalog`.`insert_by`
`psi_chart_catalog`.`update_date`
`psi_chart_catalog`.`update_by`
`psi_chart_catalog`.`delete_date`
`psi_chart_catalog`.`delete_by`
`psi_chart_catalog`.`is_deleted`
`psi_chart_catalog`.`field_label`
`psi_chart_catalog`.`field_data`
`psi_custom_component`.*
`psi_custom_component`.`id_custom_component`
`psi_custom_component`.`custom_title`
`psi_custom_component`.`custom_content`
`psi_custom_component`.`insert_date`
`psi_custom_component`.`insert_by`
`psi_custom_component`.`update_date`
`psi_custom_component`.`update_by`
`psi_custom_component`.`delete_date`
`psi_custom_component`.`delete_by`
`psi_custom_component`.`is_deleted`
`psi_custom_component`.`apps_id`
`psi_custom_component`.`api_url`
`psi_data_numbering`.*
`psi_data_numbering`.`id_numbering`
`psi_data_numbering`.`module_name`
`psi_data_numbering`.`prefix`
`psi_data_numbering`.`prefix_separator`
`psi_data_numbering`.`company_info`
`psi_data_numbering`.`id_query_company`
`psi_data_numbering`.`query_syntax_company`
`psi_data_numbering`.`dependency_field_company`
`psi_data_numbering`.`branch_info`
`psi_data_numbering`.`id_query_branch`
`psi_data_numbering`.`query_syntax_branch`
`psi_data_numbering`.`dependency_field_branch`
`psi_data_numbering`.`yr_info`
`psi_data_numbering`.`yr_info_separator`
`psi_data_numbering`.`period_info`
`psi_data_numbering`.`period_info_separator`
`psi_data_numbering`.`date_source_type`
`psi_data_numbering`.`date_source_field`
`psi_data_numbering`.`insert_date`
`psi_data_numbering`.`insert_by`
`psi_data_numbering`.`update_date`
`psi_data_numbering`.`update_by`
`psi_data_numbering`.`delete_date`
`psi_data_numbering`.`delete_by`
`psi_data_numbering`.`is_deleted`
`psi_data_numbering`.`apps_id`
`psi_data_numbering`.`padding`
`psi_data_numbering`.`company_info_separator`
`psi_data_numbering`.`branch_info_separator`
`psi_data_numbering`.`prefix_config`
`psi_data_numbering_detail`.*
`psi_data_numbering_detail`.`id_numbering_detail`
`psi_data_numbering_detail`.`id_numbering`
`psi_data_numbering_detail`.`prefix`
`psi_data_numbering_detail`.`last_number`
`psi_data_numbering_detail`.`insert_date`
`psi_data_numbering_detail`.`insert_by`
`psi_data_numbering_detail`.`update_date`
`psi_data_numbering_detail`.`update_by`
`psi_data_numbering_detail`.`delete_date`
`psi_data_numbering_detail`.`delete_by`
`psi_data_numbering_detail`.`is_deleted`
`psi_data_tables`.*
`psi_data_tables`.`id_data`
`psi_data_tables`.`apps_id`
`psi_data_tables`.`data_title`
`psi_data_tables`.`data_description`
`psi_data_tables`.`dependency_id`
`psi_data_tables`.`id_query`
`psi_data_tables`.`search_col`
`psi_data_tables`.`sort_col`
`psi_data_tables`.`show_col`
`psi_data_tables`.`show_caption`
`psi_data_tables`.`new_col_caption`
`psi_data_tables`.`new_trigger_query`
`psi_data_tables`.`id_form_new`
`psi_data_tables`.`edit_col_caption`
`psi_data_tables`.`edit_trigger_query`
`psi_data_tables`.`id_form_edit`
`psi_data_tables`.`view_col_caption`
`psi_data_tables`.`id_form_view`
`psi_data_tables`.`v_additional_button_1`
`psi_data_tables`.`v_button_1_condition`
`psi_data_tables`.`v_additional_button_2`
`psi_data_tables`.`v_button_2_condition`
`psi_data_tables`.`v_additional_button_3`
`psi_data_tables`.`v_button_3_condition`
`psi_data_tables`.`insert_date`
`psi_data_tables`.`insert_by`
`psi_data_tables`.`update_date`
`psi_data_tables`.`update_by`
`psi_data_tables`.`delete_date`
`psi_data_tables`.`delete_by`
`psi_data_tables`.`is_deleted`
`psi_data_tables`.`new_form_title`
`psi_data_tables`.`edit_form_title`
`psi_data_tables`.`view_form_title`
`psi_data_tables`.`two_column_flag`
`psi_data_tables_child`.*
`psi_data_tables_child`.`id_data_child`
`psi_data_tables_child`.`id_data`
`psi_data_tables_child`.`apps_id`
`psi_data_tables_child`.`data_title`
`psi_data_tables_child`.`data_description`
`psi_data_tables_child`.`dependency_id`
`psi_data_tables_child`.`id_query`
`psi_data_tables_child`.`search_col`
`psi_data_tables_child`.`sort_col`
`psi_data_tables_child`.`show_col`
`psi_data_tables_child`.`show_caption`
`psi_data_tables_child`.`new_col_caption`
`psi_data_tables_child`.`new_trigger_query`
`psi_data_tables_child`.`id_form_new`
`psi_data_tables_child`.`edit_col_caption`
`psi_data_tables_child`.`edit_trigger_query`
`psi_data_tables_child`.`id_form_edit`
`psi_data_tables_child`.`view_col_caption`
`psi_data_tables_child`.`id_form_view`
`psi_data_tables_child`.`v_additional_button_1`
`psi_data_tables_child`.`v_button_1_condition`
`psi_data_tables_child`.`v_additional_button_2`
`psi_data_tables_child`.`v_button_2_condition`
`psi_data_tables_child`.`v_additional_button_3`
`psi_data_tables_child`.`v_button_3_condition`
`psi_data_tables_child`.`insert_date`
`psi_data_tables_child`.`insert_by`
`psi_data_tables_child`.`update_date`
`psi_data_tables_child`.`update_by`
`psi_data_tables_child`.`delete_date`
`psi_data_tables_child`.`delete_by`
`psi_data_tables_child`.`is_deleted`
`psi_data_tables_child`.`new_form_title`
`psi_data_tables_child`.`edit_form_title`
`psi_data_tables_child`.`view_form_title`
`psi_data_tables_child`.`two_column_flag`
`psi_data_tables_child`.`dependency_value`
`psi_data_tables_wf`.*
`psi_data_tables_wf`.`id_data_wf`
`psi_data_tables_wf`.`id_data`
`psi_data_tables_wf`.`wf_id`
`psi_data_tables_wf`.`stage_name`
`psi_data_tables_wf`.`stage_desc`
`psi_data_tables_wf`.`button_stage_caption`
`psi_data_tables_wf`.`label_color_data`
`psi_data_tables_wf`.`id_status`
`psi_data_tables_wf`.`order_no`
`psi_data_tables_wf`.`id_data_wf_parent`
`psi_data_tables_wf`.`insert_date`
`psi_data_tables_wf`.`insert_by`
`psi_data_tables_wf`.`update_date`
`psi_data_tables_wf`.`update_by`
`psi_data_tables_wf`.`delete_date`
`psi_data_tables_wf`.`delete_by`
`psi_data_tables_wf`.`is_deleted`
`psi_data_tables_wf`.`condition_type`
`psi_data_tables_wf`.`id_query_condition`
`psi_data_tables_wf`.`query_syntax_condition`
`psi_data_tables_wf`.`variable_query_output`
`psi_data_tables_wf_condition`.*
`psi_data_tables_wf_condition`.`id_data_wf_condition`
`psi_data_tables_wf_condition`.`id_data_wf`
`psi_data_tables_wf_condition`.`param_type_1`
`psi_data_tables_wf_condition`.`param_value_1`
`psi_data_tables_wf_condition`.`id_group_condition`
`psi_data_tables_wf_condition`.`insert_date`
`psi_data_tables_wf_condition`.`insert_by`
`psi_data_tables_wf_condition`.`update_date`
`psi_data_tables_wf_condition`.`update_by`
`psi_data_tables_wf_condition`.`delete_date`
`psi_data_tables_wf_condition`.`delete_by`
`psi_data_tables_wf_condition`.`is_deleted`
`psi_data_tables_wf_condition`.`param_type_2`
`psi_data_tables_wf_condition`.`param_value_2`
`psi_data_tables_wf_log`.*
`psi_data_tables_wf_log`.`id_data_wf_log`
`psi_data_tables_wf_log`.`id_data_wf`
`psi_data_tables_wf_log`.`id_data`
`psi_data_tables_wf_log`.`wf_id`
`psi_data_tables_wf_log`.`table_field`
`psi_data_tables_wf_log`.`table_value`
`psi_data_tables_wf_log`.`stage_name`
`psi_data_tables_wf_log`.`stage_desc`
`psi_data_tables_wf_log`.`order_no`
`psi_data_tables_wf_log`.`condition_type`
`psi_data_tables_wf_log`.`group_id`
`psi_data_tables_wf_log`.`user_id`
`psi_data_tables_wf_log`.`insert_date`
`psi_data_tables_wf_log`.`insert_by`
`psi_data_tables_wf_log`.`update_date`
`psi_data_tables_wf_log`.`update_by`
`psi_data_tables_wf_log`.`delete_date`
`psi_data_tables_wf_log`.`delete_by`
`psi_data_tables_wf_log`.`is_deleted`
`psi_data_tables_wf_log`.`action_type`
`psi_data_wf_detail`.*
`psi_data_wf_detail`.`id_data_wf_detail`
`psi_data_wf_detail`.`id_data_wf`
`psi_data_wf_detail`.`group_id`
`psi_data_wf_detail`.`insert_date`
`psi_data_wf_detail`.`insert_by`
`psi_data_wf_detail`.`update_date`
`psi_data_wf_detail`.`update_by`
`psi_data_wf_detail`.`delete_date`
`psi_data_wf_detail`.`delete_by`
`psi_data_wf_detail`.`is_deleted`
`psi_datatables_group`.*
`psi_datatables_group`.`id_ref_auth_group`
`psi_datatables_group`.`id_data`
`psi_datatables_group`.`group_id`
`psi_datatables_group`.`crud_type`
`psi_datatables_group`.`insert_date`
`psi_datatables_group`.`insert_by`
`psi_datatables_group`.`update_date`
`psi_datatables_group`.`update_by`
`psi_datatables_group`.`delete_date`
`psi_datatables_group`.`delete_by`
`psi_datatables_group`.`is_deleted`
`psi_db_catalog`.*
`psi_db_catalog`.`id_dbcon`
`psi_db_catalog`.`apps_id`
`psi_db_catalog`.`id_dbtype`
`psi_db_catalog`.`db_name`
`psi_db_catalog`.`server_name`
`psi_db_catalog`.`ip_addr`
`psi_db_catalog`.`port_no`
`psi_db_catalog`.`user_name`
`psi_db_catalog`.`pwd`
`psi_db_catalog`.`audit_trail_table_name`
`psi_db_catalog`.`insert_date`
`psi_db_catalog`.`insert_by`
`psi_db_catalog`.`update_date`
`psi_db_catalog`.`update_by`
`psi_db_catalog`.`delete_date`
`psi_db_catalog`.`delete_by`
`psi_db_catalog`.`is_deleted`
`psi_db_table`.*
`psi_db_table`.`table_id`
`psi_db_table`.`db_name`
`psi_db_table`.`table_name`
`psi_db_table`.`insert_date`
`psi_db_table`.`insert_by`
`psi_db_table`.`update_date`
`psi_db_table`.`update_by`
`psi_db_table`.`delete_date`
`psi_db_table`.`delete_by`
`psi_db_table`.`is_deleted`
`psi_db_table_field`.*
`psi_db_table_field`.`field_id`
`psi_db_table_field`.`table_id`
`psi_db_table_field`.`field_value`
`psi_db_table_field`.`insert_date`
`psi_db_table_field`.`insert_by`
`psi_db_table_field`.`update_date`
`psi_db_table_field`.`update_by`
`psi_db_table_field`.`delete_date`
`psi_db_table_field`.`delete_by`
`psi_db_table_field`.`is_deleted`
`psi_form_catalog`.*
`psi_form_catalog`.`id_form`
`psi_form_catalog`.`apps_id`
`psi_form_catalog`.`form_title`
`psi_form_catalog`.`form_desc`
`psi_form_catalog`.`form_size_cols`
`psi_form_catalog`.`variable_input`
`psi_form_catalog`.`variable_caption`
`psi_form_catalog`.`variable_validation`
`psi_form_catalog`.`form_action_url`
`psi_form_catalog`.`insert_date`
`psi_form_catalog`.`insert_by`
`psi_form_catalog`.`update_date`
`psi_form_catalog`.`update_by`
`psi_form_catalog`.`delete_date`
`psi_form_catalog`.`delete_by`
`psi_form_catalog`.`is_deleted`
`psi_form_catalog`.`id_api`
`psi_form_catalog`.`form_config`
`psi_form_catalog`.`field_used`
`psi_form_catalog_detail`.*
`psi_form_catalog_detail`.`id_formdetail`
`psi_form_catalog_detail`.`id_form`
`psi_form_catalog_detail`.`col`
`psi_form_catalog_detail`.`field_name`
`psi_form_catalog_detail`.`field_caption`
`psi_form_catalog_detail`.`dependency_field`
`psi_form_catalog_detail`.`query_list`
`psi_form_catalog_detail`.`field_type`
`psi_form_catalog_detail`.`field_size`
`psi_form_catalog_detail`.`id_validation`
`psi_form_catalog_detail`.`insert_date`
`psi_form_catalog_detail`.`insert_by`
`psi_form_catalog_detail`.`update_date`
`psi_form_catalog_detail`.`update_by`
`psi_form_catalog_detail`.`delete_date`
`psi_form_catalog_detail`.`delete_by`
`psi_form_catalog_detail`.`is_deleted`
`psi_form_catalog_detail`.`id_form_group`
`psi_form_catalog_detail`.`row`
`psi_form_catalog_detail`.`mandatory_flag`
`psi_form_catalog_detail`.`col_size`
`psi_form_catalog_detail`.`field_properties`
`psi_form_catalog_group`.*
`psi_form_catalog_group`.`id_form_group`
`psi_form_catalog_group`.`id_form`
`psi_form_catalog_group`.`group_title`
`psi_form_catalog_group`.`group_desc`
`psi_form_catalog_group`.`row_pos`
`psi_form_catalog_group`.`col_pos`
`psi_form_catalog_group`.`size`
`psi_form_catalog_group`.`insert_date`
`psi_form_catalog_group`.`insert_by`
`psi_form_catalog_group`.`update_date`
`psi_form_catalog_group`.`update_by`
`psi_form_catalog_group`.`delete_date`
`psi_form_catalog_group`.`delete_by`
`psi_form_catalog_group`.`is_deleted`
`psi_group`.*
`psi_group`.`group_id`
`psi_group`.`apps_id`
`psi_group`.`group_name`
`psi_group`.`notes`
`psi_group`.`insert_date`
`psi_group`.`insert_by`
`psi_group`.`update_date`
`psi_group`.`update_by`
`psi_group`.`delete_date`
`psi_group`.`delete_by`
`psi_group`.`is_deleted`
`psi_group_user`.*
`psi_group_user`.`group_user_id`
`psi_group_user`.`group_id`
`psi_group_user`.`user_id`
`psi_group_user`.`insert_date`
`psi_group_user`.`insert_by`
`psi_group_user`.`update_date`
`psi_group_user`.`update_by`
`psi_group_user`.`delete_date`
`psi_group_user`.`delete_by`
`psi_group_user`.`is_deleted`
`psi_groupauthorization`.*
`psi_groupauthorization`.`group_auth_id`
`psi_groupauthorization`.`group_id`
`psi_groupauthorization`.`auth_id`
`psi_groupauthorization`.`insert_date`
`psi_groupauthorization`.`insert_by`
`psi_groupauthorization`.`update_date`
`psi_groupauthorization`.`update_by`
`psi_groupauthorization`.`delete_date`
`psi_groupauthorization`.`delete_by`
`psi_groupauthorization`.`is_deleted`
`psi_login_setting`.*
`psi_login_setting`.`id_login`
`psi_login_setting`.`apps_id`
`psi_login_setting`.`login_title`
`psi_login_setting`.`id_logintype`
`psi_login_setting`.`is_captcha`
`psi_login_setting`.`insert_date`
`psi_login_setting`.`insert_by`
`psi_login_setting`.`update_date`
`psi_login_setting`.`update_by`
`psi_login_setting`.`delete_date`
`psi_login_setting`.`delete_by`
`psi_login_setting`.`is_deleted`
`psi_master_companies`.*
`psi_master_companies`.`id_company`
`psi_master_companies`.`company_code`
`psi_master_companies`.`company_name`
`psi_master_companies`.`insert_date`
`psi_master_companies`.`insert_by`
`psi_master_companies`.`update_date`
`psi_master_companies`.`update_by`
`psi_master_companies`.`delete_date`
`psi_master_companies`.`delete_by`
`psi_master_companies`.`is_deleted`
`psi_master_employees`.*
`psi_master_employees`.`id`
`psi_master_employees`.`employee_code`
`psi_master_employees`.`employee_name`
`psi_master_employees`.`position`
`psi_master_employees`.`company_code`
`psi_master_employees`.`employee_parent_code`
`psi_master_employees`.`email`
`psi_master_kabupaten`.*
`psi_master_kabupaten`.`id`
`psi_master_kabupaten`.`kabupaten_kode`
`psi_master_kabupaten`.`kabupaten_nama`
`psi_master_kabupaten`.`propinsi_kode`
`psi_master_kabupaten`.`insert_date`
`psi_master_kabupaten`.`insert_by`
`psi_master_kabupaten`.`update_date`
`psi_master_kabupaten`.`update_by`
`psi_master_kabupaten`.`deleted_date`
`psi_master_kabupaten`.`delete_by`
`psi_master_kabupaten`.`is_deleted`
`psi_master_kecamatan`.*
`psi_master_kecamatan`.`id`
`psi_master_kecamatan`.`kecamatan_kode`
`psi_master_kecamatan`.`kecamatan_nama`
`psi_master_kecamatan`.`kabupaten_kode`
`psi_master_kecamatan`.`insert_date`
`psi_master_kecamatan`.`insert_by`
`psi_master_kecamatan`.`update_date`
`psi_master_kecamatan`.`update_by`
`psi_master_kecamatan`.`deleted_date`
`psi_master_kecamatan`.`delete_by`
`psi_master_kecamatan`.`is_deleted`
`psi_master_kelurahan`.*
`psi_master_kelurahan`.`id`
`psi_master_kelurahan`.`kelurahan_kode`
`psi_master_kelurahan`.`kelurahan_nama`
`psi_master_kelurahan`.`kecamatan_kode`
`psi_master_kelurahan`.`kodepos`
`psi_master_kelurahan`.`insert_date`
`psi_master_kelurahan`.`insert_by`
`psi_master_kelurahan`.`update_date`
`psi_master_kelurahan`.`update_by`
`psi_master_kelurahan`.`deleted_date`
`psi_master_kelurahan`.`delete_by`
`psi_master_kelurahan`.`is_deleted`
`psi_master_new_employees`.*
`psi_master_new_employees`.`id`
`psi_master_new_employees`.`employee_code`
`psi_master_new_employees`.`employee_name`
`psi_master_new_employees`.`email`
`psi_master_new_employees`.`join_date`
`psi_master_new_employees`.`grade`
`psi_master_new_employees`.`employee_level`
`psi_master_new_employees`.`position_id`
`psi_master_new_employees`.`position_name`
`psi_master_new_employees`.`job_family`
`psi_master_new_employees`.`lokper`
`psi_master_new_employees`.`lokper_name`
`psi_master_new_employees`.`cost_center_code`
`psi_master_new_employees`.`cost_center_name`
`psi_master_new_employees`.`al_code`
`psi_master_new_employees`.`al_name`
`psi_master_new_employees`.`al_email`
`psi_master_new_employees`.`al_position_id`
`psi_master_new_employees`.`al_position_name`
`psi_master_new_employees`.`aal_code`
`psi_master_new_employees`.`aal_name`
`psi_master_new_employees`.`aal_email`
`psi_master_new_employees`.`aal_position_id`
`psi_master_new_employees`.`aal_position_name`
`psi_master_new_employees`.`insert_date`
`psi_master_new_employees`.`insert_by`
`psi_master_new_employees`.`update_date`
`psi_master_new_employees`.`update_by`
`psi_master_new_employees`.`delete_date`
`psi_master_new_employees`.`delete_by`
`psi_master_new_employees`.`is_deleted`
`psi_master_propinsi`.*
`psi_master_propinsi`.`id`
`psi_master_propinsi`.`propinsi_kode`
`psi_master_propinsi`.`propinsi_nama`
`psi_master_propinsi`.`insert_date`
`psi_master_propinsi`.`insert_by`
`psi_master_propinsi`.`update_date`
`psi_master_propinsi`.`update_by`
`psi_master_propinsi`.`deleted_date`
`psi_master_propinsi`.`delete_by`
`psi_master_propinsi`.`is_deleted`
`psi_menu`.*
`psi_menu`.`menu_id`
`psi_menu`.`apps_id`
`psi_menu`.`title`
`psi_menu`.`id_page`
`psi_menu`.`parent_id`
`psi_menu`.`class_menu`
`psi_menu`.`level`
`psi_menu`.`auth_id`
`psi_menu`.`order`
`psi_menu`.`insert_date`
`psi_menu`.`insert_by`
`psi_menu`.`update_date`
`psi_menu`.`update_by`
`psi_menu`.`delete_date`
`psi_menu`.`delete_by`
`psi_menu`.`is_deleted`
`psi_menu`.`url_external`
`psi_menu`.`enabled`
`psi_menu`.`menu_header_id`
`psi_menu_header`.*
`psi_menu_header`.`menu_header_id`
`psi_menu_header`.`apps_id`
`psi_menu_header`.`menu_title`
`psi_menu_header`.`description`
`psi_menu_header`.`insert_date`
`psi_menu_header`.`insert_by`
`psi_menu_header`.`update_date`
`psi_menu_header`.`update_by`
`psi_menu_header`.`delete_date`
`psi_menu_header`.`delete_by`
`psi_menu_header`.`is_deleted`
`psi_query_catalog`.*
`psi_query_catalog`.`id_query`
`psi_query_catalog`.`query_name`
`psi_query_catalog`.`query_desc`
`psi_query_catalog`.`query_syntax`
`psi_query_catalog`.`search_col`
`psi_query_catalog`.`search_table`
`psi_query_catalog`.`search_table_join`
`psi_query_catalog`.`search_condition`
`psi_query_catalog`.`insert_date`
`psi_query_catalog`.`insert_by`
`psi_query_catalog`.`update_date`
`psi_query_catalog`.`update_by`
`psi_query_catalog`.`delete_date`
`psi_query_catalog`.`delete_by`
`psi_query_catalog`.`is_deleted`
`psi_query_catalog`.`apps_id`
`psi_query_catalog`.`id_dbcon`
`psi_query_catalog`.`main_table_aliases`
`psi_ref_admin`.*
`psi_ref_admin`.`user_id`
`psi_ref_admin`.`user_name`
`psi_ref_admin`.`pwd`
`psi_ref_admin`.`pin`
`psi_ref_admin`.`full_name`
`psi_ref_admin`.`notes`
`psi_ref_admin`.`group_id`
`psi_ref_admin`.`email`
`psi_ref_admin`.`apps_id`
`psi_ref_admin`.`insert_date`
`psi_ref_admin`.`insert_by`
`psi_ref_admin`.`update_date`
`psi_ref_admin`.`update_by`
`psi_ref_admin`.`delete_date`
`psi_ref_admin`.`delete_by`
`psi_ref_admin`.`is_deleted`
`psi_ref_apitype`.*
`psi_ref_apitype`.`id_apitype`
`psi_ref_apitype`.`apitype_title`
`psi_ref_apitype`.`apitype_desc`
`psi_ref_apitype`.`insert_date`
`psi_ref_apitype`.`insert_by`
`psi_ref_apitype`.`update_date`
`psi_ref_apitype`.`update_by`
`psi_ref_apitype`.`delete_date`
`psi_ref_apitype`.`delete_by`
`psi_ref_apitype`.`is_deleted`
`psi_ref_authorization`.*
`psi_ref_authorization`.`auth_id`
`psi_ref_authorization`.`apps_id`
`psi_ref_authorization`.`auth_name`
`psi_ref_authorization`.`notes`
`psi_ref_authorization`.`parent_id`
`psi_ref_authorization`.`insert_date`
`psi_ref_authorization`.`insert_by`
`psi_ref_authorization`.`update_date`
`psi_ref_authorization`.`update_by`
`psi_ref_authorization`.`delete_date`
`psi_ref_authorization`.`delete_by`
`psi_ref_authorization`.`is_deleted`
`psi_ref_authorization`.`id_data`
`psi_ref_authorization`.`id_page`
`psi_ref_authorization_group`.*
`psi_ref_authorization_group`.`auth_group_id`
`psi_ref_authorization_group`.`auth_id`
`psi_ref_authorization_group`.`group_id`
`psi_ref_authorization_group`.`insert_date`
`psi_ref_authorization_group`.`insert_by`
`psi_ref_authorization_group`.`update_date`
`psi_ref_authorization_group`.`update_by`
`psi_ref_authorization_group`.`delete_date`
`psi_ref_authorization_group`.`delete_by`
`psi_ref_authorization_group`.`is_deleted`
`psi_ref_chart_component`.*
`psi_ref_chart_component`.`id_chart`
`psi_ref_chart_component`.`chart_title`
`psi_ref_chart_component`.`chart_description`
`psi_ref_chart_component`.`dependency_id`
`psi_ref_chart_component`.`chart_code_url`
`psi_ref_chart_component`.`insert_date`
`psi_ref_chart_component`.`insert_by`
`psi_ref_chart_component`.`update_date`
`psi_ref_chart_component`.`update_by`
`psi_ref_chart_component`.`delete_date`
`psi_ref_chart_component`.`delete_by`
`psi_ref_chart_component`.`is_deleted`
`psi_ref_component`.*
`psi_ref_component`.`id_component`
`psi_ref_component`.`component_title`
`psi_ref_component`.`component_desc`
`psi_ref_component`.`table_component`
`psi_ref_component`.`component_url`
`psi_ref_component`.`insert_date`
`psi_ref_component`.`insert_by`
`psi_ref_component`.`update_date`
`psi_ref_component`.`update_by`
`psi_ref_component`.`delete_date`
`psi_ref_component`.`delete_by`
`psi_ref_component`.`is_deleted`
`psi_ref_dbtype`.*
`psi_ref_dbtype`.`id_dbtype`
`psi_ref_dbtype`.`db_engine`
`psi_ref_dbtype`.`description`
`psi_ref_dbtype`.`insert_date`
`psi_ref_dbtype`.`insert_by`
`psi_ref_dbtype`.`update_date`
`psi_ref_dbtype`.`update_by`
`psi_ref_dbtype`.`delete_date`
`psi_ref_dbtype`.`delete_by`
`psi_ref_dbtype`.`is_deleted`
`psi_ref_form_component`.*
`psi_ref_form_component`.`id_form_component`
`psi_ref_form_component`.`form_comp_title`
`psi_ref_form_component`.`form_comp_desc`
`psi_ref_form_component`.`form_comp_code`
`psi_ref_form_component`.`insert_date`
`psi_ref_form_component`.`insert_by`
`psi_ref_form_component`.`update_date`
`psi_ref_form_component`.`update_by`
`psi_ref_form_component`.`delete_date`
`psi_ref_form_component`.`delete_by`
`psi_ref_form_component`.`is_deleted`
`psi_ref_language`.*
`psi_ref_language`.`language_id`
`psi_ref_language`.`charset`
`psi_ref_language`.`display_name`
`psi_ref_language`.`image`
`psi_ref_language_dictionary`.*
`psi_ref_language_dictionary`.`id_word`
`psi_ref_language_dictionary`.`apps_id`
`psi_ref_language_dictionary`.`lang_id`
`psi_ref_language_dictionary`.`lang_en`
`psi_ref_language_dictionary`.`insert_date`
`psi_ref_language_dictionary`.`insert_by`
`psi_ref_language_dictionary`.`update_date`
`psi_ref_language_dictionary`.`update_by`
`psi_ref_language_dictionary`.`delete_date`
`psi_ref_language_dictionary`.`delete_by`
`psi_ref_language_dictionary`.`is_deleted`
`psi_ref_logintype`.*
`psi_ref_logintype`.`id_logintype`
`psi_ref_logintype`.`logtype_title`
`psi_ref_logintype`.`logtype_desc`
`psi_ref_logintype`.`insert_date`
`psi_ref_logintype`.`insert_by`
`psi_ref_logintype`.`update_date`
`psi_ref_logintype`.`update_by`
`psi_ref_logintype`.`delete_date`
`psi_ref_logintype`.`delete_by`
`psi_ref_logintype`.`is_deleted`
`psi_ref_pagetype`.*
`psi_ref_pagetype`.`id_pagetype`
`psi_ref_pagetype`.`page_title`
`psi_ref_pagetype`.`page_desc`
`psi_ref_pagetype`.`page_icon`
`psi_ref_pagetype`.`page_template_url`
`psi_ref_pagetype`.`insert_date`
`psi_ref_pagetype`.`insert_by`
`psi_ref_pagetype`.`update_date`
`psi_ref_pagetype`.`update_by`
`psi_ref_pagetype`.`delete_date`
`psi_ref_pagetype`.`delete_by`
`psi_ref_pagetype`.`is_deleted`
`psi_ref_status`.*
`psi_ref_status`.`id_status`
`psi_ref_status`.`status_name`
`psi_ref_status`.`status_desc`
`psi_ref_status`.`insert_date`
`psi_ref_status`.`insert_by`
`psi_ref_status`.`update_date`
`psi_ref_status`.`update_by`
`psi_ref_status`.`delete_date`
`psi_ref_status`.`delete_by`
`psi_ref_status`.`is_deleted`
`psi_ref_status`.`id_data`
`psi_ref_user`.*
`psi_ref_user`.`user_id`
`psi_ref_user`.`user_name`
`psi_ref_user`.`pwd`
`psi_ref_user`.`pin`
`psi_ref_user`.`full_name`
`psi_ref_user`.`notes`
`psi_ref_user`.`group_id`
`psi_ref_user`.`email`
`psi_ref_user`.`apps_id`
`psi_ref_user`.`insert_date`
`psi_ref_user`.`insert_by`
`psi_ref_user`.`update_date`
`psi_ref_user`.`update_by`
`psi_ref_user`.`delete_date`
`psi_ref_user`.`delete_by`
`psi_ref_user`.`is_deleted`
`psi_ref_validationform`.*
`psi_ref_validationform`.`id_validation`
`psi_ref_validationform`.`validation_name`
`psi_ref_validationform`.`validation_desc`
`psi_ref_validationform`.`validation_script`
`psi_ref_validationform`.`insert_date`
`psi_ref_validationform`.`insert_by`
`psi_ref_validationform`.`update_date`
`psi_ref_validationform`.`update_by`
`psi_ref_validationform`.`delete_date`
`psi_ref_validationform`.`delete_by`
`psi_ref_validationform`.`is_deleted`
`psi_report_catalog`.*
`psi_report_catalog`.`id_report`
`psi_report_catalog`.`apps_id`
`psi_report_catalog`.`report_title`
`psi_report_catalog`.`report_description`
`psi_report_catalog`.`dependency_id`
`psi_report_catalog`.`id_query`
`psi_report_catalog`.`search_col`
`psi_report_catalog`.`show_col`
`psi_report_catalog`.`show_caption`
`psi_report_catalog`.`insert_date`
`psi_report_catalog`.`insert_by`
`psi_report_catalog`.`update_date`
`psi_report_catalog`.`update_by`
`psi_report_catalog`.`delete_date`
`psi_report_catalog`.`delete_by`
`psi_report_catalog`.`is_deleted`
`psi_report_catalog`.`sort_col`
`psi_workflowtype`.*
`psi_workflowtype`.`wf_id`
`psi_workflowtype`.`wf_name`
`psi_workflowtype`.`wf_desc`
`psi_workflowtype`.`insert_date`
`psi_workflowtype`.`insert_by`
`psi_workflowtype`.`update_date`
`psi_workflowtype`.`update_by`
`psi_workflowtype`.`delete_date`
`psi_workflowtype`.`delete_by`
`psi_workflowtype`.`is_deleted`
Alias:
Show:
Sort:
Ascending
Descending
Ascending
Descending
Ascending
Descending
Sort order:
1
2
3
1
2
3
1
2
3
Criteria:
Ins:
And:
Del:
Or:
Modify:
Or:
And:
Ins
Del
Or:
And:
Ins
Del
Ins
Del
Add/Delete criteria rows:
-3
-2
-1
0
1
2
3
Add/Delete columns:
-3
-2
-1
0
1
2
3
Use tables
psi_api_catalog
psi_api_parser
psi_app_configurator
psi_app_dba
psi_app_page
psi_app_page_detail
psi_app_reviewer
psi_application
psi_application_ui
psi_application_variable
psi_chart_catalog
psi_custom_component
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_datatables_group
psi_db_catalog
psi_db_table
psi_db_table_field
psi_form_catalog
psi_form_catalog_detail
psi_form_catalog_group
psi_group
psi_group_user
psi_groupauthorization
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
SQL query on database
psi_studio
: