<?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.rj.mapper.CommunicationRecordMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.rj.entity.CommunicationRecord">
        <id column="id" property="id" />
        <result column="customer_name" property="customerName" />
        <result column="customer_phone" property="customerPhone" />
        <result column="customer_id" property="customerId" />
        <result column="communication_type" property="communicationType" />
        <result column="communication_time" property="communicationTime" />
        <result column="communication_content" property="communicationContent" />
        <result column="communication_result" property="communicationResult" />
        <result column="owner_name" property="ownerName" />
        <result column="owner_phone" property="ownerPhone" />
        <result column="todo_suggestion" property="todoSuggestion" />
        <result column="create_time" property="createTime" />
        <result column="update_time" property="updateTime" />
        <result column="status" property="status" />
    </resultMap>

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        id, customer_name, customer_phone, customer_id, communication_type, 
        communication_time, communication_content, communication_result, 
        owner_name, owner_phone, todo_suggestion, create_time, update_time, status
    </sql>

</mapper>
