数据库结构
<p>[TOC]</p>
<h2>cw_admin<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-admin"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td></td>
</tr>
<tr>
<td>root</td>
<td>tinyint</td>
<td>是否超级管理员 0-否 1-是</td>
</tr>
<tr>
<td>name</td>
<td>varchar</td>
<td>名称</td>
</tr>
<tr>
<td>avatar</td>
<td>varchar</td>
<td>用户头像</td>
</tr>
<tr>
<td>account</td>
<td>varchar</td>
<td>账号</td>
</tr>
<tr>
<td>password</td>
<td>varchar</td>
<td>密码</td>
</tr>
<tr>
<td>login_time</td>
<td>int</td>
<td>最后登录时间</td>
</tr>
<tr>
<td>login_ip</td>
<td>varchar</td>
<td>最后登录ip</td>
</tr>
<tr>
<td>multipoint_login</td>
<td>tinyint</td>
<td>是否支持多处登录：1-是；0-否；</td>
</tr>
<tr>
<td>disable</td>
<td>tinyint</td>
<td>是否禁用：0-否；1-是；</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>修改时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_admin_dept<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-admin-dept"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>admin_id</td>
<td>int</td>
<td>管理员id</td>
</tr>
<tr>
<td>dept_id</td>
<td>int</td>
<td>部门id</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_admin_jobs<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-admin-jobs"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>admin_id</td>
<td>int</td>
<td>管理员id</td>
</tr>
<tr>
<td>jobs_id</td>
<td>int</td>
<td>岗位id</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_admin_role<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-admin-role"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>admin_id</td>
<td>int</td>
<td>管理员id</td>
</tr>
<tr>
<td>role_id</td>
<td>int</td>
<td>角色id</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_admin_session<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-admin-session"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td></td>
</tr>
<tr>
<td>admin_id</td>
<td>int</td>
<td>用户id</td>
</tr>
<tr>
<td>terminal</td>
<td>tinyint</td>
<td>客户端类型：1-pc管理后台 2-mobile手机管理后台</td>
</tr>
<tr>
<td>token</td>
<td>varchar</td>
<td>令牌</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>expire_time</td>
<td>int</td>
<td>到期时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_article<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-article"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>文章id</td>
</tr>
<tr>
<td>cid</td>
<td>int</td>
<td>文章分类</td>
</tr>
<tr>
<td>title</td>
<td>varchar</td>
<td>文章标题</td>
</tr>
<tr>
<td>desc</td>
<td>varchar</td>
<td>简介</td>
</tr>
<tr>
<td>abstract</td>
<td>text</td>
<td>文章摘要</td>
</tr>
<tr>
<td>image</td>
<td>varchar</td>
<td>文章图片</td>
</tr>
<tr>
<td>author</td>
<td>varchar</td>
<td>作者</td>
</tr>
<tr>
<td>content</td>
<td>text</td>
<td>文章内容</td>
</tr>
<tr>
<td>click_virtual</td>
<td>int</td>
<td>虚拟浏览量</td>
</tr>
<tr>
<td>click_actual</td>
<td>int</td>
<td>实际浏览量</td>
</tr>
<tr>
<td>is_show</td>
<td>tinyint</td>
<td>是否显示:1-是.0-否</td>
</tr>
<tr>
<td>sort</td>
<td>int</td>
<td>排序</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_article_cate<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-article-cate"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>文章分类id</td>
</tr>
<tr>
<td>name</td>
<td>varchar</td>
<td>分类名称</td>
</tr>
<tr>
<td>sort</td>
<td>int</td>
<td>排序</td>
</tr>
<tr>
<td>is_show</td>
<td>tinyint</td>
<td>是否显示:1-是;0-否</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_article_collect<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-article-collect"></a></h2>
<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>article_id</td>
<td>int</td>
<td>文章ID</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>收藏状态 0-未收藏 1-已收藏</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_background(背景图)<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-background-%E8%83%8C%E6%99%AF%E5%9B%BE"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td></td>
</tr>
<tr>
<td>url</td>
<td>varchar</td>
<td>图片</td>
</tr>
<tr>
<td>type</td>
<td>int</td>
<td>版型类型：1-竖版；2-横版</td>
</tr>
<tr>
<td>category_id</td>
<td>int</td>
<td>分类id</td>
</tr>
<tr>
<td>sort</td>
<td>int</td>
<td>排序</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>状态:1-开启,0-关闭</td>
</tr>
<tr>
<td>media_id</td>
<td>varchar</td>
<td>媒体id</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_background_category(背景图分类)<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-background-category-%E8%83%8C%E6%99%AF%E5%9B%BE%E5%88%86%E7%B1%BB"></a></h2>
<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>sort</td>
<td>int</td>
<td>排序</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>状态:1-开启,0-关闭</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_chat_category<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-chat-category"></a></h2>
<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>sort</td>
<td>int</td>
<td>排序</td>
</tr>
<tr>
<td>status</td>
<td>int</td>
<td>状态：1-开启，0-关闭</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>image</td>
<td>varchar</td>
<td>图标</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>修改时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_chat_record<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-chat-record"></a></h2>
<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>category_id</td>
<td>int</td>
<td>对话记录分类</td>
</tr>
<tr>
<td>other_id</td>
<td>int</td>
<td>创作id</td>
</tr>
<tr>
<td>ask</td>
<td>text</td>
<td>提问</td>
</tr>
<tr>
<td>reply</td>
<td>text</td>
<td>回复</td>
</tr>
<tr>
<td>type</td>
<td>int</td>
<td>类型：1-对话，2-创作</td>
</tr>
<tr>
<td>key</td>
<td>varchar</td>
<td>模型来源公司</td>
</tr>
<tr>
<td>model</td>
<td>varchar</td>
<td>对话模型</td>
</tr>
<tr>
<td>is_show</td>
<td>tinyint</td>
<td>是否显示：1-是；0-否；</td>
</tr>
<tr>
<td>censor_status</td>
<td>tinyint</td>
<td>审核状态：0-未审核；1-合规；2-不合规；3-疑似；4-审核失败；</td>
</tr>
<tr>
<td>censor_result</td>
<td>text</td>
<td>审核结果</td>
</tr>
<tr>
<td>censor_num</td>
<td>int</td>
<td>审核次数</td>
</tr>
<tr>
<td>extra</td>
<td>text</td>
<td>预留扩展字段</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_chat_record_category<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-chat-record-category"></a></h2>
<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>name</td>
<td>varchar</td>
<td>对话分类名称</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_chat_record_collect<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-chat-record-collect"></a></h2>
<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>records_id</td>
<td>int</td>
<td>对话记录ID</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_chat_sample<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-chat-sample"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td></td>
</tr>
<tr>
<td>category_id</td>
<td>int</td>
<td>类目id</td>
</tr>
<tr>
<td>sort</td>
<td>int</td>
<td>排序</td>
</tr>
<tr>
<td>content</td>
<td>varchar</td>
<td>内容</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>状态：1-是；0-否</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>修改时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_config<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-config"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td></td>
</tr>
<tr>
<td>type</td>
<td>varchar</td>
<td>类型</td>
</tr>
<tr>
<td>name</td>
<td>varchar</td>
<td>名称</td>
</tr>
<tr>
<td>value</td>
<td>text</td>
<td>值</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_creation_category(创作类别)<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-creation-category-%E5%88%9B%E4%BD%9C%E7%B1%BB%E5%88%AB"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td></td>
</tr>
<tr>
<td>image</td>
<td>varchar</td>
<td>分类图标</td>
</tr>
<tr>
<td>name</td>
<td>varchar</td>
<td>类目名称</td>
</tr>
<tr>
<td>sort</td>
<td>int</td>
<td>排序</td>
</tr>
<tr>
<td>status</td>
<td>int</td>
<td>状态：1-开启，0-关闭</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>修改时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_creation_model(创作模型)<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-creation-model-%E5%88%9B%E4%BD%9C%E6%A8%A1%E5%9E%8B"></a></h2>
<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>image</td>
<td>varchar</td>
<td>图标</td>
</tr>
<tr>
<td>sort</td>
<td>int</td>
<td>排序</td>
</tr>
<tr>
<td>category_id</td>
<td>int</td>
<td>类别id</td>
</tr>
<tr>
<td>status</td>
<td>int</td>
<td>状态：1-开启，0-关闭</td>
</tr>
<tr>
<td>content</td>
<td>text</td>
<td>主题内容</td>
</tr>
<tr>
<td>tips</td>
<td>text</td>
<td>提示文字</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>修改时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
<td>context_num</td>
<td>int</td>
<td>上下文总数</td>
</tr>
<tr>
<td>top_p</td>
<td>decimal</td>
<td>随机属性</td>
</tr>
<tr>
<td>presence_penalty</td>
<td>decimal</td>
<td>话题属性</td>
</tr>
<tr>
<td>frequency_penalty</td>
<td>decimal</td>
<td>重复属性</td>
</tr>
<tr>
<td>n</td>
<td>int</td>
<td>最大回复</td>
</tr>
<tr>
<td>max_tokens</td>
<td>int</td>
<td>回复最大长度</td>
</tr>
<tr>
<td>temperature</td>
<td>decimal</td>
<td>词汇属性</td>
</tr>
<tr>
<td>form</td>
<td>text</td>
<td>表单</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_creation_model_collect(创作收藏表)<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-creation-model-collect-%E5%88%9B%E4%BD%9C%E6%94%B6%E8%97%8F%E8%A1%A8"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td></td>
</tr>
<tr>
<td>creation_id</td>
<td>int</td>
<td>创作id</td>
</tr>
<tr>
<td>user_id</td>
<td>int</td>
<td>用户id</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_decals(贴纸)<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-decals-%E8%B4%B4%E7%BA%B8"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td></td>
</tr>
<tr>
<td>url</td>
<td>varchar</td>
<td>图片</td>
</tr>
<tr>
<td>category_id</td>
<td>int</td>
<td>分类id</td>
</tr>
<tr>
<td>sort</td>
<td>int</td>
<td>排序</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>状态:1-开启,0-关闭</td>
</tr>
<tr>
<td>media_id</td>
<td>varchar</td>
<td>媒体id</td>
</tr>
<tr>
<td>type</td>
<td>tinyint</td>
<td>类型：1-图片；2-动图</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
<td>source</td>
<td>tinyint</td>
<td>类型：1-阿里官方；2-后台上传</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_decals_category(贴纸分类)<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-decals-category-%E8%B4%B4%E7%BA%B8%E5%88%86%E7%B1%BB"></a></h2>
<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>sort</td>
<td>int</td>
<td>排序</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>状态:1-开启,0-关闭</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_decorate_nav<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-decorate-nav"></a></h2>
<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>icon</td>
<td>varchar</td>
<td>导航图标</td>
</tr>
<tr>
<td>link</td>
<td>varchar</td>
<td>链接地址</td>
</tr>
<tr>
<td>is_show</td>
<td>tinyint</td>
<td>是否显示</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_decorate_page<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-decorate-page"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>主键</td>
</tr>
<tr>
<td>type</td>
<td>tinyint</td>
<td>页面类型 1=商城首页, 2=个人中心, 3=客服设置 4-PC首页</td>
</tr>
<tr>
<td>name</td>
<td>varchar</td>
<td>页面名称</td>
</tr>
<tr>
<td>data</td>
<td>text</td>
<td>页面数据</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_decorate_tabbar<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-decorate-tabbar"></a></h2>
<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>selected</td>
<td>varchar</td>
<td>未选图标</td>
</tr>
<tr>
<td>unselected</td>
<td>varchar</td>
<td>已选图标</td>
</tr>
<tr>
<td>link</td>
<td>varchar</td>
<td>链接地址</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_dept<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-dept"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>id</td>
</tr>
<tr>
<td>name</td>
<td>varchar</td>
<td>部门名称</td>
</tr>
<tr>
<td>pid</td>
<td>bigint</td>
<td>上级部门id</td>
</tr>
<tr>
<td>sort</td>
<td>int</td>
<td>排序</td>
</tr>
<tr>
<td>leader</td>
<td>varchar</td>
<td>负责人</td>
</tr>
<tr>
<td>mobile</td>
<td>varchar</td>
<td>联系电话</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>部门状态（0停用 1正常）</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>修改时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_dev_crontab<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-dev-crontab"></a></h2>
<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>type</td>
<td>tinyint</td>
<td>类型 1-定时任务</td>
</tr>
<tr>
<td>system</td>
<td>tinyint</td>
<td>是否系统任务 0-否 1-是</td>
</tr>
<tr>
<td>remark</td>
<td>varchar</td>
<td>备注</td>
</tr>
<tr>
<td>command</td>
<td>varchar</td>
<td>命令内容</td>
</tr>
<tr>
<td>params</td>
<td>varchar</td>
<td>参数</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>状态 1-运行 2-停止 3-错误</td>
</tr>
<tr>
<td>expression</td>
<td>varchar</td>
<td>运行规则</td>
</tr>
<tr>
<td>error</td>
<td>varchar</td>
<td>运行失败原因</td>
</tr>
<tr>
<td>last_time</td>
<td>int</td>
<td>最后执行时间</td>
</tr>
<tr>
<td>time</td>
<td>varchar</td>
<td>实时执行时长</td>
</tr>
<tr>
<td>max_time</td>
<td>varchar</td>
<td>最大执行时长</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_dev_pay_config<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-dev-pay-config"></a></h2>
<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>pay_way</td>
<td>tinyint</td>
<td>支付方式:1-余额支付;2-微信支付;3-支付宝支付;</td>
</tr>
<tr>
<td>config</td>
<td>text</td>
<td>对应支付配置(json字符串)</td>
</tr>
<tr>
<td>icon</td>
<td>varchar</td>
<td>图标</td>
</tr>
<tr>
<td>sort</td>
<td>int</td>
<td>排序</td>
</tr>
<tr>
<td>remark</td>
<td>varchar</td>
<td>备注</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_dev_pay_way<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-dev-pay-way"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td></td>
</tr>
<tr>
<td>pay_config_id</td>
<td>int</td>
<td>支付配置ID</td>
</tr>
<tr>
<td>scene</td>
<td>tinyint</td>
<td>场景:1-微信小程序;2-微信公众号;3-H5;4-PC;5-APP;</td>
</tr>
<tr>
<td>is_default</td>
<td>tinyint</td>
<td>是否默认支付:0-否;1-是;</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>状态:0-关闭;1-开启;</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_dict_data<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-dict-data"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>id</td>
</tr>
<tr>
<td>name</td>
<td>varchar</td>
<td>数据名称</td>
</tr>
<tr>
<td>value</td>
<td>varchar</td>
<td>数据值</td>
</tr>
<tr>
<td>type_id</td>
<td>int</td>
<td>字典类型id</td>
</tr>
<tr>
<td>type_value</td>
<td>varchar</td>
<td>字典类型</td>
</tr>
<tr>
<td>sort</td>
<td>int</td>
<td>排序值</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>状态 0-停用 1-正常</td>
</tr>
<tr>
<td>remark</td>
<td>varchar</td>
<td>备注</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>修改时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_dict_type<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-dict-type"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>id</td>
</tr>
<tr>
<td>name</td>
<td>varchar</td>
<td>字典名称</td>
</tr>
<tr>
<td>type</td>
<td>varchar</td>
<td>字典类型名称</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>状态 0-停用 1-正常</td>
</tr>
<tr>
<td>remark</td>
<td>varchar</td>
<td>备注</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>修改时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_email_log<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-email-log"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>id</td>
</tr>
<tr>
<td>scene_id</td>
<td>int</td>
<td>场景id</td>
</tr>
<tr>
<td>email</td>
<td>varchar</td>
<td>邮箱</td>
</tr>
<tr>
<td>content</td>
<td>varchar</td>
<td>发送内容</td>
</tr>
<tr>
<td>code</td>
<td>varchar</td>
<td>验证码</td>
</tr>
<tr>
<td>is_verify</td>
<td>tinyint</td>
<td>是否已验证；0-否；1-是</td>
</tr>
<tr>
<td>check_num</td>
<td>int</td>
<td>验证次数</td>
</tr>
<tr>
<td>send_status</td>
<td>tinyint</td>
<td>发送状态：0-发送中；1-发送成功；2-发送失败</td>
</tr>
<tr>
<td>send_time</td>
<td>int</td>
<td>发送时间</td>
</tr>
<tr>
<td>results</td>
<td>text</td>
<td>发送结果</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_file<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-file"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>主键ID</td>
</tr>
<tr>
<td>cid</td>
<td>int</td>
<td>类目ID</td>
</tr>
<tr>
<td>source_id</td>
<td>int</td>
<td>上传者id</td>
</tr>
<tr>
<td>source</td>
<td>tinyint</td>
<td>来源类型[0-后台,1-用户]</td>
</tr>
<tr>
<td>type</td>
<td>tinyint</td>
<td>类型[10=图片, 20=视频]</td>
</tr>
<tr>
<td>name</td>
<td>varchar</td>
<td>文件名称</td>
</tr>
<tr>
<td>uri</td>
<td>varchar</td>
<td>文件路径</td>
</tr>
<tr>
<td>use_type</td>
<td>tinyint</td>
<td>使用类型：1-常规素材使用，2-数字人素材使用</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_file_cate<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-file-cate"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>主键ID</td>
</tr>
<tr>
<td>pid</td>
<td>int</td>
<td>父级ID</td>
</tr>
<tr>
<td>type</td>
<td>tinyint</td>
<td>类型[10=图片，20=视频，30=文件，40=音频]</td>
</tr>
<tr>
<td>name</td>
<td>varchar</td>
<td>分类名称</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_generate_column<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-generate-column"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>id</td>
</tr>
<tr>
<td>table_id</td>
<td>int</td>
<td>表id</td>
</tr>
<tr>
<td>column_name</td>
<td>varchar</td>
<td>字段名称</td>
</tr>
<tr>
<td>column_comment</td>
<td>varchar</td>
<td>字段描述</td>
</tr>
<tr>
<td>column_type</td>
<td>varchar</td>
<td>字段类型</td>
</tr>
<tr>
<td>is_required</td>
<td>tinyint</td>
<td>是否必填 0-非必填 1-必填</td>
</tr>
<tr>
<td>is_pk</td>
<td>tinyint</td>
<td>是否为主键 0-不是 1-是</td>
</tr>
<tr>
<td>is_insert</td>
<td>tinyint</td>
<td>是否为插入字段 0-不是 1-是</td>
</tr>
<tr>
<td>is_update</td>
<td>tinyint</td>
<td>是否为更新字段 0-不是 1-是</td>
</tr>
<tr>
<td>is_lists</td>
<td>tinyint</td>
<td>是否为列表字段 0-不是 1-是</td>
</tr>
<tr>
<td>is_query</td>
<td>tinyint</td>
<td>是否为查询字段 0-不是 1-是</td>
</tr>
<tr>
<td>query_type</td>
<td>varchar</td>
<td>查询类型</td>
</tr>
<tr>
<td>view_type</td>
<td>varchar</td>
<td>显示类型</td>
</tr>
<tr>
<td>dict_type</td>
<td>varchar</td>
<td>字典类型</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>修改时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_generate_table<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-generate-table"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>id</td>
</tr>
<tr>
<td>table_name</td>
<td>varchar</td>
<td>表名称</td>
</tr>
<tr>
<td>table_comment</td>
<td>varchar</td>
<td>表描述</td>
</tr>
<tr>
<td>template_type</td>
<td>tinyint</td>
<td>模板类型 0-单表(curd) 1-树表(curd)</td>
</tr>
<tr>
<td>author</td>
<td>varchar</td>
<td>作者</td>
</tr>
<tr>
<td>remark</td>
<td>varchar</td>
<td>备注</td>
</tr>
<tr>
<td>generate_type</td>
<td>tinyint</td>
<td>生成方式 0-压缩包下载 1-生成到模块</td>
</tr>
<tr>
<td>module_name</td>
<td>varchar</td>
<td>模块名</td>
</tr>
<tr>
<td>class_dir</td>
<td>varchar</td>
<td>类目录名</td>
</tr>
<tr>
<td>class_comment</td>
<td>varchar</td>
<td>类描述</td>
</tr>
<tr>
<td>admin_id</td>
<td>int</td>
<td>管理员id</td>
</tr>
<tr>
<td>menu</td>
<td>text</td>
<td>菜单配置</td>
</tr>
<tr>
<td>delete</td>
<td>text</td>
<td>删除配置</td>
</tr>
<tr>
<td>tree</td>
<td>text</td>
<td>树表配置</td>
</tr>
<tr>
<td>relations</td>
<td>text</td>
<td>关联配置</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>修改时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_hot_search<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-hot-search"></a></h2>
<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>sort</td>
<td>smallint</td>
<td>排序号</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_index_visit<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-index-visit"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td></td>
</tr>
<tr>
<td>ip</td>
<td>varchar</td>
<td>访客ip地址</td>
</tr>
<tr>
<td>terminal</td>
<td>tinyint</td>
<td>访问终端</td>
</tr>
<tr>
<td>visit</td>
<td>int</td>
<td>浏览量</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>访问时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td></td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td></td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_jobs<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-jobs"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>id</td>
</tr>
<tr>
<td>name</td>
<td>varchar</td>
<td>岗位名称</td>
</tr>
<tr>
<td>code</td>
<td>varchar</td>
<td>岗位编码</td>
</tr>
<tr>
<td>sort</td>
<td>int</td>
<td>显示顺序</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>状态（0停用 1正常）</td>
</tr>
<tr>
<td>remark</td>
<td>varchar</td>
<td>备注</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>修改时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_key_down_rule(key自动下架规则)<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-key-down-rule-key%E8%87%AA%E5%8A%A8%E4%B8%8B%E6%9E%B6%E8%A7%84%E5%88%99"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td></td>
</tr>
<tr>
<td>type</td>
<td>tinyint</td>
<td>规则类型：1-对话</td>
</tr>
<tr>
<td>ai_key</td>
<td>varchar</td>
<td>接口类型</td>
</tr>
<tr>
<td>rule</td>
<td>varchar</td>
<td>停用规则</td>
</tr>
<tr>
<td>prompt</td>
<td>varchar</td>
<td>停用提示</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>状态：1-开启,0-关闭</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_key_pool<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-key-pool"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>id</td>
</tr>
<tr>
<td>type</td>
<td>tinyint</td>
<td>类型</td>
</tr>
<tr>
<td>model</td>
<td>varchar</td>
<td>模型</td>
</tr>
<tr>
<td>key</td>
<td>varchar</td>
<td>密钥</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>状态</td>
</tr>
<tr>
<td>remark</td>
<td>varchar</td>
<td>备注</td>
</tr>
<tr>
<td>appid</td>
<td>varchar</td>
<td>appid</td>
</tr>
<tr>
<td>secret</td>
<td>varchar</td>
<td>secret</td>
</tr>
<tr>
<td>notice</td>
<td>text</td>
<td>通知</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_knowledge<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-knowledge"></a></h2>
<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>admin_id</td>
<td>int</td>
<td>后台ID</td>
</tr>
<tr>
<td>name</td>
<td>varchar</td>
<td>名称</td>
</tr>
<tr>
<td>image</td>
<td>varchar</td>
<td>图标</td>
</tr>
<tr>
<td>sort</td>
<td>smallint</td>
<td>排序</td>
</tr>
<tr>
<td>type</td>
<td>tinyint</td>
<td>集合类型: [1=问答型, 2=检索型]</td>
</tr>
<tr>
<td>is_enable</td>
<td>tinyint</td>
<td>是否启用: [0=否, 1=是]</td>
</tr>
<tr>
<td>create_type</td>
<td>tinyint</td>
<td>创建类型: [1=后台, 2=前台]</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_know_apply<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-know-apply"></a></h2>
<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>admin_id</td>
<td>int</td>
<td>管理员ID</td>
</tr>
<tr>
<td>code</td>
<td>varchar</td>
<td>应用编号</td>
</tr>
<tr>
<td>kb_ids</td>
<td>varchar</td>
<td>知识库ID</td>
</tr>
<tr>
<td>category_id</td>
<td>int</td>
<td>分类ID</td>
</tr>
<tr>
<td>image</td>
<td>varchar</td>
<td>应用封面</td>
</tr>
<tr>
<td>name</td>
<td>varchar</td>
<td>应用名称</td>
</tr>
<tr>
<td>intro</td>
<td>varchar</td>
<td>应用简介</td>
</tr>
<tr>
<td>sort</td>
<td>smallint</td>
<td>排序编号</td>
</tr>
<tr>
<td>welcome</td>
<td>text</td>
<td>欢迎语</td>
</tr>
<tr>
<td>example</td>
<td>text</td>
<td>示例值</td>
</tr>
<tr>
<td>systemPrompt</td>
<td>text</td>
<td>提示词</td>
</tr>
<tr>
<td>limitPrompt</td>
<td>text</td>
<td>限定词</td>
</tr>
<tr>
<td>searchEmptyText</td>
<td>text</td>
<td>空搜索回复</td>
</tr>
<tr>
<td>searchSimilarity</td>
<td>decimal</td>
<td>相似度</td>
</tr>
<tr>
<td>searchLimit</td>
<td>smallint</td>
<td>单次搜索数量</td>
</tr>
<tr>
<td>artificial_content</td>
<td>text</td>
<td>人工客服内容</td>
</tr>
<tr>
<td>chat_icon</td>
<td>varchar</td>
<td>对话图标</td>
</tr>
<tr>
<td>auth_type</td>
<td>tinyint</td>
<td>使用权限: 0=所有用户, 1=指定分组</td>
</tr>
<tr>
<td>create_type</td>
<td>tinyint</td>
<td>创建类型: 1=后台创建, 2=前台创建</td>
</tr>
<tr>
<td>null_reply_type</td>
<td>tinyint</td>
<td>空回复类型: [1=默认回复, 2=AI回复]</td>
</tr>
<tr>
<td>is_show_context</td>
<td>tinyint</td>
<td>显示上下文: [0=否, 1=是]</td>
</tr>
<tr>
<td>is_show_quote</td>
<td>tinyint</td>
<td>显示引用: [0=否, 1=是]</td>
</tr>
<tr>
<td>is_artificial</td>
<td>tinyint</td>
<td>人工客服: [0=否, 1=是]</td>
</tr>
<tr>
<td>is_enable</td>
<td>tinyint</td>
<td>是否启用: [0=否, 1=是]</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_know_apply_auth<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-know-apply-auth"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>主键</td>
</tr>
<tr>
<td>apply_id</td>
<td>int</td>
<td>应用ID</td>
</tr>
<tr>
<td>group_id</td>
<td>int</td>
<td>分组ID</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_know_apply_category<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-know-apply-category"></a></h2>
<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>sort</td>
<td>smallint</td>
<td>排序编号</td>
</tr>
<tr>
<td>is_enable</td>
<td>tinyint</td>
<td>是否启用: [0=否, 1=是]</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_know_apply_collect<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-know-apply-collect"></a></h2>
<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>apply_id</td>
<td>int</td>
<td>应用ID</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_know_qa<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-know-qa"></a></h2>
<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>content</td>
<td>text</td>
<td>文本内容</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>拆分状态: [0=等待拆分, 1=拆分中, 2=拆分成功, 3=拆分失败]</td>
</tr>
<tr>
<td>error</td>
<td>text</td>
<td>错误信息</td>
</tr>
<tr>
<td>save_bk_ids</td>
<td>varchar</td>
<td>知识库ID</td>
</tr>
<tr>
<td>handle_id</td>
<td>int</td>
<td>处理人ID</td>
</tr>
<tr>
<td>handle_type</td>
<td>tinyint</td>
<td>处理类型: [1=后台, 2=用户]</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_know_qa_data<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-know-qa-data"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>主键</td>
</tr>
<tr>
<td>qa_id</td>
<td>int</td>
<td>拆分ID</td>
</tr>
<tr>
<td>question</td>
<td>text</td>
<td>问题</td>
</tr>
<tr>
<td>answer</td>
<td>text</td>
<td>回复</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_know_record<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-know-record"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>主键</td>
</tr>
<tr>
<td>wind_id</td>
<td>int</td>
<td>窗口ID</td>
</tr>
<tr>
<td>user_id</td>
<td>int</td>
<td>用户ID</td>
</tr>
<tr>
<td>apply_id</td>
<td>int</td>
<td>应用ID</td>
</tr>
<tr>
<td>ask</td>
<td>text</td>
<td>提问</td>
</tr>
<tr>
<td>reply</td>
<td>text</td>
<td>答复</td>
</tr>
<tr>
<td>context</td>
<td>text</td>
<td>上下文</td>
</tr>
<tr>
<td>quotes</td>
<td>text</td>
<td>引用值</td>
</tr>
<tr>
<td>images</td>
<td>text</td>
<td>附带图片</td>
</tr>
<tr>
<td>files</td>
<td>text</td>
<td>附带文件</td>
</tr>
<tr>
<td>model</td>
<td>varchar</td>
<td>模型</td>
</tr>
<tr>
<td>identity</td>
<td>varchar</td>
<td>临时身份</td>
</tr>
<tr>
<td>channel_sn</td>
<td>varchar</td>
<td>渠道编号</td>
</tr>
<tr>
<td>channel_type</td>
<td>tinyint</td>
<td>访问渠道: [0=前台, 1=网页, 2=API]</td>
</tr>
<tr>
<td>censor_status</td>
<td>tinyint</td>
<td>审核状态: [0=未审核, 1=合规, 2=不合规, 3=疑似, 4=审核失败]</td>
</tr>
<tr>
<td>censor_num</td>
<td>smallint</td>
<td>审核次数</td>
</tr>
<tr>
<td>censor_result</td>
<td>text</td>
<td>审核结果</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_know_release<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-know-release"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>主键</td>
</tr>
<tr>
<td>type</td>
<td>int</td>
<td>类型: [1=web, 2=api]</td>
</tr>
<tr>
<td>user_id</td>
<td>int</td>
<td>用户ID</td>
</tr>
<tr>
<td>apply_id</td>
<td>int</td>
<td>应用ID</td>
</tr>
<tr>
<td>apply_sn</td>
<td>varchar</td>
<td>应用编号</td>
</tr>
<tr>
<td>channel_sn</td>
<td>varchar</td>
<td>渠道编号</td>
</tr>
<tr>
<td>name</td>
<td>varchar</td>
<td>分享名称</td>
</tr>
<tr>
<td>secret</td>
<td>varchar</td>
<td>访问密钥</td>
</tr>
<tr>
<td>context_num</td>
<td>tinyint</td>
<td>上下文数</td>
</tr>
<tr>
<td>limit_total_chat</td>
<td>int</td>
<td>限制每个用户累计总对话数</td>
</tr>
<tr>
<td>limit_today_chat</td>
<td>int</td>
<td>限制每个用户每天总对话数</td>
</tr>
<tr>
<td>limit_exceed</td>
<td>varchar</td>
<td>限制超出的默认回复</td>
</tr>
<tr>
<td>use_time</td>
<td>int</td>
<td>使用时间</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_know_window<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-know-window"></a></h2>
<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>apply_id</td>
<td>int</td>
<td>应用ID</td>
</tr>
<tr>
<td>name</td>
<td>varchar</td>
<td>窗口名称</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_material_upload_log(素材上传记录)<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-material-upload-log-%E7%B4%A0%E6%9D%90%E4%B8%8A%E4%BC%A0%E8%AE%B0%E5%BD%95"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td></td>
</tr>
<tr>
<td>relation_id</td>
<td>int</td>
<td>关联表id</td>
</tr>
<tr>
<td>type</td>
<td>int</td>
<td>类型：1-音乐；2-背景图；3-前景图；4-贴纸</td>
</tr>
<tr>
<td>media_id</td>
<td>varchar</td>
<td>阿里媒体id</td>
</tr>
<tr>
<td>result</td>
<td>text</td>
<td>上传结果</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_music(音乐)<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-music-%E9%9F%B3%E4%B9%90"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td></td>
</tr>
<tr>
<td>category_id</td>
<td>int</td>
<td>分类id</td>
</tr>
<tr>
<td>cover</td>
<td>varchar</td>
<td>封面</td>
</tr>
<tr>
<td>url</td>
<td>varchar</td>
<td>音乐分类</td>
</tr>
<tr>
<td>name</td>
<td>varchar</td>
<td>名称</td>
</tr>
<tr>
<td>sort</td>
<td>int</td>
<td>排序</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>状态:1-开启,0-关闭</td>
</tr>
<tr>
<td>media_id</td>
<td>varchar</td>
<td>媒体id</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_music_category(音乐分类)<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-music-category-%E9%9F%B3%E4%B9%90%E5%88%86%E7%B1%BB"></a></h2>
<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>sort</td>
<td>int</td>
<td>排序</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>状态:1-开启,0-关闭</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_notice_record<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-notice-record"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>ID</td>
</tr>
<tr>
<td>user_id</td>
<td>int</td>
<td>用户id</td>
</tr>
<tr>
<td>title</td>
<td>varchar</td>
<td>标题</td>
</tr>
<tr>
<td>content</td>
<td>text</td>
<td>内容</td>
</tr>
<tr>
<td>scene_id</td>
<td>int</td>
<td>场景</td>
</tr>
<tr>
<td>read</td>
<td>tinyint</td>
<td>已读状态;0-未读,1-已读</td>
</tr>
<tr>
<td>recipient</td>
<td>tinyint</td>
<td>通知接收对象类型;1-会员;2-商家;3-平台;4-游客(未注册用户)</td>
</tr>
<tr>
<td>send_type</td>
<td>tinyint</td>
<td>通知发送类型 1-系统通知 2-短信通知 3-微信模板 4-微信小程序</td>
</tr>
<tr>
<td>notice_type</td>
<td>tinyint</td>
<td>通知类型 1-业务通知 2-验证码</td>
</tr>
<tr>
<td>extra</td>
<td>varchar</td>
<td>其他</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_notice_setting<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-notice-setting"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td></td>
</tr>
<tr>
<td>scene_id</td>
<td>int</td>
<td>场景id</td>
</tr>
<tr>
<td>scene_name</td>
<td>varchar</td>
<td>场景名称</td>
</tr>
<tr>
<td>scene_desc</td>
<td>varchar</td>
<td>场景描述</td>
</tr>
<tr>
<td>recipient</td>
<td>tinyint</td>
<td>接收者 1-用户 2-平台</td>
</tr>
<tr>
<td>type</td>
<td>tinyint</td>
<td>通知类型: 1-业务通知 2-验证码</td>
</tr>
<tr>
<td>system_notice</td>
<td>text</td>
<td>系统通知设置</td>
</tr>
<tr>
<td>sms_notice</td>
<td>text</td>
<td>短信通知设置</td>
</tr>
<tr>
<td>oa_notice</td>
<td>text</td>
<td>公众号通知设置</td>
</tr>
<tr>
<td>mnp_notice</td>
<td>text</td>
<td>小程序通知设置</td>
</tr>
<tr>
<td>email_notice</td>
<td>text</td>
<td>邮箱通知设置</td>
</tr>
<tr>
<td>support</td>
<td>char</td>
<td>支持的发送类型 1-系统通知 2-短信通知 3-微信模板消息 4-小程序提醒 5-邮箱通知</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_official_account_reply<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-official-account-reply"></a></h2>
<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>keyword</td>
<td>varchar</td>
<td>关键词</td>
</tr>
<tr>
<td>reply_type</td>
<td>tinyint</td>
<td>回复类型 1-关注回复 2-关键字回复 3-默认回复</td>
</tr>
<tr>
<td>matching_type</td>
<td>tinyint</td>
<td>匹配方式：1-全匹配；2-模糊匹配</td>
</tr>
<tr>
<td>content_type</td>
<td>tinyint</td>
<td>内容类型：1-文本</td>
</tr>
<tr>
<td>content</td>
<td>text</td>
<td>回复内容</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>启动状态：1-启动；0-关闭</td>
</tr>
<tr>
<td>sort</td>
<td>int</td>
<td>排序</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_operation_log<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-operation-log"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td></td>
</tr>
<tr>
<td>admin_id</td>
<td>int</td>
<td>管理员ID</td>
</tr>
<tr>
<td>admin_name</td>
<td>varchar</td>
<td>管理员名称</td>
</tr>
<tr>
<td>account</td>
<td>varchar</td>
<td>管理员账号</td>
</tr>
<tr>
<td>action</td>
<td>varchar</td>
<td>操作名称</td>
</tr>
<tr>
<td>type</td>
<td>varchar</td>
<td>请求方式</td>
</tr>
<tr>
<td>url</td>
<td>varchar</td>
<td>访问链接</td>
</tr>
<tr>
<td>params</td>
<td>text</td>
<td>请求数据</td>
</tr>
<tr>
<td>result</td>
<td>text</td>
<td>请求结果</td>
</tr>
<tr>
<td>ip</td>
<td>varchar</td>
<td>ip地址</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_preposition(前置图)<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-preposition-%E5%89%8D%E7%BD%AE%E5%9B%BE"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td></td>
</tr>
<tr>
<td>url</td>
<td>varchar</td>
<td>前置图</td>
</tr>
<tr>
<td>sort</td>
<td>int</td>
<td>排序</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>状态:1-开启,0-关闭</td>
</tr>
<tr>
<td>media_id</td>
<td>varchar</td>
<td>媒体id</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_recharge_order<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-recharge-order"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>ID</td>
</tr>
<tr>
<td>sn</td>
<td>varchar</td>
<td>订单编号</td>
</tr>
<tr>
<td>user_id</td>
<td>int</td>
<td>用户ID</td>
</tr>
<tr>
<td>package_id</td>
<td>int</td>
<td>套餐ID</td>
</tr>
<tr>
<td>pay_sn</td>
<td>varchar</td>
<td>支付编号-冗余字段，针对微信同一主体不同客户端支付需用不同订单号预留。</td>
</tr>
<tr>
<td>pay_way</td>
<td>tinyint</td>
<td>支付方式: 2=微信支付, 3=支付宝支付</td>
</tr>
<tr>
<td>pay_status</td>
<td>tinyint</td>
<td>支付状态: 0=待支付, 1=已支付</td>
</tr>
<tr>
<td>refund_status</td>
<td>tinyint</td>
<td>退款状态: 0=未退款, 1=已退款</td>
</tr>
<tr>
<td>order_amount</td>
<td>decimal</td>
<td>订单金额</td>
</tr>
<tr>
<td>order_terminal</td>
<td>tinyint</td>
<td>终端平台</td>
</tr>
<tr>
<td>transaction_id</td>
<td>varchar</td>
<td>第三方平台交易流水号</td>
</tr>
<tr>
<td>chat_number</td>
<td>int</td>
<td>充值的对话数量</td>
</tr>
<tr>
<td>robot_number</td>
<td>int</td>
<td>充值的机器人数量</td>
</tr>
<tr>
<td>kb_number</td>
<td>int</td>
<td>充值的知识库数量</td>
</tr>
<tr>
<td>video_duration</td>
<td>int</td>
<td>充值的视频合成时长</td>
</tr>
<tr>
<td>snapshot</td>
<td>text</td>
<td>订单快照</td>
</tr>
<tr>
<td>pay_time</td>
<td>int</td>
<td>支付时间</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_recharge_package<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-recharge-package"></a></h2>
<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>remarks</td>
<td>varchar</td>
<td>套餐描述</td>
</tr>
<tr>
<td>sell_price</td>
<td>decimal</td>
<td>销售价格</td>
</tr>
<tr>
<td>line_price</td>
<td>decimal</td>
<td>划线价格</td>
</tr>
<tr>
<td>chat_number</td>
<td>int</td>
<td>问答的数量</td>
</tr>
<tr>
<td>robot_number</td>
<td>int</td>
<td>机器人数量</td>
</tr>
<tr>
<td>kb_number</td>
<td>int</td>
<td>知识库数量</td>
</tr>
<tr>
<td>video_duration</td>
<td>int</td>
<td>视频合成时长</td>
</tr>
<tr>
<td>give_chat_number</td>
<td>int</td>
<td>赠送问答的数量</td>
</tr>
<tr>
<td>give_robot_number</td>
<td>int</td>
<td>赠送机器人数量</td>
</tr>
<tr>
<td>give_kb_number</td>
<td>int</td>
<td>赠送知识库数量</td>
</tr>
<tr>
<td>give_video_duration</td>
<td>int</td>
<td>赠送视频合成时长</td>
</tr>
<tr>
<td>sort</td>
<td>int</td>
<td>排序编号</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>套餐状态: [0=关闭, 1=开启]</td>
</tr>
<tr>
<td>is_give</td>
<td>tinyint</td>
<td>赠送状态: [0=关闭, 1=开启]</td>
</tr>
<tr>
<td>is_recommend</td>
<td>tinyint</td>
<td>是否推荐: [0=否, 1=是]</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_refund_log<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-refund-log"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>id</td>
</tr>
<tr>
<td>sn</td>
<td>varchar</td>
<td>编号</td>
</tr>
<tr>
<td>record_id</td>
<td>int</td>
<td>退款记录id</td>
</tr>
<tr>
<td>user_id</td>
<td>int</td>
<td>关联用户</td>
</tr>
<tr>
<td>handle_id</td>
<td>int</td>
<td>处理人id（管理员id）</td>
</tr>
<tr>
<td>order_amount</td>
<td>decimal</td>
<td>订单总的应付款金额，冗余字段</td>
</tr>
<tr>
<td>refund_amount</td>
<td>decimal</td>
<td>本次退款金额</td>
</tr>
<tr>
<td>refund_status</td>
<td>tinyint</td>
<td>退款状态，0退款中，1退款成功，2退款失败</td>
</tr>
<tr>
<td>refund_msg</td>
<td>text</td>
<td>退款信息</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_refund_record<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-refund-record"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>id</td>
</tr>
<tr>
<td>sn</td>
<td>varchar</td>
<td>退款编号</td>
</tr>
<tr>
<td>user_id</td>
<td>int</td>
<td>关联用户</td>
</tr>
<tr>
<td>order_id</td>
<td>int</td>
<td>来源订单id</td>
</tr>
<tr>
<td>order_sn</td>
<td>varchar</td>
<td>来源单号</td>
</tr>
<tr>
<td>order_type</td>
<td>varchar</td>
<td>订单来源 order-商品订单 recharge-充值订单</td>
</tr>
<tr>
<td>order_amount</td>
<td>decimal</td>
<td>订单总的应付款金额，冗余字段</td>
</tr>
<tr>
<td>refund_amount</td>
<td>decimal</td>
<td>本次退款金额</td>
</tr>
<tr>
<td>transaction_id</td>
<td>varchar</td>
<td>第三方平台交易流水号</td>
</tr>
<tr>
<td>refund_way</td>
<td>tinyint</td>
<td>退款方式 1-线上退款 2-线下退款</td>
</tr>
<tr>
<td>refund_type</td>
<td>tinyint</td>
<td>退款类型 1-后台退款</td>
</tr>
<tr>
<td>refund_status</td>
<td>tinyint</td>
<td>退款状态，0退款中，1退款成功，2退款失败</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_sensitive_word<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-sensitive-word"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td></td>
</tr>
<tr>
<td>word</td>
<td>varchar</td>
<td>敏感词</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>状态：1-开启，0-关闭</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_sms_log<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-sms-log"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>id</td>
</tr>
<tr>
<td>scene_id</td>
<td>int</td>
<td>场景id</td>
</tr>
<tr>
<td>mobile</td>
<td>varchar</td>
<td>手机号码</td>
</tr>
<tr>
<td>content</td>
<td>varchar</td>
<td>发送内容</td>
</tr>
<tr>
<td>code</td>
<td>varchar</td>
<td>发送关键字（注册、找回密码）</td>
</tr>
<tr>
<td>is_verify</td>
<td>tinyint</td>
<td>是否已验证；0-否；1-是</td>
</tr>
<tr>
<td>check_num</td>
<td>int</td>
<td>验证次数</td>
</tr>
<tr>
<td>send_status</td>
<td>tinyint</td>
<td>发送状态：0-发送中；1-发送成功；2-发送失败</td>
</tr>
<tr>
<td>send_time</td>
<td>int</td>
<td>发送时间</td>
</tr>
<tr>
<td>results</td>
<td>text</td>
<td>短信结果</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_system_menu<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-system-menu"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>主键</td>
</tr>
<tr>
<td>pid</td>
<td>int</td>
<td>上级菜单</td>
</tr>
<tr>
<td>type</td>
<td>char</td>
<td>权限类型: M=目录，C=菜单，A=按钮</td>
</tr>
<tr>
<td>name</td>
<td>varchar</td>
<td>菜单名称</td>
</tr>
<tr>
<td>icon</td>
<td>varchar</td>
<td>菜单图标</td>
</tr>
<tr>
<td>sort</td>
<td>smallint</td>
<td>菜单排序</td>
</tr>
<tr>
<td>perms</td>
<td>varchar</td>
<td>权限标识</td>
</tr>
<tr>
<td>paths</td>
<td>varchar</td>
<td>路由地址</td>
</tr>
<tr>
<td>component</td>
<td>varchar</td>
<td>前端组件</td>
</tr>
<tr>
<td>selected</td>
<td>varchar</td>
<td>选中路径</td>
</tr>
<tr>
<td>params</td>
<td>varchar</td>
<td>路由参数</td>
</tr>
<tr>
<td>is_cache</td>
<td>tinyint</td>
<td>是否缓存: 0=否, 1=是</td>
</tr>
<tr>
<td>is_show</td>
<td>tinyint</td>
<td>是否显示: 0=否, 1=是</td>
</tr>
<tr>
<td>is_disable</td>
<td>tinyint</td>
<td>是否禁用: 0=否, 1=是</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_system_role<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-system-role"></a></h2>
<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>desc</td>
<td>varchar</td>
<td>描述</td>
</tr>
<tr>
<td>sort</td>
<td>int</td>
<td>排序</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_system_role_menu<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-system-role-menu"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>role_id</td>
<td>int</td>
<td>角色ID</td>
</tr>
<tr>
<td>menu_id</td>
<td>int</td>
<td>菜单ID</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_user<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-user"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td>主键</td>
</tr>
<tr>
<td>group_ids</td>
<td>varchar</td>
<td>分组</td>
</tr>
<tr>
<td>sn</td>
<td>int</td>
<td>编号</td>
</tr>
<tr>
<td>avatar</td>
<td>varchar</td>
<td>头像</td>
</tr>
<tr>
<td>real_name</td>
<td>varchar</td>
<td>真实姓名</td>
</tr>
<tr>
<td>nickname</td>
<td>varchar</td>
<td>用户昵称</td>
</tr>
<tr>
<td>account</td>
<td>varchar</td>
<td>用户账号</td>
</tr>
<tr>
<td>password</td>
<td>varchar</td>
<td>用户密码</td>
</tr>
<tr>
<td>mobile</td>
<td>varchar</td>
<td>手机号码</td>
</tr>
<tr>
<td>email</td>
<td>varchar</td>
<td>邮箱</td>
</tr>
<tr>
<td>sex</td>
<td>tinyint</td>
<td>用户性别: [1=男, 2=女]</td>
</tr>
<tr>
<td>channel</td>
<td>tinyint</td>
<td>注册渠道: [1-微信小程序 2-微信公众号 3-手机H5 4-电脑PC 5-苹果APP 6-安卓APP 7-后台创建]</td>
</tr>
<tr>
<td>is_disable</td>
<td>tinyint</td>
<td>是否禁用: [0=否, 1=是]</td>
</tr>
<tr>
<td>login_ip</td>
<td>varchar</td>
<td>最后登录IP</td>
</tr>
<tr>
<td>login_time</td>
<td>int</td>
<td>最后登录时间</td>
</tr>
<tr>
<td>is_new_user</td>
<td>tinyint</td>
<td>是否是新注册用户: [1-是, 0-否]</td>
</tr>
<tr>
<td>balance_chat</td>
<td>int</td>
<td>对话余额</td>
</tr>
<tr>
<td>robot_num</td>
<td>int</td>
<td>可创建机器人的次数</td>
</tr>
<tr>
<td>kb_num</td>
<td>int</td>
<td>可创建知识库的次数</td>
</tr>
<tr>
<td>total_chat</td>
<td>int</td>
<td>累计提问次数</td>
</tr>
<tr>
<td>is_blacklist</td>
<td>tinyint</td>
<td>是否在黑名单：1-是；0-否；</td>
</tr>
<tr>
<td>video_duration</td>
<td>decimal</td>
<td>视频可合成时长</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_user_account_log<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-user-account-log"></a></h2>
<table>
<thead>
<tr>
<th>字段名</th>
<th>数据类型</th>
<th>注释</th>
</tr>
</thead>
<tbody>
<tr>
<td>id</td>
<td>int</td>
<td></td>
</tr>
<tr>
<td>sn</td>
<td>varchar</td>
<td>流水号</td>
</tr>
<tr>
<td>user_id</td>
<td>int</td>
<td>用户id</td>
</tr>
<tr>
<td>admin_id</td>
<td>int</td>
<td>管理ID</td>
</tr>
<tr>
<td>change_object</td>
<td>tinyint</td>
<td>变动对象</td>
</tr>
<tr>
<td>change_type</td>
<td>smallint</td>
<td>变动类型</td>
</tr>
<tr>
<td>action</td>
<td>tinyint</td>
<td>动作 1-增加 2-减少</td>
</tr>
<tr>
<td>change_amount</td>
<td>decimal</td>
<td>变动数量</td>
</tr>
<tr>
<td>left_amount</td>
<td>decimal</td>
<td>变动后数量</td>
</tr>
<tr>
<td>source_sn</td>
<td>varchar</td>
<td>关联单号</td>
</tr>
<tr>
<td>remark</td>
<td>varchar</td>
<td>备注</td>
</tr>
<tr>
<td>extra</td>
<td>text</td>
<td>预留扩展字段</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_user_auth<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-user-auth"></a></h2>
<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>openid</td>
<td>varchar</td>
<td>微信openid</td>
</tr>
<tr>
<td>unionid</td>
<td>varchar</td>
<td>微信unionid</td>
</tr>
<tr>
<td>terminal</td>
<td>tinyint</td>
<td>客户端类型：1-微信小程序；2-微信公众号；3-手机H5；4-电脑PC；5-苹果APP；6-安卓APP</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_user_group<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-user-group"></a></h2>
<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>sort</td>
<td>smallint</td>
<td>排序</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_user_session<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-user-session"></a></h2>
<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>terminal</td>
<td>tinyint</td>
<td>客户端类型：1-微信小程序；2-微信公众号；3-手机H5；4-电脑PC；5-苹果APP；6-安卓APP</td>
</tr>
<tr>
<td>token</td>
<td>varchar</td>
<td>令牌</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>expire_time</td>
<td>int</td>
<td>到期时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_video_generate_log(数字人合成流程记录)<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-video-generate-log-%E6%95%B0%E5%AD%97%E4%BA%BA%E5%90%88%E6%88%90%E6%B5%81%E7%A8%8B%E8%AE%B0%E5%BD%95"></a></h2>
<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>records_id</td>
<td>int</td>
<td>记录id</td>
</tr>
<tr>
<td>params</td>
<td>text</td>
<td>合成参数</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>状态：1-合成中，2-合成成功，3-合成失败</td>
</tr>
<tr>
<td>type</td>
<td>tinyint</td>
<td>类型：1-数字人，2-视频点播</td>
</tr>
<tr>
<td>require_result</td>
<td>text</td>
<td>请求合成结果</td>
</tr>
<tr>
<td>result</td>
<td>text</td>
<td>合成结果</td>
</tr>
<tr>
<td>long_time</td>
<td>int</td>
<td>视频时长:毫秒</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</tbody>
</table>
<h2>cw_video_records(数字人合成记录)<a href="https://doc.chatmoney.cn/pro/develop/database.html#cw-video-records-%E6%95%B0%E5%AD%97%E4%BA%BA%E5%90%88%E6%88%90%E8%AE%B0%E5%BD%95"></a></h2>
<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>name</td>
<td>varchar</td>
<td>视频标题</td>
</tr>
<tr>
<td>params</td>
<td>text</td>
<td>参数</td>
</tr>
<tr>
<td>avatar_params</td>
<td>text</td>
<td>数字人参数</td>
</tr>
<tr>
<td>void_params</td>
<td>text</td>
<td>视频点播参数</td>
</tr>
<tr>
<td>void_type</td>
<td>tinyint</td>
<td>播报类型：1-文本；2-音频</td>
</tr>
<tr>
<td>status</td>
<td>tinyint</td>
<td>状态：1-草稿，2-合成中，3-合成成功，4-合成失败</td>
</tr>
<tr>
<td>sub_status</td>
<td>tinyint</td>
<td>子状态：1-草稿，2-数字人视频合成中，3-数字人视频合成失败，4-视频点播合成中，5-视频点播合成失败，6-视频合成完成</td>
</tr>
<tr>
<td>video_url</td>
<td>varchar</td>
<td>视频地址</td>
</tr>
<tr>
<td>cover_picture_url</td>
<td>varchar</td>
<td>视频封面图</td>
</tr>
<tr>
<td>result</td>
<td>text</td>
<td>合成结果</td>
</tr>
<tr>
<td>fail_reason</td>
<td>varchar</td>
<td>视频合成失败原因</td>
</tr>
<tr>
<td>long_time</td>
<td>varchar</td>
<td>视频时长（毫秒）</td>
</tr>
<tr>
<td>create_time</td>
<td>int</td>
<td>创建时间</td>
</tr>
<tr>
<td>update_time</td>
<td>int</td>
<td>更新时间</td>
</tr>
<tr>
<td>delete_time</td>
<td>int</td>
<td>删除时间</td>
</tr>
<tr>
</tr>
<tr>
<td></td>
</tr>
</tbody>
</table>