Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: db_test_2020_01_02
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 412 InnoDB utf8_general_ci 112 KiB -
agenda_wise_decisions 889 InnoDB utf8_general_ci 432 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 46 InnoDB utf8_general_ci 16 KiB -
audits 8,413 InnoDB utf8_general_ci 26.5 MiB -
audit_deltas 6,597 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 251 InnoDB utf8_general_ci 64 KiB -
audit_objection_agencies 7 InnoDB utf8_general_ci 16 KiB -
audit_objection_audit_directorates 251 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 16 InnoDB utf8_general_ci 16 KiB -
audit_objection_multiples 599 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 104 InnoDB utf8_general_ci 16 KiB -
briefing_notes 51 InnoDB utf8_general_ci 1.5 MiB -
cag_infos 2 InnoDB utf8_general_ci 16 KiB -
cag_info_members 15 InnoDB utf8_general_ci 16 KiB -
cag_info_member_meeting_records 196 InnoDB utf8_general_ci 96 KiB -
chairman_speeches 3 InnoDB utf8_general_ci 32 KiB -
cmn_functions 203 InnoDB utf8_general_ci 4.5 MiB -
committee_lists 547 InnoDB utf8_general_ci 64 KiB -
committee_meeting_records 1,182 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 253 InnoDB utf8_general_ci 16 KiB -
designations 0 InnoDB utf8_general_ci 16 KiB -
employees 0 InnoDB utf8_general_ci 16 KiB -
enquiries 100 InnoDB utf8_general_ci 96 KiB -
enquiry_multiples 0 InnoDB utf8_general_ci 16 KiB -
enquiry_officer_orderings 909 InnoDB utf8_general_ci 64 KiB -
enquiry_times 104 InnoDB utf8_general_ci 16 KiB -
evidence_informations 82 InnoDB utf8_general_ci 16 KiB -
evidence_information_files 80 InnoDB utf8_general_ci 48 KiB -
evidence_officer_orderings 918 InnoDB utf8_general_ci 64 KiB -
evidence_requisitions 102 InnoDB utf8_general_ci 416 KiB -
evidence_requisition_agencies 204 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_agency_members 359 InnoDB utf8_general_ci 48 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 25 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_for_kind_infos 130 InnoDB latin1_swedish_ci 16 KiB -
evidence_requisition_logistic_members 283 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_ministries 89 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_ministry_officers 86 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_parliament_emps 41 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_witnesses 103 InnoDB utf8_general_ci 16 KiB -
expart_lists 6 InnoDB utf8_general_ci 16 KiB -
expart_list_enquiries 1 InnoDB utf8_general_ci 16 KiB -
expert_meeting_records 25 InnoDB utf8_general_ci 16 KiB -
fiscal_years 251 InnoDB utf8_general_ci 48 KiB -
for_kind_infos 19 InnoDB utf8_general_ci 16 KiB -
for_kind_info_enquiries 91 InnoDB utf8_general_ci 16 KiB -
for_kind_info_member_meeting_records 758 InnoDB utf8_general_ci 64 KiB -
gov_org_infos 104 InnoDB utf8_general_ci 112 KiB -
gov_org_member_lists 180 InnoDB utf8_general_ci 112 KiB -
inquiry_agencies 43 InnoDB utf8_general_ci 16 KiB -
inquiry_agency_members 42 InnoDB utf8_general_ci 16 KiB -
inquiry_audit_directorates 60 InnoDB utf8_general_ci 16 KiB -
inquiry_audit_directorate_members 60 InnoDB utf8_general_ci 48 KiB -
inquiry_cag_infos 28 InnoDB utf8_general_ci 16 KiB -
inquiry_cag_info_members 47 InnoDB utf8_general_ci 16 KiB -
inquiry_ministries 110 InnoDB utf8_general_ci 16 KiB -
inquiry_ministry_officers 112 InnoDB utf8_general_ci 48 KiB -
inquiry_parliament_secretariat_officers 79 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 143 InnoDB utf8_general_ci 16 KiB -
logistic_member_lists 81 InnoDB utf8_general_ci 64 KiB -
logistic_member_meeting_records 2,626 InnoDB utf8_general_ci 448 KiB -
maintenance_records 0 InnoDB utf8_general_ci 16 KiB -
media_infos 2 InnoDB utf8_general_ci 16 KiB -
meetings 99 InnoDB utf8_general_ci 48 KiB -
meetings_2018_07_17_0432PM 35 InnoDB utf8_general_ci 16 KiB -
meeting_activities 1,040 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 119 InnoDB utf8_general_ci 16 KiB -
meeting_adjourn_records_2018_07_17_0432PM 50 InnoDB utf8_general_ci 16 KiB -
meeting_archives 11 InnoDB utf8_general_ci 16 KiB -
meeting_audit_directorate_members 145 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 49 InnoDB utf8_general_ci 64 KiB -
ministry_officers 132 InnoDB utf8_general_ci 80 KiB -
ministry_officer_meeting_records 279 InnoDB utf8_general_ci 112 KiB -
modules 116 InnoDB utf8_general_ci 16 KiB -
mpsinfos 618 InnoDB utf8_general_ci 1.5 MiB -
officer_orderings 966 InnoDB utf8_general_ci 80 KiB -
parliaments 11 InnoDB utf8_general_ci 16 KiB -
parliament_emps 82 InnoDB utf8_general_ci 64 KiB -
parliament_emp_committees 131 InnoDB utf8_general_ci 16 KiB -
parliament_secretariat_meeting_records 173 InnoDB utf8_general_ci 16 KiB -
parties 12 InnoDB utf8_general_ci 16 KiB -
pcommittees 89 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 48 InnoDB utf8_general_ci 64 KiB -
recording_decision_agency_members 132 InnoDB utf8_general_ci 16 KiB -
recording_decision_audit_directorate_members 57 InnoDB utf8_general_ci 16 KiB -
recording_decision_cag_info_members 114 InnoDB utf8_general_ci 16 KiB -
recording_decision_committee_members 384 InnoDB utf8_general_ci 48 KiB -
recording_decision_experts 9 InnoDB utf8_general_ci 16 KiB -
recording_decision_ministry_officers 87 InnoDB utf8_general_ci 16 KiB -
recording_decision_officer_orderings 384 InnoDB utf8_general_ci 48 KiB -
recording_decision_parliament_emps 102 InnoDB utf8_general_ci 16 KiB -
recording_decision_sub_committee_members 0 InnoDB utf8_general_ci 16 KiB -
recording_decision_witnesses 3 InnoDB utf8_general_ci 16 KiB -
reg_files 131 InnoDB utf8_general_ci 64 KiB -
reg_infos 122 InnoDB utf8_general_ci 80 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 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 29 InnoDB utf8_general_ci 16 KiB -
task_flow_files 161 InnoDB utf8_general_ci 16 KiB -
task_flow_qas 28 InnoDB utf8_general_ci 64 KiB -
tfq_answers 21 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,489 InnoDB utf8_general_ci 1.5 MiB -
witnesses 34 InnoDB utf8_general_ci 16 KiB -
witness_enquiries 1 InnoDB utf8_general_ci 16 KiB -
witness_meeting_records 71 InnoDB utf8_general_ci 16 KiB -
workflows 2 InnoDB utf8_general_ci 16 KiB -
138 tables Sum 43,070 InnoDB utf8_general_ci 52.7 MiB 0 B

  Create table
Name:
Number of columns: