<?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="prj_file_info"> <ns1:fields> <ns1:field name="prj_file_info_id" databaseType="BIGINT" datatype="java.lang.Long"/> <ns1:field name="condition_req" databaseType="VARCHAR" datatype="java.lang.String"/> <ns1:field name="project_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="req_description" databaseType="VARCHAR" datatype="java.lang.String"/> <ns1:field name="raise_status" databaseType="VARCHAR" datatype="java.lang.String"/> <!-- <ns1:field name="raise_status_desc" expression="(select v.code_value_name from sys_code_values_v v where v.code = 'RAISE_STATUS' and v.code_value = t1.raise_status)" forInsert="false" forUpdate="false" /> --> <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="prj_file_info_id"/> </ns1:primary-key> <ns1:query-fields> <ns1:query-field name="project_id" queryExpression="t1.project_id = ${/parameter/@project_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>