* id email password_hash name role created_at erp_user_id

* id admin_id action entity_type entity_id ip_address details created_at

* id account_number caf_number customer_type first_name last_name company_name phone alternate_phone email gstin billing_address installation_address city state postal_code latitude longitude status notes created_at updated_at erp_customer_id erp_franchisee_id

* id franchisee_profile_id plan_price_id sharing_price selling_price isp_share_percent franchisee_share_percent tax_percent effective_from effective_until enabled created_by created_at updated_at

* id erp_franchisee_id franchisee_code franchisee_name business_model default_isp_share default_franchisee_share wallet_balance settlement_payable enabled created_at updated_at

* id service_id customer_id franchisee_profile_id plan_price_id invoice_id business_model sharing_price selling_price isp_share_percent franchisee_share_percent isp_share_amount franchisee_share_amount addon_amount tax_percent tax_amount customer_total wallet_deduction wallet_transaction_id previous_expiry new_expiry status created_by created_at

* id franchisee_profile_id transaction_type direction amount payable_before payable_after renewal_id reference_number notes idempotency_key created_by created_at

* id franchisee_profile_id transaction_type direction amount balance_before balance_after reference_type reference_id receipt_number payment_method payment_reference notes idempotency_key created_by created_at

* id invoice_number customer_id service_id invoice_type status invoice_date due_date subtotal discount tax_amount total paid_amount notes created_by created_at

* id invoice_id description quantity unit_price tax_percent line_total

* id name start_ip end_ip gateway dns_servers nas_id enabled notes created_at

* id nasname shortname type ports secret server community description coa_port coa_secret enabled

* id receipt_number invoice_id customer_id amount payment_method reference_number paid_at notes received_by created_at

* id name download_mbps upload_mbps monthly_price data_cap_gb session_timeout enabled created_at plan_type billing_type data_mode fallback_plan_id fup_period burst_download_mbps burst_upload_mbps tax_percent tax_inclusive

* id plan_id label duration_value duration_unit price enabled created_at

* id plan_id attribute op value created_at

* radacctid acctsessionid acctuniqueid username realm nasipaddress nasportid nasporttype acctstarttime acctupdatetime acctstoptime acctinterval acctsessiontime acctauthentic connectinfo_start connectinfo_stop acctinputoctets acctoutputoctets calledstationid callingstationid acctterminatecause servicetype framedprotocol framedipaddress framedipv6address framedipv6prefix framedinterfaceid delegatedipv6prefix class

* id username attribute op value

* id groupname attribute op value

* id groupname attribute op value

* id erp_user_id app_role erp_franchisee_id enabled granted_by created_at

* id username pass reply authdate

* id username attribute op value

* id username groupname priority

* id service_id plan_id plan_price_id starts_at ends_at price created_by created_at

* id service_id old_status new_status reason changed_by created_at

* id username password_encrypted full_name email phone address plan_id status expires_at static_ip simultaneous_use created_at updated_at

* id customer_id subscriber_id plan_id plan_price_id service_type auth_protocol billing_type ip_mode ip_pool_id mac_address circuit_id router_serial installation_amount security_deposit auto_renew dont_suspend activated_at expires_at status created_at updated_at erp_franchisee_id

select table admins audit_logs customers franchisee_plan_shares franchisee_profiles franchisee_renewals franchisee_settlement_transactions franchisee_wallet_transactions invoices invoice_items ip_pools nas payments plans plan_prices plan_radius_attributes radacct radcheck radgroupcheck radgroupreply radius_user_access radpostauth radreply radusergroup service_plan_history service_status_history subscribers subscriber_services . 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 admins audit_logs customers franchisee_plan_shares franchisee_profiles franchisee_renewals franchisee_settlement_transactions franchisee_wallet_transactions invoices invoice_items ip_pools nas payments plans plan_prices plan_radius_attributes radacct radcheck radgroupcheck radgroupreply radius_user_access radpostauth radreply radusergroup service_plan_history service_status_history subscribers subscriber_services .	select column