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

    <resultMap id="BaseResultMap" type="com.zksy.data.domain.po.XcrFoodBusinessLicense">
            <id property="xhCodeId" column="xh_code_id" jdbcType="BIGINT"/>
            <result property="infosharId" column="INFOSHAR_ID" jdbcType="VARCHAR"/>
            <result property="id" column="ID" jdbcType="VARCHAR"/>
            <result property="licNo" column="LIC_NO" jdbcType="CHAR"/>
            <result property="foodOperName" column="FOOD_OPER_NAME" jdbcType="VARCHAR"/>
            <result property="uniscId" column="UNISC_ID" jdbcType="VARCHAR"/>
            <result property="lerep" column="LEREP" jdbcType="VARCHAR"/>
            <result property="economicNature" column="ECONOMIC_NATURE" jdbcType="CHAR"/>
            <result property="dom" column="DOM" jdbcType="VARCHAR"/>
            <result property="pobRegCode" column="POB_REG_CODE" jdbcType="CHAR"/>
            <result property="pob" column="POB" jdbcType="VARCHAR"/>
            <result property="physicalStores" column="PHYSICAL_STORES" jdbcType="CHAR"/>
            <result property="warehouseAddr" column="WAREHOUSE_ADDR" jdbcType="VARCHAR"/>
            <result property="mbtCode" column="MBT_CODE" jdbcType="VARCHAR"/>
            <result property="mbt" column="MBT" jdbcType="VARCHAR"/>
            <result property="networkOperation" column="NETWORK_OPERATION" jdbcType="CHAR"/>
            <result property="centralKitchen" column="CENTRAL_KITCHEN" jdbcType="CHAR"/>
            <result property="groupMealDis" column="GROUP_MEAL_DIS" jdbcType="CHAR"/>
            <result property="businessItemsCode" column="BUSINESS_ITEMS_CODE" jdbcType="VARCHAR"/>
            <result property="businessItems" column="BUSINESS_ITEMS" jdbcType="VARCHAR"/>
            <result property="soof" column="SOOF" jdbcType="VARCHAR"/>
            <result property="pasoof" column="PASOOF" jdbcType="VARCHAR"/>
            <result property="autoVending" column="AUTO_VENDING" jdbcType="CHAR"/>
            <result property="bcfSales" column="BCF_SALES" jdbcType="CHAR"/>
            <result property="selfBrewingPas" column="SELF_BREWING_PAS" jdbcType="CHAR"/>
            <result property="issuingAuthority" column="ISSUING_AUTHORITY" jdbcType="VARCHAR"/>
            <result property="issuingAuthorityCode" column="ISSUING_AUTHORITY_CODE" jdbcType="VARCHAR"/>
            <result property="issueDate" column="ISSUE_DATE" jdbcType="TIMESTAMP"/>
            <result property="valFrom" column="VAL_FROM" jdbcType="CHAR"/>
            <result property="valTo" column="VAL_TO" jdbcType="CHAR"/>
            <result property="updateTime" column="UPDATE_TIME" jdbcType="TIMESTAMP"/>
            <result property="licenseStatus" column="LICENSE_STATUS" jdbcType="CHAR"/>
            <result property="administArea" column="ADMINIST_AREA" jdbcType="CHAR"/>
            <result property="manageOrganization" column="MANAGE_ORGANIZATION" jdbcType="VARCHAR"/>
            <result property="complaintPhone" column="COMPLAINT_PHONE" jdbcType="VARCHAR"/>
            <result property="issuer" column="ISSUER" jdbcType="VARCHAR"/>
            <result property="elecrtonicCertFlag" column="ELECRTONIC_CERT_FLAG" jdbcType="CHAR"/>
            <result property="elecrtonicCertName" column="ELECRTONIC_CERT_NAME" jdbcType="VARCHAR"/>
            <result property="datebaseTime" column="DATEBASE_TIME" jdbcType="TIMESTAMP"/>
            <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="businessArea" column="business_area" jdbcType="VARCHAR"/>
            <result property="saleMethod" column="sale_method" 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">
        xh_code_id,INFOSHAR_ID,ID,
        LIC_NO,FOOD_OPER_NAME,UNISC_ID,
        LEREP,ECONOMIC_NATURE,DOM,
        POB_REG_CODE,POB,PHYSICAL_STORES,
        WAREHOUSE_ADDR,MBT_CODE,MBT,
        NETWORK_OPERATION,CENTRAL_KITCHEN,GROUP_MEAL_DIS,
        BUSINESS_ITEMS_CODE,BUSINESS_ITEMS,SOOF,
        PASOOF,AUTO_VENDING,BCF_SALES,
        SELF_BREWING_PAS,ISSUING_AUTHORITY,ISSUING_AUTHORITY_CODE,
        ISSUE_DATE,VAL_FROM,VAL_TO,
        UPDATE_TIME,LICENSE_STATUS,ADMINIST_AREA,
        MANAGE_ORGANIZATION,COMPLAINT_PHONE,ISSUER,
        ELECRTONIC_CERT_FLAG,ELECRTONIC_CERT_NAME,DATEBASE_TIME,
        INFOSHARE_FID,INFOSHAR_TIME,INFOSHARE_TIME1,
        INFOSHARE_TIME2,INFOSHARE_TIME3,INFOSHARE_STAT,
        INFOSHARE_DTSOURCE,INFOSHARE_DTAREA,INFOSHARE_VER,
        INFOSHAR_APP,SEQ_GLOBALLY_USER_UNIQUE______,business_area,
        sale_method,IF_ZHUXIAO,I_TIME,
        uni_code
    </sql>
</mapper>
