* log_id user_id action affected_user_id created_at log_type

* log_id admin_id action user_id details created_at

* id username password created_at

* id username user_id password full_name phone email created_date updated_date last_login status role profile_image login_attempts locked_until

* id borrower_name borrower_department reason blacklist_date expiry_date status created_by notes

* id equipment_id transaction_type quantity user_name notes attachment approver_name return_signature borrow_signature borrower_name borrower_department borrower_phone borrowed_date purpose borrow_date due_date expected_return_date actual_return_date borrow_request_id status user_id condition_on_return return_notes created_at

* id doc_no book_date work_time use_date return_date depart_time return_time car_type destination map_url contact_name job_no has_map contact_tel pickup_location pickup_datetime has_staff staff_data job_type detail detail2 return_type return_location car_plate vehicle_id driver_name requester_sign requester_tel status created_by created_at updated_at

* id reservation_id filename uploaded_by created_at

* id name

* status priority total_contacts this_week this_month

* id username fullname department password email role status created_at

* id user_id password driver_name nickname contact_number license_type skills photo gps_consent status created_at

* id team_name employee_id full_name department photo created_at team_color status daily_wage ot_wage

* id img name model brand serial_number serial quantity category_id description status condition_status location purchase_date purchase_price warranty_expiry last_maintenance image_path created_at updated_at

* id name description color status created_at updated_at

* id equipment_id transaction_id condition_before condition_after damage_description repair_needed repair_cost inspector_name inspection_date notes

* id equipment_id maintenance_type maintenance_date next_maintenance_date cost description status technician notes created_at

* id equipment_id transaction_type quantity user_name notes created_at attachment approver_name return_signature borrow_signature borrower_name borrower_department borrower_phone returner_name returner_department returner_position returner_code purpose borrow_date expected_return_date actual_return_date borrow_request_id status user_id condition_on_return return_notes receiver_name receiver_role signature_borrower signature_receiver related_borrow_id

* id equipment_id total_borrows total_returns overdue_count damage_count total_usage_hours average_rating last_borrowed_date last_returned_date updated_at

* id user_id user_name role department max_approval_amount is_active created_at updated_at

* id breakdown_id file_name file_path file_type file_size description uploaded_by uploaded_by_name created_at

* id foreman_id foreman_name project_name job_number customer project_owner location required_date installation_date status remarks created_at updated_at submitted_at approved_at approved_by approved_by_name rejected_at rejected_by rejected_by_name rejection_reason store_confirmed_by store_confirmed_by_name store_confirmed_at

* id breakdown_id material_id material_code material_name brand order_date required_qty required_unit stock_qty stock_unit order_qty approved_qty actual_qty received_qty received_date received_by item_remarks is_paid is_checked checked_by checked_at paid_by paid_at created_at updated_at sort_order

* id breakdown_id action user_id user_name user_role old_status new_status remarks ip_address created_at

* id item_id received_no received_qty received_date received_by issued_by warehouse_history_id remarks created_at updated_at

* id password full_name nickname department photo photo_filename signature created_at updated_at

* id holiday_name holiday_date description

* id date category item_name required_date product_code brand size note quantity unit price_before_vat price_with_vat total_price pr_number foreman job_number job_name vendor vendor_phone po_number order_by order_date appointment_date received_date received_by invoice_number status created_by created_date updated_at

* id name_item detail Rem_Amt type img

* id item_id job_number operator type quantity remark transaction_date

* type_id type_name

* id name department position name_leader phone email image status approval_status approved_by approved_date member_code notes created_at updated_at

* id equipment_code equipment_name equipment_type brand model serial_number size location status stock_quantity min_quantity image_path notes created_at updated_at last_stock_update

* id name email subject company project_type priority days_waiting created_at

* id purchase_order_id category item_name product_code brand quantity unit unit_price unit_price_vat total_price remarks

* id order_date product_type item_name required_date product_code brand size remark quantity unit price_before_vat price_with_vat total_amount pr_number foreman job_number job_name vendor phone po_number ordered_by order_date_time expected_date received_date received_by invoice_no created_at updated_at

* id update_date category product_name required_date product_code brand size note quantity unit price_before_vat price_with_vat total_amount pr_number foreman job remarks vendor phone_number po order_person order_date delivery_date received_date receiver invoice_bill image created_at updated_at

* id qa_store_id image_name original_name file_path file_size mime_type image_type upload_order uploaded_at updated_at

* id name email phone subject message_preview company project_type status priority created_at

* id transaction_id evidence_type file_path file_name file_size description uploaded_by created_at

* id transaction_id borrower_rating service_rating equipment_quality_rating feedback_message suggestions submitted_at

* id borrow_id equipment_id quantity_returned return_date condition_on_return return_notes return_signature attachment_file processed_by created_at

* id transaction_id notification_type message sent_at read_at created_at

* id transaction_id returner_signature receiver_signature return_condition return_notes created_at

* id name permissions created_at updated_at

* id equipment_id action quantity notes created_at

* id name contact_info

* id role_id system_key can_access created_at updated_at

* id setting_key setting_value setting_type description is_public created_at updated_at

* id department team_name team_leader leader_photo created_at updated_at

* id team_id member_name member_photo created_at

* id img name model brand serial quantity description status location created_at

* id category_name description created_at

* id reservation_id driver_name status lat lng location_text note reported_at mileage

* id traffic_report_id filename uploaded_by uploaded_at

* user_id username password email role_id created_at status approved_by approved_at

* id user_id username action_type module action_description ip_address user_agent additional_data created_at

* id user_id session_id ip_address user_agent created_at last_activity is_active

* id car_plate car_type res_car_type vehicle_kind brand model car_year color fuel_type engine_cc engine_cylinders horsepower_hp cargo_width_m cargo_length_m cargo_height_m timing_system timing_note chassis_no engine_no reg_date reg_date_text vehicle_age_years reg_expire insurance_co insurance_no insurance_expire inspect_expire last_service_km last_service_date next_service_km next_service_date current_km gross_weight_kg curb_weight_kg payload_weight_kg department assigned_driver remark status created_at

* id vehicle_id filename sort_order created_at

* id vehicle_id car_plate repair_date repair_type description cost garage mileage_at_repair next_repair_km next_repair_date note created_by created_at

* source_table id equipment_id equipment_name category borrower_name borrower_department borrower_phone quantity borrow_date expected_return_date actual_return_date status purpose days_overdue

* borrower_name borrower_department borrower_phone total_items overdue_items first_borrow_date last_expected_return

* equipment_id equipment_name model brand quantity equipment_status total_borrows currently_borrowed last_borrow_date last_return_date availability_status

* id category_name created_at is_active

* id user_id setting_name column_order created_at updated_at

* id product_code brand category product_name quantity unit barcode shelf location created_by image created_at updated_at price cost supplier minimum_stock status description

* id product_id receive_date status transaction_type quantity job_number job_name supplier foreman recorder created_at po_id

* id logged_at action username product_id product_name product_code barcode field new_value query_text

* id unit_name created_at is_active

* id name email phone subject message company project_type budget_range status priority ip_address user_agent source_page admin_notes replied_by replied_at created_at updated_at

* id title content image author_id author_name status priority views created_date updated_date published_date

* id job_number name_job detail images status created_by created_at updated_at view_count

* id product_name main_image secondary_images product_video price description status created_by created_at updated_at view_count

* id withdrawal_number withdrawal_date job_number project_name requester remarks created_at

* id withdrawal_id item_name quantity unit remarks

* id parent_id team_id team_name department job_number job_title supervisor team_leader work_type work_type_label start_date start_time end_date end_time location province description members status created_by created_at updated_at

* id work_plan_id file_name original_name file_type file_size uploaded_by uploaded_at

select table activity_logs admin_logs admin_users ad_user borrower_blacklist borrow_transactions car_reservations car_reservation_photos categories contact_summary data_user drivers employees equipments equipment_categories equipment_condition_history equipment_maintenance equipment_transactions equipment_usage_stats foreman_approvers foreman_material_attachments foreman_material_breakdown foreman_material_items foreman_material_logs foreman_material_received foreman_users holidays incoming_items led_item led_transactions led_types loan_members media_equipment pending_contacts purchase_items purchase_orders qa_in_store qa_in_store_images recent_contacts return_evidence return_feedback return_logs return_notifications return_signatures roles stock_logs suppliers system_permissions system_settings teams team_members tools_new tool_categories traffic_reports traffic_report_photos users user_activity_logs user_sessions vehicles vehicle_photos vehicle_repairs v_all_borrowing v_borrowing_stats v_borrow_summary warehouse_categories warehouse_column_settings warehouse_products warehouse_receive_history warehouse_scan_log warehouse_units wep_contact wep_news wep_performances wep_products withdrawals withdrawal_items work_plans work_plan_files . 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 activity_logs admin_logs admin_users ad_user borrower_blacklist borrow_transactions car_reservations car_reservation_photos categories contact_summary data_user drivers employees equipments equipment_categories equipment_condition_history equipment_maintenance equipment_transactions equipment_usage_stats foreman_approvers foreman_material_attachments foreman_material_breakdown foreman_material_items foreman_material_logs foreman_material_received foreman_users holidays incoming_items led_item led_transactions led_types loan_members media_equipment pending_contacts purchase_items purchase_orders qa_in_store qa_in_store_images recent_contacts return_evidence return_feedback return_logs return_notifications return_signatures roles stock_logs suppliers system_permissions system_settings teams team_members tools_new tool_categories traffic_reports traffic_report_photos users user_activity_logs user_sessions vehicles vehicle_photos vehicle_repairs v_all_borrowing v_borrowing_stats v_borrow_summary warehouse_categories warehouse_column_settings warehouse_products warehouse_receive_history warehouse_scan_log warehouse_units wep_contact wep_news wep_performances wep_products withdrawals withdrawal_items work_plans work_plan_files .	select column