erp.shahsolutions.in / 127.0.0.1 / radius

There are no favourite tables.

Customise appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favourite tables Maximum number of favourite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customise the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Untitled *

v		radius admins
id : bigint(20) unsigned
email : varchar(190)
password_hash : varchar(255)
name : varchar(120)
role : enum('admin','operator','viewer')
created_at : timestamp
erp_user_id : bigint(20) unsigned

v		radius audit_logs
id : bigint(20) unsigned
admin_id : bigint(20) unsigned
action : varchar(80)
entity_type : varchar(80)
entity_id : varchar(80)
ip_address : varchar(45)
details : longtext
created_at : timestamp

v		radius customers
id : bigint(20) unsigned
account_number : varchar(32)
caf_number : varchar(64)
customer_type : enum('individual','business')
first_name : varchar(100)
last_name : varchar(100)
company_name : varchar(180)
phone : varchar(30)
alternate_phone : varchar(30)
email : varchar(190)
gstin : varchar(20)
billing_address : text
installation_address : text
city : varchar(100)
state : varchar(100)
postal_code : varchar(12)
latitude : decimal(10,7)
longitude : decimal(10,7)
status : enum('lead','pending','active','suspended','disconnected')
notes : text
created_at : timestamp
updated_at : timestamp
erp_customer_id : bigint(20) unsigned
erp_franchisee_id : bigint(20) unsigned

v		radius franchisee_plan_shares
id : bigint(20) unsigned
franchisee_profile_id : bigint(20) unsigned
plan_price_id : bigint(20) unsigned
sharing_price : decimal(12,2)
selling_price : decimal(12,2)
isp_share_percent : decimal(5,2)
franchisee_share_percent : decimal(5,2)
tax_percent : decimal(5,2)
effective_from : datetime
effective_until : datetime
enabled : tinyint(1)
created_by : bigint(20) unsigned
created_at : timestamp
updated_at : timestamp

v		radius franchisee_profiles
id : bigint(20) unsigned
erp_franchisee_id : bigint(20) unsigned
franchisee_code : varchar(50)
franchisee_name : varchar(150)
business_model : enum('deposit','revenue_share')
default_isp_share : decimal(5,2)
default_franchisee_share : decimal(5,2)
wallet_balance : decimal(14,2)
settlement_payable : decimal(14,2)
enabled : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		radius franchisee_renewals
id : bigint(20) unsigned
service_id : bigint(20) unsigned
customer_id : bigint(20) unsigned
franchisee_profile_id : bigint(20) unsigned
plan_price_id : bigint(20) unsigned
invoice_id : bigint(20) unsigned
business_model : enum('deposit','revenue_share')
sharing_price : decimal(12,2)
selling_price : decimal(12,2)
isp_share_percent : decimal(5,2)
franchisee_share_percent : decimal(5,2)
isp_share_amount : decimal(12,2)
franchisee_share_amount : decimal(12,2)
addon_amount : decimal(12,2)
tax_percent : decimal(5,2)
tax_amount : decimal(12,2)
customer_total : decimal(12,2)
wallet_deduction : decimal(12,2)
wallet_transaction_id : bigint(20) unsigned
previous_expiry : datetime
new_expiry : datetime
status : enum('completed','reversed')
created_by : bigint(20) unsigned
created_at : timestamp

v		radius franchisee_settlement_transactions
id : bigint(20) unsigned
franchisee_profile_id : bigint(20) unsigned
transaction_type : enum('share_accrual','payout','reversal','deduction','adjustment')
direction : enum('credit','debit')
amount : decimal(14,2)
payable_before : decimal(14,2)
payable_after : decimal(14,2)
renewal_id : bigint(20) unsigned
reference_number : varchar(120)
notes : varchar(255)
idempotency_key : varchar(100)
created_by : bigint(20) unsigned
created_at : timestamp

v		radius franchisee_wallet_transactions
id : bigint(20) unsigned
franchisee_profile_id : bigint(20) unsigned
transaction_type : enum('opening','topup','renewal','activation','reversal','adjustment')
direction : enum('credit','debit')
amount : decimal(14,2)
balance_before : decimal(14,2)
balance_after : decimal(14,2)
reference_type : varchar(40)
reference_id : bigint(20) unsigned
receipt_number : varchar(50)
payment_method : enum('cash','bank','upi','card','gateway','adjustment')
payment_reference : varchar(120)
notes : varchar(255)
idempotency_key : varchar(100)
created_by : bigint(20) unsigned
created_at : timestamp

v		radius invoices
id : bigint(20) unsigned
invoice_number : varchar(40)
customer_id : bigint(20) unsigned
service_id : bigint(20) unsigned
invoice_type : enum('activation','renewal','topup','adjustment')
status : enum('draft','unpaid','partial','paid','cancelled')
invoice_date : date
due_date : date
subtotal : decimal(12,2)
discount : decimal(12,2)
tax_amount : decimal(12,2)
total : decimal(12,2)
paid_amount : decimal(12,2)
notes : varchar(255)
created_by : bigint(20) unsigned
created_at : timestamp

v		radius invoice_items
id : bigint(20) unsigned
invoice_id : bigint(20) unsigned
description : varchar(255)
quantity : decimal(10,2)
unit_price : decimal(12,2)
tax_percent : decimal(5,2)
line_total : decimal(12,2)

v		radius ip_pools
id : bigint(20) unsigned
name : varchar(100)
start_ip : varchar(45)
end_ip : varchar(45)
gateway : varchar(45)
dns_servers : varchar(190)
nas_id : int(11)
enabled : tinyint(1)
notes : varchar(255)
created_at : timestamp

v		radius nas
id : int(11)
nasname : varchar(128)
shortname : varchar(32)
type : varchar(30)
ports : int(11)
secret : varchar(60)
server : varchar(64)
community : varchar(50)
description : varchar(200)
coa_port : smallint(5) unsigned
coa_secret : varchar(128)
enabled : tinyint(1)

v		radius payments
id : bigint(20) unsigned
receipt_number : varchar(40)
invoice_id : bigint(20) unsigned
customer_id : bigint(20) unsigned
amount : decimal(12,2)
payment_method : enum('cash','bank','upi','card','gateway','wallet','adjustment')
reference_number : varchar(100)
paid_at : datetime
notes : varchar(255)
received_by : bigint(20) unsigned
created_at : timestamp

v		radius plans
id : bigint(20) unsigned
name : varchar(120)
download_mbps : int(10) unsigned
upload_mbps : int(10) unsigned
monthly_price : decimal(10,2)
data_cap_gb : int(10) unsigned
session_timeout : int(10) unsigned
enabled : tinyint(1)
created_at : timestamp
plan_type : enum('base','fallback','topup','static_ip','device_rental')
billing_type : enum('prepaid','postpaid','free','demo')
data_mode : enum('unlimited','fup')
fallback_plan_id : bigint(20) unsigned
fup_period : enum('billing_cycle','daily','weekly','monthly')
burst_download_mbps : int(10) unsigned
burst_upload_mbps : int(10) unsigned
tax_percent : decimal(5,2)
tax_inclusive : tinyint(1)

v		radius plan_prices
id : bigint(20) unsigned
plan_id : bigint(20) unsigned
label : varchar(80)
duration_value : smallint(5) unsigned
duration_unit : enum('day','month','year')
price : decimal(12,2)
enabled : tinyint(1)
created_at : timestamp

v		radius plan_radius_attributes
id : bigint(20) unsigned
plan_id : bigint(20) unsigned
attribute : varchar(64)
op : char(2)
value : varchar(253)
created_at : timestamp

v		radius radacct
radacctid : bigint(20) unsigned
acctsessionid : varchar(64)
acctuniqueid : varchar(32)
username : varchar(64)
realm : varchar(64)
nasipaddress : varchar(45)
nasportid : varchar(32)
nasporttype : varchar(32)
acctstarttime : datetime
acctupdatetime : datetime
acctstoptime : datetime
acctinterval : int(11)
acctsessiontime : int(10) unsigned
acctauthentic : varchar(32)
connectinfo_start : varchar(50)
connectinfo_stop : varchar(50)
acctinputoctets : bigint(20)
acctoutputoctets : bigint(20)
calledstationid : varchar(50)
callingstationid : varchar(50)
acctterminatecause : varchar(32)
servicetype : varchar(32)
framedprotocol : varchar(32)
framedipaddress : varchar(45)
framedipv6address : varchar(45)
framedipv6prefix : varchar(45)
framedinterfaceid : varchar(44)
delegatedipv6prefix : varchar(45)
class : varchar(64)

v		radius radcheck
id : int(10) unsigned
username : varchar(64)
attribute : varchar(64)
op : char(2)
value : varchar(253)

v		radius radgroupcheck
id : int(10) unsigned
groupname : varchar(64)
attribute : varchar(64)
op : char(2)
value : varchar(253)

v		radius radgroupreply
id : int(10) unsigned
groupname : varchar(64)
attribute : varchar(64)
op : char(2)
value : varchar(253)

v		radius radius_user_access
id : bigint(20) unsigned
erp_user_id : bigint(20) unsigned
app_role : enum('admin','operator','viewer','franchisee')
erp_franchisee_id : bigint(20) unsigned
enabled : tinyint(1)
granted_by : bigint(20) unsigned
created_at : timestamp

v		radius radpostauth
id : int(10) unsigned
username : varchar(64)
pass : varchar(64)
reply : varchar(32)
authdate : timestamp

v		radius radreply
id : int(10) unsigned
username : varchar(64)
attribute : varchar(64)
op : char(2)
value : varchar(253)

v		radius radusergroup
id : int(10) unsigned
username : varchar(64)
groupname : varchar(64)
priority : int(11)

v		radius service_plan_history
id : bigint(20) unsigned
service_id : bigint(20) unsigned
plan_id : bigint(20) unsigned
plan_price_id : bigint(20) unsigned
starts_at : datetime
ends_at : datetime
price : decimal(12,2)
created_by : bigint(20) unsigned
created_at : timestamp

v		radius service_status_history
id : bigint(20) unsigned
service_id : bigint(20) unsigned
old_status : varchar(30)
new_status : varchar(30)
reason : varchar(255)
changed_by : bigint(20) unsigned
created_at : timestamp

v		radius subscribers
id : bigint(20) unsigned
username : varchar(64)
password_encrypted : text
full_name : varchar(160)
email : varchar(190)
phone : varchar(40)
address : text
plan_id : bigint(20) unsigned
status : enum('active','suspended','disabled')
expires_at : datetime
static_ip : varchar(45)
simultaneous_use : smallint(5) unsigned
created_at : timestamp
updated_at : timestamp

v		radius subscriber_services
id : bigint(20) unsigned
customer_id : bigint(20) unsigned
subscriber_id : bigint(20) unsigned
plan_id : bigint(20) unsigned
plan_price_id : bigint(20) unsigned
service_type : enum('broadband','hotspot','static_ip')
auth_protocol : enum('pppoe','ipoe','hotspot')
billing_type : enum('prepaid','postpaid','free','demo')
ip_mode : enum('dynamic','static','pool','pool_static')
ip_pool_id : bigint(20) unsigned
mac_address : varchar(32)
circuit_id : varchar(100)
router_serial : varchar(100)
installation_amount : decimal(12,2)
security_deposit : decimal(12,2)
auto_renew : tinyint(1)
dont_suspend : tinyint(1)
activated_at : datetime
expires_at : datetime
status : enum('pending','active','expired','suspended','on_hold','disconnected')
created_at : timestamp
updated_at : timestamp
erp_franchisee_id : bigint(20) unsigned

Create relationship
FOREIGN KEY
on delete
on update