Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: dbtest_mis_2
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 44 InnoDB utf8_general_ci 80 KiB -
agenda_wise_decisions 843 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 0 InnoDB utf8_general_ci 16 KiB -
assemblies 39 InnoDB utf8_general_ci 16 KiB -
audits 5,124 InnoDB utf8_general_ci 23.5 MiB -
audit_deltas 4,514 InnoDB utf8_general_ci 4.9 MiB -
audit_directorates 14 InnoDB utf8_general_ci 16 KiB -
audit_directorate_members 33 InnoDB utf8_general_ci 16 KiB -
audit_objections 250 InnoDB utf8_general_ci 64 KiB -
audit_objection_agencies 7 InnoDB utf8_general_ci 16 KiB -
audit_objection_audit_directorates 250 InnoDB utf8_general_ci 16 KiB -
audit_objection_financials 593 InnoDB utf8_general_ci 144 KiB -
audit_objection_financial_flows 0 InnoDB utf8_general_ci 16 KiB -
audit_objection_ministries 15 InnoDB utf8_general_ci 16 KiB -
audit_objection_multiples 591 InnoDB utf8_general_ci 256 KiB -
bills 1 InnoDB utf8_general_ci 16 KiB -
bill_report_others 30 InnoDB utf8_general_ci 16 KiB -
booking_meeting_places 54 InnoDB utf8_general_ci 16 KiB -
briefing_notes 40 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 129 InnoDB utf8_general_ci 96 KiB -
chairman_speeches 3 InnoDB utf8_general_ci 32 KiB -
cmn_functions 175 InnoDB utf8_general_ci 4.5 MiB -
committee_lists 385 InnoDB utf8_general_ci 64 KiB -
committee_meeting_records 760 InnoDB utf8_general_ci 80 KiB -
committee_members_pictures 30 InnoDB utf8_general_ci 16 KiB -
committee_report_indices 19 InnoDB utf8_general_ci 16 KiB -
committee_secretaries 176 InnoDB utf8_general_ci 16 KiB -
designations 0 InnoDB utf8_general_ci 16 KiB -
employees 0 InnoDB utf8_general_ci 16 KiB -
enquiries 36 InnoDB utf8_general_ci 64 KiB -
enquiry_multiples 0 InnoDB utf8_general_ci 16 KiB -
enquiry_officer_orderings 324 InnoDB utf8_general_ci 48 KiB -
enquiry_times 38 InnoDB utf8_general_ci 16 KiB -
evidence_informations 40 InnoDB utf8_general_ci 16 KiB -
evidence_information_files 39 InnoDB utf8_general_ci 48 KiB -
evidence_officer_orderings 441 InnoDB utf8_general_ci 64 KiB -
evidence_requisitions 49 InnoDB utf8_general_ci 336 KiB -
evidence_requisition_agencies 62 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_agency_members 93 InnoDB utf8_general_ci 16 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 6 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_for_kind_infos 9 InnoDB latin1_swedish_ci 16 KiB -
evidence_requisition_logistic_members 10 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_ministries 36 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_ministry_officers 37 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_parliament_emps 18 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_witnesses 34 InnoDB utf8_general_ci 16 KiB -
expart_lists 6 InnoDB utf8_general_ci 16 KiB -
expart_list_enquiries 0 InnoDB utf8_general_ci 16 KiB -
expert_meeting_records 0 InnoDB utf8_general_ci 16 KiB -
fiscal_years 250 InnoDB utf8_general_ci 48 KiB -
for_kind_infos 18 InnoDB utf8_general_ci 16 KiB -
for_kind_info_enquiries 58 InnoDB utf8_general_ci 16 KiB -
for_kind_info_member_meeting_records 413 InnoDB utf8_general_ci 64 KiB -
gov_org_infos 84 InnoDB utf8_general_ci 96 KiB -
gov_org_member_lists 174 InnoDB utf8_general_ci 112 KiB -
inquiry_agencies 24 InnoDB utf8_general_ci 16 KiB -
inquiry_agency_members 24 InnoDB utf8_general_ci 16 KiB -
inquiry_audit_directorates 30 InnoDB utf8_general_ci 16 KiB -
inquiry_audit_directorate_members 30 InnoDB utf8_general_ci 16 KiB -
inquiry_cag_infos 15 InnoDB utf8_general_ci 16 KiB -
inquiry_cag_info_members 34 InnoDB utf8_general_ci 16 KiB -
inquiry_ministries 41 InnoDB utf8_general_ci 16 KiB -
inquiry_ministry_officers 50 InnoDB utf8_general_ci 16 KiB -
inquiry_parliament_secretariat_officers 51 InnoDB utf8_general_ci 16 KiB -
inquiry_reports 15 InnoDB utf8_general_ci 112 KiB -
ir_follow_ups 0 InnoDB utf8_general_ci 16 KiB -
ir_recommendations 487 InnoDB utf8_general_ci 272 KiB -
logistics 4 InnoDB utf8_general_ci 64 KiB -
logistics_inquiries 84 InnoDB utf8_general_ci 16 KiB -
logistic_member_lists 72 InnoDB utf8_general_ci 64 KiB -
logistic_member_meeting_records 1,680 InnoDB utf8_general_ci 400 KiB -
maintenance_records 0 InnoDB utf8_general_ci 16 KiB -
media_infos 2 InnoDB utf8_general_ci 16 KiB -
meetings 61 InnoDB utf8_general_ci 16 KiB -
meetings_2018_07_17_0432PM 35 InnoDB utf8_general_ci 16 KiB -
meeting_activities 839 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 80 InnoDB utf8_general_ci 16 KiB -
meeting_adjourn_records_2018_07_17_0432PM 50 InnoDB utf8_general_ci 16 KiB -
meeting_archives 8 InnoDB utf8_general_ci 16 KiB -
meeting_audit_directorate_members 42 InnoDB utf8_general_ci 80 KiB -
meeting_notice_informations 0 InnoDB utf8_general_ci 16 KiB -
meeting_places 10 InnoDB utf8_general_ci 16 KiB -
ministries 38 InnoDB utf8_general_ci 64 KiB -
ministry_officers 118 InnoDB utf8_general_ci 80 KiB -
ministry_officer_meeting_records 58 InnoDB utf8_general_ci 96 KiB -
modules 116 InnoDB utf8_general_ci 16 KiB -
mpsinfos 615 InnoDB utf8_general_ci 1.5 MiB -
officer_orderings 566 InnoDB utf8_general_ci 64 KiB -
parliaments 11 InnoDB utf8_general_ci 16 KiB -
parliament_emps 66 InnoDB utf8_general_ci 64 KiB -
parliament_emp_committees 109 InnoDB utf8_general_ci 16 KiB -
parliament_secretariat_meeting_records 114 InnoDB utf8_general_ci 16 KiB -
parties 11 InnoDB utf8_general_ci 16 KiB -
pcommittees 88 InnoDB utf8_general_ci 80 KiB -
press_releases 0 InnoDB utf8_general_ci 16 KiB -
privileges 1,578 InnoDB utf8_general_ci 128 KiB -
progress_reports 0 InnoDB utf8_general_ci 16 KiB -
recording_decisions 39 InnoDB utf8_general_ci 64 KiB -
recording_decision_agency_members 116 InnoDB utf8_general_ci 16 KiB -
recording_decision_audit_directorate_members 42 InnoDB utf8_general_ci 16 KiB -
recording_decision_cag_info_members 89 InnoDB utf8_general_ci 16 KiB -
recording_decision_committee_members 294 InnoDB utf8_general_ci 48 KiB -
recording_decision_experts 0 InnoDB utf8_general_ci 16 KiB -
recording_decision_ministry_officers 75 InnoDB utf8_general_ci 16 KiB -
recording_decision_officer_orderings 312 InnoDB utf8_general_ci 16 KiB -
recording_decision_parliament_emps 80 InnoDB utf8_general_ci 16 KiB -
recording_decision_sub_committee_members 0 InnoDB utf8_general_ci 16 KiB -
recording_decision_witnesses 0 InnoDB utf8_general_ci 16 KiB -
reg_files 57 InnoDB utf8_general_ci 64 KiB -
reg_infos 41 InnoDB utf8_general_ci 64 KiB -
roles 16 InnoDB utf8_general_ci 16 KiB -
secretarial_branches 24 InnoDB utf8_general_ci 16 KiB -
settings 1 InnoDB utf8_general_ci 16 KiB -
sub_committees 10 InnoDB utf8_general_ci 16 KiB -
sub_committee_meeting_records 0 InnoDB utf8_general_ci 16 KiB -
sub_committee_members 35 InnoDB utf8_general_ci 16 KiB -
task_flows 20 InnoDB utf8_general_ci 16 KiB -
task_flow_files 139 InnoDB utf8_general_ci 16 KiB -
task_flow_qas 20 InnoDB utf8_general_ci 64 KiB -
tfq_answers 12 InnoDB utf8_general_ci 80 KiB -
users 40 InnoDB utf8_general_ci 48 KiB -
user_committees 59 InnoDB utf8_general_ci 16 KiB -
user_logins 1,743 InnoDB utf8_general_ci 512 KiB -
witnesses 34 InnoDB utf8_general_ci 16 KiB -
witness_enquiries 0 InnoDB utf8_general_ci 16 KiB -
witness_meeting_records 0 InnoDB utf8_general_ci 16 KiB -
workflows 2 InnoDB utf8_general_ci 16 KiB -
138 tables Sum 29,921 InnoDB utf8_general_ci 48.1 MiB 0 B

  Create table
Name:
Number of columns: