Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: smartschool
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 7 InnoDB utf8_general_ci 48.0 KiB -
chat_messages 17 InnoDB utf8_general_ci 48.0 KiB -
chat_users 12 InnoDB utf8_general_ci 80.0 KiB -
classes 55 InnoDB utf8_general_ci 16.0 KiB -
class_sections 720 InnoDB utf8_general_ci 96.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 93 InnoDB utf8_general_ci 48.0 KiB -
content_for 125 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 1 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 160 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 1 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 ~172,663 InnoDB utf8_general_ci 23.5 MiB -
messages 197 InnoDB utf8_general_ci 240.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 2,648 InnoDB utf8_general_ci 368.0 KiB -
onlineexam_attempts 4,256 InnoDB utf8_general_ci 208.0 KiB -
onlineexam_questions ~142,159 InnoDB utf8_general_ci 14.1 MiB -
onlineexam_students 4,451 InnoDB utf8_general_ci 320.0 KiB -
onlineexam_student_results ~195,659 InnoDB utf8_general_ci 19.5 MiB -
online_admissions 12 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 6,514 InnoDB utf8_general_ci 2.7 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 1,218 InnoDB utf8_general_ci 96.0 KiB -
room_types 0 InnoDB utf8_general_ci 16.0 KiB -
school_houses 16 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 25 InnoDB utf8_general_ci 32.0 KiB -
staff_attendance 281 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 25 InnoDB utf8_general_ci 48.0 KiB -
staff_timeline 2 InnoDB utf8_general_ci 32.0 KiB -
students 541 InnoDB utf8_general_ci 160.0 KiB -
student_applyleave 1 InnoDB utf8_general_ci 16.0 KiB -
student_attendences 2 InnoDB utf8_general_ci 48.0 KiB -
student_doc 1 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 551 InnoDB utf8_general_ci 128.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 145 InnoDB utf8_general_ci 16.0 KiB -
subject_groups 57 InnoDB utf8_general_ci 32.0 KiB -
subject_group_class_sections 46 InnoDB utf8_general_ci 64.0 KiB -
subject_group_subjects 164 InnoDB utf8_general_ci 64.0 KiB -
subject_timetable 37 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 1 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 23,978 InnoDB utf8_general_ci 1.5 MiB -
users 1,082 InnoDB utf8_general_ci 96.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 275 InnoDB utf8_general_ci 64.0 KiB -
visitors_purpose 4 InnoDB utf8_general_ci 16.0 KiB -
147 tables Sum ~560,278 InnoDB utf8mb4_general_ci 66.8 MiB 0 B

Create table
Name:
Number of columns: