* id acctsessionid username realm nasid nasipaddress nasportid nasporttype framedipaddress acctsessiontime acctinputoctets acctoutputoctets acctstatustype macaddr dateAdded

* id title message category active created_by created_at updated_at

* id setting value

* id name_bw rate_down rate_down_unit rate_up rate_up_unit burst

* id bill_no customer_ref customer_name plan_ref plan_name period_month period_year amount status bill_date created_by created_at

* id code type value description max_usage usage_count status min_order_amount max_discount_amount start_date end_date created_at updated_at

* id username password photo pppoe_username pppoe_password pppoe_ip fullname address city district state zip phonenumber email coordinates account_type balance service_type plan_id auto_renewal status created_by created_at last_login ont_pon ont_onu

* id customer_id field_name field_value

* id customer_id date_created date_read subject body from admin_id

* id ref_no expense_date category_id description amount method paid_to expense_type created_by created_at

* id name type

* id pay_no bill_no customer_ref customer_name pay_date method amount note created_by created_at

* id date type description userid ip

* id message_type recipient message_content status error_message sent_at

* id tbl tbl_id name value

* id node_type name coordinates address area description created_at

* id name ip_address port username password enabled created_at

* id customer_id amount method reference note proof_path status reject_reason created_at verified_by verified_at

* id username user_id gateway gateway_trx_id plan_id plan_name routers_id routers price pg_url_payment payment_method payment_channel pg_request pg_paid_response expired_date created_date paid_date trx_invoice status

* id name_plan id_bw price price_old type typebp limit_type time_limit time_unit data_limit data_unit validity validity_unit shared_users routers is_radius pool plan_expired expired_date enabled allow_purchase prepaid plan_type device on_login on_logout

* id pool_name local_ip range_ip routers

* id public_ip port_name range_port routers

* id name ip_address username password description coordinates status last_seen coverage enabled

* id router_id interface rx_bytes tx_bytes rx_bps tx_bps created_at

* id ticket_no customer_id category subject description priority status staff_note created_at updated_at handled_by handled_at

* id invoice username user_id plan_id plan_name price recharged_on recharged_time expiration time method routers type note admin_id

* id root photo username fullname password phone email city subdistrict ward user_type status data last_login login_token creationdate

* id customer_id username plan_id namebp recharged_on recharged_time expiration time status method routers type admin_id

* id type routers id_plan code user status created_at used_date generated_by

* id orders position user enabled title widget content

select table rad_acct tbl_announcements tbl_appconfig tbl_bandwidth tbl_bills tbl_coupons tbl_customers tbl_customers_fields tbl_customers_inbox tbl_expenses tbl_expense_categories tbl_fin_income tbl_logs tbl_message_logs tbl_meta tbl_nodes tbl_olts tbl_payments tbl_payment_gateway tbl_plans tbl_pool tbl_port_pool tbl_routers tbl_router_traffic tbl_tickets tbl_transactions tbl_users tbl_user_recharges tbl_voucher tbl_widgets . 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 rad_acct tbl_announcements tbl_appconfig tbl_bandwidth tbl_bills tbl_coupons tbl_customers tbl_customers_fields tbl_customers_inbox tbl_expenses tbl_expense_categories tbl_fin_income tbl_logs tbl_message_logs tbl_meta tbl_nodes tbl_olts tbl_payments tbl_payment_gateway tbl_plans tbl_pool tbl_port_pool tbl_routers tbl_router_traffic tbl_tickets tbl_transactions tbl_users tbl_user_recharges tbl_voucher tbl_widgets .	select column