数据库设计文档
<h2><center>数据库设计文档</center></h2>
<h3>1.数据库ER图</h3>
<p><img src="https://www.showdoc.com.cn/server/api/attachment/visitFile?sign=73dfc578b7c4b9603ed1e8386a7adea9&amp;file=file.png" alt="" /></p>
<h3>2.数据库设计表</h3>
<table>
<thead>
<tr>
<th style="text-align: left;">中文名称</th>
<th style="text-align: left;">表名</th>
<th>主键</th>
<th>说明</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align: left;">患者表</td>
<td style="text-align: left;">customer</td>
<td>id(<strong>customer_id</strong>)</td>
<td>存储患者记录</td>
</tr>
<tr>
<td style="text-align: left;">患者基本信息表</td>
<td style="text-align: left;">customer_info</td>
<td>关联customer_id</td>
<td>关联患者表1对1</td>
</tr>
<tr>
<td style="text-align: left;">患者签到信息表</td>
<td style="text-align: left;">customer_clock_in</td>
<td>id ,关联customer_id</td>
<td>关联患者表，每日打卡记录</td>
</tr>
<tr>
<td style="text-align: left;">病例表</td>
<td style="text-align: left;">med_design</td>
<td>id(<strong>design_id</strong>)，关联键customer_id</td>
<td>关联患者多对一</td>
</tr>
<tr>
<td style="text-align: left;">病例阶段表</td>
<td style="text-align: left;">med_design_phase</td>
<td>id(<strong>phase_id</strong>) ，关联键design_id</td>
<td>关联病例多对一</td>
</tr>
<tr>
<td style="text-align: left;">中期阶段反馈表</td>
<td style="text-align: left;">med_design_phase_feedback</td>
<td>id，关联键phase_id</td>
<td>中期阶段反馈表</td>
</tr>
<tr>
<td style="text-align: left;">资料表</td>
<td style="text-align: left;">med_resource</td>
<td>id，关联键phase_id</td>
<td>资料表</td>
</tr>
<tr>
<td style="text-align: left;">资料类型表</td>
<td style="text-align: left;">med_resource_image</td>
<td>id，关联键phase_id</td>
<td>资料类型表</td>
</tr>
<tr>
<td style="text-align: left;">头影测量表</td>
<td style="text-align: left;">med_resource_cephalo</td>
<td>id，关联键image_id</td>
<td>头影测量表</td>
</tr>
<tr>
<td style="text-align: left;">方案计划表</td>
<td style="text-align: left;">med_design_plan</td>
<td>id(<strong>plan_id</strong>) ，关联键phase_id</td>
<td>关联病例阶段表</td>
</tr>
<tr>
<td style="text-align: left;">目标位表</td>
<td style="text-align: left;">med_model_target</td>
<td>id ，关联键plan_id</td>
<td>目标位</td>
</tr>
<tr>
<td style="text-align: left;">附件表</td>
<td style="text-align: left;">med_model_attach</td>
<td>id ，关联键plan_id</td>
<td>附件</td>
</tr>
<tr>
<td style="text-align: left;">分步表</td>
<td style="text-align: left;">med_model_substep_teeth</td>
<td>id ，关联键plan_id</td>
<td>分步表</td>
</tr>
<tr>
<td style="text-align: left;">病例流水记录表</td>
<td style="text-align: left;">med_design_phase_tiding</td>
<td>id(<strong>plan_id</strong>) ，关联键phase_id</td>
<td>病例流水记录表</td>
</tr>
</tbody>
</table>
<h3>3.表结构详情</h3>
<h5>customer</h5>
<p><img src="https://www.showdoc.com.cn/server/api/attachment/visitFile?sign=878ec89d42d40b383e98145a998022bc&amp;file=file.png" alt="" /></p>
<h5>customer_info</h5>
<p><img src="https://www.showdoc.com.cn/server/api/attachment/visitFile?sign=9d75169afda960040649e46dcc2a3669&amp;file=file.png" alt="" /></p>
<h5>customer_clock_in</h5>
<p><img src="https://www.showdoc.com.cn/server/api/attachment/visitFile?sign=ceb7b63a859f9037a43b53d2512321cc&amp;file=file.png" alt="" /></p>
<h5>med_design</h5>
<p><img src="https://www.showdoc.com.cn/server/api/attachment/visitFile?sign=4827ffbc18301d319ea31542bec1b635&amp;file=file.png" alt="" /></p>
<h5>med_design_phase</h5>
<p><img src="https://www.showdoc.com.cn/server/api/attachment/visitFile?sign=2a44f2a7029e6efeb5b63ed9e1d09065&amp;file=file.png" alt="" /></p>
<h5>med_design_phase_feedback</h5>
<p><img src="https://www.showdoc.com.cn/server/api/attachment/visitFile?sign=80bfafadf689fe9055c4beaff1217a76&amp;file=file.png" alt="" /></p>
<h5>med_resource</h5>
<p><img src="https://www.showdoc.com.cn/server/api/attachment/visitFile?sign=60df282f871ba74a2044360136073a3b&amp;file=file.png" alt="" /></p>
<h5>med_resource_image</h5>
<p><img src="https://www.showdoc.com.cn/server/api/attachment/visitFile?sign=3daea594d202e94383fd2242e3166eab&amp;file=file.png" alt="" /></p>
<h5>med_resource_cephalo</h5>
<p><img src="https://www.showdoc.com.cn/server/api/attachment/visitFile?sign=cca5715926afc4f2852bf5e1e2614c44&amp;file=file.png" alt="" /></p>
<h5>med_design_plan</h5>
<p><img src="https://www.showdoc.com.cn/server/api/attachment/visitFile?sign=f6067dd1fd9cc9c9f1b4f4353e6e932f&amp;file=file.png" alt="" /></p>
<h5>med_model_target</h5>
<p><img src="https://www.showdoc.com.cn/server/api/attachment/visitFile?sign=86c5176d8161ed154c55f12329dea3e2&amp;file=file.png" alt="" /></p>
<h5>med_model_attach</h5>
<p><img src="https://www.showdoc.com.cn/server/api/attachment/visitFile?sign=4098cd34eceb4b99b22ea606276b3a5d&amp;file=file.png" alt="" /></p>
<h5>med_model_substep_teeth</h5>
<p><img src="https://www.showdoc.com.cn/server/api/attachment/visitFile?sign=4b90476d86f04de7bec00fe481a03245&amp;file=file.png" alt="" /></p>
<h5>med_design_phase_tiding</h5>
<p><img src="https://www.showdoc.com.cn/server/api/attachment/visitFile?sign=e03d97a266e05f3f8e4feae3f85c11b4&amp;file=file.png" alt="" /></p>