Add Column
Current Schema
CREATE TABLE item_submissions (
id TEXT PRIMARY KEY,
item_id TEXT NOT NULL REFERENCES assignment_items(id) ON DELETE CASCADE,
assignment_id TEXT NOT NULL,
child_id TEXT NOT NULL,
content TEXT DEFAULT '',
media_urls TEXT DEFAULT '[]',
-- JSON数组: 提交图片/语音URL列表
ocr_text TEXT DEFAULT '',
ai_comment TEXT DEFAULT '',
score INTEGER,
total_score INTEGER DEFAULT 100,
ai_pipeline TEXT CHECK(ai_pipeline IN
('ocr_correction','copy_check','recite_check','dictation_check','manual')),
status TEXT DEFAULT 'submitted'
CHECK(status IN ('submitted','corrected')),
corrected_at DATETIME,
created_at DATETIME DEFAULT (datetime('now')),
updated_at DATETIME DEFAULT (datetime('now'))
)