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

package com.cyksj.model.views;

import com.ejlchina.searcher.bean.DbField;
import com.ejlchina.searcher.bean.SearchBean;
import com.fasterxml.jackson.annotation.JsonIgnore;
import lombok.Getter;
import lombok.Setter;

/*
 *项目名: netflix
 *文件名: QuestionnaireView
 *创建者: JavaZou
 *创建时间:2023/6/13 11:13
 */
@Getter
@Setter
@SearchBean(tables = "form_template fd left join form_fields ff on ff.template_id = fd.id",
		where = "fd.deleted is true,ff.deleted is true")
public class QuestionnaireView {

	@DbField("fd.promotion_id")
	private Long promotionId;

	@DbField("ff.id")
	private Long fieldsId;

	@DbField("ff.fields_name")
	private String fieldsName;

	@DbField("ff.data_type")
	private Integer dataType;

	@DbField("ff.fields_entry_type")
	private Integer FieldsEntryType;

	@DbField("ff.max_length")
	private Integer maxLength;

	@DbField("ff.show_table")
	private Integer showTable;

	@DbField("ff.sorted")
	@JsonIgnore
	private Integer sorted;
}