🛠️ Database Manager Suite
💻 Run Custom SQL Query
🔍 Table Schema Structure: rm_managers
| Field Name | Data Type | Null Allowed | Key Index | Default Value | Extra Attributes |
|---|---|---|---|---|---|
| managername | varchar(64) | NO | 🔑 PRIMARY KEY | NULL | |
| password | varchar(32) | NO | - | NULL | |
| firstname | varchar(50) | NO | - | NULL | |
| lastname | varchar(50) | NO | - | NULL | |
| phone | varchar(15) | NO | - | NULL | |
| mobile | varchar(15) | NO | - | NULL | |
| address | varchar(50) | NO | - | NULL | |
| city | varchar(50) | NO | - | NULL | |
| zip | varchar(8) | NO | - | NULL | |
| country | varchar(50) | NO | - | NULL | |
| state | varchar(50) | NO | - | NULL | |
| comment | varchar(200) | NO | - | NULL | |
| company | varchar(50) | NO | - | NULL | |
| vatid | varchar(40) | NO | - | NULL | |
| varchar(50) | NO | - | NULL | ||
| balance | decimal(20,2) | NO | - | NULL | |
| perm_listusers | tinyint(1) | NO | - | NULL | |
| perm_createusers | tinyint(1) | NO | - | NULL | |
| perm_editusers | tinyint(1) | NO | - | NULL | |
| perm_edituserspriv | tinyint(1) | NO | - | NULL | |
| perm_deleteusers | tinyint(1) | NO | - | NULL | |
| perm_listmanagers | tinyint(1) | NO | - | NULL | |
| perm_createmanagers | tinyint(1) | NO | - | NULL | |
| perm_editmanagers | tinyint(1) | NO | - | NULL | |
| perm_deletemanagers | tinyint(1) | NO | - | NULL | |
| perm_listservices | tinyint(1) | NO | - | NULL | |
| perm_createservices | tinyint(1) | NO | - | NULL | |
| perm_editservices | tinyint(1) | NO | - | NULL | |
| perm_deleteservices | tinyint(1) | NO | - | NULL | |
| perm_listonlineusers | tinyint(1) | NO | - | NULL | |
| perm_listinvoices | tinyint(1) | NO | - | NULL | |
| perm_trafficreport | tinyint(1) | NO | - | NULL | |
| perm_addcredits | tinyint(1) | NO | - | NULL | |
| perm_negbalance | tinyint(1) | NO | - | NULL | |
| perm_listallinvoices | tinyint(1) | NO | - | NULL | |
| perm_showinvtotals | tinyint(1) | NO | - | NULL | |
| perm_logout | tinyint(1) | NO | - | NULL | |
| perm_cardsys | tinyint(1) | NO | - | NULL | |
| perm_editinvoice | tinyint(1) | NO | - | NULL | |
| perm_allusers | tinyint(1) | NO | - | NULL | |
| perm_allowdiscount | tinyint(1) | NO | - | NULL | |
| perm_enwriteoff | tinyint(1) | NO | - | NULL | |
| perm_accessap | tinyint(1) | NO | - | NULL | |
| perm_cts | tinyint(1) | NO | - | NULL | |
| enablemanager | tinyint(1) | NO | - | NULL | |
| lang | varchar(30) | NO | - | NULL | |
| dealer_type | varchar(100) | NO | - | NULL | |
| showpass | varchar(255) | NO | - | NULL | |
| created_dealer | varchar(100) | NO | - | NULL | |
| perm_onlybilling | tinyint(1) | NO | - | NULL | |
| perm_listnases | tinyint(1) | NO | - | NULL | |
| perm_newnas | tinyint(1) | NO | - | NULL | |
| perm_editnas | tinyint(1) | NO | - | NULL | |
| perm_delnas | tinyint(1) | NO | - | NULL | |
| perm_messages | tinyint(1) | NO | - | NULL | |
| perm_expenses | tinyint(1) | NO | - | NULL | |
| perm_complaint | tinyint(1) | NO | - | NULL | |
| perm_userbalance | tinyint(1) | NO | - | NULL | |
| perm_dealerbalance | tinyint(1) | NO | - | NULL | |
| perm_autorecharge_user | tinyint(1) | NO | - | NULL | |
| perm_showdealerwise_msg | tinyint(1) | NO | - | NULL | |
| perm_areawiseuser | varchar(100) | NO | - | NULL | |
| perm_activemultiuser | tinyint(1) | NO | - | NULL | |
| expirydate_fixed | varchar(50) | NO | - | NULL | |
| expirydate | tinyint(1) | NO | - | NULL | |
| perm_editableuserbill | tinyint(1) | NO | - | NULL | |
| perm_api | tinyint(1) | NO | - | NULL | |
| perm_onlyrecharge | varchar(4) | NO | - | NULL | |
| perm_editexpirydate | tinyint(1) | NO | - | NULL | |
| cnic_front | varchar(255) | NO | - | NULL | |
| cnic_back | varchar(255) | NO | - | NULL | |
| perm_allareas | tinyint(1) | NO | - | NULL | |
| expiry_date | date | NO | - | NULL | |
| created_date | date | NO | - | NULL | |
| expiry_limit | tinyint(2) | NO | - | NULL | |
| logoname | varchar(20) | NO | - | NULL | |
| logofile | varchar(255) | NO | - | NULL | |
| allowed_user | varchar(100) | NO | - | NULL | |
| onlyareawise | varchar(10) | NO | - | NULL | |
| mac_clear | tinyint(1) | NO | - | NULL | |
| change_conn_pass | tinyint(1) | NO | - | NULL | |
| disable_conn | tinyint(1) | NO | - | NULL | |
| show_conn_pass | tinyint(1) | NO | - | NULL | |
| show_user_status | tinyint(1) | NO | - | NULL | |
| show_live_graph | tinyint(1) | NO | - | NULL | |
| show_clock | tinyint(1) | NO | - | NULL | |
| system_cpu | tinyint(1) | NO | - | NULL | |
| system_uptime | tinyint(1) | NO | - | NULL |
📊 Data Preview: rm_managers (Limit 100)
This table is currently empty.