<?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>