Recent
`bank_complaint_system`.`audit_logs`
`incidencereport`.`bankbranch`
`information_schema`.`INNODB_CMP`
`information_schema`.`EVENTS`
`information_schema`.`TABLE_CONSTRAINTS`
`information_schema`.`KEY_CACHES`
`information_schema`.`USER_PRIVILEGES`
`mysql`.`innodb_table_stats`
`mysql`.`innodb_index_stats`
`mysql`.`proc`
Favorites
There are no favorite tables.
New
adaverificat
bank_complaint_system
citizens_community_bank
esusdb
esusdb22
incidencereport
information_schema
mobile_payment_system
mysql
performance_schema
phpmyadmin
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customize 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
).
main
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.
Favorite tables
Maximum number of favorite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customize 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
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
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
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: esusdb22
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Tracking
Designer
Central columns
Console
Clear
History
Options
Bookmarks
Debug SQL
Press Ctrl+Enter to execute query
Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse
Expand
Show trace
Hide trace
Count :
Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Label:
Target database:
Share this bookmark
OK
Options
Set default
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 :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Switch to
visual builder
Saved bookmarked search:
New bookmark
Column:
`bank`.*
`bank`.`1`
`bank`.`bankname`
`bankbranch`.*
`bankbranch`.`bb_id`
`bankbranch`.`BankName`
`bankbranch`.`BranchName`
`bankbranch`.`Quantity`
`bankbranch`.`QtyDisposal`
`bankbranch`.`QtyAuction`
`bankbranch`.`QtyTransferFrom`
`bankbranch`.`QtyTransferTo`
`bankbranch`.`Bcode`
`bankbranch`.`Branch`
`branchcode`.*
`branchcode`.`branchid`
`branchcode`.`branchcode`
`branchcode`.`branchname`
`branchcode`.`AccountType`
`branchlocation`.*
`branchlocation`.`Bra_id`
`branchlocation`.`BranchName`
`branchlocation`.`Location`
`branchlocation`.`NewLocation`
`cashdenomination`.*
`cashdenomination`.`id`
`cashdenomination`.`Denomination`
`cashdenomination`.`DenomType`
`ccb_announcements`.*
`ccb_announcements`.`id`
`ccb_announcements`.`title`
`ccb_announcements`.`category`
`ccb_announcements`.`content`
`ccb_announcements`.`staff_name`
`ccb_announcements`.`department`
`ccb_announcements`.`effective_date`
`ccb_announcements`.`image`
`ccb_announcements`.`priority`
`ccb_announcements`.`status`
`ccb_announcements`.`created_by`
`ccb_announcements`.`created_at`
`ccb_leave_allocation`.*
`ccb_leave_allocation`.`id`
`ccb_leave_allocation`.`staff_id`
`ccb_leave_allocation`.`staff_name`
`ccb_leave_allocation`.`department`
`ccb_leave_allocation`.`position`
`ccb_leave_allocation`.`year`
`ccb_leave_allocation`.`annual_days`
`ccb_leave_allocation`.`casual_days`
`ccb_leave_allocation`.`sick_days`
`ccb_leave_allocation`.`maternity_days`
`ccb_leave_allocation`.`compassionate_days`
`ccb_leave_allocation`.`study_days`
`ccb_leave_allocation`.`annual_used`
`ccb_leave_allocation`.`casual_used`
`ccb_leave_allocation`.`sick_used`
`ccb_leave_allocation`.`annual_balance`
`ccb_leave_allocation`.`status`
`ccb_leave_allocation`.`allocated_by`
`ccb_leave_allocation`.`created_at`
`ccb_leave_requests`.*
`ccb_leave_requests`.`id`
`ccb_leave_requests`.`staff_name`
`ccb_leave_requests`.`staff_id`
`ccb_leave_requests`.`department`
`ccb_leave_requests`.`branch_type`
`ccb_leave_requests`.`is_dept_head`
`ccb_leave_requests`.`position`
`ccb_leave_requests`.`leave_type`
`ccb_leave_requests`.`from_date`
`ccb_leave_requests`.`to_date`
`ccb_leave_requests`.`days`
`ccb_leave_requests`.`resumption_date`
`ccb_leave_requests`.`reason`
`ccb_leave_requests`.`contact_phone`
`ccb_leave_requests`.`email`
`ccb_leave_requests`.`handing_over_to`
`ccb_leave_requests`.`status`
`ccb_leave_requests`.`current_stage`
`ccb_leave_requests`.`approved_by`
`ccb_leave_requests`.`approved_date`
`ccb_leave_requests`.`hr_forwarded`
`ccb_leave_requests`.`created_at`
`ccb_leave_workflow`.*
`ccb_leave_workflow`.`id`
`ccb_leave_workflow`.`leave_id`
`ccb_leave_workflow`.`step_order`
`ccb_leave_workflow`.`role_name`
`ccb_leave_workflow`.`approver_name`
`ccb_leave_workflow`.`approver_id`
`ccb_leave_workflow`.`status`
`ccb_leave_workflow`.`action_date`
`ccb_leave_workflow`.`remarks`
`ccb_leave_workflow`.`created_at`
`chartable`.*
`chartable`.`id`
`chartable`.`name`
`companydetails`.*
`companydetails`.`id`
`companydetails`.`BOXNO`
`companydetails`.`HEADOFFICE`
`companydetails`.`EMAIL`
`companydetails`.`WEBSITE`
`companydetails`.`bankname`
`customer_detals`.*
`customer_detals`.`C_Details_id`
`customer_detals`.`Customer_Name`
`customer_detals`.`AccountNumber`
`customer_detals`.`Email_Address`
`customer_detals`.`ContactNo`
`customer_detals`.`Date_Created`
`customer_detals`.`AgentName`
`customer_detals`.`AccountNumberG`
`customer_detals`.`BankBranch`
`customer_detals`.`AgentContactno`
`customer_detals`.`AgentSignOnName`
`customer_detals`.`AgentID`
`customer_detals`.`GenderStatus`
`customer_detals`.`Accoun2`
`customer_detals`.`Branchname`
`customer_detals`.`Accountno`
`customer_detals`.`PassportPhoto`
`customer_detals`.`SignaturePhoto`
`customer_detals`.`PhotoPath`
`customer_detals`.`SigPath`
`customer_detals`.`GhanaCard`
`customer_detals`.`GhanaCardFront`
`customer_detals`.`GhanaCardBack`
`customer_detals`.`GhanaCardDOB`
`customer_detals`.`GhanaCardVerified`
`dailydeposit`.*
`dailydeposit`.`DailyD_id`
`dailydeposit`.`DepositDate`
`dailydeposit`.`AgentAccNo`
`dailydeposit`.`AgentName`
`dailydeposit`.`TotalCustomers1`
`dailydeposit`.`DepositAmt`
`dailydeposit`.`BankBranch`
`dailydeposit`.`AgentName2`
`dr_backup_transactions`.*
`dr_backup_transactions`.`id`
`dr_backup_transactions`.`BankBranch`
`dr_backup_transactions`.`Accno`
`dr_backup_transactions`.`CreditAmount`
`dr_backup_transactions`.`Transid`
`dr_backup_transactions`.`full_json`
`dr_backup_transactions`.`created_at`
`fd_products`.*
`fd_products`.`id`
`fd_products`.`product_code`
`fd_products`.`product_name`
`fd_products`.`interest_rate`
`fd_products`.`duration_months`
`fd_products`.`status`
`fixed_deposit`.*
`fixed_deposit`.`id`
`fixed_deposit`.`branch`
`fixed_deposit`.`applicant_name`
`fixed_deposit`.`dob`
`fixed_deposit`.`accno`
`fixed_deposit`.`id_type`
`fixed_deposit`.`id_number`
`fixed_deposit`.`tel`
`fixed_deposit`.`scheme`
`fixed_deposit`.`rollover`
`fixed_deposit`.`rollover_type`
`fixed_deposit`.`period`
`fixed_deposit`.`value_date`
`fixed_deposit`.`maturity_date`
`fixed_deposit`.`amount`
`fixed_deposit`.`amount_words`
`fixed_deposit`.`agent`
`fixed_deposit`.`created_at`
`ghana_card_verification`.*
`ghana_card_verification`.`id`
`ghana_card_verification`.`acc`
`ghana_card_verification`.`ghana_card`
`ghana_card_verification`.`dob`
`ghana_card_verification`.`front_path`
`ghana_card_verification`.`back_path`
`ghana_card_verification`.`verified_by`
`ghana_card_verification`.`verified_at`
`ghana_card_verification`.`match_score`
`ghana_cards`.*
`ghana_cards`.`id`
`ghana_cards`.`member_id`
`ghana_cards`.`card_number`
`ghana_cards`.`full_name`
`ghana_cards`.`dob`
`ghana_cards`.`gender`
`ghana_cards`.`address`
`ghana_cards`.`front_photo`
`ghana_cards`.`back_photo`
`ghana_cards`.`verified`
`ghana_cards`.`created_at`
`group_attendance`.*
`group_attendance`.`id`
`group_attendance`.`group_id`
`group_attendance`.`meeting_id`
`group_attendance`.`member_id`
`group_attendance`.`is_present`
`group_attendance`.`remarks`
`group_attendance`.`created_at`
`group_meetings`.*
`group_meetings`.`id`
`group_meetings`.`group_id`
`group_meetings`.`meeting_date`
`group_meetings`.`meeting_time`
`group_meetings`.`location`
`group_meetings`.`gps`
`group_meetings`.`attendance_total`
`group_meetings`.`attendance_present`
`group_meetings`.`notes`
`group_meetings`.`photo`
`group_meetings`.`created_by`
`group_meetings`.`created_at`
`group_members`.*
`group_members`.`id`
`group_members`.`group_id`
`group_members`.`full_name`
`group_members`.`phone`
`group_members`.`account_no`
`group_members`.`role`
`group_members`.`gender`
`group_members`.`dob`
`group_members`.`residential_address`
`group_members`.`gps_address`
`group_members`.`id_type`
`group_members`.`id_number`
`group_members`.`occupation`
`group_members`.`kin_name`
`group_members`.`kin_phone`
`group_members`.`photo`
`group_members`.`signature`
`group_members`.`is_present`
`group_members`.`created_at`
`group_treasury`.*
`group_treasury`.`id`
`group_treasury`.`group_id`
`group_treasury`.`member_id`
`group_treasury`.`type`
`group_treasury`.`amount`
`group_treasury`.`balance_after`
`group_treasury`.`description`
`group_treasury`.`receipt_no`
`group_treasury`.`created_at`
`iptabl22n`.*
`iptabl22n`.`ipd_id`
`iptabl22n`.`name`
`iptabl22n`.`amt`
`iptabl22n`.`norow`
`iptabl22n`.`agentNo`
`iptabl22n`.`Transno`
`iptabl22n`.`InputterName`
`iptabl22n`.`Transdate`
`iptabl22n`.`TotalAmt`
`iptabl22n`.`Agentid`
`iptabl22n`.`AgentNum`
`iptabl22n`.`Agentgender`
`loan_products`.*
`loan_products`.`id`
`loan_products`.`product_code`
`loan_products`.`product_name`
`loan_products`.`interest_rate`
`loan_products`.`status`
`loan_repayments`.*
`loan_repayments`.`id`
`loan_repayments`.`loan_id`
`loan_repayments`.`group_id`
`loan_repayments`.`member_id`
`loan_repayments`.`amount`
`loan_repayments`.`payment_date`
`loan_repayments`.`method`
`loan_repayments`.`receipt_no`
`loan_repayments`.`created_at`
`loans`.*
`loans`.`id`
`loans`.`group_id`
`loans`.`member_id`
`loans`.`amount`
`loans`.`interest_rate`
`loans`.`interest_amount`
`loans`.`total_payable`
`loans`.`amount_paid`
`loans`.`balance`
`loans`.`purpose`
`loans`.`repayment_period`
`loans`.`due_date`
`loans`.`status`
`loans`.`disbursed_date`
`loans`.`created_at`
`mailset2`.*
`mailset2`.`id`
`mailset2`.`Bankname`
`mailset2`.`Name`
`mailset2`.`Emadd`
`mailset2`.`empass`
`mailset2`.`Hostname`
`mailset2`.`portnumber`
`mailset2`.`securetype`
`mailset2`.`status`
`mailset2`.`Messsage`
`mailset2`.`Subject`
`mailset2`.`message2`
`mailset2`.`message3`
`mailset2`.`AboutPass1`
`mailset2`.`AboutPass2`
`mailset2`.`AboutPass3`
`mailset2`.`AboutPass4`
`micro_groups`.*
`micro_groups`.`id`
`micro_groups`.`group_code`
`micro_groups`.`group_name`
`micro_groups`.`branch_id`
`micro_groups`.`meeting_days`
`micro_groups`.`meeting_time`
`micro_groups`.`meeting_location`
`micro_groups`.`location_gps`
`micro_groups`.`contact_address`
`micro_groups`.`treasury_amount`
`micro_groups`.`group_leader_name`
`micro_groups`.`group_leader_phone`
`micro_groups`.`group_leader_photo`
`micro_groups`.`group_leader_signature`
`micro_groups`.`chairman_name`
`micro_groups`.`chairman_signature`
`micro_groups`.`secretary_name`
`micro_groups`.`secretary_signature`
`micro_groups`.`treasurer_name`
`micro_groups`.`treasurer_signature`
`micro_groups`.`organizer_name`
`micro_groups`.`organizer_signature`
`micro_groups`.`group_photo`
`micro_groups`.`total_members`
`micro_groups`.`status`
`micro_groups`.`created_at`
`micro_groups`.`updated_at`
`passhistory`.*
`passhistory`.`pa_id`
`passhistory`.`SignOnName`
`passhistory`.`Fullname`
`passhistory`.`DateTime`
`passhistory`.`Comment`
`salary_advance`.*
`salary_advance`.`id`
`salary_advance`.`accno`
`salary_advance`.`customer_name`
`salary_advance`.`address`
`salary_advance`.`tel`
`salary_advance`.`occupation`
`salary_advance`.`monthly_salary`
`salary_advance`.`current_loan`
`salary_advance`.`monthly_ded`
`salary_advance`.`expiry`
`salary_advance`.`amount_requested`
`salary_advance`.`purpose`
`salary_advance`.`app_date`
`salary_advance`.`signature_path`
`salary_advance`.`off_balance`
`salary_advance`.`rec_amount`
`salary_advance`.`app_amount`
`salary_advance`.`agent`
`salary_advance`.`created_at`
`savings`.*
`savings`.`id`
`savings`.`group_id`
`savings`.`member_id`
`savings`.`amount`
`savings`.`date`
`savings`.`note`
`savings`.`created_at`
`settings`.*
`settings`.`key`
`settings`.`value`
`settings2`.*
`settings2`.`key`
`settings2`.`value`
`sms_log`.*
`sms_log`.`id`
`sms_log`.`acc`
`sms_log`.`channel`
`sms_log`.`sent_to`
`sms_log`.`total`
`sms_log`.`count_txn`
`sms_log`.`message`
`sms_log`.`sent_by`
`sms_log`.`sent_at`
`sms_settings`.*
`sms_settings`.`id`
`sms_settings`.`api_key`
`sms_settings`.`sender_id`
`sms_settings`.`cost`
`sms_settings`.`status`
`sms_settings`.`cost_per_sms`
`sms_settings`.`api_status`
`specailchar`.*
`specailchar`.`id`
`specailchar`.`specsd`
`specialchar`.*
`specialchar`.`id`
`specialchar`.`specsd`
`susumobile`.*
`susumobile`.`Sus_id`
`susumobile`.`Accountno`
`susumobile`.`Accountname`
`susumobile`.`AccountNum`
`susumobile`.`shortnum`
`susumobile`.`Accono1`
`susumobile`.`Accoun2`
`susumobile`.`Accoun3`
`susumobile`.`Branchname`
`susumobile2`.*
`susumobile2`.`Sus_id`
`susumobile2`.`Accountno`
`susumobile2`.`Accountname`
`susumobile2`.`AccountNum`
`susumobile2`.`shortnum`
`susumobile4`.*
`susumobile4`.`Sus_id`
`susumobile4`.`Accountno`
`susumobile4`.`Accountname`
`susumobile4`.`AccountNum`
`susumobile4`.`shortnum`
`susumobile4`.`Accono1`
`susumobile4`.`Accoun2`
`susumobile4`.`Accoun3`
`susumobile4`.`Branchname`
`susutransaction`.*
`susutransaction`.`Sust_id`
`susutransaction`.`Cusno`
`susutransaction`.`Accno`
`susutransaction`.`Accname`
`susutransaction`.`Transdate`
`susutransaction`.`TransDateTime`
`susutransaction`.`CreatedAt`
`susutransaction`.`Description`
`susutransaction`.`CreditAmount`
`susutransaction`.`Transid`
`susutransaction`.`AgentName`
`susutransaction`.`AgentLat`
`susutransaction`.`AgentLong`
`susutransaction`.`AgentLocation`
`susutransaction`.`GPSAccuracy`
`susutransaction`.`AccountNumber`
`susutransaction`.`TellerName`
`susutransaction`.`TellerCashAcc`
`susutransaction`.`BankBranch`
`susutransaction`.`ContactNo`
`susutransaction`.`AgentContactno`
`susutransaction`.`AgentSignOnName`
`susutransaction`.`AgentID`
`susutransaction`.`GenderStatus`
`susutransaction`.`VerifyBy`
`susutransaction`.`VerifyBy2`
`susutransaction`.`tabidno`
`susutransaction`.`AccType`
`susutransaction`.`TransactionType`
`susutransaction`.`TransactionCurrency`
`treasury_logs`.*
`treasury_logs`.`id`
`treasury_logs`.`group_id`
`treasury_logs`.`type`
`treasury_logs`.`amount`
`treasury_logs`.`previous_balance`
`treasury_logs`.`new_balance`
`treasury_logs`.`member_id`
`treasury_logs`.`description`
`treasury_logs`.`receipt_no`
`treasury_logs`.`created_by`
`treasury_logs`.`created_at`
`usertable`.*
`usertable`.`userid`
`usertable`.`username`
`usertable`.`Password`
`usertable`.`AccountNum`
`usertable`.`contactnumber`
`usertable`.`BankBranch`
`usertable`.`AccountType`
`usertable`.`SignOnName`
`usertable`.`fullname`
`usertable`.`StatusType`
`usertable`.`Designation`
`usertable`.`Designation2`
`usertable`.`UserBranch`
`usertable`.`Fname`
`usertable`.`Mname`
`usertable`.`Lname`
`usertable`.`DefaultPassword`
`usertable`.`FullNamek`
`usertable`.`Tdate`
`usertable`.`LogInStatus`
`usertable`.`Messalert1`
`usertable`.`CashAccount`
`usertable1`.*
`usertable1`.`mic_id`
`usertable1`.`accno`
`usertable1`.`accname`
`usertable1`.`secretPin`
`usertable1`.`pin1`
`usertable1`.`confpin1`
`usertable1`.`Bankbranch`
`usertable1`.`branch_type`
`usertable1`.`AccountType`
`usertable1`.`AccessLevel`
`usertable1`.`system_role`
`usertable1`.`SignOnNam`
`usertable1`.`Coun`
`usertable1`.`AccontNumber`
`usertable1`.`AgentContactno`
`usertable1`.`AgentID`
`usertable1`.`GenderStatus`
`usertable1`.`sectionLogIn`
`vault_audit_trail`.*
`vault_audit_trail`.`id`
`vault_audit_trail`.`audit_date`
`vault_audit_trail`.`vault_date`
`vault_audit_trail`.`branch_code`
`vault_audit_trail`.`action_type`
`vault_audit_trail`.`record_id`
`vault_audit_trail`.`teller_no`
`vault_audit_trail`.`amount`
`vault_audit_trail`.`old_status`
`vault_audit_trail`.`new_status`
`vault_audit_trail`.`performed_by`
`vault_audit_trail`.`role_performed`
`vault_audit_trail`.`ip_address`
`vault_audit_trail`.`details`
`vault_movement`.*
`vault_movement`.`id`
`vault_movement`.`vault_date`
`vault_movement`.`branch_code`
`vault_movement`.`movement_type`
`vault_movement`.`teller_no`
`vault_movement`.`teller_name`
`vault_movement`.`denom_200`
`vault_movement`.`denom_100`
`vault_movement`.`denom_50`
`vault_movement`.`denom_20`
`vault_movement`.`denom_10`
`vault_movement`.`denom_5`
`vault_movement`.`denom_2`
`vault_movement`.`denom_1`
`vault_movement`.`denom_c200`
`vault_movement`.`denom_c100`
`vault_movement`.`denom_c050`
`vault_movement`.`denom_c020`
`vault_movement`.`denom_c010`
`vault_movement`.`total_pieces`
`vault_movement`.`total_amount`
`vault_movement`.`remarks`
`vault_movement`.`status`
`vault_movement`.`approved_by`
`vault_movement`.`approved_at`
`vault_movement`.`created_by`
`vault_movement`.`created_at`
`vault_movement`.`denom_c005`
`vault_movement`.`notes_amount`
`vault_movement`.`coins_amount`
`vault_movement`.`denom_c001`
`vault_movement`.`denom_2_note`
`vault_movement`.`denom_1_note`
`vault_reserve`.*
`vault_reserve`.`id`
`vault_reserve`.`vault_date`
`vault_reserve`.`branch_code`
`vault_reserve`.`opening_balance`
`vault_reserve`.`closing_balance`
`vault_reserve`.`created_by`
`vault_reserve`.`created_at`
`vault_reserve`.`denom_200`
`vault_reserve`.`denom_100`
`vault_reserve`.`denom_50`
`vault_reserve`.`denom_20`
`vault_reserve`.`denom_10`
`vault_reserve`.`denom_5`
`vault_reserve`.`denom_2`
`vault_reserve`.`denom_1`
`vault_reserve`.`denom_c050`
`vault_reserve`.`denom_c020`
`vault_reserve`.`denom_c010`
`vault_reserve`.`denom_c005`
`vault_reserve`.`notes_amount`
`vault_reserve`.`coins_amount`
`vault_reserve`.`denom_c001`
`vault_reserve`.`denom_2_note`
`vault_reserve`.`denom_1_note`
`vault_tellers`.*
`vault_tellers`.`id`
`vault_tellers`.`branch_code`
`vault_tellers`.`teller_no`
`vault_tellers`.`teller_name`
`vault_tellers`.`teller_pin`
`vault_tellers`.`role`
`vault_tellers`.`password`
`vault_tellers`.`pin`
`vault_tellers`.`pin_hash`
`vault_tellers`.`status`
`vault_tellers`.`created_at`
`whatsapp_logs`.*
`whatsapp_logs`.`id`
`whatsapp_logs`.`acc`
`whatsapp_logs`.`phone`
`whatsapp_logs`.`message`
`whatsapp_logs`.`status`
`whatsapp_logs`.`created_at`
`bank`.*
`bank`.`1`
`bank`.`bankname`
`bankbranch`.*
`bankbranch`.`bb_id`
`bankbranch`.`BankName`
`bankbranch`.`BranchName`
`bankbranch`.`Quantity`
`bankbranch`.`QtyDisposal`
`bankbranch`.`QtyAuction`
`bankbranch`.`QtyTransferFrom`
`bankbranch`.`QtyTransferTo`
`bankbranch`.`Bcode`
`bankbranch`.`Branch`
`branchcode`.*
`branchcode`.`branchid`
`branchcode`.`branchcode`
`branchcode`.`branchname`
`branchcode`.`AccountType`
`branchlocation`.*
`branchlocation`.`Bra_id`
`branchlocation`.`BranchName`
`branchlocation`.`Location`
`branchlocation`.`NewLocation`
`cashdenomination`.*
`cashdenomination`.`id`
`cashdenomination`.`Denomination`
`cashdenomination`.`DenomType`
`ccb_announcements`.*
`ccb_announcements`.`id`
`ccb_announcements`.`title`
`ccb_announcements`.`category`
`ccb_announcements`.`content`
`ccb_announcements`.`staff_name`
`ccb_announcements`.`department`
`ccb_announcements`.`effective_date`
`ccb_announcements`.`image`
`ccb_announcements`.`priority`
`ccb_announcements`.`status`
`ccb_announcements`.`created_by`
`ccb_announcements`.`created_at`
`ccb_leave_allocation`.*
`ccb_leave_allocation`.`id`
`ccb_leave_allocation`.`staff_id`
`ccb_leave_allocation`.`staff_name`
`ccb_leave_allocation`.`department`
`ccb_leave_allocation`.`position`
`ccb_leave_allocation`.`year`
`ccb_leave_allocation`.`annual_days`
`ccb_leave_allocation`.`casual_days`
`ccb_leave_allocation`.`sick_days`
`ccb_leave_allocation`.`maternity_days`
`ccb_leave_allocation`.`compassionate_days`
`ccb_leave_allocation`.`study_days`
`ccb_leave_allocation`.`annual_used`
`ccb_leave_allocation`.`casual_used`
`ccb_leave_allocation`.`sick_used`
`ccb_leave_allocation`.`annual_balance`
`ccb_leave_allocation`.`status`
`ccb_leave_allocation`.`allocated_by`
`ccb_leave_allocation`.`created_at`
`ccb_leave_requests`.*
`ccb_leave_requests`.`id`
`ccb_leave_requests`.`staff_name`
`ccb_leave_requests`.`staff_id`
`ccb_leave_requests`.`department`
`ccb_leave_requests`.`branch_type`
`ccb_leave_requests`.`is_dept_head`
`ccb_leave_requests`.`position`
`ccb_leave_requests`.`leave_type`
`ccb_leave_requests`.`from_date`
`ccb_leave_requests`.`to_date`
`ccb_leave_requests`.`days`
`ccb_leave_requests`.`resumption_date`
`ccb_leave_requests`.`reason`
`ccb_leave_requests`.`contact_phone`
`ccb_leave_requests`.`email`
`ccb_leave_requests`.`handing_over_to`
`ccb_leave_requests`.`status`
`ccb_leave_requests`.`current_stage`
`ccb_leave_requests`.`approved_by`
`ccb_leave_requests`.`approved_date`
`ccb_leave_requests`.`hr_forwarded`
`ccb_leave_requests`.`created_at`
`ccb_leave_workflow`.*
`ccb_leave_workflow`.`id`
`ccb_leave_workflow`.`leave_id`
`ccb_leave_workflow`.`step_order`
`ccb_leave_workflow`.`role_name`
`ccb_leave_workflow`.`approver_name`
`ccb_leave_workflow`.`approver_id`
`ccb_leave_workflow`.`status`
`ccb_leave_workflow`.`action_date`
`ccb_leave_workflow`.`remarks`
`ccb_leave_workflow`.`created_at`
`chartable`.*
`chartable`.`id`
`chartable`.`name`
`companydetails`.*
`companydetails`.`id`
`companydetails`.`BOXNO`
`companydetails`.`HEADOFFICE`
`companydetails`.`EMAIL`
`companydetails`.`WEBSITE`
`companydetails`.`bankname`
`customer_detals`.*
`customer_detals`.`C_Details_id`
`customer_detals`.`Customer_Name`
`customer_detals`.`AccountNumber`
`customer_detals`.`Email_Address`
`customer_detals`.`ContactNo`
`customer_detals`.`Date_Created`
`customer_detals`.`AgentName`
`customer_detals`.`AccountNumberG`
`customer_detals`.`BankBranch`
`customer_detals`.`AgentContactno`
`customer_detals`.`AgentSignOnName`
`customer_detals`.`AgentID`
`customer_detals`.`GenderStatus`
`customer_detals`.`Accoun2`
`customer_detals`.`Branchname`
`customer_detals`.`Accountno`
`customer_detals`.`PassportPhoto`
`customer_detals`.`SignaturePhoto`
`customer_detals`.`PhotoPath`
`customer_detals`.`SigPath`
`customer_detals`.`GhanaCard`
`customer_detals`.`GhanaCardFront`
`customer_detals`.`GhanaCardBack`
`customer_detals`.`GhanaCardDOB`
`customer_detals`.`GhanaCardVerified`
`dailydeposit`.*
`dailydeposit`.`DailyD_id`
`dailydeposit`.`DepositDate`
`dailydeposit`.`AgentAccNo`
`dailydeposit`.`AgentName`
`dailydeposit`.`TotalCustomers1`
`dailydeposit`.`DepositAmt`
`dailydeposit`.`BankBranch`
`dailydeposit`.`AgentName2`
`dr_backup_transactions`.*
`dr_backup_transactions`.`id`
`dr_backup_transactions`.`BankBranch`
`dr_backup_transactions`.`Accno`
`dr_backup_transactions`.`CreditAmount`
`dr_backup_transactions`.`Transid`
`dr_backup_transactions`.`full_json`
`dr_backup_transactions`.`created_at`
`fd_products`.*
`fd_products`.`id`
`fd_products`.`product_code`
`fd_products`.`product_name`
`fd_products`.`interest_rate`
`fd_products`.`duration_months`
`fd_products`.`status`
`fixed_deposit`.*
`fixed_deposit`.`id`
`fixed_deposit`.`branch`
`fixed_deposit`.`applicant_name`
`fixed_deposit`.`dob`
`fixed_deposit`.`accno`
`fixed_deposit`.`id_type`
`fixed_deposit`.`id_number`
`fixed_deposit`.`tel`
`fixed_deposit`.`scheme`
`fixed_deposit`.`rollover`
`fixed_deposit`.`rollover_type`
`fixed_deposit`.`period`
`fixed_deposit`.`value_date`
`fixed_deposit`.`maturity_date`
`fixed_deposit`.`amount`
`fixed_deposit`.`amount_words`
`fixed_deposit`.`agent`
`fixed_deposit`.`created_at`
`ghana_card_verification`.*
`ghana_card_verification`.`id`
`ghana_card_verification`.`acc`
`ghana_card_verification`.`ghana_card`
`ghana_card_verification`.`dob`
`ghana_card_verification`.`front_path`
`ghana_card_verification`.`back_path`
`ghana_card_verification`.`verified_by`
`ghana_card_verification`.`verified_at`
`ghana_card_verification`.`match_score`
`ghana_cards`.*
`ghana_cards`.`id`
`ghana_cards`.`member_id`
`ghana_cards`.`card_number`
`ghana_cards`.`full_name`
`ghana_cards`.`dob`
`ghana_cards`.`gender`
`ghana_cards`.`address`
`ghana_cards`.`front_photo`
`ghana_cards`.`back_photo`
`ghana_cards`.`verified`
`ghana_cards`.`created_at`
`group_attendance`.*
`group_attendance`.`id`
`group_attendance`.`group_id`
`group_attendance`.`meeting_id`
`group_attendance`.`member_id`
`group_attendance`.`is_present`
`group_attendance`.`remarks`
`group_attendance`.`created_at`
`group_meetings`.*
`group_meetings`.`id`
`group_meetings`.`group_id`
`group_meetings`.`meeting_date`
`group_meetings`.`meeting_time`
`group_meetings`.`location`
`group_meetings`.`gps`
`group_meetings`.`attendance_total`
`group_meetings`.`attendance_present`
`group_meetings`.`notes`
`group_meetings`.`photo`
`group_meetings`.`created_by`
`group_meetings`.`created_at`
`group_members`.*
`group_members`.`id`
`group_members`.`group_id`
`group_members`.`full_name`
`group_members`.`phone`
`group_members`.`account_no`
`group_members`.`role`
`group_members`.`gender`
`group_members`.`dob`
`group_members`.`residential_address`
`group_members`.`gps_address`
`group_members`.`id_type`
`group_members`.`id_number`
`group_members`.`occupation`
`group_members`.`kin_name`
`group_members`.`kin_phone`
`group_members`.`photo`
`group_members`.`signature`
`group_members`.`is_present`
`group_members`.`created_at`
`group_treasury`.*
`group_treasury`.`id`
`group_treasury`.`group_id`
`group_treasury`.`member_id`
`group_treasury`.`type`
`group_treasury`.`amount`
`group_treasury`.`balance_after`
`group_treasury`.`description`
`group_treasury`.`receipt_no`
`group_treasury`.`created_at`
`iptabl22n`.*
`iptabl22n`.`ipd_id`
`iptabl22n`.`name`
`iptabl22n`.`amt`
`iptabl22n`.`norow`
`iptabl22n`.`agentNo`
`iptabl22n`.`Transno`
`iptabl22n`.`InputterName`
`iptabl22n`.`Transdate`
`iptabl22n`.`TotalAmt`
`iptabl22n`.`Agentid`
`iptabl22n`.`AgentNum`
`iptabl22n`.`Agentgender`
`loan_products`.*
`loan_products`.`id`
`loan_products`.`product_code`
`loan_products`.`product_name`
`loan_products`.`interest_rate`
`loan_products`.`status`
`loan_repayments`.*
`loan_repayments`.`id`
`loan_repayments`.`loan_id`
`loan_repayments`.`group_id`
`loan_repayments`.`member_id`
`loan_repayments`.`amount`
`loan_repayments`.`payment_date`
`loan_repayments`.`method`
`loan_repayments`.`receipt_no`
`loan_repayments`.`created_at`
`loans`.*
`loans`.`id`
`loans`.`group_id`
`loans`.`member_id`
`loans`.`amount`
`loans`.`interest_rate`
`loans`.`interest_amount`
`loans`.`total_payable`
`loans`.`amount_paid`
`loans`.`balance`
`loans`.`purpose`
`loans`.`repayment_period`
`loans`.`due_date`
`loans`.`status`
`loans`.`disbursed_date`
`loans`.`created_at`
`mailset2`.*
`mailset2`.`id`
`mailset2`.`Bankname`
`mailset2`.`Name`
`mailset2`.`Emadd`
`mailset2`.`empass`
`mailset2`.`Hostname`
`mailset2`.`portnumber`
`mailset2`.`securetype`
`mailset2`.`status`
`mailset2`.`Messsage`
`mailset2`.`Subject`
`mailset2`.`message2`
`mailset2`.`message3`
`mailset2`.`AboutPass1`
`mailset2`.`AboutPass2`
`mailset2`.`AboutPass3`
`mailset2`.`AboutPass4`
`micro_groups`.*
`micro_groups`.`id`
`micro_groups`.`group_code`
`micro_groups`.`group_name`
`micro_groups`.`branch_id`
`micro_groups`.`meeting_days`
`micro_groups`.`meeting_time`
`micro_groups`.`meeting_location`
`micro_groups`.`location_gps`
`micro_groups`.`contact_address`
`micro_groups`.`treasury_amount`
`micro_groups`.`group_leader_name`
`micro_groups`.`group_leader_phone`
`micro_groups`.`group_leader_photo`
`micro_groups`.`group_leader_signature`
`micro_groups`.`chairman_name`
`micro_groups`.`chairman_signature`
`micro_groups`.`secretary_name`
`micro_groups`.`secretary_signature`
`micro_groups`.`treasurer_name`
`micro_groups`.`treasurer_signature`
`micro_groups`.`organizer_name`
`micro_groups`.`organizer_signature`
`micro_groups`.`group_photo`
`micro_groups`.`total_members`
`micro_groups`.`status`
`micro_groups`.`created_at`
`micro_groups`.`updated_at`
`passhistory`.*
`passhistory`.`pa_id`
`passhistory`.`SignOnName`
`passhistory`.`Fullname`
`passhistory`.`DateTime`
`passhistory`.`Comment`
`salary_advance`.*
`salary_advance`.`id`
`salary_advance`.`accno`
`salary_advance`.`customer_name`
`salary_advance`.`address`
`salary_advance`.`tel`
`salary_advance`.`occupation`
`salary_advance`.`monthly_salary`
`salary_advance`.`current_loan`
`salary_advance`.`monthly_ded`
`salary_advance`.`expiry`
`salary_advance`.`amount_requested`
`salary_advance`.`purpose`
`salary_advance`.`app_date`
`salary_advance`.`signature_path`
`salary_advance`.`off_balance`
`salary_advance`.`rec_amount`
`salary_advance`.`app_amount`
`salary_advance`.`agent`
`salary_advance`.`created_at`
`savings`.*
`savings`.`id`
`savings`.`group_id`
`savings`.`member_id`
`savings`.`amount`
`savings`.`date`
`savings`.`note`
`savings`.`created_at`
`settings`.*
`settings`.`key`
`settings`.`value`
`settings2`.*
`settings2`.`key`
`settings2`.`value`
`sms_log`.*
`sms_log`.`id`
`sms_log`.`acc`
`sms_log`.`channel`
`sms_log`.`sent_to`
`sms_log`.`total`
`sms_log`.`count_txn`
`sms_log`.`message`
`sms_log`.`sent_by`
`sms_log`.`sent_at`
`sms_settings`.*
`sms_settings`.`id`
`sms_settings`.`api_key`
`sms_settings`.`sender_id`
`sms_settings`.`cost`
`sms_settings`.`status`
`sms_settings`.`cost_per_sms`
`sms_settings`.`api_status`
`specailchar`.*
`specailchar`.`id`
`specailchar`.`specsd`
`specialchar`.*
`specialchar`.`id`
`specialchar`.`specsd`
`susumobile`.*
`susumobile`.`Sus_id`
`susumobile`.`Accountno`
`susumobile`.`Accountname`
`susumobile`.`AccountNum`
`susumobile`.`shortnum`
`susumobile`.`Accono1`
`susumobile`.`Accoun2`
`susumobile`.`Accoun3`
`susumobile`.`Branchname`
`susumobile2`.*
`susumobile2`.`Sus_id`
`susumobile2`.`Accountno`
`susumobile2`.`Accountname`
`susumobile2`.`AccountNum`
`susumobile2`.`shortnum`
`susumobile4`.*
`susumobile4`.`Sus_id`
`susumobile4`.`Accountno`
`susumobile4`.`Accountname`
`susumobile4`.`AccountNum`
`susumobile4`.`shortnum`
`susumobile4`.`Accono1`
`susumobile4`.`Accoun2`
`susumobile4`.`Accoun3`
`susumobile4`.`Branchname`
`susutransaction`.*
`susutransaction`.`Sust_id`
`susutransaction`.`Cusno`
`susutransaction`.`Accno`
`susutransaction`.`Accname`
`susutransaction`.`Transdate`
`susutransaction`.`TransDateTime`
`susutransaction`.`CreatedAt`
`susutransaction`.`Description`
`susutransaction`.`CreditAmount`
`susutransaction`.`Transid`
`susutransaction`.`AgentName`
`susutransaction`.`AgentLat`
`susutransaction`.`AgentLong`
`susutransaction`.`AgentLocation`
`susutransaction`.`GPSAccuracy`
`susutransaction`.`AccountNumber`
`susutransaction`.`TellerName`
`susutransaction`.`TellerCashAcc`
`susutransaction`.`BankBranch`
`susutransaction`.`ContactNo`
`susutransaction`.`AgentContactno`
`susutransaction`.`AgentSignOnName`
`susutransaction`.`AgentID`
`susutransaction`.`GenderStatus`
`susutransaction`.`VerifyBy`
`susutransaction`.`VerifyBy2`
`susutransaction`.`tabidno`
`susutransaction`.`AccType`
`susutransaction`.`TransactionType`
`susutransaction`.`TransactionCurrency`
`treasury_logs`.*
`treasury_logs`.`id`
`treasury_logs`.`group_id`
`treasury_logs`.`type`
`treasury_logs`.`amount`
`treasury_logs`.`previous_balance`
`treasury_logs`.`new_balance`
`treasury_logs`.`member_id`
`treasury_logs`.`description`
`treasury_logs`.`receipt_no`
`treasury_logs`.`created_by`
`treasury_logs`.`created_at`
`usertable`.*
`usertable`.`userid`
`usertable`.`username`
`usertable`.`Password`
`usertable`.`AccountNum`
`usertable`.`contactnumber`
`usertable`.`BankBranch`
`usertable`.`AccountType`
`usertable`.`SignOnName`
`usertable`.`fullname`
`usertable`.`StatusType`
`usertable`.`Designation`
`usertable`.`Designation2`
`usertable`.`UserBranch`
`usertable`.`Fname`
`usertable`.`Mname`
`usertable`.`Lname`
`usertable`.`DefaultPassword`
`usertable`.`FullNamek`
`usertable`.`Tdate`
`usertable`.`LogInStatus`
`usertable`.`Messalert1`
`usertable`.`CashAccount`
`usertable1`.*
`usertable1`.`mic_id`
`usertable1`.`accno`
`usertable1`.`accname`
`usertable1`.`secretPin`
`usertable1`.`pin1`
`usertable1`.`confpin1`
`usertable1`.`Bankbranch`
`usertable1`.`branch_type`
`usertable1`.`AccountType`
`usertable1`.`AccessLevel`
`usertable1`.`system_role`
`usertable1`.`SignOnNam`
`usertable1`.`Coun`
`usertable1`.`AccontNumber`
`usertable1`.`AgentContactno`
`usertable1`.`AgentID`
`usertable1`.`GenderStatus`
`usertable1`.`sectionLogIn`
`vault_audit_trail`.*
`vault_audit_trail`.`id`
`vault_audit_trail`.`audit_date`
`vault_audit_trail`.`vault_date`
`vault_audit_trail`.`branch_code`
`vault_audit_trail`.`action_type`
`vault_audit_trail`.`record_id`
`vault_audit_trail`.`teller_no`
`vault_audit_trail`.`amount`
`vault_audit_trail`.`old_status`
`vault_audit_trail`.`new_status`
`vault_audit_trail`.`performed_by`
`vault_audit_trail`.`role_performed`
`vault_audit_trail`.`ip_address`
`vault_audit_trail`.`details`
`vault_movement`.*
`vault_movement`.`id`
`vault_movement`.`vault_date`
`vault_movement`.`branch_code`
`vault_movement`.`movement_type`
`vault_movement`.`teller_no`
`vault_movement`.`teller_name`
`vault_movement`.`denom_200`
`vault_movement`.`denom_100`
`vault_movement`.`denom_50`
`vault_movement`.`denom_20`
`vault_movement`.`denom_10`
`vault_movement`.`denom_5`
`vault_movement`.`denom_2`
`vault_movement`.`denom_1`
`vault_movement`.`denom_c200`
`vault_movement`.`denom_c100`
`vault_movement`.`denom_c050`
`vault_movement`.`denom_c020`
`vault_movement`.`denom_c010`
`vault_movement`.`total_pieces`
`vault_movement`.`total_amount`
`vault_movement`.`remarks`
`vault_movement`.`status`
`vault_movement`.`approved_by`
`vault_movement`.`approved_at`
`vault_movement`.`created_by`
`vault_movement`.`created_at`
`vault_movement`.`denom_c005`
`vault_movement`.`notes_amount`
`vault_movement`.`coins_amount`
`vault_movement`.`denom_c001`
`vault_movement`.`denom_2_note`
`vault_movement`.`denom_1_note`
`vault_reserve`.*
`vault_reserve`.`id`
`vault_reserve`.`vault_date`
`vault_reserve`.`branch_code`
`vault_reserve`.`opening_balance`
`vault_reserve`.`closing_balance`
`vault_reserve`.`created_by`
`vault_reserve`.`created_at`
`vault_reserve`.`denom_200`
`vault_reserve`.`denom_100`
`vault_reserve`.`denom_50`
`vault_reserve`.`denom_20`
`vault_reserve`.`denom_10`
`vault_reserve`.`denom_5`
`vault_reserve`.`denom_2`
`vault_reserve`.`denom_1`
`vault_reserve`.`denom_c050`
`vault_reserve`.`denom_c020`
`vault_reserve`.`denom_c010`
`vault_reserve`.`denom_c005`
`vault_reserve`.`notes_amount`
`vault_reserve`.`coins_amount`
`vault_reserve`.`denom_c001`
`vault_reserve`.`denom_2_note`
`vault_reserve`.`denom_1_note`
`vault_tellers`.*
`vault_tellers`.`id`
`vault_tellers`.`branch_code`
`vault_tellers`.`teller_no`
`vault_tellers`.`teller_name`
`vault_tellers`.`teller_pin`
`vault_tellers`.`role`
`vault_tellers`.`password`
`vault_tellers`.`pin`
`vault_tellers`.`pin_hash`
`vault_tellers`.`status`
`vault_tellers`.`created_at`
`whatsapp_logs`.*
`whatsapp_logs`.`id`
`whatsapp_logs`.`acc`
`whatsapp_logs`.`phone`
`whatsapp_logs`.`message`
`whatsapp_logs`.`status`
`whatsapp_logs`.`created_at`
`bank`.*
`bank`.`1`
`bank`.`bankname`
`bankbranch`.*
`bankbranch`.`bb_id`
`bankbranch`.`BankName`
`bankbranch`.`BranchName`
`bankbranch`.`Quantity`
`bankbranch`.`QtyDisposal`
`bankbranch`.`QtyAuction`
`bankbranch`.`QtyTransferFrom`
`bankbranch`.`QtyTransferTo`
`bankbranch`.`Bcode`
`bankbranch`.`Branch`
`branchcode`.*
`branchcode`.`branchid`
`branchcode`.`branchcode`
`branchcode`.`branchname`
`branchcode`.`AccountType`
`branchlocation`.*
`branchlocation`.`Bra_id`
`branchlocation`.`BranchName`
`branchlocation`.`Location`
`branchlocation`.`NewLocation`
`cashdenomination`.*
`cashdenomination`.`id`
`cashdenomination`.`Denomination`
`cashdenomination`.`DenomType`
`ccb_announcements`.*
`ccb_announcements`.`id`
`ccb_announcements`.`title`
`ccb_announcements`.`category`
`ccb_announcements`.`content`
`ccb_announcements`.`staff_name`
`ccb_announcements`.`department`
`ccb_announcements`.`effective_date`
`ccb_announcements`.`image`
`ccb_announcements`.`priority`
`ccb_announcements`.`status`
`ccb_announcements`.`created_by`
`ccb_announcements`.`created_at`
`ccb_leave_allocation`.*
`ccb_leave_allocation`.`id`
`ccb_leave_allocation`.`staff_id`
`ccb_leave_allocation`.`staff_name`
`ccb_leave_allocation`.`department`
`ccb_leave_allocation`.`position`
`ccb_leave_allocation`.`year`
`ccb_leave_allocation`.`annual_days`
`ccb_leave_allocation`.`casual_days`
`ccb_leave_allocation`.`sick_days`
`ccb_leave_allocation`.`maternity_days`
`ccb_leave_allocation`.`compassionate_days`
`ccb_leave_allocation`.`study_days`
`ccb_leave_allocation`.`annual_used`
`ccb_leave_allocation`.`casual_used`
`ccb_leave_allocation`.`sick_used`
`ccb_leave_allocation`.`annual_balance`
`ccb_leave_allocation`.`status`
`ccb_leave_allocation`.`allocated_by`
`ccb_leave_allocation`.`created_at`
`ccb_leave_requests`.*
`ccb_leave_requests`.`id`
`ccb_leave_requests`.`staff_name`
`ccb_leave_requests`.`staff_id`
`ccb_leave_requests`.`department`
`ccb_leave_requests`.`branch_type`
`ccb_leave_requests`.`is_dept_head`
`ccb_leave_requests`.`position`
`ccb_leave_requests`.`leave_type`
`ccb_leave_requests`.`from_date`
`ccb_leave_requests`.`to_date`
`ccb_leave_requests`.`days`
`ccb_leave_requests`.`resumption_date`
`ccb_leave_requests`.`reason`
`ccb_leave_requests`.`contact_phone`
`ccb_leave_requests`.`email`
`ccb_leave_requests`.`handing_over_to`
`ccb_leave_requests`.`status`
`ccb_leave_requests`.`current_stage`
`ccb_leave_requests`.`approved_by`
`ccb_leave_requests`.`approved_date`
`ccb_leave_requests`.`hr_forwarded`
`ccb_leave_requests`.`created_at`
`ccb_leave_workflow`.*
`ccb_leave_workflow`.`id`
`ccb_leave_workflow`.`leave_id`
`ccb_leave_workflow`.`step_order`
`ccb_leave_workflow`.`role_name`
`ccb_leave_workflow`.`approver_name`
`ccb_leave_workflow`.`approver_id`
`ccb_leave_workflow`.`status`
`ccb_leave_workflow`.`action_date`
`ccb_leave_workflow`.`remarks`
`ccb_leave_workflow`.`created_at`
`chartable`.*
`chartable`.`id`
`chartable`.`name`
`companydetails`.*
`companydetails`.`id`
`companydetails`.`BOXNO`
`companydetails`.`HEADOFFICE`
`companydetails`.`EMAIL`
`companydetails`.`WEBSITE`
`companydetails`.`bankname`
`customer_detals`.*
`customer_detals`.`C_Details_id`
`customer_detals`.`Customer_Name`
`customer_detals`.`AccountNumber`
`customer_detals`.`Email_Address`
`customer_detals`.`ContactNo`
`customer_detals`.`Date_Created`
`customer_detals`.`AgentName`
`customer_detals`.`AccountNumberG`
`customer_detals`.`BankBranch`
`customer_detals`.`AgentContactno`
`customer_detals`.`AgentSignOnName`
`customer_detals`.`AgentID`
`customer_detals`.`GenderStatus`
`customer_detals`.`Accoun2`
`customer_detals`.`Branchname`
`customer_detals`.`Accountno`
`customer_detals`.`PassportPhoto`
`customer_detals`.`SignaturePhoto`
`customer_detals`.`PhotoPath`
`customer_detals`.`SigPath`
`customer_detals`.`GhanaCard`
`customer_detals`.`GhanaCardFront`
`customer_detals`.`GhanaCardBack`
`customer_detals`.`GhanaCardDOB`
`customer_detals`.`GhanaCardVerified`
`dailydeposit`.*
`dailydeposit`.`DailyD_id`
`dailydeposit`.`DepositDate`
`dailydeposit`.`AgentAccNo`
`dailydeposit`.`AgentName`
`dailydeposit`.`TotalCustomers1`
`dailydeposit`.`DepositAmt`
`dailydeposit`.`BankBranch`
`dailydeposit`.`AgentName2`
`dr_backup_transactions`.*
`dr_backup_transactions`.`id`
`dr_backup_transactions`.`BankBranch`
`dr_backup_transactions`.`Accno`
`dr_backup_transactions`.`CreditAmount`
`dr_backup_transactions`.`Transid`
`dr_backup_transactions`.`full_json`
`dr_backup_transactions`.`created_at`
`fd_products`.*
`fd_products`.`id`
`fd_products`.`product_code`
`fd_products`.`product_name`
`fd_products`.`interest_rate`
`fd_products`.`duration_months`
`fd_products`.`status`
`fixed_deposit`.*
`fixed_deposit`.`id`
`fixed_deposit`.`branch`
`fixed_deposit`.`applicant_name`
`fixed_deposit`.`dob`
`fixed_deposit`.`accno`
`fixed_deposit`.`id_type`
`fixed_deposit`.`id_number`
`fixed_deposit`.`tel`
`fixed_deposit`.`scheme`
`fixed_deposit`.`rollover`
`fixed_deposit`.`rollover_type`
`fixed_deposit`.`period`
`fixed_deposit`.`value_date`
`fixed_deposit`.`maturity_date`
`fixed_deposit`.`amount`
`fixed_deposit`.`amount_words`
`fixed_deposit`.`agent`
`fixed_deposit`.`created_at`
`ghana_card_verification`.*
`ghana_card_verification`.`id`
`ghana_card_verification`.`acc`
`ghana_card_verification`.`ghana_card`
`ghana_card_verification`.`dob`
`ghana_card_verification`.`front_path`
`ghana_card_verification`.`back_path`
`ghana_card_verification`.`verified_by`
`ghana_card_verification`.`verified_at`
`ghana_card_verification`.`match_score`
`ghana_cards`.*
`ghana_cards`.`id`
`ghana_cards`.`member_id`
`ghana_cards`.`card_number`
`ghana_cards`.`full_name`
`ghana_cards`.`dob`
`ghana_cards`.`gender`
`ghana_cards`.`address`
`ghana_cards`.`front_photo`
`ghana_cards`.`back_photo`
`ghana_cards`.`verified`
`ghana_cards`.`created_at`
`group_attendance`.*
`group_attendance`.`id`
`group_attendance`.`group_id`
`group_attendance`.`meeting_id`
`group_attendance`.`member_id`
`group_attendance`.`is_present`
`group_attendance`.`remarks`
`group_attendance`.`created_at`
`group_meetings`.*
`group_meetings`.`id`
`group_meetings`.`group_id`
`group_meetings`.`meeting_date`
`group_meetings`.`meeting_time`
`group_meetings`.`location`
`group_meetings`.`gps`
`group_meetings`.`attendance_total`
`group_meetings`.`attendance_present`
`group_meetings`.`notes`
`group_meetings`.`photo`
`group_meetings`.`created_by`
`group_meetings`.`created_at`
`group_members`.*
`group_members`.`id`
`group_members`.`group_id`
`group_members`.`full_name`
`group_members`.`phone`
`group_members`.`account_no`
`group_members`.`role`
`group_members`.`gender`
`group_members`.`dob`
`group_members`.`residential_address`
`group_members`.`gps_address`
`group_members`.`id_type`
`group_members`.`id_number`
`group_members`.`occupation`
`group_members`.`kin_name`
`group_members`.`kin_phone`
`group_members`.`photo`
`group_members`.`signature`
`group_members`.`is_present`
`group_members`.`created_at`
`group_treasury`.*
`group_treasury`.`id`
`group_treasury`.`group_id`
`group_treasury`.`member_id`
`group_treasury`.`type`
`group_treasury`.`amount`
`group_treasury`.`balance_after`
`group_treasury`.`description`
`group_treasury`.`receipt_no`
`group_treasury`.`created_at`
`iptabl22n`.*
`iptabl22n`.`ipd_id`
`iptabl22n`.`name`
`iptabl22n`.`amt`
`iptabl22n`.`norow`
`iptabl22n`.`agentNo`
`iptabl22n`.`Transno`
`iptabl22n`.`InputterName`
`iptabl22n`.`Transdate`
`iptabl22n`.`TotalAmt`
`iptabl22n`.`Agentid`
`iptabl22n`.`AgentNum`
`iptabl22n`.`Agentgender`
`loan_products`.*
`loan_products`.`id`
`loan_products`.`product_code`
`loan_products`.`product_name`
`loan_products`.`interest_rate`
`loan_products`.`status`
`loan_repayments`.*
`loan_repayments`.`id`
`loan_repayments`.`loan_id`
`loan_repayments`.`group_id`
`loan_repayments`.`member_id`
`loan_repayments`.`amount`
`loan_repayments`.`payment_date`
`loan_repayments`.`method`
`loan_repayments`.`receipt_no`
`loan_repayments`.`created_at`
`loans`.*
`loans`.`id`
`loans`.`group_id`
`loans`.`member_id`
`loans`.`amount`
`loans`.`interest_rate`
`loans`.`interest_amount`
`loans`.`total_payable`
`loans`.`amount_paid`
`loans`.`balance`
`loans`.`purpose`
`loans`.`repayment_period`
`loans`.`due_date`
`loans`.`status`
`loans`.`disbursed_date`
`loans`.`created_at`
`mailset2`.*
`mailset2`.`id`
`mailset2`.`Bankname`
`mailset2`.`Name`
`mailset2`.`Emadd`
`mailset2`.`empass`
`mailset2`.`Hostname`
`mailset2`.`portnumber`
`mailset2`.`securetype`
`mailset2`.`status`
`mailset2`.`Messsage`
`mailset2`.`Subject`
`mailset2`.`message2`
`mailset2`.`message3`
`mailset2`.`AboutPass1`
`mailset2`.`AboutPass2`
`mailset2`.`AboutPass3`
`mailset2`.`AboutPass4`
`micro_groups`.*
`micro_groups`.`id`
`micro_groups`.`group_code`
`micro_groups`.`group_name`
`micro_groups`.`branch_id`
`micro_groups`.`meeting_days`
`micro_groups`.`meeting_time`
`micro_groups`.`meeting_location`
`micro_groups`.`location_gps`
`micro_groups`.`contact_address`
`micro_groups`.`treasury_amount`
`micro_groups`.`group_leader_name`
`micro_groups`.`group_leader_phone`
`micro_groups`.`group_leader_photo`
`micro_groups`.`group_leader_signature`
`micro_groups`.`chairman_name`
`micro_groups`.`chairman_signature`
`micro_groups`.`secretary_name`
`micro_groups`.`secretary_signature`
`micro_groups`.`treasurer_name`
`micro_groups`.`treasurer_signature`
`micro_groups`.`organizer_name`
`micro_groups`.`organizer_signature`
`micro_groups`.`group_photo`
`micro_groups`.`total_members`
`micro_groups`.`status`
`micro_groups`.`created_at`
`micro_groups`.`updated_at`
`passhistory`.*
`passhistory`.`pa_id`
`passhistory`.`SignOnName`
`passhistory`.`Fullname`
`passhistory`.`DateTime`
`passhistory`.`Comment`
`salary_advance`.*
`salary_advance`.`id`
`salary_advance`.`accno`
`salary_advance`.`customer_name`
`salary_advance`.`address`
`salary_advance`.`tel`
`salary_advance`.`occupation`
`salary_advance`.`monthly_salary`
`salary_advance`.`current_loan`
`salary_advance`.`monthly_ded`
`salary_advance`.`expiry`
`salary_advance`.`amount_requested`
`salary_advance`.`purpose`
`salary_advance`.`app_date`
`salary_advance`.`signature_path`
`salary_advance`.`off_balance`
`salary_advance`.`rec_amount`
`salary_advance`.`app_amount`
`salary_advance`.`agent`
`salary_advance`.`created_at`
`savings`.*
`savings`.`id`
`savings`.`group_id`
`savings`.`member_id`
`savings`.`amount`
`savings`.`date`
`savings`.`note`
`savings`.`created_at`
`settings`.*
`settings`.`key`
`settings`.`value`
`settings2`.*
`settings2`.`key`
`settings2`.`value`
`sms_log`.*
`sms_log`.`id`
`sms_log`.`acc`
`sms_log`.`channel`
`sms_log`.`sent_to`
`sms_log`.`total`
`sms_log`.`count_txn`
`sms_log`.`message`
`sms_log`.`sent_by`
`sms_log`.`sent_at`
`sms_settings`.*
`sms_settings`.`id`
`sms_settings`.`api_key`
`sms_settings`.`sender_id`
`sms_settings`.`cost`
`sms_settings`.`status`
`sms_settings`.`cost_per_sms`
`sms_settings`.`api_status`
`specailchar`.*
`specailchar`.`id`
`specailchar`.`specsd`
`specialchar`.*
`specialchar`.`id`
`specialchar`.`specsd`
`susumobile`.*
`susumobile`.`Sus_id`
`susumobile`.`Accountno`
`susumobile`.`Accountname`
`susumobile`.`AccountNum`
`susumobile`.`shortnum`
`susumobile`.`Accono1`
`susumobile`.`Accoun2`
`susumobile`.`Accoun3`
`susumobile`.`Branchname`
`susumobile2`.*
`susumobile2`.`Sus_id`
`susumobile2`.`Accountno`
`susumobile2`.`Accountname`
`susumobile2`.`AccountNum`
`susumobile2`.`shortnum`
`susumobile4`.*
`susumobile4`.`Sus_id`
`susumobile4`.`Accountno`
`susumobile4`.`Accountname`
`susumobile4`.`AccountNum`
`susumobile4`.`shortnum`
`susumobile4`.`Accono1`
`susumobile4`.`Accoun2`
`susumobile4`.`Accoun3`
`susumobile4`.`Branchname`
`susutransaction`.*
`susutransaction`.`Sust_id`
`susutransaction`.`Cusno`
`susutransaction`.`Accno`
`susutransaction`.`Accname`
`susutransaction`.`Transdate`
`susutransaction`.`TransDateTime`
`susutransaction`.`CreatedAt`
`susutransaction`.`Description`
`susutransaction`.`CreditAmount`
`susutransaction`.`Transid`
`susutransaction`.`AgentName`
`susutransaction`.`AgentLat`
`susutransaction`.`AgentLong`
`susutransaction`.`AgentLocation`
`susutransaction`.`GPSAccuracy`
`susutransaction`.`AccountNumber`
`susutransaction`.`TellerName`
`susutransaction`.`TellerCashAcc`
`susutransaction`.`BankBranch`
`susutransaction`.`ContactNo`
`susutransaction`.`AgentContactno`
`susutransaction`.`AgentSignOnName`
`susutransaction`.`AgentID`
`susutransaction`.`GenderStatus`
`susutransaction`.`VerifyBy`
`susutransaction`.`VerifyBy2`
`susutransaction`.`tabidno`
`susutransaction`.`AccType`
`susutransaction`.`TransactionType`
`susutransaction`.`TransactionCurrency`
`treasury_logs`.*
`treasury_logs`.`id`
`treasury_logs`.`group_id`
`treasury_logs`.`type`
`treasury_logs`.`amount`
`treasury_logs`.`previous_balance`
`treasury_logs`.`new_balance`
`treasury_logs`.`member_id`
`treasury_logs`.`description`
`treasury_logs`.`receipt_no`
`treasury_logs`.`created_by`
`treasury_logs`.`created_at`
`usertable`.*
`usertable`.`userid`
`usertable`.`username`
`usertable`.`Password`
`usertable`.`AccountNum`
`usertable`.`contactnumber`
`usertable`.`BankBranch`
`usertable`.`AccountType`
`usertable`.`SignOnName`
`usertable`.`fullname`
`usertable`.`StatusType`
`usertable`.`Designation`
`usertable`.`Designation2`
`usertable`.`UserBranch`
`usertable`.`Fname`
`usertable`.`Mname`
`usertable`.`Lname`
`usertable`.`DefaultPassword`
`usertable`.`FullNamek`
`usertable`.`Tdate`
`usertable`.`LogInStatus`
`usertable`.`Messalert1`
`usertable`.`CashAccount`
`usertable1`.*
`usertable1`.`mic_id`
`usertable1`.`accno`
`usertable1`.`accname`
`usertable1`.`secretPin`
`usertable1`.`pin1`
`usertable1`.`confpin1`
`usertable1`.`Bankbranch`
`usertable1`.`branch_type`
`usertable1`.`AccountType`
`usertable1`.`AccessLevel`
`usertable1`.`system_role`
`usertable1`.`SignOnNam`
`usertable1`.`Coun`
`usertable1`.`AccontNumber`
`usertable1`.`AgentContactno`
`usertable1`.`AgentID`
`usertable1`.`GenderStatus`
`usertable1`.`sectionLogIn`
`vault_audit_trail`.*
`vault_audit_trail`.`id`
`vault_audit_trail`.`audit_date`
`vault_audit_trail`.`vault_date`
`vault_audit_trail`.`branch_code`
`vault_audit_trail`.`action_type`
`vault_audit_trail`.`record_id`
`vault_audit_trail`.`teller_no`
`vault_audit_trail`.`amount`
`vault_audit_trail`.`old_status`
`vault_audit_trail`.`new_status`
`vault_audit_trail`.`performed_by`
`vault_audit_trail`.`role_performed`
`vault_audit_trail`.`ip_address`
`vault_audit_trail`.`details`
`vault_movement`.*
`vault_movement`.`id`
`vault_movement`.`vault_date`
`vault_movement`.`branch_code`
`vault_movement`.`movement_type`
`vault_movement`.`teller_no`
`vault_movement`.`teller_name`
`vault_movement`.`denom_200`
`vault_movement`.`denom_100`
`vault_movement`.`denom_50`
`vault_movement`.`denom_20`
`vault_movement`.`denom_10`
`vault_movement`.`denom_5`
`vault_movement`.`denom_2`
`vault_movement`.`denom_1`
`vault_movement`.`denom_c200`
`vault_movement`.`denom_c100`
`vault_movement`.`denom_c050`
`vault_movement`.`denom_c020`
`vault_movement`.`denom_c010`
`vault_movement`.`total_pieces`
`vault_movement`.`total_amount`
`vault_movement`.`remarks`
`vault_movement`.`status`
`vault_movement`.`approved_by`
`vault_movement`.`approved_at`
`vault_movement`.`created_by`
`vault_movement`.`created_at`
`vault_movement`.`denom_c005`
`vault_movement`.`notes_amount`
`vault_movement`.`coins_amount`
`vault_movement`.`denom_c001`
`vault_movement`.`denom_2_note`
`vault_movement`.`denom_1_note`
`vault_reserve`.*
`vault_reserve`.`id`
`vault_reserve`.`vault_date`
`vault_reserve`.`branch_code`
`vault_reserve`.`opening_balance`
`vault_reserve`.`closing_balance`
`vault_reserve`.`created_by`
`vault_reserve`.`created_at`
`vault_reserve`.`denom_200`
`vault_reserve`.`denom_100`
`vault_reserve`.`denom_50`
`vault_reserve`.`denom_20`
`vault_reserve`.`denom_10`
`vault_reserve`.`denom_5`
`vault_reserve`.`denom_2`
`vault_reserve`.`denom_1`
`vault_reserve`.`denom_c050`
`vault_reserve`.`denom_c020`
`vault_reserve`.`denom_c010`
`vault_reserve`.`denom_c005`
`vault_reserve`.`notes_amount`
`vault_reserve`.`coins_amount`
`vault_reserve`.`denom_c001`
`vault_reserve`.`denom_2_note`
`vault_reserve`.`denom_1_note`
`vault_tellers`.*
`vault_tellers`.`id`
`vault_tellers`.`branch_code`
`vault_tellers`.`teller_no`
`vault_tellers`.`teller_name`
`vault_tellers`.`teller_pin`
`vault_tellers`.`role`
`vault_tellers`.`password`
`vault_tellers`.`pin`
`vault_tellers`.`pin_hash`
`vault_tellers`.`status`
`vault_tellers`.`created_at`
`whatsapp_logs`.*
`whatsapp_logs`.`id`
`whatsapp_logs`.`acc`
`whatsapp_logs`.`phone`
`whatsapp_logs`.`message`
`whatsapp_logs`.`status`
`whatsapp_logs`.`created_at`
Alias:
Show:
Sort:
Ascending
Descending
Ascending
Descending
Ascending
Descending
Sort order:
1
2
3
1
2
3
1
2
3
Criteria:
Ins:
And:
Del:
Or:
Modify:
Or:
And:
Ins
Del
Or:
And:
Ins
Del
Ins
Del
Add/Delete criteria rows:
-3
-2
-1
0
1
2
3
Add/Delete columns:
-3
-2
-1
0
1
2
3
Use tables
bank
bankbranch
branchcode
branchlocation
cashdenomination
ccb_announcements
ccb_leave_allocation
ccb_leave_requests
ccb_leave_workflow
chartable
companydetails
customer_detals
dailydeposit
dr_backup_transactions
fd_products
fixed_deposit
ghana_card_verification
ghana_cards
group_attendance
group_meetings
group_members
group_treasury
iptabl22n
loan_products
loan_repayments
loans
mailset2
micro_groups
passhistory
salary_advance
savings
settings
settings2
sms_log
sms_settings
specailchar
specialchar
susumobile
susumobile2
susumobile4
susutransaction
treasury_logs
usertable
usertable1
vault_audit_trail
vault_movement
vault_reserve
vault_tellers
whatsapp_logs
SQL query on database
esusdb22
: