* setting_key setting_value updated_by updated_at

* id user_id request_type from_date to_date period reason status approved_by approved_at admin_remarks created_at updated_at

* id company_id user_id event auditable_type auditable_id old_values new_values url ip_address user_agent device_info created_at

* id backup_type status started_at finished_at backup_path db_files files_copied files_skipped bytes_copied message created_by created_at

* id company_id branch_code name address city state phone email is_head_office status created_at updated_at deleted_at franchisee_id

* id company_code name legal_name gst_number phone email address status created_at updated_at deleted_at

* id company_id branch_id customer_code name phone email address latitude longitude plan_name status created_at updated_at deleted_at franchisee_name mac_address expiry_at sub_package ip_address nas_ip router_serial router_type

* id department_code name status created_at updated_at deleted_at

* id company_id branch_id product_id serialized_item_id customer_id pop_location_id engineer_id installation_transaction_id install_type customer_name_snapshot install_address installed_at current_status monitoring_enabled monitoring_status last_movement_transaction_id removed_at removal_transaction_id remarks created_at updated_at deleted_at

* id user_id duty_date started_at ended_at start_lat start_lng end_lat end_lng start_accuracy end_accuracy status device_info ip_address created_at updated_at start_selfie_path start_device_id end_device_id pending_task_end_reason end_selfie_path start_meter_reading end_meter_reading start_meter_photo_path end_meter_photo_path

* id user_id duty_session_id captured_at latitude longitude accuracy_m event_type source device_info ip_address created_at client_point_id synced_from_device_at app_version_code app_version_name battery_percent

* id shift_name start_time end_time late_grace_minutes standard_hours status created_at updated_at deleted_at

* id user_id duty_session_id token_hash expires_at revoked_at created_at

* id user_id workplace_id created_at

* id title message audience_scope priority status created_by created_at expires_at

* id broadcast_id user_id seen_at

* id module media_type linked_type linked_id local_path public_path firebase_bucket firebase_object original_name mime_type file_size uploaded_by uploaded_at created_at updated_at

* id parent_id module_key name description url sort_order status created_at updated_at

* id source_label local_path_hash local_path object_name file_size file_mtime firebase_generation uploaded_at created_at updated_at

* id company_id franchisee_code franchisee_name mobile_number status created_at updated_at deleted_at

* id company_id branch_id import_type original_filename stored_file_path total_rows success_rows failed_rows status created_by created_at completed_at

* id import_log_id row_number field_name error_message row_payload created_at

* id permission_key module display_name created_at

* id duty_session_id start_meter_reading end_meter_reading km_override amount_override reason updated_by created_at updated_at

* id company_id branch_id pop_code name address latitude longitude status created_at updated_at deleted_at

* id company_id product_category_id sku name brand model unit_type serial_required mac_required warranty_required warranty_months minimum_stock_level branch_allowed active_monitoring_device qr_barcode_enabled approval_status approved_by approved_at status created_by updated_by created_at updated_at deleted_at stock_movement_class image_required minimum_order_quantity

* id product_id action old_status new_status remarks acted_by acted_at ip_address device_info

* id name category_type description status created_at updated_at

* id name status created_at

* id job_no company_id serialized_item_id repair_vendor_id fault_reported_by fault_date fault_description dispatch_transaction_id return_transaction_id repair_cost job_status final_status remarks created_at updated_at

* id company_id vendor_code name contact_person phone email address status created_at updated_at deleted_at

* id name display_name scope is_system_role created_at updated_at

* role_id permission_id created_at

* id transaction_id engineer_id outcome reason notes photo_path serial_number mac_address latitude longitude accuracy_m visited_at created_at

* migration_key description executed_by executed_at

* id company_id product_id serial_number mac_address qr_code barcode current_location_id current_condition lifecycle_status supplier_id purchase_invoice_no purchase_date warranty_start_date warranty_end_date is_installed created_at updated_at deleted_at

* id request_no company_id location_id product_id serialized_item_id requested_quantity_change reason approval_status approved_by approved_at stock_transaction_id created_by created_at updated_at

* id company_id location_id product_id stock_condition quantity updated_at

* id transfer_no stock_transaction_id stock_transaction_item_id from_user_id to_user_id installed_status status reason accepted_at created_by created_at updated_at

* id company_id branch_id location_code name location_type user_id customer_id pop_location_id supplier_id repair_vendor_id is_stock_available_location status created_at updated_at deleted_at

* id stock_transaction_item_id installed_qty balance_qty customer_reference proof_image_path remarks installed_by installed_at created_at deleted_at

* company_id location_id product_id inward_qty outward_qty stock_qty updated_at

* id transaction_no transaction_type company_id from_location_id to_location_id customer_id pop_location_id engineer_id supplier_id repair_vendor_id related_transaction_id transaction_at dispatch_confirmed_at received_confirmed_at approval_status approved_by approved_at status remarks supporting_document_path created_by updated_by ip_address device_info created_at updated_at deleted_at person_name last_visit_at last_visit_outcome last_visit_reason last_visit_photo_path last_visit_latitude last_visit_longitude last_visit_accuracy last_visit_by

* id stock_transaction_id product_id serialized_item_id quantity unit_type condition_before condition_after serial_number mac_address remarks created_at installed_status installation_proof_path installation_marked_by installation_marked_at returned_from_item_id installation_purpose customer_username replacement_reason old_router_serial old_router_mac old_router_collected stock_purpose

* id company_id supplier_code name contact_person phone email address gst_number status created_at updated_at deleted_at supplier_name supplier_type mobile_number

* id task_instance_id actor_user_id event_type message created_at attachment_path attachment_name edited_at seen_at

* id template_id title description assigned_to_user_id assigned_by_user_id due_at priority proof_required proof_path completion_remarks points status completed_at approved_by approved_at created_at updated_at not_completed_reason carried_forward_from_id approver_user_id tat_minutes

* task_instance_id observer_user_id added_by_user_id created_at

* id task_instance_id from_user_id to_user_id message status created_at seen_at

* id title description department assigned_to_user_id assigned_by_user_id priority recurrence start_date due_day due_time proof_required points status created_at updated_at deleted_at approver_user_id tat_minutes

* task_template_id observer_user_id added_by_user_id created_at

* id company_id primary_branch_id role_id employee_code name email phone password sso_provider sso_subject status last_login_at created_at updated_at deleted_at attendance_anywhere attendance_device_id attendance_device_registered_at attendance_device_reset_at attendance_device_reset_by department_id shift_id alternate_mobile nearest_relative_contact blood_group employee_address employee_id_proof_path employee_photo_path tracking_required salary_amount salary_effective_from allow_apple_web_login apple_web_device_hash apple_web_device_registered_at apple_web_device_reset_at apple_web_device_reset_by date_of_birth employee_id_proof_type employee_id_proof_number bike_meter_required

* id user_id branch_id can_issue_stock can_receive_stock can_install_device created_at

* id user_id franchisee_name created_at

* id user_id selector validator_hash expires_at user_agent ip_address created_at last_used_at revoked_at

* serialized_item_id serial_number mac_address sku product_name lifecycle_status current_condition current_location current_location_type transaction_no transaction_type transaction_at from_location to_location remarks

* company_name location_name location_type branch_name category_name sku product_name brand model stock_condition quantity unit_type minimum_stock_level is_low_stock

* id claim_no company_id serialized_item_id supplier_id fault_reported_by fault_date fault_description dispatch_transaction_id return_transaction_id claim_status final_status remarks created_at updated_at

* id workplace_code name latitude longitude radius_m status created_at updated_at deleted_at

select table app_settings attendance_requests audit_logs backup_jobs branches companies customers departments device_installations employee_duty_sessions employee_location_points employee_shifts employee_tracking_tokens employee_workplace_mappings erp_broadcast_messages erp_broadcast_reads erp_media_files erp_modules firebase_backup_files franchisees import_logs import_log_errors permissions petrol_allowance_adjustments pop_locations products product_approval_logs product_categories product_makes repair_jobs repair_vendors roles role_permissions router_collection_visits schema_migrations serialized_items stock_adjustment_requests stock_balances stock_employee_transfers stock_locations stock_partial_installations stock_summary_cache stock_transactions stock_transaction_items suppliers task_activity_logs task_instances task_observers task_reminders task_templates task_template_observers users user_branch_mappings user_franchisee_mappings user_remember_tokens vw_serial_trace vw_stock_on_hand warranty_claims workplaces . 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 app_settings attendance_requests audit_logs backup_jobs branches companies customers departments device_installations employee_duty_sessions employee_location_points employee_shifts employee_tracking_tokens employee_workplace_mappings erp_broadcast_messages erp_broadcast_reads erp_media_files erp_modules firebase_backup_files franchisees import_logs import_log_errors permissions petrol_allowance_adjustments pop_locations products product_approval_logs product_categories product_makes repair_jobs repair_vendors roles role_permissions router_collection_visits schema_migrations serialized_items stock_adjustment_requests stock_balances stock_employee_transfers stock_locations stock_partial_installations stock_summary_cache stock_transactions stock_transaction_items suppliers task_activity_logs task_instances task_observers task_reminders task_templates task_template_observers users user_branch_mappings user_franchisee_mappings user_remember_tokens vw_serial_trace vw_stock_on_hand warranty_claims workplaces .	select column