yhlxj/netflix-dao/src/main/java/com/cyksj/model/views/CouponAvailableRecommendView.java

package com.cyksj.model.views;

import com.cyksj.model.entity.Coupon;
import com.ejlchina.searcher.bean.DbField;
import com.ejlchina.searcher.bean.SearchBean;
import lombok.Getter;
import lombok.Setter;

/*
 *项目名: netflix
 *文件名: CouponAvailableRecommenView
 *创建者: JavaZou
 *创建时间:2022/11/18 15:19
 */
@Setter
@Getter
@SearchBean(tables = "coupon_recommend cr left join coupon c on c.id = cr.coupon_id" +
		" left join coupon_user cu on cu.coupon_id = c.id",
		where = "cr.deleted is true and c.deleted is true")
public class CouponAvailableRecommendView {
	@DbField("cr.id")
	private Long recommendId;

	@DbField("c.id")
	private Long couponId;

	@DbField("c.scope")
	private Coupon.Scope scope;

	@DbField("cu.coupon_id")
	private Long userCouponId;

	@DbField("cu.user_id")
	private Long userId;
}