新闻 news
<ul>
<li>新闻表:news</li>
</ul>
<table>
<thead>
<tr>
<th>字段</th>
<th>类型</th>
<th>可选</th>
<th>注释</th>
<th>备注</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td></td>
<td>序号</td>
<td>AUTO_INCREMENT</td>
</tr>
<tr>
<td>create_time</td>
<td>datetime</td>
<td></td>
<td>创建时间</td>
<td></td>
</tr>
<tr>
<td>update_time</td>
<td>datetime</td>
<td></td>
<td>更新时间</td>
<td></td>
</tr>
<tr>
<td>update_user</td>
<td>varchar(32)</td>
<td></td>
<td>更新人</td>
<td></td>
</tr>
<tr>
<td>is_delete</td>
<td>int</td>
<td>default = 0</td>
<td>删除标记</td>
<td>逻辑删除: 0=未删除, 1=删除</td>
</tr>
<tr>
<td>title</td>
<td>text</td>
<td></td>
<td>标题</td>
<td></td>
</tr>
<tr>
<td>abstract</td>
<td>text</td>
<td></td>
<td>摘要</td>
<td>手动填写</td>
</tr>
<tr>
<td>content</td>
<td>text</td>
<td></td>
<td>内容</td>
<td>富文本</td>
</tr>
<tr>
<td>date</td>
<td>datetime</td>
<td></td>
<td>日期</td>
<td></td>
</tr>
<tr>
<td>show_on_main</td>
<td>boolean</td>
<td>default = false</td>
<td>是否主页展示</td>
<td>默认False</td>
</tr>
</tbody>
</table>
<ul>
<li>备注:日期以字符串 YYYY-MM-DDTHH:mm:SS 形式传输,存储采用DateTime</li>
</ul>