<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: chenlingfeng  
    $Date: 2018-2-27 下午5:01:56  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:o="leaf.database.local.oracle" xmlns:f="leaf.database.features" xmlns:bm="http://www.leaf-framework.org/schema/bm" alias="t1" baseTable="DS_SYS_SMS_LIST">

    <bm:fields>
         <bm:field name="list_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LIST_ID" prompt="DS_SYS_SMS_LIST.LIST_ID"/>
            <bm:field name="batch_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BATCH_ID" prompt="DS_SYS_SMS_LIST.BATCH_ID"/>
            <bm:field name="document_category" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DOCUMENT_CATEGORY" prompt="DS_SYS_SMS_LIST.DOCUMENT_CATEGORY"/>
            <bm:field name="document_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="DOCUMENT_ID" prompt="DS_SYS_SMS_LIST.DOCUMENT_ID"/>
            <bm:field name="document_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DOCUMENT_NUMBER" prompt="DS_SYS_SMS_LIST.DOCUMENT_NUMBER"/>
            <bm:field name="name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NAME" prompt="DS_SYS_SMS_LIST.NAME"/>
            <bm:field name="phone" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PHONE" prompt="DS_SYS_SMS_LIST.PHONE"/>
            <bm:field name="content" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTENT" prompt="DS_SYS_SMS_LIST.CONTENT"/>
            <bm:field name="send_date" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SEND_DATE" prompt="DS_SYS_SMS_LIST.SEND_DATE"/>
            <bm:field name="send_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SEND_STATUS" prompt="DS_SYS_SMS_LIST.SEND_STATUS"/>
            <bm:field name="send_status_desc" expression="(SELECT v.code_value_name  FROM    sys_code_values_v v                    WHERE                        v.code       = 'SYS402_SMS_STATUS' AND                        v.code_value = t1.send_status                    )" forInsert="false" forceUpdate="false"  />
    </bm:fields>
    <bm:features>
        <f:standard-who/>
        <o:sequence-pk/>
    </bm:features>
    <bm:primary-key>
        <bm:pk-field name="list_id"/>
    </bm:primary-key>
    <bm:query-fields>
        <bm:query-field field="list_id" queryOperator="="/>
        <bm:query-field field="batch_id" queryOperator="="/>
    </bm:query-fields>
</bm:model>
