Zhiqim Master(运营管理台)是在ZhiqimManager基础上改造成用于运营思路的管理系统,增加余额,和组织结构等,开放组织管理员,可以添加组织内的部门和角色和操作员。并增加该管理台上的一些组件,如充值支付等组件。适用于二级代理管理或该大型组织机构
阿斌 最后提交于3月前 修改切换组织错误
知启蒙管理台数据库字典.dbo14KB
<?xml version="1.0" encoding="UTF-8"?>
<zhiqim-dbo>
<config version="1.2.0" dbType="mysql" folder="../src" initDataWidth="1000">
<![CDATA[
/*
* 版权所有 (C) 2015 知启蒙(ZHIQIM) 保留所有权利。[遇见知启蒙,邂逅框架梦]
*
* https://zhiqim.org/project/zhiqim_components/zhiqim_manager.htm
*
* Zhiqim Manager 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_MENU" desc="系统菜单表" key="MENU_CODE" type="InnoDB">
<field column="PARENT_CODE" type="string" length="32" notNull="true" notField="null" desc="父类菜单编码"/>
<field column="MENU_CODE" type="string" length="32" notNull="true" notField="null" desc="菜单编码"/>
<field column="MENU_NAME" type="string" length="64" notNull="true" notField="null" desc="菜单名称"/>
<field column="MENU_NAME_ABBR" type="string" length="10" notNull="false" notField="null" desc="菜单名称简称"/>
<field column="MENU_LEVEL" type="byte" length="" notNull="true" notField="null" desc="菜单级别:相对于根节点的级别"/>
<field column="MENU_TYPE" type="byte" length="" notNull="true" notField="null" desc="菜单类型:0表示根节点;1表示枝节点;2表示属性"/>
<field column="MENU_STATUS" type="byte" length="" notNull="true" notField="null" desc="菜单状态,0表示正常,1表示停用"/>
<field column="MENU_ICON" type="string" length="32" notNull="false" notField="null" desc="菜单图标"/>
<field column="MENU_URL" type="string" length="100" notNull="false" notField="null" desc="菜单对应的URL:1.当URL为空时不显示链接;2.URL允许多个path,之间用“,”分隔,链接采用第一个path;3.path作为权限的验证原子"/>
<field column="MENU_DESC" type="string" length="100" notNull="false" notField="null" 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_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_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_ORG" desc="系统组织表" key="ORG_ID" type="InnoDB">
<field column="ORG_ID" type="long" length="" notNull="true" notField="null" desc="组织编号"/>
<field column="ORG_NAME" type="string" length="32" notNull="true" notField="null" desc="组织名称"/>
<field column="ORG_LEVEL" type="int" length="" notNull="true" notField="null" desc="组织级别"/>
<field column="ORG_STATUS" type="byte" length="" notNull="true" notField="null" desc="组织状态,0表示正常,1表示停用"/>
<field column="ORG_SEQ" type="int" length="" notNull="true" notField="null" desc="组织排序数"/>
<field column="ORG_DESC" type="string" length="100" notNull="false" notField="null" desc="组织描述"/>
<field column="ORG_MANAGER" type="string" length="32" notNull="false" notField="null" desc="组织负责人"/>
</table>
<table name="ZMR_ORG_RULE" desc="系统组织权限表" key="ORG_ID,MENU_CODE" type="InnoDB">
<field column="ORG_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_DEPT" desc="组织部门表" key="ORG_ID,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_TYPE" type="long" length="" notNull="true" notField="false" desc="部门类型"/>
<field column="DEPT_VALID" type="boolean" length="" notNull="true" notField="false" desc="部门状态,1表示正常,0表示停用"/>
<field column="DEPT_SEQ" type="int" length="" notNull="true" notField="null" desc="部门排序数"/>
<field column="DEPT_PARENT_ALL" type="string" length="850" notNull="true" notField="null" desc="部门所有父节点,多个逗号隔开"/>
<field column="DEPT_MANAGER" type="string" length="32" notNull="false" notField="null" desc="部门负责人"/>
<field column="DEPT_SUB_MANAGER" type="string" length="200" notNull="false" notField="null" desc="部门副负责人,多个逗号隔开"/>
<field column="DEPT_DESC" type="string" length="100" notNull="false" notField="null" desc="部门描述"/>
</table>
<table name="ZMR_DEPT_TYPE" desc="部门类型表" key="ORG_ID,DEPT_TYPE" type="InnoDB">
<field column="ORG_ID" type="long" length="" notNull="true" notField="false" desc="组织编号"/>
<field column="DEPT_TYPE" type="long" length="" notNull="true" notField="false" desc="部门类型编号"/>
<field column="DEPT_TYPE_NAME" type="string" length="50" notNull="true" notField="false" desc="部门类型名称"/>
<field column="DEPT_TYPE_VALID" type="boolean" length="" notNull="true" notField="false" desc="部门类型状态"/>
<field column="DEPT_TYPE_SEQ" type="int" length="" notNull="true" notField="false" desc="部门类型排序数"/>
<field column="DEPT_TYPE_SYS" type="boolean" length="" notNull="true" notField="false" 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="ORG_ID,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_VALID" type="boolean" length="" notNull="true" notField="false" desc="角色状态,1表示正常,0表示停用"/>
<field column="ROLE_SYS" type="boolean" length="" notNull="true" notField="false" desc="角色类型,true表示系统角色,false表示自定义角色"/>
<field column="ROLE_SEQ" type="int" length="" notNull="true" notField="null" desc="角色排序数"/>
</table>
<table name="ZMR_ROLE_RULE" desc="组织角色权限表" key="ORG_ID,ROLE_ID,MENU_CODE" type="InnoDB">
<field column="ORG_ID" type="long" length="" notNull="true" notField="false" desc="组织编号"/>
<field column="ROLE_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_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,char" notNull="true" notField="null" desc="操作员密码"/>
<field column="OPERATOR_PASS_SALT" type="string" length="64,char" notNull="true" notField="null" 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="null" desc="操作员类型:0:超级管理员,1:管理员,2:操作员"/>
<field column="OPERATOR_NAME" type="string" length="64" notNull="true" notField="null" desc="操作员名称"/>
<field column="OPERATOR_BALANCE" type="long" length="" notNull="true" notField="null" desc="操作员余额,单位:分"/>
<field column="OPERATOR_AVATAR" type="long" length="" notNull="false" notField="null" desc="操作员头像编号"/>
<field column="OPERATOR_DEPT" type="string" length="850" notNull="false" notField="null" desc="操作员所属部门,多个用逗号隔开,当前支持关联50个部门"/>
<field column="OPERATOR_DEPT_ALL" type="string" length="1700" notNull="false" notField="null" desc="操作员对应的所有部门,多个用逗号隔开,当前支持关联100个部门"/>
<field column="OPERATOR_ROLE" type="string" length="850" notNull="false" notField="null" desc="操作员角色,多个用逗号隔开,当前支持关联50个角色"/>
<field column="OPERATOR_MOBILE" type="string" length="21" notNull="false" notField="null" desc="操作员手机号"/>
<field column="OPERATOR_EMAIL" type="string" length="64" notNull="false" notField="null" desc="操作员邮箱"/>
<field column="OPERATOR_SKIN" type="string" length="20" notNull="false" notField="null" desc="操作员主题肤色"/>
<field column="OPERATOR_IP" type="string" length="18" notNull="false" notField="null" desc="操作员工作IP"/>
<field column="OPERATOR_URL" type="string" length="50" notNull="false" notField="null" desc="操作员登录后首页"/>
<field column="OPERATOR_PARAM" type="string" length="1024" notNull="false" notField="null" desc="操作员参数,用于项目自定义设置"/>
<field column="OPERATOR_CREATED" type="datetime" length="" notNull="true" notField="null" desc="操作员创建时间"/>
<field column="OPERATOR_MODIFIED" type="datetime" length="" notNull="true" notField="null" 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="null" desc="菜单编码"/>
</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>
</package>
</zhiqim-dbo>