jacobxu666andClaude Opus 4.8
6ed4d5a61e
- 全站按 Corporate Trust 设计规范重做:靛蓝/紫罗兰渐变、Plus Jakarta Sans 自托管字体、带色阴影、卡片悬浮、氛围光斑 - 打卡任务增加科目分类(语文/数学/英语/运动/其他),孩子端按科目分组 - 英语语法自学模块:线性解锁课程 + 课后/周/月测验引擎,测验达标 自动联动当日英语打卡;家长概览显示语法进度 - 课程内容:A1→B1 完整大纲,9 周 54 课 + 9 周测 + 2 月测,讲解/例句/ 练习/测验均原创,仅参考两份语法书的主题编排 Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
12 lines
572 B
SQL
12 lines
572 B
SQL
CREATE TABLE `grammar_progress` (
|
|
`id` bigint AUTO_INCREMENT NOT NULL,
|
|
`child_user_id` bigint NOT NULL,
|
|
`seq` int NOT NULL,
|
|
`score` int,
|
|
`passed` boolean NOT NULL DEFAULT false,
|
|
`completed_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
CONSTRAINT `grammar_progress_id` PRIMARY KEY(`id`),
|
|
CONSTRAINT `uq_grammar_child_seq` UNIQUE(`child_user_id`,`seq`)
|
|
);
|
|
--> statement-breakpoint
|
|
ALTER TABLE `grammar_progress` ADD CONSTRAINT `grammar_progress_child_user_id_user_id_fk` FOREIGN KEY (`child_user_id`) REFERENCES `user`(`id`) ON DELETE cascade ON UPDATE no action; |