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

package com.cyksj.model.views;

import com.ejlchina.searcher.bean.DbField;
import com.ejlchina.searcher.bean.DbIgnore;
import com.ejlchina.searcher.bean.SearchBean;
import lombok.Getter;
import lombok.Setter;

/*
 *项目名: netflix
 *文件名: CouponDistributePopularizeView
 *创建者: JavaZou
 *创建时间:2022/11/18 10:37
 */
@Getter
@Setter
@SearchBean(tables = "coupon_distribute_popularize cp left join user_distribute ub on ub.id = cp.distribute_id" +
		" left join user u on u.id = ub.user_id",
		where = "cp.deleted is true and cp.is_general is false")
public class CouponDistributePopularizeView {
	@DbField("cp.id")
	private Long id;

	@DbField("u.nickname")
	private String nickname;

	@DbField("u.headimgurl")
	private String headImgUrl;

	@DbField("u.id")
	private Long userId;

	@DbField("cp.coupon_id")
	private Long couponId;

	@DbField("cp.ex_code")
	private String exCode;

	@DbIgnore
	private Integer usedNum;
}