首页
学习
工程
  • Zhiqim Framework 融合Java+HTML5的更轻量的后端程序和WEB程序框架
  • Zhiqim Kit 基于知启蒙框架的各类工具集合，如数据库、PDF等
  • Zhiqim TKSee 基于CEF开发的桌面端程序框架
  • Zhiqim Components 基于知启蒙框架，高度可重用的业务和功能组件模块
  • Zhiqim Products 知启蒙发布的产品，下载解压后可以直接运行使用
登录&注册
当前位置：  工程  >>  项目  >>  项目文件

Zhiqim Manager（知启蒙管理台）是知启蒙框架中最核心的基础组件，大部分后台组件和产品都依赖该组件。因为管理台提供了核心的系统配置、菜单、操作员、部门、角色等权限功能，以及6种皮肤样式可供选择

森中灵 最后提交于3月前 修复切换frame模式时未情况includeUrl
返回文件列表
知启蒙管理台数据库字典.dbo12KB 
<?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="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_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_DEPT" desc="部门表" key="DEPT_ID" type="InnoDB">
        <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="DEPT_TYPE" type="InnoDB">
        <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="DEPT_ID,MENU_CODE" type="InnoDB">
        <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="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="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="null" desc="菜单编码"/>
    </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_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_IP" type="string" length="18" notNull="false" notField="null" desc="操作员工作IP"/>
        <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="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>