SQLite Web: xiaohe.db

id

Primary key. TEXT

package_id

TEXT NOT NULL

topic_name

TEXT NOT NULL

priority

INTEGER (default 3

error_count

INTEGER (default 0

mastery

REAL (default 0

ai_content

[{"id":1,"type":"choice","question":"【语法入门】What color is the sky?","options":["A. Blue","B. Red","C. Green","D. Yellow"],"answer":"A","explain":"天空是蓝色的"},{"id":2,"type":"fill","question":"【语法入门】请拼写\"苹果\"___","answer":"apple","explain":"a-p-p-l-e"},{"id":3,"type":"choice","question":"【语法入门】\"I ___ a student.\" 选哪个？","options":["A. am","B. is","C. are","D. be"],"answer":"A","explain":"I 配 am"},{"id":4,"type":"fill","question":"【语法入门】How many legs does a cat have? ___, it has 4 legs.","answer":"Four","explain":"cat has four legs"},{"id":5,"type":"choice","question":"【语法入门】What's this? It's ___ apple.","options":["A. a","B. an","C. the","D. /"],"answer":"B","explain":"apple 以元音开头用 an"},{"id":6,"type":"fill","question":"【语法入门】\"猫\"的英文是___","answer":"cat","explain":"cat"},{"id":7,"type":"choice","question":"【语法入门】Which word means \"快乐\"?","options":["A. Happy","B. Sad","C. Angry","D. Tired"],"answer":"A","explain":"happy=快乐的"},{"id":8,"type":"fill","question":"【语法入门】\"Hello\"的中文意思是___","answer":"你好","explain":"Hello=你好"}]

TEXT (default '[]'

status

TEXT (default 'pending'

created_at

DATETIME (default datetime('now')

Update row rt_mqcbfpnkvesp in review_topics