-- 检查成长记录表中的记录类型分布
SELECT 
    record_type,
    COUNT(*) as count,
    MIN(record_date) as earliest_date,
    MAX(record_date) as latest_date
FROM growth_record 
WHERE deleted = 0
GROUP BY record_type
ORDER BY record_type;

-- 查看最近的周反馈记录
SELECT 
    id,
    student_id,
    student_name,
    record_type,
    record_date,
    week_start_date,
    month_year,
    content,
    summary,
    status,
    create_time
FROM growth_record 
WHERE record_type = 'weekly' 
  AND deleted = 0
ORDER BY record_date DESC, create_time DESC
LIMIT 10;

-- 查看最近的日反馈记录
SELECT 
    id,
    student_id,
    student_name,
    record_type,
    record_date,
    content,
    status,
    create_time
FROM growth_record 
WHERE record_type = 'daily' 
  AND deleted = 0
ORDER BY record_date DESC, create_time DESC
LIMIT 10;
