<?xml version="1.0" encoding="UTF-8"?>
<ns1:model xmlns:ns2="leaf.database.local.oracle" xmlns:e="leaf.service.exception" xmlns:f="leaf.database.features" xmlns:ns1="http://www.leaf-framework.org/schema/bm" alias="t1" baseTable="con_file_info">
    <ns1:fields>
        <ns1:field name="file_info_id" databaseType="BIGINT" datatype="java.lang.Long"/>
        <ns1:field name="condition_req" databaseType="VARCHAR" datatype="java.lang.String"/>
        <ns1:field name="contract_id" databaseType="BIGINT" datatype="java.lang.Long"/>
        <ns1:field name="department_id" databaseType="BIGINT" datatype="java.lang.Long"/>
        <ns1:field name="department_desc" expression="(select vl.description from exp_org_unit_vl vl where vl.unit_id = t1.department_id)" forInsert="false" forUpdate="false"/>
        <ns1:field name="req_status" databaseType="VARCHAR" datatype="java.lang.String"/>
        <ns1:field name="raise_status" databaseType="VARCHAR" datatype="java.lang.String"/>
        <ns1:field name="req_description" databaseType="VARCHAR" datatype="java.lang.String"/>
        <ns1:field name="expiration_date" databaseType="DATE" datatype="java.sql.Date"/>
        <ns1:field name="req_date" databaseType="DATE" datatype="java.sql.Date"/>
        <ns1:field name="req_flag" databaseType="VARCHAR" datatype="java.lang.String"/>
    </ns1:fields>
    <ns1:primary-key>
        <ns1:pk-field name="file_info_id"/>
    </ns1:primary-key>
    <ns1:query-fields>
        <ns1:query-field name="contract_id" queryExpression="t1.contract_id = ${/parameter/@contract_id}"/>
    </ns1:query-fields>
    <ns1:data-filters><![CDATA[
    
    ]]></ns1:data-filters>
    <ns1:features>
        <ns2:sequence-pk/>
        <f:standard-who/>
        <f:multi-language-storage/>
    </ns1:features>
    <ns1:ref-fields/>
</ns1:model>
