* 1 bankname

* bb_id BankName BranchName Quantity QtyDisposal QtyAuction QtyTransferFrom QtyTransferTo Bcode Branch

* branchid branchcode branchname AccountType

* Bra_id BranchName Location NewLocation

* id Denomination DenomType

* id title category content staff_name department effective_date image priority status created_by created_at

* id staff_id staff_name department position year annual_days casual_days sick_days maternity_days compassionate_days study_days annual_used casual_used sick_used annual_balance status allocated_by created_at

* id staff_name staff_id department branch_type is_dept_head position leave_type from_date to_date days resumption_date reason contact_phone email handing_over_to status current_stage approved_by approved_date hr_forwarded created_at

* id leave_id step_order role_name approver_name approver_id status action_date remarks created_at

* id name

* id BOXNO HEADOFFICE EMAIL WEBSITE bankname

* C_Details_id Customer_Name AccountNumber Email_Address ContactNo Date_Created AgentName AccountNumberG BankBranch AgentContactno AgentSignOnName AgentID GenderStatus Accoun2 Branchname Accountno PassportPhoto SignaturePhoto PhotoPath SigPath GhanaCard GhanaCardFront GhanaCardBack GhanaCardDOB GhanaCardVerified

* DailyD_id DepositDate AgentAccNo AgentName TotalCustomers1 DepositAmt BankBranch AgentName2

* id BankBranch Accno CreditAmount Transid full_json created_at

* id product_code product_name interest_rate duration_months status

* id branch applicant_name dob accno id_type id_number tel scheme rollover rollover_type period value_date maturity_date amount amount_words agent created_at

* id member_id card_number full_name dob gender address front_photo back_photo verified created_at

* id acc ghana_card dob front_path back_path verified_by verified_at match_score

* id group_id meeting_id member_id is_present remarks created_at

* id group_id meeting_date meeting_time location gps attendance_total attendance_present notes photo created_by created_at

* id group_id full_name phone account_no role gender dob residential_address gps_address id_type id_number occupation kin_name kin_phone photo signature is_present created_at

* id group_id member_id type amount balance_after description receipt_no created_at

* ipd_id name amt norow agentNo Transno InputterName Transdate TotalAmt Agentid AgentNum Agentgender

* id group_id member_id amount interest_rate interest_amount total_payable amount_paid balance purpose repayment_period due_date status disbursed_date created_at

* id product_code product_name interest_rate status

* id loan_id group_id member_id amount payment_date method receipt_no created_at

* id Bankname Name Emadd empass Hostname portnumber securetype status Messsage Subject message2 message3 AboutPass1 AboutPass2 AboutPass3 AboutPass4

* id group_code group_name branch_id meeting_days meeting_time meeting_location location_gps contact_address treasury_amount group_leader_name group_leader_phone group_leader_photo group_leader_signature chairman_name chairman_signature secretary_name secretary_signature treasurer_name treasurer_signature organizer_name organizer_signature group_photo total_members status created_at updated_at

* pa_id SignOnName Fullname DateTime Comment

* id accno customer_name address tel occupation monthly_salary current_loan monthly_ded expiry amount_requested purpose app_date signature_path off_balance rec_amount app_amount agent created_at

* id group_id member_id amount date note created_at

* key value

* key value

* id acc channel sent_to total count_txn message sent_by sent_at

* id api_key sender_id cost status cost_per_sms api_status

* id specsd

* id specsd

* Sus_id Accountno Accountname AccountNum shortnum Accono1 Accoun2 Accoun3 Branchname

* Sus_id Accountno Accountname AccountNum shortnum

* Sus_id Accountno Accountname AccountNum shortnum Accono1 Accoun2 Accoun3 Branchname

* Sust_id Cusno Accno Accname Transdate TransDateTime CreatedAt Description CreditAmount Transid AgentName AgentLat AgentLong AgentLocation GPSAccuracy AccountNumber TellerName TellerCashAcc BankBranch ContactNo AgentContactno AgentSignOnName AgentID GenderStatus VerifyBy VerifyBy2 tabidno AccType TransactionType TransactionCurrency

* id group_id type amount previous_balance new_balance member_id description receipt_no created_by created_at

* userid username Password AccountNum contactnumber BankBranch AccountType SignOnName fullname StatusType Designation Designation2 UserBranch Fname Mname Lname DefaultPassword FullNamek Tdate LogInStatus Messalert1 CashAccount

* mic_id accno accname secretPin pin1 confpin1 Bankbranch branch_type AccountType AccessLevel system_role SignOnNam Coun AccontNumber AgentContactno AgentID GenderStatus sectionLogIn

* id audit_date vault_date branch_code action_type record_id teller_no amount old_status new_status performed_by role_performed ip_address details

* id vault_date branch_code movement_type teller_no teller_name denom_200 denom_100 denom_50 denom_20 denom_10 denom_5 denom_2 denom_1 denom_c200 denom_c100 denom_c050 denom_c020 denom_c010 total_pieces total_amount remarks status approved_by approved_at created_by created_at denom_c005 notes_amount coins_amount denom_c001 denom_2_note denom_1_note

* id vault_date branch_code opening_balance closing_balance created_by created_at denom_200 denom_100 denom_50 denom_20 denom_10 denom_5 denom_2 denom_1 denom_c050 denom_c020 denom_c010 denom_c005 notes_amount coins_amount denom_c001 denom_2_note denom_1_note

* id branch_code teller_no teller_name teller_pin role password pin pin_hash status created_at

* id acc phone message status created_at

select table 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_cards ghana_card_verification group_attendance group_meetings group_members group_treasury iptabl22n loans loan_products loan_repayments 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 . 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 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_cards ghana_card_verification group_attendance group_meetings group_members group_treasury iptabl22n loans loan_products loan_repayments 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 .	select column