<?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.zhentao.mapper.UserProfileMapper">

    <resultMap id="BaseResultMap" type="com.zhentao.pojo.UserProfile">
            <id property="profileId" column="profile_id" jdbcType="INTEGER"/>
            <result property="userId" column="user_id" jdbcType="INTEGER"/>
            <result property="house" column="house" jdbcType="TINYINT"/>
            <result property="car" column="car" jdbcType="TINYINT"/>
            <result property="height" column="height" jdbcType="INTEGER"/>
            <result property="weight" column="weight" jdbcType="INTEGER"/>
            <result property="star" column="star" jdbcType="VARCHAR"/>
            <result property="animal" column="animal" jdbcType="VARCHAR"/>
            <result property="realName" column="real_name" jdbcType="VARCHAR"/>
            <result property="idCard" column="id_card" jdbcType="VARCHAR"/>
            <result property="educationLevel" column="education_level" jdbcType="TINYINT"/>
            <result property="hobby" column="hobby" jdbcType="OTHER"/>
            <result property="schoolName" column="school_name" jdbcType="VARCHAR"/>
            <result property="company" column="company" jdbcType="VARCHAR"/>
            <result property="salaryRange" column="salary_range" jdbcType="TINYINT"/>
            <result property="jobTitle" column="job_title" jdbcType="VARCHAR"/>
            <result property="maritalStatus" column="marital_status" jdbcType="TINYINT"/>
            <result property="isRealNameVerified" column="is_real_name_verified" jdbcType="TINYINT"/>
            <result property="isEducationVerified" column="is_education_verified" jdbcType="TINYINT"/>
            <result property="isWorkVerified" column="is_work_verified" jdbcType="TINYINT"/>
            <result property="isMaritalVerified" column="is_marital_verified" jdbcType="TINYINT"/>
            <result property="verifiedAt" column="verified_at" jdbcType="TIMESTAMP"/>
            <result property="provinceId" column="province_id" jdbcType="INTEGER"/>
            <result property="cityId" column="city_id" jdbcType="INTEGER"/>
            <result property="areaId" column="area_id" jdbcType="INTEGER"/>
            <result property="privacySalary" column="privacy_salary" jdbcType="TINYINT"/>
            <result property="privacyPhone" column="privacy_phone" jdbcType="TINYINT"/>
            <result property="authenticityScore" column="authenticity_score" jdbcType="TINYINT"/>
    </resultMap>

    <sql id="Base_Column_List">
        profile_id,user_id,house,
        car,height,weight,
        star,animal,real_name,
        id_card,education_level,hobby,
        school_name,company,salary_range,
        job_title,marital_status,is_real_name_verified,
        is_education_verified,is_work_verified,is_marital_verified,
        verified_at,province_id,city_id,
        area_id,privacy_salary,privacy_phone,
        authenticity_score
    </sql>
</mapper>
