Recent
`sadika_pos`.`cash_transactions`
`agro_system`.`settings`
`sadika_erp`.`hr_kpi_settings`
`sadika_erp`.`prj_projects`
`mysql`.`func`
`ayyub_erp`.`technicians`
`sadika_erp`.`sys_wa_queue`
`sadika_pos`.`products`
`ayyub_erp`.`customers`
`sadika_pos`.`user_levels`
Favorites
There are no favorite tables.
New
agro_system
alumni_db
ayyub
ayyub_erp
ayyub_pos_db
cahayailahi_db
gti_erp
imigrasi_db
information_schema
mysql
performance_schema
phpmyadmin
saas_sekolah
sadika
sadika_erp
sadika_pos
sembada_db
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.
Create view
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: sadika_erp
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:
`acc_assets`.*
`acc_assets`.`id`
`acc_assets`.`name`
`acc_assets`.`purchase_date`
`acc_assets`.`purchase_value`
`acc_assets`.`useful_life_months`
`acc_assets`.`residual_value`
`acc_assets`.`status`
`acc_assets`.`created_at`
`acc_coa`.*
`acc_coa`.`id`
`acc_coa`.`code`
`acc_coa`.`name`
`acc_coa`.`type`
`acc_coa`.`is_active`
`acc_journal_entries`.*
`acc_journal_entries`.`id`
`acc_journal_entries`.`entry_date`
`acc_journal_entries`.`description`
`acc_journal_entries`.`reference_type`
`acc_journal_entries`.`reference_id`
`acc_journal_entries`.`created_by`
`acc_journal_entries`.`created_at`
`acc_journal_items`.*
`acc_journal_items`.`id`
`acc_journal_items`.`entry_id`
`acc_journal_items`.`coa_id`
`acc_journal_items`.`debit`
`acc_journal_items`.`credit`
`employee_kpis`.*
`employee_kpis`.`id`
`employee_kpis`.`user_id`
`employee_kpis`.`role_type`
`employee_kpis`.`month`
`employee_kpis`.`year`
`employee_kpis`.`attendance_score`
`employee_kpis`.`discipline_notes`
`employee_kpis`.`tickets_completed`
`employee_kpis`.`avg_speed_minutes`
`employee_kpis`.`rating_avg`
`employee_kpis`.`punctuality_score`
`employee_kpis`.`complaints_count`
`employee_kpis`.`revenue_generated`
`employee_kpis`.`efficiency_percent`
`employee_kpis`.`invoices_completed`
`employee_kpis`.`avg_response_time_mins`
`employee_kpis`.`input_errors_count`
`employee_kpis`.`report_closing_status`
`employee_kpis`.`schedule_order_score`
`employee_kpis`.`cashflow_accuracy`
`employee_kpis`.`ar_collection_rate`
`employee_kpis`.`report_delay_days`
`employee_kpis`.`cash_diff_amount`
`employee_kpis`.`final_kpi_score`
`employee_kpis`.`updated_at`
`hr_complaints`.*
`hr_complaints`.`id`
`hr_complaints`.`ticket_id`
`hr_complaints`.`user_id`
`hr_complaints`.`customer_id`
`hr_complaints`.`description`
`hr_complaints`.`severity`
`hr_complaints`.`status`
`hr_complaints`.`created_at`
`hr_kpi_settings`.*
`hr_kpi_settings`.`id`
`hr_kpi_settings`.`role_type`
`hr_kpi_settings`.`component_name`
`hr_kpi_settings`.`weight_percent`
`hr_users`.*
`hr_users`.`id`
`hr_users`.`username`
`hr_users`.`password`
`hr_users`.`name`
`hr_users`.`email`
`hr_users`.`phone`
`hr_users`.`role_id`
`hr_users`.`photo`
`hr_users`.`is_active`
`hr_users`.`last_login`
`hr_users`.`created_at`
`hr_users`.`updated_at`
`inv_inventory_transactions`.*
`inv_inventory_transactions`.`id`
`inv_inventory_transactions`.`sparepart_id`
`inv_inventory_transactions`.`transaction_type`
`inv_inventory_transactions`.`source`
`inv_inventory_transactions`.`source_id`
`inv_inventory_transactions`.`qty`
`inv_inventory_transactions`.`stock_before`
`inv_inventory_transactions`.`stock_after`
`inv_inventory_transactions`.`notes`
`inv_inventory_transactions`.`created_by`
`inv_inventory_transactions`.`created_at`
`inv_purchase_items`.*
`inv_purchase_items`.`id`
`inv_purchase_items`.`purchase_id`
`inv_purchase_items`.`sparepart_id`
`inv_purchase_items`.`qty`
`inv_purchase_items`.`cost_price`
`inv_purchase_items`.`subtotal`
`inv_purchases`.*
`inv_purchases`.`id`
`inv_purchases`.`purchase_number`
`inv_purchases`.`supplier_id`
`inv_purchases`.`supplier_name`
`inv_purchases`.`total_amount`
`inv_purchases`.`status`
`inv_purchases`.`received_at`
`inv_purchases`.`created_by`
`inv_purchases`.`created_at`
`inv_spareparts`.*
`inv_spareparts`.`id`
`inv_spareparts`.`code`
`inv_spareparts`.`name`
`inv_spareparts`.`category`
`inv_spareparts`.`brand`
`inv_spareparts`.`price`
`inv_spareparts`.`cost_price`
`inv_spareparts`.`stock`
`inv_spareparts`.`min_stock`
`inv_spareparts`.`unit`
`inv_spareparts`.`is_active`
`inv_spareparts`.`created_at`
`inv_spareparts`.`updated_at`
`inv_stock_transfers`.*
`inv_stock_transfers`.`id`
`inv_stock_transfers`.`transfer_number`
`inv_stock_transfers`.`from_location`
`inv_stock_transfers`.`to_location`
`inv_stock_transfers`.`status`
`inv_stock_transfers`.`notes`
`inv_stock_transfers`.`created_at`
`mst_customer_devices`.*
`mst_customer_devices`.`id`
`mst_customer_devices`.`customer_id`
`mst_customer_devices`.`device_name`
`mst_customer_devices`.`brand`
`mst_customer_devices`.`model`
`mst_customer_devices`.`serial_number`
`mst_customer_devices`.`purchase_date`
`mst_customer_devices`.`warranty_expired`
`mst_customer_devices`.`notes`
`mst_customer_devices`.`is_active`
`mst_customer_devices`.`created_at`
`mst_customer_types`.*
`mst_customer_types`.`id`
`mst_customer_types`.`name`
`mst_customer_types`.`description`
`mst_customer_types`.`is_active`
`mst_customers`.*
`mst_customers`.`id`
`mst_customers`.`code`
`mst_customers`.`name`
`mst_customers`.`company`
`mst_customers`.`email`
`mst_customers`.`phone`
`mst_customers`.`address`
`mst_customers`.`city`
`mst_customers`.`customer_type_id`
`mst_customers`.`latitude`
`mst_customers`.`longitude`
`mst_customers`.`location_photo`
`mst_customers`.`favorite_teknisi_id`
`mst_customers`.`notes`
`mst_customers`.`is_active`
`mst_customers`.`created_by`
`mst_customers`.`created_at`
`mst_customers`.`updated_at`
`mst_project_statuses`.*
`mst_project_statuses`.`id`
`mst_project_statuses`.`name`
`mst_project_statuses`.`color`
`mst_project_statuses`.`is_closed`
`mst_project_statuses`.`sequence`
`mst_project_types`.*
`mst_project_types`.`id`
`mst_project_types`.`name`
`mst_project_types`.`code`
`mst_project_types`.`description`
`mst_project_types`.`default_margin`
`mst_project_types`.`is_active`
`mst_project_types`.`created_at`
`mst_service_types`.*
`mst_service_types`.`id`
`mst_service_types`.`name`
`mst_service_types`.`code`
`mst_service_types`.`description`
`mst_service_types`.`base_price`
`mst_service_types`.`is_active`
`mst_service_types`.`created_at`
`onsite_checkins`.*
`onsite_checkins`.`id`
`onsite_checkins`.`ticket_id`
`onsite_checkins`.`teknisi_id`
`onsite_checkins`.`checkin_type`
`onsite_checkins`.`latitude`
`onsite_checkins`.`longitude`
`onsite_checkins`.`address`
`onsite_checkins`.`checkin_time`
`onsite_checkins`.`checkout_time`
`onsite_checkins`.`duration_minutes`
`onsite_checkins`.`notes`
`onsite_checkins`.`created_at`
`onsite_checklists`.*
`onsite_checklists`.`id`
`onsite_checklists`.`ticket_id`
`onsite_checklists`.`checklist_item`
`onsite_checklists`.`is_checked`
`onsite_checklists`.`checked_by`
`onsite_checklists`.`checked_at`
`onsite_checklists`.`notes`
`onsite_checklists`.`created_at`
`onsite_expenses`.*
`onsite_expenses`.`id`
`onsite_expenses`.`ticket_id`
`onsite_expenses`.`teknisi_id`
`onsite_expenses`.`expense_type`
`onsite_expenses`.`amount`
`onsite_expenses`.`description`
`onsite_expenses`.`receipt_url`
`onsite_expenses`.`is_approved`
`onsite_expenses`.`approved_by`
`onsite_expenses`.`approved_at`
`onsite_expenses`.`created_by`
`onsite_expenses`.`created_at`
`onsite_photos`.*
`onsite_photos`.`id`
`onsite_photos`.`ticket_id`
`onsite_photos`.`onsite_checkin_id`
`onsite_photos`.`photo_type`
`onsite_photos`.`photo_url`
`onsite_photos`.`description`
`onsite_photos`.`uploaded_by`
`onsite_photos`.`created_at`
`onsite_reports`.*
`onsite_reports`.`id`
`onsite_reports`.`ticket_id`
`onsite_reports`.`report_number`
`onsite_reports`.`report_data`
`onsite_reports`.`pdf_url`
`onsite_reports`.`is_generated`
`onsite_reports`.`generated_by`
`onsite_reports`.`generated_at`
`onsite_reports`.`created_at`
`onsite_signatures`.*
`onsite_signatures`.`id`
`onsite_signatures`.`ticket_id`
`onsite_signatures`.`signature_type`
`onsite_signatures`.`signature_data`
`onsite_signatures`.`signer_name`
`onsite_signatures`.`signer_phone`
`onsite_signatures`.`signed_at`
`onsite_signatures`.`ip_address`
`onsite_signatures`.`created_at`
`pos_order_items`.*
`pos_order_items`.`id`
`pos_order_items`.`order_id`
`pos_order_items`.`sparepart_id`
`pos_order_items`.`sparepart_code`
`pos_order_items`.`sparepart_name`
`pos_order_items`.`price`
`pos_order_items`.`cost_price`
`pos_order_items`.`quantity`
`pos_order_items`.`discount`
`pos_order_items`.`subtotal`
`pos_orders`.*
`pos_orders`.`id`
`pos_orders`.`order_number`
`pos_orders`.`session_id`
`pos_orders`.`customer_id`
`pos_orders`.`customer_name`
`pos_orders`.`customer_phone`
`pos_orders`.`subtotal`
`pos_orders`.`discount`
`pos_orders`.`tax`
`pos_orders`.`total`
`pos_orders`.`payment_method`
`pos_orders`.`amount_paid`
`pos_orders`.`change_due`
`pos_orders`.`status`
`pos_orders`.`notes`
`pos_orders`.`created_by`
`pos_orders`.`created_at`
`pos_orders`.`completed_at`
`pos_sessions`.*
`pos_sessions`.`id`
`pos_sessions`.`user_id`
`pos_sessions`.`start_time`
`pos_sessions`.`end_time`
`pos_sessions`.`starting_cash`
`pos_sessions`.`ending_cash`
`pos_sessions`.`status`
`pos_sessions`.`notes`
`prj_project_history`.*
`prj_project_history`.`id`
`prj_project_history`.`project_id`
`prj_project_history`.`action`
`prj_project_history`.`description`
`prj_project_history`.`old_value`
`prj_project_history`.`new_value`
`prj_project_history`.`user_id`
`prj_project_history`.`created_at`
`prj_project_invoices`.*
`prj_project_invoices`.`id`
`prj_project_invoices`.`project_id`
`prj_project_invoices`.`invoice_number`
`prj_project_invoices`.`jumlah`
`prj_project_invoices`.`status`
`prj_project_invoices`.`due_date`
`prj_project_invoices`.`paid_at`
`prj_project_invoices`.`created_at`
`prj_project_members`.*
`prj_project_members`.`id`
`prj_project_members`.`project_id`
`prj_project_members`.`user_id`
`prj_project_members`.`role`
`prj_project_members`.`assigned_at`
`prj_project_progress`.*
`prj_project_progress`.`id`
`prj_project_progress`.`project_id`
`prj_project_progress`.`percent`
`prj_project_progress`.`description`
`prj_project_progress`.`photo`
`prj_project_progress`.`created_by`
`prj_project_progress`.`created_at`
`prj_project_purchases`.*
`prj_project_purchases`.`id`
`prj_project_purchases`.`project_id`
`prj_project_purchases`.`item_name`
`prj_project_purchases`.`qty`
`prj_project_purchases`.`satuan`
`prj_project_purchases`.`harga_satuan`
`prj_project_purchases`.`total`
`prj_project_purchases`.`supplier`
`prj_project_purchases`.`status`
`prj_project_purchases`.`created_at`
`prj_projects`.*
`prj_projects`.`id`
`prj_projects`.`project_number`
`prj_projects`.`project_name`
`prj_projects`.`customer_id`
`prj_projects`.`project_type_id`
`prj_projects`.`status_id`
`prj_projects`.`pm_id`
`prj_projects`.`start_date`
`prj_projects`.`end_date`
`prj_projects`.`survey_date`
`prj_projects`.`deal_date`
`prj_projects`.`completed_date`
`prj_projects`.`nilai_rab`
`prj_projects`.`nilai_penawaran`
`prj_projects`.`nilai_deal`
`prj_projects`.`biaya_barang`
`prj_projects`.`biaya_tenaga`
`prj_projects`.`biaya_transport`
`prj_projects`.`fee_marketing`
`prj_projects`.`total_cost`
`prj_projects`.`laba_rugi`
`prj_projects`.`margin_persen`
`prj_projects`.`description`
`prj_projects`.`location`
`prj_projects`.`notes`
`prj_projects`.`survey_file`
`prj_projects`.`rab_file`
`prj_projects`.`penawaran_file`
`prj_projects`.`kontrak_file`
`prj_projects`.`bast_file`
`prj_projects`.`created_by`
`prj_projects`.`created_at`
`prj_projects`.`updated_at`
`prj_v_project_stats`.*
`prj_v_project_stats`.`lead_baru`
`prj_v_project_stats`.`menunggu_deal`
`prj_v_project_stats`.`project_aktif`
`prj_v_project_stats`.`project_selesai`
`prj_v_project_stats`.`total_nilai_proyek`
`prj_v_project_stats`.`total_laba_tahun`
`sys_settings`.*
`sys_settings`.`id`
`sys_settings`.`setting_key`
`sys_settings`.`setting_value`
`sys_settings`.`description`
`sys_settings`.`created_at`
`sys_settings`.`updated_at`
`sys_wa_queue`.*
`sys_wa_queue`.`id`
`sys_wa_queue`.`phone`
`sys_wa_queue`.`message`
`sys_wa_queue`.`message_type`
`sys_wa_queue`.`priority`
`sys_wa_queue`.`status`
`sys_wa_queue`.`error_message`
`sys_wa_queue`.`created_at`
`sys_wa_queue`.`sent_at`
`sys_wa_queue`.`updated_at`
`trx_invoice_details`.*
`trx_invoice_details`.`id`
`trx_invoice_details`.`invoice_id`
`trx_invoice_details`.`item_type`
`trx_invoice_details`.`item_id`
`trx_invoice_details`.`item_name`
`trx_invoice_details`.`quantity`
`trx_invoice_details`.`price`
`trx_invoice_details`.`subtotal`
`trx_invoices`.*
`trx_invoices`.`id`
`trx_invoices`.`invoice_number`
`trx_invoices`.`ticket_id`
`trx_invoices`.`customer_id`
`trx_invoices`.`service_fee`
`trx_invoices`.`sparepart_fee`
`trx_invoices`.`discount`
`trx_invoices`.`tax`
`trx_invoices`.`total_amount`
`trx_invoices`.`final_amount`
`trx_invoices`.`status`
`trx_invoices`.`payment_method`
`trx_invoices`.`paid_at`
`trx_invoices`.`due_date`
`trx_invoices`.`notes`
`trx_invoices`.`created_by`
`trx_invoices`.`created_at`
`trx_invoices`.`updated_at`
`trx_jobs`.*
`trx_jobs`.`id`
`trx_jobs`.`job_number`
`trx_jobs`.`ticket_id`
`trx_jobs`.`title`
`trx_jobs`.`description`
`trx_jobs`.`assigned_to`
`trx_jobs`.`status_id`
`trx_jobs`.`notes`
`trx_jobs`.`started_at`
`trx_jobs`.`completed_at`
`trx_jobs`.`created_at`
`trx_jobs`.`updated_at`
`trx_ticket_history`.*
`trx_ticket_history`.`id`
`trx_ticket_history`.`ticket_id`
`trx_ticket_history`.`user_id`
`trx_ticket_history`.`action`
`trx_ticket_history`.`description`
`trx_ticket_history`.`old_value`
`trx_ticket_history`.`new_value`
`trx_ticket_history`.`created_at`
`trx_ticket_spareparts`.*
`trx_ticket_spareparts`.`id`
`trx_ticket_spareparts`.`ticket_id`
`trx_ticket_spareparts`.`sparepart_id`
`trx_ticket_spareparts`.`quantity`
`trx_ticket_spareparts`.`price`
`trx_ticket_spareparts`.`subtotal`
`trx_ticket_spareparts`.`created_at`
`trx_tickets`.*
`trx_tickets`.`id`
`trx_tickets`.`ticket_number`
`trx_tickets`.`customer_id`
`trx_tickets`.`service_type_id`
`trx_tickets`.`teknisi_id`
`trx_tickets`.`title`
`trx_tickets`.`description`
`trx_tickets`.`status_id`
`trx_tickets`.`priority_id`
`trx_tickets`.`estimated_price`
`trx_tickets`.`final_price`
`trx_tickets`.`device_brand`
`trx_tickets`.`device_model`
`trx_tickets`.`device_sn`
`trx_tickets`.`accessories`
`trx_tickets`.`notes`
`trx_tickets`.`scheduled_date`
`trx_tickets`.`scheduled_time`
`trx_tickets`.`started_at`
`trx_tickets`.`completed_at`
`trx_tickets`.`created_by`
`trx_tickets`.`created_at`
`trx_tickets`.`updated_at`
`v_dashboard_stats`.*
`v_dashboard_stats`.`tickets_today`
`v_dashboard_stats`.`tickets_baru`
`v_dashboard_stats`.`tickets_proses`
`v_dashboard_stats`.`tickets_waiting`
`v_dashboard_stats`.`revenue_month`
`v_dashboard_stats`.`revenue_year`
`v_dashboard_stats`.`completed_today`
`v_dashboard_stats`.`total_customers`
`v_dashboard_stats`.`total_teknisi`
`acc_assets`.*
`acc_assets`.`id`
`acc_assets`.`name`
`acc_assets`.`purchase_date`
`acc_assets`.`purchase_value`
`acc_assets`.`useful_life_months`
`acc_assets`.`residual_value`
`acc_assets`.`status`
`acc_assets`.`created_at`
`acc_coa`.*
`acc_coa`.`id`
`acc_coa`.`code`
`acc_coa`.`name`
`acc_coa`.`type`
`acc_coa`.`is_active`
`acc_journal_entries`.*
`acc_journal_entries`.`id`
`acc_journal_entries`.`entry_date`
`acc_journal_entries`.`description`
`acc_journal_entries`.`reference_type`
`acc_journal_entries`.`reference_id`
`acc_journal_entries`.`created_by`
`acc_journal_entries`.`created_at`
`acc_journal_items`.*
`acc_journal_items`.`id`
`acc_journal_items`.`entry_id`
`acc_journal_items`.`coa_id`
`acc_journal_items`.`debit`
`acc_journal_items`.`credit`
`employee_kpis`.*
`employee_kpis`.`id`
`employee_kpis`.`user_id`
`employee_kpis`.`role_type`
`employee_kpis`.`month`
`employee_kpis`.`year`
`employee_kpis`.`attendance_score`
`employee_kpis`.`discipline_notes`
`employee_kpis`.`tickets_completed`
`employee_kpis`.`avg_speed_minutes`
`employee_kpis`.`rating_avg`
`employee_kpis`.`punctuality_score`
`employee_kpis`.`complaints_count`
`employee_kpis`.`revenue_generated`
`employee_kpis`.`efficiency_percent`
`employee_kpis`.`invoices_completed`
`employee_kpis`.`avg_response_time_mins`
`employee_kpis`.`input_errors_count`
`employee_kpis`.`report_closing_status`
`employee_kpis`.`schedule_order_score`
`employee_kpis`.`cashflow_accuracy`
`employee_kpis`.`ar_collection_rate`
`employee_kpis`.`report_delay_days`
`employee_kpis`.`cash_diff_amount`
`employee_kpis`.`final_kpi_score`
`employee_kpis`.`updated_at`
`hr_complaints`.*
`hr_complaints`.`id`
`hr_complaints`.`ticket_id`
`hr_complaints`.`user_id`
`hr_complaints`.`customer_id`
`hr_complaints`.`description`
`hr_complaints`.`severity`
`hr_complaints`.`status`
`hr_complaints`.`created_at`
`hr_kpi_settings`.*
`hr_kpi_settings`.`id`
`hr_kpi_settings`.`role_type`
`hr_kpi_settings`.`component_name`
`hr_kpi_settings`.`weight_percent`
`hr_users`.*
`hr_users`.`id`
`hr_users`.`username`
`hr_users`.`password`
`hr_users`.`name`
`hr_users`.`email`
`hr_users`.`phone`
`hr_users`.`role_id`
`hr_users`.`photo`
`hr_users`.`is_active`
`hr_users`.`last_login`
`hr_users`.`created_at`
`hr_users`.`updated_at`
`inv_inventory_transactions`.*
`inv_inventory_transactions`.`id`
`inv_inventory_transactions`.`sparepart_id`
`inv_inventory_transactions`.`transaction_type`
`inv_inventory_transactions`.`source`
`inv_inventory_transactions`.`source_id`
`inv_inventory_transactions`.`qty`
`inv_inventory_transactions`.`stock_before`
`inv_inventory_transactions`.`stock_after`
`inv_inventory_transactions`.`notes`
`inv_inventory_transactions`.`created_by`
`inv_inventory_transactions`.`created_at`
`inv_purchase_items`.*
`inv_purchase_items`.`id`
`inv_purchase_items`.`purchase_id`
`inv_purchase_items`.`sparepart_id`
`inv_purchase_items`.`qty`
`inv_purchase_items`.`cost_price`
`inv_purchase_items`.`subtotal`
`inv_purchases`.*
`inv_purchases`.`id`
`inv_purchases`.`purchase_number`
`inv_purchases`.`supplier_id`
`inv_purchases`.`supplier_name`
`inv_purchases`.`total_amount`
`inv_purchases`.`status`
`inv_purchases`.`received_at`
`inv_purchases`.`created_by`
`inv_purchases`.`created_at`
`inv_spareparts`.*
`inv_spareparts`.`id`
`inv_spareparts`.`code`
`inv_spareparts`.`name`
`inv_spareparts`.`category`
`inv_spareparts`.`brand`
`inv_spareparts`.`price`
`inv_spareparts`.`cost_price`
`inv_spareparts`.`stock`
`inv_spareparts`.`min_stock`
`inv_spareparts`.`unit`
`inv_spareparts`.`is_active`
`inv_spareparts`.`created_at`
`inv_spareparts`.`updated_at`
`inv_stock_transfers`.*
`inv_stock_transfers`.`id`
`inv_stock_transfers`.`transfer_number`
`inv_stock_transfers`.`from_location`
`inv_stock_transfers`.`to_location`
`inv_stock_transfers`.`status`
`inv_stock_transfers`.`notes`
`inv_stock_transfers`.`created_at`
`mst_customer_devices`.*
`mst_customer_devices`.`id`
`mst_customer_devices`.`customer_id`
`mst_customer_devices`.`device_name`
`mst_customer_devices`.`brand`
`mst_customer_devices`.`model`
`mst_customer_devices`.`serial_number`
`mst_customer_devices`.`purchase_date`
`mst_customer_devices`.`warranty_expired`
`mst_customer_devices`.`notes`
`mst_customer_devices`.`is_active`
`mst_customer_devices`.`created_at`
`mst_customer_types`.*
`mst_customer_types`.`id`
`mst_customer_types`.`name`
`mst_customer_types`.`description`
`mst_customer_types`.`is_active`
`mst_customers`.*
`mst_customers`.`id`
`mst_customers`.`code`
`mst_customers`.`name`
`mst_customers`.`company`
`mst_customers`.`email`
`mst_customers`.`phone`
`mst_customers`.`address`
`mst_customers`.`city`
`mst_customers`.`customer_type_id`
`mst_customers`.`latitude`
`mst_customers`.`longitude`
`mst_customers`.`location_photo`
`mst_customers`.`favorite_teknisi_id`
`mst_customers`.`notes`
`mst_customers`.`is_active`
`mst_customers`.`created_by`
`mst_customers`.`created_at`
`mst_customers`.`updated_at`
`mst_project_statuses`.*
`mst_project_statuses`.`id`
`mst_project_statuses`.`name`
`mst_project_statuses`.`color`
`mst_project_statuses`.`is_closed`
`mst_project_statuses`.`sequence`
`mst_project_types`.*
`mst_project_types`.`id`
`mst_project_types`.`name`
`mst_project_types`.`code`
`mst_project_types`.`description`
`mst_project_types`.`default_margin`
`mst_project_types`.`is_active`
`mst_project_types`.`created_at`
`mst_service_types`.*
`mst_service_types`.`id`
`mst_service_types`.`name`
`mst_service_types`.`code`
`mst_service_types`.`description`
`mst_service_types`.`base_price`
`mst_service_types`.`is_active`
`mst_service_types`.`created_at`
`onsite_checkins`.*
`onsite_checkins`.`id`
`onsite_checkins`.`ticket_id`
`onsite_checkins`.`teknisi_id`
`onsite_checkins`.`checkin_type`
`onsite_checkins`.`latitude`
`onsite_checkins`.`longitude`
`onsite_checkins`.`address`
`onsite_checkins`.`checkin_time`
`onsite_checkins`.`checkout_time`
`onsite_checkins`.`duration_minutes`
`onsite_checkins`.`notes`
`onsite_checkins`.`created_at`
`onsite_checklists`.*
`onsite_checklists`.`id`
`onsite_checklists`.`ticket_id`
`onsite_checklists`.`checklist_item`
`onsite_checklists`.`is_checked`
`onsite_checklists`.`checked_by`
`onsite_checklists`.`checked_at`
`onsite_checklists`.`notes`
`onsite_checklists`.`created_at`
`onsite_expenses`.*
`onsite_expenses`.`id`
`onsite_expenses`.`ticket_id`
`onsite_expenses`.`teknisi_id`
`onsite_expenses`.`expense_type`
`onsite_expenses`.`amount`
`onsite_expenses`.`description`
`onsite_expenses`.`receipt_url`
`onsite_expenses`.`is_approved`
`onsite_expenses`.`approved_by`
`onsite_expenses`.`approved_at`
`onsite_expenses`.`created_by`
`onsite_expenses`.`created_at`
`onsite_photos`.*
`onsite_photos`.`id`
`onsite_photos`.`ticket_id`
`onsite_photos`.`onsite_checkin_id`
`onsite_photos`.`photo_type`
`onsite_photos`.`photo_url`
`onsite_photos`.`description`
`onsite_photos`.`uploaded_by`
`onsite_photos`.`created_at`
`onsite_reports`.*
`onsite_reports`.`id`
`onsite_reports`.`ticket_id`
`onsite_reports`.`report_number`
`onsite_reports`.`report_data`
`onsite_reports`.`pdf_url`
`onsite_reports`.`is_generated`
`onsite_reports`.`generated_by`
`onsite_reports`.`generated_at`
`onsite_reports`.`created_at`
`onsite_signatures`.*
`onsite_signatures`.`id`
`onsite_signatures`.`ticket_id`
`onsite_signatures`.`signature_type`
`onsite_signatures`.`signature_data`
`onsite_signatures`.`signer_name`
`onsite_signatures`.`signer_phone`
`onsite_signatures`.`signed_at`
`onsite_signatures`.`ip_address`
`onsite_signatures`.`created_at`
`pos_order_items`.*
`pos_order_items`.`id`
`pos_order_items`.`order_id`
`pos_order_items`.`sparepart_id`
`pos_order_items`.`sparepart_code`
`pos_order_items`.`sparepart_name`
`pos_order_items`.`price`
`pos_order_items`.`cost_price`
`pos_order_items`.`quantity`
`pos_order_items`.`discount`
`pos_order_items`.`subtotal`
`pos_orders`.*
`pos_orders`.`id`
`pos_orders`.`order_number`
`pos_orders`.`session_id`
`pos_orders`.`customer_id`
`pos_orders`.`customer_name`
`pos_orders`.`customer_phone`
`pos_orders`.`subtotal`
`pos_orders`.`discount`
`pos_orders`.`tax`
`pos_orders`.`total`
`pos_orders`.`payment_method`
`pos_orders`.`amount_paid`
`pos_orders`.`change_due`
`pos_orders`.`status`
`pos_orders`.`notes`
`pos_orders`.`created_by`
`pos_orders`.`created_at`
`pos_orders`.`completed_at`
`pos_sessions`.*
`pos_sessions`.`id`
`pos_sessions`.`user_id`
`pos_sessions`.`start_time`
`pos_sessions`.`end_time`
`pos_sessions`.`starting_cash`
`pos_sessions`.`ending_cash`
`pos_sessions`.`status`
`pos_sessions`.`notes`
`prj_project_history`.*
`prj_project_history`.`id`
`prj_project_history`.`project_id`
`prj_project_history`.`action`
`prj_project_history`.`description`
`prj_project_history`.`old_value`
`prj_project_history`.`new_value`
`prj_project_history`.`user_id`
`prj_project_history`.`created_at`
`prj_project_invoices`.*
`prj_project_invoices`.`id`
`prj_project_invoices`.`project_id`
`prj_project_invoices`.`invoice_number`
`prj_project_invoices`.`jumlah`
`prj_project_invoices`.`status`
`prj_project_invoices`.`due_date`
`prj_project_invoices`.`paid_at`
`prj_project_invoices`.`created_at`
`prj_project_members`.*
`prj_project_members`.`id`
`prj_project_members`.`project_id`
`prj_project_members`.`user_id`
`prj_project_members`.`role`
`prj_project_members`.`assigned_at`
`prj_project_progress`.*
`prj_project_progress`.`id`
`prj_project_progress`.`project_id`
`prj_project_progress`.`percent`
`prj_project_progress`.`description`
`prj_project_progress`.`photo`
`prj_project_progress`.`created_by`
`prj_project_progress`.`created_at`
`prj_project_purchases`.*
`prj_project_purchases`.`id`
`prj_project_purchases`.`project_id`
`prj_project_purchases`.`item_name`
`prj_project_purchases`.`qty`
`prj_project_purchases`.`satuan`
`prj_project_purchases`.`harga_satuan`
`prj_project_purchases`.`total`
`prj_project_purchases`.`supplier`
`prj_project_purchases`.`status`
`prj_project_purchases`.`created_at`
`prj_projects`.*
`prj_projects`.`id`
`prj_projects`.`project_number`
`prj_projects`.`project_name`
`prj_projects`.`customer_id`
`prj_projects`.`project_type_id`
`prj_projects`.`status_id`
`prj_projects`.`pm_id`
`prj_projects`.`start_date`
`prj_projects`.`end_date`
`prj_projects`.`survey_date`
`prj_projects`.`deal_date`
`prj_projects`.`completed_date`
`prj_projects`.`nilai_rab`
`prj_projects`.`nilai_penawaran`
`prj_projects`.`nilai_deal`
`prj_projects`.`biaya_barang`
`prj_projects`.`biaya_tenaga`
`prj_projects`.`biaya_transport`
`prj_projects`.`fee_marketing`
`prj_projects`.`total_cost`
`prj_projects`.`laba_rugi`
`prj_projects`.`margin_persen`
`prj_projects`.`description`
`prj_projects`.`location`
`prj_projects`.`notes`
`prj_projects`.`survey_file`
`prj_projects`.`rab_file`
`prj_projects`.`penawaran_file`
`prj_projects`.`kontrak_file`
`prj_projects`.`bast_file`
`prj_projects`.`created_by`
`prj_projects`.`created_at`
`prj_projects`.`updated_at`
`prj_v_project_stats`.*
`prj_v_project_stats`.`lead_baru`
`prj_v_project_stats`.`menunggu_deal`
`prj_v_project_stats`.`project_aktif`
`prj_v_project_stats`.`project_selesai`
`prj_v_project_stats`.`total_nilai_proyek`
`prj_v_project_stats`.`total_laba_tahun`
`sys_settings`.*
`sys_settings`.`id`
`sys_settings`.`setting_key`
`sys_settings`.`setting_value`
`sys_settings`.`description`
`sys_settings`.`created_at`
`sys_settings`.`updated_at`
`sys_wa_queue`.*
`sys_wa_queue`.`id`
`sys_wa_queue`.`phone`
`sys_wa_queue`.`message`
`sys_wa_queue`.`message_type`
`sys_wa_queue`.`priority`
`sys_wa_queue`.`status`
`sys_wa_queue`.`error_message`
`sys_wa_queue`.`created_at`
`sys_wa_queue`.`sent_at`
`sys_wa_queue`.`updated_at`
`trx_invoice_details`.*
`trx_invoice_details`.`id`
`trx_invoice_details`.`invoice_id`
`trx_invoice_details`.`item_type`
`trx_invoice_details`.`item_id`
`trx_invoice_details`.`item_name`
`trx_invoice_details`.`quantity`
`trx_invoice_details`.`price`
`trx_invoice_details`.`subtotal`
`trx_invoices`.*
`trx_invoices`.`id`
`trx_invoices`.`invoice_number`
`trx_invoices`.`ticket_id`
`trx_invoices`.`customer_id`
`trx_invoices`.`service_fee`
`trx_invoices`.`sparepart_fee`
`trx_invoices`.`discount`
`trx_invoices`.`tax`
`trx_invoices`.`total_amount`
`trx_invoices`.`final_amount`
`trx_invoices`.`status`
`trx_invoices`.`payment_method`
`trx_invoices`.`paid_at`
`trx_invoices`.`due_date`
`trx_invoices`.`notes`
`trx_invoices`.`created_by`
`trx_invoices`.`created_at`
`trx_invoices`.`updated_at`
`trx_jobs`.*
`trx_jobs`.`id`
`trx_jobs`.`job_number`
`trx_jobs`.`ticket_id`
`trx_jobs`.`title`
`trx_jobs`.`description`
`trx_jobs`.`assigned_to`
`trx_jobs`.`status_id`
`trx_jobs`.`notes`
`trx_jobs`.`started_at`
`trx_jobs`.`completed_at`
`trx_jobs`.`created_at`
`trx_jobs`.`updated_at`
`trx_ticket_history`.*
`trx_ticket_history`.`id`
`trx_ticket_history`.`ticket_id`
`trx_ticket_history`.`user_id`
`trx_ticket_history`.`action`
`trx_ticket_history`.`description`
`trx_ticket_history`.`old_value`
`trx_ticket_history`.`new_value`
`trx_ticket_history`.`created_at`
`trx_ticket_spareparts`.*
`trx_ticket_spareparts`.`id`
`trx_ticket_spareparts`.`ticket_id`
`trx_ticket_spareparts`.`sparepart_id`
`trx_ticket_spareparts`.`quantity`
`trx_ticket_spareparts`.`price`
`trx_ticket_spareparts`.`subtotal`
`trx_ticket_spareparts`.`created_at`
`trx_tickets`.*
`trx_tickets`.`id`
`trx_tickets`.`ticket_number`
`trx_tickets`.`customer_id`
`trx_tickets`.`service_type_id`
`trx_tickets`.`teknisi_id`
`trx_tickets`.`title`
`trx_tickets`.`description`
`trx_tickets`.`status_id`
`trx_tickets`.`priority_id`
`trx_tickets`.`estimated_price`
`trx_tickets`.`final_price`
`trx_tickets`.`device_brand`
`trx_tickets`.`device_model`
`trx_tickets`.`device_sn`
`trx_tickets`.`accessories`
`trx_tickets`.`notes`
`trx_tickets`.`scheduled_date`
`trx_tickets`.`scheduled_time`
`trx_tickets`.`started_at`
`trx_tickets`.`completed_at`
`trx_tickets`.`created_by`
`trx_tickets`.`created_at`
`trx_tickets`.`updated_at`
`v_dashboard_stats`.*
`v_dashboard_stats`.`tickets_today`
`v_dashboard_stats`.`tickets_baru`
`v_dashboard_stats`.`tickets_proses`
`v_dashboard_stats`.`tickets_waiting`
`v_dashboard_stats`.`revenue_month`
`v_dashboard_stats`.`revenue_year`
`v_dashboard_stats`.`completed_today`
`v_dashboard_stats`.`total_customers`
`v_dashboard_stats`.`total_teknisi`
`acc_assets`.*
`acc_assets`.`id`
`acc_assets`.`name`
`acc_assets`.`purchase_date`
`acc_assets`.`purchase_value`
`acc_assets`.`useful_life_months`
`acc_assets`.`residual_value`
`acc_assets`.`status`
`acc_assets`.`created_at`
`acc_coa`.*
`acc_coa`.`id`
`acc_coa`.`code`
`acc_coa`.`name`
`acc_coa`.`type`
`acc_coa`.`is_active`
`acc_journal_entries`.*
`acc_journal_entries`.`id`
`acc_journal_entries`.`entry_date`
`acc_journal_entries`.`description`
`acc_journal_entries`.`reference_type`
`acc_journal_entries`.`reference_id`
`acc_journal_entries`.`created_by`
`acc_journal_entries`.`created_at`
`acc_journal_items`.*
`acc_journal_items`.`id`
`acc_journal_items`.`entry_id`
`acc_journal_items`.`coa_id`
`acc_journal_items`.`debit`
`acc_journal_items`.`credit`
`employee_kpis`.*
`employee_kpis`.`id`
`employee_kpis`.`user_id`
`employee_kpis`.`role_type`
`employee_kpis`.`month`
`employee_kpis`.`year`
`employee_kpis`.`attendance_score`
`employee_kpis`.`discipline_notes`
`employee_kpis`.`tickets_completed`
`employee_kpis`.`avg_speed_minutes`
`employee_kpis`.`rating_avg`
`employee_kpis`.`punctuality_score`
`employee_kpis`.`complaints_count`
`employee_kpis`.`revenue_generated`
`employee_kpis`.`efficiency_percent`
`employee_kpis`.`invoices_completed`
`employee_kpis`.`avg_response_time_mins`
`employee_kpis`.`input_errors_count`
`employee_kpis`.`report_closing_status`
`employee_kpis`.`schedule_order_score`
`employee_kpis`.`cashflow_accuracy`
`employee_kpis`.`ar_collection_rate`
`employee_kpis`.`report_delay_days`
`employee_kpis`.`cash_diff_amount`
`employee_kpis`.`final_kpi_score`
`employee_kpis`.`updated_at`
`hr_complaints`.*
`hr_complaints`.`id`
`hr_complaints`.`ticket_id`
`hr_complaints`.`user_id`
`hr_complaints`.`customer_id`
`hr_complaints`.`description`
`hr_complaints`.`severity`
`hr_complaints`.`status`
`hr_complaints`.`created_at`
`hr_kpi_settings`.*
`hr_kpi_settings`.`id`
`hr_kpi_settings`.`role_type`
`hr_kpi_settings`.`component_name`
`hr_kpi_settings`.`weight_percent`
`hr_users`.*
`hr_users`.`id`
`hr_users`.`username`
`hr_users`.`password`
`hr_users`.`name`
`hr_users`.`email`
`hr_users`.`phone`
`hr_users`.`role_id`
`hr_users`.`photo`
`hr_users`.`is_active`
`hr_users`.`last_login`
`hr_users`.`created_at`
`hr_users`.`updated_at`
`inv_inventory_transactions`.*
`inv_inventory_transactions`.`id`
`inv_inventory_transactions`.`sparepart_id`
`inv_inventory_transactions`.`transaction_type`
`inv_inventory_transactions`.`source`
`inv_inventory_transactions`.`source_id`
`inv_inventory_transactions`.`qty`
`inv_inventory_transactions`.`stock_before`
`inv_inventory_transactions`.`stock_after`
`inv_inventory_transactions`.`notes`
`inv_inventory_transactions`.`created_by`
`inv_inventory_transactions`.`created_at`
`inv_purchase_items`.*
`inv_purchase_items`.`id`
`inv_purchase_items`.`purchase_id`
`inv_purchase_items`.`sparepart_id`
`inv_purchase_items`.`qty`
`inv_purchase_items`.`cost_price`
`inv_purchase_items`.`subtotal`
`inv_purchases`.*
`inv_purchases`.`id`
`inv_purchases`.`purchase_number`
`inv_purchases`.`supplier_id`
`inv_purchases`.`supplier_name`
`inv_purchases`.`total_amount`
`inv_purchases`.`status`
`inv_purchases`.`received_at`
`inv_purchases`.`created_by`
`inv_purchases`.`created_at`
`inv_spareparts`.*
`inv_spareparts`.`id`
`inv_spareparts`.`code`
`inv_spareparts`.`name`
`inv_spareparts`.`category`
`inv_spareparts`.`brand`
`inv_spareparts`.`price`
`inv_spareparts`.`cost_price`
`inv_spareparts`.`stock`
`inv_spareparts`.`min_stock`
`inv_spareparts`.`unit`
`inv_spareparts`.`is_active`
`inv_spareparts`.`created_at`
`inv_spareparts`.`updated_at`
`inv_stock_transfers`.*
`inv_stock_transfers`.`id`
`inv_stock_transfers`.`transfer_number`
`inv_stock_transfers`.`from_location`
`inv_stock_transfers`.`to_location`
`inv_stock_transfers`.`status`
`inv_stock_transfers`.`notes`
`inv_stock_transfers`.`created_at`
`mst_customer_devices`.*
`mst_customer_devices`.`id`
`mst_customer_devices`.`customer_id`
`mst_customer_devices`.`device_name`
`mst_customer_devices`.`brand`
`mst_customer_devices`.`model`
`mst_customer_devices`.`serial_number`
`mst_customer_devices`.`purchase_date`
`mst_customer_devices`.`warranty_expired`
`mst_customer_devices`.`notes`
`mst_customer_devices`.`is_active`
`mst_customer_devices`.`created_at`
`mst_customer_types`.*
`mst_customer_types`.`id`
`mst_customer_types`.`name`
`mst_customer_types`.`description`
`mst_customer_types`.`is_active`
`mst_customers`.*
`mst_customers`.`id`
`mst_customers`.`code`
`mst_customers`.`name`
`mst_customers`.`company`
`mst_customers`.`email`
`mst_customers`.`phone`
`mst_customers`.`address`
`mst_customers`.`city`
`mst_customers`.`customer_type_id`
`mst_customers`.`latitude`
`mst_customers`.`longitude`
`mst_customers`.`location_photo`
`mst_customers`.`favorite_teknisi_id`
`mst_customers`.`notes`
`mst_customers`.`is_active`
`mst_customers`.`created_by`
`mst_customers`.`created_at`
`mst_customers`.`updated_at`
`mst_project_statuses`.*
`mst_project_statuses`.`id`
`mst_project_statuses`.`name`
`mst_project_statuses`.`color`
`mst_project_statuses`.`is_closed`
`mst_project_statuses`.`sequence`
`mst_project_types`.*
`mst_project_types`.`id`
`mst_project_types`.`name`
`mst_project_types`.`code`
`mst_project_types`.`description`
`mst_project_types`.`default_margin`
`mst_project_types`.`is_active`
`mst_project_types`.`created_at`
`mst_service_types`.*
`mst_service_types`.`id`
`mst_service_types`.`name`
`mst_service_types`.`code`
`mst_service_types`.`description`
`mst_service_types`.`base_price`
`mst_service_types`.`is_active`
`mst_service_types`.`created_at`
`onsite_checkins`.*
`onsite_checkins`.`id`
`onsite_checkins`.`ticket_id`
`onsite_checkins`.`teknisi_id`
`onsite_checkins`.`checkin_type`
`onsite_checkins`.`latitude`
`onsite_checkins`.`longitude`
`onsite_checkins`.`address`
`onsite_checkins`.`checkin_time`
`onsite_checkins`.`checkout_time`
`onsite_checkins`.`duration_minutes`
`onsite_checkins`.`notes`
`onsite_checkins`.`created_at`
`onsite_checklists`.*
`onsite_checklists`.`id`
`onsite_checklists`.`ticket_id`
`onsite_checklists`.`checklist_item`
`onsite_checklists`.`is_checked`
`onsite_checklists`.`checked_by`
`onsite_checklists`.`checked_at`
`onsite_checklists`.`notes`
`onsite_checklists`.`created_at`
`onsite_expenses`.*
`onsite_expenses`.`id`
`onsite_expenses`.`ticket_id`
`onsite_expenses`.`teknisi_id`
`onsite_expenses`.`expense_type`
`onsite_expenses`.`amount`
`onsite_expenses`.`description`
`onsite_expenses`.`receipt_url`
`onsite_expenses`.`is_approved`
`onsite_expenses`.`approved_by`
`onsite_expenses`.`approved_at`
`onsite_expenses`.`created_by`
`onsite_expenses`.`created_at`
`onsite_photos`.*
`onsite_photos`.`id`
`onsite_photos`.`ticket_id`
`onsite_photos`.`onsite_checkin_id`
`onsite_photos`.`photo_type`
`onsite_photos`.`photo_url`
`onsite_photos`.`description`
`onsite_photos`.`uploaded_by`
`onsite_photos`.`created_at`
`onsite_reports`.*
`onsite_reports`.`id`
`onsite_reports`.`ticket_id`
`onsite_reports`.`report_number`
`onsite_reports`.`report_data`
`onsite_reports`.`pdf_url`
`onsite_reports`.`is_generated`
`onsite_reports`.`generated_by`
`onsite_reports`.`generated_at`
`onsite_reports`.`created_at`
`onsite_signatures`.*
`onsite_signatures`.`id`
`onsite_signatures`.`ticket_id`
`onsite_signatures`.`signature_type`
`onsite_signatures`.`signature_data`
`onsite_signatures`.`signer_name`
`onsite_signatures`.`signer_phone`
`onsite_signatures`.`signed_at`
`onsite_signatures`.`ip_address`
`onsite_signatures`.`created_at`
`pos_order_items`.*
`pos_order_items`.`id`
`pos_order_items`.`order_id`
`pos_order_items`.`sparepart_id`
`pos_order_items`.`sparepart_code`
`pos_order_items`.`sparepart_name`
`pos_order_items`.`price`
`pos_order_items`.`cost_price`
`pos_order_items`.`quantity`
`pos_order_items`.`discount`
`pos_order_items`.`subtotal`
`pos_orders`.*
`pos_orders`.`id`
`pos_orders`.`order_number`
`pos_orders`.`session_id`
`pos_orders`.`customer_id`
`pos_orders`.`customer_name`
`pos_orders`.`customer_phone`
`pos_orders`.`subtotal`
`pos_orders`.`discount`
`pos_orders`.`tax`
`pos_orders`.`total`
`pos_orders`.`payment_method`
`pos_orders`.`amount_paid`
`pos_orders`.`change_due`
`pos_orders`.`status`
`pos_orders`.`notes`
`pos_orders`.`created_by`
`pos_orders`.`created_at`
`pos_orders`.`completed_at`
`pos_sessions`.*
`pos_sessions`.`id`
`pos_sessions`.`user_id`
`pos_sessions`.`start_time`
`pos_sessions`.`end_time`
`pos_sessions`.`starting_cash`
`pos_sessions`.`ending_cash`
`pos_sessions`.`status`
`pos_sessions`.`notes`
`prj_project_history`.*
`prj_project_history`.`id`
`prj_project_history`.`project_id`
`prj_project_history`.`action`
`prj_project_history`.`description`
`prj_project_history`.`old_value`
`prj_project_history`.`new_value`
`prj_project_history`.`user_id`
`prj_project_history`.`created_at`
`prj_project_invoices`.*
`prj_project_invoices`.`id`
`prj_project_invoices`.`project_id`
`prj_project_invoices`.`invoice_number`
`prj_project_invoices`.`jumlah`
`prj_project_invoices`.`status`
`prj_project_invoices`.`due_date`
`prj_project_invoices`.`paid_at`
`prj_project_invoices`.`created_at`
`prj_project_members`.*
`prj_project_members`.`id`
`prj_project_members`.`project_id`
`prj_project_members`.`user_id`
`prj_project_members`.`role`
`prj_project_members`.`assigned_at`
`prj_project_progress`.*
`prj_project_progress`.`id`
`prj_project_progress`.`project_id`
`prj_project_progress`.`percent`
`prj_project_progress`.`description`
`prj_project_progress`.`photo`
`prj_project_progress`.`created_by`
`prj_project_progress`.`created_at`
`prj_project_purchases`.*
`prj_project_purchases`.`id`
`prj_project_purchases`.`project_id`
`prj_project_purchases`.`item_name`
`prj_project_purchases`.`qty`
`prj_project_purchases`.`satuan`
`prj_project_purchases`.`harga_satuan`
`prj_project_purchases`.`total`
`prj_project_purchases`.`supplier`
`prj_project_purchases`.`status`
`prj_project_purchases`.`created_at`
`prj_projects`.*
`prj_projects`.`id`
`prj_projects`.`project_number`
`prj_projects`.`project_name`
`prj_projects`.`customer_id`
`prj_projects`.`project_type_id`
`prj_projects`.`status_id`
`prj_projects`.`pm_id`
`prj_projects`.`start_date`
`prj_projects`.`end_date`
`prj_projects`.`survey_date`
`prj_projects`.`deal_date`
`prj_projects`.`completed_date`
`prj_projects`.`nilai_rab`
`prj_projects`.`nilai_penawaran`
`prj_projects`.`nilai_deal`
`prj_projects`.`biaya_barang`
`prj_projects`.`biaya_tenaga`
`prj_projects`.`biaya_transport`
`prj_projects`.`fee_marketing`
`prj_projects`.`total_cost`
`prj_projects`.`laba_rugi`
`prj_projects`.`margin_persen`
`prj_projects`.`description`
`prj_projects`.`location`
`prj_projects`.`notes`
`prj_projects`.`survey_file`
`prj_projects`.`rab_file`
`prj_projects`.`penawaran_file`
`prj_projects`.`kontrak_file`
`prj_projects`.`bast_file`
`prj_projects`.`created_by`
`prj_projects`.`created_at`
`prj_projects`.`updated_at`
`prj_v_project_stats`.*
`prj_v_project_stats`.`lead_baru`
`prj_v_project_stats`.`menunggu_deal`
`prj_v_project_stats`.`project_aktif`
`prj_v_project_stats`.`project_selesai`
`prj_v_project_stats`.`total_nilai_proyek`
`prj_v_project_stats`.`total_laba_tahun`
`sys_settings`.*
`sys_settings`.`id`
`sys_settings`.`setting_key`
`sys_settings`.`setting_value`
`sys_settings`.`description`
`sys_settings`.`created_at`
`sys_settings`.`updated_at`
`sys_wa_queue`.*
`sys_wa_queue`.`id`
`sys_wa_queue`.`phone`
`sys_wa_queue`.`message`
`sys_wa_queue`.`message_type`
`sys_wa_queue`.`priority`
`sys_wa_queue`.`status`
`sys_wa_queue`.`error_message`
`sys_wa_queue`.`created_at`
`sys_wa_queue`.`sent_at`
`sys_wa_queue`.`updated_at`
`trx_invoice_details`.*
`trx_invoice_details`.`id`
`trx_invoice_details`.`invoice_id`
`trx_invoice_details`.`item_type`
`trx_invoice_details`.`item_id`
`trx_invoice_details`.`item_name`
`trx_invoice_details`.`quantity`
`trx_invoice_details`.`price`
`trx_invoice_details`.`subtotal`
`trx_invoices`.*
`trx_invoices`.`id`
`trx_invoices`.`invoice_number`
`trx_invoices`.`ticket_id`
`trx_invoices`.`customer_id`
`trx_invoices`.`service_fee`
`trx_invoices`.`sparepart_fee`
`trx_invoices`.`discount`
`trx_invoices`.`tax`
`trx_invoices`.`total_amount`
`trx_invoices`.`final_amount`
`trx_invoices`.`status`
`trx_invoices`.`payment_method`
`trx_invoices`.`paid_at`
`trx_invoices`.`due_date`
`trx_invoices`.`notes`
`trx_invoices`.`created_by`
`trx_invoices`.`created_at`
`trx_invoices`.`updated_at`
`trx_jobs`.*
`trx_jobs`.`id`
`trx_jobs`.`job_number`
`trx_jobs`.`ticket_id`
`trx_jobs`.`title`
`trx_jobs`.`description`
`trx_jobs`.`assigned_to`
`trx_jobs`.`status_id`
`trx_jobs`.`notes`
`trx_jobs`.`started_at`
`trx_jobs`.`completed_at`
`trx_jobs`.`created_at`
`trx_jobs`.`updated_at`
`trx_ticket_history`.*
`trx_ticket_history`.`id`
`trx_ticket_history`.`ticket_id`
`trx_ticket_history`.`user_id`
`trx_ticket_history`.`action`
`trx_ticket_history`.`description`
`trx_ticket_history`.`old_value`
`trx_ticket_history`.`new_value`
`trx_ticket_history`.`created_at`
`trx_ticket_spareparts`.*
`trx_ticket_spareparts`.`id`
`trx_ticket_spareparts`.`ticket_id`
`trx_ticket_spareparts`.`sparepart_id`
`trx_ticket_spareparts`.`quantity`
`trx_ticket_spareparts`.`price`
`trx_ticket_spareparts`.`subtotal`
`trx_ticket_spareparts`.`created_at`
`trx_tickets`.*
`trx_tickets`.`id`
`trx_tickets`.`ticket_number`
`trx_tickets`.`customer_id`
`trx_tickets`.`service_type_id`
`trx_tickets`.`teknisi_id`
`trx_tickets`.`title`
`trx_tickets`.`description`
`trx_tickets`.`status_id`
`trx_tickets`.`priority_id`
`trx_tickets`.`estimated_price`
`trx_tickets`.`final_price`
`trx_tickets`.`device_brand`
`trx_tickets`.`device_model`
`trx_tickets`.`device_sn`
`trx_tickets`.`accessories`
`trx_tickets`.`notes`
`trx_tickets`.`scheduled_date`
`trx_tickets`.`scheduled_time`
`trx_tickets`.`started_at`
`trx_tickets`.`completed_at`
`trx_tickets`.`created_by`
`trx_tickets`.`created_at`
`trx_tickets`.`updated_at`
`v_dashboard_stats`.*
`v_dashboard_stats`.`tickets_today`
`v_dashboard_stats`.`tickets_baru`
`v_dashboard_stats`.`tickets_proses`
`v_dashboard_stats`.`tickets_waiting`
`v_dashboard_stats`.`revenue_month`
`v_dashboard_stats`.`revenue_year`
`v_dashboard_stats`.`completed_today`
`v_dashboard_stats`.`total_customers`
`v_dashboard_stats`.`total_teknisi`
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
acc_assets
acc_coa
acc_journal_entries
acc_journal_items
employee_kpis
hr_complaints
hr_kpi_settings
hr_users
inv_inventory_transactions
inv_purchase_items
inv_purchases
inv_spareparts
inv_stock_transfers
mst_customer_devices
mst_customer_types
mst_customers
mst_project_statuses
mst_project_types
mst_service_types
onsite_checkins
onsite_checklists
onsite_expenses
onsite_photos
onsite_reports
onsite_signatures
pos_order_items
pos_orders
pos_sessions
prj_project_history
prj_project_invoices
prj_project_members
prj_project_progress
prj_project_purchases
prj_projects
prj_v_project_stats
sys_settings
sys_wa_queue
trx_invoice_details
trx_invoices
trx_jobs
trx_ticket_history
trx_ticket_spareparts
trx_tickets
v_dashboard_stats
SQL query on database
sadika_erp
: