* id invoice_no invoice_date registration_no room_id customer_id booking_type check_in_date check_out_date actual_checkout_date check_in_time check_out_time total_price deposit deposit_transfer status payment_status payment_method paid_at paid_by discount_type discount_value discount_note notes created_at slip_image

* id fullname phone email id_card nationality address occupation arriving_from departing_to created_at

* id booking_id service_name price quantity created_at

* id user_id product_id product_name price qty total payment_method created_at

* id name type status printer_ip printer_width printer_ip_kitchen printer_ip_bar

* id name color status branch_ids printer_type

* id phone fullname points tier created_at

* id branch_id table_id user_id room_id customer_name status payment_method subtotal discount tax total created_at updated_at shift_id member_id promo_id discount_amount vat_amount service_charge_amount is_void void_reason void_by void_at is_takeaway paid_at

* id order_id product_id product_name price qty total status created_at

* id category_id name price cost_price stock_qty image status is_track_stock type show_restaurant show_pub show_minimart

* product_id branch_id stock_qty

* id promo_code name discount_type discount_value min_spend start_date end_date status created_at

* id name unit stock_qty cost_per_unit status

* id product_id raw_material_id qty_used

* id name permissions is_system

* id branch_id user_id starting_cash ending_cash expected_cash opened_at closed_at status

* id product_id user_id action qty reason created_at

* id branch_id requested_by approved_by product_id qty note status requested_at approved_at

* id branch_id table_name status

* id username password role_id branch_id fullname status created_at pin_code

* id room_number room_type name capacity price status cleaning_status description image_url created_at

* id user_id shift_date shift_label opened_at closed_at opening_cash closing_cash expected_cash difference notes status

* setting_key setting_value updated_at

* id username password fullname role created_at

select table bookings customers extra_services frontdesk_sales pos_branches pos_categories pos_members pos_orders pos_order_items pos_products pos_product_branches pos_promotions pos_raw_materials pos_recipes pos_roles pos_shifts pos_stock_logs pos_stock_requests pos_tables pos_users rooms shifts system_settings users . 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 bookings customers extra_services frontdesk_sales pos_branches pos_categories pos_members pos_orders pos_order_items pos_products pos_product_branches pos_promotions pos_raw_materials pos_recipes pos_roles pos_shifts pos_stock_logs pos_stock_requests pos_tables pos_users rooms shifts system_settings users .	select column