<?xml version="1.0" encoding="UTF-8"?>
<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="HLS_PRODUCT_PLAN_TO_GRANT" needAccessControl="false">
    <bm:fields>
        <bm:field name="product_grant_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PRODUCT_GRANT_ID" prompt="HLS_PRODUCT_PLAN_TO_GRANT.PRODUCT_GRANT_ID"/>
        <bm:field name="product_plan_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PRODUCT_PLAN_ID" prompt="HLS_PRODUCT_PLAN_TO_GRANT.PRODUCT_PLAN_ID"/>
        <bm:field name="car_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CAR_TYPE" prompt="HLS_PRODUCT_PLAN_TO_GRANT.CAR_TYPE"/>
        <bm:field name="lease_method" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEASE_METHOD" prompt="HLS_PRODUCT_PLAN_TO_GRANT.LEASE_METHOD"/>
        <bm:field name="customer_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CUSTOMER_TYPE" prompt="HLS_PRODUCT_PLAN_TO_GRANT.CUSTOMER_TYPE"/>
        <bm:field name="grant_brand" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GRANT_BRAND" prompt="HLS_PRODUCT_PLAN_TO_GRANT.GRANT_BRAND"/>
        <!-- <bm:field name="grant_province" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GRANT_PROVINCE" prompt="HLS_PRODUCT_PLAN_TO_GRANT.GRANT_PROVINCE"/> -->
        <!-- <bm:field name="grant_city" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GRANT_CITY" prompt="HLS_PRODUCT_PLAN_TO_GRANT.GRANT_CITY"/> -->
        <bm:field name="grant_company" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GRANT_COMPANY" prompt="HLS_PRODUCT_PLAN_TO_GRANT.GRANT_COMPANY"/>
        <bm:field name="province_id" prompt="HLS_PRODUCT_PLAN_TO_GRANT.PROVINCE_ID"/>
        <bm:field name="province_name" prompt="HLS_PRODUCT_PLAN_TO_GRANT.PROVINCE_ID"/>
        <bm:field name="city_id" prompt="HLS_PRODUCT_PLAN_TO_GRANT.CITY_ID"/>
        <bm:field name="city_name" prompt="HLS_PRODUCT_PLAN_TO_GRANT.CITY_ID"/>
        <bm:field name="brand_id" prompt="HLS_PRODUCT_PLAN_TO_GRANT.BRAND_ID"/>
        <bm:field name="bp_id" prompt="HLS_PRODUCT_PLAN_TO_GRANT.BP_ID"/>
        <bm:field name="start_date" databaseType="DATE" datatype="java.util.Date" physicalName="START_DATE" prompt="HLS_PRODUCT_PLAN_TO_GRANT.START_DATE"/>
        <bm:field name="end_date" databaseType="DATE" datatype="java.util.Date" physicalName="END_DATE" prompt="HLS_PRODUCT_PLAN_TO_GRANT.END_DATE"/>
        <bm:field name="apply_channel" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="APPLY_CHANNEL" prompt="HLS_PRODUCT_PLAN_TO_GRANT.APPLY_CHANNEL"/>
        <bm:field name="area" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="AREA" prompt="HLS_PRODUCT_PLAN_TO_GRANT.AREA"/>
    </bm:fields>
    <bm:features>
        <f:standard-who/>
        <o:sequence-pk/>
    </bm:features>
    <bm:primary-key>
        <bm:pk-field name="product_grant_id"/>
    </bm:primary-key>
    <bm:data-filters>
        <bm:data-filter name="product_plan_id" enforceOperations="query" expression="t1.product_plan_id = ${@product_plan_id}"/>
    </bm:data-filters>
</bm:model>
