|
|
<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="/xzs-mysql/" class=""><img class="logo" src="/xzs-mysql/images/logo/logo.png" alt="学之思教程"><span class="site-name can-hide">学之思教程</span></a></span><div class="navbar-links-wrapper" style=""><!--[--><!--]--><nav class="navbar-links can-hide"><!--[--><div class="navbar-links-item"><a class="nav-link external" href="https://www.mindskip.net" rel="noopener noreferrer" target="_blank" aria-label="官网"><!--[--><!--]--> 官网 <span><svg class="icon outbound" xmlns="http://www.w3.org/2000/svg" ariahidden="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="sr-only">open in new window</span><!--]--></span><!--[--><!--]--></a></div><div class="navbar-links-item"><a class="nav-link external" href="https://www.mindskip.net/sdd.html" rel="noopener noreferrer" target="_blank" aria-label="思多多"><!--[--><!--]--> 思多多 <span><svg class="icon outbound" xmlns="http://www.w3.org/2000/svg" ariahidden="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="sr-only">open in new window</span><!--]--></span><!--[--><!--]--></a></div><div class="navbar-links-item"><a class="nav-link external" href="https://www.mindskip.net/wdd.html" rel="noopener noreferrer" target="_blank" aria-label="维多多"><!--[--><!--]--> 维多多 <span><svg class="icon outbound" xmlns="http://www.w3.org/2000/svg" ariahidden="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="sr-only">open in new window</span><!--]--></span><!--[--><!--]--></a></div><div class="navbar-links-item"><a class="nav-link external" href="https://www.mindskip.net/xzs.html" rel="noopener noreferrer" target="_blank" aria-label="学之思"><!--[--><!--]--> 学之思 <span><svg class="icon outbound" xmlns="http://www.w3.org/2000/svg" ariahidden="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="sr-only">open in new window</span><!--]--></span><!--[--><!--]--></a></div><div class="navbar-links-item"><a class="nav-link external" href="https://www.mindskip.net/buy.html" rel="noopener noreferrer" target="_blank" aria-label="商业购买"><!--[--><!--]--> 商业购买 <span><svg class="icon outbound" xmlns="http://www.w3.org/2000/svg" ariahidden="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="sr-only">open in new window</span><!--]--></span><!--[--><!--]--></a></div><!--]--></nav><!--[--><!--]--><button class="toggle-dark-button" title="toggle dark 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-links"><!--[--><div class="navbar-links-item"><a class="nav-link external" href="https://www.mindskip.net" rel="noopener noreferrer" target="_blank" aria-label="官网"><!--[--><!--]--> 官网 <span><svg class="icon outbound" xmlns="http://www.w3.org/2000/svg" ariahidden="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="sr-only">open in new window</span><!--]--></span><!--[--><!--]--></a></div><div class="navbar-links-item"><a class="nav-link external" href="https://www.mindskip.net/sdd.html" rel="noopener noreferrer" target="_blank" aria-label="思多多"><!--[--><!--]--> 思多多 <span><svg class="icon outbound" xmlns="http://www.w3.org/2000/svg" ariahidden="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="sr-only">open in new window</span><!--]--></span><!--[--><!--]--></a></div><div class="navbar-links-item"><a class="nav-link external" href="https://www.mindskip.net/wdd.html" rel="noopener noreferrer" target="_blank" aria-label="维多多"><!--[--><!--]--> 维多多 <span><svg class="icon outbound" xmlns="http://www.w3.org/2000/svg" ariahidden="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="sr-only">open in new window</span><!--]--></span><!--[--><!--]--></a></div><div class="navbar-links-item"><a class="nav-link external" href="https://www.mindskip.net/xzs.html" rel="noopener noreferrer" target="_blank" aria-label="学之思"><!--[--><!--]--> 学之思 <span><svg class="icon outbound" xmlns="http://www.w3.org/2000/svg" ariahidden="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="sr-only">open in new window</span><!--]--></span><!--[--><!--]--></a></div><div class="navbar-links-item"><a class="nav-link external" href="https://www.mindskip.net/buy.html" rel="noopener noreferrer" target="_blank" aria-label="商业购买"><!--[--><!--]--> 商业购买 <span><svg class="icon outbound" xmlns="http://www.w3.org/2000/svg" ariahidden="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="sr-only">open in new window</span><!--]--></span><!--[--><!--]--></a></div><!--]--></nav><!--[--><!--]--><ul class="sidebar-links"><!--[--><!--[--><a href="/xzs-mysql/guide/feature.html" class="nav-link sidebar-heading sidebar-item" aria-label="1. 功能列表"><!--[--><!--]--> 1. 功能列表 <!--[--><!--]--></a><!----><!--]--><!--[--><a href="/xzs-mysql/guide/skill.html" class="nav-link sidebar-heading sidebar-item" aria-label="2. 技术栈"><!--[--><!--]--> 2. 技术栈 <!--[--><!--]--></a><!----><!--]--><!--[--><a aria-current="page" href="/xzs-mysql/guide/database.html" class="router-link-active router-link-exact-active nav-link router-link-active sidebar-heading sidebar-item active" aria-label="3. 数据库设计"><!--[--><!--]--> 3. 数据库设计 <!--[--><!--]--></a><ul class=""><li><!--[--><a aria-current="page" href="/xzs-mysql/guide/database.html#_3-1-试卷表" class="router-link-active router-link-exact-active nav-link sidebar-item" aria-label="3.1 试卷表"><!--[--><!--]--> 3.1 试卷表 <!--[--><!--]--></a><!----><!--]--></li><li><!--[--><a aria-current="page" href="/xzs-mysql/guide/database.html#_3-2-试卷答案表" class="router-link-active router-link-exact-active nav-link sidebar-item" aria-label="3.2 试卷答案表"><!--[--><!--]--> 3.2 试卷答案表 <!--[--><!--]--></a><!----><!--]--></li><li><!--[--><a aria-current="page" href="/xzs-mysql/guide/database.html#_3-3-试卷题目答案表" class="router-link-active router-link-exact-active nav-link sidebar-item" aria-label="3.3 试卷题目答案表"><!--[--><!--]--> 3.3 试卷题目答案表 <!--[--><!--]--></a><!----><!--]--></li><li><!--[--><a aria-current="page" href="/xzs-mysql/guide/database.html#_3-4-消息表" class="router-link-active router-link-exact-active nav-link sidebar-item" aria-label="3.4 消息表"><!--[--><!--]--> 3.4 消息表 <!--[--><!--]--></a><!----><!--]--></li><li><!--[--><a aria-current="page" href="/xzs-mysql/guide/database.html#_3-5-用户消息表" class="router-link-active router-link-exact-active nav-link sidebar-item" aria-label="3.5 用户消息表"><!--[--><!--]--> 3.5 用户消息表 <!--[--><!--]--></a><!----><!--]--></li><li><!--[--><a aria-current="page" href="/xzs-mysql/guide/database.html#_3-6-题目表" class="router-link-active router-link-exact-active nav-link sidebar-item" aria-label="3.6 题目表"><!--[--><!--]--> 3.6 题目表 <!--[--><!--]--></a><!----><!--]--></li><li><!--[--><a aria-current="page" href="/xzs-mysql/guide/database.html#_3-7-学科表" class="router-link-active router-link-exact-active nav-link sidebar-item" aria-label="3.7 学科表"><!--[--><!--]--> 3.7 学科表 <!--[--><!--]--></a><!----><!--]--></li><li><!--[--><a aria-current="page" href="/xzs-mysql/guide/database.html#_3-8-任务表" class="router-link-active router-link-exact-active nav-link sidebar-item" aria-label="3.8 任务表"><!--[--><!--]--> 3.8 任务表 <!--[--><!--]--></a><!----><!--]--></li><li><!--[--><a aria-current="page" href="/xzs-mysql/guide/database.html#_3-9-用户任务表" class="router-link-active router-link-exact-active nav-link sidebar-item" aria-label="3.9 用户任务表"><!--[--><!--]--> 3.9 用户任务表 <!--[--><!--]--></a><!----><!--]--></li><li><!--[--><a aria-current="page" href="/xzs-mysql/guide/database.html#_3-10-文本表" class="router-link-active router-link-exact-active nav-link sidebar-item" aria-label="3.10 文本表"><!--[--><!--]--> 3.10 文本表 <!--[--><!--]--></a><!----><!--]--></li><li><!--[--><a aria-current="page" href="/xzs-mysql/guide/database.html#_3-11-用户表" class="router-link-active router-link-exact-active nav-link sidebar-item" aria-label="3.11 用户表"><!--[--><!--]--> 3.11 用户表 <!--[--><!--]--></a><!----><!--]--></li><li><!--[--><a aria-current="page" href="/xzs-mysql/guide/database.html#_3-12-用户日志表" class="router-link-active router-link-exact-active nav-link sidebar-item" aria-label="3.12 用户日志表"><!--[--><!--]--> 3.12 用户日志表 <!--[--><!--]--></a><!----><!--]--></li><li><!--[--><a aria-current="page" href="/xzs-mysql/guide/database.html#_3-13-用户token表" class="router-link-active router-link-exact-active nav-link sidebar-item" aria-label="3.13 用户Token表"><!--[--><!--]--> 3.13 用户Token表 <!--[--><!--]--></a><!----><!--]--></li></ul><!--]--><!--[--><p class="sidebar-heading sidebar-item">4. 接口文档</p><ul class=""><li><!--[--><a href="/xzs-mysql/guide/student.html" class="nav-link sidebar-item" aria-label="4.1 学生端"><!--[--><!--]--> 4.1 学生端 <!--[--><!--]--></a><!----><!--]--></li><li><!--[--><a href="/xzs-mysql/guide/wx.html" class="nav-link sidebar-item" aria-label="4.2 小程序"><!--[--><!--]--> 4.2 小程序 <!--[--><!--]--></a><!----><!--]--></li><li><!--[--><a href="/xzs-mysql/guide/admin.html" class="nav-link sidebar-item" aria-label="4.3 管理端"><!--[--><!--]--> 4.3 管理端 <!--[--><!--]--></a><!----><!--]--></li></ul><!--]--><!--[--><a href="/xzs-mysql/guide/develop.html" class="nav-link sidebar-heading sidebar-item" aria-label="5. 项目开发"><!--[--><!--]--> 5. 项目开发 <!--[--><!--]--></a><!----><!--]--><!--[--><a href="/xzs-mysql/guide/deploy.html" class="nav-link sidebar-heading sidebar-item" aria-label="6. 项目部署"><!--[--><!--]--> 6. 项目部署 <!--[--><!--]--></a><!----><!--]--><!--[--><a href="/xzs-mysql/guide/video.html" class="nav-link sidebar-heading sidebar-item" aria-label="7. 视频教程"><!--[--><!--]--> 7. 视频教程 <!--[--><!--]--></a><!----><!--]--><!--]--></ul><!--[--><!--]--></aside><!--[--><main class="page"><!--[--><!--]--><div class="theme-default-content"><!--[--><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><footer class="page-meta"><!----><div class="meta-item last-updated"><span class="meta-item-label">上次更新: </span><span class="meta-item-info">2021/7/13 16:40:30</span></div><!----></footer><nav class="page-nav"><p class="inner"><span class="prev"> ← <a href="/xzs-mysql/guide/skill.html" class="nav-link" aria-label="2. 技术栈"><!--[--><!--]--> 2. 技术栈 <!--[--><!--]--></a></span><!----></p></nav><!--[--><!--]--></main><!--]--></div><!----><!--]--></div>
|
