<?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="org.qinan.safetyeval.infrastructure.persistence.mapper.QualFilingPersonnelCertChangeMapper">

    <resultMap type="org.qinan.safetyeval.infrastructure.persistence.domainobject.QualFilingPersonnelCertChangeDO"
               id="QualFilingPersonnelCertChangeResult">
        <id property="id" column="id"/>
        <result property="filingChangeId" column="filing_change_id"/>
        <result property="filingPersonnelId" column="filing_personnel_id"/>
        <result property="certName" column="cert_name"/>
        <result property="certTypeCode" column="cert_type_code"/>
        <result property="certTypeName" column="cert_type_name"/>
        <result property="certCategoryCode" column="cert_category_code"/>
        <result property="certCategoryName" column="cert_category_name"/>
        <result property="operationCategoryCode" column="operation_category_code"/>
        <result property="operationCategoryName" column="operation_category_name"/>
        <result property="certNo" column="cert_no"/>
        <result property="issueOrg" column="issue_org"/>
        <result property="validStartDate" column="valid_start_date"/>
        <result property="validEndDate" column="valid_end_date"/>
        <result property="reviewDate" column="review_date"/>
        <result property="certAttachmentUrl" column="cert_attachment_url"/>
        <result property="sourceCertId" column="source_cert_id"/>
        <result property="deleteEnum" column="delete_enum"/>
        <result property="remarks" column="remarks"/>
        <result property="createName" column="create_name"/>
        <result property="updateName" column="update_name"/>
        <result property="tenantId" column="tenant_id"/>
        <result property="orgId" column="org_id"/>
        <result property="version" column="version"/>
        <result property="createTime" column="create_time"/>
        <result property="updateTime" column="update_time"/>
        <result property="createId" column="create_id"/>
        <result property="updateId" column="update_id"/>
        <result property="env" column="env"/>
    </resultMap>

    <sql id="selectQualFilingPersonnelCertChange">
        select id,
               filing_change_id,
               filing_personnel_id,
               cert_name,
               cert_type_code,
               cert_type_name,
               cert_category_code,
               cert_category_name,
               operation_category_code,
               operation_category_name,
               cert_no,
               issue_org,
               valid_start_date,
               valid_end_date,
               review_date,
               cert_attachment_url,
               source_cert_id,
               delete_enum,
               remarks,
               create_name,
               update_name,
               tenant_id,
               org_id,
               version,
               create_time,
               update_time,
               create_id,
               update_id,
               env
        from qual_filing_personnel_cert_change
    </sql>

</mapper>