28 lines
1.1 KiB
MySQL
28 lines
1.1 KiB
MySQL
|
-- 创建测试的周反馈记录
|
||
|
|
INSERT INTO growth_record (
|
||
|
|
teacher_id, student_id, student_name, record_type, record_date,
|
||
|
|
week_start_date, content, summary, status, create_time, update_time
|
||
|
|
) VALUES
|
||
|
|
(1, 1, '测试学生1', 'weekly', '2026-01-25', '2026-01-20',
|
||
|
|
'本周学生学习了数学和语文，整体表现良好。数学方面掌握了加减法运算，语文方面能够背诵古诗。建议继续加强练习。',
|
||
|
|
'本周学习总结：学生表现优秀，掌握了基本知识点，建议继续保持学习热情。', 1, NOW(), NOW()),
|
||
|
|
|
||
|
|
(2, 2, '测试学生2', 'weekly', '2026-01-25', '2026-01-20',
|
||
|
|
'本周主要学习了英语单词和基础语法，词汇量有所提升。建议多进行口语练习。',
|
||
|
|
'本周学习总结：英语学习进步明显，需要加强实际应用能力。', 1, NOW(), NOW());
|
||
|
|
|
||
|
|
-- 查看插入的周反馈记录
|
||
|
|
SELECT
|
||
|
|
id,
|
||
|
|
student_name,
|
||
|
|
record_type,
|
||
|
|
record_date,
|
||
|
|
week_start_date,
|
||
|
|
content,
|
||
|
|
summary,
|
||
|
|
status
|
||
|
|
FROM growth_record
|
||
|
|
WHERE record_type = 'weekly'
|
||
|
|
AND deleted = 0
|
||
|
|
ORDER BY record_date DESC;
|