<?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.FnaFormMapper">

    <resultMap id="BaseResultMap" type="com.yd.csf.service.model.FnaForm">
            <id property="id" column="id" />
            <result property="fnaFormBizId" column="fna_form_biz_id" />
            <result property="userBizId" column="user_biz_id" />
            <result property="agentBizId" column="agent_biz_id" />
            <result property="customerBizId" column="customer_biz_id" />
            <result property="brokerList" column="broker_list" />
            <result property="dependantList" column="dependant_list" />
            <result property="personalData" column="personal_data" />
             <result property="taxList" column="tax_list" />
            <result property="familyMembers" column="family_members" />
            <result property="existingSecurityOwner" column="existing_security_owner" />
            <result property="existingSecurityInsured" column="existing_security_insured" />
            <result property="incomeExpense" column="income_expense" />
            <result property="liquidAssets" column="liquid_assets" />
            <result property="primaryResidence" column="primary_residence" />
            <result property="investment" column="investment" />
            <result property="premiumAffordability" column="premium_affordability" />
            <result property="companyBusinessData" column="company_business_data" />
            <result property="other" column="other" />
            <result property="fnaFormStatus" column="fna_form_status" />
            <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,fna_form_biz_id,user_biz_id,agent_biz_id,customer_biz_id,broker_list,dependant_list,personal_data,tax_list,
        family_members,existing_security_owner,existing_security_insured,income_expense,liquid_assets,
        primary_residence,investment,premium_affordability,company_business_data,other,fna_form_status,
        remark,is_deleted,creator_id,updater_id,create_time,
        update_time
    </sql>
</mapper>
