Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
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
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Database structure
Choose which details to show in the database structure (list of tables).
Database structure
Documentation Show or hide a column displaying the charset for all tables. Restore default value
Documentation Show or hide a column displaying the comments for all tables. Restore default value
Documentation Show or hide a column displaying the Creation timestamp for all tables. Restore default value
Documentation Show or hide a column displaying the Last update timestamp for all tables. Restore default value
Documentation Show or hide a column displaying the Last check timestamp for all tables. Restore default value
Filters
Table Ascending Descending Action Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11. Type Collation Size Overhead
accessories_senior   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 950 InnoDB utf8mb4_general_ci 32.0 KiB -
active_sessions   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 InnoDB latin1_swedish_ci 64.0 KiB -
cashier   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 InnoDB utf8mb4_general_ci 48.0 KiB -
chat_messages   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 207 InnoDB utf8mb4_general_ci 16.0 KiB -
dbias_sections   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 350 InnoDB utf8mb4_general_ci 32.0 KiB -
dbias_sections_junior   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5 InnoDB utf8mb4_general_ci 16.0 KiB -
dbias_strands   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6 InnoDB utf8mb4_general_ci 32.0 KiB -
dropped_junior   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_general_ci 32.0 KiB -
dropped_students   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 77 InnoDB utf8mb4_general_ci 48.0 KiB -
enrolled_junior   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 16 InnoDB utf8mb4_general_ci 32.0 KiB -
enrolled_students   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 16,315 InnoDB utf8mb4_general_ci 48.0 KiB -
enrolling_junior   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4 InnoDB utf8mb4_general_ci 32.0 KiB -
enrolling_students   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB utf8mb4_general_ci 48.0 KiB -
expenses_audit   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4 InnoDB utf8mb4_general_ci 16.0 KiB -
expense_particulars   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 48 InnoDB utf8mb4_general_ci 32.0 KiB -
expense_photos   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4 InnoDB utf8mb4_general_ci 32.0 KiB -
graduate_senior   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_general_ci 48.0 KiB -
graduation_junior   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB utf8mb4_general_ci 32.0 KiB -
graduation_payments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_general_ci 32.0 KiB -
graduation_payments2   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 11,736 InnoDB utf8mb4_general_ci 32.0 KiB -
graduation_students2   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4,386 InnoDB utf8mb4_general_ci 16.0 KiB -
inventory_items   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 InnoDB utf8mb4_general_ci 16.0 KiB -
inventory_logs   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4 InnoDB utf8mb4_general_ci 32.0 KiB -
junior_subjects   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 InnoDB utf8mb4_general_ci 16.0 KiB -
login_history   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB latin1_swedish_ci 64.0 KiB -
miscellaneous_fees   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_general_ci 16.0 KiB -
miscellaneous_payment_history   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_general_ci 32.0 KiB -
not_graduate_senior   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_general_ci 48.0 KiB -
password_reset_logs   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6 InnoDB utf8mb4_unicode_ci 64.0 KiB -
referrals   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 502 InnoDB utf8mb4_general_ci 32.0 KiB -
referral_claims   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,514 InnoDB utf8mb4_general_ci 16.0 KiB -
registrar   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 16 InnoDB utf8mb4_general_ci 48.0 KiB -
service_invoice_audit   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 10,236 InnoDB utf8mb4_general_ci 32.0 KiB -
strand_subjects   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 279 InnoDB utf8mb4_general_ci 32.0 KiB -
student_allowances   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,299 InnoDB utf8mb4_general_ci 32.0 KiB -
student_miscellaneous   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 InnoDB utf8mb4_general_ci 32.0 KiB -
student_payments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 463 InnoDB utf8mb4_general_ci 32.0 KiB -
student_payments_junior   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 35 InnoDB utf8mb4_general_ci 32.0 KiB -
student_subjects   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 105,496 InnoDB utf8mb4_general_ci 32.0 KiB -
system_logs   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 111 InnoDB latin1_swedish_ci 128.0 KiB -
system_updates   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 16 InnoDB utf8mb4_general_ci 16.0 KiB -
system_update_logs   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB utf8mb4_general_ci 16.0 KiB -
transferred_out   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 45 InnoDB utf8mb4_general_ci 48.0 KiB -
users   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 22 InnoDB utf8mb4_unicode_ci 112.0 KiB -
voided_payments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 48 InnoDB utf8mb4_general_ci 16.0 KiB -
45 tables Sum 154,211 InnoDB utf8mb4_general_ci 1.6 MiB 0 B
With selected:

Data dictionary Data dictionary

Create new table Create new table