<?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.younike.service.mapper.OrderGoodsMapper">

    <resultMap type="com.younike.service.pojo.OrderGoods" id="OrderGoodsResult">
        <result property="orderGoodsId" column="order_goods_id"/>
        <result property="orderId" column="order_id"/>
        <result property="orderIndex" column="order_index"/>
        <result property="appMemberId" column="app_member_id"/>
        <result property="goodsId" column="goods_id"/>
        <result property="goodsName" column="goods_name"/>
        <result property="retailPrice" column="retail_price"/>
        <result property="salePrice" column="sale_price"/>
        <result property="maxBuyQtyPerPerson" column="max_buy_qty_per_person"/>
        <result property="maxUseQtyPerOrder" column="max_use_qty_per_order"/>
        <result property="validFrom" column="valid_from"/>
        <result property="validUntil" column="valid_until"/>
        <result property="isHolidayRestricted" column="is_holiday_restricted"/>
        <result property="validScope" column="valid_scope"/>
        <result property="commonRules" column="common_rules"/>
        <result property="delFlag" column="del_flag"/>
        <result property="createdBy" column="created_by"/>
        <result property="createdTime" column="created_time"/>
        <result property="updatedBy" column="updated_by"/>
        <result property="updatedTime" column="updated_time"/>
        <result property="version" column="version"/>
        <result property="remark" column="remark"/>
    </resultMap>




    <sql id="selectOrderGoodsVo">
        select order_goods_id, order_id, order_index, app_member_id, goods_id, goods_name, retail_price, sale_price, max_buy_qty_per_person, max_use_qty_per_order, valid_from, valid_until, is_holiday_restricted, valid_scope, common_rules, del_flag, created_by, created_time, updated_by, updated_time, version, remark from order_goods
    </sql>


</mapper>
