Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
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
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `psi_data_tables_child`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id_data_child id_data apps_id data_title data_description dependency_id id_query search_col sort_col show_col show_caption new_col_caption new_trigger_query id_form_new edit_col_caption edit_trigger_query id_form_edit view_col_caption id_form_view v_additional_button_1 v_button_1_condition v_additional_button_2 v_button_2_condition v_additional_button_3 v_button_3_condition insert_date insert_by update_date update_by delete_date delete_by is_deleted new_form_title edit_form_title view_form_title two_column_flag dependency_value
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 1
1 3 0 TABEL KARYAWAN NULL NULL 8 Nama Karyawan|employee_name, employee_name, employee_name, Nama Karyawan, [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL NULL NULL NULL NULL NULL 2022-09-08 04:26:23 1 2022-09-28 18:30:42 admin NULL NULL 0 Input Data Karyawan Edit Data Karyawan View Data Karyawan 0 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 2
2 10 26 DAFTAR PIC PROJECT NULL id_project 15 contact_name|contact_name,phone_no|phone_no, contact_name,phone_no, contact_name,phone_no, contact_name,phone_no, [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL NULL NULL NULL NULL NULL 2022-10-31 22:56:28 1 2022-11-02 20:01:19 admin NULL NULL 0 TAMBAH PIC PROYEK UBAH PIC PROYEK LIHAT PIC PROYEK 0 id_project
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 3
3 15 0 DATA CUSTOMER CONTACT NULL m_customer_id 32 name|name,job_title|job_title,mobile_no|mobile_no,... name,job_title,mobile_no,email, name,job_title,mobile_no,email, name,job_title,mobile_no,email, [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL NULL NULL NULL NULL NULL 2022-09-30 21:09:44 1 2022-10-01 04:05:04 admin NULL NULL 0 Input Data Customer Contact Edit Data Customer Contact View Data Customer Contact 0 id
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 6
6 16 23 DATA CONTACT NULL m_customer_id 34 name|name,job_title|job_title,phone_no|phone_no,em... name,job_title,phone_no,email, name,job_title,phone_no,email, name,job_title,phone_no,email, [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL NULL NULL NULL NULL NULL 2022-10-01 23:03:02 1 2022-10-01 23:03:02 1 NULL NULL 0 Add Contact Edit Contact View Contact 0 id_customer
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 7
7 22 26 QUOTATION DETAIL NULL quotation_id 41 id_quotation_detail|id_quotation_detail,jumlah|jum... id_quotation_detail,jumlah,harga,service_name, id_quotation_detail,jumlah,harga,service_name, id_quotation_detail,jumlah,harga,service_name, [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL NULL NULL NULL NULL NULL 2022-11-04 01:17:52 1 2022-11-04 04:38:06 admin NULL NULL 0 TAMBAH ITEM QUOTATION UBAH ITEM QUOTATION LIHAT ITEM QUOTATION 0 quotation_id
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 8
8 25 27 EMPLOYEE COMPANY EMPLOYEE COMPANY EMP_ID 47 START_DATE|START_DATE,END_DATE|END_DATE,POSITION_I... START_DATE,END_DATE,POSITION_ID,END_PROBATION,END_... START_DATE,END_DATE,POSITION_ID,END_PROBATION,END_... START_DATE,END_DATE,POSITION_ID,END_PROBATION,END_... [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL NULL NULL NULL NULL NULL 2022-11-03 22:11:25 19 2022-11-05 02:38:23 kahfi.resmana NULL NULL 0 Employee Company Employee Company Employee Company 0 EMP_ID
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 9
9 26 27 APPROVAL REIMBURSEMENT APPROVAL REIMBURSEMENT Reqapprovedby_id 48 Reqapprovedby_id|Reqapprovedby_id,emp_id_approve|e... Reqapprovedby_id,emp_id_approve,position_id_approv... Reqapprovedby_id,emp_id_approve,position_id_approv... Reqapprovedby_id,emp_id_approve,position_id_approv... [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL NULL NULL NULL NULL NULL 2022-11-04 19:11:20 19 2022-11-05 21:28:22 kahfi.resmana NULL NULL 0 APPROVAL REIMBURSEMENT APPROVAL REIMBURSEMENT APPROVAL REIMBURSEMENT 0 REIM_NO
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 10
10 25 27 FAMILY NULL EMP_ID 52 EMPFAMILY_NAME|EMPFAMILY_NAME,EMPFAMILY_RELATIONSH... EMPFAMILY_NAME,EMPFAMILY_RELATIONSHIP_ID,EMPFAMILY... EMPFAMILY_NAME,EMPFAMILY_RELATIONSHIP_ID,EMPFAMILY... EMPFAMILY_NAME,EMPFAMILY_RELATIONSHIP_ID,EMPFAMILY... [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL NULL NULL NULL NULL NULL 2022-11-07 23:34:29 19 2022-11-07 23:34:29 19 NULL NULL 0 ADD FAMILY EDIT FAMILY VIEW FAMILY 0 EMP_ID
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 11
11 14 26 DT_CUSTOMERS_TYPE NULL id 53 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2022-11-10 20:38:14 15 2022-11-10 20:38:14 15 2022-11-18 11:44:35 15 1 NULL NULL NULL 0 m_customer_type_id
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 12
12 51 26 CUSTOMER CONTACT NULL m_customer_id 84 salutation|salutation,name|name,job_title|job_titl... salutation,name,job_title,phone_no,email, salutation,name,job_title,phone_no,email, salutation,name,job_title,phone_no,email, [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL NULL NULL NULL NULL NULL 2022-11-10 21:45:21 1 2022-11-10 21:45:21 1 NULL NULL 0 Input Customer Contact Edit Customer Contact View Customer Contact 0 id
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 13
13 82 26 APPROVAL LIMIT Input Company Approval Limit m_company_position_id 118 Approval Limit Type|approval_limit_type,Min Approv... approval_limit_type,min_approval_limit,max_approva... approval_limit_type,min_approval_limit,max_approva... Approval Limit Type,Min Approval Limit,Max Approva... [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL NULL NULL NULL NULL NULL 2022-11-17 18:10:33 25 2022-11-17 18:12:54 nurdiana.handayani NULL NULL 0 Add New Company Approval Limit Edit Company Approval Limit View Company Approval Limit 0 id
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 14
14 14 26 CUSTOMER ANALYST NULL id 127 id|id,code|code,name|name, id,code,name, id,code,name, id,code,name, NULL NULL 26 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2022-11-18 19:26:04 1 2022-11-18 19:26:04 1 2022-11-19 02:48:46 1 1 NULL NULL NULL 0 id
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 15
15 14 26 CUSTOMER ANALYST NULL m_customer_id 141 Liquidity|liquidity,Asset Size|asset_size,Asset No... liquidity,asset_size,asset_note,reputation,reputat... liquidity,asset_size,asset_note,reputation,reputat... Liquidity,Asset Size,Asset Notes,Reputation,Reputa... NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2022-11-18 19:52:41 1 2022-11-18 19:52:41 1 NULL NULL 0 NULL NULL NULL 0 id
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 16
16 101 26 DT_MASTER_PROJECTS_DETAILS NULL project_id 156 Division|division_name,Service|service_name,Charge... division_name,service_name,charge_name, division_name,service_name,charge_name, Division,Service,Charge, [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL NULL NULL NULL NULL NULL 2022-11-28 05:31:05 24 2022-12-09 20:54:56 ken.nurdiattama NULL NULL 0 Input New Project Detail Edit Project Detail View Project Detail 0 id
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 17
17 102 26 PERFORMA INVOICE DETAILS NULL t_proforma_id 155 Exchange Rate|exchange_rate,Amount|amount,QTY|qty,... exchange_rate,amount,qty,total_amount,remarks,coa,... exchange_rate,amount,qty,total_amount,remarks,coa,... Exchange Rate,Amount,QTY,Sub Total,Remarks,Coa,Div... [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL NULL NULL NULL NULL NULL 2022-11-27 21:14:15 25 2022-12-12 22:27:12 nurdiana.handayani NULL NULL 0 Add Performa Invoice Details Edit Performa Invoice Details View Performa Invoice Details 0 id
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 18
18 105 26 DT_MASTER_PROJECT_VENDOR_DETAILS NULL project_vendor_id 164 Charge Category|charge_category,Charge|charge,Bill... charge_category,charge,bill_type,exchange_rate,qty... charge_category,charge,bill_type,currency,exchange... Charge Category,Charge,Bill Type,Currency,Exchange... [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL NULL NULL NULL NULL NULL 2022-12-02 19:45:46 24 2022-11-25 18:00:33 admin NULL NULL 0 Input New Project Vendor Detail Edit Project Vendor Detail View Project Vendor Detail 0 id
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 19
19 79 26 DT_MASTER_TERM_CONDITION_MAPPING_DETAILS NULL m_term_condition_mapping_id 166 Term and Condition Name|term_condition_name,Seq No... term_condition_name,seq_no, term_condition_name,seq_no, Term and Condition Name,Seq No, [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL NULL NULL NULL NULL NULL 2022-12-04 04:13:51 24 2022-12-04 04:13:51 24 NULL NULL 0 Input New Term and Condition Mapping Detail Edit Term and Condition Mapping Detail View Term and Condition Mapping Detail 0 id
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 20
20 112 26 DT_MASTER_VENDOR_LEGAL_DOCUMENTS NULL m_vendor_id 171 Legal Document Name|document_name,Document No|docu... document_name,document_code,document_start_date,do... document_name,document_code,document_start_date,do... Legal Document Name,Document No,Start Date,End Dat... [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL NULL NULL NULL NULL NULL 2022-12-05 03:44:22 24 2022-11-27 21:55:26 ken.nurdiattama NULL NULL 0 Input Vendor New Legal Document Edit Vendor Legal Document View Vendor Legal Document 0 id_vendor
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 21
21 111 26 DETAILS PROFORMA NULL t_proforma_id 168 Exchange Rate|exchange_rate,Amount|amount,Qty|qty,... exchange_rate,amount,qty,total_amount,remarks,dept... exchange_rate,amount,qty,total_amount,remarks,dept... Exchange Rate,Amount,Qty,Total Amount,Remarks,Divi... [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL NULL NULL NULL NULL NULL 2022-12-05 04:31:50 25 2022-12-15 19:25:11 agus.romdhoni NULL NULL 0 Add Proforma Detail Edit Proforma Detail View Proforma Detail 0 id
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 22
22 112 26 DT_MASTER_VENDOR_BANKS NULL m_vendor_id 173 Bank Name|bank_name,Account No|account_no,Account ... bank_name,account_no,account_name,branch_name,curr... bank_name,account_no,account_name,branch_name,curr... Bank Name,Account No,Account Name,Branch Name,Curr... [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL NULL NULL NULL NULL NULL 2022-12-04 18:33:28 24 2022-11-24 01:31:09 ken.nurdiattama NULL NULL 0 Input New Vendor Bank Edit Vendor Bank View Vendor Bank 0 id_vendor
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 23
23 112 26 DT_MASTER_VENDOR_CONTACTS NULL m_vendor_id 176 Name|name,Job Title|job_title,Phone No|phone_no,Mo... name,job_title,phone_no,mobile_no,email, name,job_title,phone_no,mobile_no,email, Name,Job Title,Phone No,Mobile No,Email, [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL NULL NULL NULL NULL NULL 2022-12-04 19:18:38 24 2022-12-04 19:18:38 24 NULL NULL 0 Input New Vendor Contact Edit Vendor Contact View Vendor Contact 0 id_vendor
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 24
24 109 26 DT_MASTER_CUSTOMER_LEGAL_DOCUMENTS NULL m_customer_id 182 Document No|document_no,Document Name|document_nam... document_no,document_name,document_start_date,docu... document_no,document_name,document_start_date,docu... Document No,Document Name,Validity Start Date,Vali... [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL NULL NULL NULL NULL NULL 2022-12-09 02:54:09 24 2022-11-27 23:43:53 ken.nurdiattama NULL NULL 0 Input New Customer Legal Document Edit Customer Legal Document View Customer Legal Document 0 id
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 25
25 111 26 ATTACHMENT NULL t_proforma_id 185 Document Name|document_name,Document URL|doc_url, document_name,doc_url, document_name Document Name [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL NULL NULL NULL NULL NULL 2022-12-08 20:25:38 25 2022-12-15 19:26:13 agus.romdhoni NULL NULL 0 Add File Edit File View File 0 id
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 26
26 126 26 PROFORMA DETAILS NULL t_proforma_id 168 Exchange Rate|exchange_rate,Amount|amount,Qty|qty,... exchange_rate,amount,qty,total_amount,remarks,dept... dept_name,charge_name,category_name,amount,qty,exc... Division,Charge,Category Name,Amount,Qty,Exchange ... NULL NULL NULL NULL NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL NULL NULL NULL NULL NULL 2022-12-12 04:32:25 25 2022-12-11 20:10:20 nurdiana.handayani NULL NULL 0 NULL NULL View Proforma Detail 0 id
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables_child WHERE `psi_data_tables_child`.`id_data_child` = 27
27 126 26 PROFORMA DOCS NULL t_proforma_id 185 id|id,Document Name|document_name, id,document_name, document_name, Document Name, NULL NULL NULL NULL NULL NULL [
   {
       "two_column_flag": "0",
      ...
NULL NULL NULL NULL NULL NULL NULL 2022-12-12 04:39:30 25 2022-12-12 04:39:30 25 NULL NULL 0 NULL NULL View Proforma Docs 0 id
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query