Recent
`sgm_crm`.`items`
`sgm_crm`.`items_tax_hsn_sac`
`rajkamal_crm`.`items_opening_stock`
`sgm_crm`.`ledger_details`
`surena_crm`.`subsidy_scheme_application_form`
`payitsea_jnablr`.`z_mobile_online_oem_recent_omr`
`payitsea_jnablr`.`z_mobile_live_class_hosts`
`payitsea_jnablr`.`sb_ca_accounts_fee_master`
`payitsea_jnablr`.`z_mobile_online_fixed_fee`
`payitsea_jnablr`.`z_mobile_help`
Favourites
There are no favourite tables.
New
information_schema
mysql
payitsea_jnablr
performance_schema
phpmyadmin
rajkamal_crm
sgm_crm
surena
surena_code_editor
surena_crm
edbroad
surena_edbroad_1
surena_edbroad_old
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customise 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.
Favourite tables
Maximum number of favourite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customise 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
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: payitsea_jnablr
Structure
(current)
SQL
Search
Query
Export
Import
Operations
Privileges
Routines
Events
Triggers
Tracking
Designer
Central columns
Console
Clear
History
Options
Bookmarks
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 :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Label:
Target database:
Share this bookmark
OK
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
Bookmark
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
a01_set_locations
Browse
Structure
Search
Insert
Empty
Drop
10
InnoDB
latin1_swedish_ci
16.0
KiB
-
a01_set_school_code
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
latin1_swedish_ci
32.0
KiB
-
a01_set_school_info
Browse
Structure
Search
Insert
Empty
Drop
5
InnoDB
latin1_swedish_ci
16.0
KiB
-
a02_set_academic_year
Browse
Structure
Search
Insert
Empty
Drop
24
InnoDB
latin1_swedish_ci
16.0
KiB
-
a03_set_institutiontype
Browse
Structure
Search
Insert
Empty
Drop
48
InnoDB
latin1_swedish_ci
32.0
KiB
-
a04_set_course_group
Browse
Structure
Search
Insert
Empty
Drop
144
InnoDB
latin1_swedish_ci
32.0
KiB
-
a05_set_course_r_batch
Browse
Structure
Search
Insert
Empty
Drop
1,692
InnoDB
latin1_swedish_ci
528.0
KiB
-
a06_set_course_section
Browse
Structure
Search
Insert
Empty
Drop
6,666
InnoDB
latin1_swedish_ci
560.0
KiB
-
a07_set_course_r_batch_start_date
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
a07_set_header_group
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
a08_set_header
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
a09_set_lang_compit_list
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
a09_set_templates
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
a10_set_template_module
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
a11_set_ltnwise_assign_template
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
a12_set_ltnwise_asign_exam_grp
Browse
Structure
Search
Insert
Empty
Drop
49
InnoDB
latin1_swedish_ci
64.0
KiB
-
a13_set_ltnwise_asign_course_sec_grp
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
48.0
KiB
-
a14_set_ltnwise_asign_header
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
64.0
KiB
-
a15_set_ltnwise_asign_exam_grade_grp
Browse
Structure
Search
Insert
Empty
Drop
56
InnoDB
latin1_swedish_ci
48.0
KiB
-
a15_set_ltnwise_asign_exam_grade_grp_part_b
Browse
Structure
Search
Insert
Empty
Drop
56
InnoDB
latin1_swedish_ci
64.0
KiB
-
a16_set_ltnwise_asign_fee_grp
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
a17_set_ltnwise_remove_mob_menu
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
a18_set_ltnwise_asign_school_info
Browse
Structure
Search
Insert
Empty
Drop
69
InnoDB
latin1_swedish_ci
64.0
KiB
-
aa01_payroll_shift
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
aa01_payroll_shift_cron
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
aa02_payroll_shift_details
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
aa03_payroll_shift_halfday_value
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
aa04_payroll_salary_group
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
aa05_payroll_salary_group_earnings
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
aa06_payroll_salary_group_earnings_value
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
aa07_payroll_salary_group_deductions
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
aa08_payroll_salary_group_deductions_value
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
aa09_payroll_salary_group_tax
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
aa10_payroll_salary_group_tax_value
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
aa11_payroll_salary_advance
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
aa12_payroll_basic_salary
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
aa13_payroll_public_holidays
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
aa14_payroll_leave_types
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
aa15_payroll_assign_shifts
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
aa16_payroll_emp_leave_details
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
aa17_payroll_date_settings
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
aa18_payroll_weekends
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
aa19_payroll_report_formats
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
add_new_occupation
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
app_settings
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
latin1_swedish_ci
16.0
KiB
-
attendancelog
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
attendancelog_bck
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
attendance_login_details
Browse
Structure
Search
Insert
Empty
Drop
0
MyISAM
latin1_swedish_ci
1.0
KiB
-
attendance_logout_details
Browse
Structure
Search
Insert
Empty
Drop
0
MyISAM
latin1_swedish_ci
1.0
KiB
-
b01_set_exam_parta_group
Browse
Structure
Search
Insert
Empty
Drop
6
InnoDB
latin1_swedish_ci
16.0
KiB
-
b01_set_exam_parta_terms
Browse
Structure
Search
Insert
Empty
Drop
12
InnoDB
latin1_swedish_ci
32.0
KiB
-
b02_set_exam_parta_mainactivity
Browse
Structure
Search
Insert
Empty
Drop
48
InnoDB
latin1_swedish_ci
32.0
KiB
-
b03_set_exam_parta_mainsubject
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
b04_set_exam_parta_coresubject
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
b05_set_exam_parta_subactivity
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
b06_set_exam_partbcd_type
Browse
Structure
Search
Insert
Empty
Drop
24
InnoDB
latin1_swedish_ci
32.0
KiB
-
b07_set_exam_partb_subjects
Browse
Structure
Search
Insert
Empty
Drop
101
InnoDB
latin1_swedish_ci
32.0
KiB
-
b08_set_exam_partbcd_activity
Browse
Structure
Search
Insert
Empty
Drop
101
InnoDB
latin1_swedish_ci
32.0
KiB
-
b09_set_exam_grade_method
Browse
Structure
Search
Insert
Empty
Drop
3
InnoDB
latin1_swedish_ci
16.0
KiB
-
b09_set_exam_grade_method_part_b
Browse
Structure
Search
Insert
Empty
Drop
3
InnoDB
latin1_swedish_ci
16.0
KiB
-
b09_set_exam_grade_method_view
Browse
Structure
Search
Insert
Empty
Drop
0
MyISAM
latin1_swedish_ci
1.0
KiB
-
b10_set_exam_grade_details
Browse
Structure
Search
Insert
Empty
Drop
19
InnoDB
latin1_swedish_ci
32.0
KiB
-
b10_set_exam_grade_details_part_b
Browse
Structure
Search
Insert
Empty
Drop
9
InnoDB
latin1_swedish_ci
32.0
KiB
-
b10_set_exam_grade_details_view
Browse
Structure
Search
Insert
Empty
Drop
0
MyISAM
latin1_swedish_ci
1.0
KiB
-
b11_set_compit_exam_master
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
b12_set_class_timetable_subject
Browse
Structure
Search
Insert
Empty
Drop
34
InnoDB
latin1_swedish_ci
16.0
KiB
-
b12_set_timetable_exams
Browse
Structure
Search
Insert
Empty
Drop
5
InnoDB
latin1_swedish_ci
48.0
KiB
-
b12_set_timetable_exam_details
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
64.0
KiB
-
b12_set_timetable_exam_subject
Browse
Structure
Search
Insert
Empty
Drop
23
InnoDB
latin1_swedish_ci
16.0
KiB
-
b12_set_timetable_notes
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
c01_aca_student_abstract_certificate
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
c01_aca_student_basic_details
Browse
Structure
Search
Insert
Empty
Drop
1,424
InnoDB
latin1_swedish_ci
1.8
MiB
-
c01_aca_student_study_certificate
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
c01_aca_student_transfer_certificate
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
c02_aca_student_other_details
Browse
Structure
Search
Insert
Empty
Drop
1,788
InnoDB
latin1_swedish_ci
416.0
KiB
-
c03_aca_student_custom_details
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
c05_aca_student_attendance_device
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
c06_aca_student_attendance
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
c06_aca_student_attendance_settings
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
c07_aca_student_apply_leave
Browse
Structure
Search
Insert
Empty
Drop
82
InnoDB
latin1_swedish_ci
16.0
KiB
-
c08_aca_student_attendance_verify
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
c08_attendance_verify_calendar_employee
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
c08_attendance_verify_calendar_student
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
latin1_swedish_ci
16.0
KiB
-
c10_aca_student_application
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
c10_aca_student_application_online
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
c10_aca_student_application_online_payment_details
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
c11_aca_student_application_fee
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
c12_aca_main_events
Browse
Structure
Search
Insert
Empty
Drop
4
InnoDB
latin1_swedish_ci
16.0
KiB
-
c12_aca_sub_events
Browse
Structure
Search
Insert
Empty
Drop
3
InnoDB
latin1_swedish_ci
32.0
KiB
-
c13_aca_homework
Browse
Structure
Search
Insert
Empty
Drop
9
InnoDB
latin1_swedish_ci
32.0
KiB
-
c13_aca_homework_chapters
Browse
Structure
Search
Insert
Empty
Drop
2,630
InnoDB
latin1_swedish_ci
272.0
KiB
-
c13_aca_homework_done_students
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
c13_aca_homework_subject
Browse
Structure
Search
Insert
Empty
Drop
1,518
InnoDB
latin1_swedish_ci
112.0
KiB
-
c14_aca_gallery_album
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
c14_aca_homework_merged_pdf
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
c14_aca_photo_gallery
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
c14_aca_video_gallery
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
c14_aca_video_gallery_youtube
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
c15_aca_circular
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
c16_aca_public_holidays
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
d01_exam_parta_marks_entry
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
d02_exam_partbcd_marks_entry
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
d03_exam_parta_absentees
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
48.0
KiB
-
d04_exam_partb_absentees
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
48.0
KiB
-
d05_exam_health_status
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
d05_exam_remarks_entry
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
d05_marks_entry_history
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
d05_student_achivements_entry
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
64.0
KiB
-
d05_student_achivement_levels
Browse
Structure
Search
Insert
Empty
Drop
3
InnoDB
latin1_swedish_ci
16.0
KiB
-
d05_student_achivement_place
Browse
Structure
Search
Insert
Empty
Drop
3
InnoDB
latin1_swedish_ci
16.0
KiB
-
d05_student_achivement_portfolio
Browse
Structure
Search
Insert
Empty
Drop
19
InnoDB
latin1_swedish_ci
16.0
KiB
-
d05_student_remarks_category
Browse
Structure
Search
Insert
Empty
Drop
9
InnoDB
latin1_swedish_ci
16.0
KiB
-
d05_student_remarks_entry
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
48.0
KiB
-
d06_exam_attendance_entry
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
da8_co_scholastic_subjects
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
da8_exam_group
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
da8_exam_type
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
da8_scholastic_subjects
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
devices
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e01_set_online_fee_group
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e02_set_fee_feecategory
Browse
Structure
Search
Insert
Empty
Drop
13
InnoDB
latin1_swedish_ci
16.0
KiB
-
e02_set_online_fee_mainfee
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e03_set_online_fee_payout_accounts
Browse
Structure
Search
Insert
Empty
Drop
4
InnoDB
latin1_swedish_ci
16.0
KiB
-
e03_set_online_fee_payout_splitdetails
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e03_set_online_fee_subfee
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e04_set_online_fee_feecategory
Browse
Structure
Search
Insert
Empty
Drop
13
InnoDB
latin1_swedish_ci
16.0
KiB
-
e05_set_fee_monthly_fee
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e06_set_fee_months
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e07_set_fee_monthlyfee_master
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e08_set_fee_hostelfee
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e08_set_fee_hostel_min_day_calc
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e09_set_fee_hostelfee_master
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e10_assign_hostel_to_students
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e10_set_hostel_master
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e10_set_online_fee_hostelfee_std_allot
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e11_set_fee_individual_fee
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e13_set_fee_individual_fee_assign_class
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e13_set_hostel_fee_assign_class
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e13_set_monthly_fee_assign_class
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e13_set_online_fee_assign_feeto_class
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e14_set_fee_individaul_fee_std_allot
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e15_set_online_fee_transport_group
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e16_set_fee_transport_min_day_calc
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e17_set_fee_transport_months
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e18_set_online_fee_transport_area
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e19_set_online_fee_transport_area_amount
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e20_set_online_fee_transport_assign_student
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e21_fee_transcations
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
e22_fee_concession
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
f01_set_aca_bloodgroup
Browse
Structure
Search
Insert
Empty
Drop
9
InnoDB
latin1_swedish_ci
16.0
KiB
-
f02_set_aca_gender
Browse
Structure
Search
Insert
Empty
Drop
8
InnoDB
latin1_swedish_ci
16.0
KiB
-
f03_set_aca_caste
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
f04_set_aca_sub_caste
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
f05_set_aca_caste_category
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
f07_set_aca_oldnew
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
f08_set_aca_nationality
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
f09_set_aca_religion
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
f10_set_aca_attendance_sessions
Browse
Structure
Search
Insert
Empty
Drop
3,920
InnoDB
latin1_swedish_ci
240.0
KiB
-
f10_set_aca_attendance_value
Browse
Structure
Search
Insert
Empty
Drop
5
InnoDB
latin1_swedish_ci
16.0
KiB
-
f11_set_aca_attendance_data_fetch_type
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
f12_set_aca_mobile_app_type
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
f12_set_aca_mobile_menu
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
f13_set_aca_set_mobile_assign_menu
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
g01_set_emp_category
Browse
Structure
Search
Insert
Empty
Drop
6
InnoDB
latin1_swedish_ci
16.0
KiB
-
g02_set_emp_position
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
g03_set_emp_department
Browse
Structure
Search
Insert
Empty
Drop
16
InnoDB
latin1_swedish_ci
16.0
KiB
-
h01_emp_basic_details
Browse
Structure
Search
Insert
Empty
Drop
80
InnoDB
latin1_swedish_ci
64.0
KiB
-
h01_emp_documnet_details
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
h01_emp_language_details
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
h02_emp_batch_sec_permition
Browse
Structure
Search
Insert
Empty
Drop
56
InnoDB
latin1_swedish_ci
64.0
KiB
-
h02_emp_office_details
Browse
Structure
Search
Insert
Empty
Drop
19
InnoDB
latin1_swedish_ci
16.0
KiB
-
h03_emp_attendance
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
h04_emp_attendance_sessions
Browse
Structure
Search
Insert
Empty
Drop
210
InnoDB
latin1_swedish_ci
16.0
KiB
-
h05_emp_attendance_verify
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
h06_aca_emp_apply_leave
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
h06_emp_apply_leave
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
i01_set_payroll_emp_lop_wdays
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
i02_set_payroll_leave_types
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
i03_set_payroll_calc_settings
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
i04_set_payroll_salary_category
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
i05_set_payroll_salary_components
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
i06_set_payroll_gross_salary
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
j01_set_sms_category
Browse
Structure
Search
Insert
Empty
Drop
6
InnoDB
latin1_swedish_ci
16.0
KiB
-
j02_set_sms_category_message
Browse
Structure
Search
Insert
Empty
Drop
21
InnoDB
latin1_swedish_ci
16.0
KiB
-
j03_set_sms_sender_id
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
j04_set_sms_gateway
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
j04_set_sms_menu_list
Browse
Structure
Search
Insert
Empty
Drop
9
InnoDB
latin1_swedish_ci
16.0
KiB
-
k01_send_sms_details
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
k01_send_sms_details_individual
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
utf8_general_ci
16.0
KiB
-
k01_sms_delivery_status
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
m01_set_omr_1-10
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
m01_set_omr_2-10
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
m02_set_omr_11-15
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
m03_set_omr_16-20
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
main_menu
Browse
Structure
Search
Insert
Empty
Drop
13
InnoDB
latin1_swedish_ci
16.0
KiB
-
mandatory_field_settings
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
mobile_menu_permission
Browse
Structure
Search
Insert
Empty
Drop
0
MyISAM
latin1_swedish_ci
1.0
KiB
-
mobile_menu_user_permission
Browse
Structure
Search
Insert
Empty
Drop
0
MyISAM
latin1_swedish_ci
1.0
KiB
-
omr_omrsms
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
latin1_swedish_ci
16.0
KiB
-
opay_upi_response
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
otp_verify
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
parent_menu
Browse
Structure
Search
Insert
Empty
Drop
142
InnoDB
latin1_swedish_ci
32.0
KiB
-
pdf_list
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
report_login
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
report_user_login
Browse
Structure
Search
Insert
Empty
Drop
8
InnoDB
latin1_swedish_ci
16.0
KiB
-
sample_table
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
sb_ca_academics_classinfo
Browse
Structure
Search
Insert
Empty
Drop
261
InnoDB
latin1_swedish_ci
64.0
KiB
-
sb_ca_accounts_fee_master
Browse
Structure
Search
Insert
Empty
Drop
35
InnoDB
latin1_swedish_ci
16.0
KiB
-
sb_ca_accounts_hostel_transport_receiptformat
Browse
Structure
Search
Insert
Empty
Drop
50
InnoDB
latin1_swedish_ci
16.0
KiB
-
sb_ca_account_feetransaction_receipt
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
sb_ca_class_schoolname
Browse
Structure
Search
Insert
Empty
Drop
84
InnoDB
latin1_swedish_ci
160.0
KiB
-
sb_ca_settings_syllabusmaster
Browse
Structure
Search
Insert
Empty
Drop
3
InnoDB
latin1_swedish_ci
16.0
KiB
-
send_sms_status_record
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
sms_history
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
sub_menu
Browse
Structure
Search
Insert
Empty
Drop
38
InnoDB
latin1_swedish_ci
32.0
KiB
-
tally
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
user_menu_permission
Browse
Structure
Search
Insert
Empty
Drop
18
InnoDB
latin1_swedish_ci
16.0
KiB
-
user_role
Browse
Structure
Search
Insert
Empty
Drop
7
InnoDB
latin1_swedish_ci
16.0
KiB
-
user_role_permission
Browse
Structure
Search
Insert
Empty
Drop
19
InnoDB
latin1_swedish_ci
16.0
KiB
-
whatsapp_history
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
y01_eclass_category
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
y01_eclass_class
Browse
Structure
Search
Insert
Empty
Drop
71
InnoDB
latin1_swedish_ci
32.0
KiB
-
y01_eclass_subject
Browse
Structure
Search
Insert
Empty
Drop
756
InnoDB
latin1_swedish_ci
112.0
KiB
-
y02_eclass_chapters
Browse
Structure
Search
Insert
Empty
Drop
1,384
InnoDB
latin1_swedish_ci
224.0
KiB
-
y03_eclass_chapters_video
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
y03_eclass_chapters_video_youtube
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
y04_eclass_chapters_notes
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
y05_eclass_chapters_textbook
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
32.0
KiB
-
y11_eclass_test_questions
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
y12_eclass_test_choices
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
zoomtoken
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
zoom_credentials
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
zoom_credentials_web
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
z_dashboard_flashcard_wishes
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
z_mobile_aboutus
Browse
Structure
Search
Insert
Empty
Drop
1
InnoDB
latin1_swedish_ci
16.0
KiB
-
z_mobile_app_feedback
Browse
Structure
Search
Insert
Empty
Drop
8
MyISAM
latin1_swedish_ci
2.6
KiB
-
z_mobile_class_timetable
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
z_mobile_class_timetable_periods
Browse
Structure
Search
Insert
Empty
Drop
11
InnoDB
latin1_swedish_ci
16.0
KiB
-
z_mobile_class_timetable_update
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
z_mobile_eclass_menu_permission
Browse
Structure
Search
Insert
Empty
Drop
26
InnoDB
latin1_swedish_ci
16.0
KiB
-
z_mobile_emp_basic_details
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
z_mobile_emp_submenu_permission
Browse
Structure
Search
Insert
Empty
Drop
5
InnoDB
latin1_swedish_ci
16.0
KiB
-
z_mobile_exam_category
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
z_mobile_exam_result
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
z_mobile_fee_agreegator
Browse
Structure
Search
Insert
Empty
Drop
6
InnoDB
latin1_swedish_ci
16.0
KiB
-
z_mobile_fee_cal_conyenacefee
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
z_mobile_fee_ccavenue_payment_details
Browse
Structure
Search
Insert
Empty
Drop
48
InnoDB
latin1_swedish_ci
16.0
KiB
-
z_mobile_fee_transcations
Browse
Structure
Search
Insert
Empty
Drop
2
InnoDB
latin1_swedish_ci
32.0
KiB
-
z_mobile_fee_transcations_sessions1
Browse
Structure
Search
Insert
Empty
Drop
50
InnoDB
latin1_swedish_ci
16.0
KiB
-
z_mobile_fee_transcations_settlement
Browse
Structure
Search
Insert
Empty
Drop
0
InnoDB
latin1_swedish_ci
16.0
KiB
-
250 tables
Sum
24,155
InnoDB
utf8mb4_unicode_ci
9.1 MiB
0 B
Check all
With selected:
Copy table
Show create
Export
Empty
Drop
Analyse table
Check table
Checksum table
Optimise table
Repair table
Add prefix to table
Replace table prefix
Copy table with prefix
Add columns to central list
Remove columns from central list
Make consistent with central list
Are you sure?
This action may change some of the columns definition.
Are you sure you want to continue?
Page number:
1
2
>
>>
Print
Data dictionary
Create new table
Table name
Number of columns