Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: dbtest_mis
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress 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 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.
Table AscendingDescending Action Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11. Type Collation Size Overhead
agency_meeting_records 3,732 InnoDB utf8_general_ci 240 KiB -
agenda_wise_decisions 1,177 InnoDB utf8_general_ci 416 KiB -
agenda_wise_decisions2 629 InnoDB utf8_general_ci 272 KiB -
agenda_wise_decisions3 629 InnoDB utf8_general_ci 272 KiB -
agenda_wise_decisions_bk_2018_04_10_10_39am 322 InnoDB utf8_general_ci 160 KiB -
agenda_wise_votings 90 InnoDB utf8_general_ci 16 KiB -
assemblies 41 InnoDB utf8_general_ci 16 KiB -
audits 22,112 InnoDB utf8_general_ci 34.6 MiB -
audit_deltas 9,874 InnoDB utf8_general_ci 6 MiB -
audit_directorates 14 InnoDB utf8_general_ci 16 KiB -
audit_directorate_members 33 InnoDB utf8_general_ci 16 KiB -
audit_objections 252 InnoDB utf8_general_ci 64 KiB -
audit_objection_agencies 7 InnoDB utf8_general_ci 16 KiB -
audit_objection_audit_directorates 252 InnoDB utf8_general_ci 16 KiB -
audit_objection_financials 598 InnoDB utf8_general_ci 144 KiB -
audit_objection_financial_flows 0 InnoDB utf8_general_ci 16 KiB -
audit_objection_ministries 17 InnoDB utf8_general_ci 16 KiB -
audit_objection_multiples 596 InnoDB utf8_general_ci 256 KiB -
bills 56 InnoDB utf8_general_ci 176 KiB -
bill_report_others 124 InnoDB utf8_general_ci 16 KiB -
booking_meeting_places 275 InnoDB utf8_general_ci 16 KiB -
briefing_notes 168 InnoDB utf8_general_ci 1.5 MiB -
cag_infos 2 InnoDB utf8_general_ci 16 KiB -
cag_info_members 7 InnoDB utf8_general_ci 16 KiB -
cag_info_member_meeting_records 456 InnoDB utf8_general_ci 112 KiB -
chairman_speeches 45 InnoDB utf8_general_ci 192 KiB -
cmn_functions 483 InnoDB utf8_general_ci 4.5 MiB -
committee_lists 338 InnoDB utf8_general_ci 64 KiB -
committee_meeting_records 2,498 InnoDB utf8_general_ci 128 KiB -
committee_members_pictures 360 InnoDB utf8_general_ci 48 KiB -
committee_report_indices 148 InnoDB utf8_general_ci 48 KiB -
committee_secretaries 691 InnoDB utf8_general_ci 80 KiB -
designations 0 InnoDB utf8_general_ci 16 KiB -
employees 0 InnoDB utf8_general_ci 16 KiB -
enquiries 305 InnoDB utf8_general_ci 176 KiB -
enquiry_multiples 0 InnoDB utf8_general_ci 16 KiB -
enquiry_officer_orderings 2,745 InnoDB utf8_general_ci 176 KiB -
enquiry_times 302 InnoDB utf8_general_ci 16 KiB -
evidence_informations 155 InnoDB utf8_general_ci 16 KiB -
evidence_information_files 151 InnoDB utf8_general_ci 80 KiB -
evidence_officer_orderings 1,917 InnoDB utf8_general_ci 80 KiB -
evidence_requisitions 213 InnoDB utf8_general_ci 1.5 MiB -
evidence_requisition_agencies 819 InnoDB utf8_general_ci 80 KiB -
evidence_requisition_agency_members 1,780 InnoDB utf8_general_ci 144 KiB -
evidence_requisition_audit_directorates 10 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_audit_directorate_members 10 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_cag_infos 20 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_cag_info_members 20 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_expart_lists 290 InnoDB utf8_general_ci 48 KiB -
evidence_requisition_for_kind_infos 495 InnoDB latin1_swedish_ci 48 KiB -
evidence_requisition_logistic_members 966 InnoDB utf8_general_ci 80 KiB -
evidence_requisition_ministries 204 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_ministry_officers 379 InnoDB utf8_general_ci 64 KiB -
evidence_requisition_parliament_emps 264 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_witnesses 1,086 InnoDB utf8_general_ci 96 KiB -
expart_lists 6 InnoDB utf8_general_ci 16 KiB -
expart_list_enquiries 83 InnoDB utf8_general_ci 16 KiB -
expert_meeting_records 290 InnoDB utf8_general_ci 16 KiB -
fiscal_years 254 InnoDB utf8_general_ci 48 KiB -
for_kind_infos 18 InnoDB utf8_general_ci 16 KiB -
for_kind_info_enquiries 479 InnoDB utf8_general_ci 48 KiB -
for_kind_info_member_meeting_records 1,544 InnoDB utf8_general_ci 128 KiB -
gov_org_infos 85 InnoDB utf8_general_ci 96 KiB -
gov_org_member_lists 175 InnoDB utf8_general_ci 112 KiB -
inquiry_agencies 195 InnoDB utf8_general_ci 16 KiB -
inquiry_agency_members 201 InnoDB utf8_general_ci 48 KiB -
inquiry_audit_directorates 99 InnoDB utf8_general_ci 16 KiB -
inquiry_audit_directorate_members 88 InnoDB utf8_general_ci 16 KiB -
inquiry_cag_infos 93 InnoDB utf8_general_ci 16 KiB -
inquiry_cag_info_members 96 InnoDB utf8_general_ci 16 KiB -
inquiry_ministries 278 InnoDB utf8_general_ci 16 KiB -
inquiry_ministry_officers 334 InnoDB utf8_general_ci 64 KiB -
inquiry_parliament_secretariat_officers 381 InnoDB utf8_general_ci 16 KiB -
inquiry_reports 109 InnoDB utf8_general_ci 384 KiB -
ir_follow_ups 22 InnoDB utf8_general_ci 16 KiB -
ir_recommendations 846 InnoDB utf8_general_ci 368 KiB -
logistics 70 InnoDB utf8_general_ci 288 KiB -
logistics_inquiries 650 InnoDB utf8_general_ci 64 KiB -
logistic_member_lists 72 InnoDB utf8_general_ci 64 KiB -
logistic_member_meeting_records 3,392 InnoDB utf8_general_ci 512 KiB -
maintenance_records 2 InnoDB utf8_general_ci 16 KiB -
media_infos 2 InnoDB utf8_general_ci 16 KiB -
meetings 292 InnoDB utf8_general_ci 96 KiB -
meetings_2018_07_17_0432PM 35 InnoDB utf8_general_ci 16 KiB -
meeting_activities 1,679 InnoDB utf8_general_ci 2.5 MiB -
meeting_activities2 661 InnoDB utf8_general_ci 1.5 MiB -
meeting_activities3 661 InnoDB utf8_general_ci 1.5 MiB -
meeting_adjourn_records 348 InnoDB utf8_general_ci 80 KiB -
meeting_adjourn_records_2018_07_17_0432PM 50 InnoDB utf8_general_ci 16 KiB -
meeting_archives 41 InnoDB utf8_general_ci 16 KiB -
meeting_audit_directorate_members 1,158 InnoDB utf8_general_ci 144 KiB -
meeting_notice_informations 0 InnoDB utf8_general_ci 16 KiB -
meeting_places 11 InnoDB utf8_general_ci 16 KiB -
ministries 40 InnoDB utf8_general_ci 64 KiB -
ministry_officers 116 InnoDB utf8_general_ci 80 KiB -
ministry_officer_meeting_records 493 InnoDB utf8_general_ci 128 KiB -
modules 116 InnoDB utf8_general_ci 16 KiB -
mpsinfos 353 InnoDB utf8_general_ci 432 KiB -
officer_orderings 2,666 InnoDB utf8_general_ci 112 KiB -
parliaments 11 InnoDB utf8_general_ci 16 KiB -
parliament_emps 71 InnoDB utf8_general_ci 64 KiB -
parliament_emp_committees 120 InnoDB utf8_general_ci 16 KiB -
parliament_secretariat_meeting_records 783 InnoDB utf8_general_ci 80 KiB -
parties 11 InnoDB utf8_general_ci 16 KiB -
pcommittees 50 InnoDB utf8_general_ci 64 KiB -
press_releases 83 InnoDB utf8_general_ci 160 KiB -
privileges 1,586 InnoDB utf8_general_ci 128 KiB -
progress_reports 18 InnoDB utf8_general_ci 16 KiB -
recording_decisions 122 InnoDB utf8_general_ci 80 KiB -
recording_decision_agency_members 1,084 InnoDB utf8_general_ci 96 KiB -
recording_decision_audit_directorate_members 316 InnoDB utf8_general_ci 48 KiB -
recording_decision_cag_info_members 148 InnoDB utf8_general_ci 16 KiB -
recording_decision_committee_members 805 InnoDB utf8_general_ci 64 KiB -
recording_decision_experts 74 InnoDB utf8_general_ci 16 KiB -
recording_decision_ministry_officers 179 InnoDB utf8_general_ci 16 KiB -
recording_decision_officer_orderings 976 InnoDB utf8_general_ci 80 KiB -
recording_decision_parliament_emps 238 InnoDB utf8_general_ci 16 KiB -
recording_decision_sub_committee_members 25 InnoDB utf8_general_ci 16 KiB -
recording_decision_witnesses 238 InnoDB utf8_general_ci 16 KiB -
reg_files 339 InnoDB utf8_general_ci 128 KiB -
reg_infos 368 InnoDB utf8_general_ci 160 KiB -
roles 16 InnoDB utf8_general_ci 16 KiB -
secretarial_branches 26 InnoDB utf8_general_ci 16 KiB -
settings 1 InnoDB utf8_general_ci 16 KiB -
sub_committees 23 InnoDB utf8_general_ci 48 KiB -
sub_committee_meeting_records 94 InnoDB utf8_general_ci 16 KiB -
sub_committee_members 77 InnoDB utf8_general_ci 16 KiB -
task_flows 77 InnoDB utf8_general_ci 16 KiB -
task_flow_files 153 InnoDB utf8_general_ci 16 KiB -
task_flow_qas 96 InnoDB utf8_general_ci 96 KiB -
tfq_answers 80 InnoDB utf8_general_ci 192 KiB -
users 40 InnoDB utf8_general_ci 48 KiB -
user_committees 59 InnoDB utf8_general_ci 16 KiB -
user_logins 3,993 InnoDB utf8_general_ci 1.5 MiB -
witnesses 34 InnoDB utf8_general_ci 16 KiB -
witness_enquiries 101 InnoDB utf8_general_ci 16 KiB -
witness_meeting_records 1,040 InnoDB utf8_general_ci 112 KiB -
workflows 3 InnoDB utf8_general_ci 16 KiB -
138 tables Sum 90,299 InnoDB utf8_general_ci 64.8 MiB 0 B

  Create table
Name:
Number of columns: