<?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.shcd.mapper.dredging.DredgingProjectOverviewMapper">

    <resultMap id="BaseResultMap" type="com.shcd.entity.dredging.DredgingProjectOverview">
            <id property="id" column="ID" jdbcType="VARCHAR"/>
            <result property="projectName" column="PRJ_NAME" jdbcType="VARCHAR"/>
            <result property="quantities" column="QUANTITIES" jdbcType="VARCHAR"/>
            <result property="createUser" column="CREATE_USER" jdbcType="VARCHAR"/>
            <result property="createTime" column="CREATE_TIME" jdbcType="TIMESTAMP"/>
            <result property="updateUser" column="UPDATE_USER" jdbcType="VARCHAR"/>
            <result property="updateTime" column="UPDATE_TIME" jdbcType="TIMESTAMP"/>
            <result property="isRemove" column="IS_REMOVE" jdbcType="DECIMAL"/>
            <result property="projectStartTime" column="PROJECT_START_TIME" jdbcType="TIMESTAMP"/>
            <result property="projectEndTime" column="PROJECT_END_TIME" jdbcType="TIMESTAMP"/>
            <result property="investment" column="INVESTMENT" jdbcType="VARCHAR"/>
            <result property="quantitiesSelf" column="QUANTITIES_SELF" jdbcType="VARCHAR"/>
            <result property="year" column="YEAR" jdbcType="VARCHAR"/>
    </resultMap>

    <sql id="Base_Column_List">
        ID,PRJ_NAME,QUANTITIES,
        CREATE_USER,CREATE_TIME,UPDATE_USER,
        UPDATE_TIME,IS_REMOVE,PROJECT_START_TIME,
        PROJECT_END_TIME,INVESTMENT,QUANTITIES_SELF,
        YEAR
    </sql>
</mapper>
