<?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.ruoyi.web.mapper.ProjectsMapper">

    <resultMap id="BaseResultMap" type="com.ruoyi.web.domain.entity.Projects">
        <id property="id" column="id" jdbcType="INTEGER"/>
        <result property="projectName" column="project_name" jdbcType="VARCHAR"/>
        <result property="projectDescription" column="project_description" jdbcType="VARCHAR"/>
        <result property="investmentAmount" column="investment_amount" jdbcType="DECIMAL"/>
        <result property="startDate" column="start_date" jdbcType="DATE"/>
        <result property="estimatedCompletionDate" column="estimated_completion_date" jdbcType="DATE"/>
        <result property="actualCompletionDate" column="actual_completion_date" jdbcType="DATE"/>
        <result property="progress" column="progress" jdbcType="TINYINT"/>
        <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>
        <result property="updateTime" column="update_time" jdbcType="TIMESTAMP"/>
    </resultMap>

    <sql id="Base_Column_List">
        id
        ,project_name,project_description,
        investment_amount,start_date,estimated_completion_date,
        actual_completion_date,progress,create_time,
        update_time
    </sql>
</mapper>
