{"table_name":"dp_lms_courses","full_table_name":"wp_dp_lms_courses","description":"Stores dp lms courses data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_dp_lms_courses ( id bigint(20) NOT NULL AUTO_INCREMENT, title varchar(255) NOT NULL, slug varchar(255) NOT NULL, category bigint(20) NOT NULL, teacher_id bigint(20) NOT NULL, course_description text DEFAULT NULL, available_date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, enrollment_deadline datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, duration_days int(11) DEFAULT 0 NOT NULL, PRIMARY KEY (id), UNIQUE KEY slug (slug) ) $charset_collate;\", \"CREATE TABLE wp_dp_lms_audit_log ( id bigint(20) NOT NULL AUTO_INCREMENT, user_id bigint(20) NOT NULL, action varchar(100) NOT NULL, details text NOT NULL, recorded_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id) ) $charset_collate;\", \"CREATE TABLE wp_dp_lms_categories ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(100) NOT NULL, slug varchar(200) NOT NULL, parent_id int(11) DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY slug (slug) ) $charset_collate;\", \"CREATE TABLE wp_dp_lms_modules ( id bigint(20) NOT NULL AUTO_INCREMENT, course_id bigint(20) NOT NULL, title varchar(255) NOT NULL, slug varchar(200) DEFAULT NULL, type varchar(50) NOT NULL DEFAULT 'document', url text DEFAULT NULL, content longtext DEFAULT NULL, sort_order int(11) DEFAULT 0, PRIMARY KEY (id), KEY course_id (course_id) ) $charset_collate;\", \"CREATE TABLE wp_dp_lms_enrollments ( id bigint(20) NOT NULL AUTO_INCREMENT, course_id bigint(20) NOT NULL, student_id bigint(20) NOT NULL, enrolled_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, progress_percentage int(11) DEFAULT 0, cert_id varchar(12) DEFAULT NULL, status varchar(20) DEFAULT 'active' NOT NULL, PRIMARY KEY (id), UNIQUE KEY course_student (course_id, student_id), KEY idx_status (status) ) $charset_collate;\", \"CREATE TABLE wp_dp_lms_progress_history ( id bigint(20) NOT NULL AUTO_INCREMENT, student_id bigint(20) NOT NULL, course_id bigint(20) NOT NULL, item_id bigint(20) NOT NULL, item_type varchar(50) NOT NULL DEFAULT 'module', completed_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id), KEY idx_student_course (student_id, course_id) ) $charset_collate;\", \"CREATE TABLE wp_dp_lms_grades ( id bigint(20) NOT NULL AUTO_INCREMENT, student_id bigint(20) NOT NULL, module_id bigint(20) NOT NULL, grade int(11) DEFAULT 0, graded_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id), UNIQUE KEY student_module (student_id, module_id) ) $charset_collate;\", \"CREATE TABLE wp_dp_lms_questions ( id bigint(20) NOT NULL AUTO_INCREMENT, module_id bigint(20) NOT NULL, question_text text NOT NULL, question_type varchar(50) NOT NULL, options text DEFAULT NULL, correct_answer varchar(255) NOT NULL, PRIMARY KEY (id), KEY module_id (module_id) ) $charset_collate;\", \"CREATE TABLE wp_dp_lms_quiz_submissions ( id bigint(20) NOT NULL AUTO_INCREMENT, student_id bigint(20) NOT NULL, module_id bigint(20) NOT NULL, responses longtext DEFAULT NULL, status varchar(50) DEFAULT 'pending', submitted_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id) ) $charset_collate;\", );","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"slug","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"category","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"teacher_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"course_description","type":"text","nullable":true,"primary_key":false},{"name":"available_date","type":"datetime","nullable":false,"primary_key":false},{"name":"enrollment_deadline","type":"datetime","nullable":false,"primary_key":false},{"name":"duration_days","type":"int(11)","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"action","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"details","type":"text","nullable":false,"primary_key":false},{"name":"recorded_at","type":"datetime","nullable":false,"primary_key":false},{"name":"name","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"slug","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"parent_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"course_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"slug","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"url","type":"text","nullable":true,"primary_key":false},{"name":"content","type":"longtext","nullable":true,"primary_key":false},{"name":"sort_order","type":"int(11)","nullable":true,"primary_key":false},{"name":"course_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"student_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"enrolled_at","type":"datetime","nullable":false,"primary_key":false},{"name":"progress_percentage","type":"int(11)","nullable":true,"primary_key":false},{"name":"cert_id","type":"varchar(12)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"student_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"course_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"item_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"item_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"completed_at","type":"datetime","nullable":false,"primary_key":false},{"name":"student_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"module_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"grade","type":"int(11)","nullable":true,"primary_key":false},{"name":"graded_at","type":"datetime","nullable":false,"primary_key":false},{"name":"module_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"question_text","type":"text","nullable":false,"primary_key":false},{"name":"question_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"options","type":"text","nullable":true,"primary_key":false},{"name":"correct_answer","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"student_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"module_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"responses","type":"longtext","nullable":true,"primary_key":false},{"name":"status","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"submitted_at","type":"datetime","nullable":false,"primary_key":false}],"plugin":{"slug":"voltora-academy-for-divi","name":"Voltora Academy for Divi","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/voltora-academy-for-divi/"}}