all-project/backend/sql/test_audit_fields_fix.sql

-- 测试审核字段修复结果
USE hzdyjs_xg;

SELECT '=== 检查修复后的审核字段 ===' as message;

SELECT
    COLUMN_NAME as '字段名',
    DATA_TYPE as '数据类型',
    IS_NULLABLE as '允许NULL',
    COLUMN_DEFAULT as '默认值',
    COLUMN_COMMENT as '注释'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'hzdyjs_xg'
AND TABLE_NAME = 'jcbt_poverty_application'
AND COLUMN_NAME IN ('audit_time', 'audit_opinion', 'auditor_id', 'auditor_name')
ORDER BY COLUMN_NAME;

SELECT '=== 测试审核字段查询（模拟MyBatis-Plus查询）===' as message;

-- 模拟MyBatis-Plus的查询，包含所有字段
SELECT
    id, application_no, academic_year, term, student_id, student_no, student_name,
    gender, college_id, college_name, major_id, major_name, class_id, class_name,
    teacher_id, teacher_name, recognition_group, recognition_type_id, recognition_type_code,
    recognition_type_name, assistance_type_ids, assistance_type_names, family_economy_summary,
    attach_application_form_url, attach_application_form_id, attach_survey_form_url,
    attach_survey_form_id, status, submitter_id, submitter_name, submit_time,
    auditor_id, auditor_name, audit_time, audit_opinion, remark,
    deleted, create_dept, create_by, create_time, update_by, update_time
FROM jcbt_poverty_application
WHERE deleted = 0 AND tenant_id = '000000'
ORDER BY create_time DESC
LIMIT 1;

SELECT '✅ 测试完成！如果没有 Unknown column 错误，说明字段修复成功！' as result;