<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.yd.csf.service.dao.PolicyPolicyholderMapper">

    <resultMap id="BaseResultMap" type="com.yd.csf.service.model.PolicyPolicyholder">
            <id property="id" column="id" />
            <result property="policyPolicyholderBizId" column="policy_policyholder_biz_id" />
            <result property="policyBizId" column="policy_biz_id" />
            <result property="policyNo" column="policy_no" />
            <result property="customerType" column="customer_type" />
            <result property="customerBizId" column="customer_biz_id" />
            <result property="customerNo" column="customer_no" />
            <result property="name" column="name" />
            <result property="nameEn" column="name_en" />
            <result property="gender" column="gender" />
            <result property="documentType" column="document_type" />
            <result property="idNumber" column="id_number" />
            <result property="birthday" column="birthday" />
            <result property="age" column="age" />
            <result property="residentialAddress" column="residential_address" />
            <result property="mailingAddress" column="mailing_address" />
            <result property="mobileCode" column="mobile_code" />
            <result property="mobile" column="mobile" />
            <result property="email" column="email" />
            <result property="companyName" column="company_name" />
            <result property="companyAddress" column="company_address" />
            <result property="industry" column="industry" />
            <result property="position" column="position" />
            <result property="riskAppetite" column="risk_appetite" />
            <result property="isVip" column="is_vip" />
            <result property="vipRemark" column="vip_remark" />
            <result property="appellation" column="appellation" />
            <result property="smokingAllowed" column="smoking_allowed" />
            <result property="birthplace" column="birthplace" />
            <result property="nationality" column="nationality" />
            <result property="passportNo" column="passport_no" />
            <result property="passNo" column="pass_no" />
            <result property="height" column="height" />
            <result property="weight" column="weight" />
            <result property="bmi" column="bmi" />
            <result property="monthExpenditure" column="month_expenditure" />
            <result property="monthIncome" column="month_income" />
            <result property="currentTenure" column="current_tenure" />
            <result property="totalCurrentAssets" column="total_current_assets" />
            <result property="totalDebt" column="total_debt" />
            <result property="dependentsNum" column="dependents_num" />
            <result property="maritalStatus" column="marital_status" />
            <result property="educationLevel" column="education_level" />
            <result property="totalWorkingYears" column="total_working_years" />
            <result property="currentMonthlyIncome" column="current_monthly_income" />
            <result property="companyMobileCode" column="company_mobile_code" />
            <result property="companyMobile" column="company_mobile" />
            <result property="landlineCode" column="landline_code" />
            <result property="landline" column="landline" />
            <result property="otherMobile" column="other_mobile" />
            <result property="isExceed" column="is_exceed" />
            <result property="isOtherCountry" column="is_other_country" />
            <result property="isPromotion" column="is_promotion" />
            <result property="postalCode" column="postal_code" />
            <result property="travel" column="travel" />
            <result property="exercise" column="exercise" />
            <result property="game" column="game" />
            <result property="movieDrama" column="movie_drama" />
            <result property="delicacy" column="delicacy" />
            <result property="addressList" column="address_list" />
            <result property="smokingVolume" column="smoking_volume" />
            <result property="currency" column="currency" />
            <result property="companyNameEn" column="company_name_en" />
            <result property="companyBusinessNo" column="company_business_no" />
            <result property="companyRegisterTime" column="company_register_time" />
            <result property="companyRegisterRegion" column="company_register_region" />
            <result property="companyEmail" column="company_email" />
            <result property="companyEnterAddress" column="company_enter_address" />
            <result property="authNameCn" column="auth_name_cn" />
            <result property="authNameEn" column="auth_name_en" />
            <result property="authProfessional" column="auth_professional" />
            <result property="authMobileCode" column="auth_mobile_code" />
            <result property="authMobile" column="auth_mobile" />
            <result property="remark" column="remark" />
            <result property="isDeleted" column="is_deleted" />
            <result property="creatorId" column="creator_id" />
            <result property="updaterId" column="updater_id" />
            <result property="createTime" column="create_time" />
            <result property="updateTime" column="update_time" />
    </resultMap>

    <sql id="Base_Column_List">
        id,policy_policyholder_biz_id,policy_biz_id,policy_no,customer_type,customer_biz_id,
        customer_no,name,name_en,gender,document_type,
        id_number,birthday,age,residential_address,mailing_address,
        mobile_code,mobile,email,company_name,company_address,
        industry,position,risk_appetite,is_vip,vip_remark,
        appellation,smoking_allowed,birthplace,nationality,passport_no,
        pass_no,height,weight,bmi,month_expenditure,
        month_income,current_tenure,total_current_assets,total_debt,dependents_num,
        marital_status,education_level,total_working_years,current_monthly_income,company_mobile_code,
        company_mobile,landline_code,landline,other_mobile,is_exceed,
        is_other_country,is_promotion,postal_code,travel,exercise,
        game,movie_drama,delicacy,address_list,smoking_volume,
        currency,company_name_en,company_business_no,company_register_time,company_register_region,
        company_email,company_enter_address,auth_name_cn,auth_name_en,auth_professional,
        auth_mobile_code,auth_mobile,remark,is_deleted,creator_id,
        updater_id,create_time,update_time
    </sql>
</mapper>
