Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: db_test_2019_11_20
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 392 InnoDB utf8_general_ci 112 KiB -
agenda_wise_decisions 847 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 44 InnoDB utf8_general_ci 16 KiB -
audits 6,103 InnoDB utf8_general_ci 25.5 MiB -
audit_deltas 5,777 InnoDB utf8_general_ci 5 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 63 InnoDB utf8_general_ci 16 KiB -
briefing_notes 43 InnoDB utf8_general_ci 1.5 MiB -
cag_infos 2 InnoDB utf8_general_ci 16 KiB -
cag_info_members 12 InnoDB utf8_general_ci 16 KiB -
cag_info_member_meeting_records 177 InnoDB utf8_general_ci 96 KiB -
chairman_speeches 3 InnoDB utf8_general_ci 32 KiB -
cmn_functions 179 InnoDB utf8_general_ci 4.5 MiB -
committee_lists 440 InnoDB utf8_general_ci 64 KiB -
committee_meeting_records 959 InnoDB utf8_general_ci 96 KiB -
committee_members_pictures 39 InnoDB utf8_general_ci 16 KiB -
committee_report_indices 19 InnoDB utf8_general_ci 16 KiB -
committee_secretaries 218 InnoDB utf8_general_ci 16 KiB -
designations 0 InnoDB utf8_general_ci 16 KiB -
employees 0 InnoDB utf8_general_ci 16 KiB -
enquiries 53 InnoDB utf8_general_ci 80 KiB -
enquiry_multiples 0 InnoDB utf8_general_ci 16 KiB -
enquiry_officer_orderings 477 InnoDB utf8_general_ci 64 KiB -
enquiry_times 54 InnoDB utf8_general_ci 16 KiB -
evidence_informations 44 InnoDB utf8_general_ci 16 KiB -
evidence_information_files 43 InnoDB utf8_general_ci 48 KiB -
evidence_officer_orderings 558 InnoDB utf8_general_ci 64 KiB -
evidence_requisitions 62 InnoDB utf8_general_ci 400 KiB -
evidence_requisition_agencies 65 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_agency_members 99 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_audit_directorates 12 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_audit_directorate_members 12 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_cag_infos 22 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_cag_info_members 24 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_expart_lists 6 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_for_kind_infos 10 InnoDB latin1_swedish_ci 16 KiB -
evidence_requisition_logistic_members 20 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_ministries 45 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_ministry_officers 45 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_parliament_emps 22 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 12 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 74 InnoDB utf8_general_ci 16 KiB -
for_kind_info_member_meeting_records 488 InnoDB utf8_general_ci 64 KiB -
gov_org_infos 86 InnoDB utf8_general_ci 96 KiB -
gov_org_member_lists 177 InnoDB utf8_general_ci 112 KiB -
inquiry_agencies 39 InnoDB utf8_general_ci 16 KiB -
inquiry_agency_members 39 InnoDB utf8_general_ci 16 KiB -
inquiry_audit_directorates 59 InnoDB utf8_general_ci 16 KiB -
inquiry_audit_directorate_members 59 InnoDB utf8_general_ci 48 KiB -
inquiry_cag_infos 26 InnoDB utf8_general_ci 16 KiB -
inquiry_cag_info_members 45 InnoDB utf8_general_ci 16 KiB -
inquiry_ministries 57 InnoDB utf8_general_ci 16 KiB -
inquiry_ministry_officers 65 InnoDB utf8_general_ci 48 KiB -
inquiry_parliament_secretariat_officers 64 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 113 InnoDB utf8_general_ci 16 KiB -
logistic_member_lists 81 InnoDB utf8_general_ci 64 KiB -
logistic_member_meeting_records 2,022 InnoDB utf8_general_ci 432 KiB -
maintenance_records 0 InnoDB utf8_general_ci 16 KiB -
media_infos 2 InnoDB utf8_general_ci 16 KiB -
meetings 69 InnoDB utf8_general_ci 16 KiB -
meetings_2018_07_17_0432PM 35 InnoDB utf8_general_ci 16 KiB -
meeting_activities 926 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 88 InnoDB utf8_general_ci 16 KiB -
meeting_adjourn_records_2018_07_17_0432PM 50 InnoDB utf8_general_ci 16 KiB -
meeting_archives 9 InnoDB utf8_general_ci 16 KiB -
meeting_audit_directorate_members 158 InnoDB utf8_general_ci 96 KiB -
meeting_notice_informations 0 InnoDB utf8_general_ci 16 KiB -
meeting_places 10 InnoDB utf8_general_ci 16 KiB -
ministries 44 InnoDB utf8_general_ci 64 KiB -
ministry_officers 130 InnoDB utf8_general_ci 80 KiB -
ministry_officer_meeting_records 248 InnoDB utf8_general_ci 112 KiB -
modules 116 InnoDB utf8_general_ci 16 KiB -
mpsinfos 617 InnoDB utf8_general_ci 1.5 MiB -
officer_orderings 756 InnoDB utf8_general_ci 80 KiB -
parliaments 11 InnoDB utf8_general_ci 16 KiB -
parliament_emps 79 InnoDB utf8_general_ci 64 KiB -
parliament_emp_committees 129 InnoDB utf8_general_ci 16 KiB -
parliament_secretariat_meeting_records 145 InnoDB utf8_general_ci 16 KiB -
parties 12 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 40 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 301 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 320 InnoDB utf8_general_ci 48 KiB -
recording_decision_parliament_emps 82 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 73 InnoDB utf8_general_ci 64 KiB -
reg_infos 62 InnoDB utf8_general_ci 80 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 21 InnoDB utf8_general_ci 16 KiB -
task_flow_files 139 InnoDB utf8_general_ci 16 KiB -
task_flow_qas 21 InnoDB utf8_general_ci 64 KiB -
tfq_answers 15 InnoDB utf8_general_ci 80 KiB -
users 40 InnoDB utf8_general_ci 48 KiB -
user_committees 61 InnoDB utf8_general_ci 16 KiB -
user_logins 2,147 InnoDB utf8_general_ci 1.5 MiB -
witnesses 34 InnoDB utf8_general_ci 16 KiB -
witness_enquiries 0 InnoDB utf8_general_ci 16 KiB -
witness_meeting_records 68 InnoDB utf8_general_ci 16 KiB -
workflows 2 InnoDB utf8_general_ci 16 KiB -
138 tables Sum 35,130 InnoDB utf8_general_ci 51.5 MiB 0 B

  Create table
Name:
Number of columns: