评论表的设计

<?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.lyr.blog3.mapper.manual.CommentVOMapper">
    <resultMap id="commentMap" type="com.lyr.blog3.pojo.vo.CommentVO">
        <association property="comment">
            <id column="id" jdbcType="BIGINT" property="id"/>
            <result column="nickname" jdbcType="VARCHAR" property="nickname"/>
            <result column="at_nickname" jdbcType="VARCHAR" property="atNickname"/>
            <result column="email" jdbcType="VARCHAR" property="email"/>
            <result column="content" jdbcType="VARCHAR" property="content"/>
            <result column="avatar" jdbcType="VARCHAR" property="avatar"/>
            <result column="create_time" jdbcType="TIMESTAMP" property="createTime"/>
            <result column="blog_id" jdbcType="BIGINT" property="blogId"/>
            <result column="parent_comment_id" jdbcType="BIGINT" property="parentCommentId"/>
            <result column="admincomment" jdbcType="INTEGER" property="admincomment"/>
        </association>
        <collection property="replyComment"
                    column="id"
                    select="listChildCommentByParentCommentId" >

        </collection>
    </resultMap>
    <sql id="firstPageInfo">
        id,nickname,content,avatar,create_time,parent_comment_id,admincomment,at_nickname
    </sql>
    <select id="listCommentByBlogId" resultMap="commentMap">
        select  <include refid="firstPageInfo" /> from t_comment where blog_id = #{blogId} and parent_comment_id = -1
    </select>
    <select id="listChildCommentByParentCommentId" resultType="com.lyr.blog3.pojo.po.Comment">
        select  <include refid="firstPageInfo" /> from t_comment where parent_comment_id = #{parentCommentId} limit 20
    </select>

</mapper>