Recent
`performance_schema`.`mutex_instances`
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_personal_program_school
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
price
percentageOfBasicSalary
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
allowence_id
date
givenAlways
notGivenWhenIll
notGivenWhenVacation
onlyGivenOnVacation
notTaxed
doubleShift
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
Name
Surname
Gender
Birth
Nationality
MobileNo_1
IsWhatsapp_1
IsComon_1
MobileNo_2
IsWhatsapp_2
IsComon_2
Email
ExecutivBoardPositionID
PositionSince
ImagePath
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
ID
Valid
Item1ID
Item2ID
Item3ID
EmploymentMonths
*
id
user_email
ip_address
user_agent
timestamp
data
browser
version
device
platform
*
id
name
value
language_id
addedOn
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
*
EmpTaskID
Date
Finished
*
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
first_name
sur_name
gender
date_of_birth
nationality_id
religion_id
mobile_no_1
is_whatsapp_mobile_1
is_comon_mobile_1
mobile_no_2
is_whatsapp_mobile_2
is_comon_mobile_2
email
city
town
street
social_security_no
tax_no
profession_id
sector_id
can_read
can_write
is_lives_in_project_staff_house
from_date
to_date
ResignType
image
signature_image
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
employee_id
person_name
contact_number
relation
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
EmployeeID
Name
Content
DocumentType
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
id_image
signature_image
tin_number
employee_id
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
employeed_as
date_of_employment
date_of_termination
days_of_vocation
is_living_in_staffhouse
employee_id
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
name
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
employee_id
basic_salary
allowances
allowances_ids
total_salary
position
bank_name
bban
bank_account_number
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
employee_id
message_template_id
subject
content
email
email_from
email_send_at
email_send_status
file_name
file
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
ID
Name
ShortName
EmpltType
Color
*
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
date
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
FromInt
ToInt
Amount
OwnerID
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
name
short_form
language_code
text_direction
status
deleted
language_order
text_editor_lang
flag_path
*
ID
Name
Password
*
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
email_template_for
sectors_ids
professions_ids
email_subject
content
status
deleted
modifiedDate
createdDate
addedBy
modifiedBy
*
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
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
type
sub_type
Name
Street
PLZ
Town
POBox
Email
Phone
Fax
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
bank_name
bank_iban
contacts
*
id
PartnerID
Gender
Address
Title
Pos
Name
Surname
Phone
Mobile
Fax
Email
Note
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
partners_type_id
name
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
name
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
name
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
id
name
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
*
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
SalaryHistoryID
AllowanceID
AmountAllDays
AmountCalculateDays
Amount
NotPaidDays
*
id
YearMonth
EmplID
CalculationDate
WorkDays
WorkDaysInMonth
BasicSalary
BasicSalaryManual
Allowances
AllowancesManual
RegularBonus
IrregularBonus
IrregularBonusManual
PaidAdvance
RepaymentOfLoan
RepaymentOfLoanManual
IncomeTax
IncomeTaxManual
OtherTaxes
EmplSocialSecurity
EmplSocialSecurityPercent
CompSocialSecurity
CompSocialSecurityPercent
SocialSecurityTotal
EmplSocialSecurityGov
EmplSocialSecurityPercentGov
CompSocialSecurityGov
CompSocialSecurityPercentGov
SocialSecurityTotalGov
EmplSocialSecurityInj
EmplSocialSecurityPercentInj
CompSocialSecurityInj
CompSocialSecurityPercentInj
SocialSecurityTotalInj
InsurenceAmount
Brutto
Payment
Calculated
CountPaidDayForBasicSalary
NotPaidDaysForBasicSalary
SettlementDate
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
Extra
*
id
name
status
deleted
addedOn
addedBy
modifiedBy
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
addedOn
modifiedOn
addedBy
modifiedBy
status
deleted
login_language
*
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
Name
*
ID
GroupID
WorkerID
Pos
*
Date
WorkerID
EmpltTmplID
*
id
EmployeeID
Year
Month
D1
D2
D3
D4
D5
D6
D7
D8
D9
D10
D11
D12
D13
D14
D15
D16
D17
D18
D19
D20
D21
D22
D23
D24
D25
D26
D27
D28
D29
D30
D31
status
deleted
addedOn
addedBy
modifiedBy
modifiedOn
select table
allowances
allowance_salary_settings
board_members
bonus_reg
ci_sessions
company_details
contents
currencies
day_task_finished
email_templates
employees
employees_emergency_contact_details
employees_related_documents
employee_extras
employee_miscellaneous
employee_roles
employee_salaries
employee_send_messages
employment_types
folders
folder_files
holidays
income_tax_rates
languages
last_user
location_cities
location_countries
location_states
location_villages
login_attempts
login_records
message_templates
modules
nationalities
partners
partners_contacts
partners_sub_types
partners_types
professions
religions
roles
role_permissions
salaries_history_allowances
salary_histories
sectors
settings
transfers
tribes
uploads
users
user_address_books
user_profiles
user_schedules
user_settings
worker_groups
worker_group_members
worker_schedule
worker_schedules
.
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
allowances
allowance_salary_settings
board_members
bonus_reg
ci_sessions
company_details
contents
currencies
day_task_finished
email_templates
employees
employees_emergency_contact_details
employees_related_documents
employee_extras
employee_miscellaneous
employee_roles
employee_salaries
employee_send_messages
employment_types
folders
folder_files
holidays
income_tax_rates
languages
last_user
location_cities
location_countries
location_states
location_villages
login_attempts
login_records
message_templates
modules
nationalities
partners
partners_contacts
partners_sub_types
partners_types
professions
religions
roles
role_permissions
salaries_history_allowances
salary_histories
sectors
settings
transfers
tribes
uploads
users
user_address_books
user_profiles
user_schedules
user_settings
worker_groups
worker_group_members
worker_schedule
worker_schedules
.
select column
select table
allowances
allowance_salary_settings
board_members
bonus_reg
ci_sessions
company_details
contents
currencies
day_task_finished
email_templates
employees
employees_emergency_contact_details
employees_related_documents
employee_extras
employee_miscellaneous
employee_roles
employee_salaries
employee_send_messages
employment_types
folders
folder_files
holidays
income_tax_rates
languages
last_user
location_cities
location_countries
location_states
location_villages
login_attempts
login_records
message_templates
modules
nationalities
partners
partners_contacts
partners_sub_types
partners_types
professions
religions
roles
role_permissions
salaries_history_allowances
salary_histories
sectors
settings
transfers
tribes
uploads
users
user_address_books
user_profiles
user_schedules
user_settings
worker_groups
worker_group_members
worker_schedule
worker_schedules
.
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
allowances
allowance_salary_settings
board_members
bonus_reg
ci_sessions
company_details
contents
currencies
day_task_finished
email_templates
employees
employees_emergency_contact_details
employees_related_documents
employee_extras
employee_miscellaneous
employee_roles
employee_salaries
employee_send_messages
employment_types
folders
folder_files
holidays
income_tax_rates
languages
last_user
location_cities
location_countries
location_states
location_villages
login_attempts
login_records
message_templates
modules
nationalities
partners
partners_contacts
partners_sub_types
partners_types
professions
religions
roles
role_permissions
salaries_history_allowances
salary_histories
sectors
settings
transfers
tribes
uploads
users
user_address_books
user_profiles
user_schedules
user_settings
worker_groups
worker_group_members
worker_schedule
worker_schedules
.
select column
select table
allowances
allowance_salary_settings
board_members
bonus_reg
ci_sessions
company_details
contents
currencies
day_task_finished
email_templates
employees
employees_emergency_contact_details
employees_related_documents
employee_extras
employee_miscellaneous
employee_roles
employee_salaries
employee_send_messages
employment_types
folders
folder_files
holidays
income_tax_rates
languages
last_user
location_cities
location_countries
location_states
location_villages
login_attempts
login_records
message_templates
modules
nationalities
partners
partners_contacts
partners_sub_types
partners_types
professions
religions
roles
role_permissions
salaries_history_allowances
salary_histories
sectors
settings
transfers
tribes
uploads
users
user_address_books
user_profiles
user_schedules
user_settings
worker_groups
worker_group_members
worker_schedule
worker_schedules
.
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
allowances
allowance_salary_settings
board_members
bonus_reg
ci_sessions
company_details
contents
currencies
day_task_finished
email_templates
employees
employees_emergency_contact_details
employees_related_documents
employee_extras
employee_miscellaneous
employee_roles
employee_salaries
employee_send_messages
employment_types
folders
folder_files
holidays
income_tax_rates
languages
last_user
location_cities
location_countries
location_states
location_villages
login_attempts
login_records
message_templates
modules
nationalities
partners
partners_contacts
partners_sub_types
partners_types
professions
religions
roles
role_permissions
salaries_history_allowances
salary_histories
sectors
settings
transfers
tribes
uploads
users
user_address_books
user_profiles
user_schedules
user_settings
worker_groups
worker_group_members
worker_schedule
worker_schedules
.
select column
select table
allowances
allowance_salary_settings
board_members
bonus_reg
ci_sessions
company_details
contents
currencies
day_task_finished
email_templates
employees
employees_emergency_contact_details
employees_related_documents
employee_extras
employee_miscellaneous
employee_roles
employee_salaries
employee_send_messages
employment_types
folders
folder_files
holidays
income_tax_rates
languages
last_user
location_cities
location_countries
location_states
location_villages
login_attempts
login_records
message_templates
modules
nationalities
partners
partners_contacts
partners_sub_types
partners_types
professions
religions
roles
role_permissions
salaries_history_allowances
salary_histories
sectors
settings
transfers
tribes
uploads
users
user_address_books
user_profiles
user_schedules
user_settings
worker_groups
worker_group_members
worker_schedule
worker_schedules
.
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
allowances
allowance_salary_settings
board_members
bonus_reg
ci_sessions
company_details
contents
currencies
day_task_finished
email_templates
employees
employees_emergency_contact_details
employees_related_documents
employee_extras
employee_miscellaneous
employee_roles
employee_salaries
employee_send_messages
employment_types
folders
folder_files
holidays
income_tax_rates
languages
last_user
location_cities
location_countries
location_states
location_villages
login_attempts
login_records
message_templates
modules
nationalities
partners
partners_contacts
partners_sub_types
partners_types
professions
religions
roles
role_permissions
salaries_history_allowances
salary_histories
sectors
settings
transfers
tribes
uploads
users
user_address_books
user_profiles
user_schedules
user_settings
worker_groups
worker_group_members
worker_schedule
worker_schedules
.
select column