Recent
`humanresource`.`budget_controller_jo`
`general`.`setup_security_dtl`
`service_request_db`.`migrations`
`accounting`.`documentmanager`
`general`.`activitylog`
`general`.`application_ot`
`documenttracker`.`flowsetupmain`
`general`.`setup_system`
`general`.`useroverideaccess`
`service_request_db`.`app_modules`
Favorites
There are no favorite tables.
New
accounting
bac_lgu
budget
cenro
dbfederation
db_meter_readings
documenttracker
el_laravue
general
humanresource
information_schema
lgis
lgis_app
lgis_dum_app
lgu_repository
mysql
online_hr
performance
performance_management
performance_schema
qpsii
qpsii_lguengineering
qpsii_lguprocurement
qpsii_lgusystem
qpsii_waterworks
queue
repository
service_request_db
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: accounting
Structure
(current)
SQL
Search
Query
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
Database structure
Database structure
Choose which details to show in the database structure (list of tables).
Database structure
Show table charset
Show or hide a column displaying the charset for all tables.
Show table comments
Show or hide a column displaying the comments for all tables.
Show creation timestamp
Show or hide a column displaying the Creation timestamp for all tables.
Show last update timestamp
Show or hide a column displaying the Last update timestamp for all tables.
Show last check timestamp
Show or hide a column displaying the Last check timestamp for all tables.
Page number:
1
2
>
>>
Filters
Containing the word:
Table
Action
Rows
May be approximate. Click on the number to get the exact count. See
FAQ 3.11
.
Type
Collation
Size
Overhead
accounts_parents
Browse
Structure
Search
Insert
Empty
Drop
79
InnoDB
latin1_swedish_ci
16.0
KiB
-
accounttable
Browse
Structure
Search
Insert
Empty
Drop
589
InnoDB
latin1_swedish_ci
96.0
KiB
-
accounttypemodel
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
accounttypes
Browse
Structure
Search
Insert
Empty
Drop
57
InnoDB
latin1_swedish_ci
16.0
KiB
-
accounttypescopy
Browse
Structure
Search
Insert
Empty
Drop
15
InnoDB
latin1_swedish_ci
16.0
KiB
-
account_classification
Browse
Structure
Search
Insert
Empty
Drop
6
InnoDB
latin1_swedish_ci
16.0
KiB
-
account_ledger
Browse
Structure
Search
Insert
Empty
Drop
8
InnoDB
latin1_swedish_ci
16.0
KiB
-
account_main
Browse
Structure
Search
Insert
Empty
Drop
5
InnoDB
latin1_swedish_ci
16.0
KiB
-
account_per_department
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
account_setup
Browse
Structure
Search
Insert
Empty
Drop
723
InnoDB
latin1_swedish_ci
272.0
KiB
-
account_setup2
Browse
Structure
Search
Insert
Empty
Drop
596
InnoDB
latin1_swedish_ci
208.0
KiB
-
account_setupcopy
Browse
Structure
Search
Insert
Empty
Drop
584
InnoDB
latin1_swedish_ci
208.0
KiB
-
account_setup_default
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
112.0
KiB
-
account_setup_excel
Browse
Structure
Search
Insert
Empty
Drop
594
InnoDB
latin1_swedish_ci
208.0
KiB
-
account_setup_orig
Browse
Structure
Search
Insert
Empty
Drop
782
InnoDB
latin1_swedish_ci
240.0
KiB
-
account_setup_orig2
Browse
Structure
Search
Insert
Empty
Drop
594
InnoDB
latin1_swedish_ci
208.0
KiB
-
account_type
Browse
Structure
Search
Insert
Empty
Drop
4
InnoDB
latin1_swedish_ci
16.0
KiB
-
advances_from_customer
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
advance_to_supplier
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
advance_to_supplier_offsetted
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
adviceentrydetail
Browse
Structure
Search
Insert
Empty
Drop
2,962
InnoDB
latin1_swedish_ci
1.5
MiB
-
adviceentrymain
Browse
Structure
Search
Insert
Empty
Drop
567
InnoDB
latin1_swedish_ci
208.0
KiB
-
agents_cash_adv
Browse
Structure
Search
Insert
Empty
Drop
3
InnoDB
latin1_swedish_ci
16.0
KiB
-
aging_basedate
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
64.0
KiB
-
amount_limits
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
utf8_general_ci
16.0
KiB
-
applog
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
appointments
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
48.0
KiB
-
apv_charges
Browse
Structure
Search
Insert
Empty
Drop
11
InnoDB
utf8_general_ci
16.0
KiB
-
apv_entry
Browse
Structure
Search
Insert
Empty
Drop
5
InnoDB
utf8_general_ci
16.0
KiB
-
apv_number
Browse
Structure
Search
Insert
Empty
Drop
541
InnoDB
latin1_swedish_ci
144.0
KiB
-
apv_number_copy
Browse
Structure
Search
Insert
Empty
Drop
537
InnoDB
latin1_swedish_ci
96.0
KiB
-
apv_records
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
48.0
KiB
-
ap_account
Browse
Structure
Search
Insert
Empty
Drop
818
InnoDB
latin1_swedish_ci
96.0
KiB
-
assistance_survey_setup
Browse
Structure
Search
Insert
Empty
Drop
15
InnoDB
latin1_swedish_ci
16.0
KiB
-
atc_setup
Browse
Structure
Search
Insert
Empty
Drop
86
InnoDB
latin1_swedish_ci
48.0
KiB
-
atc_tax_rate
Browse
Structure
Search
Insert
Empty
Drop
11
InnoDB
latin1_swedish_ci
16.0
KiB
-
atc_vendor_default
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
autoritytodeduct
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
autoritytodeduct_details
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
balancesheet_group
Browse
Structure
Search
Insert
Empty
Drop
441
InnoDB
latin1_swedish_ci
80.0
KiB
-
bankreconentry
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
latin1_swedish_ci
16.0
KiB
-
bank_recon_records
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
beginning_ap
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
beginning_ar
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
beginning_entry
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
beginning_temp
Browse
Structure
Search
Insert
Empty
Drop
724
InnoDB
latin1_swedish_ci
240.0
KiB
-
billingrecord
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
billing_monitoring
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
billing_others
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
bill_series
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
bircolumn
Browse
Structure
Search
Insert
Empty
Drop
3
InnoDB
utf8_general_ci
16.0
KiB
-
bir_signatories
Browse
Structure
Search
Insert
Empty
Drop
3
InnoDB
latin1_swedish_ci
16.0
KiB
-
bisligpetty
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
bislig_petty_liquidate
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
board_directors
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
breakdown_invoices
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
breakdown_invoices_ar
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
bsgroup_setup
Browse
Structure
Search
Insert
Empty
Drop
67
InnoDB
latin1_swedish_ci
16.0
KiB
-
budgettypes
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
latin1_swedish_ci
16.0
KiB
-
casd_release
Browse
Structure
Search
Insert
Empty
Drop
15
InnoDB
latin1_swedish_ci
80.0
KiB
-
cashadvance
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
cashadvancemonitoring
Browse
Structure
Search
Insert
Empty
Drop
15
InnoDB
latin1_swedish_ci
16.0
KiB
-
cashadvance_details
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
cashall
Browse
Structure
Search
Insert
Empty
Drop
3
InnoDB
latin1_swedish_ci
32.0
KiB
-
cashflowdetail_group
Browse
Structure
Search
Insert
Empty
Drop
572
InnoDB
latin1_swedish_ci
128.0
KiB
-
cashflow_group
Browse
Structure
Search
Insert
Empty
Drop
206
InnoDB
latin1_swedish_ci
48.0
KiB
-
cashliquidation
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
cashvoucher_series
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
48.0
KiB
-
cash_advances
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
cash_advance_request
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
cash_advance_request_details
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
casl_liq
Browse
Structure
Search
Insert
Empty
Drop
9
InnoDB
latin1_swedish_ci
96.0
KiB
-
casl_liq_br
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
casl_liq_details
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
64.0
KiB
-
casl_refund_list
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
casl_released
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
80.0
KiB
-
cfdetailgroup_setup
Browse
Structure
Search
Insert
Empty
Drop
28
InnoDB
latin1_swedish_ci
32.0
KiB
-
cfgroup_setup
Browse
Structure
Search
Insert
Empty
Drop
27
InnoDB
latin1_swedish_ci
16.0
KiB
-
cf_accounts
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
48.0
KiB
-
cf_description
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
cf_taxes
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
32.0
KiB
-
change_in_eqt_setup
Browse
Structure
Search
Insert
Empty
Drop
3
InnoDB
utf8_general_ci
16.0
KiB
-
checkdefaultsignatories
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
checkingaccountlog
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
80.0
KiB
-
checkingaccountlog_debits
Browse
Structure
Search
Insert
Empty
Drop
625
InnoDB
latin1_swedish_ci
256.0
KiB
-
checkrecieve
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
checkreleasinginfo
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
checks_records
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
checks_warehouse
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
checkwarehouse
Browse
Structure
Search
Insert
Empty
Drop
5,659
InnoDB
latin1_swedish_ci
2.5
MiB
-
checkwarehouseclearingstatus
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
check_monitoring
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
check_preparation
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
check_preparation_accounts
Browse
Structure
Search
Insert
Empty
Drop
6
InnoDB
utf8_general_ci
16.0
KiB
-
check_prep_apvs
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
check_prep_apvs_wtax
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
check_received_released_stat
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
check_warehouse
Browse
Structure
Search
Insert
Empty
Drop
5,020
InnoDB
utf8_general_ci
1.5
MiB
-
check_warehousing
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
cho1_potability_permit_insp_activity
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
classification_setup
Browse
Structure
Search
Insert
Empty
Drop
12
InnoDB
latin1_swedish_ci
48.0
KiB
-
classification_setup2
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
64.0
KiB
-
classification_setupcopy
Browse
Structure
Search
Insert
Empty
Drop
7
InnoDB
latin1_swedish_ci
16.0
KiB
-
class_instructors
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
class_section
Browse
Structure
Search
Insert
Empty
Drop
3
InnoDB
latin1_swedish_ci
16.0
KiB
-
class_subject
Browse
Structure
Search
Insert
Empty
Drop
11
InnoDB
latin1_swedish_ci
16.0
KiB
-
class_type
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
class_type_year
Browse
Structure
Search
Insert
Empty
Drop
4
InnoDB
latin1_swedish_ci
16.0
KiB
-
clearing_cust_advanc_pay
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
clev_ar
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
clev_deductions
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
closing_entry_log
Browse
Structure
Search
Insert
Empty
Drop
87
InnoDB
latin1_swedish_ci
16.0
KiB
-
committee_report
Browse
Structure
Search
Insert
Empty
Drop
8
InnoDB
latin1_swedish_ci
16.0
KiB
-
container_monitoring
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
conversion_setup
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
latin1_swedish_ci
16.0
KiB
-
costing
Browse
Structure
Search
Insert
Empty
Drop
1,603
InnoDB
utf8_general_ci
1.5
MiB
-
counteredpo
Browse
Structure
Search
Insert
Empty
Drop
30
InnoDB
latin1_swedish_ci
16.0
KiB
-
counteredporr
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
32.0
KiB
-
countered_entry
Browse
Structure
Search
Insert
Empty
Drop
6
InnoDB
utf8_general_ci
16.0
KiB
-
countered_rr
Browse
Structure
Search
Insert
Empty
Drop
4
InnoDB
latin1_swedish_ci
16.0
KiB
-
countered_si
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
countered_si_rr_matching
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
countering
Browse
Structure
Search
Insert
Empty
Drop
16
InnoDB
latin1_swedish_ci
16.0
KiB
-
cto_cash_disbursement_statement
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
cto_check_disbursement_voucher
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
cto_fund_setup
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
cto_official_reciept_setup_cash_tickets_registry_details
Browse
Structure
Search
Insert
Empty
Drop
4
InnoDB
latin1_swedish_ci
32.0
KiB
-
cto_official_reciept_setup_cash_tickets_registry_main
Browse
Structure
Search
Insert
Empty
Drop
4
InnoDB
latin1_swedish_ci
32.0
KiB
-
cto_official_reciept_setup_cash_tickets_sales_dtails
Browse
Structure
Search
Insert
Empty
Drop
34
InnoDB
latin1_swedish_ci
16.0
KiB
-
cto_official_reciept_setup_cash_tickets_sales_main
Browse
Structure
Search
Insert
Empty
Drop
31
InnoDB
latin1_swedish_ci
16.0
KiB
-
cto_official_reciept_setup_cash_tickets_withdrawal_dtails
Browse
Structure
Search
Insert
Empty
Drop
29
InnoDB
latin1_swedish_ci
16.0
KiB
-
cto_official_reciept_setup_cash_tickets_withdrawal_main
Browse
Structure
Search
Insert
Empty
Drop
30
InnoDB
latin1_swedish_ci
16.0
KiB
-
cto_transaction_partial_deposit
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
cto_transaction_partial_deposit_dtl
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
currencysetup
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
customeradvancedeductionlogs
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
customeradvances
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
customeradvanceslog
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
customersl_log
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
customize_invoice
Browse
Structure
Search
Insert
Empty
Drop
19
InnoDB
utf8_general_ci
16.0
KiB
-
cust_adv_refund_log
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
cwip_logs
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
debits_actual_deducted
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
32.0
KiB
-
defaultbank
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
defaultids
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
defaults
Browse
Structure
Search
Insert
Empty
Drop
18
InnoDB
utf8_general_ci
16.0
KiB
-
defaults_accounts
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
deletionlogmodel
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
deposited_collection
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
depreciationaccounts
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
64.0
KiB
-
division_setup
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
documentmanager
Browse
Structure
Search
Insert
Empty
Drop
30
InnoDB
latin1_swedish_ci
16.0
KiB
-
documentmanager_file
Browse
Structure
Search
Insert
Empty
Drop
599
InnoDB
latin1_swedish_ci
192.0
KiB
-
document_financial
Browse
Structure
Search
Insert
Empty
Drop
3
InnoDB
latin1_swedish_ci
16.0
KiB
-
document_name1
Browse
Structure
Search
Insert
Empty
Drop
7
InnoDB
latin1_swedish_ci
16.0
KiB
-
document_setup
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
latin1_swedish_ci
16.0
KiB
-
doc_attendance
Browse
Structure
Search
Insert
Empty
Drop
8
InnoDB
latin1_swedish_ci
16.0
KiB
-
doc_incoming
Browse
Structure
Search
Insert
Empty
Drop
6
InnoDB
latin1_swedish_ci
16.0
KiB
-
doc_outgoing
Browse
Structure
Search
Insert
Empty
Drop
13
InnoDB
latin1_swedish_ci
16.0
KiB
-
doc_recording
Browse
Structure
Search
Insert
Empty
Drop
5
InnoDB
latin1_swedish_ci
16.0
KiB
-
doc_trainseminar
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
latin1_swedish_ci
16.0
KiB
-
doc_transmittal
Browse
Structure
Search
Insert
Empty
Drop
4
InnoDB
latin1_swedish_ci
16.0
KiB
-
doc_verbalmotion
Browse
Structure
Search
Insert
Empty
Drop
4
InnoDB
latin1_swedish_ci
16.0
KiB
-
doc_verbalmotion_dtls
Browse
Structure
Search
Insert
Empty
Drop
7
InnoDB
latin1_swedish_ci
16.0
KiB
-
drivers_profile
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
dvsignatories
Browse
Structure
Search
Insert
Empty
Drop
4
InnoDB
latin1_swedish_ci
16.0
KiB
-
ebplo_violation_dtl_new
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
employee_with_positions
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
enforceaccounting_sec
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
enter_payment_default
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
expense_details
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
expense_type_setup
Browse
Structure
Search
Insert
Empty
Drop
16
InnoDB
utf8_general_ci
16.0
KiB
-
failed_jobs
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_unicode_ci
32.0
KiB
-
fa_account
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
latin1_swedish_ci
16.0
KiB
-
fa_history
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
fa_info
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
fa_ledgercard
Browse
Structure
Search
Insert
Empty
Drop
~116,293
InnoDB
latin1_swedish_ci
25.6
MiB
-
fa_setup
Browse
Structure
Search
Insert
Empty
Drop
76,131
MyISAM
latin1_swedish_ci
20.0
MiB
-
fiscalyear
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
form_name
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
for_setup_check
Browse
Structure
Search
Insert
Empty
Drop
611
InnoDB
latin1_swedish_ci
112.0
KiB
-
fundmap
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
fvc_checklist_setup
Browse
Structure
Search
Insert
Empty
Drop
138
InnoDB
latin1_swedish_ci
16.0
KiB
-
generalsettings
Browse
Structure
Search
Insert
Empty
Drop
3
InnoDB
latin1_swedish_ci
16.0
KiB
-
genset
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
latin1_swedish_ci
16.0
KiB
-
gjv_number
Browse
Structure
Search
Insert
Empty
Drop
1,742
InnoDB
latin1_swedish_ci
448.0
KiB
-
glmigrate
Browse
Structure
Search
Insert
Empty
Drop
303
InnoDB
latin1_swedish_ci
96.0
KiB
-
gso_forms
Browse
Structure
Search
Insert
Empty
Drop
6
InnoDB
latin1_swedish_ci
16.0
KiB
-
gso_signatories
Browse
Structure
Search
Insert
Empty
Drop
11
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_biometric_logs
Browse
Structure
Search
Insert
Empty
Drop
~62,376
InnoDB
latin1_swedish_ci
14.1
MiB
-
hr_db
Browse
Structure
Search
Insert
Empty
Drop
9
InnoDB
latin1_swedish_ci
16.0
KiB
-
hr_emp_attendance
Browse
Structure
Search
Insert
Empty
Drop
18,596
InnoDB
utf8_general_ci
3.0
MiB
-
hr_emp_attendance_jo
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
32.0
KiB
-
hr_tbl_clearance
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
incomestatement_group
Browse
Structure
Search
Insert
Empty
Drop
214
InnoDB
latin1_swedish_ci
80.0
KiB
-
input_tax_records
Browse
Structure
Search
Insert
Empty
Drop
1,363
InnoDB
latin1_swedish_ci
368.0
KiB
-
input_tax_records_copy
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
inventory_main
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
48.0
KiB
-
invoices
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
isgroup_setup
Browse
Structure
Search
Insert
Empty
Drop
48
InnoDB
latin1_swedish_ci
16.0
KiB
-
journal_acctivity_log
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
journal_atc
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
journal_detail
Browse
Structure
Search
Insert
Empty
Drop
~253,709
InnoDB
utf8_general_ci
94.7
MiB
-
journal_detail_log
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
32.0
KiB
-
journal_main
Browse
Structure
Search
Insert
Empty
Drop
~51,318
InnoDB
utf8_general_ci
27.6
MiB
-
journal_main_log
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
journal_main_temp1
Browse
Structure
Search
Insert
Empty
Drop
3,122
InnoDB
utf8_general_ci
1.5
MiB
-
lastcash
Browse
Structure
Search
Insert
Empty
Drop
12
InnoDB
latin1_swedish_ci
48.0
KiB
-
lastcv
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
48.0
KiB
-
lastreconbalance
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
latin1_swedish_ci
16.0
KiB
-
law_appointment
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
law_branh_setup
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
law_cases_entry
Browse
Structure
Search
Insert
Empty
Drop
5
InnoDB
utf8_general_ci
16.0
KiB
-
law_cases_entry_client
Browse
Structure
Search
Insert
Empty
Drop
3
InnoDB
latin1_swedish_ci
16.0
KiB
-
law_cases_entry_law
Browse
Structure
Search
Insert
Empty
Drop
5
InnoDB
utf8_general_ci
16.0
KiB
-
law_case_document
Browse
Structure
Search
Insert
Empty
Drop
13
InnoDB
latin1_swedish_ci
16.0
KiB
-
law_case_meeting
Browse
Structure
Search
Insert
Empty
Drop
7
InnoDB
latin1_swedish_ci
16.0
KiB
-
law_case_type
Browse
Structure
Search
Insert
Empty
Drop
6
InnoDB
utf8_general_ci
16.0
KiB
-
law_client
Browse
Structure
Search
Insert
Empty
Drop
24
MyISAM
utf8_unicode_ci
5.8
KiB
-
law_consultation
Browse
Structure
Search
Insert
Empty
Drop
4
InnoDB
latin1_swedish_ci
16.0
KiB
-
law_court_setup
Browse
Structure
Search
Insert
Empty
Drop
6
InnoDB
latin1_swedish_ci
16.0
KiB
-
law_court_type
Browse
Structure
Search
Insert
Empty
Drop
3
InnoDB
latin1_swedish_ci
16.0
KiB
-
law_document_type
Browse
Structure
Search
Insert
Empty
Drop
13
InnoDB
utf8_general_ci
16.0
KiB
-
law_hearing_schedule
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
law_judge
Browse
Structure
Search
Insert
Empty
Drop
3
MyISAM
utf8_unicode_ci
2.4
KiB
-
law_lawyer
Browse
Structure
Search
Insert
Empty
Drop
5
MyISAM
utf8_unicode_ci
7.8
KiB
-
law_law_setup
Browse
Structure
Search
Insert
Empty
Drop
10
InnoDB
utf8_general_ci
16.0
KiB
-
law_witness
Browse
Structure
Search
Insert
Empty
Drop
7
InnoDB
latin1_swedish_ci
32.0
KiB
-
listofcashadvance
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
majorfund
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
migrated_apv
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
migrated_apv_details
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
mop
Browse
Structure
Search
Insert
Empty
Drop
4
InnoDB
latin1_swedish_ci
16.0
KiB
-
nddrmf
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
office_subcode
Browse
Structure
Search
Insert
Empty
Drop
8
InnoDB
latin1_swedish_ci
16.0
KiB
-
offsetted_trans_record
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
open_dr
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
payee
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
pettycashfund
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
pettycash_replinishment
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
petty_cash_expense_details
Browse
Structure
Search
Insert
Empty
Drop
22
InnoDB
utf8_general_ci
16.0
KiB
-
petty_cash_released
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
petty_cash_request
Browse
Structure
Search
Insert
Empty
Drop
26
InnoDB
utf8_general_ci
16.0
KiB
-
petty_cash_request_details
Browse
Structure
Search
Insert
Empty
Drop
8
InnoDB
utf8_general_ci
16.0
KiB
-
postdated
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
80.0
KiB
-
postinglog
Browse
Structure
Search
Insert
Empty
Drop
15,898
InnoDB
latin1_swedish_ci
1.5
MiB
-
po_offset_payment
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
ppestorage
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
ppetypes
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
ppe_category
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
250 tables
Sum
~628,401
InnoDB
latin1_swedish_ci
203.4 MiB
0 B
Check all
With selected:
Copy table
Show create
Export
Empty
Drop
Analyze table
Check table
Checksum table
Optimize table
Repair table
Add prefix to table
Replace table prefix
Copy table with prefix
Page number:
1
2
>
>>
Print
Data dictionary
Create new table
Table name
Number of columns
mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.