SQLite Web: xiaohe.db

id

Primary key. TEXT

child_id

TEXT NOT NULL

package_id

TEXT

subject

TEXT NOT NULL

questions

[{"id":1,"type":"choice","question":"(语文模拟) 第1题：期末综合测试","options":["A. 选项A","B. 选项B","C. 选项C","D. 选项D"],"answer":"A","score":10,"explain":"语文基础知识考查。"},{"id":2,"type":"choice","question":"(语文模拟) 第2题：期末综合测试","options":["A. 选项A","B. 选项B","C. 选项C","D. 选项D"],"answer":"B","score":10,"explain":"语文基础知识考查。"},{"id":3,"type":"choice","question":"(语文模拟) 第3题：期末综合测试","options":["A. 选项A","B. 选项B","C. 选项C","D. 选项D"],"answer":"C","score":10,"explain":"语文基础知识考查。"},{"id":4,"type":"choice","question":"(语文模拟) 第4题：期末综合测试","options":["A. 选项A","B. 选项B","C. 选项C","D. 选项D"],"answer":"B","score":10,"explain":"语文基础知识考查。"},{"id":5,"type":"choice","question":"(语文模拟) 第5题：期末综合测试","options":["A. 选项A","B. 选项B","C. 选项C","D. 选项D"],"answer":"A","score":10,"explain":"语文基础知识考查。"},{"id":6,"type":"fill","question":"(语文模拟) 第6题：期末综合测试","answer":"C","score":10,"explain":"语文基础知识考查。"},{"id":7,"type":"fill","question":"(语文模拟) 第7题：期末综合测试","answer":"A","score":10,"explain":"语文基础知识考查。"},{"id":8,"type":"fill","question":"(语文模拟) 第8题：期末综合测试","answer":"B","score":10,"explain":"语文基础知识考查。"},{"id":9,"type":"fill","question":"(语文模拟) 第9题：期末综合测试","answer":"C","score":10,"explain":"语文基础知识考查。"},{"id":10,"type":"fill","question":"(语文模拟) 第10题：期末综合测试","answer":"B","score":10,"explain":"语文基础知识考查。"}]

TEXT (default '[]'

answers

TEXT (default '[]'

total_score

INTEGER (default 100

user_score

INTEGER (default 0

time_limit_min

INTEGER (default 15

used_seconds

INTEGER (default 0

status

TEXT (default 'pending'

created_at

DATETIME (default datetime('now')

updated_at

DATETIME (default datetime('now')

Update row me_mqcbfpnmckbf in mock_exams