<?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.springblade.etl.mapper.EtlMvAttStBaseMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="stBaseEntityResultMap" type="org.springblade.etl.entity.EtlMvAttStBaseEntity">
        <result column="ST_CODE" property="stCode"/>
        <result column="ST_NAME" property="stName"/>
        <result column="AD_CODE" property="adCode"/>
        <result column="AD_NAME" property="adName"/>
        <result column="ST_TYPE" property="stType"/>
        <result column="ST_LONG" property="stLong"/>
        <result column="ST_LAT" property="stLat"/>
        <result column="ST_SITE" property="stSite"/>
        <result column="RV_CODE" property="rvCode"/>
        <result column="RV_NAME" property="rvName"/>
        <result column="IS_RAIN" property="isRain"/>
        <result column="IS_RIVER" property="isRiver"/>
        <result column="IS_RES" property="isRes"/>
        <result column="RAIN_ST_TYPE" property="rainStType"/>
    </resultMap>

    <!--SELECT_ZHSL_USER.MV_ATT_ST_BASE d-->
    <select id="selectList" resultMap="stBaseEntityResultMap">
        SELECT
        d.*
        FROM
        SELECT_ZHSL_USER.MV_ATT_ST_BASE d
        WHERE 1=1
        order  by d.ST_CODE
    </select>
</mapper>
