<?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.data.mapper.XcrFoodProductionLicenseMapper">

    <resultMap id="BaseResultMap" type="com.zksy.data.domain.po.XcrFoodProductionLicense">
            <id property="id" column="ID" jdbcType="VARCHAR"/>
            <result property="infosharId" column="INFOSHAR_ID" jdbcType="VARCHAR"/>
            <result property="producerName" column="PRODUCER_NAME" jdbcType="VARCHAR"/>
            <result property="legalPerson" column="LEGAL_PERSON" jdbcType="VARCHAR"/>
            <result property="permitNo" column="PERMIT_NO" jdbcType="VARCHAR"/>
            <result property="socialCreditCode" column="SOCIAL_CREDIT_CODE" jdbcType="VARCHAR"/>
            <result property="divisonCode" column="DIVISON_CODE" jdbcType="VARCHAR"/>
            <result property="domicile" column="DOMICILE" jdbcType="VARCHAR"/>
            <result property="productionAddress" column="PRODUCTION_ADDRESS" jdbcType="VARCHAR"/>
            <result property="foodCategory" column="FOOD_CATEGORY" jdbcType="VARCHAR"/>
            <result property="licensingAuthority" column="LICENSING_AUTHORITY" jdbcType="VARCHAR"/>
            <result property="licensingAuthorityCode" column="LICENSING_AUTHORITY_CODE" jdbcType="VARCHAR"/>
            <result property="issuanceDate" column="ISSUANCE_DATE" jdbcType="DATE"/>
            <result property="expirationDate" column="EXPIRATION_DATE" jdbcType="DATE"/>
            <result property="useElectronicLicense" column="USE_ELECTRONIC_LICENSE" jdbcType="CHAR"/>
            <result property="acceptanceTime" column="ACCEPTANCE_TIME" jdbcType="DATE"/>
            <result property="licenseStatus" column="LICENSE_STATUS" jdbcType="CHAR"/>
            <result property="permitType" column="PERMIT_TYPE" jdbcType="CHAR"/>
            <result property="cancellationReason" column="CANCELLATION_REASON" jdbcType="VARCHAR"/>
            <result property="cancellationDate" column="CANCELLATION_DATE" jdbcType="DATE"/>
            <result property="originalLicenseNo" column="ORIGINAL_LICENSE_NO" jdbcType="VARCHAR"/>
            <result property="informCommitment" column="INFORM_COMMITMENT" jdbcType="CHAR"/>
            <result property="informPromisedFoodCategory" column="INFORM_PROMISED_FOOD_CATEGORY" jdbcType="VARCHAR"/>
            <result property="dailySupervisionOrganization" column="DAILY_SUPERVISION_ORGANIZATION" jdbcType="VARCHAR"/>
            <result property="dailysuperorgDivisonCode" column="DAILYSUPERORG_DIVISON_CODE" jdbcType="VARCHAR"/>
            <result property="dailySupervisor" column="DAILY_SUPERVISOR" jdbcType="VARCHAR"/>
            <result property="complaintHotline" column="COMPLAINT_HOTLINE" jdbcType="VARCHAR"/>
            <result property="signer" column="SIGNER" jdbcType="VARCHAR"/>
            <result property="warehouseAddress" column="WAREHOUSE_ADDRESS" jdbcType="VARCHAR"/>
            <result property="recordDate" column="RECORD_DATE" jdbcType="DATE"/>
            <result property="infoshareFid" column="INFOSHARE_FID" jdbcType="VARCHAR"/>
            <result property="infosharTime" column="INFOSHAR_TIME" jdbcType="TIMESTAMP"/>
            <result property="infoshareTime1" column="INFOSHARE_TIME1" jdbcType="TIMESTAMP"/>
            <result property="infoshareTime2" column="INFOSHARE_TIME2" jdbcType="TIMESTAMP"/>
            <result property="infoshareTime3" column="INFOSHARE_TIME3" jdbcType="TIMESTAMP"/>
            <result property="infoshareStat" column="INFOSHARE_STAT" jdbcType="VARCHAR"/>
            <result property="infoshareDtsource" column="INFOSHARE_DTSOURCE" jdbcType="VARCHAR"/>
            <result property="infoshareDtarea" column="INFOSHARE_DTAREA" jdbcType="VARCHAR"/>
            <result property="infoshareVer" column="INFOSHARE_VER" jdbcType="VARCHAR"/>
            <result property="infosharApp" column="INFOSHAR_APP" jdbcType="VARCHAR"/>
            <result property="seqGloballyUserUnique" column="SEQ_GLOBALLY_USER_UNIQUE______" jdbcType="VARCHAR"/>
            <result property="sourceSystem" column="SOURCE_SYSTEM" jdbcType="VARCHAR"/>
            <result property="licenseStatusNew" column="LICENSE_STATUS_NEW" jdbcType="VARCHAR"/>
            <result property="ifZhuxiao" column="IF_ZHUXIAO" jdbcType="VARCHAR"/>
            <result property="iTime" column="I_TIME" jdbcType="TIMESTAMP"/>
            <result property="uniCode" column="uni_code" jdbcType="VARCHAR"/>
    </resultMap>

    <sql id="Base_Column_List">
        ID,INFOSHAR_ID,PRODUCER_NAME,
        LEGAL_PERSON,PERMIT_NO,SOCIAL_CREDIT_CODE,
        DIVISON_CODE,DOMICILE,PRODUCTION_ADDRESS,
        FOOD_CATEGORY,LICENSING_AUTHORITY,LICENSING_AUTHORITY_CODE,
        ISSUANCE_DATE,EXPIRATION_DATE,USE_ELECTRONIC_LICENSE,
        ACCEPTANCE_TIME,LICENSE_STATUS,PERMIT_TYPE,
        CANCELLATION_REASON,CANCELLATION_DATE,ORIGINAL_LICENSE_NO,
        INFORM_COMMITMENT,INFORM_PROMISED_FOOD_CATEGORY,DAILY_SUPERVISION_ORGANIZATION,
        DAILYSUPERORG_DIVISON_CODE,DAILY_SUPERVISOR,COMPLAINT_HOTLINE,
        SIGNER,WAREHOUSE_ADDRESS,RECORD_DATE,
        INFOSHARE_FID,INFOSHAR_TIME,INFOSHARE_TIME1,
        INFOSHARE_TIME2,INFOSHARE_TIME3,INFOSHARE_STAT,
        INFOSHARE_DTSOURCE,INFOSHARE_DTAREA,INFOSHARE_VER,
        INFOSHAR_APP,SEQ_GLOBALLY_USER_UNIQUE______,SOURCE_SYSTEM,
        LICENSE_STATUS_NEW,IF_ZHUXIAO,I_TIME,
        uni_code,QR_CODE
    </sql>
</mapper>
