Membaca existing upload EduSpark dari vericoac_portalacademy, menolak SDM/ISCA/BCM, membersihkan nama palsu seperti Student Name 142, lalu membuka report dari bridge yang benar.
Sync Existing Upload EduSparkList Report EduSparkOpen Existing UploadDaftar tabel kandidat existing upload. Klik Sync untuk menarik row siswa EduSpark.
| Table | Rows | Columns |
|---|---|---|
| assessment_batches | 6 | id, school_id, assessment_type, file_name, file_path, total_sheets, total_rows_read, total_students_saved, upload_status, uploaded_by_user_id, uploaded_at, created_at, updated_at |
| bs_student_domain_summary | 0 | id, student_id, domain_id, total_items, first_attempt_correct, total_attempts, avg_response_seconds, completion_rate, persistence_score, current_domain_score, trend_label, last_calculated_at |
| students | 528 | id, school_id, user_id, current_batch_id, student_code, full_name, class_name, grade_level, gender, assessment_type, dashboard_type, status, created_at, updated_at, school_code, school_key, school_prefix, school_name |
| student_assessments | 407 | id, student_id, batch_id, school_id, assessment_type, assessment_date, mbti_type, summary_text, raw_json, created_at, updated_at |
| student_assessment_scores | 2594 | id, student_assessment_id, score_key, score_value, score_label, sort_order, created_at |
| student_character_trainings | 0 | id, student_id, training_date, focus_value, activity_summary, reflection_note, score, teacher_note, created_at, updated_at |
| student_daily_trackers | 10 | id, student_id, school_id, class_name, tracker_date, discipline_1, discipline_2, discipline_3, discipline_4, focus_1, focus_2, focus_3, focus_4, responsibility_1, responsibility_2, responsibility_3, responsibility_4, character_1 |
| student_grit_trainings | 0 | id, student_id, training_date, challenge_focus, effort_summary, resilience_note, score, teacher_note, created_at, updated_at |
| student_import_logs | 24 | id, batch_id, sheet_name, row_number, row_data_json, status, message, created_at |
| student_weekly_trackers | 1 | id, student_id, school_id, class_name, week_label, average_daily_score, best_area, improvement_area, weekly_summary, next_week_target, teacher_note, created_at, updated_at |
| vegi_assessment_snapshots | 0 | id, child_id, source_session_id, me_score, ba_score, kl_score, di_score, an_score, ra_score, focus_score, fine_motor_score, eq_social_score, priority_areas_json, snapshot_note, created_at |
| verico_assessment_upload_batches | 48 | id, batch_name, assessment_type, test_round, test_label, school_id, school_name, file_name, total_rows, status, created_at, updated_at, assessment_domain |
| verico_assessment_upload_rows | 6432 | id, batch_id, school_id, school_name, student_id, student_code, student_name, class_name, grade_level, assessment_type, test_round, test_label, test_date, raw_json, status, created_at, updated_at, assessment_domain |
| verico_bcm_compare_result_v43 | 152 | id, student_code, student_name, school_name, class_name, assessment_date, test_round, ME, KL, BA, RA, DI, AN, quality_score, source_table, source_row_id, notes, raw_json |
| verico_bcm_dual_results_backup_v45 | 0 | id, student_code, student_name, school_name, class_name, assessment_date, test_round, ME, KL, BA, RA, DI, AN, average_score, notes, source_table, source_id, raw_json |
| verico_bcm_dual_results_backup_v46 | 112 | id, student_code, student_name, school_name, class_name, assessment_date, test_round, me, kl, ba, ra, di, an, average_score, notes, source_filename, row_hash, created_at |
| verico_bcm_dual_results_v45 | 0 | id, student_code, student_name, school_name, class_name, assessment_date, test_round, ME, KL, BA, RA, DI, AN, average_score, notes, source_table, source_id, raw_json |
| verico_bcm_dual_results_v46 | 0 | id, student_code, student_name, school_name, class_name, assessment_date, test_round, me, kl, ba, ra, di, an, average_score, notes, source_filename, row_hash, created_at |
| verico_bcm_dual_result_backup_v47 | 0 | id, student_code, student_name, school_name, class_name, assessment_date, test_round, me, kl, ba, ra, di, an, avg_score, notes, source_table, source_id, source_version |
| verico_bcm_dual_result_bridge_v47 | 135 | id, student_code, student_name, school_name, class_name, assessment_date, test_round, me, kl, ba, ra, di, an, avg_score, notes, source_table, source_id, source_version |
| verico_bcm_education_result_bridge_v32 | 1495 | id, product, student_id, student_name, student_code, class_name, school_name, assessment_date, area_scores_json, average_score, top_area, support_area, summary_text, recommendation_text, quality_score, source_table, source_id, raw_excerpt |
| verico_bcm_education_result_bridge_v33 | 479 | id, source_table, source_id, student_name, student_code, class_name, school_name, assessment_date, me, kl, ba, ra, di, an, average_score, strongest_area, priority_area, quality_score |
| verico_bcm_eduspark_extract_state_v32 | 2 | id, product, table_idx, offset_val, complete, last_table, last_message, updated_at, school_code, school_key, school_prefix, school_name, assigned_class, assigned_teacher_code, assigned_teacher_name, assigned_teacher_email, assigned_at |
| verico_bcm_student_tracker_v60 | 0 | id, student_code, product, tracker_type, tracker_date, area_key, activity_title, status, score, note, created_at, updated_at, school_code, school_key, school_prefix, school_name, assigned_class, assigned_teacher_code |
| verico_bcm_upload_skipped_v46 | 0 | id, uploaded_at, source_filename, line_no, reason, raw_line, school_code, school_key, school_prefix, school_name, assigned_class, assigned_teacher_code, assigned_teacher_name, assigned_teacher_email, assigned_at |
| verico_bcm_upload_skip_log_v47 | 0 | id, created_at, filename, row_no, reason, raw_row |
| verico_eduspark_active_backup_v66 | 0 | id, action_type, original_id, backup_json, created_at |
| verico_eduspark_active_result_v66 | 0 | id, batch_key, source_label, student_code, student_name, school_name, class_name, level_name, average_score, quality_score, payload_json, is_active, created_at, updated_at, school_code, school_key, school_prefix, assigned_class |
| verico_eduspark_clean_result_v69 | 0 | id, batch_code, product, level_name, is_active, student_code, student_name, class_name, school_name, assessment_date, average_score, payload_json, source_filename, created_at, updated_at, school_code, school_key, school_prefix |
| verico_eduspark_education_result_bridge_v32 | 146 | id, product, student_id, student_name, student_code, class_name, school_name, assessment_date, area_scores_json, average_score, top_area, support_area, summary_text, recommendation_text, quality_score, source_table, source_id, raw_excerpt |
| verico_eduspark_existing_result_bridge_v37 | 12 | id, source_table, source_id, upload_ref, student_id, student_code, student_name, class_name, school_name, assessment_date, area_json, average_score, quality, raw_ref, created_at, updated_at, school_code, school_key |
| verico_eduspark_manage_v74_backup | 54 | backup_id, source_table, source_id, backup_action, backup_at, row_json |
| verico_eduspark_sync_state_v37 | 2 | k, v, updated_at |
| verico_eduspark_upload_bridge_v52 | 0 | id, student_code, student_name, school_name, class_name, assessment_date, average_score, literacy_score, numeracy_score, reasoning_score, focus_score, discipline_score, learning_style, recommendation, notes, payload_json, created_at, updated_at |
| verico_exact_clean_results_v70 | 20 | id, batch_code, product, level_name, is_active, school_name, class_name, sheet_name, source_row, student_no, student_code, student_name, gender, age, iq, subject_recommendation, major_recommendation, personality_type |
| verico_exact_clean_upload_backup_v65 | 22 | backup_id, backup_reason, backup_at, original_id, product, level, upload_batch, sheet_name, row_no, no_col, student_name, gender, age_text, iq, subject_recommendation, major_recommendation, personality_type, data_json |
| verico_exact_clean_upload_v65 | 88 | id, product, level, upload_batch, sheet_name, row_no, no_col, student_name, gender, age_text, iq, subject_recommendation, major_recommendation, personality_type, data_json, extra_json, uploaded_at, school_code |
| verico_exact_result_v73 | 172 | id, product, level_name, batch_code, active, student_no, student_name, gender, age_text, iq, personality, rec_subject, rec_major, class_name, school_name, payload_json, source_file, created_at |
| verico_exact_resume_total_results_v74 | 0 | id, product, level_name, batch_code, active, row_no, student_no, fullname, class_name, birth_place, birth_date, age_text, iq_score, consistency, mbti_code, personality_type, subject_recommendation, major_recommendation |
| verico_existing_result_sync_logs | 81 | id, sync_code, source_table, product_type, scanned_rows, synced_rows, skipped_rows, notes, created_at |
| verico_isca_education_result_bridge | 12776 | id, source_table, source_id, product_type, student_code, student_name, school_name, class_name, assessment_date, mbti, iq, eq, aq, learning_style, dominant_intelligence, major_recommendation, career_recommendation, country_recommendation |
| verico_isca_education_result_bridge_v27 | 20304 | id, source_table, source_id, student_id, student_code, student_name, school_name, class_name, assessment_date, mbti_type, iq, eq, aq, learning_style, dominant_intelligence, major_recommendation, career_recommendation, country_recommendation |
| verico_isca_exact_result_v75 | 224 | id, product, level, upload_batch, student_key, full_name, class_name, age_text, personality_type, mbti_code, consistency, subject_recommendation, major_recommendation, positive_traits, negative_traits, aspiration, test_finished, payload_json |
| verico_isca_school_upload_backup_v90 | 0 | id, source_id, before_json, school_key, level, action_type, created_at |
| verico_practice_logs | 0 | id, user_id, module_id, self_score, reflection, status, created_at |
| verico_practice_modules | 14 | id, product_type, area_code, title, description, instruction_text, expected_output, level_label, level_order, duration_minutes, is_active, created_at |
| verico_product_result_index | 1132 | id, product_type, student_code, fullname, school_name, class_name, assessment_date, mbti, iq, eq, aq, career_recommendation, major_recommendation, country_recommendation, score_summary, payload_json, source_file, source_batch |
| verico_product_upload_batches | 10 | id, batch_code, product_type, original_file, stored_file, total_rows, imported_rows, skipped_rows, status, notes, created_at |
| verico_student_assessment_bridge | 0 | id, assessment_type, source_db, source_table, source_pk, user_id, student_code, student_name, email, class_name, school_name, mbti, iq, eq, aq, raw_json, source_updated_at, synced_at |
| verico_student_assignment_v103 | 291 | id, student_code, student_name, school_code, school_key, school_prefix, school_name, class_name, teacher_code, teacher_name, teacher_email, source_product, source_table, source_id, created_at, updated_at, assigned_class, assigned_teacher_code |
| verico_student_feature_access | 505 | id, user_id, product_type, can_open, can_list_report, can_upload_result, can_compare_history, source, created_at |
| verico_student_journey_manage_backup_v42 | 63 | backup_id, action_name, source_product, source_table, source_id, target_product, target_table, row_json, admin_note, created_at, ip_address |
| verico_student_journey_report_bridge_v35 | 3810 | id, product, source_table, source_id, student_name, student_code, class_name, school_name, assessment_date, area_json, payload_json, quality_score, report_url, created_at, updated_at, school_code, school_key, school_prefix |
| verico_student_result_upload_v61 | 0 | id, product, level, student_code, student_name, gender, age, school_name, class_name, assessment_date, iq, personality_type, recommendation_subjects, recommendation_major, verbal, numerik, skolastik, abstrak |
| verico_student_tracker_action_v64 | 0 | id, product, level, student_code, student_name, school_name, class_name, tracker_date, focus_area, focus_label, action_title, action_note, status, score, reflection, created_at, updated_at, school_code |
| verico_student_tracker_goal_v64 | 18 | id, product, level, area_code, area_label, action_1, action_2, action_3, parent_tip, teacher_tip, created_at |
| verico_student_tracker_v61 | 0 | id, product, level, student_code, student_name, tracker_type, tracker_date, week_start, focus_area, task_1, status_1, task_2, status_2, task_3, status_3, reflection, parent_note, teacher_note |
| verico_student_users_v82 | 0 | id, school_name, school_key, student_code, full_name, class_name, user_id, password_hash, password_plain_initial, products, is_active, last_login_at, created_at, updated_at, school_code, school_prefix, assigned_class, assigned_teacher_code |
| vgi_practice_recommendations | 0 | id, student_ref, product, area, recommendation_title, recommendation_detail, priority, status, created_at, updated_at |
| vgi_student_profiles | 0 | id, student_ref, product, student_name, school_name, class_name, grade_level, mbti, dominant_talent, learning_style, current_phase, status, created_at, updated_at |
| vmc_results | 1 | id, session_id, engine_score_json, top_major_json, confidence_score, risk_alert, created_at |
| vmc_students | 5 | id, student_code, student_name, school_name, grade, created_at, school_code, school_key, school_prefix, assigned_class, assigned_teacher_code, assigned_teacher_name, assigned_teacher_email, assigned_at |
| vpb_260913121203_vmc_results | 1 | id, session_id, engine_score_json, top_major_json, confidence_score, risk_alert, created_at |
| vpb_260913121203_vmc_students | 2 | id, student_code, student_name, school_name, grade, created_at, school_code, school_key, school_prefix, assigned_class, assigned_teacher_code, assigned_teacher_name, assigned_teacher_email, assigned_at |