ziqim/zhiqim_plan/document/知启蒙项目计划组件数据库字典.dbo

<?xml version="1.0" encoding="UTF-8"?>
<zhiqim-dbo>

<config version="1.2.0" dbType="mysql" folder="../src" initDataWidth="820">
<![CDATA[
/*
 * 版权所有 (C) 2015 知启蒙(ZHIQIM) 保留所有权利。[欢迎加盟知启蒙，一起邂逅框架梦]
 * 
 * https://www.zhiqim.com/gitcan/zhiqim/zhiqim_plan.htm
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
]]>
</config>

<package name="org.zhiqim.manager.dbo" type="false" desc="项目管理表">

    <table name="ZMR_OPERATOR" desc="操作员表" key="OPERATOR_CODE" type="InnoDB">
        <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_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_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="string" length="19,char" notNull="true" desc="操作员创建时间,格式：yyyy-MM-dd hh:mm:ss"/>
        <field column="OPERATOR_MODIFIED" type="string" length="19,char" notNull="true" desc="操作员修改时间,格式：yyyy-MM-dd hh:mm:ss"/>
    </table>

</package>
<package name="org.zhiqim.project.dbo" type="false" desc="项目管理表">

    <table name="ZPM_PROJECT" desc="项目工程表" key="PROJECT_ID" type="InnoDB">
        <field column="PROJECT_ID" type="long" length="" notNull="true" desc="项目编号"/>
        <field column="PROJECT_NAME" type="string" length="64" notNull="true" desc="项目名称"/>
        <field column="PROJECT_STATUS" type="byte" length="" notNull="true" desc="项目状态，0：正常，1：停用"/>
        <field column="PROJECT_SEQ" type="int" length="" notNull="true" desc="项目排序数"/>
        <field column="PROJECT_MANAGER" type="string" length="32" notNull="true" desc="项目组长"/>
        <field column="PROJECT_BEGIN_DATE" type="string" length="10,char" notNull="true" desc="项目开始时间"/>
        <field column="PROJECT_END_DATE" type="string" length="10,char" notNull="true" desc="项目结束时间"/>
        <field column="PROJECT_CREATED" type="string" length="19,char" notNull="true" desc="项目创建时间"/>
        <field column="PROJECT_MODIFIED" type="string" length="19,char" notNull="true" desc="项目修改时间"/>
        <field column="PROJECT_DESC" type="string" length="512" notNull="false" desc="项目描述"/>
    </table>

</package>
<package name="org.zhiqim.plan.dbo" type="true" desc="系统表">

    <table name="ZPM_PROJECT_PLAN" desc="项目计划表" key="PLAN_ID" type="InnoDB">
        <field column="PROJECT_ID" type="long" length="" notNull="true" desc="项目编号"/>
        <field column="PLAN_ID" type="long" length="" notNull="true" desc="计划编号"/>
        <field column="PLAN_DATE" type="int" length="" notNull="true" desc="计划日期，格式yyyyMMdd，如20171101"/>
        <field column="PLAN_STATUS" type="byte" length="" notNull="true" desc="计划状态，0：正常，1：新增，2：延误，3：取消"/>
        <field column="PLAN_SEQ" type="byte" length="" notNull="true" desc="计划序号，从1开始，周内排序"/>
        <field column="PLAN_PROGRESS" type="byte" length="" notNull="true" desc="计划进度，0-100"/>
        <field column="PLAN_MODIFIED" type="datetime" length="" notNull="true" desc="计划更新时间"/>
        <field column="PLAN_CONTENT" type="string" length="128" notNull="false" desc="计划内容"/>
        <field column="PLAN_MANAGER" type="string" length="32" notNull="false" desc="计划负责人，多个用逗号隔开"/>
        <field column="PLAN_BEGIN_DATE" type="string" length="10,char" notNull="false" desc="计划开始日期"/>
        <field column="PLAN_END_DATE" type="string" length="10,char" notNull="false" desc="计划结束日期"/>
        <field column="ACTUAL_BEGIN_DATE" type="string" length="10,char" notNull="false" desc="实际开始日期"/>
        <field column="ACTUAL_END_DATE" type="string" length="10,char" notNull="false" desc="实际结束日期"/>
    </table>

    <table name="ZPM_PROJECT_SUMMARY" desc="项目总结表" key="SUMMARY_ID" type="InnoDB">
        <field column="PROJECT_ID" type="long" length="" notNull="true" desc="项目编号"/>
        <field column="SUMMARY_ID" type="long" length="" notNull="true" desc="总结编号"/>
        <field column="SUMMARY_TYPE" type="byte" length="" notNull="true" desc="总结类型，1：周目标，2：周总结，3：月总结"/>
        <field column="SUMMARY_DATE" type="int" length="" notNull="true" desc="总结日期，格式yyyyMMdd，如20171101"/>
        <field column="SUMMARY_MODIFIED" type="datetime" length="" notNull="true" desc="总结最后更新时间"/>
        <field column="SUMMARY_CONTENT" type="string" length="1000" notNull="false" desc="总结内容，最长1000字"/>
    </table>

    <table name="ZPM_PERSON_PLAN" desc="个人计划表" key="PLAN_ID" type="InnoDB">
        <field column="OPERATOR_CODE" type="string" length="32" notNull="true" desc="操作员编号"/>
        <field column="PLAN_ID" type="long" length="" notNull="true" desc="计划编号"/>
        <field column="PLAN_DATE" type="int" length="" notNull="true" desc="计划日期，格式yyyyMMdd，如20171101"/>
        <field column="PLAN_STATUS" type="byte" length="" notNull="true" desc="计划状态，0：正常，1：新增，2：延误，3：取消"/>
        <field column="PLAN_SEQ" type="byte" length="" notNull="true" desc="计划序号，从1开始，周内排序"/>
        <field column="PLAN_MODIFIED" type="datetime" length="" notNull="true" desc="计划最后更新时间"/>
        <field column="PLAN_CONTENT" type="string" length="256" notNull="false" desc="计划内容"/>
    </table>

    <table name="ZPM_PERSON_SUMMARY" desc="个人总结表" key="SUMMARY_ID" type="InnoDB">
        <field column="OPERATOR_CODE" type="string" length="32" notNull="true" desc="操作员编号"/>
        <field column="SUMMARY_ID" type="long" length="" notNull="true" desc="总结编号"/>
        <field column="SUMMARY_TYPE" type="byte" length="" notNull="true" desc="总结类型，1：日总结，2：周总结，3：月总结"/>
        <field column="SUMMARY_DATE" type="int" length="" notNull="true" desc="总结日期，格式yyyyMMdd，如20171101"/>
        <field column="SUMMARY_MODIFIED" type="datetime" length="" notNull="true" desc="总结最后更新时间"/>
        <field column="SUMMARY_CONTENT" type="string" length="1000" notNull="false" desc="总结内容，最长1000字"/>
    </table>

</package>

</zhiqim-dbo>