Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: smartschool3
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 42 InnoDB utf8_general_ci 16.0 KiB -
class_sections 556 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 115 InnoDB utf8_general_ci 48.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 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 ~162,860 InnoDB utf8_general_ci 22.5 MiB -
messages 196 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 1,916 InnoDB utf8_general_ci 320.0 KiB -
onlineexam_attempts 3,227 InnoDB utf8_general_ci 240.0 KiB -
onlineexam_questions ~140,145 InnoDB utf8_general_ci 13.1 MiB -
onlineexam_students 3,317 InnoDB utf8_general_ci 320.0 KiB -
onlineexam_student_results ~197,843 InnoDB utf8_general_ci 20.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 380 InnoDB utf8_general_ci 144.0 KiB -
student_applyleave 1 InnoDB utf8_general_ci 16.0 KiB -
student_attendences 2 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 390 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 10,100 InnoDB utf8_general_ci 1.5 MiB -
141 tables Sum ~532,053 InnoDB utf8mb4_general_ci 65.6 MiB 0 B

Create table
Name:
Number of columns: