Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: smartschool222
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).

Documentation Show or hide a column displaying the charset for all tables.
Documentation Show or hide a column displaying the comments for all tables.
Documentation Show or hide a column displaying the Creation timestamp for all tables.
Documentation Show or hide a column displaying the Last update timestamp for all tables.
Documentation Show or hide a column displaying the Last check timestamp for all tables.
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
attendence_type 6 InnoDB utf8_general_ci 16.0 KiB -
books 1,210 InnoDB utf8_general_ci 208.0 KiB -
book_issues 0 InnoDB utf8_general_ci 16.0 KiB -
categories 7 InnoDB utf8_general_ci 16.0 KiB -
certificates 1 InnoDB utf8_general_ci 16.0 KiB -
chat_connections 2 InnoDB utf8_general_ci 48.0 KiB -
chat_messages 5 InnoDB utf8_general_ci 48.0 KiB -
chat_users 4 InnoDB utf8_general_ci 80.0 KiB -
classes 42 InnoDB utf8_general_ci 16.0 KiB -
class_sections 568 InnoDB utf8_general_ci 80.0 KiB -
class_teacher 14 InnoDB utf8_general_ci 16.0 KiB -
complaint 0 InnoDB utf8_general_ci 16.0 KiB -
complaint_type 3 InnoDB utf8_general_ci 16.0 KiB -
contents 128 InnoDB utf8_general_ci 64.0 KiB -
content_for 146 InnoDB utf8_general_ci 48.0 KiB -
custom_fields 0 InnoDB utf8_general_ci 16.0 KiB -
custom_field_values 0 InnoDB utf8_general_ci 32.0 KiB -
department 6 InnoDB utf8_general_ci 16.0 KiB -
disable_reason 2 InnoDB utf8_general_ci 16.0 KiB -
dispatch_receive 0 InnoDB utf8_general_ci 16.0 KiB -
email_config 1 InnoDB utf8_general_ci 16.0 KiB -
enquiry 0 InnoDB utf8_general_ci 16.0 KiB -
enquiry_type 0 InnoDB utf8_general_ci 16.0 KiB -
events 10 InnoDB utf8_general_ci 16.0 KiB -
exams 0 InnoDB utf8_general_ci 16.0 KiB -
exam_groups 1 InnoDB utf8_general_ci 16.0 KiB -
exam_group_class_batch_exams 1 InnoDB utf8_general_ci 32.0 KiB -
exam_group_class_batch_exam_students 0 InnoDB utf8_general_ci 64.0 KiB -
exam_group_class_batch_exam_subjects 1 InnoDB utf8_general_ci 48.0 KiB -
exam_group_exam_connections 0 InnoDB utf8_general_ci 48.0 KiB -
exam_group_exam_results 0 InnoDB utf8_general_ci 64.0 KiB -
exam_group_students 0 InnoDB utf8_general_ci 48.0 KiB -
exam_results 0 InnoDB utf8_general_ci 48.0 KiB -
exam_schedules 0 InnoDB utf8_general_ci 32.0 KiB -
expenses 0 InnoDB utf8_general_ci 16.0 KiB -
expense_head 0 InnoDB utf8_general_ci 16.0 KiB -
feecategory 0 InnoDB utf8_general_ci 16.0 KiB -
feemasters 0 InnoDB utf8_general_ci 16.0 KiB -
fees_discounts 0 InnoDB utf8_general_ci 32.0 KiB -
fees_reminder 4 InnoDB utf8_general_ci 16.0 KiB -
feetype 314 InnoDB utf8_general_ci 80.0 KiB -
fee_groups 42 InnoDB utf8_general_ci 16.0 KiB -
fee_groups_feetype 105 InnoDB utf8_general_ci 80.0 KiB -
fee_receipt_no 0 InnoDB utf8_general_ci 16.0 KiB -
fee_session_groups 12 InnoDB utf8_general_ci 48.0 KiB -
follow_up 0 InnoDB utf8_general_ci 16.0 KiB -
front_cms_media_gallery 5 InnoDB utf8_general_ci 16.0 KiB -
front_cms_menus 2 InnoDB utf8_general_ci 16.0 KiB -
front_cms_menu_items 4 InnoDB utf8_general_ci 16.0 KiB -
front_cms_pages 4 InnoDB utf8_general_ci 16.0 KiB -
front_cms_page_contents 0 InnoDB utf8_general_ci 32.0 KiB -
front_cms_programs 1 InnoDB utf8_general_ci 16.0 KiB -
front_cms_program_photos 3 InnoDB utf8_general_ci 32.0 KiB -
front_cms_settings 1 InnoDB utf8_general_ci 16.0 KiB -
general_calls 0 InnoDB utf8_general_ci 16.0 KiB -
grades 5 InnoDB utf8_general_ci 16.0 KiB -
homework 0 InnoDB utf8_general_ci 32.0 KiB -
homework_evaluation 0 InnoDB utf8_general_ci 16.0 KiB -
hostel 0 InnoDB utf8_general_ci 16.0 KiB -
hostel_rooms 0 InnoDB utf8_general_ci 16.0 KiB -
id_card 0 InnoDB utf8_general_ci 16.0 KiB -
income 0 InnoDB utf8_general_ci 16.0 KiB -
income_head 0 InnoDB utf8_general_ci 16.0 KiB -
item 0 InnoDB utf8_general_ci 16.0 KiB -
item_category 4 InnoDB utf8_general_ci 16.0 KiB -
item_issue 0 InnoDB utf8_general_ci 48.0 KiB -
item_stock 0 InnoDB utf8_general_ci 64.0 KiB -
item_store 0 InnoDB utf8_general_ci 16.0 KiB -
item_supplier 0 InnoDB utf8_general_ci 16.0 KiB -
languages 73 InnoDB utf8_general_ci 16.0 KiB -
leave_types 0 InnoDB utf8_general_ci 32.0 KiB -
libarary_members 0 InnoDB utf8_general_ci 16.0 KiB -
logs 4,032 InnoDB utf8_general_ci 528.0 KiB -
messages 51 InnoDB utf8_general_ci 144.0 KiB -
migrations 0 InnoDB utf8_general_ci 16.0 KiB -
multi_class_students 0 InnoDB utf8_general_ci 48.0 KiB -
notification_roles 0 InnoDB utf8_general_ci 48.0 KiB -
notification_setting 7 InnoDB utf8_general_ci 16.0 KiB -
onlineexam 0 InnoDB utf8_general_ci 32.0 KiB -
onlineexam_attempts 0 InnoDB utf8_general_ci 32.0 KiB -
onlineexam_questions 0 InnoDB utf8_general_ci 64.0 KiB -
onlineexam_students 0 InnoDB utf8_general_ci 48.0 KiB -
onlineexam_student_results 0 InnoDB utf8_general_ci 48.0 KiB -
online_admissions 0 InnoDB utf8_general_ci 32.0 KiB -
payment_settings 7 InnoDB utf8_general_ci 16.0 KiB -
payslip_allowance 0 InnoDB utf8_general_ci 16.0 KiB -
permission_category 185 InnoDB utf8_general_ci 16.0 KiB -
permission_group 26 InnoDB utf8_general_ci 16.0 KiB -
permission_parent 12 InnoDB utf8_general_ci 16.0 KiB -
permission_student 15 InnoDB utf8_general_ci 16.0 KiB -
print_headerfooter 2 InnoDB utf8_general_ci 16.0 KiB -
questions 2,267 InnoDB utf8_general_ci 1.6 MiB -
question_answers 0 InnoDB utf8_general_ci 16.0 KiB -
question_options 0 InnoDB utf8_general_ci 16.0 KiB -
read_notification 0 InnoDB utf8_general_ci 16.0 KiB -
reference 1 InnoDB utf8_general_ci 16.0 KiB -
roles 17 InnoDB utf8_general_ci 16.0 KiB -
roles_permissions 735 InnoDB utf8_general_ci 64.0 KiB -
room_types 0 InnoDB utf8_general_ci 16.0 KiB -
school_houses 0 InnoDB utf8_general_ci 16.0 KiB -
sch_settings 1 InnoDB utf8_general_ci 48.0 KiB -
sections 16 InnoDB utf8_general_ci 16.0 KiB -
send_notification 0 InnoDB utf8_general_ci 16.0 KiB -
sessions 14 InnoDB utf8_general_ci 16.0 KiB -
sms_config 0 InnoDB utf8_general_ci 16.0 KiB -
source 2 InnoDB utf8_general_ci 16.0 KiB -
staff 20 InnoDB utf8_general_ci 32.0 KiB -
staff_attendance 217 InnoDB utf8_general_ci 48.0 KiB -
staff_attendance_type 5 InnoDB utf8_general_ci 16.0 KiB -
staff_designation 16 InnoDB utf8_general_ci 16.0 KiB -
staff_leave_details 0 InnoDB utf8_general_ci 48.0 KiB -
staff_leave_request 0 InnoDB utf8_general_ci 48.0 KiB -
staff_payroll 0 InnoDB utf8_general_ci 16.0 KiB -
staff_payslip 0 InnoDB utf8_general_ci 32.0 KiB -
staff_rating 0 InnoDB utf8_general_ci 32.0 KiB -
staff_roles 20 InnoDB utf8_general_ci 48.0 KiB -
staff_timeline 2 InnoDB utf8_general_ci 32.0 KiB -
students 44 InnoDB utf8_general_ci 16.0 KiB -
student_applyleave 1 InnoDB utf8_general_ci 16.0 KiB -
student_attendences 0 InnoDB utf8_general_ci 48.0 KiB -
student_doc 0 InnoDB utf8_general_ci 16.0 KiB -
student_fees 0 InnoDB utf8_general_ci 16.0 KiB -
student_fees_deposite 0 InnoDB utf8_general_ci 48.0 KiB -
student_fees_discounts 0 InnoDB utf8_general_ci 48.0 KiB -
student_fees_master 13 InnoDB utf8_general_ci 48.0 KiB -
student_session 44 InnoDB utf8_general_ci 80.0 KiB -
student_sibling 0 InnoDB utf8_general_ci 16.0 KiB -
student_subject_attendances 0 InnoDB utf8_general_ci 64.0 KiB -
student_timeline 0 InnoDB utf8_general_ci 16.0 KiB -
subjects 113 InnoDB utf8_general_ci 16.0 KiB -
subject_groups 52 InnoDB utf8_general_ci 32.0 KiB -
subject_group_class_sections 40 InnoDB utf8_general_ci 64.0 KiB -
subject_group_subjects 156 InnoDB utf8_general_ci 64.0 KiB -
subject_timetable 5 InnoDB utf8_general_ci 112.0 KiB -
submit_assignment 0 InnoDB utf8_general_ci 16.0 KiB -
teacher_subjects 0 InnoDB utf8_general_ci 80.0 KiB -
template_admitcards 0 InnoDB utf8_general_ci 16.0 KiB -
template_marksheets 0 InnoDB utf8_general_ci 16.0 KiB -
timetables 0 InnoDB utf8_general_ci 16.0 KiB -
transport_route 0 InnoDB utf8_general_ci 16.0 KiB -
userlog 347 InnoDB utf8_general_ci 64.0 KiB -
users 88 InnoDB utf8_general_ci 16.0 KiB -
users_authentication 0 InnoDB utf8_general_ci 16.0 KiB -
vehicles 0 InnoDB utf8_general_ci 16.0 KiB -
vehicle_routes 0 InnoDB utf8_general_ci 16.0 KiB -
visitors_book 0 InnoDB utf8_general_ci 16.0 KiB -
visitors_purpose 2 InnoDB utf8_general_ci 16.0 KiB -
147 tables Sum 11,312 InnoDB utf8mb4_general_ci 6.5 MiB 0 B

Create table
Name:
Number of columns: