ziqim/zhiqim_orm/document/数据库字典V1.3.dbo

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

<config version="1.2.0" dbType="mysql" folder="../test" initDataWidth="1000">
<![CDATA[
/*
 * 版权所有 (C) 2015 知启蒙(ZHIQIM) 保留所有权利。[遇见知启蒙，邂逅框架梦]
 * 
 * 知启蒙数据库映射（zhiqim_orm）在LGPL3.0协议下开源：https://www.zhiqim.com/gitcan/zhiqim/zhiqim_orm.htm
 *
 * This file is part of [zhiqim_orm].
 * 
 * [zhiqim_orm] is free software: you can redistribute
 * it and/or modify it under the terms of the GNU Lesser General Public License
 * as published by the Free Software Foundation, either version 3 of the
 * License, or (at your option) any later version.
 * 
 * [zhiqim_orm] is distributed in the hope that it will
 * be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Lesser General Public License for more details.
 * 
 * You should have received a copy of the GNU Lesser General Public License
 * along with [zhiqim_orm].
 * If not, see <http://www.gnu.org/licenses/>.
 */
]]>
</config>

<package name="org.zhiqim.orm.test.dbo" type="true" desc="系统配置表">

    <table name="T_INTEGER" desc="整型测试表" key="T_ID" type="InnoDB">
        <field column="T_ID" type="long" length="" notNull="true" desc="测试编号"/>
        <field column="T_BOOLEAN" type="boolean" length="" notNull="true" desc="布尔型"/>
        <field column="T_BYTE" type="byte" length="" notNull="true" desc="字节型"/>
        <field column="T_SHORT" type="short" length="" notNull="true" desc="短整型"/>
        <field column="T_INT" type="int" length="" notNull="true" desc="整型"/>
        <field column="T_LONG" type="long" length="" notNull="true" desc="长整型"/>
        <data PARAM_UPDATE="0" PARAM_DESC="是否使用管理页登录退出功能" GROUP_ID="zhiqim.manager" PARAM_POS="1" PARAM_VALUE="false" PARAM_KEY="hasManageLogin"/>
        <data PARAM_UPDATE="1" PARAM_DESC="是否使用操作员组功能" GROUP_ID="zhiqim.manager" PARAM_POS="2" PARAM_VALUE="false" PARAM_KEY="hasOperatorGroup"/>
    </table>

    <table name="T_STRING" desc="测试字符串" key="T_ID" type="InnoDB">
        <field column="T_ID" type="long" length="" notNull="true" desc="测试编号"/>
        <field column="T_CHAR" type="string" length="19,char" notNull="false" desc="定长字符串"/>
        <field column="T_VARCHAR" type="string" length="32" notNull="false" desc="变长字符串"/>
        <field column="T_STRING2000" type="string" length="2000" notNull="false" desc="变成2000长度"/>
        <field column="T_STRING4000" type="string" length="4000" notNull="false" desc="变长4000长度"/>
        <field column="T_STRING8000" type="string" length="8000" notNull="false" desc="变长8000长度"/>
        <field column="T_STRING16000" type="string" length="16000" notNull="false" desc="变长16000长度"/>
    </table>

    <table name="T_DATETIME" desc="测试日期格式" key="T_ID" type="InnoDB">
        <field column="T_ID" type="long" length="" notNull="true" desc="测试编号"/>
        <field column="T_DATETIME" type="datetime" length="" notNull="true" desc="测试日期"/>
        <field column="T_DATETIME2" type="datetime" length="" notNull="true" desc="测试日期"/>
    </table>

    <table name="T_DECIMAL" desc="测试小数格式" key="T_ID" type="InnoDB">
        <field column="T_ID" type="long" length="" notNull="true" desc="测试编号"/>
        <field column="T_DM5_2" type="decimal" length="5,2" notNull="true" desc="测试5位长度，小数2位"/>
        <field column="T_DM10_3" type="decimal" length="10,3" notNull="true" desc="测试10位长度，小数3位"/>
        <field column="T_DM15_4" type="decimal" length="15,4" notNull="true" desc="测试15位长度，小数4位"/>
    </table>

    <table name="T_AUTO" desc="测试自增长字段" key="T_ID" type="InnoDB">
        <field column="T_ID" type="long" length="" notNull="true" desc="测试编号"/>
        <field column="T_VARCHAR" type="string" length="32" notNull="false" desc="变长字符串"/>
    </table>

    <table name="MESSAGE" desc="留言表" key="MESSAGE_ID" type="InnoDB">
        <field column="MESSAGE_ID" type="long" length="" notNull="true" desc="留言编号"/>
        <field column="MESSAGE_NAME" type="string" length="32" notNull="true" desc="访客称呼"/>
        <field column="MESSAGE_CONTACTING" type="string" length="50" notNull="false" desc="访客联系方式"/>
        <field column="MESSAGE_CONTENT" type="string" length="1000" notNull="true" desc="访客留言内容"/>
        <field column="MESSAGE_TIME" type="string" length="19,char" notNull="true" desc="访客留言时间"/>
        <field column="MESSAGE_RTIME" type="string" length="19,char" notNull="false" desc="管理员回复时间"/>
        <field column="MESSAGE_REPLY" type="string" length="1000" notNull="false" desc="管理员回复内容"/>
    </table>

    <table name="ADMIN" desc="管理员表" key="ADMIN_NAME" type="InnoDB">
        <field column="ADMIN_NAME" type="string" length="32" notNull="true" desc="管理员名称"/>
        <field column="ADMIN_PASS" type="string" length="32" notNull="true" desc="管理员密码"/>
        <field column="ADMIN_TIME" type="string" length="19,char" notNull="true" desc="管理员时间"/>
        <data ADMIN_NAME="admin" ADMIN_PASS="111111"/>
    </table>

    <table name="ORDER" desc="订单表" key="ORDER_ID" type="InnoDB">
        <field column="ORDER_ID" type="long" length="" notNull="true" desc="订单编号"/>
    </table>

</package>
<package name="org.zhiqim.orm.test.dboext" type="true" desc="系统配置表">

    <view name="T_INTEGER_STRING" type="true" desc="整型和字符串视图" table="T_INTEGER,T_STRING">
        <join type="EQUAL" lTable="T_INTEGER" lColumn="T_ID" rTable="T_STRING" rColumn="T_ID"/>

        <field column="*" table="T_INTEGER"/>
        <field column="T_CHAR" table="T_STRING"/>
        <field column="T_VARCHAR" table="T_STRING"/>
    </view>

    <view name="T_INTEGER_DATETIME" type="true" desc="整型和时间视图" table="T_INTEGER,T_DATETIME">
        <join type="EQUAL" lTable="T_INTEGER" lColumn="T_ID" rTable="T_DATETIME" rColumn="T_ID"/>

        <field column="*" table="T_INTEGER"/>
        <field column="T_DATETIME" table="T_DATETIME"/>
    </view>

    <view name="T_INTEGER_DECIMAL" type="true" desc="整型和小数视图" table="T_INTEGER,T_DECIMAL">
        <join type="EQUAL" lTable="T_INTEGER" lColumn="T_ID" rTable="T_DECIMAL" rColumn="T_ID"/>

        <field column="T_ID" table="T_INTEGER"/>
        <field column="T_BOOLEAN" table="T_INTEGER"/>
        <field column="T_DM5_2" table="T_DECIMAL"/>
        <field column="T_DM10_3" table="T_DECIMAL"/>
    </view>

    <view name="T_INTEGER_STRING_LEFT" type="true" desc="整型和字符串左联视图" table="T_INTEGER,T_STRING">
        <join type="LEFT" lTable="T_INTEGER" lColumn="T_ID" rTable="T_STRING" rColumn="T_ID"/>

        <field column="*" table="T_INTEGER"/>
        <field column="T_CHAR" table="T_STRING"/>
        <field column="T_VARCHAR" table="T_STRING"/>
    </view>

</package>

</zhiqim-dbo>