* id code name address phone is_active created_at

* id card_id branch_id card_holder check_in_at check_out_at time_fee food_total net_total status

* id name description printer_target created_at track_inventory

* category_id branch_id

* id name phone points total_spent is_active created_at tax_id address tax_branch_code company_name

* id name type value is_active

* branch_id cart_data totals_data qr_data payment_data updated_at

* doc_type year last_number updated_at

* id branch_id category_id amount expense_date description user_id created_at

* id name description

* id customer_id order_id points_change type note created_at

* id ticket_name branch_id cashier_id items_json discount_json subtotal table_id kitchen_status prepared_at created_at updated_at is_guest

* id branch_id table_id order_number total_amount discount_amount tax_amount net_amount received_amount change_amount payment_type payment_type_id card_uid status kitchen_status prepared_at customer_id points_redeemed points_earned note items_json cashier_id created_at is_guest

* id order_id product_id product_name quantity price_per_unit subtotal cost_price total_price created_at kitchen_status item_key parent_id parent_key

* id name icon is_active sort_order

* setting_key setting_value setting_group branch_id updated_at

* id branch_id user_id opening_time closing_time opening_cash closing_cash_actual closing_cash_expected total_sales status note created_at

* id username password_hash full_name role branch_id is_active last_login created_at

* id name ip_address port branch_id type is_active created_at

* id category_id barcode name description image cost_price sale_price stock_qty low_stock_threshold is_active created_at updated_at printer_target

* id product_id branch_id quantity is_active last_updated

* id branch_id name zone seat_count status last_cleared_at current_ticket_id created_at

* id role menu_key is_allowed

* id card_uid card_holder status created_at

* id branch_id product_id change_qty cost_price current_stock type reason reference reference_id note user_id created_at

* id reference_no from_branch_id to_branch_id product_id quantity note created_by status notified_at created_at

* id name rate type is_active

* id invoice_number order_id branch_id issued_by customer_name customer_address customer_tax_id customer_phone subtotal vat_rate vat_amount total_amount status voided_at voided_by void_reason note created_at

* id year last_number

* id order_id requester_id reason status approved_by created_at

select table branches card_sessions categories category_branch_visibility customers discounts display_sync document_sequences expenses expense_categories loyalty_history open_tickets orders order_items payment_types pos_settings pos_shifts pos_users printers products product_stocks restaurant_tables role_permissions smart_cards stock_logs stock_transfers taxes tax_invoices tax_invoice_sequences void_requests . 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 branches card_sessions categories category_branch_visibility customers discounts display_sync document_sequences expenses expense_categories loyalty_history open_tickets orders order_items payment_types pos_settings pos_shifts pos_users printers products product_stocks restaurant_tables role_permissions smart_cards stock_logs stock_transfers taxes tax_invoices tax_invoice_sequences void_requests .	select column