-
Notifications
You must be signed in to change notification settings - Fork 558
/
Copy pathdatabase.html
33 lines (33 loc) · 28.7 KB
/
database.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width,initial-scale=1">
<meta name="generator" content="VuePress 2.0.0-beta.51">
<style>
:root {
--c-bg: #fff;
}
html.dark {
--c-bg: #22272e;
}
html, body {
background-color: var(--c-bg);
}
</style>
<script>
const userMode = localStorage.getItem('vuepress-color-scheme');
const systemDarkMode = window.matchMedia && window.matchMedia('(prefers-color-scheme: dark)').matches;
if (userMode === 'dark' || (userMode !== 'light' && systemDarkMode)) {
document.documentElement.classList.toggle('dark', true);
}
</script>
<title>3. 数据库设计 | 学之思教程</title><meta name="description" content="学之思开发部署教程">
<link rel="modulepreload" href="/assets/app.7283597e.js"><link rel="modulepreload" href="/assets/database.html.20fd1a63.js"><link rel="modulepreload" href="/assets/database.html.d0f44a34.js"><link rel="prefetch" href="/assets/index.html.69524544.js"><link rel="prefetch" href="/assets/admin.html.95aff702.js"><link rel="prefetch" href="/assets/deploy.html.3556abb5.js"><link rel="prefetch" href="/assets/develop.html.fbedd315.js"><link rel="prefetch" href="/assets/feature.html.261d99f8.js"><link rel="prefetch" href="/assets/skill.html.a2155b8b.js"><link rel="prefetch" href="/assets/student.html.e082e38b.js"><link rel="prefetch" href="/assets/video.html.223c0851.js"><link rel="prefetch" href="/assets/wx.html.0df5ac91.js"><link rel="prefetch" href="/assets/404.html.c3e557d0.js"><link rel="prefetch" href="/assets/index.html.4d6ac695.js"><link rel="prefetch" href="/assets/admin.html.df216157.js"><link rel="prefetch" href="/assets/deploy.html.8a80818e.js"><link rel="prefetch" href="/assets/develop.html.b900f402.js"><link rel="prefetch" href="/assets/feature.html.352ca34b.js"><link rel="prefetch" href="/assets/skill.html.afe14bdd.js"><link rel="prefetch" href="/assets/student.html.c0cacfdd.js"><link rel="prefetch" href="/assets/video.html.0afa18fc.js"><link rel="prefetch" href="/assets/wx.html.a1b312cc.js"><link rel="prefetch" href="/assets/404.html.eb5dc5c7.js">
<link rel="stylesheet" href="/assets/style.e2da3676.css">
</head>
<body>
<div id="app"><!--[--><div class="theme-container"><!--[--><header class="navbar"><div class="toggle-sidebar-button" title="toggle sidebar" aria-expanded="false" role="button" tabindex="0"><div class="icon" aria-hidden="true"><span></span><span></span><span></span></div></div><span><a href="/" class=""><img class="logo" src="https://www.mindskip.net/style/git/images/logo/logo.png" alt="学之思教程"><span class="site-name can-hide">学之思教程</span></a></span><div class="navbar-items-wrapper" style=""><!--[--><!--]--><nav class="navbar-items can-hide"><!--[--><div class="navbar-item"><a class="external-link" href="https://www.mindskip.net" rel="noopener noreferrer" target="_blank" aria-label="官网"><!--[--><!--]--> 官网 <span><svg class="external-link-icon" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewbox="0 0 100 100" width="15" height="15"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path><polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg><span class="external-link-icon-sr-only">open in new window</span></span><!--[--><!--]--></a></div><div class="navbar-item"><a class="external-link" href="https://www.mindskip.net/sdd.html" rel="noopener noreferrer" target="_blank" aria-label="思多多"><!--[--><!--]--> 思多多 <span><svg class="external-link-icon" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewbox="0 0 100 100" width="15" height="15"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path><polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg><span class="external-link-icon-sr-only">open in new window</span></span><!--[--><!--]--></a></div><div class="navbar-item"><a class="external-link" href="https://www.mindskip.net/wdd.html" rel="noopener noreferrer" target="_blank" aria-label="维多多"><!--[--><!--]--> 维多多 <span><svg class="external-link-icon" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewbox="0 0 100 100" width="15" height="15"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path><polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg><span class="external-link-icon-sr-only">open in new window</span></span><!--[--><!--]--></a></div><div class="navbar-item"><a class="external-link" href="https://www.mindskip.net/xzs.html" rel="noopener noreferrer" target="_blank" aria-label="学之思"><!--[--><!--]--> 学之思 <span><svg class="external-link-icon" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewbox="0 0 100 100" width="15" height="15"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path><polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg><span class="external-link-icon-sr-only">open in new window</span></span><!--[--><!--]--></a></div><div class="navbar-item"><a class="external-link" href="https://www.mindskip.net/buy.html" rel="noopener noreferrer" target="_blank" aria-label="商业购买"><!--[--><!--]--> 商业购买 <span><svg class="external-link-icon" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewbox="0 0 100 100" width="15" height="15"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path><polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg><span class="external-link-icon-sr-only">open in new window</span></span><!--[--><!--]--></a></div><!--]--></nav><!--[--><!--]--><button class="toggle-color-mode-button" title="toggle color mode"><svg style="" class="icon" focusable="false" viewBox="0 0 32 32"><path d="M16 12.005a4 4 0 1 1-4 4a4.005 4.005 0 0 1 4-4m0-2a6 6 0 1 0 6 6a6 6 0 0 0-6-6z" fill="currentColor"></path><path d="M5.394 6.813l1.414-1.415l3.506 3.506L8.9 10.318z" fill="currentColor"></path><path d="M2 15.005h5v2H2z" fill="currentColor"></path><path d="M5.394 25.197L8.9 21.691l1.414 1.415l-3.506 3.505z" fill="currentColor"></path><path d="M15 25.005h2v5h-2z" fill="currentColor"></path><path d="M21.687 23.106l1.414-1.415l3.506 3.506l-1.414 1.414z" fill="currentColor"></path><path d="M25 15.005h5v2h-5z" fill="currentColor"></path><path d="M21.687 8.904l3.506-3.506l1.414 1.415l-3.506 3.505z" fill="currentColor"></path><path d="M15 2.005h2v5h-2z" fill="currentColor"></path></svg><svg style="display:none;" class="icon" focusable="false" viewBox="0 0 32 32"><path d="M13.502 5.414a15.075 15.075 0 0 0 11.594 18.194a11.113 11.113 0 0 1-7.975 3.39c-.138 0-.278.005-.418 0a11.094 11.094 0 0 1-3.2-21.584M14.98 3a1.002 1.002 0 0 0-.175.016a13.096 13.096 0 0 0 1.825 25.981c.164.006.328 0 .49 0a13.072 13.072 0 0 0 10.703-5.555a1.01 1.01 0 0 0-.783-1.565A13.08 13.08 0 0 1 15.89 4.38A1.015 1.015 0 0 0 14.98 3z" fill="currentColor"></path></svg></button><!----></div></header><!--]--><div class="sidebar-mask"></div><!--[--><aside class="sidebar"><nav class="navbar-items"><!--[--><div class="navbar-item"><a class="external-link" href="https://www.mindskip.net" rel="noopener noreferrer" target="_blank" aria-label="官网"><!--[--><!--]--> 官网 <span><svg class="external-link-icon" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewbox="0 0 100 100" width="15" height="15"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path><polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg><span class="external-link-icon-sr-only">open in new window</span></span><!--[--><!--]--></a></div><div class="navbar-item"><a class="external-link" href="https://www.mindskip.net/sdd.html" rel="noopener noreferrer" target="_blank" aria-label="思多多"><!--[--><!--]--> 思多多 <span><svg class="external-link-icon" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewbox="0 0 100 100" width="15" height="15"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path><polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg><span class="external-link-icon-sr-only">open in new window</span></span><!--[--><!--]--></a></div><div class="navbar-item"><a class="external-link" href="https://www.mindskip.net/wdd.html" rel="noopener noreferrer" target="_blank" aria-label="维多多"><!--[--><!--]--> 维多多 <span><svg class="external-link-icon" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewbox="0 0 100 100" width="15" height="15"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path><polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg><span class="external-link-icon-sr-only">open in new window</span></span><!--[--><!--]--></a></div><div class="navbar-item"><a class="external-link" href="https://www.mindskip.net/xzs.html" rel="noopener noreferrer" target="_blank" aria-label="学之思"><!--[--><!--]--> 学之思 <span><svg class="external-link-icon" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewbox="0 0 100 100" width="15" height="15"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path><polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg><span class="external-link-icon-sr-only">open in new window</span></span><!--[--><!--]--></a></div><div class="navbar-item"><a class="external-link" href="https://www.mindskip.net/buy.html" rel="noopener noreferrer" target="_blank" aria-label="商业购买"><!--[--><!--]--> 商业购买 <span><svg class="external-link-icon" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" focusable="false" x="0px" y="0px" viewbox="0 0 100 100" width="15" height="15"><path fill="currentColor" d="M18.8,85.1h56l0,0c2.2,0,4-1.8,4-4v-32h-8v28h-48v-48h28v-8h-32l0,0c-2.2,0-4,1.8-4,4v56C14.8,83.3,16.6,85.1,18.8,85.1z"></path><polygon fill="currentColor" points="45.7,48.7 51.3,54.3 77.2,28.5 77.2,37.2 85.2,37.2 85.2,14.9 62.8,14.9 62.8,22.9 71.5,22.9"></polygon></svg><span class="external-link-icon-sr-only">open in new window</span></span><!--[--><!--]--></a></div><!--]--></nav><!--[--><!--]--><ul class="sidebar-items"><!--[--><li><p tabindex="0" class="sidebar-item sidebar-heading active"> <!----></p><ul style="" class="sidebar-item-children"><!--[--><li><a href="/guide/feature.html" class="sidebar-item" aria-label="1. 功能列表"><!--[--><!--]--> 1. 功能列表 <!--[--><!--]--></a><!----></li><li><a href="/guide/skill.html" class="sidebar-item" aria-label="2. 技术栈"><!--[--><!--]--> 2. 技术栈 <!--[--><!--]--></a><!----></li><li><a aria-current="page" href="/guide/database.html" class="router-link-active router-link-exact-active router-link-active sidebar-item active" aria-label="3. 数据库设计"><!--[--><!--]--> 3. 数据库设计 <!--[--><!--]--></a><ul style="" class="sidebar-item-children"><!--[--><li><a aria-current="page" href="/guide/database.html#_3-1-试卷表" class="router-link-active router-link-exact-active sidebar-item" aria-label="3.1 试卷表"><!--[--><!--]--> 3.1 试卷表 <!--[--><!--]--></a><!----></li><li><a aria-current="page" href="/guide/database.html#_3-2-试卷答案表" class="router-link-active router-link-exact-active sidebar-item" aria-label="3.2 试卷答案表"><!--[--><!--]--> 3.2 试卷答案表 <!--[--><!--]--></a><!----></li><li><a aria-current="page" href="/guide/database.html#_3-3-试卷题目答案表" class="router-link-active router-link-exact-active sidebar-item" aria-label="3.3 试卷题目答案表"><!--[--><!--]--> 3.3 试卷题目答案表 <!--[--><!--]--></a><!----></li><li><a aria-current="page" href="/guide/database.html#_3-4-消息表" class="router-link-active router-link-exact-active sidebar-item" aria-label="3.4 消息表"><!--[--><!--]--> 3.4 消息表 <!--[--><!--]--></a><!----></li><li><a aria-current="page" href="/guide/database.html#_3-5-用户消息表" class="router-link-active router-link-exact-active sidebar-item" aria-label="3.5 用户消息表"><!--[--><!--]--> 3.5 用户消息表 <!--[--><!--]--></a><!----></li><li><a aria-current="page" href="/guide/database.html#_3-6-题目表" class="router-link-active router-link-exact-active sidebar-item" aria-label="3.6 题目表"><!--[--><!--]--> 3.6 题目表 <!--[--><!--]--></a><!----></li><li><a aria-current="page" href="/guide/database.html#_3-7-学科表" class="router-link-active router-link-exact-active sidebar-item" aria-label="3.7 学科表"><!--[--><!--]--> 3.7 学科表 <!--[--><!--]--></a><!----></li><li><a aria-current="page" href="/guide/database.html#_3-8-任务表" class="router-link-active router-link-exact-active sidebar-item" aria-label="3.8 任务表"><!--[--><!--]--> 3.8 任务表 <!--[--><!--]--></a><!----></li><li><a aria-current="page" href="/guide/database.html#_3-9-用户任务表" class="router-link-active router-link-exact-active sidebar-item" aria-label="3.9 用户任务表"><!--[--><!--]--> 3.9 用户任务表 <!--[--><!--]--></a><!----></li><li><a aria-current="page" href="/guide/database.html#_3-10-文本表" class="router-link-active router-link-exact-active sidebar-item" aria-label="3.10 文本表"><!--[--><!--]--> 3.10 文本表 <!--[--><!--]--></a><!----></li><li><a aria-current="page" href="/guide/database.html#_3-11-用户表" class="router-link-active router-link-exact-active sidebar-item" aria-label="3.11 用户表"><!--[--><!--]--> 3.11 用户表 <!--[--><!--]--></a><!----></li><li><a aria-current="page" href="/guide/database.html#_3-12-用户日志表" class="router-link-active router-link-exact-active sidebar-item" aria-label="3.12 用户日志表"><!--[--><!--]--> 3.12 用户日志表 <!--[--><!--]--></a><!----></li><li><a aria-current="page" href="/guide/database.html#_3-13-用户token表" class="router-link-active router-link-exact-active sidebar-item" aria-label="3.13 用户Token表"><!--[--><!--]--> 3.13 用户Token表 <!--[--><!--]--></a><!----></li><!--]--></ul></li><li><p tabindex="0" class="sidebar-item">4. 接口文档 <!----></p><ul style="" class="sidebar-item-children"><!--[--><li><a href="/guide/student.html" class="sidebar-item" aria-label="4.1 学生端"><!--[--><!--]--> 4.1 学生端 <!--[--><!--]--></a><!----></li><li><a href="/guide/wx.html" class="sidebar-item" aria-label="4.2 小程序"><!--[--><!--]--> 4.2 小程序 <!--[--><!--]--></a><!----></li><li><a href="/guide/admin.html" class="sidebar-item" aria-label="4.3 管理端"><!--[--><!--]--> 4.3 管理端 <!--[--><!--]--></a><!----></li><!--]--></ul></li><li><a href="/guide/develop.html" class="sidebar-item" aria-label="5. 项目开发"><!--[--><!--]--> 5. 项目开发 <!--[--><!--]--></a><!----></li><li><a href="/guide/deploy.html" class="sidebar-item" aria-label="6. 项目部署"><!--[--><!--]--> 6. 项目部署 <!--[--><!--]--></a><!----></li><li><a href="/guide/video.html" class="sidebar-item" aria-label="7. 视频教程"><!--[--><!--]--> 7. 视频教程 <!--[--><!--]--></a><!----></li><!--]--></ul></li><!--]--></ul><!--[--><!--]--></aside><!--]--><!--[--><main class="page"><!--[--><!--]--><div class="theme-default-content"><!--[--><!--]--><div><h1 id="_3-数据库设计" tabindex="-1"><a class="header-anchor" href="#_3-数据库设计" aria-hidden="true">#</a> 3. 数据库设计</h1><h3 id="_3-1-试卷表" tabindex="-1"><a class="header-anchor" href="#_3-1-试卷表" aria-hidden="true">#</a> 3.1 试卷表</h3><ul><li>表名：t_exam_paper</li><li>字段注释：</li></ul><table><thead><tr><th>字段名</th><th>类型</th><th>注释</th></tr></thead><tbody><tr><td>id</td><td>int</td><td></td></tr><tr><td>name</td><td>varchar</td><td>试卷名称</td></tr><tr><td>subject_id</td><td>int</td><td>学科</td></tr><tr><td>paper_type</td><td>int</td><td>试卷类型( 1.固定试卷 4.时段试卷 6.任务试卷 )</td></tr><tr><td>grade_level</td><td>int</td><td>年级</td></tr><tr><td>score</td><td>int</td><td>试卷总分(千分制)</td></tr><tr><td>question_count</td><td>int</td><td>题目数量</td></tr><tr><td>suggest_time</td><td>int</td><td>建议时长(分钟)</td></tr><tr><td>limit_start_time</td><td>datetime</td><td>时段试卷 开始时间</td></tr><tr><td>limit_end_time</td><td>datetime</td><td>时段试卷 结束时间</td></tr><tr><td>frame_text_content_id</td><td>int</td><td>试卷框架 内容为JSON</td></tr><tr><td>create_user</td><td>int</td><td></td></tr><tr><td>create_time</td><td>datetime</td><td></td></tr><tr><td>deleted</td><td>bit</td><td></td></tr><tr><td>task_exam_id</td><td>int</td><td></td></tr></tbody></table><h3 id="_3-2-试卷答案表" tabindex="-1"><a class="header-anchor" href="#_3-2-试卷答案表" aria-hidden="true">#</a> 3.2 试卷答案表</h3><ul><li>表名：t_exam_paper_answer</li><li>字段注释：</li></ul><table><thead><tr><th>字段名</th><th>类型</th><th>注释</th></tr></thead><tbody><tr><td>id</td><td>int</td><td></td></tr><tr><td>exam_paper_id</td><td>int</td><td></td></tr><tr><td>paper_name</td><td>varchar</td><td>试卷名称</td></tr><tr><td>paper_type</td><td>int</td><td>试卷类型( 1.固定试卷 4.时段试卷 6.任务试卷 )</td></tr><tr><td>subject_id</td><td>int</td><td>学科</td></tr><tr><td>system_score</td><td>int</td><td>系统判定得分</td></tr><tr><td>user_score</td><td>int</td><td>最终得分(千分制)</td></tr><tr><td>paper_score</td><td>int</td><td>试卷总分</td></tr><tr><td>question_correct</td><td>int</td><td>做对题目数量</td></tr><tr><td>question_count</td><td>int</td><td>题目总数量</td></tr><tr><td>do_time</td><td>int</td><td>做题时间(秒)</td></tr><tr><td>status</td><td>int</td><td>试卷状态(1待判分 2完成)</td></tr><tr><td>create_user</td><td>int</td><td>学生</td></tr><tr><td>create_time</td><td>datetime</td><td>提交时间</td></tr><tr><td>task_exam_id</td><td>int</td><td></td></tr></tbody></table><h3 id="_3-3-试卷题目答案表" tabindex="-1"><a class="header-anchor" href="#_3-3-试卷题目答案表" aria-hidden="true">#</a> 3.3 试卷题目答案表</h3><ul><li>表名：t_exam_paper_question_customer_answer</li><li>字段注释：</li></ul><table><thead><tr><th>字段名</th><th>类型</th><th>注释</th></tr></thead><tbody><tr><td>id</td><td>int</td><td></td></tr><tr><td>question_id</td><td>int</td><td>题目Id</td></tr><tr><td>exam_paper_id</td><td>int</td><td>答案Id</td></tr><tr><td>exam_paper_answer_id</td><td>int</td><td></td></tr><tr><td>question_type</td><td>int</td><td>题型</td></tr><tr><td>subject_id</td><td>int</td><td>学科</td></tr><tr><td>customer_score</td><td>int</td><td>得分</td></tr><tr><td>question_score</td><td>int</td><td>题目原始分数</td></tr><tr><td>question_text_content_id</td><td>int</td><td>问题内容</td></tr><tr><td>answer</td><td>varchar</td><td>做题答案</td></tr><tr><td>text_content_id</td><td>int</td><td>做题内容</td></tr><tr><td>do_right</td><td>bit</td><td>是否正确</td></tr><tr><td>create_user</td><td>int</td><td>做题人</td></tr><tr><td>create_time</td><td>datetime</td><td></td></tr><tr><td>item_order</td><td>int</td><td></td></tr></tbody></table><h3 id="_3-4-消息表" tabindex="-1"><a class="header-anchor" href="#_3-4-消息表" aria-hidden="true">#</a> 3.4 消息表</h3><ul><li>表名：t_message</li><li>字段注释：</li></ul><table><thead><tr><th>字段名</th><th>类型</th><th>注释</th></tr></thead><tbody><tr><td>id</td><td>int</td><td></td></tr><tr><td>title</td><td>varchar</td><td>标题</td></tr><tr><td>content</td><td>varchar</td><td>内容</td></tr><tr><td>create_time</td><td>datetime</td><td></td></tr><tr><td>send_user_id</td><td>int</td><td>发送者用户ID</td></tr><tr><td>send_user_name</td><td>varchar</td><td>发送者用户名</td></tr><tr><td>send_real_name</td><td>varchar</td><td>发送者真实姓名</td></tr><tr><td>receive_user_count</td><td>int</td><td>接收人数</td></tr><tr><td>read_count</td><td>int</td><td>已读人数</td></tr></tbody></table><h3 id="_3-5-用户消息表" tabindex="-1"><a class="header-anchor" href="#_3-5-用户消息表" aria-hidden="true">#</a> 3.5 用户消息表</h3><ul><li>表名：t_message_user</li><li>字段注释：</li></ul><table><thead><tr><th>字段名</th><th>类型</th><th>注释</th></tr></thead><tbody><tr><td>id</td><td>int</td><td></td></tr><tr><td>message_id</td><td>int</td><td>消息内容ID</td></tr><tr><td>receive_user_id</td><td>int</td><td>接收人ID</td></tr><tr><td>receive_user_name</td><td>varchar</td><td>接收人用户名</td></tr><tr><td>receive_real_name</td><td>varchar</td><td>接收人真实姓名</td></tr><tr><td>readed</td><td>bit</td><td>是否已读</td></tr><tr><td>create_time</td><td>datetime</td><td></td></tr><tr><td>read_time</td><td>datetime</td><td>阅读时间</td></tr></tbody></table><h3 id="_3-6-题目表" tabindex="-1"><a class="header-anchor" href="#_3-6-题目表" aria-hidden="true">#</a> 3.6 题目表</h3><ul><li>表名：t_question</li><li>字段注释：</li></ul><table><thead><tr><th>字段名</th><th>类型</th><th>注释</th></tr></thead><tbody><tr><td>id</td><td>int</td><td></td></tr><tr><td>question_type</td><td>int</td><td>1.单选题 2.多选题 3.判断题 4.填空题 5.简答题</td></tr><tr><td>subject_id</td><td>int</td><td>学科</td></tr><tr><td>score</td><td>int</td><td>题目总分(千分制)</td></tr><tr><td>grade_level</td><td>int</td><td>级别</td></tr><tr><td>difficult</td><td>int</td><td>题目难度</td></tr><tr><td>correct</td><td>text</td><td>正确答案</td></tr><tr><td>info_text_content_id</td><td>int</td><td>题目 填空、 题干、解析、答案等信息</td></tr><tr><td>create_user</td><td>int</td><td>创建人</td></tr><tr><td>status</td><td>int</td><td>1.正常</td></tr><tr><td>create_time</td><td>datetime</td><td>创建时间</td></tr><tr><td>deleted</td><td>bit</td><td></td></tr></tbody></table><h3 id="_3-7-学科表" tabindex="-1"><a class="header-anchor" href="#_3-7-学科表" aria-hidden="true">#</a> 3.7 学科表</h3><ul><li>表名：t_subject</li><li>字段注释：</li></ul><table><thead><tr><th>字段名</th><th>类型</th><th>注释</th></tr></thead><tbody><tr><td>id</td><td>int</td><td></td></tr><tr><td>name</td><td>varchar</td><td>语文 数学 英语 等</td></tr><tr><td>level</td><td>int</td><td>年级 (1-12) 小学 初中 高中 大学</td></tr><tr><td>level_name</td><td>varchar</td><td>一年级、二年级等</td></tr><tr><td>item_order</td><td>int</td><td>排序</td></tr><tr><td>deleted</td><td>bit</td><td></td></tr></tbody></table><h3 id="_3-8-任务表" tabindex="-1"><a class="header-anchor" href="#_3-8-任务表" aria-hidden="true">#</a> 3.8 任务表</h3><ul><li>表名：t_task_exam</li><li>字段注释：</li></ul><table><thead><tr><th>字段名</th><th>类型</th><th>注释</th></tr></thead><tbody><tr><td>id</td><td>int</td><td></td></tr><tr><td>title</td><td>varchar</td><td></td></tr><tr><td>grade_level</td><td>int</td><td>级别</td></tr><tr><td>frame_text_content_id</td><td>int</td><td>任务框架 内容为JSON</td></tr><tr><td>create_user</td><td>int</td><td></td></tr><tr><td>create_time</td><td>datetime</td><td></td></tr><tr><td>deleted</td><td>bit</td><td></td></tr><tr><td>create_user_name</td><td>varchar</td><td></td></tr></tbody></table><h3 id="_3-9-用户任务表" tabindex="-1"><a class="header-anchor" href="#_3-9-用户任务表" aria-hidden="true">#</a> 3.9 用户任务表</h3><ul><li>表名：t_task_exam_customer_answer</li><li>字段注释：</li></ul><table><thead><tr><th>字段名</th><th>类型</th><th>注释</th></tr></thead><tbody><tr><td>id</td><td>int</td><td></td></tr><tr><td>task_exam_id</td><td>int</td><td></td></tr><tr><td>create_user</td><td>int</td><td></td></tr><tr><td>create_time</td><td>datetime</td><td></td></tr><tr><td>text_content_id</td><td>int</td><td>任务完成情况(Json)</td></tr></tbody></table><h3 id="_3-10-文本表" tabindex="-1"><a class="header-anchor" href="#_3-10-文本表" aria-hidden="true">#</a> 3.10 文本表</h3><ul><li>表名：t_text_content</li><li>字段注释：</li></ul><table><thead><tr><th>字段名</th><th>类型</th><th>注释</th></tr></thead><tbody><tr><td>id</td><td>int</td><td></td></tr><tr><td>content</td><td>text</td><td></td></tr><tr><td>create_time</td><td>datetime</td><td></td></tr></tbody></table><h3 id="_3-11-用户表" tabindex="-1"><a class="header-anchor" href="#_3-11-用户表" aria-hidden="true">#</a> 3.11 用户表</h3><ul><li>表名：t_user</li><li>字段注释：</li></ul><table><thead><tr><th>字段名</th><th>类型</th><th>注释</th></tr></thead><tbody><tr><td>id</td><td>int</td><td></td></tr><tr><td>user_uuid</td><td>varchar</td><td></td></tr><tr><td>user_name</td><td>varchar</td><td>用户名</td></tr><tr><td>password</td><td>varchar</td><td></td></tr><tr><td>real_name</td><td>varchar</td><td>真实姓名</td></tr><tr><td>age</td><td>int</td><td></td></tr><tr><td>sex</td><td>int</td><td>1.男 2女</td></tr><tr><td>birth_day</td><td>datetime</td><td></td></tr><tr><td>user_level</td><td>int</td><td>学生年级(1-12)</td></tr><tr><td>phone</td><td>varchar</td><td></td></tr><tr><td>role</td><td>int</td><td>1.学生 3.管理员</td></tr><tr><td>status</td><td>int</td><td>1.启用 2禁用</td></tr><tr><td>image_path</td><td>varchar</td><td>头像地址</td></tr><tr><td>create_time</td><td>datetime</td><td></td></tr><tr><td>modify_time</td><td>datetime</td><td></td></tr><tr><td>last_active_time</td><td>datetime</td><td></td></tr><tr><td>deleted</td><td>bit</td><td>是否删除</td></tr><tr><td>wx_open_id</td><td>varchar</td><td>微信openId</td></tr></tbody></table><h3 id="_3-12-用户日志表" tabindex="-1"><a class="header-anchor" href="#_3-12-用户日志表" aria-hidden="true">#</a> 3.12 用户日志表</h3><ul><li>表名：t_user_event_log</li><li>字段注释：</li></ul><table><thead><tr><th>字段名</th><th>类型</th><th>注释</th></tr></thead><tbody><tr><td>id</td><td>int</td><td></td></tr><tr><td>user_id</td><td>int</td><td>用户id</td></tr><tr><td>user_name</td><td>varchar</td><td>用户名</td></tr><tr><td>real_name</td><td>varchar</td><td>真实姓名</td></tr><tr><td>content</td><td>text</td><td>内容</td></tr><tr><td>create_time</td><td>datetime</td><td>时间</td></tr></tbody></table><h3 id="_3-13-用户token表" tabindex="-1"><a class="header-anchor" href="#_3-13-用户token表" aria-hidden="true">#</a> 3.13 用户Token表</h3><ul><li>表名：t_user_token</li><li>字段注释：</li></ul><table><thead><tr><th>字段名</th><th>类型</th><th>注释</th></tr></thead><tbody><tr><td>id</td><td>int</td><td></td></tr><tr><td>token</td><td>varchar</td><td></td></tr><tr><td>user_id</td><td>int</td><td>用户Id</td></tr><tr><td>wx_open_id</td><td>varchar</td><td>微信openId</td></tr><tr><td>create_time</td><td>datetime</td><td></td></tr><tr><td>end_time</td><td>datetime</td><td></td></tr><tr><td>user_name</td><td>varchar</td><td>用户名</td></tr></tbody></table></div><!--[--><!--]--></div><footer class="page-meta"><!----><div class="meta-item last-updated"><span class="meta-item-label">Last Updated: </span><!----></div><div class="meta-item contributors"><span class="meta-item-label">Contributors: </span><span class="meta-item-info"><!--[--><!--[--><span class="contributor" title="email: mindskip@qq.com">mindskip</span><!----><!--]--><!--]--></span></div></footer><nav class="page-nav"><p class="inner"><span class="prev"><a href="/guide/skill.html" class="" aria-label="2. 技术栈"><!--[--><!--]--> 2. 技术栈 <!--[--><!--]--></a></span><!----></p></nav><!--[--><!--]--></main><!--]--></div><!----><!--]--></div>
<script type="module" src="/assets/app.7283597e.js" defer></script>
</body>
</html>