* log_id user_id action module description ip_address created_at

* blacklist_id customer_id name ic_number phone reason rejection_reason status created_by created_at

* booking_id receipt_no customer_id vehicle_id rental_type start_date time_out expected_end_date expected_end_time duration_unit with_driver driver_cost rental_duration actual_return_date actual_return_time rental_days daily_rate hourly_rate insurance discount_amount extra_charges early_return_discount rental_refund_amount rental_refund_status rental_refund_date rental_refund_proof extra_charges_reason damage_charge damage_notes deposit deposit_type deposit_ref deposit_proof deposit_status deposit_refund_amount deposit_refund_date deposit_refund_proof rental_payment_type rental_payment_ref rental_payment_proof payment_status amount_paid balance_due date_paid booking_status team remarks cancellation_reason rejection_reason created_by created_at updated_at pickup_mileage pickup_mileage_image return_mileage return_mileage_image sst_type

* image_id booking_id image_path image_type uploaded_at

* report_id user_id title description status created_at updated_at

* attachment_id report_id file_path file_type uploaded_at

* id company_name vehicle_id owner_name start_date end_date contract_terms invoice_data status created_at updated_at

* id customer_id vehicle_id custom_daily_rate custom_insurance_rate created_at

* log_id user_id action_type module_name record_id description ip_address user_agent created_at

* id email ip_address user_agent attempted_at

* setting_key setting_value updated_at

* user_id name email password_hash session_token role status created_at

* customer_id name ic_number phone address ic_image license_image proof_image type notes status created_at updated_at

* id email ip_address user_agent attempted_at

* module_id module_name module_slug module_url description icon color status sort_order created_at

* notification_id user_id title message type related_module related_record_id is_read created_at

* agreement_id agreement_no booking_id customer_id vehicle_id generated_by confirmed_by status customer_name customer_ic customer_phone customer_email customer_address license_no license_expiry additional_driver_name additional_driver_ic additional_driver_phone additional_driver_address additional_driver_license_no additional_driver_license_expiry vehicle_plate vehicle_brand vehicle_model vehicle_color vehicle_year rental_start_datetime rental_end_datetime pickup_location return_location mileage_out mileage_in fuel_level_out fuel_level_in destination daily_rate weekly_rate monthly_rate extra_hour_charge delivery_fee collection_fee service_tax insurance_fee miscellaneous_fee total_amount deposit_amount amount_paid balance_amount payment_method accessories_json inspection_checklist_json general_remarks customer_remarks staff_remarks customer_signature_name staff_signature_name confirmed_at cancelled_at created_at updated_at

* damage_id agreement_id vehicle_view damage_area marker_x marker_y damage_type severity damage_note created_by created_at

* notice_id title content created_by created_at

* setting_id setting_key setting_value updated_at

* user_id granted_by granted_at

* id action record_id user_id user_name old_values new_values ip_address user_agent created_at

* id date_issue flight_date trip_type return_date customer_dept portal airline warrant_no pnr flight_class pax wpua_amt infant_amt tax_amt sst_amt fare_amt service_charge status assigned_to created_by created_at updated_at

* id name phone ic_number ic_image created_at

* id action record_id user_id user_name old_values new_values ip_address created_at

* id travel_date booking_date guest_name customer_id package_type customer_type adult_pax adult_price senior_pax senior_price child_pax child_price infant_pax infant_price total_pax total_invoice total_cost net_profit deposit_paid balance_due adult_tax senior_tax child_tax infant_tax status assigned_to created_at created_by updated_at

* user_id full_name email password role status avatar created_at updated_at session_token

* access_id user_id module_id can_access can_create can_edit can_delete created_at updated_at

* user_id notice_id dismissed_at

* vehicle_id type plate_number brand model year engine_cc current_mileage ownership_type daily_rate three_day_rate weekly_rate hourly_rate insurance_rate corporate_rate status driver_available driver_rate corporate_driver_rate location category team notes created_at updated_at

* image_id vehicle_id image_path is_main uploaded_at

* id vehicle_id maintenance_date description cost status created_at receipt_image

* id wo_type company_prefix wo_year wo_month dept_code sequence_no full_wo_number date_issued attention_to subject item_info prepared_by bank_acc_no bank_name bank_acc_name status receipt_file created_at maint_location maint_technician maint_task driver_name driver_destination driver_date_from driver_date_to driver_vehicle

* id action record_id user_id user_name old_values new_values ip_address created_at

* id wo_id item_description po_number item_remark quantity price_rm

* id wo_id file_name file_path created_at

select table audit_logs blacklist bookings booking_images bug_reports bug_report_attachments corporate_contracts corporate_vehicle_rates cr_audit_logs cr_failed_login_logs cr_system_settings cr_users customers failed_login_logs modules notifications rental_agreements rental_agreement_damages system_notices system_settings ticketing_access ticketing_audit_log ticketing_sales tour_customers tour_package_audit_log tour_package_sales users user_module_access user_notice_views vehicles vehicle_images vehicle_maintenance work_orders work_order_audit_log work_order_items work_order_receipts . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table audit_logs blacklist bookings booking_images bug_reports bug_report_attachments corporate_contracts corporate_vehicle_rates cr_audit_logs cr_failed_login_logs cr_system_settings cr_users customers failed_login_logs modules notifications rental_agreements rental_agreement_damages system_notices system_settings ticketing_access ticketing_audit_log ticketing_sales tour_customers tour_package_audit_log tour_package_sales users user_module_access user_notice_views vehicles vehicle_images vehicle_maintenance work_orders work_order_audit_log work_order_items work_order_receipts .	select column