Zhiqim Account（前端账户管理台）是在ZhiqimManager基础上改造成用于前端注册登录的管理系统，增加组织结构和余额，开放注册组织和组织管理员，可以添加组织内的部门和角色和操作员。并增加该管理台上的一些组件，如充值支付等组件。适用于二级代理管理或该大型组织机构
知启蒙管理台数据库字典.dbo17KB
<?xml version="1.0" encoding="UTF-8"?>
<zhiqim-dbo>
<config version="1.2.0" dbType="mysql" folder="../src" initDataWidth="820">
<![CDATA[
/*
* 版权所有 (C) 2015 知启蒙(ZHIQIM) 保留所有权利。[遇见知启蒙，邂逅框架梦]
*
* https://zhiqim.org/project/zhiqim_components/zhiqim_account.htm
*
* Zhiqim Account is licensed under Mulan PSL v2.
* You can use this software according to the terms and conditions of the Mulan PSL v2.
* You may obtain a copy of Mulan PSL v2 at:
* http://license.coscl.org.cn/MulanPSL2
* THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
* EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
* MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
* See the Mulan PSL v2 for more details.
*/
]]>
</config>
<package name="org.zhiqim.manager.dbo" type="true" desc="知启蒙管理台表">
<table name="ZMR_PARAM" desc="系统参数表" key="PARAM_GROUP,PARAM_KEY" type="InnoDB">
<field column="PARAM_GROUP" type="string" length="32" notNull="true" notField="null" desc="参数组号"/>
<field column="PARAM_KEY" type="string" length="32" notNull="true" notField="null" desc="参数键"/>
<field column="PARAM_SEQ" type="int" length="" notNull="true" notField="null" desc="参数排序数"/>
<field column="PARAM_VALUE" type="string" length="2000" notNull="false" notField="null" desc="参数值，允许为空"/>
<field column="PARAM_TYPE" type="string" length="10" notNull="true" notField="null" desc="参数类型，private表示私有不显示，protected表示显示，public表示公开可修改"/>
<field column="PARAM_VALIDATE" type="string" length="200" notNull="false" notField="null" desc="参数验证"/>
<field column="PARAM_DESC" type="string" length="200" notNull="true" notField="null" desc="参数描述"/>
</table>
<table name="ZMR_MENU" desc="系统菜单信息表" key="MENU_CODE" type="InnoDB">
<field column="PARENT_CODE" type="string" length="32" notNull="true" notField="false" desc="父类菜单编码"/>
<field column="MENU_CODE" type="string" length="32" notNull="true" notField="false" desc="菜单编码"/>
<field column="MENU_NAME" type="string" length="64" notNull="true" notField="false" desc="菜单名称"/>
<field column="MENU_NAME_ABBR" type="string" length="10" notNull="false" notField="false" desc="菜单名称简称"/>
<field column="MENU_LEVEL" type="byte" length="" notNull="true" notField="false" desc="菜单级别：相对于根节点的级别"/>
<field column="MENU_TYPE" type="byte" length="" notNull="true" notField="false" desc="菜单类型：0表示根节点；1表示枝节点；2表示属性"/>
<field column="MENU_STATUS" type="int" length="" notNull="true" notField="false" desc="菜单状态，0表示显示；1表示隐藏；2表示关闭"/>
<field column="MENU_ICON" type="string" length="200" notNull="false" notField="false" desc="菜单图标"/>
<field column="MENU_URL" type="string" length="100" notNull="true" notField="false" desc="菜单对应的URL：1.当URL为空时不显示链接；2.URL允许多个path，之间用“,”分隔，链接采用第一个path；3.path作为权限的验证原子"/>
<field column="MENU_DESC" type="string" length="32" notNull="true" notField="false" desc="菜单描述"/>
</table>
<table name="ZMR_AVATAR" desc="系统头像表" key="AVATAR_ID" type="InnoDB">
<field column="AVATAR_ID" type="long" length="" notNull="true" notField="null" desc="头像编号"/>
<field column="AVATAR_TYPE" type="byte" length="" notNull="true" notField="null" desc="头像类型：0系统，1用户"/>
<field column="AVATAR_TIME" type="long" length="" notNull="true" notField="null" desc="头像上传时间，long型，方便转HTTP时间"/>
<field column="AVATAR_50" type="binary" length="" notNull="true" notField="null" desc="50*50头像"/>
<field column="AVATAR_100" type="binary" length="" notNull="true" notField="null" desc="100*100头像"/>
<field column="AVATAR_150" type="binary" length="" notNull="true" notField="null" desc="150*150头像"/>
</table>
<table name="ZMR_ORG" desc="系统组织表" key="ORG_ID" type="InnoDB">
<field column="ORG_ID" type="long" length="" notNull="true" notField="false" desc="组织编号"/>
<field column="ORG_NAME" type="string" length="64" notNull="true" notField="false" desc="组织名称"/>
<field column="ORG_LEVEL" type="int" length="" notNull="true" notField="false" desc="组织级别，目前0：根组织，1：商户"/>
<field column="ORG_STATUS" type="int" length="" notNull="true" notField="false" desc="组织状态，0：正常，1：停用"/>
<field column="ORG_SEQ" type="int" length="" notNull="true" notField="false" desc="组织排序号"/>
<field column="ORG_TYPES" type="string" length="200" notNull="false" notField="false" desc="组织权限分组，多个逗号隔开"/>
<field column="ORG_BALANCE" type="long" length="" notNull="true" notField="false" desc="商户余额，分"/>
<field column="ORG_BALANCE_GIFT" type="long" length="" notNull="true" notField="false" desc="商户赠送余额，分"/>
<field column="ORG_VIP" type="string" length="20" notNull="false" notField="false" desc="VIP等级"/>
<field column="ORG_PAYMENT" type="string" length="32" notNull="false" notField="false" desc="用户默认支付方式"/>
<field column="ORG_CREATED" type="datetime" length="" notNull="true" notField="false" desc="商户注册时间"/>
</table>
<table name="ZMR_ORG_TYPE" desc="系统组织类型表" key="ORG_TYPE_ID" type="InnoDB">
<field column="ORG_TYPE_ID" type="long" length="" notNull="true" notField="false" desc="组织类型编号"/>
<field column="ORG_TYPE_NAME" type="string" length="64" notNull="true" notField="false" desc="组织类型名称"/>
<field column="ORG_TYPE_VALID" type="boolean" length="" notNull="true" notField="false" desc="组织类型状态"/>
<field column="ORG_TYPE_DEFAULT" type="boolean" length="" notNull="true" notField="false" desc="组织类型默认"/>
</table>
<table name="ZMR_ORG_TYPE_RULE" desc="系统组织类型权限表" key="ORG_TYPE_ID,MENU_CODE" type="InnoDB">
<field column="ORG_TYPE_ID" type="long" length="" notNull="true" notField="false" desc="组织类型编号"/>
<field column="MENU_CODE" type="string" length="32" notNull="true" notField="false" desc="菜单编码"/>
</table>
<table name="ZMR_DEPT" desc="组织部门表" key="DEPT_ID" type="InnoDB">
<field column="ORG_ID" type="long" length="" notNull="true" notField="null" desc="组织编号"/>
<field column="PARENT_ID" type="long" length="" notNull="true" notField="null" desc="部门父编号"/>
<field column="DEPT_ID" type="long" length="" notNull="true" notField="null" desc="部门编号"/>
<field column="DEPT_NAME" type="string" length="32" notNull="true" notField="null" desc="部门名称"/>
<field column="DEPT_LEVEL" type="int" length="" notNull="true" notField="null" desc="部门级别"/>
<field column="DEPT_STATUS" type="int" length="" notNull="true" notField="null" desc="部门状态，0：正常，1：停用"/>
<field column="DEPT_SEQ" type="int" length="" notNull="true" notField="null" desc="部门序号"/>
<field column="DEPT_PARENT_ALL" type="string" length="850" notNull="false" notField="null" desc="部门所有父节点"/>
<field column="DEPT_MANAGER" type="string" length="32" notNull="false" notField="false" desc="部门负责人（操作员账号）"/>
<field column="DEPT_SUB_MANAGER" type="string" length="200" notNull="false" notField="false" desc="部门副负责人，多个逗号分隔"/>
<field column="DEPT_DESC" type="string" length="200" notNull="false" notField="null" desc="部门描述"/>
</table>
<table name="ZMR_DEPT_RULE" desc="组织部门权限表" key="ORG_ID,DEPT_ID,MENU_CODE" type="InnoDB">
<field column="ORG_ID" type="long" length="" notNull="true" notField="false" desc="组织编号"/>
<field column="DEPT_ID" type="long" length="" notNull="true" notField="null" desc="部门编号"/>
<field column="MENU_CODE" type="string" length="32" notNull="true" notField="null" desc="菜单编码"/>
</table>
<table name="ZMR_ROLE" desc="组织角色表" key="ROLE_ID" type="InnoDB">
<field column="ORG_ID" type="long" length="" notNull="true" notField="null" desc="组织编号"/>
<field column="ROLE_ID" type="long" length="" notNull="true" notField="null" desc="角色编号"/>
<field column="ROLE_NAME" type="string" length="32" notNull="true" notField="null" desc="角色名称"/>
<field column="ROLE_TYPE" type="int" length="" notNull="true" notField="null" desc="角色类型，0：普通，1：系统"/>
<field column="ROLE_STATUS" type="int" length="" notNull="true" notField="null" desc="角色状态，0：正常，1：停用"/>
<field column="ROLE_SEQ" type="int" length="" notNull="true" notField="null" desc="角色序号"/>
</table>
<table name="ZMR_ROLE_RULE" desc="组织角色权限表" key="ROLE_ID,MENU_CODE" type="InnoDB">
<field column="ROLE_ID" type="long" length="" notNull="true" notField="null" desc="角色编号"/>
<field column="MENU_CODE" type="string" length="32" notNull="true" notField="false" desc="导航ID"/>
</table>
<table name="ZMR_PARAM_OPERATOR" desc="系统操作员参数表" key="PARAM_KEY" type="InnoDB">
<field column="PARAM_KEY" type="string" length="32" notNull="true" notField="null" desc="参数键"/>
<field column="PARAM_SEQ" type="int" length="" notNull="true" notField="null" desc="参数排序数"/>
<field column="PARAM_NAME" type="string" length="32" notNull="true" notField="null" desc="参数中文名称"/>
<field column="PARAM_TYPE" type="string" length="10" notNull="true" notField="null" desc="参数类型，private表示私有不显示，protected表示显示，public表示公开可修改"/>
<field column="PARAM_VALIDATE" type="string" length="200" notNull="false" notField="null" desc="参数验证"/>
<field column="PARAM_DESC" type="string" length="200" notNull="true" notField="null" desc="参数描述"/>
</table>
<table name="ZMR_OPERATOR" desc="操作员表" key="OPERATOR_CODE" type="InnoDB">
<field column="ORG_ID" type="long" length="" notNull="true" notField="null" desc="组织编号"/>
<field column="OPERATOR_CODE" type="string" length="32" notNull="true" notField="false" desc="操作员账号，系统内唯一"/>
<field column="OPERATOR_PASS" type="string" length="64" notNull="false" notField="false" desc="操作员密码"/>
<field column="OPERATOR_PASS_SALT" type="string" length="64" notNull="false" notField="false" desc="操作员密码盐值"/>
<field column="OPERATOR_VALID" type="boolean" length="" notNull="true" notField="false" desc="操作员状态：1：正常，0：停用"/>
<field column="OPERATOR_TYPE" type="byte" length="" notNull="true" notField="false" desc="用户类型：0：系统管理员,1：超级管理员，2:普通用户"/>
<field column="OPERATOR_NAME" type="string" length="20" notNull="false" notField="false" desc="操作员名称"/>
<field column="OPERATOR_MOBILE" type="string" length="11" notNull="false" notField="false" desc="操作员手机，一个手机最多绑定5个用户"/>
<field column="OPERATOR_MOBILE_LOGIN" type="boolean" length="" notNull="false" notField="false" desc="操作员手机登录"/>
<field column="OPERATOR_EMAIL" type="string" length="50" notNull="false" notField="false" desc="操作员邮箱，一个邮箱最多绑定5个账号"/>
<field column="OPERATOR_AVATAR" type="long" length="" notNull="true" notField="false" desc="操作员头像"/>
<field column="OPERATOR_DEPT" type="string" length="850" notNull="false" notField="false" desc="操作员所属部门，多个用逗号隔开，当前支持关联50个部门"/>
<field column="OPERATOR_DEPT_ALL" type="string" length="1700" notNull="false" notField="false" desc="操作员对应的所有部门，多个用逗号隔开，当前支持关联100个部门"/>
<field column="OPERATOR_ROLE" type="string" length="850" notNull="false" notField="false" desc="操作员角色，多个用逗号隔开，当前支持关联50个角色"/>
<field column="OPERATOR_SEX" type="byte" length="" notNull="true" notField="false" desc="操作员性别，0：保密，1：男，2：女"/>
<field column="OPERATOR_PARAM" type="string" length="1024" notNull="false" notField="false" desc="操作员参数，用于项目自定义设置"/>
<field column="OPERATOR_CREATED" type="datetime" length="" notNull="true" notField="false" desc="操作员注册时间"/>
<field column="OPERATOR_MODIFIED" type="datetime" length="" notNull="true" notField="false" desc="操作员更新时间"/>
<field column="OPERATOR_LOGINED" type="datetime" length="" notNull="true" notField="false" desc="操作员最后登录时间"/>
</table>
<table name="ZMR_OPERATOR_RULE" desc="操作员独立权限表" key="OPERATOR_CODE,MENU_CODE" type="InnoDB">
<field column="OPERATOR_CODE" type="string" length="32" notNull="true" notField="false" desc="操作员账号，系统内唯一"/>
<field column="MENU_CODE" type="string" length="32" notNull="true" notField="false" desc="导航ID"/>
</table>
<table name="ZMR_OPERATOR_LOG" desc="操作员日志表" key="" type="InnoDB">
<index name="IX_ZMR_OPERATOR_LOG_ORG_TIME" desc="组织时间排序" unique="false" column="ORG_ID,OPERATE_TIME"/>
<field column="ORG_ID" type="long" length="" notNull="true" notField="null" desc="组织编号"/>
<field column="OPERATOR_CODE" type="string" length="32" notNull="true" notField="false" desc="操作员账号"/>
<field column="OPERATE_TIME" type="datetime" length="" notNull="true" notField="null" desc="操作时间,格式：yyyy-MM-dd hh:mm:ss"/>
<field column="OPERATE_IP" type="string" length="15" notNull="true" notField="null" desc="操作IP地址"/>
<field column="OPERATE_FEATURE" type="string" length="50" notNull="true" notField="null" desc="操作功能"/>
<field column="OPERATE_DESC" type="string" length="2000" notNull="false" notField="null" desc="操作描述"/>
</table>
<table name="ZMR_VCODE" desc="操作员验证表" key="VCODE_ID" type="InnoDB">
<field column="USER_NUMBER" type="string" length="11" notNull="true" notField="false" desc="操作员手机号"/>
<field column="VCODE_ID" type="long" length="" notNull="true" notField="false" desc="验证码编号"/>
<field column="VCODE_TYPE" type="byte" length="" notNull="true" notField="false" desc="验证码类型，0：注册验证，1：忘记密码，2：修改手机号，3：修改邮箱"/>
<field column="VCODE_VALUE" type="string" length="6" notNull="true" notField="false" desc="验证码值"/>
<field column="VCODE_STATUS" type="int" length="" notNull="true" notField="false" desc="验证码状态，0：未使用，1：已使用，2：失效"/>
<field column="VCODE_DATE" type="string" length="10" notNull="true" notField="false" desc="验证码发送日期，yyyy-MM-dd"/>
<field column="VCODE_END_TIME" type="string" length="19,char" notNull="true" notField="false" desc="验证码失效时间"/>
</table>
<table name="ZMR_SMS" desc="短信日志表" key="SMS_ID" type="InnoDB">
<field column="OPERATOR_CODE" type="string" length="32" notNull="true" notField="false" desc="操作员"/>
<field column="SMS_ID" type="long" length="" notNull="true" notField="false" desc="短信编号"/>
<field column="SMS_RECEIVER" type="long" length="" notNull="true" notField="false" desc="短信接收者"/>
<field column="SMS_MOBILE" type="long" length="" notNull="true" notField="false" desc="短信手机号"/>
<field column="SMS_CONTENT" type="string" length="200" notNull="true" notField="false" desc="短信内容"/>
<field column="SMS_TIME" type="datetime" length="" notNull="true" notField="false" desc="短信发送时间"/>
<field column="SMS_RESULT" type="byte" length="" notNull="true" notField="false" desc="短信发送结果，=0表示成功"/>
<field column="SMS_REMARK" type="string" length="400" notNull="false" notField="false" desc="短信备注"/>
</table>
<view name="ZMR_ORG_TYPE_MENU" type="true" desc="组织类型菜单视图" table="ZMR_MENU,ZMR_ORG_TYPE_RULE">
<join type="EQUAL" lTable="ZMR_MENU" lColumn="MENU_CODE" rTable="ZMR_ORG_TYPE_RULE" rColumn="MENU_CODE"/>
<field column="*" table="ZMR_MENU"/>
<field column="ORG_TYPE_ID" table="ZMR_ORG_TYPE_RULE"/>
</view>
<view name="ZMR_OPERATOR_ORG" type="true" desc="操作员组织视图" table="ZMR_OPERATOR,ZMR_ORG">
<join type="EQUAL" lTable="ZMR_OPERATOR" lColumn="ORG_ID" rTable="ZMR_ORG" rColumn="ORG_ID"/>
<field column="*" table="ZMR_OPERATOR"/>
<field column="ORG_STATUS" table="ZMR_ORG"/>
<field column="ORG_NAME" table="ZMR_ORG"/>
<field column="ORG_LEVEL" table="ZMR_ORG"/>
<field column="ORG_TYPES" table="ZMR_ORG"/>
</view>
</package>
</zhiqim-dbo>