Zhiqim Master是在ZhiqimManager基础上改造成用于运营思路的管理系统,增加余额,和组织结构等,开放组织管理员,可以添加组织内的部门和角色和操作员。并增加该管理台上的一些组件,如充值支付等组件。适用于二级代理管理或该大型组织机构

森中灵 最后提交于6月前 从Zhiqim Manager切换版本至Zhiqim Master
知启蒙管理台数据库字典.dbo13KB
<?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" desc="父类菜单编码"/>
        <field column="MENU_CODE" type="string" length="32" notNull="true" desc="菜单编码"/>
        <field column="MENU_NAME" type="string" length="64" notNull="true" desc="菜单名称"/>
        <field column="MENU_NAME_ABBR" type="string" length="10" notNull="false" desc="菜单名称简称"/>
        <field column="MENU_LEVEL" type="byte" length="" notNull="true" desc="菜单级别:相对于根节点的级别"/>
        <field column="MENU_TYPE" type="byte" length="" notNull="true" desc="菜单类型:0表示根节点;1表示枝节点;2表示属性"/>
        <field column="MENU_STATUS" type="byte" length="" notNull="true" desc="菜单状态,0表示正常,1表示停用"/>
        <field column="MENU_ICON" type="string" length="32" notNull="false" desc="菜单图标"/>
        <field column="MENU_URL" type="string" length="100" notNull="false" desc="菜单对应的URL:1.当URL为空时不显示链接;2.URL允许多个path,之间用“,”分隔,链接采用第一个path;3.path作为权限的验证原子"/>
        <field column="MENU_DESC" type="string" length="100" notNull="false" desc="菜单描述"/>
    </table>

    <table name="ZMR_AVATAR" desc="系统头像表" key="AVATAR_ID" type="InnoDB">
        <field column="AVATAR_ID" type="long" length="" notNull="true" desc="头像编号"/>
        <field column="AVATAR_TYPE" type="byte" length="" notNull="true" desc="头像类型:0系统,1用户"/>
        <field column="AVATAR_TIME" type="long" length="" notNull="true" desc="头像上传时间,long型,方便转HTTP时间"/>
        <field column="AVATAR_50" type="binary" length="" notNull="true" desc="50*50头像"/>
        <field column="AVATAR_100" type="binary" length="" notNull="true" desc="100*100头像"/>
        <field column="AVATAR_150" type="binary" length="" notNull="true" 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" desc="参数组号"/>
        <field column="PARAM_KEY" type="string" length="32" notNull="true" desc="参数键"/>
        <field column="PARAM_SEQ" type="int" length="" notNull="true" desc="参数排序数"/>
        <field column="PARAM_VALUE" type="string" length="2000" notNull="false" desc="参数值,允许为空"/>
        <field column="PARAM_TYPE" type="string" length="10" notNull="true" desc="参数类型,private表示私有不显示,protected表示显示,public表示公开可修改"/>
        <field column="PARAM_VALIDATE" type="string" length="200" notNull="false" desc="参数验证"/>
        <field column="PARAM_DESC" type="string" length="200" notNull="true" desc="参数描述"/>
        <data PARAM_UPDATE="0" PARAM_DESC="首页主题(在首页主题中修改)" PARAM_VALIDATE="" PARAM_GROUP="zhiqim.manager" PARAM_SEQ="1" PARAM_VALUE="00_default" PARAM_KEY="themeIndex"/>
        <data PARAM_UPDATE="0" PARAM_DESC="主页主题(在主页主题中修改)" PARAM_VALIDATE="" PARAM_GROUP="zhiqim.manager" PARAM_SEQ="2" PARAM_VALUE="00_default" PARAM_KEY="themeMain"/>
        <data PARAM_UPDATE="1" PARAM_DESC="主题是否使用iframe风格" PARAM_VALIDATE="" PARAM_GROUP="zhiqim.manager" PARAM_SEQ="3" PARAM_VALUE="false" PARAM_KEY="themeFrame"/>
        <data PARAM_UPDATE="1" PARAM_DESC="是否使用管理页登录退出功能" PARAM_VALIDATE="" PARAM_GROUP="zhiqim.manager" PARAM_SEQ="4" PARAM_VALUE="false" PARAM_KEY="hasManageLogin"/>
        <data PARAM_UPDATE="1" PARAM_DESC="是否需要验证码" PARAM_VALIDATE="" PARAM_GROUP="zhiqim.manager" PARAM_SEQ="5" PARAM_VALUE="false" PARAM_KEY="hasVerificationCode"/>
        <data PARAM_UPDATE="1" PARAM_DESC="是否显示记住用户名" PARAM_VALIDATE="" PARAM_GROUP="zhiqim.manager" PARAM_SEQ="6" PARAM_VALUE="true" PARAM_KEY="hasRememberCode"/>
        <data PARAM_UPDATE="1" PARAM_DESC="是否显示记住密码" PARAM_VALIDATE="" PARAM_GROUP="zhiqim.manager" PARAM_SEQ="7" PARAM_VALUE="false" PARAM_KEY="hasRememberPass"/>
        <data PARAM_UPDATE="1" PARAM_DESC="登录之后的主页地址" PARAM_VALIDATE="" PARAM_GROUP="zhiqim.manager" PARAM_SEQ="8" PARAM_VALUE="/zhiqim_manager/main.htm" PARAM_KEY="mainUrl"/>
        <data PARAM_UPDATE="1" PARAM_DESC="保留操作员日志天数" PARAM_VALIDATE="" PARAM_GROUP="zhiqim.manager" PARAM_SEQ="9" PARAM_VALUE="7" PARAM_KEY="remainLogDay"/>
        <data PARAM_UPDATE="1" PARAM_DESC="操作员权限是否继承上级部门权限" PARAM_VALIDATE="" PARAM_GROUP="zhiqim.manager" PARAM_SEQ="10" PARAM_VALUE="true" PARAM_KEY="operatorDeptAllRule"/>
        <data PARAM_UPDATE="1" PARAM_DESC="如果CDN路径不为空,JS文件优先取CDN路径" PARAM_VALIDATE="" PARAM_GROUP="zhiqim.manager" PARAM_SEQ="11" PARAM_VALUE="" PARAM_KEY="cdnPath"/>
    </table>

    <table name="ZMR_PARAM_OPERATOR" desc="系统操作员参数表" key="PARAM_KEY" type="InnoDB">
        <field column="PARAM_KEY" type="string" length="32" notNull="true" desc="参数键"/>
        <field column="PARAM_DESC" type="string" length="200" notNull="true" desc="参数描述"/>
    </table>

    <table name="ZMR_ORG" desc="系统组织表" key="ORG_ID" type="InnoDB">
        <field column="ORG_ID" type="long" length="" notNull="true" desc="组织编号"/>
        <field column="ORG_NAME" type="string" length="32" notNull="true" desc="组织名称"/>
        <field column="ORG_LEVEL" type="int" length="" notNull="true" desc="组织级别"/>
        <field column="ORG_STATUS" type="byte" length="" notNull="true" desc="组织状态,0表示正常,1表示停用"/>
        <field column="ORG_SEQ" type="int" length="" notNull="true" desc="组织排序数"/>
        <field column="ORG_DESC" type="string" length="100" notNull="false" desc="组织描述"/>
        <field column="ORG_MANAGER" type="string" length="32" notNull="false" desc="组织负责人"/>
    </table>

    <table name="ZMR_ORG_RULE" desc="系统组织权限表" key="ORG_ID,MENU_CODE" type="InnoDB">
        <field column="ORG_ID" type="long" length="" notNull="true" desc="组织编号"/>
        <field column="MENU_CODE" type="string" length="32" notNull="true" desc="菜单编码"/>
    </table>

    <table name="ZMR_DEPT" desc="组织部门表" key="DEPT_ID" type="InnoDB">
        <field column="ORG_ID" type="long" length="" notNull="true" desc="组织编号"/>
        <field column="PARENT_ID" type="long" length="" notNull="true" desc="部门父编号"/>
        <field column="DEPT_ID" type="long" length="" notNull="true" desc="部门编号"/>
        <field column="DEPT_NAME" type="string" length="32" notNull="true" desc="部门名称"/>
        <field column="DEPT_LEVEL" type="int" length="" notNull="true" desc="部门级别"/>
        <field column="DEPT_STATUS" type="byte" length="" notNull="true" desc="部门状态,0表示正常,1表示停用"/>
        <field column="DEPT_SEQ" type="int" length="" notNull="true" desc="部门排序数"/>
        <field column="DEPT_PARENT_ALL" type="string" length="850" notNull="true" desc="部门所有父节点,多个逗号隔开"/>
        <field column="DEPT_MANAGER" type="string" length="32" notNull="false" desc="部门负责人"/>
        <field column="DEPT_SUB_MANAGER" type="string" length="200" notNull="false" desc="部门副负责人,多个逗号隔开"/>
        <field column="DEPT_DESC" type="string" length="100" notNull="false" desc="部门描述"/>
    </table>

    <table name="ZMR_DEPT_RULE" desc="组织部门权限表" key="DEPT_ID,MENU_CODE" type="InnoDB">
        <field column="DEPT_ID" type="long" length="" notNull="true" desc="部门编号"/>
        <field column="MENU_CODE" type="string" length="32" notNull="true" desc="菜单编码"/>
    </table>

    <table name="ZMR_ROLE" desc="角色表" key="ROLE_ID" type="InnoDB">
        <field column="ORG_ID" type="long" length="" notNull="true" desc="组织编号"/>
        <field column="ROLE_ID" type="long" length="" notNull="true" desc="角色编号"/>
        <field column="ROLE_NAME" type="string" length="32" notNull="true" desc="角色名称"/>
        <field column="ROLE_STATUS" type="byte" length="" notNull="true" desc="角色状态,0表示正常,1表示停用"/>
        <field column="ROLE_SEQ" type="int" length="" notNull="true" desc="角色排序数"/>
    </table>

    <table name="ZMR_ROLE_RULE" desc="角色权限表" key="ROLE_ID,MENU_CODE" type="InnoDB">
        <field column="ROLE_ID" type="long" length="" notNull="true" desc="角色编号"/>
        <field column="MENU_CODE" type="string" length="32" notNull="true" desc="菜单编码"/>
    </table>

    <table name="ZMR_OPERATOR" desc="操作员表" key="OPERATOR_CODE" type="InnoDB">
        <field column="ORG_ID" type="long" length="" notNull="true" desc="组织编号"/>
        <field column="OPERATOR_CODE" type="string" length="32" notNull="true" desc="操作员编码"/>
        <field column="OPERATOR_PASS" type="string" length="64,char" notNull="true" desc="操作员密码"/>
        <field column="OPERATOR_PASS_SALT" type="string" length="64,char" notNull="true" desc="操作员密码盐值"/>
        <field column="OPERATOR_STATUS" type="byte" length="" notNull="true" desc="操作员状态:0正常,1停用"/>
        <field column="OPERATOR_TYPE" type="byte" length="" notNull="true" desc="操作员类型:0:超级管理员,1:管理员,2:操作员"/>
        <field column="OPERATOR_NAME" type="string" length="64" notNull="true" desc="操作员名称"/>
        <field column="OPERATOR_BALANCE" type="long" length="" notNull="true" desc="操作员余额,单位:分"/>
        <field column="OPERATOR_AVATAR" type="long" length="" notNull="false" desc="操作员头像编号"/>
        <field column="OPERATOR_DEPT" type="string" length="850" notNull="false" desc="操作员所属部门,多个用逗号隔开,当前支持关联50个部门"/>
        <field column="OPERATOR_DEPT_ALL" type="string" length="1700" notNull="false" desc="操作员对应的所有部门,多个用逗号隔开,当前支持关联100个部门"/>
        <field column="OPERATOR_ROLE" type="string" length="850" notNull="false" desc="操作员角色,多个用逗号隔开,当前支持关联50个角色"/>
        <field column="OPERATOR_MOBILE" type="string" length="21" notNull="false" desc="操作员手机号"/>
        <field column="OPERATOR_EMAIL" type="string" length="64" notNull="false" desc="操作员邮箱"/>
        <field column="OPERATOR_SKIN" type="string" length="20" notNull="false" desc="操作员主题肤色"/>
        <field column="OPERATOR_IP" type="string" length="18" notNull="false" desc="操作员工作IP"/>
        <field column="OPERATOR_URL" type="string" length="50" notNull="false" desc="操作员登录后首页"/>
        <field column="OPERATOR_PARAM" type="string" length="1024" notNull="false" desc="操作员参数,用于项目自定义设置"/>
        <field column="OPERATOR_CREATED" type="datetime" length="" notNull="true" desc="操作员创建时间"/>
        <field column="OPERATOR_MODIFIED" type="datetime" length="" notNull="true" 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" desc="操作员编码"/>
        <field column="MENU_CODE" type="string" length="32" notNull="true" 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" desc="组织编号"/>
        <field column="OPERATOR_CODE" type="string" length="32" notNull="true" desc="操作员编码"/>
        <field column="OPERATE_TIME" type="datetime" length="" notNull="true" desc="操作时间,格式:yyyy-MM-dd hh:mm:ss"/>
        <field column="OPERATE_IP" type="string" length="15" notNull="true" desc="操作IP地址"/>
        <field column="OPERATE_FEATURE" type="string" length="50" notNull="true" desc="操作功能"/>
        <field column="OPERATE_DESC" type="string" length="2000" notNull="false" desc="操作描述"/>
    </table>

</package>

</zhiqim-dbo>