Tables


SchemaSpy Analysis of quest_rearch_production.quest_rearch_production

Generated on Mon Jan 19 12:16 UTC 2026

XML Representation
Insertion Order Deletion Order
TABLES 236
VIEWS 24
COLUMNS 3415
Constraints 139
Anomalies 31
Routines 0

Database Properties

Database Type: MySQL - 8.0.42

Tables

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

Stores Lessons Tagged to a community
mqops_internal_meeting_user 0 0 3 5169 Table

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

Master table for activitu mediums
ple_day_streak_user 0 3 10 274069 Table
ple_avatar_categories 1 2 7 0 Table
subject_progress_temp 0 0 4 0 Table
phases_downloads 0 0 6 39 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 363681 Table

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

Master table for points
badge_user 0 0 11 18452108 Table

Keeps User Badges
centre_mqops_centre_visit 0 1 3 2327 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
learning_activities_temporary 0 0 30 648583 Table

Stores student learning activity
mqops_activity_trackers 0 0 183 8693 Table

Stores MQOPS Activity form Data
mqops_tot_states 0 0 5 79 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 2955 Table
phase_project 0 0 3 75 Table

Table to map Phases to project
roles 0 0 13 33 Table

Stores Roles
vacancy_trade 0 0 6 5481 Table
ple_career_paths 3 3 12 22 Table
placement_types 0 0 8 3 Table

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

Stores FAQs for LMS
design 0 0 2 6 Table
master_trainer_user 0 0 2 1374 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 439520 Table

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

Stores batches data
subject_trade_old 0 0 5 8820 Table
ple_assessment_response_keys 0 5 10 3019315 Table
mqops_tot_summary 0 0 31 197 Table
states 1 0 7 37 Table

Master table for States
mqops_principal_interaction_tracker 0 0 23 2 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 1568410 Table
approvals 0 0 10 5 Table

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

Users tagged to community comments
jobs 0 0 7 1808 Table

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

Master table for trades
vacancy_educational_qualification 0 0 4 717 Table

Stores educational qualification for vacancies(jobs)
mqops_educator_interaction_tracker 0 0 40 8 Table
courses 3 0 14 1560 Table

Stores Course Data
vacancy_field 0 0 6 2644 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
phase_users 0 4 7 538538 Table
community_user_actions 0 0 8 41508 Table

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

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

Stores program details
login_logs 0 0 8 1798753 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 5220955 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 1480197 Table

Stores lesson download details from mobile
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 59731 Table

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

Centres Mapped to Activity Tracker
leader_designation_mqops_activity_tracker 0 0 2 240 Table
learning_activity_responses 0 3 6 1363 Table
otps_old 0 0 9 263980 Table

stores generated otp according to request type
offerletter_status 0 0 6 3 Table

Master table of offer letter status
facilitator_lesson_progress 0 0 12 1253 Table

stores facilitator lesson progress
email_verify_records 0 0 4 16011 Table

store emails of user before verification.
google_meets 0 0 16 750 Table
activity_log 0 0 12 109031348 Table

Keeps Activity data
ple_guide_book_user 0 5 9 0 Table
phases 0 0 15 120 Table

Stores Phases details
mqops_session_trackers 0 0 119 3460 Table
ple_user_onboardings 0 4 21 160038 Table
organisation_program 0 0 6 1646 Table

Stores organisation program mapping
mqops_external_meeting_user 0 0 3 1029 Table

Stores users(Team Members) which is mapped to MQOPS external meeting form
lessons 0 0 32 16433 Table

Stores lesson data
community_comments 0 0 9 1526515 Table

Stores comments of community
placement_courses 0 1 7 5 Table

Master table for course dropdown in placement data
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 21398630 Table

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

Master table for lesson categories
centre_user 0 2 2 7559 Table

Superfacilitator centres
resource_categories 0 0 6 4 Table

Master table for resource categories
user_resources 0 0 9 188701 Table

Stores the clicks on external resource by users
mqops_activity_wfh_sector 0 0 2 23 Table
mqops_tot_objective_summary 0 0 2 447 Table
model_has_roles 0 0 5 806477 Table

Stores roles for each users
mqops_internal_meetings 0 0 12 1734 Table

Stores MQOPS internal Meeting form details
vacancies 0 0 32 2571 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 22470 Table

Projects mapped to centre
lesson_progress 0 0 12 304220 Table
language_lesson 0 0 9 20964 Table

Stores link for different languages of lessons
ple_content_ple_skill 0 2 2 6 Table
session_types 11 0 7 22 Table
ple_avatar_user 0 4 8 244228 Table
mqops_centrehead_interaction_tracker 0 0 22 0 Table
fields 0 0 7 95 Table

Job field Master Data
subject_trade 0 0 2 6179 Table
batch_community 0 0 2 3217819 Table
faq_categories 0 1 11 19 Table

STores FAQ Categories
centre_subject 0 2 5 427701 Table

Subjects mapped to centre
vacancy_types 0 0 7 7 Table

Master table for vacancy type.
personal_access_tokens 0 0 9 1029876 Table
google_refresh_tokens 0 0 4 0 Table
ple_skills 6 3 11 60 Table
user_recent_subjects 0 0 2 165054 Table

Stores recently accessed subjects by users
test_table 0 0 3 137472 Table
ple_job_cards 3 4 17 8009 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 110960 Table
phases_download_status 0 0 7 135 Table
centre_phase 0 1 6 7540 Table

Phase which is mapped to centre
ple_skill_user 0 4 8 578680 Table
users 42 0 49 1004546 Table

Stores users details
learning_activities 1 0 30 29175189 Table

Stores student learning activity
mqops_external_meetings 0 0 19 1283 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 4950845 Table

student course progress
ple_image_assets 0 3 14 9 Table
facilitator_details 0 0 12 33582 Table

Stores facilitator details
ple_assessments 2 3 13 51 Table
subject_ple_career_path 0 0 2 150 Table
mqops_tot_summary_centre 0 0 10 1114 Table
mqops_activity_typesold 0 0 6 23 Table

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

Tenant details
notifications 0 0 12 46030502 Table

Stores All Notifications
lesson_progress_18092023 0 0 12 1376 Table

Stores lesson progress of student
badges 0 2 14 589 Table

Stores badges data
projects 1 0 13 171 Table

Stores Project details
mqops_educator_interaction_topics 0 0 4 25 Table
phase_subject 0 2 3 59 Table
facilitator_learning_activities 0 0 27 442172 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 10 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
organisations 0 0 22 1501 Table

Stores Organisation data
subject_feedbacks 0 0 9 548043 Table

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

Stores Users tagged to a community
lesson_types 0 0 10 5 Table

Master table for lesson types
ple_job_card_user 0 4 9 1414412 Table
project_subject 0 0 4 1541 Table

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

Stores subject details
facilitator_subject_progress 0 0 11 46100 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 524293 Table

Direct Permissions for users
sidp_subjects 0 0 5 4128 Table
ple_content_card_ple_skill 0 2 2 347 Table
ple_job_card_career_path 0 4 8 8341 Table
ple_assessment_questions 2 6 17 1605 Table
batch_subject 0 2 3 1126274 Table

Subjects mapped to batches
mqops_student_interaction_tracker_details 0 0 11 14 Table
centre_trade_old 0 0 2 455544 Table
mqops_tot_summary_project 0 0 8 260 Table
community_users 0 0 9 225019 Table

Stores users tagged to a community
google_meet_records 0 0 6 142 Table
reports 0 0 31 18720 Table

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

Master Table for Sectors
course_progress_15092023 0 0 11 1607360 Table

student course progress
mqops_centre_visits 0 0 31 2109 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 929 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 6 0 Table
mqops_tot_types 0 0 2 16 Table
ple_career_path_user 0 4 9 140062 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 0 49 23017 Table

Stores Centre Data
communities 0 1 19 2926577 Table

Stores Commmunity Data
role_has_permissions 0 0 2 679 Table

Table to map permissions to roles
community_details 0 0 8 46990 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 921367 Table

Stores Student details
ple_contents 5 0 10 59 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 17 Table
user_programs 0 0 5 18022 Table
ple_career_path_texts 0 2 13 37 Table
profile_pics 0 0 5 10 Table

Master table for Profile Pics
report_comments 0 0 12 20288 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 238 Table
subject_progress_18092023 0 0 11 7140 Table

stores student subject progress
mqops_student_interaction_tracker 0 0 15 3 Table
mqops_documents 0 0 7 14946 Table

Used for storing mqops documents
lesson_progress_15092023 0 0 12 192708 Table

Stores lesson progress of student
placements 0 0 23 98401 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 107862 Table
learning_activities_sub 0 0 30 30831902 Table

Stores student learning activity
batches_non_ple 0 0 1 354 Table
mqops_lem_activities 0 0 4 16 Table
admin_mobile 0 1 7 276 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 124138 Table

facilitator course progress
educational_qualifications 0 1 7 7 Table

Master table for educational qualification
lessons_view 0 0 31 0 View
student_report_view 0 0 90 0 View
mqops_session_view 0 0 99 0 View
l_p_view 0 0 5 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
activity_log_view 0 0 14 0 View
batch_all_learners 0 0 41 0 View
centre_lesson_view 0 0 33 0 View
c_p_view 0 0 6 0 View
centre_subject_career_path_view 0 0 20 0 View
mqops_session_viewold 0 0 55 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
notification_not_send_view 0 0 12 0 View
s_p_view 0 0 6 0 View
centre_module_view 0 0 15 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
mqops_activity_view 0 0 193 0 View
centre_subject_view 0 0 18 0 View