* id company_name tagline address phone email logo_url created_at updated_at trn

* id user_id first_name last_name display_name gender mobile_number email password_hash date_of_birth image_url address total_spent last_visit created_at updated_at

* id invoice_id job_card_id customer_id invoice_number customer_name amount payment_method payment_date advance_applied invoice_subtotal invoice_tax invoice_total invoice_remaining_before invoice_remaining_after notes created_at payment_type

* id name email phone vehicle_count quotation_count job_card_count proforma_invoice_count invoice_count total_spent last_visit

* id description amount tax total_amount quantity unit_price category payment_method payment_date status vendor invoice_number notes trn approved_by created_at

* month total_income total_expenses net_profit

* id customer_name invoice_number amount payment_method payment_date status category description received_by created_at source customer_payment_id

* id proforma_invoice_id job_card_id customer_id quotation_id invoice_number subtotal tax total_amount advance_amount remaining_amount status due_date paid_date payment_method notes customer_name customer_email customer_phone vehicle_brand vehicle_name vehicle_year vehicle_license_plate vin_number created_at updated_at

* id invoice_id description quantity unit_price total type supplier_id product_id stock_deducted created_at

* id job_card_number quotation_id customer_id vehicle_id assigned_to status priority start_date completion_date actual_labor_hours notes subtotal tax total_amount created_at updated_at advance_amount

* id job_card_id user_id labour_hours created_at

* id job_card_id before_file_path after_file_path description sort_order created_at

* id job_card_id description quantity unit_price total type supplier_id product_id created_at is_done

* id job_card_id file_path caption type created_at

* id job_card_id description completed sort_order created_at

* id supplier_id name description sku category unit_price cost_price stock_quantity min_stock_level max_stock_level unit status created_at updated_at

* id job_card_id customer_id quotation_id proforma_number subtotal tax total_amount advance_amount remaining_amount status notes created_at updated_at

* id proforma_invoice_id description quantity unit_price total type supplier_id product_id created_at

* id quotation_number customer_id vehicle_id customer_name vehicle_info subtotal tax total_amount remaining_amount status valid_until notes created_at updated_at vehicle_inspection_report_id

* id quotation_id description quantity unit_price total type supplier_id product_id created_at

* id product_id type quantity reference_type reference_id reference_display created_at

* id vendor_name payment_date trn payment_method payment_status invoice_number notes total_amount item_count created_at description expense_id

* id batch_id product_id product_name quantity buying_price amount vat_applied created_at

* id name email phone address rating products_count total_orders status category created_at updated_at display_name trn work_phone mobile address_line_1 bank_name account_number iban swift_code branch

* id email password_hash name role phone address emirates_id_file_path passport_file_path created_at updated_at

* id vehicle_id customer_id brand name license_plate vin_number year color odometer_reading last_service_date next_service_date status fuel_type engine_size transmission images created_at updated_at insurance_start_date insurance_expiry_date mulkiya_start_date mulkiya_expiry_date traffic_plate_number

* id name description logo_url created_at updated_at

* id vehicle_id type file_path name created_at

* id brand_id name description category created_at updated_at

select table company_settings customers customer_payments customer_summary expenses financial_summary income invoices invoice_items job_cards job_card_assignments job_card_before_after job_card_items job_card_photos job_card_tasks products proforma_invoices proforma_invoice_items quotations quotation_items stock_changes stock_topup_batches stock_topup_batch_items suppliers users vehicles vehicle_brands vehicle_documents vehicle_names . 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 company_settings customers customer_payments customer_summary expenses financial_summary income invoices invoice_items job_cards job_card_assignments job_card_before_after job_card_items job_card_photos job_card_tasks products proforma_invoices proforma_invoice_items quotations quotation_items stock_changes stock_topup_batches stock_topup_batch_items suppliers users vehicles vehicle_brands vehicle_documents vehicle_names .	select column