Déposer des fichiers ici

Téléversement SQL ( 0 ) x -

Serveur: localhost »Base de données: moodle
Paramètres relatifs à la page Cliquer sur la barre pour faire défiler en haut de page
Faire Ctrl+Entrée pour exécuter la requête Faire Entrée pour exécuter la requête
croissant
décroissant
Ordre :
Déboguer SQL
Nombre
Ordre d'exécution
Temps nécessaire
Trier par :
Regrouper les requêtes
Dissocier les groupes
Réduire Développer Afficher le suivi Masquer le suivi Nombre Temps nécessaire
Signets
Actualiser
Ajouter
Aucun signet
Ajouter un signet
Options
Définir par défaut





Réduire Développer Exécuter la requête à nouveau Éditer Expliquer Profilage Signet La requête a échoué Base de données : Daté du :

Structure de base de données

Choisir les détails à afficher dans la liste des tables.

Documentation Afficher ou masquer une colonne affichant le jeu de caractères pour toutes les tables.
Documentation Afficher ou masquer une colonne affichant les commentaires pour toutes les tables.
Documentation Afficher ou masquer une colonne contenant la date de création pour toutes les tables.
Documentation Afficher ou masquer une colonne contenant l'horodatage de dernière mise à jour pour toutes les tables.
Documentation Afficher ou masquer une colonne contenant l'horodatage de dernière vérification pour toutes les tables.
Page n° :
> >>
Filtres
Table Croissant Décroissant Action Lignes Peut être approximatif. Cliquer sur le nombre pour obtenir le compte exact. Voir FAQ 3.11. Type Interclassement Taille Perte
mdl_analytics_indicator_calc 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_analytics_models 5 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_analytics_models_log 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_analytics_predictions 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_analytics_prediction_actions 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_analytics_predict_samples 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_analytics_train_samples 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_analytics_used_analysables 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_analytics_used_files 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_assign 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_assignfeedback_comments 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_assignfeedback_editpdf_annot 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_assignfeedback_editpdf_cmnt 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_assignfeedback_editpdf_queue 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_assignfeedback_editpdf_quick 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_assignfeedback_editpdf_rot 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_assignfeedback_file 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_assignment 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_assignment_submissions 0 InnoDB utf8mb4_general_ci 40,0 kio -
mdl_assignment_upgrade 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_assignsubmission_file 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_assignsubmission_onlinetext 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_assign_grades 0 InnoDB utf8mb4_general_ci 40,0 kio -
mdl_assign_overrides 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_assign_plugin_config 0 InnoDB utf8mb4_general_ci 40,0 kio -
mdl_assign_submission 0 InnoDB utf8mb4_general_ci 48,0 kio -
mdl_assign_user_flags 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_assign_user_mapping 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_auth_oauth2_linked_login 0 InnoDB utf8mb4_general_ci 48,0 kio -
mdl_backup_controllers 0 InnoDB utf8mb4_general_ci 40,0 kio -
mdl_backup_courses 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_backup_logs 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_badge 0 InnoDB utf8mb4_general_ci 40,0 kio -
mdl_badge_alignment 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_badge_backpack 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_badge_backpack_oauth2 0 InnoDB utf8mb4_general_ci 40,0 kio -
mdl_badge_criteria 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_badge_criteria_met 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_badge_criteria_param 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_badge_endorsement 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_badge_external 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_badge_external_backpack 1 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_badge_external_identifier 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_badge_issued 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_badge_manual_award 0 InnoDB utf8mb4_general_ci 40,0 kio -
mdl_badge_related 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_block 44 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_block_instances 19 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_block_positions 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_block_recentlyaccesseditems 0 InnoDB utf8mb4_general_ci 40,0 kio -
mdl_block_recent_activity 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_block_rss_client 0 InnoDB utf8mb4_general_ci 8,0 kio -
mdl_blog_association 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_blog_external 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_book 0 InnoDB utf8mb4_general_ci 8,0 kio -
mdl_book_chapters 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_cache_filters 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_cache_flags 1 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_capabilities 692 InnoDB utf8mb4_general_ci 64,0 kio -
mdl_chat 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_chat_messages 0 InnoDB utf8mb4_general_ci 40,0 kio -
mdl_chat_messages_current 0 InnoDB utf8mb4_general_ci 40,0 kio -
mdl_chat_users 0 InnoDB utf8mb4_general_ci 40,0 kio -
mdl_choice 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_choice_answers 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_choice_options 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_cohort 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_cohort_members 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_comments 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_competency 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_competency_coursecomp 0 InnoDB utf8mb4_general_ci 40,0 kio -
mdl_competency_coursecompsetting 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_competency_evidence 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_competency_framework 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_competency_modulecomp 0 InnoDB utf8mb4_general_ci 40,0 kio -
mdl_competency_plan 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_competency_plancomp 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_competency_relatedcomp 0 InnoDB utf8mb4_general_ci 8,0 kio -
mdl_competency_template 0 InnoDB utf8mb4_general_ci 8,0 kio -
mdl_competency_templatecohort 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_competency_templatecomp 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_competency_usercomp 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_competency_usercompcourse 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_competency_usercompplan 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_competency_userevidence 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_competency_userevidencecomp 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_config 522 InnoDB utf8mb4_general_ci 56,0 kio -
mdl_config_log 2 517 InnoDB utf8mb4_general_ci 192,0 kio -
mdl_config_plugins 2 697 InnoDB utf8mb4_general_ci 192,0 kio -
mdl_contentbank_content 0 InnoDB utf8mb4_general_ci 48,0 kio -
mdl_context 30 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_context_temp 0 InnoDB utf8mb4_general_ci 8,0 kio -
mdl_course 1 InnoDB utf8mb4_general_ci 40,0 kio -
mdl_course_categories 7 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_course_completions 0 InnoDB utf8mb4_general_ci 40,0 kio -
mdl_course_completion_aggr_methd 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_course_completion_criteria 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_course_completion_crit_compl 0 InnoDB utf8mb4_general_ci 48,0 kio -
mdl_course_completion_defaults 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_course_format_options 1 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_course_modules 0 InnoDB utf8mb4_general_ci 56,0 kio -
mdl_course_modules_completion 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_course_published 0 InnoDB utf8mb4_general_ci 8,0 kio -
mdl_course_request 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_course_sections 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_customfield_category 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_customfield_data 0 InnoDB utf8mb4_general_ci 56,0 kio -
mdl_customfield_field 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_data 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_data_content 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_data_fields 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_data_records 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_editor_atto_autosave 40 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_enrol 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_enrol_flatfile 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_enrol_lti_lti2_consumer 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_enrol_lti_lti2_context 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_enrol_lti_lti2_nonce 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_enrol_lti_lti2_resource_link 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_enrol_lti_lti2_share_key 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_enrol_lti_lti2_tool_proxy 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_enrol_lti_lti2_user_result 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_enrol_lti_tools 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_enrol_lti_tool_consumer_map 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_enrol_lti_users 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_enrol_paypal 0 InnoDB utf8mb4_general_ci 48,0 kio -
mdl_event 0 InnoDB utf8mb4_general_ci 104,0 kio -
mdl_events_handlers 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_events_queue 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_events_queue_handlers 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_event_subscriptions 0 InnoDB utf8mb4_general_ci 8,0 kio -
mdl_external_functions 617 InnoDB utf8mb4_general_ci 96,0 kio -
mdl_external_services 1 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_external_services_functions 375 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_external_services_users 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_external_tokens 0 InnoDB utf8mb4_general_ci 48,0 kio -
mdl_favourite 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_feedback 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_feedback_completed 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_feedback_completedtmp 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_feedback_item 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_feedback_sitecourse_map 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_feedback_template 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_feedback_value 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_feedback_valuetmp 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_files 79 InnoDB utf8mb4_general_ci 80,0 kio -
mdl_files_reference 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_file_conversion 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_filter_active 6 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_filter_config 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_folder 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_forum 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_forum_digests 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_forum_discussions 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_forum_discussion_subs 0 InnoDB utf8mb4_general_ci 40,0 kio -
mdl_forum_grades 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_forum_posts 0 InnoDB utf8mb4_general_ci 56,0 kio -
mdl_forum_queue 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_forum_read 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_forum_subscriptions 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_forum_track_prefs 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_glossary 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_glossary_alias 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_glossary_categories 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_glossary_entries 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_glossary_entries_categories 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_glossary_formats 7 InnoDB utf8mb4_general_ci 8,0 kio -
mdl_grade_categories 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_grade_categories_history 0 InnoDB utf8mb4_general_ci 56,0 kio -
mdl_grade_grades 0 InnoDB utf8mb4_general_ci 56,0 kio -
mdl_grade_grades_history 0 InnoDB utf8mb4_general_ci 80,0 kio -
mdl_grade_import_newitem 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_grade_import_values 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_grade_items 0 InnoDB utf8mb4_general_ci 72,0 kio -
mdl_grade_items_history 0 InnoDB utf8mb4_general_ci 72,0 kio -
mdl_grade_letters 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_grade_outcomes 0 InnoDB utf8mb4_general_ci 40,0 kio -
mdl_grade_outcomes_courses 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_grade_outcomes_history 0 InnoDB utf8mb4_general_ci 56,0 kio -
mdl_grade_settings 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_gradingform_guide_comments 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_gradingform_guide_criteria 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_gradingform_guide_fillings 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_gradingform_rubric_criteria 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_gradingform_rubric_fillings 0 InnoDB utf8mb4_general_ci 40,0 kio -
mdl_gradingform_rubric_levels 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_grading_areas 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_grading_definitions 0 InnoDB utf8mb4_general_ci 40,0 kio -
mdl_grading_instances 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_groupings 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_groupings_groups 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_groups 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_groups_members 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_h5p 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_h5pactivity 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_h5pactivity_attempts 0 InnoDB utf8mb4_general_ci 48,0 kio -
mdl_h5pactivity_attempts_results 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_h5p_contents_libraries 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_h5p_libraries 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_h5p_libraries_cachedassets 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_h5p_library_dependencies 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_imscp 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_infected_files 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_label 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_lesson 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_lesson_answers 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_lesson_attempts 0 InnoDB utf8mb4_general_ci 40,0 kio -
mdl_lesson_branch 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_lesson_grades 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_lesson_overrides 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_lesson_pages 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_lesson_timer 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_license 9 InnoDB utf8mb4_general_ci 8,0 kio -
mdl_lock_db 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_log 0 InnoDB utf8mb4_general_ci 48,0 kio -
mdl_logstore_standard_log 1 287 InnoDB utf8mb4_general_ci 344,0 kio -
mdl_log_display 189 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_log_queries 0 InnoDB utf8mb4_general_ci 8,0 kio -
mdl_lti 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_ltiservice_gradebookservices 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_lti_access_tokens 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_lti_submission 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_lti_tool_proxies 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_lti_tool_settings 0 InnoDB utf8mb4_general_ci 40,0 kio -
mdl_lti_types 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_lti_types_config 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_message 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_messageinbound_datakeys 0 InnoDB utf8mb4_general_ci 24,0 kio -
mdl_messageinbound_handlers 3 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_messageinbound_messagelist 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_messages 0 InnoDB utf8mb4_general_ci 32,0 kio -
mdl_message_airnotifier_devices 0 InnoDB utf8mb4_general_ci 16,0 kio -
mdl_message_contacts 0 InnoDB utf8mb4_general_ci 32,0 kio -