Zhiqim Admin(简版的管理台)是从知启蒙管理台分离出来,保留系统参数表、系统菜单表、操作员、操作日志,去除组织、部门、角色等复杂权限功能,仅保留操作员独立权限功能。系统设计时保留ZmrSessionUser和ZmrOperator类,方便以后升级到知启蒙管理台。

森中灵 最后提交于10天前 替换framework依赖包
知启蒙管理台数据库字典.dbo7KB
<?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_admin.htm
 *
 * Zhiqim Admin 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="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_OPERATOR" desc="操作员表" key="OPERATOR_CODE" type="InnoDB">
        <field column="OPERATOR_CODE" type="string" length="32" notNull="true" notField="null" 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_AVATAR" type="long" length="" notNull="false" notField="null" desc="操作员头像编号"/>
        <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_IP" type="string" length="18" notNull="false" notField="null" desc="操作员工作IP"/>
        <field column="OPERATOR_CREATED" type="datetime" length="" notNull="true" notField="null" desc="操作员创建时间,格式:yyyy-MM-dd hh:mm:ss"/>
        <field column="OPERATOR_MODIFIED" type="datetime" length="" notNull="true" notField="null" desc="操作员修改时间,格式:yyyy-MM-dd hh:mm:ss"/>
    </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="null" 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_TIME" desc="时间排序" unique="false" column="OPERATE_TIME"/>

        <field column="OPERATOR_CODE" type="string" length="32" notNull="true" notField="null" 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>