Tables


SchemaSpy Analysis of quest_rearch_production.quest_rearch_production

Generated on Tue May 19 02:00 UTC 2026

XML Representation
Insertion Order Deletion Order
TABLES 291
VIEWS 26
COLUMNS 3856
Constraints 146
Anomalies 43
Routines 0

Database Properties

Database Type: MySQL - 8.0.44

Tables

Table / View Children Parents Columns Rows Type Comments
community_lesson 0 0 4 683 Table

Stores Lessons Tagged to a community
es_module_topic_studied 0 0 2 351 Table
mqops_internal_meeting_user 0 0 3 5169 Table

Stores users(Team Members) which is mapped to MQOPS internal meeting form
mqops_educator_interaction_learners_topics 0 0 2 0 Table
mqops_activity_mediums 0 0 5 9 Table

Master table for activitu mediums
ple_day_streak_user 0 3 10 625508 Table
ple_avatar_categories 1 2 7 0 Table
subject_progress_temp 0 0 4 0 Table
phases_downloads 0 0 6 46 Table
maintenance_logs 0 2 9 2 Table
mqops_21st_century_activities_incorporated 0 0 2 9 Table
ple_video_assets 0 3 12 20 Table
facilitator_lesson_progress_1 0 0 12 5062 Table

stores facilitator lesson progress
course_progress_temp 0 0 4 11100 Table
failed_jobs 0 0 6 811406 Table

failed jobs during job dispatch
google_meet_attendees 0 0 5 211 Table
es_module_topic_completed 0 0 2 268 Table
points 0 0 7 6 Table

Master table for points
badge_user 0 0 11 45350613 Table

Keeps User Badges
centre_mqops_centre_visit 0 1 3 2334 Table

Centres Mapped to mqops centre visit
mqops_session_modules 0 0 3 15 Table
migrations 0 0 3 0 Table
custom_fields 0 0 7 0 Table

stores freescout custom feild
ple_skill_texts 0 2 8 60 Table
learning_activities_temporary 0 0 30 648583 Table

Stores student learning activity
ways_own_facilitation_skills 0 0 2 4 Table
mqops_activity_trackers 0 0 183 8657 Table

Stores MQOPS Activity form Data
mqops_tot_states 0 0 5 140 Table
course_progress_new 0 0 11 1638710 Table
community_comment_lesson 0 0 4 0 Table

Lessons tagged to community comments
centre_mqops_session_tracker 0 1 2 2888 Table
phase_project 0 0 3 79 Table

Table to map Phases to project
roles 0 0 14 35 Table

Stores Roles
vacancy_trade 0 0 6 5484 Table
ple_career_paths 3 3 12 21 Table
placement_types 0 0 8 3 Table

Master table for placement type dropdown in placement data
vacancy_district 0 0 2 2604 Table
faqs 0 0 10 125 Table

Stores FAQs for LMS
mqops_educator_interaction_activities_participation 0 0 2 0 Table
design 0 0 2 6 Table
mqops_ways_own_facilitation_skills 0 0 2 0 Table
mqops_placement_interaction_sectors 0 0 2 0 Table
master_trainer_user 0 0 2 1367 Table

Stores facilitators under a master trainer
notification_contents 0 0 11 14 Table

Master table for notification contents
lesson_progress_1 0 0 12 228240 Table

Stores lesson progress of student
ple_guide_books 1 3 10 0 Table
facilitator_learning_activities_sub 0 0 24 1462026 Table

Stores Facilitator learning Activities
lesson_progress_temp 0 0 4 617 Table
batches 2 3 18 28873 Table

Stores batches data
subject_trade_old 0 0 5 8820 Table
mqops_digital_platforms 0 0 2 6 Table
ple_assessment_response_keys 0 5 10 4109921 Table
mqops_educator_interaction_topic_being_taughtin_class 0 0 2 0 Table
mqops_tot_summary 0 0 34 237 Table
mqops_learning_support 0 0 2 8 Table
states 1 0 7 37 Table

Master table for States
mqops_overcome_challenges 0 0 2 5 Table
mqops_principal_interaction_tracker 0 0 40 7 Table
partnership_types 0 0 7 7 Table

Stores types of partnerships
ple_credits 0 2 11 4 Table
centre_types_old 0 1 8 8 Table

Centre types master table
ple_assessment_pages 1 3 10 48 Table
subject_progress 0 0 11 1688152 Table
approvals 0 0 10 5 Table

Stores data for approval,when a user creates data in admin panel
mqops_educator_interaction_es_session_challenges 0 0 2 0 Table
community_comment_user 0 0 4 16 Table

Users tagged to community comments
jobs 0 0 7 1755 Table

Database Queue Jobs table.
course_progress_11 0 0 11 1718332 Table
trades 5 0 9 416 Table

Master table for trades
vacancy_educational_qualification 0 0 4 733 Table

Stores educational qualification for vacancies(jobs)
centre_subject_backup 0 0 5 462926 Table
mqops_educator_interaction_tracker 0 0 40 8 Table
learning_activities_archive 0 0 30 8603187 Table

Stores student learning activity
courses 3 1 14 1668 Table

Stores Course Data
vacancy_field 0 0 6 2650 Table

Stores fields attached to a vacancy(jobs)
districts 0 0 7 739 Table

Stores district master data
mqops_partner_types 0 0 5 5 Table

Master table for MQOPS partner types
session_typesold 0 0 3 16 Table
learning_activities_temp 0 0 20 64162 Table

temp learning activity
mqops_education_interactions 0 0 59 0 Table
phase_users 0 4 7 1308700 Table
community_user_actions 0 0 8 41591 Table

Stores community user likes and bookmarks data
otps 0 0 9 38335 Table

stores generated otp according to request type
mqops_educator_interaction_digital_platforms 0 0 2 0 Table
batch_phase 0 0 5 4324 Table
ple_avatars 1 4 14 25 Table
programs 0 0 11 55 Table

Stores program details
login_logs 0 0 8 1839234 Table

Stores Login Details
mqops_activity_types 0 0 11 43 Table
ple_course_skill 0 5 9 0 Table
user_library_languages 0 0 7 5312530 Table

Stores languages selected by users for each subjects and courses
feedback_questions 0 0 6 6 Table

Stores Subject Completion feedback questions
user_lesson_downloads 0 0 6 1481896 Table

Stores lesson download details from mobile
es_modules 0 0 2 16 Table
google_meet_guests 0 0 4 3299 Table
mqops_activity_tracker_trade 0 1 2 0 Table
mqops_self_reflection_tracker 0 0 25 5 Table
vacancy_user_actions 0 0 9 59838 Table

Stores data when user shows intrested,or delete a job
centre_mqops_activity_tracker 0 1 3 8149 Table

Centres Mapped to Activity Tracker
leader_designation_mqops_activity_tracker 0 0 2 232 Table
learning_activity_responses 0 3 6 77432 Table
offerletter_status 0 0 6 3 Table

Master table of offer letter status
otps_old 0 0 9 263980 Table

stores generated otp according to request type
email_verify_records 0 0 4 1979 Table

store emails of user before verification.
facilitator_lesson_progress 0 0 12 1253 Table

stores facilitator lesson progress
google_meets 0 0 16 750 Table
activity_log 0 0 12 184783896 Table

Keeps Activity data
ple_guide_book_user 0 5 9 0 Table
mqops_educator_interaction_21st_century_activities_incorporated 0 0 2 0 Table
phases 0 0 15 119 Table

Stores Phases details
mqops_session_trackers 0 0 119 3393 Table
ple_user_onboardings 0 4 21 158055 Table
mqops_improve_es_session 0 0 2 5 Table
organisation_program 0 0 6 1646 Table

Stores organisation program mapping
mqops_external_meeting_user 0 0 3 1028 Table

Stores users(Team Members) which is mapped to MQOPS external meeting form
mqops_sub_grant_topic_being_taught_in_class 0 0 2 16 Table
mqops_educator_interaction_lem_session 0 0 2 0 Table
lessons 0 0 32 16759 Table

Stores lesson data
community_comments 0 0 9 1526605 Table

Stores comments of community
atest_table2 0 0 2 0 Table
mqops_centre_visit_states 0 0 5 209 Table
placement_courses 0 1 7 5 Table

Master table for course dropdown in placement data
atest_table1 0 0 2 0 Table
mqops_educator_interaction_overcome_challenges 0 0 2 0 Table
vacancy_shares 0 0 6 1088 Table

Stores details for vacancy shares.When a user shares a vacancy to a user or batch,it will be stored in this table
batch_mqops_activity_tracker 0 1 3 4172 Table

Batches linked to Mqops activity tracker
point_users 0 0 12 42555404 Table

stores point of user
centre_trade 0 0 2 512151 Table
lesson_categories 0 0 8 2 Table

Master table for lesson categories
centre_user 0 2 2 7463 Table

Superfacilitator centres
resource_categories 0 0 6 4 Table

Master table for resource categories
mqops_educator_interaction_motivates_to_improve 0 0 2 0 Table
learning_activities_backup_march12 0 0 30 0 Table

Stores student learning activity
user_resources 0 0 9 188700 Table

Stores the clicks on external resource by users
mqops_activity_wfh_sector 0 0 2 23 Table
learning_activities_archive_log 4 0 7 994 Table
mqops_tot_objective_summary 0 0 2 492 Table
model_has_roles 0 1 5 809594 Table

Stores roles for each users
mqops_internal_meetings 0 0 12 1734 Table

Stores MQOPS internal Meeting form details
vacancies 0 0 32 2577 Table

Stores vacancy(jobs) data
placement_status 0 0 9 9 Table

Mastertable for placement status dropdown in placement data
centre_project 0 2 3 22484 Table

Projects mapped to centre
mqops_es_session_challenges 0 0 2 5 Table
language_lesson 0 0 9 26761 Table

Stores link for different languages of lessons
lesson_progress 0 0 12 312865 Table
mqops_educator_interaction_sub_grant_topic_being_taught_in_class 0 0 2 0 Table
ple_content_ple_skill 0 2 2 6 Table
session_types 11 0 7 22 Table
ple_avatar_user 0 4 8 241878 Table
mqops_centrehead_interaction_tracker 0 0 22 0 Table
mqops_activities_participation 0 0 2 8 Table
mqops_placement_officer_interaction 0 0 38 0 Table
fields 0 0 7 95 Table

Job field Master Data
mqops_educator_interaction_learning_support 0 0 2 0 Table
mqops_educator_interaction_harder_topics 0 0 2 0 Table
subject_trade 0 0 2 6288 Table
batch_community 0 0 2 3218047 Table
faq_categories 0 1 11 19 Table

STores FAQ Categories
centre_subject 0 2 5 321822 Table

Subjects mapped to centre
vacancy_types 0 0 7 7 Table

Master table for vacancy type.
personal_access_tokens 0 0 9 1559220 Table
google_refresh_tokens 0 0 4 0 Table
ple_skills 7 3 11 60 Table
test_table 0 0 3 321558 Table
user_recent_subjects 0 0 2 216711 Table

Stores recently accessed subjects by users
ple_job_cards 3 4 17 8555 Table
facilitator_course_progress_1 0 0 11 46240 Table

facilitator course progress
activity_types 0 0 2 3 Table
ple_assessment_responses 1 4 11 112569 Table
phases_download_status 0 0 7 235 Table
centre_phase 0 1 6 7554 Table

Phase which is mapped to centre
ple_skill_user 0 4 8 571616 Table
users 45 1 50 1065870 Table

Stores users details
learning_activities 1 0 30 34900863 Table

Stores student learning activity
mqops_external_meetings 0 0 19 1282 Table

Stores MQOPS external Meeting form details
mqops_tot_stakeholder 0 0 2 5 Table
mqops_tot_objectives 0 0 2 8 Table
log_stud_details 0 0 5 0 Table

stores loged in student details
course_progress 0 0 11 12198062 Table

student course progress
mqops_lem_sessions 0 0 2 6 Table
ple_assessment_lock_activities 0 2 5 6 Table
ple_image_assets 0 3 14 9 Table
mqops_tot_summary_centre_type 0 0 2 488 Table
facilitator_details 0 0 12 33581 Table

Stores facilitator details
ple_assessments 3 3 14 51 Table
subject_ple_career_path 0 0 2 186 Table
mqops_tot_summary_centre 0 0 10 1878 Table
mqops_activity_typesold 0 0 6 23 Table

Master table for MQOPS Activity types
ple_job_card_texts 0 1 12 10172 Table
tenants 32 0 6 3 Table

Tenant details
notifications 0 0 12 91454842 Table

Stores All Notifications
mqops_century_activities 0 0 2 14 Table
lesson_progress_18092023 0 0 12 1376 Table

Stores lesson progress of student
badges 0 2 14 1024 Table

Stores badges data
projects 1 0 13 171 Table

Stores Project details
exclude_user_id 0 0 1 102 Table
mqops_educator_interaction_topics 0 0 4 25 Table
phase_subject 0 2 3 82 Table
facilitator_learning_activities 0 0 27 1272742 Table

Stores Facilitator learning Activities
subject_progress_15092023 0 0 11 921788 Table

stores student subject progress
badge_type 1 1 6 2 Table

Stored badge type
languages 11 0 8 10 Table

Master table for available lesson languages
offerletter_types 0 0 6 2 Table

Master table for offer letter types
mqops_activity_employer_sector 0 0 2 0 Table
ple_content_ple_job_card 0 2 2 0 Table
telescope_entries_tags 0 1 2 1809314 Table
organisations 0 0 22 1501 Table

Stores Organisation data
subject_feedbacks 0 0 9 554796 Table

Stores user feedback of completed subjects
community_user 0 0 4 164 Table

Stores Users tagged to a community
mqops_institute_active_placement 0 0 2 3 Table
lesson_types 0 0 10 5 Table

Master table for lesson types
ple_job_card_user 0 4 9 1401108 Table
mqops_empoyability_skill_taught 0 0 2 6 Table
project_subject 0 0 4 1541 Table

Stores project - subject mapping data
subjects 2 0 18 971 Table

Stores subject details
facilitator_subject_progress 0 0 11 72846 Table

stores facilitator subject progress
locations 0 0 5 715 Table

Master table for locations
permissions 0 0 12 99 Table

Stores Permissions Master Data
model_has_permissions 0 0 3 526867 Table

Direct Permissions for users
sidp_subjects 0 0 5 4102 Table
mqops_educator_interaction_empoyability_skill_taught 0 0 2 0 Table
ple_content_card_ple_skill 0 2 2 347 Table
mqops_educator_interaction_21st_century_activities 0 0 2 0 Table
ple_job_card_career_path 0 4 8 8199 Table
ple_assessment_questions 2 6 17 1605 Table
batch_subject 0 2 3 1125753 Table

Subjects mapped to batches
mqops_student_interaction_tracker_details 0 0 47 14 Table
mqops_topic_being_taught_in_class 0 0 2 18 Table
centre_trade_old 0 0 2 455544 Table
mqops_tot_summary_project 0 0 8 260 Table
telescope_entries 1 0 8 2142736 Table
community_users 0 0 9 225019 Table

Stores users tagged to a community
google_meet_records 0 0 6 142 Table
telescope_monitoring 0 0 1 0 Table
reports 0 0 31 19086 Table

Stores issues raised by learners or facilitators
sectors 0 0 7 41 Table

Master Table for Sectors
mqops_educator_interaction_institute_active_placement 0 0 2 0 Table
course_progress_15092023 0 0 11 1607360 Table

student course progress
mqops_lem_sector 0 0 2 41 Table
mqops_centre_visits 0 0 59 3989 Table

Stores MQOPS Centre Visit form data
mqops_internal_meeing_user 0 0 3 221 Table

Stores users(Team Members) which is mapped to MQOPS internal meeting form
mqops_centre_visit_user 0 0 3 933 Table

Stores users(Team Members) which is mapped to MQOPS centre visit form
mailboxes 0 0 6 37 Table

Stores mailbox details
mqops_reasons 0 0 2 9 Table
app_updates 0 0 13 1 Table
mqops_tot_types 0 0 2 16 Table
ple_career_path_user 0 4 9 192971 Table
mqops_external_meeing_user 0 0 3 29 Table

Stores users(Team Members) which is mapped to MQOPS external meeting form
ple_skill_trade 0 5 9 0 Table
centres 8 1 49 23038 Table

Stores Centre Data
communities 0 1 19 2926544 Table

Stores Commmunity Data
role_has_permissions 0 0 2 763 Table

Table to map permissions to roles
community_details 0 0 8 47021 Table

Stores files attached to community
mqops_leader_designation 0 0 2 6 Table
ple_analytics 0 3 13 0 Table
failed_jobs_backup 0 0 6 1972002 Table

failed jobs during job dispatch
student_details 0 0 42 975249 Table

Stores Student details
ple_contents 5 0 12 239 Table
subject_progress_1 0 0 11 1202640 Table

stores student subject progress
mqops_sectors 0 0 3 41 Table
mqops_activity_company_sector 0 0 2 26 Table
state_user 0 2 2 20 Table
atest_table 0 0 2 0 Table
user_programs 0 0 5 18044 Table
ple_career_path_texts 0 2 13 39 Table
profile_pics 0 0 5 10 Table

Master table for Profile Pics
report_comments 0 0 12 35686 Table

Stores comments for issues raised through IMS
badge_category 1 1 6 3 Table

Stores badge categories
ple_success_stories 0 3 14 17 Table
faq_sub_categories 0 1 10 111 Table

Stores FAQ subcategories data
ple_content_cards 3 2 9 1478 Table
subject_progress_18092023 0 0 11 7140 Table

stores student subject progress
mqops_student_interaction_tracker 0 0 16 5 Table
mqops_documents 0 0 7 15226 Table

Used for storing mqops documents
lesson_progress_15092023 0 0 12 192708 Table

Stores lesson progress of student
placements 0 0 23 99125 Table

Stores placement details for learners
mqops_downloads 0 0 5 33 Table
resources 0 0 14 169 Table

Stores external resource data
facilitator_activity_logs 0 0 8 109975 Table
learning_activities_sub 0 0 30 47743267 Table

Stores student learning activity
batches_non_ple 0 0 1 354 Table
mqops_facilitation_skills 0 0 2 4 Table
mqops_lem_educator_century_activities 0 0 2 0 Table
mqops_lem_activities 0 0 4 16 Table
admin_mobile 0 1 7 279 Table
facilitator_subject_progress_1 0 0 11 7920 Table

stores facilitator subject progress
ple_assessment_options 1 3 11 5966 Table
centre_types 0 1 8 16 Table
report_feedback 0 0 7 0 Table

Stores feedback for issues raised through IMS
facilitator_course_progress 0 0 11 324204 Table

facilitator course progress
educational_qualifications 0 1 7 7 Table

Master table for educational qualification
lessons_view 0 0 31 0 View
mqops_session_view 0 0 99 0 View
user_tst_view 0 0 38 0 View
learn_act 0 0 15 0 View
batch_subject_view 0 0 16 0 View
batch_all_learners 0 0 41 0 View
centre_subject_career_path_view 0 0 20 0 View
mqops_session_viewold 0 0 55 0 View
notification_not_send_view 0 0 12 0 View
mqops_activity_view 0 0 194 0 View
student_report_view 0 0 91 0 View
l_p_view 0 0 5 0 View
centre_module_viewbackup9feb26 0 0 15 0 View
centre_lesson_viewbackup9feb26 0 0 33 0 View
activity_log_view 0 0 14 0 View
centre_lesson_view 0 0 34 0 View
c_p_view 0 0 6 0 View
centre_internal_resource_view 0 0 28 0 View
batch_lesson_view 0 0 25 0 View
mqops_activity_viewold 0 0 75 0 View
s_p_view 0 0 6 0 View
centre_module_view 0 0 16 0 View
batch_subject_career_path_view 0 0 18 0 View
centre_subject_progress_view 0 0 4 0 View
error_report_view 0 0 32 0 View
centre_subject_view 0 0 20 0 View