<?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.zksy.system.basicData.mapper.CrmSystemCertificationInfoMapper">
    
    <resultMap type="CrmSystemCertificationInfo" id="CrmSystemCertificationInfoResult">
        <result property="id"    column="id"    />
        <result property="certificateNo"    column="certificate_no"    />
        <result property="certificateStatus"    column="certificate_status"    />
        <result property="organizationName"    column="organization_name"    />
        <result property="unifiedSocialCreditCode"    column="unified_social_credit_code"    />
        <result property="certificationType"    column="certification_type"    />
        <result property="issueDate"    column="issue_date"    />
        <result property="expiryDate"    column="expiry_date"    />
        <result property="initialCertificationDate"    column="initial_certification_date"    />
        <result property="reportingDate"    column="reporting_date"    />
        <result property="certificationProject"    column="certification_project"    />
        <result property="certificationBasis"    column="certification_basis"    />
        <result property="supervisionTimes"    column="supervision_times"    />
        <result property="recertificationTimes"    column="recertification_times"    />
        <result property="businessScopeCovered"    column="business_scope_covered"    />
        <result property="multiSiteCovered"    column="multi_site_covered"    />
        <result property="siteNamesAndAddresses"    column="site_names_and_addresses"    />
        <result property="accreditationMarksUsed"    column="accreditation_marks_used"    />
        <result property="countryRegion"    column="country_region"    />
        <result property="certifiedPersonnelCount"    column="certified_personnel_count"    />
        <result property="organizationAddress"    column="organization_address"    />
        <result property="issuingAgencyName"    column="issuing_agency_name"    />
        <result property="agencyApprovalNo"    column="agency_approval_no"    />
        <result property="agencyValidPeriod"    column="agency_valid_period"    />
        <result property="agencyStatus"    column="agency_status"    />
        <result property="agencyWebsite"    column="agency_website"    />
        <result property="agencyAddress"    column="agency_address"    />
        <result property="agencyBusinessScope"    column="agency_business_scope"    />
    </resultMap>
</mapper>