Recent
`axiuss40_africa_personal_program_school`.`tribes`
`axiuss40_africa_personal_program_school`.`worker_schedule`
`axiuss40_africa_personal_program_school`.`day_task_finished`
`task_manager`.`location_states`
`axiuss40_africa_charity_program`.`reports_dates`
`axiuss40_africa_personal_program_school`.`modules`
`task_manager`.`employees`
`axiuss40_africa_personal_program_school`.`professions`
`axiuss40_africa_patient_program`.`user_profiles`
`mysql`.`column_stats`
Favorites
There are no favorite tables.
New
axiuss40_africa
charity_program
axiuss40_africa_charity_program
axiuss40_africa_charity_program_staging
money_program
axiuss40_africa_money_program
axiuss40_africa_money_program_bk
axiuss40_africa_money_program_private
axiuss40_africa_money_program_private_german
axiuss40_africa_money_program_rdi
axiuss40_africa_money_program_staging
patient_program
axiuss40_africa_patient_program
axiuss40_africa_patient_program_bk
axiuss40_africa_patient_program_staging
axiuss40_africa_patient_program_staging_old
personal_program
axiuss40_africa_personal_program
axiuss40_africa_personal_program_bk
axiuss40_africa_personal_program_school
axiuss40_africa_personal_program_staging
information_schema
mysql
performance_schema
task_manager
task_manager
task_manager_staging
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
Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session?
Yes
/
No
/
Delete settings
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: axiuss40_africa_money_program
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Designer
Console
Clear
History
Options
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 :
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
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Query window
*
id
name
currency_id
balance
activation_date
is_bank_statement_available
account_type
is_obsolute_account
iban
bank_name
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
account_id
name
date_from
date_to
incoming_balance
outgoing_balance
document_file_ext
document_file
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
account_id
transfer_account_id
type
number
date
payee
amount
amount2
exchange_rate
category_id
sub_category_id
sub_sub_category_id
info
document
document_file
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
TransactionID
*
id
booking_id
action
account_id
transfer_account_id
type
number
date
payee
amount
category_id
sub_category_id
sub_sub_category_id
info
document
delete_reason
addedOn
addedBy
modifiedBy
modifiedOn
*
id
booking_id
material
qty
split_amount
per_qty_price
package
packageSize
packageValue
project
info
purpose
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
TransactionID
Picture
*
id
booking_id
cat_id
sub_cat_id
sub_sub_cat_id
split_amount
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
CatID
SubcatID
SubSubCatID
name
type
parent_id
status
status2
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
user_email
ip_address
user_agent
timestamp
data
browser
version
device
platform
*
id
name
value
language_id
addedOn
modifiedOn
*
id
name
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
category_id
title
description
image
status
order_no
deleted
slug
meta_title
meta_key
meta_description
addedBy
addedOn
modifiedOn
modifiedBy
*
id
name
symbol
exchange_rate
code
exchange_rate_def
status
deleted
addedBy
modifiedBy
addedOn
modifiedOn
*
id
number
deposit_date
pay_from
amount
info
document
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
deposit_id
cat_id
sub_cat_id
sub_sub_cat_id
split_amount
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
name
email_template_key
email_from
email_subject
content
content_cn
email_subject_cn
variables
sms_template
sms_send_status
status
modifiedDate
createdDate
addedBy
modifiedBy
*
id
parent_id
name
date
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
folder_id
file_original_name
file_name
user_id
file_size
extension
type
created_at
updated_at
deleted_at
deleted
status
*
id
name
short_form
language_code
text_direction
status
deleted
language_order
text_editor_lang
flag_path
*
id
name
state_id
state_code
country_id
country_code
latitude
longitude
created_at
updated_at
flag
wikiDataId
*
id
name
iso3
iso2
phonecode
capital
currency
currency_symbol
tld
native
region
subregion
timezones
translations
latitude
longitude
emoji
emojiU
created_at
updated_at
status
wikiDataId
*
id
name
country_id
country_code
fips_code
iso2
latitude
longitude
created_at
updated_at
flag
wikiDataId
*
id
name
distance
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
ip_address
login
time
*
id
session_id
user_email
ip_address
user_agent
login_time
logout_time
browser
version
device
platform
mac_id
modifiedOn
user_id
*
id
name
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
section
name
lang_names
alias
order_no
is_url
url
parent_id
description
icon
permissions
is_public
addedBy
status
deleted
addedOn
modifiedOn
modifiedBy
*
id
name
company_group_ids
town
email
contact_no_1
contact_no_2
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
user_id
from_date
to_date
*
id
parent_id
name
description
modifiedBy
deleted
addedBy
addedOn
modifiedOn
status
*
id
role_id
module_id
parent_module_id
section
permission_add
permission_edit
permission_view
permission_delete
permission_status
addedBy
addedOn
modifiedOn
*
id
name
value
language_id
addedOn
modifiedOn
*
id
number
date
pay_from
pay_to
amount
info
document
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
name
checked
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
file_original_name
file_name
user_id
file_size
extension
type
created_at
updated_at
deleted_at
*
id
parent_id
role_ids
login_id
password
is_online
is_verified
is_admin_verified
is_first_login
otp
device_type
ios_device_id
android_device_id
web_token
login_type
login_language
addedOn
modifiedOn
addedBy
modifiedBy
status
deleted
*
id
user_id
is_favourite
name
phone_no
address
area
lat
lng
address_type
is_gift
status
deleted
addedBy
modifiedBy
addedOn
modifiedOn
*
id
parent_id
user_id
full_name
fname
lname
email
phone_code
phone_no
profile_image
gender
dob
about
landmark
address
lat
lng
state_id
country_id
city_id
pincode
addedOn
modifiedOn
modifiedBy
*
id
user_id
day
day_name
time_from
time_to
type
modifiedOn
*
id
user_id
time_zone
language_id
multifactor_authenticate
google_auth_code
authenticate_using_otp
otp_phone
otp
authenticate_using_google
modifiedOn
modifiedBy
*
id
number
date
pay_to
amount
info
document
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
withdrawal_id
cat_id
sub_cat_id
sub_sub_cat_id
split_amount
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
select table
accounts
bank_statements
bookings
booking_histories
booking_materials
booking_pictures
booking_splits
categories
ci_sessions
company_details
company_groups
contents
currencies
deposits
deposits_splits
email_templates
folders
folder_files
languages
location_cities
location_countries
location_states
location_villages
login_attempts
login_records
materials
modules
payees
reports_dates
roles
role_permissions
settings
transfers
tribes
uploads
users
user_address_books
user_profiles
user_schedules
user_settings
withdrawals
withdrawal_splits
.
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
accounts
bank_statements
bookings
booking_histories
booking_materials
booking_pictures
booking_splits
categories
ci_sessions
company_details
company_groups
contents
currencies
deposits
deposits_splits
email_templates
folders
folder_files
languages
location_cities
location_countries
location_states
location_villages
login_attempts
login_records
materials
modules
payees
reports_dates
roles
role_permissions
settings
transfers
tribes
uploads
users
user_address_books
user_profiles
user_schedules
user_settings
withdrawals
withdrawal_splits
.
select column
select table
accounts
bank_statements
bookings
booking_histories
booking_materials
booking_pictures
booking_splits
categories
ci_sessions
company_details
company_groups
contents
currencies
deposits
deposits_splits
email_templates
folders
folder_files
languages
location_cities
location_countries
location_states
location_villages
login_attempts
login_records
materials
modules
payees
reports_dates
roles
role_permissions
settings
transfers
tribes
uploads
users
user_address_books
user_profiles
user_schedules
user_settings
withdrawals
withdrawal_splits
.
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
accounts
bank_statements
bookings
booking_histories
booking_materials
booking_pictures
booking_splits
categories
ci_sessions
company_details
company_groups
contents
currencies
deposits
deposits_splits
email_templates
folders
folder_files
languages
location_cities
location_countries
location_states
location_villages
login_attempts
login_records
materials
modules
payees
reports_dates
roles
role_permissions
settings
transfers
tribes
uploads
users
user_address_books
user_profiles
user_schedules
user_settings
withdrawals
withdrawal_splits
.
select column
select table
accounts
bank_statements
bookings
booking_histories
booking_materials
booking_pictures
booking_splits
categories
ci_sessions
company_details
company_groups
contents
currencies
deposits
deposits_splits
email_templates
folders
folder_files
languages
location_cities
location_countries
location_states
location_villages
login_attempts
login_records
materials
modules
payees
reports_dates
roles
role_permissions
settings
transfers
tribes
uploads
users
user_address_books
user_profiles
user_schedules
user_settings
withdrawals
withdrawal_splits
.
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
accounts
bank_statements
bookings
booking_histories
booking_materials
booking_pictures
booking_splits
categories
ci_sessions
company_details
company_groups
contents
currencies
deposits
deposits_splits
email_templates
folders
folder_files
languages
location_cities
location_countries
location_states
location_villages
login_attempts
login_records
materials
modules
payees
reports_dates
roles
role_permissions
settings
transfers
tribes
uploads
users
user_address_books
user_profiles
user_schedules
user_settings
withdrawals
withdrawal_splits
.
select column
select table
accounts
bank_statements
bookings
booking_histories
booking_materials
booking_pictures
booking_splits
categories
ci_sessions
company_details
company_groups
contents
currencies
deposits
deposits_splits
email_templates
folders
folder_files
languages
location_cities
location_countries
location_states
location_villages
login_attempts
login_records
materials
modules
payees
reports_dates
roles
role_permissions
settings
transfers
tribes
uploads
users
user_address_books
user_profiles
user_schedules
user_settings
withdrawals
withdrawal_splits
.
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
accounts
bank_statements
bookings
booking_histories
booking_materials
booking_pictures
booking_splits
categories
ci_sessions
company_details
company_groups
contents
currencies
deposits
deposits_splits
email_templates
folders
folder_files
languages
location_cities
location_countries
location_states
location_villages
login_attempts
login_records
materials
modules
payees
reports_dates
roles
role_permissions
settings
transfers
tribes
uploads
users
user_address_books
user_profiles
user_schedules
user_settings
withdrawals
withdrawal_splits
.
select column
