<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: ZLF  
    $Date: 2015-2-11 下午8:30:52  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:o="leaf.database.local.oracle" xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="t1" baseTable="PRJ_PAY_CONDITION">
    <bm:fields>
        <bm:field name="pay_condition_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PAY_CONDITION_ID" prompt="PRJ_PAY_CONDITION.PAY_CONDITION_ID"/>
        <bm:field name="project_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PROJECT_ID" prompt="PRJ_PAY_CONDITION.PROJECT_ID"/>
        <bm:field name="condition_seq" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONDITION_SEQ" prompt="PRJ_PAY_CONDITION.CONDITION_SEQ"/>
        <bm:field name="condition_des" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONDITION_DES" prompt="PRJ_PAY_CONDITION.CONDITION_DES"/>
        <bm:field name="required_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REQUIRED_FLAG" prompt="PRJ_PAY_CONDITION.REQUIRED_FLAG"/>
        <bm:field name="status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STATUS" prompt="PRJ_PAY_CONDITION.STATUS"/>
        <bm:field name="status_des" expression="decode(t1.status,&apos;SUBMITED&apos;,&apos;已提交&apos;,&apos;未提交&apos;)" forInsert="false" forUpdate="false"/>
        <bm:field name="confirm_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONFIRM_FLAG" prompt="PRJ_PAY_CONDITION.CONFIRM_STATUS"/>
        <bm:field name="confirm_desc" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONFIRM_DESC" prompt="PRJ_PAY_CONDITION.CONFIRM_DESC"/>
    </bm:fields>
    <bm:features>
        <f:standard-who/>
        <o:sequence-pk/>
    </bm:features>
    <bm:primary-key>
        <bm:pk-field name="pay_condition_id"/>
    </bm:primary-key>
    <bm:query-fields>
        <bm:query-field name="project_id" queryExpression="t1.project_id = ${@project_id}"/>
    </bm:query-fields>
</bm:model>