知启蒙开源平台

Zhiqim Admin（简版的管理台）是从知启蒙管理台分离出来，保留系统参数表、系统菜单表、操作员、操作日志，去除组织、部门、角色等复杂权限功能，仅保留操作员独立权限功能。系统设计时保留ZmrSessionUser和ZmrOperator类，方便以后升级到知启蒙管理台。
森中灵最后提交于5月前整理V8.0.6
返回文件列表
知启蒙管理台数据库字典.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="false" desc="菜单状态，0表示显示；1表示隐藏；2表示关闭"/>
        <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="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_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="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_TIME" desc="时间排序" unique="false" column="OPERATE_TIME"/>

        <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>