Recent
`mysql`.`help_relation`
`mysql`.`help_topic`
`phpmyadmin`.`pma__tracking`
`mysql`.`func`
`phpmyadmin`.`pma__table_uiprefs`
`phpmyadmin`.`pma__recent`
`ggth_erp`.`users`
`mysql`.`table_stats`
`phpmyadmin`.`pma__usergroups`
`phpmyadmin`.`pma__relation`
Favorites
There are no favorite tables.
New
ggth_erp
information_schema
mysql
performance_schema
phpmyadmin
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: ggth_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:
`audit_logs`.*
`audit_logs`.`log_id`
`audit_logs`.`user_id`
`audit_logs`.`action`
`audit_logs`.`module`
`audit_logs`.`description`
`audit_logs`.`ip_address`
`audit_logs`.`created_at`
`blacklist`.*
`blacklist`.`blacklist_id`
`blacklist`.`customer_id`
`blacklist`.`name`
`blacklist`.`ic_number`
`blacklist`.`phone`
`blacklist`.`reason`
`blacklist`.`rejection_reason`
`blacklist`.`status`
`blacklist`.`created_by`
`blacklist`.`created_at`
`booking_images`.*
`booking_images`.`image_id`
`booking_images`.`booking_id`
`booking_images`.`image_path`
`booking_images`.`image_type`
`booking_images`.`uploaded_at`
`bookings`.*
`bookings`.`booking_id`
`bookings`.`receipt_no`
`bookings`.`customer_id`
`bookings`.`vehicle_id`
`bookings`.`rental_type`
`bookings`.`start_date`
`bookings`.`time_out`
`bookings`.`expected_end_date`
`bookings`.`expected_end_time`
`bookings`.`duration_unit`
`bookings`.`with_driver`
`bookings`.`driver_cost`
`bookings`.`rental_duration`
`bookings`.`actual_return_date`
`bookings`.`actual_return_time`
`bookings`.`rental_days`
`bookings`.`daily_rate`
`bookings`.`hourly_rate`
`bookings`.`insurance`
`bookings`.`discount_amount`
`bookings`.`extra_charges`
`bookings`.`early_return_discount`
`bookings`.`rental_refund_amount`
`bookings`.`rental_refund_status`
`bookings`.`rental_refund_date`
`bookings`.`rental_refund_proof`
`bookings`.`extra_charges_reason`
`bookings`.`damage_charge`
`bookings`.`damage_notes`
`bookings`.`deposit`
`bookings`.`deposit_type`
`bookings`.`deposit_ref`
`bookings`.`deposit_proof`
`bookings`.`deposit_status`
`bookings`.`deposit_refund_amount`
`bookings`.`deposit_refund_date`
`bookings`.`deposit_refund_proof`
`bookings`.`rental_payment_type`
`bookings`.`rental_payment_ref`
`bookings`.`rental_payment_proof`
`bookings`.`payment_status`
`bookings`.`amount_paid`
`bookings`.`balance_due`
`bookings`.`date_paid`
`bookings`.`booking_status`
`bookings`.`team`
`bookings`.`remarks`
`bookings`.`cancellation_reason`
`bookings`.`rejection_reason`
`bookings`.`created_by`
`bookings`.`created_at`
`bookings`.`updated_at`
`bookings`.`pickup_mileage`
`bookings`.`pickup_mileage_image`
`bookings`.`return_mileage`
`bookings`.`return_mileage_image`
`bookings`.`sst_type`
`bug_report_attachments`.*
`bug_report_attachments`.`attachment_id`
`bug_report_attachments`.`report_id`
`bug_report_attachments`.`file_path`
`bug_report_attachments`.`file_type`
`bug_report_attachments`.`uploaded_at`
`bug_reports`.*
`bug_reports`.`report_id`
`bug_reports`.`user_id`
`bug_reports`.`title`
`bug_reports`.`description`
`bug_reports`.`status`
`bug_reports`.`created_at`
`bug_reports`.`updated_at`
`corporate_contracts`.*
`corporate_contracts`.`id`
`corporate_contracts`.`company_name`
`corporate_contracts`.`vehicle_id`
`corporate_contracts`.`owner_name`
`corporate_contracts`.`start_date`
`corporate_contracts`.`end_date`
`corporate_contracts`.`contract_terms`
`corporate_contracts`.`invoice_data`
`corporate_contracts`.`status`
`corporate_contracts`.`created_at`
`corporate_contracts`.`updated_at`
`corporate_vehicle_rates`.*
`corporate_vehicle_rates`.`id`
`corporate_vehicle_rates`.`customer_id`
`corporate_vehicle_rates`.`vehicle_id`
`corporate_vehicle_rates`.`custom_daily_rate`
`corporate_vehicle_rates`.`custom_insurance_rate`
`corporate_vehicle_rates`.`created_at`
`cr_audit_logs`.*
`cr_audit_logs`.`log_id`
`cr_audit_logs`.`user_id`
`cr_audit_logs`.`action_type`
`cr_audit_logs`.`module_name`
`cr_audit_logs`.`record_id`
`cr_audit_logs`.`description`
`cr_audit_logs`.`ip_address`
`cr_audit_logs`.`user_agent`
`cr_audit_logs`.`created_at`
`cr_failed_login_logs`.*
`cr_failed_login_logs`.`id`
`cr_failed_login_logs`.`email`
`cr_failed_login_logs`.`ip_address`
`cr_failed_login_logs`.`user_agent`
`cr_failed_login_logs`.`attempted_at`
`cr_system_settings`.*
`cr_system_settings`.`setting_key`
`cr_system_settings`.`setting_value`
`cr_system_settings`.`updated_at`
`cr_users`.*
`cr_users`.`user_id`
`cr_users`.`name`
`cr_users`.`email`
`cr_users`.`password_hash`
`cr_users`.`session_token`
`cr_users`.`role`
`cr_users`.`status`
`cr_users`.`created_at`
`customers`.*
`customers`.`customer_id`
`customers`.`name`
`customers`.`ic_number`
`customers`.`phone`
`customers`.`address`
`customers`.`ic_image`
`customers`.`license_image`
`customers`.`proof_image`
`customers`.`type`
`customers`.`notes`
`customers`.`status`
`customers`.`created_at`
`customers`.`updated_at`
`failed_login_logs`.*
`failed_login_logs`.`id`
`failed_login_logs`.`email`
`failed_login_logs`.`ip_address`
`failed_login_logs`.`user_agent`
`failed_login_logs`.`attempted_at`
`modules`.*
`modules`.`module_id`
`modules`.`module_name`
`modules`.`module_slug`
`modules`.`module_url`
`modules`.`description`
`modules`.`icon`
`modules`.`color`
`modules`.`status`
`modules`.`sort_order`
`modules`.`created_at`
`notifications`.*
`notifications`.`notification_id`
`notifications`.`user_id`
`notifications`.`title`
`notifications`.`message`
`notifications`.`type`
`notifications`.`related_module`
`notifications`.`related_record_id`
`notifications`.`is_read`
`notifications`.`created_at`
`rental_agreement_damages`.*
`rental_agreement_damages`.`damage_id`
`rental_agreement_damages`.`agreement_id`
`rental_agreement_damages`.`vehicle_view`
`rental_agreement_damages`.`damage_area`
`rental_agreement_damages`.`marker_x`
`rental_agreement_damages`.`marker_y`
`rental_agreement_damages`.`damage_type`
`rental_agreement_damages`.`severity`
`rental_agreement_damages`.`damage_note`
`rental_agreement_damages`.`created_by`
`rental_agreement_damages`.`created_at`
`rental_agreements`.*
`rental_agreements`.`agreement_id`
`rental_agreements`.`agreement_no`
`rental_agreements`.`booking_id`
`rental_agreements`.`customer_id`
`rental_agreements`.`vehicle_id`
`rental_agreements`.`generated_by`
`rental_agreements`.`confirmed_by`
`rental_agreements`.`status`
`rental_agreements`.`customer_name`
`rental_agreements`.`customer_ic`
`rental_agreements`.`customer_phone`
`rental_agreements`.`customer_email`
`rental_agreements`.`customer_address`
`rental_agreements`.`license_no`
`rental_agreements`.`license_expiry`
`rental_agreements`.`additional_driver_name`
`rental_agreements`.`additional_driver_ic`
`rental_agreements`.`additional_driver_phone`
`rental_agreements`.`additional_driver_address`
`rental_agreements`.`additional_driver_license_no`
`rental_agreements`.`additional_driver_license_expiry`
`rental_agreements`.`vehicle_plate`
`rental_agreements`.`vehicle_brand`
`rental_agreements`.`vehicle_model`
`rental_agreements`.`vehicle_color`
`rental_agreements`.`vehicle_year`
`rental_agreements`.`rental_start_datetime`
`rental_agreements`.`rental_end_datetime`
`rental_agreements`.`pickup_location`
`rental_agreements`.`return_location`
`rental_agreements`.`mileage_out`
`rental_agreements`.`mileage_in`
`rental_agreements`.`fuel_level_out`
`rental_agreements`.`fuel_level_in`
`rental_agreements`.`destination`
`rental_agreements`.`daily_rate`
`rental_agreements`.`weekly_rate`
`rental_agreements`.`monthly_rate`
`rental_agreements`.`extra_hour_charge`
`rental_agreements`.`delivery_fee`
`rental_agreements`.`collection_fee`
`rental_agreements`.`service_tax`
`rental_agreements`.`insurance_fee`
`rental_agreements`.`miscellaneous_fee`
`rental_agreements`.`total_amount`
`rental_agreements`.`deposit_amount`
`rental_agreements`.`amount_paid`
`rental_agreements`.`balance_amount`
`rental_agreements`.`payment_method`
`rental_agreements`.`accessories_json`
`rental_agreements`.`inspection_checklist_json`
`rental_agreements`.`general_remarks`
`rental_agreements`.`customer_remarks`
`rental_agreements`.`staff_remarks`
`rental_agreements`.`customer_signature_name`
`rental_agreements`.`staff_signature_name`
`rental_agreements`.`confirmed_at`
`rental_agreements`.`cancelled_at`
`rental_agreements`.`created_at`
`rental_agreements`.`updated_at`
`system_notices`.*
`system_notices`.`notice_id`
`system_notices`.`title`
`system_notices`.`content`
`system_notices`.`created_by`
`system_notices`.`created_at`
`system_settings`.*
`system_settings`.`setting_id`
`system_settings`.`setting_key`
`system_settings`.`setting_value`
`system_settings`.`updated_at`
`ticketing_access`.*
`ticketing_access`.`user_id`
`ticketing_access`.`granted_by`
`ticketing_access`.`granted_at`
`ticketing_audit_log`.*
`ticketing_audit_log`.`id`
`ticketing_audit_log`.`action`
`ticketing_audit_log`.`record_id`
`ticketing_audit_log`.`user_id`
`ticketing_audit_log`.`user_name`
`ticketing_audit_log`.`old_values`
`ticketing_audit_log`.`new_values`
`ticketing_audit_log`.`ip_address`
`ticketing_audit_log`.`user_agent`
`ticketing_audit_log`.`created_at`
`ticketing_sales`.*
`ticketing_sales`.`id`
`ticketing_sales`.`date_issue`
`ticketing_sales`.`flight_date`
`ticketing_sales`.`trip_type`
`ticketing_sales`.`return_date`
`ticketing_sales`.`customer_dept`
`ticketing_sales`.`portal`
`ticketing_sales`.`airline`
`ticketing_sales`.`warrant_no`
`ticketing_sales`.`pnr`
`ticketing_sales`.`flight_class`
`ticketing_sales`.`pax`
`ticketing_sales`.`wpua_amt`
`ticketing_sales`.`infant_amt`
`ticketing_sales`.`tax_amt`
`ticketing_sales`.`sst_amt`
`ticketing_sales`.`fare_amt`
`ticketing_sales`.`service_charge`
`ticketing_sales`.`status`
`ticketing_sales`.`assigned_to`
`ticketing_sales`.`created_by`
`ticketing_sales`.`created_at`
`ticketing_sales`.`updated_at`
`tour_customers`.*
`tour_customers`.`id`
`tour_customers`.`name`
`tour_customers`.`phone`
`tour_customers`.`ic_number`
`tour_customers`.`ic_image`
`tour_customers`.`created_at`
`tour_package_audit_log`.*
`tour_package_audit_log`.`id`
`tour_package_audit_log`.`action`
`tour_package_audit_log`.`record_id`
`tour_package_audit_log`.`user_id`
`tour_package_audit_log`.`user_name`
`tour_package_audit_log`.`old_values`
`tour_package_audit_log`.`new_values`
`tour_package_audit_log`.`ip_address`
`tour_package_audit_log`.`created_at`
`tour_package_sales`.*
`tour_package_sales`.`id`
`tour_package_sales`.`travel_date`
`tour_package_sales`.`booking_date`
`tour_package_sales`.`guest_name`
`tour_package_sales`.`customer_id`
`tour_package_sales`.`package_type`
`tour_package_sales`.`customer_type`
`tour_package_sales`.`adult_pax`
`tour_package_sales`.`adult_price`
`tour_package_sales`.`senior_pax`
`tour_package_sales`.`senior_price`
`tour_package_sales`.`child_pax`
`tour_package_sales`.`child_price`
`tour_package_sales`.`infant_pax`
`tour_package_sales`.`infant_price`
`tour_package_sales`.`total_pax`
`tour_package_sales`.`total_invoice`
`tour_package_sales`.`total_cost`
`tour_package_sales`.`net_profit`
`tour_package_sales`.`deposit_paid`
`tour_package_sales`.`balance_due`
`tour_package_sales`.`adult_tax`
`tour_package_sales`.`senior_tax`
`tour_package_sales`.`child_tax`
`tour_package_sales`.`infant_tax`
`tour_package_sales`.`status`
`tour_package_sales`.`assigned_to`
`tour_package_sales`.`created_at`
`tour_package_sales`.`created_by`
`tour_package_sales`.`updated_at`
`user_module_access`.*
`user_module_access`.`access_id`
`user_module_access`.`user_id`
`user_module_access`.`module_id`
`user_module_access`.`can_access`
`user_module_access`.`can_create`
`user_module_access`.`can_edit`
`user_module_access`.`can_delete`
`user_module_access`.`created_at`
`user_module_access`.`updated_at`
`user_notice_views`.*
`user_notice_views`.`user_id`
`user_notice_views`.`notice_id`
`user_notice_views`.`dismissed_at`
`users`.*
`users`.`user_id`
`users`.`full_name`
`users`.`email`
`users`.`password`
`users`.`role`
`users`.`status`
`users`.`avatar`
`users`.`created_at`
`users`.`updated_at`
`users`.`session_token`
`vehicle_images`.*
`vehicle_images`.`image_id`
`vehicle_images`.`vehicle_id`
`vehicle_images`.`image_path`
`vehicle_images`.`is_main`
`vehicle_images`.`uploaded_at`
`vehicle_maintenance`.*
`vehicle_maintenance`.`id`
`vehicle_maintenance`.`vehicle_id`
`vehicle_maintenance`.`maintenance_date`
`vehicle_maintenance`.`description`
`vehicle_maintenance`.`cost`
`vehicle_maintenance`.`status`
`vehicle_maintenance`.`created_at`
`vehicle_maintenance`.`receipt_image`
`vehicles`.*
`vehicles`.`vehicle_id`
`vehicles`.`type`
`vehicles`.`plate_number`
`vehicles`.`brand`
`vehicles`.`model`
`vehicles`.`year`
`vehicles`.`engine_cc`
`vehicles`.`current_mileage`
`vehicles`.`ownership_type`
`vehicles`.`daily_rate`
`vehicles`.`three_day_rate`
`vehicles`.`weekly_rate`
`vehicles`.`hourly_rate`
`vehicles`.`insurance_rate`
`vehicles`.`corporate_rate`
`vehicles`.`status`
`vehicles`.`driver_available`
`vehicles`.`driver_rate`
`vehicles`.`corporate_driver_rate`
`vehicles`.`location`
`vehicles`.`category`
`vehicles`.`team`
`vehicles`.`notes`
`vehicles`.`created_at`
`vehicles`.`updated_at`
`work_order_audit_log`.*
`work_order_audit_log`.`id`
`work_order_audit_log`.`action`
`work_order_audit_log`.`record_id`
`work_order_audit_log`.`user_id`
`work_order_audit_log`.`user_name`
`work_order_audit_log`.`old_values`
`work_order_audit_log`.`new_values`
`work_order_audit_log`.`ip_address`
`work_order_audit_log`.`created_at`
`work_order_items`.*
`work_order_items`.`id`
`work_order_items`.`wo_id`
`work_order_items`.`item_description`
`work_order_items`.`po_number`
`work_order_items`.`item_remark`
`work_order_items`.`quantity`
`work_order_items`.`price_rm`
`work_order_receipts`.*
`work_order_receipts`.`id`
`work_order_receipts`.`wo_id`
`work_order_receipts`.`file_name`
`work_order_receipts`.`file_path`
`work_order_receipts`.`created_at`
`work_orders`.*
`work_orders`.`id`
`work_orders`.`wo_type`
`work_orders`.`company_prefix`
`work_orders`.`wo_year`
`work_orders`.`wo_month`
`work_orders`.`dept_code`
`work_orders`.`sequence_no`
`work_orders`.`full_wo_number`
`work_orders`.`date_issued`
`work_orders`.`attention_to`
`work_orders`.`subject`
`work_orders`.`item_info`
`work_orders`.`prepared_by`
`work_orders`.`bank_acc_no`
`work_orders`.`bank_name`
`work_orders`.`bank_acc_name`
`work_orders`.`status`
`work_orders`.`receipt_file`
`work_orders`.`created_at`
`work_orders`.`maint_location`
`work_orders`.`maint_technician`
`work_orders`.`maint_task`
`work_orders`.`driver_name`
`work_orders`.`driver_destination`
`work_orders`.`driver_date_from`
`work_orders`.`driver_date_to`
`work_orders`.`driver_vehicle`
`audit_logs`.*
`audit_logs`.`log_id`
`audit_logs`.`user_id`
`audit_logs`.`action`
`audit_logs`.`module`
`audit_logs`.`description`
`audit_logs`.`ip_address`
`audit_logs`.`created_at`
`blacklist`.*
`blacklist`.`blacklist_id`
`blacklist`.`customer_id`
`blacklist`.`name`
`blacklist`.`ic_number`
`blacklist`.`phone`
`blacklist`.`reason`
`blacklist`.`rejection_reason`
`blacklist`.`status`
`blacklist`.`created_by`
`blacklist`.`created_at`
`booking_images`.*
`booking_images`.`image_id`
`booking_images`.`booking_id`
`booking_images`.`image_path`
`booking_images`.`image_type`
`booking_images`.`uploaded_at`
`bookings`.*
`bookings`.`booking_id`
`bookings`.`receipt_no`
`bookings`.`customer_id`
`bookings`.`vehicle_id`
`bookings`.`rental_type`
`bookings`.`start_date`
`bookings`.`time_out`
`bookings`.`expected_end_date`
`bookings`.`expected_end_time`
`bookings`.`duration_unit`
`bookings`.`with_driver`
`bookings`.`driver_cost`
`bookings`.`rental_duration`
`bookings`.`actual_return_date`
`bookings`.`actual_return_time`
`bookings`.`rental_days`
`bookings`.`daily_rate`
`bookings`.`hourly_rate`
`bookings`.`insurance`
`bookings`.`discount_amount`
`bookings`.`extra_charges`
`bookings`.`early_return_discount`
`bookings`.`rental_refund_amount`
`bookings`.`rental_refund_status`
`bookings`.`rental_refund_date`
`bookings`.`rental_refund_proof`
`bookings`.`extra_charges_reason`
`bookings`.`damage_charge`
`bookings`.`damage_notes`
`bookings`.`deposit`
`bookings`.`deposit_type`
`bookings`.`deposit_ref`
`bookings`.`deposit_proof`
`bookings`.`deposit_status`
`bookings`.`deposit_refund_amount`
`bookings`.`deposit_refund_date`
`bookings`.`deposit_refund_proof`
`bookings`.`rental_payment_type`
`bookings`.`rental_payment_ref`
`bookings`.`rental_payment_proof`
`bookings`.`payment_status`
`bookings`.`amount_paid`
`bookings`.`balance_due`
`bookings`.`date_paid`
`bookings`.`booking_status`
`bookings`.`team`
`bookings`.`remarks`
`bookings`.`cancellation_reason`
`bookings`.`rejection_reason`
`bookings`.`created_by`
`bookings`.`created_at`
`bookings`.`updated_at`
`bookings`.`pickup_mileage`
`bookings`.`pickup_mileage_image`
`bookings`.`return_mileage`
`bookings`.`return_mileage_image`
`bookings`.`sst_type`
`bug_report_attachments`.*
`bug_report_attachments`.`attachment_id`
`bug_report_attachments`.`report_id`
`bug_report_attachments`.`file_path`
`bug_report_attachments`.`file_type`
`bug_report_attachments`.`uploaded_at`
`bug_reports`.*
`bug_reports`.`report_id`
`bug_reports`.`user_id`
`bug_reports`.`title`
`bug_reports`.`description`
`bug_reports`.`status`
`bug_reports`.`created_at`
`bug_reports`.`updated_at`
`corporate_contracts`.*
`corporate_contracts`.`id`
`corporate_contracts`.`company_name`
`corporate_contracts`.`vehicle_id`
`corporate_contracts`.`owner_name`
`corporate_contracts`.`start_date`
`corporate_contracts`.`end_date`
`corporate_contracts`.`contract_terms`
`corporate_contracts`.`invoice_data`
`corporate_contracts`.`status`
`corporate_contracts`.`created_at`
`corporate_contracts`.`updated_at`
`corporate_vehicle_rates`.*
`corporate_vehicle_rates`.`id`
`corporate_vehicle_rates`.`customer_id`
`corporate_vehicle_rates`.`vehicle_id`
`corporate_vehicle_rates`.`custom_daily_rate`
`corporate_vehicle_rates`.`custom_insurance_rate`
`corporate_vehicle_rates`.`created_at`
`cr_audit_logs`.*
`cr_audit_logs`.`log_id`
`cr_audit_logs`.`user_id`
`cr_audit_logs`.`action_type`
`cr_audit_logs`.`module_name`
`cr_audit_logs`.`record_id`
`cr_audit_logs`.`description`
`cr_audit_logs`.`ip_address`
`cr_audit_logs`.`user_agent`
`cr_audit_logs`.`created_at`
`cr_failed_login_logs`.*
`cr_failed_login_logs`.`id`
`cr_failed_login_logs`.`email`
`cr_failed_login_logs`.`ip_address`
`cr_failed_login_logs`.`user_agent`
`cr_failed_login_logs`.`attempted_at`
`cr_system_settings`.*
`cr_system_settings`.`setting_key`
`cr_system_settings`.`setting_value`
`cr_system_settings`.`updated_at`
`cr_users`.*
`cr_users`.`user_id`
`cr_users`.`name`
`cr_users`.`email`
`cr_users`.`password_hash`
`cr_users`.`session_token`
`cr_users`.`role`
`cr_users`.`status`
`cr_users`.`created_at`
`customers`.*
`customers`.`customer_id`
`customers`.`name`
`customers`.`ic_number`
`customers`.`phone`
`customers`.`address`
`customers`.`ic_image`
`customers`.`license_image`
`customers`.`proof_image`
`customers`.`type`
`customers`.`notes`
`customers`.`status`
`customers`.`created_at`
`customers`.`updated_at`
`failed_login_logs`.*
`failed_login_logs`.`id`
`failed_login_logs`.`email`
`failed_login_logs`.`ip_address`
`failed_login_logs`.`user_agent`
`failed_login_logs`.`attempted_at`
`modules`.*
`modules`.`module_id`
`modules`.`module_name`
`modules`.`module_slug`
`modules`.`module_url`
`modules`.`description`
`modules`.`icon`
`modules`.`color`
`modules`.`status`
`modules`.`sort_order`
`modules`.`created_at`
`notifications`.*
`notifications`.`notification_id`
`notifications`.`user_id`
`notifications`.`title`
`notifications`.`message`
`notifications`.`type`
`notifications`.`related_module`
`notifications`.`related_record_id`
`notifications`.`is_read`
`notifications`.`created_at`
`rental_agreement_damages`.*
`rental_agreement_damages`.`damage_id`
`rental_agreement_damages`.`agreement_id`
`rental_agreement_damages`.`vehicle_view`
`rental_agreement_damages`.`damage_area`
`rental_agreement_damages`.`marker_x`
`rental_agreement_damages`.`marker_y`
`rental_agreement_damages`.`damage_type`
`rental_agreement_damages`.`severity`
`rental_agreement_damages`.`damage_note`
`rental_agreement_damages`.`created_by`
`rental_agreement_damages`.`created_at`
`rental_agreements`.*
`rental_agreements`.`agreement_id`
`rental_agreements`.`agreement_no`
`rental_agreements`.`booking_id`
`rental_agreements`.`customer_id`
`rental_agreements`.`vehicle_id`
`rental_agreements`.`generated_by`
`rental_agreements`.`confirmed_by`
`rental_agreements`.`status`
`rental_agreements`.`customer_name`
`rental_agreements`.`customer_ic`
`rental_agreements`.`customer_phone`
`rental_agreements`.`customer_email`
`rental_agreements`.`customer_address`
`rental_agreements`.`license_no`
`rental_agreements`.`license_expiry`
`rental_agreements`.`additional_driver_name`
`rental_agreements`.`additional_driver_ic`
`rental_agreements`.`additional_driver_phone`
`rental_agreements`.`additional_driver_address`
`rental_agreements`.`additional_driver_license_no`
`rental_agreements`.`additional_driver_license_expiry`
`rental_agreements`.`vehicle_plate`
`rental_agreements`.`vehicle_brand`
`rental_agreements`.`vehicle_model`
`rental_agreements`.`vehicle_color`
`rental_agreements`.`vehicle_year`
`rental_agreements`.`rental_start_datetime`
`rental_agreements`.`rental_end_datetime`
`rental_agreements`.`pickup_location`
`rental_agreements`.`return_location`
`rental_agreements`.`mileage_out`
`rental_agreements`.`mileage_in`
`rental_agreements`.`fuel_level_out`
`rental_agreements`.`fuel_level_in`
`rental_agreements`.`destination`
`rental_agreements`.`daily_rate`
`rental_agreements`.`weekly_rate`
`rental_agreements`.`monthly_rate`
`rental_agreements`.`extra_hour_charge`
`rental_agreements`.`delivery_fee`
`rental_agreements`.`collection_fee`
`rental_agreements`.`service_tax`
`rental_agreements`.`insurance_fee`
`rental_agreements`.`miscellaneous_fee`
`rental_agreements`.`total_amount`
`rental_agreements`.`deposit_amount`
`rental_agreements`.`amount_paid`
`rental_agreements`.`balance_amount`
`rental_agreements`.`payment_method`
`rental_agreements`.`accessories_json`
`rental_agreements`.`inspection_checklist_json`
`rental_agreements`.`general_remarks`
`rental_agreements`.`customer_remarks`
`rental_agreements`.`staff_remarks`
`rental_agreements`.`customer_signature_name`
`rental_agreements`.`staff_signature_name`
`rental_agreements`.`confirmed_at`
`rental_agreements`.`cancelled_at`
`rental_agreements`.`created_at`
`rental_agreements`.`updated_at`
`system_notices`.*
`system_notices`.`notice_id`
`system_notices`.`title`
`system_notices`.`content`
`system_notices`.`created_by`
`system_notices`.`created_at`
`system_settings`.*
`system_settings`.`setting_id`
`system_settings`.`setting_key`
`system_settings`.`setting_value`
`system_settings`.`updated_at`
`ticketing_access`.*
`ticketing_access`.`user_id`
`ticketing_access`.`granted_by`
`ticketing_access`.`granted_at`
`ticketing_audit_log`.*
`ticketing_audit_log`.`id`
`ticketing_audit_log`.`action`
`ticketing_audit_log`.`record_id`
`ticketing_audit_log`.`user_id`
`ticketing_audit_log`.`user_name`
`ticketing_audit_log`.`old_values`
`ticketing_audit_log`.`new_values`
`ticketing_audit_log`.`ip_address`
`ticketing_audit_log`.`user_agent`
`ticketing_audit_log`.`created_at`
`ticketing_sales`.*
`ticketing_sales`.`id`
`ticketing_sales`.`date_issue`
`ticketing_sales`.`flight_date`
`ticketing_sales`.`trip_type`
`ticketing_sales`.`return_date`
`ticketing_sales`.`customer_dept`
`ticketing_sales`.`portal`
`ticketing_sales`.`airline`
`ticketing_sales`.`warrant_no`
`ticketing_sales`.`pnr`
`ticketing_sales`.`flight_class`
`ticketing_sales`.`pax`
`ticketing_sales`.`wpua_amt`
`ticketing_sales`.`infant_amt`
`ticketing_sales`.`tax_amt`
`ticketing_sales`.`sst_amt`
`ticketing_sales`.`fare_amt`
`ticketing_sales`.`service_charge`
`ticketing_sales`.`status`
`ticketing_sales`.`assigned_to`
`ticketing_sales`.`created_by`
`ticketing_sales`.`created_at`
`ticketing_sales`.`updated_at`
`tour_customers`.*
`tour_customers`.`id`
`tour_customers`.`name`
`tour_customers`.`phone`
`tour_customers`.`ic_number`
`tour_customers`.`ic_image`
`tour_customers`.`created_at`
`tour_package_audit_log`.*
`tour_package_audit_log`.`id`
`tour_package_audit_log`.`action`
`tour_package_audit_log`.`record_id`
`tour_package_audit_log`.`user_id`
`tour_package_audit_log`.`user_name`
`tour_package_audit_log`.`old_values`
`tour_package_audit_log`.`new_values`
`tour_package_audit_log`.`ip_address`
`tour_package_audit_log`.`created_at`
`tour_package_sales`.*
`tour_package_sales`.`id`
`tour_package_sales`.`travel_date`
`tour_package_sales`.`booking_date`
`tour_package_sales`.`guest_name`
`tour_package_sales`.`customer_id`
`tour_package_sales`.`package_type`
`tour_package_sales`.`customer_type`
`tour_package_sales`.`adult_pax`
`tour_package_sales`.`adult_price`
`tour_package_sales`.`senior_pax`
`tour_package_sales`.`senior_price`
`tour_package_sales`.`child_pax`
`tour_package_sales`.`child_price`
`tour_package_sales`.`infant_pax`
`tour_package_sales`.`infant_price`
`tour_package_sales`.`total_pax`
`tour_package_sales`.`total_invoice`
`tour_package_sales`.`total_cost`
`tour_package_sales`.`net_profit`
`tour_package_sales`.`deposit_paid`
`tour_package_sales`.`balance_due`
`tour_package_sales`.`adult_tax`
`tour_package_sales`.`senior_tax`
`tour_package_sales`.`child_tax`
`tour_package_sales`.`infant_tax`
`tour_package_sales`.`status`
`tour_package_sales`.`assigned_to`
`tour_package_sales`.`created_at`
`tour_package_sales`.`created_by`
`tour_package_sales`.`updated_at`
`user_module_access`.*
`user_module_access`.`access_id`
`user_module_access`.`user_id`
`user_module_access`.`module_id`
`user_module_access`.`can_access`
`user_module_access`.`can_create`
`user_module_access`.`can_edit`
`user_module_access`.`can_delete`
`user_module_access`.`created_at`
`user_module_access`.`updated_at`
`user_notice_views`.*
`user_notice_views`.`user_id`
`user_notice_views`.`notice_id`
`user_notice_views`.`dismissed_at`
`users`.*
`users`.`user_id`
`users`.`full_name`
`users`.`email`
`users`.`password`
`users`.`role`
`users`.`status`
`users`.`avatar`
`users`.`created_at`
`users`.`updated_at`
`users`.`session_token`
`vehicle_images`.*
`vehicle_images`.`image_id`
`vehicle_images`.`vehicle_id`
`vehicle_images`.`image_path`
`vehicle_images`.`is_main`
`vehicle_images`.`uploaded_at`
`vehicle_maintenance`.*
`vehicle_maintenance`.`id`
`vehicle_maintenance`.`vehicle_id`
`vehicle_maintenance`.`maintenance_date`
`vehicle_maintenance`.`description`
`vehicle_maintenance`.`cost`
`vehicle_maintenance`.`status`
`vehicle_maintenance`.`created_at`
`vehicle_maintenance`.`receipt_image`
`vehicles`.*
`vehicles`.`vehicle_id`
`vehicles`.`type`
`vehicles`.`plate_number`
`vehicles`.`brand`
`vehicles`.`model`
`vehicles`.`year`
`vehicles`.`engine_cc`
`vehicles`.`current_mileage`
`vehicles`.`ownership_type`
`vehicles`.`daily_rate`
`vehicles`.`three_day_rate`
`vehicles`.`weekly_rate`
`vehicles`.`hourly_rate`
`vehicles`.`insurance_rate`
`vehicles`.`corporate_rate`
`vehicles`.`status`
`vehicles`.`driver_available`
`vehicles`.`driver_rate`
`vehicles`.`corporate_driver_rate`
`vehicles`.`location`
`vehicles`.`category`
`vehicles`.`team`
`vehicles`.`notes`
`vehicles`.`created_at`
`vehicles`.`updated_at`
`work_order_audit_log`.*
`work_order_audit_log`.`id`
`work_order_audit_log`.`action`
`work_order_audit_log`.`record_id`
`work_order_audit_log`.`user_id`
`work_order_audit_log`.`user_name`
`work_order_audit_log`.`old_values`
`work_order_audit_log`.`new_values`
`work_order_audit_log`.`ip_address`
`work_order_audit_log`.`created_at`
`work_order_items`.*
`work_order_items`.`id`
`work_order_items`.`wo_id`
`work_order_items`.`item_description`
`work_order_items`.`po_number`
`work_order_items`.`item_remark`
`work_order_items`.`quantity`
`work_order_items`.`price_rm`
`work_order_receipts`.*
`work_order_receipts`.`id`
`work_order_receipts`.`wo_id`
`work_order_receipts`.`file_name`
`work_order_receipts`.`file_path`
`work_order_receipts`.`created_at`
`work_orders`.*
`work_orders`.`id`
`work_orders`.`wo_type`
`work_orders`.`company_prefix`
`work_orders`.`wo_year`
`work_orders`.`wo_month`
`work_orders`.`dept_code`
`work_orders`.`sequence_no`
`work_orders`.`full_wo_number`
`work_orders`.`date_issued`
`work_orders`.`attention_to`
`work_orders`.`subject`
`work_orders`.`item_info`
`work_orders`.`prepared_by`
`work_orders`.`bank_acc_no`
`work_orders`.`bank_name`
`work_orders`.`bank_acc_name`
`work_orders`.`status`
`work_orders`.`receipt_file`
`work_orders`.`created_at`
`work_orders`.`maint_location`
`work_orders`.`maint_technician`
`work_orders`.`maint_task`
`work_orders`.`driver_name`
`work_orders`.`driver_destination`
`work_orders`.`driver_date_from`
`work_orders`.`driver_date_to`
`work_orders`.`driver_vehicle`
`audit_logs`.*
`audit_logs`.`log_id`
`audit_logs`.`user_id`
`audit_logs`.`action`
`audit_logs`.`module`
`audit_logs`.`description`
`audit_logs`.`ip_address`
`audit_logs`.`created_at`
`blacklist`.*
`blacklist`.`blacklist_id`
`blacklist`.`customer_id`
`blacklist`.`name`
`blacklist`.`ic_number`
`blacklist`.`phone`
`blacklist`.`reason`
`blacklist`.`rejection_reason`
`blacklist`.`status`
`blacklist`.`created_by`
`blacklist`.`created_at`
`booking_images`.*
`booking_images`.`image_id`
`booking_images`.`booking_id`
`booking_images`.`image_path`
`booking_images`.`image_type`
`booking_images`.`uploaded_at`
`bookings`.*
`bookings`.`booking_id`
`bookings`.`receipt_no`
`bookings`.`customer_id`
`bookings`.`vehicle_id`
`bookings`.`rental_type`
`bookings`.`start_date`
`bookings`.`time_out`
`bookings`.`expected_end_date`
`bookings`.`expected_end_time`
`bookings`.`duration_unit`
`bookings`.`with_driver`
`bookings`.`driver_cost`
`bookings`.`rental_duration`
`bookings`.`actual_return_date`
`bookings`.`actual_return_time`
`bookings`.`rental_days`
`bookings`.`daily_rate`
`bookings`.`hourly_rate`
`bookings`.`insurance`
`bookings`.`discount_amount`
`bookings`.`extra_charges`
`bookings`.`early_return_discount`
`bookings`.`rental_refund_amount`
`bookings`.`rental_refund_status`
`bookings`.`rental_refund_date`
`bookings`.`rental_refund_proof`
`bookings`.`extra_charges_reason`
`bookings`.`damage_charge`
`bookings`.`damage_notes`
`bookings`.`deposit`
`bookings`.`deposit_type`
`bookings`.`deposit_ref`
`bookings`.`deposit_proof`
`bookings`.`deposit_status`
`bookings`.`deposit_refund_amount`
`bookings`.`deposit_refund_date`
`bookings`.`deposit_refund_proof`
`bookings`.`rental_payment_type`
`bookings`.`rental_payment_ref`
`bookings`.`rental_payment_proof`
`bookings`.`payment_status`
`bookings`.`amount_paid`
`bookings`.`balance_due`
`bookings`.`date_paid`
`bookings`.`booking_status`
`bookings`.`team`
`bookings`.`remarks`
`bookings`.`cancellation_reason`
`bookings`.`rejection_reason`
`bookings`.`created_by`
`bookings`.`created_at`
`bookings`.`updated_at`
`bookings`.`pickup_mileage`
`bookings`.`pickup_mileage_image`
`bookings`.`return_mileage`
`bookings`.`return_mileage_image`
`bookings`.`sst_type`
`bug_report_attachments`.*
`bug_report_attachments`.`attachment_id`
`bug_report_attachments`.`report_id`
`bug_report_attachments`.`file_path`
`bug_report_attachments`.`file_type`
`bug_report_attachments`.`uploaded_at`
`bug_reports`.*
`bug_reports`.`report_id`
`bug_reports`.`user_id`
`bug_reports`.`title`
`bug_reports`.`description`
`bug_reports`.`status`
`bug_reports`.`created_at`
`bug_reports`.`updated_at`
`corporate_contracts`.*
`corporate_contracts`.`id`
`corporate_contracts`.`company_name`
`corporate_contracts`.`vehicle_id`
`corporate_contracts`.`owner_name`
`corporate_contracts`.`start_date`
`corporate_contracts`.`end_date`
`corporate_contracts`.`contract_terms`
`corporate_contracts`.`invoice_data`
`corporate_contracts`.`status`
`corporate_contracts`.`created_at`
`corporate_contracts`.`updated_at`
`corporate_vehicle_rates`.*
`corporate_vehicle_rates`.`id`
`corporate_vehicle_rates`.`customer_id`
`corporate_vehicle_rates`.`vehicle_id`
`corporate_vehicle_rates`.`custom_daily_rate`
`corporate_vehicle_rates`.`custom_insurance_rate`
`corporate_vehicle_rates`.`created_at`
`cr_audit_logs`.*
`cr_audit_logs`.`log_id`
`cr_audit_logs`.`user_id`
`cr_audit_logs`.`action_type`
`cr_audit_logs`.`module_name`
`cr_audit_logs`.`record_id`
`cr_audit_logs`.`description`
`cr_audit_logs`.`ip_address`
`cr_audit_logs`.`user_agent`
`cr_audit_logs`.`created_at`
`cr_failed_login_logs`.*
`cr_failed_login_logs`.`id`
`cr_failed_login_logs`.`email`
`cr_failed_login_logs`.`ip_address`
`cr_failed_login_logs`.`user_agent`
`cr_failed_login_logs`.`attempted_at`
`cr_system_settings`.*
`cr_system_settings`.`setting_key`
`cr_system_settings`.`setting_value`
`cr_system_settings`.`updated_at`
`cr_users`.*
`cr_users`.`user_id`
`cr_users`.`name`
`cr_users`.`email`
`cr_users`.`password_hash`
`cr_users`.`session_token`
`cr_users`.`role`
`cr_users`.`status`
`cr_users`.`created_at`
`customers`.*
`customers`.`customer_id`
`customers`.`name`
`customers`.`ic_number`
`customers`.`phone`
`customers`.`address`
`customers`.`ic_image`
`customers`.`license_image`
`customers`.`proof_image`
`customers`.`type`
`customers`.`notes`
`customers`.`status`
`customers`.`created_at`
`customers`.`updated_at`
`failed_login_logs`.*
`failed_login_logs`.`id`
`failed_login_logs`.`email`
`failed_login_logs`.`ip_address`
`failed_login_logs`.`user_agent`
`failed_login_logs`.`attempted_at`
`modules`.*
`modules`.`module_id`
`modules`.`module_name`
`modules`.`module_slug`
`modules`.`module_url`
`modules`.`description`
`modules`.`icon`
`modules`.`color`
`modules`.`status`
`modules`.`sort_order`
`modules`.`created_at`
`notifications`.*
`notifications`.`notification_id`
`notifications`.`user_id`
`notifications`.`title`
`notifications`.`message`
`notifications`.`type`
`notifications`.`related_module`
`notifications`.`related_record_id`
`notifications`.`is_read`
`notifications`.`created_at`
`rental_agreement_damages`.*
`rental_agreement_damages`.`damage_id`
`rental_agreement_damages`.`agreement_id`
`rental_agreement_damages`.`vehicle_view`
`rental_agreement_damages`.`damage_area`
`rental_agreement_damages`.`marker_x`
`rental_agreement_damages`.`marker_y`
`rental_agreement_damages`.`damage_type`
`rental_agreement_damages`.`severity`
`rental_agreement_damages`.`damage_note`
`rental_agreement_damages`.`created_by`
`rental_agreement_damages`.`created_at`
`rental_agreements`.*
`rental_agreements`.`agreement_id`
`rental_agreements`.`agreement_no`
`rental_agreements`.`booking_id`
`rental_agreements`.`customer_id`
`rental_agreements`.`vehicle_id`
`rental_agreements`.`generated_by`
`rental_agreements`.`confirmed_by`
`rental_agreements`.`status`
`rental_agreements`.`customer_name`
`rental_agreements`.`customer_ic`
`rental_agreements`.`customer_phone`
`rental_agreements`.`customer_email`
`rental_agreements`.`customer_address`
`rental_agreements`.`license_no`
`rental_agreements`.`license_expiry`
`rental_agreements`.`additional_driver_name`
`rental_agreements`.`additional_driver_ic`
`rental_agreements`.`additional_driver_phone`
`rental_agreements`.`additional_driver_address`
`rental_agreements`.`additional_driver_license_no`
`rental_agreements`.`additional_driver_license_expiry`
`rental_agreements`.`vehicle_plate`
`rental_agreements`.`vehicle_brand`
`rental_agreements`.`vehicle_model`
`rental_agreements`.`vehicle_color`
`rental_agreements`.`vehicle_year`
`rental_agreements`.`rental_start_datetime`
`rental_agreements`.`rental_end_datetime`
`rental_agreements`.`pickup_location`
`rental_agreements`.`return_location`
`rental_agreements`.`mileage_out`
`rental_agreements`.`mileage_in`
`rental_agreements`.`fuel_level_out`
`rental_agreements`.`fuel_level_in`
`rental_agreements`.`destination`
`rental_agreements`.`daily_rate`
`rental_agreements`.`weekly_rate`
`rental_agreements`.`monthly_rate`
`rental_agreements`.`extra_hour_charge`
`rental_agreements`.`delivery_fee`
`rental_agreements`.`collection_fee`
`rental_agreements`.`service_tax`
`rental_agreements`.`insurance_fee`
`rental_agreements`.`miscellaneous_fee`
`rental_agreements`.`total_amount`
`rental_agreements`.`deposit_amount`
`rental_agreements`.`amount_paid`
`rental_agreements`.`balance_amount`
`rental_agreements`.`payment_method`
`rental_agreements`.`accessories_json`
`rental_agreements`.`inspection_checklist_json`
`rental_agreements`.`general_remarks`
`rental_agreements`.`customer_remarks`
`rental_agreements`.`staff_remarks`
`rental_agreements`.`customer_signature_name`
`rental_agreements`.`staff_signature_name`
`rental_agreements`.`confirmed_at`
`rental_agreements`.`cancelled_at`
`rental_agreements`.`created_at`
`rental_agreements`.`updated_at`
`system_notices`.*
`system_notices`.`notice_id`
`system_notices`.`title`
`system_notices`.`content`
`system_notices`.`created_by`
`system_notices`.`created_at`
`system_settings`.*
`system_settings`.`setting_id`
`system_settings`.`setting_key`
`system_settings`.`setting_value`
`system_settings`.`updated_at`
`ticketing_access`.*
`ticketing_access`.`user_id`
`ticketing_access`.`granted_by`
`ticketing_access`.`granted_at`
`ticketing_audit_log`.*
`ticketing_audit_log`.`id`
`ticketing_audit_log`.`action`
`ticketing_audit_log`.`record_id`
`ticketing_audit_log`.`user_id`
`ticketing_audit_log`.`user_name`
`ticketing_audit_log`.`old_values`
`ticketing_audit_log`.`new_values`
`ticketing_audit_log`.`ip_address`
`ticketing_audit_log`.`user_agent`
`ticketing_audit_log`.`created_at`
`ticketing_sales`.*
`ticketing_sales`.`id`
`ticketing_sales`.`date_issue`
`ticketing_sales`.`flight_date`
`ticketing_sales`.`trip_type`
`ticketing_sales`.`return_date`
`ticketing_sales`.`customer_dept`
`ticketing_sales`.`portal`
`ticketing_sales`.`airline`
`ticketing_sales`.`warrant_no`
`ticketing_sales`.`pnr`
`ticketing_sales`.`flight_class`
`ticketing_sales`.`pax`
`ticketing_sales`.`wpua_amt`
`ticketing_sales`.`infant_amt`
`ticketing_sales`.`tax_amt`
`ticketing_sales`.`sst_amt`
`ticketing_sales`.`fare_amt`
`ticketing_sales`.`service_charge`
`ticketing_sales`.`status`
`ticketing_sales`.`assigned_to`
`ticketing_sales`.`created_by`
`ticketing_sales`.`created_at`
`ticketing_sales`.`updated_at`
`tour_customers`.*
`tour_customers`.`id`
`tour_customers`.`name`
`tour_customers`.`phone`
`tour_customers`.`ic_number`
`tour_customers`.`ic_image`
`tour_customers`.`created_at`
`tour_package_audit_log`.*
`tour_package_audit_log`.`id`
`tour_package_audit_log`.`action`
`tour_package_audit_log`.`record_id`
`tour_package_audit_log`.`user_id`
`tour_package_audit_log`.`user_name`
`tour_package_audit_log`.`old_values`
`tour_package_audit_log`.`new_values`
`tour_package_audit_log`.`ip_address`
`tour_package_audit_log`.`created_at`
`tour_package_sales`.*
`tour_package_sales`.`id`
`tour_package_sales`.`travel_date`
`tour_package_sales`.`booking_date`
`tour_package_sales`.`guest_name`
`tour_package_sales`.`customer_id`
`tour_package_sales`.`package_type`
`tour_package_sales`.`customer_type`
`tour_package_sales`.`adult_pax`
`tour_package_sales`.`adult_price`
`tour_package_sales`.`senior_pax`
`tour_package_sales`.`senior_price`
`tour_package_sales`.`child_pax`
`tour_package_sales`.`child_price`
`tour_package_sales`.`infant_pax`
`tour_package_sales`.`infant_price`
`tour_package_sales`.`total_pax`
`tour_package_sales`.`total_invoice`
`tour_package_sales`.`total_cost`
`tour_package_sales`.`net_profit`
`tour_package_sales`.`deposit_paid`
`tour_package_sales`.`balance_due`
`tour_package_sales`.`adult_tax`
`tour_package_sales`.`senior_tax`
`tour_package_sales`.`child_tax`
`tour_package_sales`.`infant_tax`
`tour_package_sales`.`status`
`tour_package_sales`.`assigned_to`
`tour_package_sales`.`created_at`
`tour_package_sales`.`created_by`
`tour_package_sales`.`updated_at`
`user_module_access`.*
`user_module_access`.`access_id`
`user_module_access`.`user_id`
`user_module_access`.`module_id`
`user_module_access`.`can_access`
`user_module_access`.`can_create`
`user_module_access`.`can_edit`
`user_module_access`.`can_delete`
`user_module_access`.`created_at`
`user_module_access`.`updated_at`
`user_notice_views`.*
`user_notice_views`.`user_id`
`user_notice_views`.`notice_id`
`user_notice_views`.`dismissed_at`
`users`.*
`users`.`user_id`
`users`.`full_name`
`users`.`email`
`users`.`password`
`users`.`role`
`users`.`status`
`users`.`avatar`
`users`.`created_at`
`users`.`updated_at`
`users`.`session_token`
`vehicle_images`.*
`vehicle_images`.`image_id`
`vehicle_images`.`vehicle_id`
`vehicle_images`.`image_path`
`vehicle_images`.`is_main`
`vehicle_images`.`uploaded_at`
`vehicle_maintenance`.*
`vehicle_maintenance`.`id`
`vehicle_maintenance`.`vehicle_id`
`vehicle_maintenance`.`maintenance_date`
`vehicle_maintenance`.`description`
`vehicle_maintenance`.`cost`
`vehicle_maintenance`.`status`
`vehicle_maintenance`.`created_at`
`vehicle_maintenance`.`receipt_image`
`vehicles`.*
`vehicles`.`vehicle_id`
`vehicles`.`type`
`vehicles`.`plate_number`
`vehicles`.`brand`
`vehicles`.`model`
`vehicles`.`year`
`vehicles`.`engine_cc`
`vehicles`.`current_mileage`
`vehicles`.`ownership_type`
`vehicles`.`daily_rate`
`vehicles`.`three_day_rate`
`vehicles`.`weekly_rate`
`vehicles`.`hourly_rate`
`vehicles`.`insurance_rate`
`vehicles`.`corporate_rate`
`vehicles`.`status`
`vehicles`.`driver_available`
`vehicles`.`driver_rate`
`vehicles`.`corporate_driver_rate`
`vehicles`.`location`
`vehicles`.`category`
`vehicles`.`team`
`vehicles`.`notes`
`vehicles`.`created_at`
`vehicles`.`updated_at`
`work_order_audit_log`.*
`work_order_audit_log`.`id`
`work_order_audit_log`.`action`
`work_order_audit_log`.`record_id`
`work_order_audit_log`.`user_id`
`work_order_audit_log`.`user_name`
`work_order_audit_log`.`old_values`
`work_order_audit_log`.`new_values`
`work_order_audit_log`.`ip_address`
`work_order_audit_log`.`created_at`
`work_order_items`.*
`work_order_items`.`id`
`work_order_items`.`wo_id`
`work_order_items`.`item_description`
`work_order_items`.`po_number`
`work_order_items`.`item_remark`
`work_order_items`.`quantity`
`work_order_items`.`price_rm`
`work_order_receipts`.*
`work_order_receipts`.`id`
`work_order_receipts`.`wo_id`
`work_order_receipts`.`file_name`
`work_order_receipts`.`file_path`
`work_order_receipts`.`created_at`
`work_orders`.*
`work_orders`.`id`
`work_orders`.`wo_type`
`work_orders`.`company_prefix`
`work_orders`.`wo_year`
`work_orders`.`wo_month`
`work_orders`.`dept_code`
`work_orders`.`sequence_no`
`work_orders`.`full_wo_number`
`work_orders`.`date_issued`
`work_orders`.`attention_to`
`work_orders`.`subject`
`work_orders`.`item_info`
`work_orders`.`prepared_by`
`work_orders`.`bank_acc_no`
`work_orders`.`bank_name`
`work_orders`.`bank_acc_name`
`work_orders`.`status`
`work_orders`.`receipt_file`
`work_orders`.`created_at`
`work_orders`.`maint_location`
`work_orders`.`maint_technician`
`work_orders`.`maint_task`
`work_orders`.`driver_name`
`work_orders`.`driver_destination`
`work_orders`.`driver_date_from`
`work_orders`.`driver_date_to`
`work_orders`.`driver_vehicle`
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
audit_logs
blacklist
booking_images
bookings
bug_report_attachments
bug_reports
corporate_contracts
corporate_vehicle_rates
cr_audit_logs
cr_failed_login_logs
cr_system_settings
cr_users
customers
failed_login_logs
modules
notifications
rental_agreement_damages
rental_agreements
system_notices
system_settings
ticketing_access
ticketing_audit_log
ticketing_sales
tour_customers
tour_package_audit_log
tour_package_sales
user_module_access
user_notice_views
users
vehicle_images
vehicle_maintenance
vehicles
work_order_audit_log
work_order_items
work_order_receipts
work_orders
SQL query on database
ggth_erp
: