Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: dbtestmis
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 17 InnoDB utf8_general_ci 48 KiB -
agenda_wise_decisions 277 InnoDB utf8_general_ci 128 KiB -
agenda_wise_votings 0 InnoDB utf8_general_ci 16 KiB -
assemblies 32 InnoDB utf8_general_ci 16 KiB -
audits 1,333 InnoDB utf8_general_ci 7.5 MiB -
audit_deltas 1,713 InnoDB utf8_general_ci 1.7 MiB -
audit_directorates 14 InnoDB utf8_general_ci 16 KiB -
audit_directorate_members 24 InnoDB utf8_general_ci 16 KiB -
audit_objections 125 InnoDB utf8_general_ci 48 KiB -
audit_objection_agencies 4 InnoDB utf8_general_ci 16 KiB -
audit_objection_audit_directorates 125 InnoDB utf8_general_ci 16 KiB -
audit_objection_financials 231 InnoDB utf8_general_ci 80 KiB -
audit_objection_financial_flows 0 InnoDB utf8_general_ci 16 KiB -
audit_objection_ministries 7 InnoDB utf8_general_ci 16 KiB -
audit_objection_multiples 264 InnoDB utf8_general_ci 128 KiB -
bills 0 InnoDB utf8_general_ci 16 KiB -
bill_report_others 15 InnoDB utf8_general_ci 16 KiB -
booking_meeting_places 8 InnoDB utf8_general_ci 16 KiB -
briefing_notes 6 InnoDB utf8_general_ci 176 KiB -
cag_infos 2 InnoDB utf8_general_ci 16 KiB -
cag_info_members 6 InnoDB utf8_general_ci 16 KiB -
cag_info_member_meeting_records 24 InnoDB utf8_general_ci 48 KiB -
chairman_speeches 3 InnoDB utf8_general_ci 32 KiB -
cmn_functions 25 InnoDB utf8_general_ci 1.5 MiB -
committee_lists 87 InnoDB utf8_general_ci 16 KiB -
committee_meeting_records 130 InnoDB utf8_general_ci 16 KiB -
committee_members_pictures 24 InnoDB utf8_general_ci 16 KiB -
committee_report_indices 19 InnoDB utf8_general_ci 16 KiB -
committee_secretaries 38 InnoDB utf8_general_ci 16 KiB -
designations 0 InnoDB utf8_general_ci 16 KiB -
employees 0 InnoDB utf8_general_ci 16 KiB -
enquiries 7 InnoDB utf8_general_ci 16 KiB -
enquiry_multiples 0 InnoDB utf8_general_ci 16 KiB -
enquiry_officer_orderings 63 InnoDB utf8_general_ci 16 KiB -
enquiry_times 10 InnoDB utf8_general_ci 16 KiB -
evidence_informations 12 InnoDB utf8_general_ci 16 KiB -
evidence_information_files 14 InnoDB utf8_general_ci 16 KiB -
evidence_officer_orderings 144 InnoDB utf8_general_ci 16 KiB -
evidence_requisitions 16 InnoDB utf8_general_ci 144 KiB -
evidence_requisition_agencies 61 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_agency_members 92 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 7 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_cag_info_members 7 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_expart_lists 5 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_for_kind_infos 4 InnoDB latin1_swedish_ci 16 KiB -
evidence_requisition_logistic_members 2 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_ministries 13 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_ministry_officers 13 InnoDB utf8_general_ci 16 KiB -
evidence_requisition_parliament_emps 7 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 125 InnoDB utf8_general_ci 16 KiB -
for_kind_infos 17 InnoDB utf8_general_ci 16 KiB -
for_kind_info_enquiries 9 InnoDB utf8_general_ci 16 KiB -
for_kind_info_member_meeting_records 72 InnoDB utf8_general_ci 16 KiB -
gov_org_infos 66 InnoDB utf8_general_ci 80 KiB -
gov_org_member_lists 106 InnoDB utf8_general_ci 80 KiB -
inquiry_agencies 6 InnoDB utf8_general_ci 16 KiB -
inquiry_agency_members 6 InnoDB utf8_general_ci 16 KiB -
inquiry_audit_directorates 13 InnoDB utf8_general_ci 16 KiB -
inquiry_audit_directorate_members 13 InnoDB utf8_general_ci 16 KiB -
inquiry_cag_infos 5 InnoDB utf8_general_ci 16 KiB -
inquiry_cag_info_members 12 InnoDB utf8_general_ci 16 KiB -
inquiry_ministries 11 InnoDB utf8_general_ci 16 KiB -
inquiry_ministry_officers 11 InnoDB utf8_general_ci 16 KiB -
inquiry_parliament_secretariat_officers 12 InnoDB utf8_general_ci 16 KiB -
inquiry_reports 0 InnoDB utf8_general_ci 16 KiB -
ir_follow_ups 0 InnoDB utf8_general_ci 16 KiB -
ir_recommendations 0 InnoDB utf8_general_ci 16 KiB -
logistics 4 InnoDB utf8_general_ci 64 KiB -
logistics_inquiries 7 InnoDB utf8_general_ci 16 KiB -
logistic_member_lists 56 InnoDB utf8_general_ci 48 KiB -
logistic_member_meeting_records 286 InnoDB utf8_general_ci 96 KiB -
maintenance_records 0 InnoDB utf8_general_ci 16 KiB -
media_infos 2 InnoDB utf8_general_ci 16 KiB -
meetings 10 InnoDB utf8_general_ci 16 KiB -
meeting_activities 298 InnoDB utf8_general_ci 480 KiB -
meeting_adjourn_records 18 InnoDB utf8_general_ci 16 KiB -
meeting_archives 5 InnoDB utf8_general_ci 16 KiB -
meeting_audit_directorate_members 16 InnoDB utf8_general_ci 16 KiB -
meeting_notice_informations 0 InnoDB utf8_general_ci 16 KiB -
meeting_places 10 InnoDB utf8_general_ci 16 KiB -
ministries 29 InnoDB utf8_general_ci 48 KiB -
ministry_officers 60 InnoDB utf8_general_ci 64 KiB -
ministry_officer_meeting_records 14 InnoDB utf8_general_ci 48 KiB -
modules 115 InnoDB utf8_general_ci 16 KiB -
mpsinfos 351 InnoDB utf8_general_ci 432 KiB -
officer_orderings 96 InnoDB utf8_general_ci 16 KiB -
parliaments 10 InnoDB utf8_general_ci 16 KiB -
parliament_emps 55 InnoDB utf8_general_ci 48 KiB -
parliament_emp_committees 96 InnoDB utf8_general_ci 16 KiB -
parliament_secretariat_meeting_records 19 InnoDB utf8_general_ci 16 KiB -
parties 9 InnoDB utf8_general_ci 16 KiB -
pcommittees 43 InnoDB utf8_general_ci 64 KiB -
press_releases 0 InnoDB utf8_general_ci 16 KiB -
privileges 1,577 InnoDB utf8_general_ci 128 KiB -
progress_reports 0 InnoDB utf8_general_ci 16 KiB -
recording_decisions 6 InnoDB utf8_general_ci 16 KiB -
recording_decision_agency_members 41 InnoDB utf8_general_ci 16 KiB -
recording_decision_audit_directorate_members 11 InnoDB utf8_general_ci 16 KiB -
recording_decision_cag_info_members 16 InnoDB utf8_general_ci 16 KiB -
recording_decision_committee_members 49 InnoDB utf8_general_ci 16 KiB -
recording_decision_experts 0 InnoDB utf8_general_ci 16 KiB -
recording_decision_ministry_officers 21 InnoDB utf8_general_ci 16 KiB -
recording_decision_officer_orderings 48 InnoDB utf8_general_ci 16 KiB -
recording_decision_parliament_emps 11 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 13 InnoDB utf8_general_ci 16 KiB -
reg_infos 12 InnoDB utf8_general_ci 16 KiB -
roles 16 InnoDB utf8_general_ci 16 KiB -
secretarial_branches 23 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 1 InnoDB utf8_general_ci 16 KiB -
task_flow_files 0 InnoDB utf8_general_ci 16 KiB -
task_flow_qas 1 InnoDB utf8_general_ci 16 KiB -
tfq_answers 1 InnoDB utf8_general_ci 16 KiB -
users 38 InnoDB utf8_general_ci 48 KiB -
user_committees 57 InnoDB utf8_general_ci 16 KiB -
user_logins 459 InnoDB utf8_general_ci 144 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 0 InnoDB utf8_general_ci 16 KiB -
131 tables Sum 9,664 InnoDB utf8_general_ci 15 MiB 0 B

  Create table
Name:
Number of columns: