<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
                SELECT
                    t.prj_bp_id,
                    t.project_id,
                    t.id_card_no,
                    t.bp_name,
                    t.cell_phone,
                    t.academic_background,
                    t.academic_background_n,
                    t.marital_status,
                    t.marital_status_n,
                    t.annual_income,
                    t.source_of_income,
                    t.source_of_income_n,
                    t.first_time_buyer_flag,
                    t.first_time_buyer_flag_n,
                    t.main_driver_of_car,
                    t.main_driver_of_car_n,
                    t.living_address,
                    t.living_situation,
                    t.living_situation_n,
                    t.years_of_living_house,
                    t.ownship_of_house,
                    t.ownship_of_house_n,
                    t.house_loans_flag,
                    t.house_loans_flag_n,
                    t.address_on_resident_booklit,
                    t.industry,
                    t.industry_n,
                    t.work_unit,
                    t.work_unit_address,
                    t.work_unit_phone,
                    t.industry_work_experience,
                    t.position,
                    t.position_n,
                    t.release_form,
                    t.release_form_n,
                    t.id_no_sp,
                    t.bp_name_sp,
                    t.cell_phone_sp,
                    t.academic_background_sp,
                    t.academic_background_sp_n,
                    t.source_of_income_db,
                    t.source_of_income_db_n,
                    t.relationship_sp,
                    t.relationship_sp_n,
                    t.description_others,
                    t.description_others_n,
                    t.living_address_db,
                    t.resident_addres,
                    t.industry_sp,
                    t.industry_sp_n,
                    t.work_unit_name_sp,
                    t.work_unit_address_sp,
                    t.industry_work_exper,
                    t.position_sp,
                    t.position_sp_n,
                    t.gender,
                    t.gender_n,
                    t.date_of_birth,
                    t.age,
                    t.gender_sp,
                    t.gender_sp_n,
                    t.date_of_birth_sp,
                    t.old_sp,
                    t.add_province,
                    t.add_province_n,
                    t.add_city,
                    t.add_city_n,
                    t.liv_province,
                    t.liv_province_n,
                    t.liv_city,
                    t.liv_city_n,
                    t.work_province,
                    t.work_province_n,
                    t.work_city,
                    t.work_city_n,
                    t.resident_add_province,
                    t.resident_add_province_n,
                    t.living_add_province,
                    t.living_add_province_n,
                    t.living_add_city,
                    t.living_add_city_n,
                    t.work_province_sp,
                    t.work_province_sp_n,
                    t.work_city_sp,
                    t.work_city_sp_n
                FROM
                    prj_project_bp_tenant_lv t
                WHERE
                    t.project_id=${@project_id}
            ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:fields>
        <bm:field name="prj_bp_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PRJ_BP_ID" required="true"/>
        <bm:field name="project_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PROJECT_ID" required="true"/>
        <bm:field name="id_card_no" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ID_CARD_NO"/>
        <bm:field name="bp_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_NAME"/>
        <bm:field name="cell_phone" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CELL_PHONE"/>
        <bm:field name="academic_background" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACADEMIC_BACKGROUND"/>
        <bm:field name="academic_background_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACADEMIC_BACKGROUND_N"/>
        <bm:field name="marital_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MARITAL_STATUS"/>
        <bm:field name="marital_status_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MARITAL_STATUS_N"/>
        <bm:field name="annual_income" databaseType="NUMBER" datatype="java.lang.Long" physicalName="ANNUAL_INCOME"/>
        <bm:field name="source_of_income" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SOURCE_OF_INCOME"/>
        <bm:field name="source_of_income_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SOURCE_OF_INCOME_N"/>
        <bm:field name="first_time_buyer_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FIRST_TIME_BUYER_FLAG"/>
        <bm:field name="first_time_buyer_flag_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FIRST_TIME_BUYER_FLAG_N"/>
        <bm:field name="main_driver_of_car" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MAIN_DRIVER_OF_CAR"/>
        <bm:field name="main_driver_of_car_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MAIN_DRIVER_OF_CAR_N"/>
        <bm:field name="living_address" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LIVING_ADDRESS"/>
        <bm:field name="living_situation" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LIVING_SITUATION"/>
        <bm:field name="living_situation_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LIVING_SITUATION_N"/>
        <bm:field name="years_of_living_house" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="YEARS_OF_LIVING_HOUSE"/>
        <bm:field name="ownship_of_house" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OWNSHIP_OF_HOUSE"/>
        <bm:field name="ownship_of_house_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OWNSHIP_OF_HOUSE_N"/>
        <bm:field name="house_loans_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HOUSE_LOANS_FLAG"/>
        <bm:field name="house_loans_flag_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HOUSE_LOANS_FLAG_N"/>
        <bm:field name="address_on_resident_booklit" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ADDRESS_ON_RESIDENT_BOOKLIT"/>
        <bm:field name="industry" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INDUSTRY"/>
        <bm:field name="industry_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INDUSTRY_N"/>
        <bm:field name="work_unit" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_UNIT"/>
        <bm:field name="work_unit_address" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_UNIT_ADDRESS"/>
        <bm:field name="work_unit_phone" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_UNIT_PHONE"/>
        <bm:field name="industry_work_experience" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INDUSTRY_WORK_EXPERIENCE"/>
        <bm:field name="position" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="POSITION"/>
        <bm:field name="position_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="POSITION_N"/>
        <bm:field name="release_form" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RELEASE_FORM"/>
        <bm:field name="release_form_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RELEASE_FORM_N"/>
        <bm:field name="id_no_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ID_NO_SP"/>
        <bm:field name="bp_name_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_NAME_SP"/>
        <bm:field name="cell_phone_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CELL_PHONE_SP"/>
        <bm:field name="academic_background_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACADEMIC_BACKGROUND_SP"/>
        <bm:field name="academic_background_sp_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACADEMIC_BACKGROUND_SP_N"/>
        <bm:field name="source_of_income_db" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SOURCE_OF_INCOME_DB"/>
        <bm:field name="source_of_income_db_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SOURCE_OF_INCOME_DB_N"/>
        <bm:field name="relationship_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RELATIONSHIP_SP"/>
        <bm:field name="relationship_sp_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RELATIONSHIP_SP_N"/>
        <bm:field name="description_others" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DESCRIPTION_OTHERS"/>
        <bm:field name="description_others_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DESCRIPTION_OTHERS_N"/>
        <bm:field name="living_address_db" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LIVING_ADDRESS_DB"/>
        <bm:field name="resident_addres" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RESIDENT_ADDRES"/>
        <bm:field name="industry_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INDUSTRY_SP"/>
        <bm:field name="industry_sp_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INDUSTRY_SP_N"/>
        <bm:field name="work_unit_name_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_UNIT_NAME_SP"/>
        <bm:field name="work_unit_address_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_UNIT_ADDRESS_SP"/>
        <bm:field name="industry_work_exper" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INDUSTRY_WORK_EXPER"/>
        <bm:field name="position_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="POSITION_SP"/>
        <bm:field name="position_sp_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="POSITION_SP_N"/>
        <bm:field name="gender" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GENDER"/>
        <bm:field name="gender_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GENDER_N"/>
        <bm:field name="date_of_birth" databaseType="DATE" datatype="java.util.Date" physicalName="DATE_OF_BIRTH"/>
        <bm:field name="age" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="AGE"/>
        <bm:field name="gender_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GENDER_SP"/>
        <bm:field name="gender_sp_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GENDER_SP_N"/>
        <bm:field name="date_of_birth_sp" databaseType="DATE" datatype="java.util.Date" physicalName="DATE_OF_BIRTH_SP"/>
        <bm:field name="old_sp" databaseType="NUMBER" datatype="java.lang.Long" physicalName="OLD_SP"/>
        <bm:field name="add_province" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ADD_PROVINCE"/>
        <bm:field name="add_province_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ADD_PROVINCE_N"/>
        <bm:field name="add_city" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ADD_CITY"/>
        <bm:field name="add_city_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ADD_CITY_N"/>
        <bm:field name="liv_province" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LIV_PROVINCE"/>
        <bm:field name="liv_province_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LIV_PROVINCE_N"/>
        <bm:field name="liv_city" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LIV_CITY"/>
        <bm:field name="liv_city_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LIV_CITY_N"/>
        <bm:field name="work_province" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_PROVINCE"/>
        <bm:field name="work_province_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_PROVINCE_N"/>
        <bm:field name="work_city" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_CITY"/>
        <bm:field name="work_city_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_CITY_N"/>
        <bm:field name="resident_add_province" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RESIDENT_ADD_PROVINCE"/>
        <bm:field name="resident_add_province_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RESIDENT_ADD_PROVINCE_N"/>
        <bm:field name="living_add_province" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LIVING_ADD_PROVINCE"/>
        <bm:field name="living_add_province_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LIVING_ADD_PROVINCE_N"/>
        <bm:field name="living_add_city" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LIVING_ADD_CITY"/>
        <bm:field name="living_add_city_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LIVING_ADD_CITY_N"/>
        <bm:field name="work_province_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_PROVINCE_SP"/>
        <bm:field name="work_province_sp_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_PROVINCE_SP_N"/>
        <bm:field name="work_city_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_CITY_SP"/>
        <bm:field name="work_city_sp_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_CITY_SP_N"/>
    </bm:fields>
</bm:model>
